B4J Library [B4X] MiniORMUtils

MiniORMUtils
Version: 2.30

---

This library can be use for creating db schema and performing CRUD operations.
It is suitable for Web API Template or any database system.
Currently it supports SQLite and MySQL (B4J).

Project Template:
[B4X] [Project Template] MiniORM

GitHub:
https://github.com/pyhoon/MiniORMUtils-B4X

Older version:
https://www.b4x.com/android/forum/threads/b4x-miniormutils-sql-query-builder.141446/

 

[aeric]

Migration from version 1.x

1. DatabaseConnector is now ORMConnector
2. ORMConnector requires a ConnectionInfo object to pass as a parameter for initialization.
   
   Dim Info As ConnectionInfo
   Info.Initialize
   Info.DBType = "SQLite"
   Info.DBFile = "test.db"
3. Then we can initialize ORMConnector as follow:
   
   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.
   
   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".
    
    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

 

[aeric]

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]

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]

Version: 2.20
Size: 14KB

What's New

1. Fixed bugs for B4A and B4i

 

[aeric]

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]

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.