python dataset用法

import dataset

# 连接到SQLite数据库（如果不存在则创建）
db = dataset.connect('sqlite:///mydatabase.db')

# 获取或创建一个表
table = db['mytable']

# 插入一条记录
table.insert(dict(name='Alice', age=30, gender='female'))

# 查询所有记录
records = table.all()
for record in records:
    print(record)

# 更新一条记录
table.update({'age': 31}, ['name'])

# 删除一条记录
table.delete(name='Alice')

try:
    db = dataset.connect('sqlite:///mydatabase.db')
except Exception as e:
    print(f"Error connecting to database: {e}")

# 创建索引
table.create_index(['name'])

# 分页查询
for page in table.paginate(page_size=10):
    for record in page:
        print(record)

with db.begin():
    try:
        table.insert(dict(name='Bob', age=25, gender='male'))
    except Exception as e:
        print(f"Error during insert: {e}")