B4i Library [module] DBUtils

Latest version available here: https://www.b4x.com/android/forum/threads/b4x-dbutils-2.81280/

B4i implementation of DBUtils: http://www.b4x.com/android/forum/threads/8475/#content

DBUtils v1.10 - CreateTable now accepts two lists instead of a map for the columns and their types. The reason for this is that maps in B4i do not preserve the order and the order of columns can be important. Note that the updated CreateTable sub can be copied as is to B4A.

 

[little3399]

Hi，
Dbutils seem miss a important function ... ExecuteListView... ?

 

[Erel]

https://www.b4x.com/android/forum/t...ting-internet-connectivity.52615/#post-329526

 

[ivan.tellez]

Hi @Erel , I want to notify a probably "Bug" in the Module.

As you stated in the files and folders, thenon-user generated persistent files should be stored in the DirLibrary, not in the DirDocuments as in the current implementation of DBUtils.

The problem is when you implement some functionality that require user generated files, for example, if you use UIFileSharingEnabled, then, the databases will be accesible to the user.

Is this correct or maybe I misundertood the DirLibrary function?

Thanks

 

[Erel]

You are correct about the difference between DirLibrary and DirDocuments. Which one is more suitable depends on your app requirements. At this point I do not want to change the default folder as it will affect existing apps.

 

[RVP]

Missing ExecuteMapList ?

There is a ExecuteMemoryMap, but it doesn't return maps

Sorry , ExecuteMapList was something I added in B4A.

 

[Erel]

There are no such methods (ExecuteMapList or ExecuteMemoryMap) in DBUtils.

B4A methods are listed here: https://www.b4x.com/android/forum/threads/dbutils-android-databases-are-now-simple.8475/#content

B4i methods are the same except of ExecuteSpinner.

 

[RVP]

Here is the B4I code for ExecuteMapList

'Executes the query and returns a List of Maps with the column names as the keys 
'The keys are lower cased.
'Returns an uninitialized list if no results found.
Sub ExecuteMapList(SQL As SQL, Query As String, StringArgs() As String, Limit As Int) As List ' ******* RVP Added
    Dim rs As ResultSet = SQL.ExecQuery2(Query, StringArgs)
    Log("ExecuteMapList: " & Query)
    Dim TableList As List
    Dim count As Int = 0
   
    Do While rs.NextRow
        If     TableList.IsInitialized = False Then TableList.Initialize
        count = count+1
        If count <= Limit Or Limit = 0 Then
           
            Dim res As Map
            res.Initialize
            Dim values(rs.ColumnCount) As String
            For col = 0 To rs.ColumnCount - 1
                Try
                    res.Put(rs.GetColumnName(col).ToLowerCase, rs.GetString2(col))
                Catch
                    Dim  byt() As Byte: byt  = rs.GetBlob2(col)
                    res.Put(rs.GetColumnName(col).ToLowerCase, BytesToString(byt,0,byt.Length,"UTF8"))
                End Try
            Next
            TableList.Add(res)
        End If
    Loop
    rs.Close
    Return TableList
End Sub

 

[Erel]

V1.10 was uploaded to the first post.

 

[Shalu Samtani]

how about this?

 

[Myr0n]

how about this?

Please provide us more information about your issue like b4i version or what you were doing to try to reproduce the issue.

 

[Erel]

This warning means that the project was created with a newer version of B4i. There might be compatibility issues with older versions of B4i.