Peewee - Delete Records

Records can be easily deleted using multiple ways in peewee as shown in example below −

Example - Deleting Record using current Instance

Running delete_instance() method on a model instance delete corresponding row from the mapped table.

main.py

from peewee import *

db = SqliteDatabase('mydatabase.db')

class User (Model):
   name=TextField()
   age=IntegerField()
   class Meta:
      database=db
      db_table='User'
	  
obj=User.get(User.name=="Amar")
obj.delete_instance()
print("Record Deleted.")

Output

Record Deleted.

Example - Deleting Record using delete() method

delete() is a class method defined in model class, which generates DELETE query. Executing it effectively deletes rows from the table.

from peewee import *

db = SqliteDatabase('mydatabase.db')

class User (Model):
   name=TextField()
   age=IntegerField()
   class Meta:
      database=db
      db_table='User'
	  
qry=User.delete().where (User.age==25)
print(qry)
qry.execute()

print("Record Deleted.")

Output

Concerned table in database shows effect of DELETE query as follows −

DELETE FROM "User" WHERE ("User"."age" = 25)
Record Deleted.