in peewee, there are more than one commands by which, it is possible to add a new record in the table. we have already used save() method of model instance.

rec1=user(name="rajesh", age=21)
rec1.save()

the peewee.model class also has a create() method that creates a new instance and add its data in the table.

user.create(name="kiran", age=19)

in addition to this, model also has insert() as class method that constructs sql insert query object. the execute() method of query object performs adding a row in underlying table.

q = user.insert(name='lata', age=20)
q.execute()

the query object is an equivalent insert query.q.sql() returns the query string.

print (q.sql())
('insert into "user" ("name", "age") values (?, ?)', ['lata', 20])

here is the complete code that demonstrates the use of above ways of inserting record.

from peewee import *
db = sqlitedatabase('mydatabase.db')
class user (model):
   name=textfield()
   age=integerfield()
   class meta:
      database=db
      db_table='user'

db.create_tables([user])
rec1=user(name="rajesh", age=21)
rec1.save()
a=user(name="amar", age=20)
a.save()
user.create(name="kiran", age=19)
q = user.insert(name='lata', age=20)
q.execute()
db.close()

we can verify the result in sqlitestudio gui.

bulk inserts

in order to use multiple rows at once in the table, peewee provides two methods: bulk_create and insert_many.

insert_many()

the insert_many() method generates equivalent insert query, using list of dictionary objects, each having field value pairs of one object.

rows=[{"name":"rajesh", "age":21}, {"name":"amar", "age":20}]
q=user.insert_many(rows)
q.execute()

here too, q.sql() returns the insert query string is obtained as below −

print (q.sql())
('insert into "user" ("name", "age") values (?, ?), (?, ?)', ['rajesh', 21, 'amar', 20])

bulk_create()

this method takes a list argument that contains one or more unsaved instances of the model mapped to a table.

a=user(name="kiran", age=19)
b=user(name='lata', age=20)
user.bulk_create([a,b])

following code uses both approaches to perform bulk insert operation.

from peewee import *
db = sqlitedatabase('mydatabase.db')
class user (model):
   name=textfield()
   age=integerfield()
   class meta:
      database=db
      db_table='user'

db.create_tables([user])
rows=[{"name":"rajesh", "age":21}, {"name":"amar", "age":20}]
q=user.insert_many(rows)
q.execute()
a=user(name="kiran", age=19)
b=user(name='lata', age=20)
user.bulk_create([a,b])
db.close()

Save or share this article