0.1.14 版本更新了,优化了导包和一些命名。功能更新是 BaseTable
里的 count
方法。
使用例:
表格信息:
id | content | ctime | mtime |
---|---|---|---|
23 | wow | 1660295075469 | <null> |
123 | sasdfasdf | 444 | 555 |
233 | 123456 | 1660295075469 | <null> |
12300 | 345 | <null> | <null> |
34343 | 123123 | 222 | 333 |
from pydantic import BaseModel
from pypadb import table_pool, db_config
class Test(BaseModel):
id: int
content: str
ctime: int = 0
mtime: int = 0
if __name__ == '__main__':
# default connect to 127.0.0.1:3306
db_config \
.set_database('test') \
.set_user('root') \
.set_password('123456') \
.end()
table_pool.init_tables(test=Test)
# COUNT(*)
print(table_pool.test.count())
# COUNT(`mtime`)
print(table_pool.test.count('mtime'))
# COUNT(`mtime`) where
print(table_pool.test.count('mtime', content='wow'))
2022-11-16