Python資料庫操作Orator-orm

It is inspired by the database part of the Laravel framework, but largely modified to be more pythonic.

參考 PHP排名第一的web架構 Laravel framework

https://orator-orm.com/

pip install orator       

3種查詢方式 代碼實作

# -*- 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)