B4J Library [B4X] MiniORMUtils

Attachments

  • MiniORMUtils.b4xlib
    14.1 KB · Views: 12
Last edited:

aeric

Expert
Licensed User
Longtime User
Migration from version 1.x
  1. DatabaseConnector is now ORMConnector
  2. ORMConnector requires a ConnectionInfo object to pass as a parameter for initialization.
    B4X:
    Dim Info As ConnectionInfo
    Info.Initialize
    Info.DBType = "SQLite"
    Info.DBFile = "test.db"
  3. Then we can initialize ORMConnector as follow:
    B4X:
    Dim Con As ORMConnector
    Con.Initialize(Info)
  4. Now, to initialize MiniORM, we need to call DBOpen method to return an SQL object from ORMConnector object to first parameter. The second parameter is the database type, "SQLite" or "MySQL". We can use the constant variable SQLITE from MiniORM class.
    B4X:
    Dim DB As MiniORM
    DB.Initialize(Con.DBOpen, DB.SQLITE)
  5. Some methods name have been renamed.
  6. CreateORMColumn and CreateORMColumn2 renamed to CreateColumn and CreateColumn2.
  7. CreateORMFilter renamed to CreateFilter.
  8. CreateORMJoin renamed to CreateJoin.
  9. setRawSQL changed to setStatement
  10. ToString changed to getStatement
  11. Need to specify journal mode for SQLite when use in server. Default is "DELETE".
    B4X:
    Info.JournalMode = "WAL"
  12. When using MySQL, connect to main schema using InitSchema before calling DBExist2 or DBCreate.
  13. AddQuery replaced by AddNonQueryToBatch
  14. BlnAddAfterCreate and BlnAddAfterInsert replaced by setQueryAddToBatch
  15. BlnExecuteAfterCreate and BlnExecuteAfterInsert replaced by setQueryExecute
 
Last edited:

aeric

Expert
Licensed User
Longtime User
Version: 2.10
Size: 14KB

What's New
  1. Fixed bug in setParameters sub for B4J
  2. Replaced Where3 sub with WhereParam and WhereParams
  3. Show logs when ShowExtraLogs = True with LogQuery, LogQuery2 and LogQueryWithArg
 

aeric

Expert
Licensed User
Longtime User
Version: 2.11
Size: 14KB

What's New
  1. Update WhereParam sub to accept mCondition instead of mColumn as first parameter to avoid confusion with WhereParams
 

aeric

Expert
Licensed User
Longtime User
Version: 2.20
Size: 14KB

What's New
  1. Fixed bugs for B4A and B4i
 

aeric

Expert
Licensed User
Longtime User
Version: 2.21
Size: 14KB

What's New
  1. Updated AddParameters sub
  2. Updated ORMConnector Initialize sub for B4A and B4i
  3. Removed ByteConverter from manifest for B4A and B4i
  4. Removed Merge sub
  5. Fixed Find sub
  6. Fixed Find2 sub
  7. Fixed setId sub
  8. Updated Query sub
  9. Added setShowDBUtilsJson sub for B4A and B4i
 

aeric

Expert
Licensed User
Longtime User
Version: 2.30
Size: 14KB

What's New
  1. Added View property
  2. Added ResetParameters sub
  3. Added IfNull sub
  4. Added Create2 sub
  5. Added setSelect2 sub
  6. Added SelectFromView sub
  7. Added SelectFromTable sub
  8. Added ViewExists sub
  9. Added ViewExists2 sub
  10. Updated setSelect sub

Thanks to Support Ticketing System.
Many new functions in DatabaseBuilder class such as IfNull, Create2, setSelect2, SelectFromView, ViewExists and ViewExists2.
 
Top