sqobject 使用

# # 连接到 MySQL 数据库

# from sqlobject import connectionForURI, sqlhub



# # 连接到 MySQL 数据库

# conn = connectionForURI("mysql://username:password@localhost/mydatabase")

# sqlhub.processConnection = conn



# # 定义模型类

# from sqlobject import SQLObject, StringCol, IntCol



# 这是表结构
# class Person(SQLObject):

#     first_name = StringCol()

#     last_name = StringCol()

#     age = IntCol()




# # 创建表

# Person.createTable()



# # 插入数据

# person = Person(first_name="John", last_name="Doe", age=30)



# # 查询数据

# people = Person.select()

# for person in people:

#     print(person.first_name, person.last_name, person.age)



# # 更新数据

# person = Person.get(1)  # 获取 ID 为 1 的记录

# person.set(age=31)  # 修改 age 字段的值




# # 删除数据

# person = Person.get(1)  # 获取 ID 为 1 的记录

# person.destroySelf()  # 删除记录



# # 关闭连接

# sqlhub.processConnection.close()