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