Under Documentation
SQLBatis is a tool that inspired by the Mybatis, it provides an easier way to interact with the database through the raw sql.
SQLBatis allows you to migrate, update your database according to the data model you defined in your app.Also, there are several decorators and builtin functions which give you capbility to interact with your database.
Let's try it.
Install SQLBatis with command pip::
pip install sqlbatis
Connect to the DB
from sqlbatis import SQLBatis
db = SQLBatis('sqlite:///:memory:')We have provided the decorator @db.query to execute the raw sql, Here are CRUD examples:
from sqlalchemy import Column, Integer, String
from sqlbatis import SQLBatis, Model
db = SQLBatis('sqlite:///:memory:')
class User(Model):
id = Column(Integer, primary_key=True)
name = Column(String)
full_name = Column(String)
@db.query('INSERT INTO user (name, full_name) VALUS(:name, :full_name)')
def create(name, full_name):
pass
@db.query('SELECT * FROM user')
def query_user():
pass
@db.query('UPDATE user SET name = :name WHERE id = :id')
def update_user(name, id):
pass
@db.query('DELETE FROM user WHERE id = :id')
def delete_user(id):
pass
if __name__ == '__main__':
create('10111000', 'Leo')