Python数据库操作Orator-orm

pip install orator

# -*- coding: utf-8 -*-
from orator import DatabaseManager
import logging
# 开启查询日志，打印sql
logging.basicConfig(level=logging.DEBUG)
config = {
    'mysql': {
        'driver': 'mysql',
        'host': 'localhost',
        'database': 'data',
        'user': 'root',
        'password': '123456',
        'prefix': '',
        'log_queries': True
    }
}
db = DatabaseManager(config)
# query
results = db.select('select * from student where id = %s', [11])
print(results)
# query builder
user = db.table('student').first()
print(user)
# orm
from orator import Model
Model.set_connection_resolver(db)
class Student(Model):
    __table__ = 'student'
user = Student.find(11)
print(user.name)