代码拉取完成，页面将自动刷新
ORM Bee in Python!
Bee(BeePy)是Python版的ORM工具(还有Java版的).
Bee in Python url:
https://github.com/automvc/BeePy
Bee in Java url:
https://github.com/automvc/bee
1.框架使用统一的API操作DB；
2.单表查改增删(SUID)；
3.开发人员只需关注框架的面向对象方式SUID API的使用即可；
4.表对应的实体类，可以只使用普通的实体类，不需要添加额外的表结构信息和框架相关信息；
5.可以根据配置信息，指定使用哪种数据库。
6.支持防sql注入；
7.支持原生sql；
8.框架负责管理连接，事务提交、回滚等的实现逻辑；
9.ORM的编码复杂度C(n)是O(1)。
1.5.2
1.5.4(2025·元宵节·LTS版)
3. 调整exception和select_paging
4. 添加PreparedSql支持自定义SQL方式操作DB
5. 更新toUpdateSQL方法
6. select_by_id
7. delete_by_id
8. select_fun
9. count
10. exist
11. create_table
12. index_normal
13. unique
1.6.0(2025·劳动节)
1.6.2(2025·doing)
1.condition支持like/like_left/like_right,in/not in;
eg: condtion.op("num", Op.IN, [1,2]); in可以支持的类型有:list/set/tuple type
2. 更新cache的相关配置:cache_never,cache_forever,cache_modify_syn config
3. 增强分页(LimitOffset)
4. 更新默认的命名类型(默认为不转换OriginalName)
5. 更新condition Expression(delete value3,value4)
在命令行输入以下命令:
pip install ormbee
ORM Bee pypi url:
https://pypi.org/project/ormbee/
in bee.json or bee.properties set dbModuleName
{
"dbname": "SQLite",
"database": "bee.db",
//default support: pymysql,sqlite3,cx_Oracle,psycopg2 (no need set)
"dbModuleName":"sqlite3"
}
#value is: MySql,SQLite,Oracle,
#MySQL config
#bee.db.dbname=MySQL
#bee.db.host =localhost
#bee.db.user =root
#bee.db.password =
#bee.db.database =bee
#bee.db.port=3306
# SQLite
bee.db.dbname=SQLite
bee.db.database =bee.db
can set the db_config info yourself.
# #mysql
dict_config = {
'dbname':'MySQL',
'host': 'localhost', # 数据库主机
'user': 'root', # 替换为您的 MySQL 用户名
'password': '', # 替换为您的 MySQL 密码
'database': 'bee', # 替换为您的数据库名称
'port':3306
}
honeyConfig= HoneyConfig()
honeyConfig.set_db_config_dict(dict_config)
config = {
# 'dbname':'MySQL',
'host': 'localhost', # 数据库主机
'user': 'root', # 替换为您的 MySQL 用户名
'password': '', # 替换为您的 MySQL 密码
'database': 'bee', # 替换为您的数据库名称
'port':3306
}
honeyConfig= HoneyConfig()
honeyConfig.set_dbname("MySQL")
conn = pymysql.connect(**config)
factory=BeeFactory()
factory.set_connection(conn)
class Orders:
id = None
name = None
remark = None
# can ignore
def __repr__(self):
return str(self.__dict__)
# also can use field type as :int
class Orders8:
__tablename__ = "orders"
id:int = None
name:str = None
remark:str = None
def __repr__(self):
return str(self.__dict__)
class Student2:
id = None
name = None
age = None
remark = None
addr = None
def __repr__(self):
return str(self.__dict__)
from bee.api import Suid, SuidRich
from bee.config import PreConfig
from bee.honeyfactory import BF
from bee.osql.bee_enum import Op
if __name__ == "__main__":
# set bee.properties/bee.json config folder
PreConfig.config_path="E:\\Bee-Project\\resources"
# select record
suid = Suid()
orderList = suid.select(Orders()) # select all
# insert
orders = Orders()
orders.id = 1
orders.name = "bee"
orders.remark = "test"
suid = Suid()
suid.insert(orders)
# update/delete
orders = Orders()
orders.name = "bee130"
# For safety reasons
# Fields that are not present in the entity will be ignored.
orders.ext = "aaa"
orders.id = 1
suid = Suid()
n1 = suid.update(orders)
n2 = suid.delete(orders)
print(n1)
print(n2)
# batch insert
student0 = Student2()
student0.name = "bee"
student1 = Student2()
student1.name = "bee1"
student1.addr = ""
student1.age = 40
entity_list = []
entity_list.append(student0)
entity_list.append(student1)
suidRich = SuidRich()
insertNum = suidRich.insert_batch(entity_list)
print(insertNum)
#how to use Condition for advanced query and update
condition = BF.condition()
condition.op("age", Op.ge, 22)
condition.op("remark", Op.eq, None)
stuList = suidRich.select(Student2(), condition)
# select ... from student2 where age >= ? and remark is null
for stu in stuList:
print(stu)
# all stu'age add 1 if id>5
condition = BF.condition()
condition.setAdd("age", 1)
condition.op("id", Op.ge, 5)
updateNum = suidRich.updateBy(Student2(), condition)
# update student2 set age = age + ? where id >= ?
print("updateNum:", updateNum)
#SuidRich: insert_batch,select_first,updateBy
#复杂的where过滤条件、group,having,order by,Update Set等可使用Condition;
主要API在bee.api.py
Suid: simple API for Select/Update/Insert/Delete
SuidRich : select_paging, insert_batch, updateBy, select_first,select_by_id,
delete_by_id,select_fun,count,exist,create_table,index_normal,unique
PreparedSql: select, select_dict, modify, modify_dict
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
1. 开源生态
2. 协作、人、软件
3. 评估模型
马建仓 AI 助手