python基础知识(19)之MYSQL-peewee-创新互联

# coding=UTF8
"""
    create time:2022-11-18 15:36:12
    @Author    :wyk
"""

from peewee import *  # 流行的 ORM 框架，实现了对象与数据库表的映射，兼容多种数据库，简单、快速的操作相应数据库， 面向对象！

# 连接数据库
db = MySQLDatabase('wyk',
                   host='localhost',
                   port=3306,
                   user='root',
                   passwd='******',
                   charset='utf8')


# 定义映射类
class Teacher(Model):
    id = AutoField(primary_key=True)
    name = CharField()
    age = IntegerField()

    class Meta:
        database = db


# 创建表
# db.create_tables([Teacher])
# 新增数据
# t1 = Teacher(name='张三', age=22)
# t2 = Teacher(name='李四', age=23)
# t3 = Teacher(name='王五', age=24)
# t1.save()
# t2.save()
# t3.save()

# 查询数据
t = Teacher.get(Teacher.age == 22)  # 单条数据
print('name: {0}'.format(t.name))

ts = Teacher.select()  # 多条数据
for t in ts:
    print('name: {0}, age: {1}'.format(t.name, t.age))

# 修改数据
t2 = Teacher.update({Teacher.name:'张三'}).where(Teacher.id == 1)
t2.execute()

# 删除数据
t3 = Teacher.delete().where(Teacher.id == 3)
t3.execute()

你是否还在寻找稳定的海外服务器提供商？创新互联www.cdcxhl.cn海外机房具备T级流量清洗系统配攻击溯源，准确流量调度确保服务器高可用性，企业级服务器适合批量采购，新人活动首月15元起，快前往官网查看详情吧