Hi 🙂🖐
In this post, I will share with you How to add update, and delete data in peewee Database Python.
What is peewee
Peewee is a simple and small ORM. It has few (but expressive) concepts, making it easy to learn and intuitive to use.
Install peewee
pip install peewee Create User Model
from peewee import SqliteDatabase, Model, CharField, IntegerField, UUIDField from uuid import uuid4 # create database db = SqliteDatabase('database.db') # create user model class User(Model): name = CharField(max_length=10) age = IntegerField() userId = UUIDField(primary_key=True) class Meta: database = db # connect to db db.connect() # create users table db.create_tables([User]) db.commit() Add new data into table
user = User.create(name = 'test4', age = 10, userId = uuid4()) user.save() Update user name
# Update user data User.update(name = '123456').where( User.userId == '639bbd66-b0e2-4259-b751-1ee2c7edf1d1' ).execute() for user in User.select(): print(user.name, user.userId) Delete user data
User.delete_by_id(pk = '639bbd66-b0e2-4259-b751-1ee2c7edf1d1') Note
pk == primary_key
Delete user by name
User.delete().where(User.name == 'test2').execute() 
Top comments (0)