saiorm

Saiorm is a simple ORM.


Keywords
database, mongodb, mysql, orm, postgresql, sqlite, sqlserver
License
MIT
Install
pip install saiorm==0.0.3

Documentation

saiorm

Saiorm is a lightweight library for accessing database.It will take you have a easy way to use kinds of database with the same syntax,including SQL and NoSQL.

If you want to support other database,just implement like siaorm.PostgreSQL.ChainDB.

like Saiorm.PostgreSQL.CoherentDB and add a few driver code to Saiorm.init.

Documentation

Learn more.

Task

  • [x] Support MySQL, MariaDB
  • [x] Support PostgreSQL
  • [x] Support SQL Server
  • [x] Support SQLite
  • [x] Support MongoDB

Note that MongoDB support select,get,update,insert,insert_many,delete,increase,decrease,where,limit,order_by

TODO

  • NOT TEST:
    • FIX BUG IN USEING OR STATEMENT,CHANGE WHERE PARAM TO LIST INSTEAD OF DICT
    • CHANGE LINIT,USE LIMIT OFFSET
  • SQL database:

    • Transaction:

      BEGIN
      COMMIT
      ROLLBACK
      
    • having

    • join: support FULL OUTER JOIN and FULL JOIN.

    • check auto commit in SQLite

  • MongoDB:

    group
    native function,BETWEEN,IN etc.