python基础知识(19)之MYSQL-peewee

最新推荐文章于 2024-03-25 13:00:00 发布

Winyk52

最新推荐文章于 2024-03-25 13:00:00 发布

阅读量231

点赞数

分类专栏： python个人修行文章标签： mysql 数据库

本文链接：https://blog.csdn.net/Winyk52/article/details/128142468

版权

python个人修行专栏收录该内容

28 篇文章 0 订阅

订阅专栏

# 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()