off basis, you can simply tell peewee to turn off auto_increment during the import: data = load_user_csv() # load up a bunch of data User._meta.auto_increment = False # turn off auto incrementing IDs with Bulk inserts recipe section for more information. Bulk inserts There are a couple of ways you can load lots of data quickly. The naive approach is to simply call Model.create() in a loop: data_source can be modified by setting the SQLITE_MAX_VARIABLE_NUMBER flag. If the data you would like to bulk load is stored in another table, you can also create INSERT queries whose source is a SELECT query. Use

one-off basis, you can simply tell peewee to turn off auto_increment during the import: data = load_user_csv() # load up a bunch of data User._meta.auto_increment = False # turn off auto incrementing IDs with inserts recipe section for more information. 1.8.2 Bulk inserts There are a couple of ways you can load lots of data quickly. The naive approach is to simply call Model.create() in a loop: data_source can be modified by setting the SQLITE_MAX_VARIABLE_NUMBER flag. If the data you would like to bulk load is stored in another table, you can also create INSERT queries whose source is a SELECT query. Use

connection, calls function, and closes upon returning. db.create_tables(MODELS) # Create schema. load_fixture_data(db) DB-API Connection Object To obtain a reference to the underlying DB-API 2.0 connection off basis, you can simply tell peewee to turn off auto_increment during the import: data = load_user_csv() # load up a bunch of data User._meta.auto_increment = False # turn off auto incrementing IDs with to accomplish the above, without resorting to hacks, is to use the Model.insert_many() API: data = load_user_csv() fields = [User.id, User.username] with db.atomic(): User.insert_many(data, fields=fields)

connection, calls function, and closes upon returning. db.create_tables(MODELS) # Create schema. load_fixture_data(db) DB-API Connection Object To obtain a reference to the underlying DB-API 2.0 connection one-off basis, you can simply tell peewee to turn off auto_increment during the import: data = load_user_csv() # load up a bunch of data User._meta.auto_increment = False # turn off auto incrementing IDs with to accomplish the above, without resorting to hacks, is to use the Model.insert_many() API: data = load_user_csv() fields = [User.id, User.username] with db.atomic(): User.insert_many(data, fields=fields)

Schema Creation If you downloaded the SQL file from the PostgreSQL Exercises site, then you can load the data into a PostgreSQL database using the following commands: createdb peewee_test psql -U postgres connection, calls function, and closes upon returning. db.create_tables(MODELS) # Create schema. load_fixture_data(db) DB-API Connection Object To obtain a reference to the underlying DB-API 2.0 connection off basis, you can simply tell peewee to turn off auto_increment during the import: data = load_user_csv() # load up a bunch of data User._meta.auto_increment = False # turn off auto incrementing IDs with

2 Schema Creation If you downloaded the SQL file from the PostgreSQL Exercises site, then you can load the data into a PostgreSQL database using the following commands: createdb peewee_test psql -U postgres connection, calls function, and closes upon returning. db.create_tables(MODELS) # Create schema. load_fixture_data(db) DB-API Connection Object To obtain a reference to the underlying DB-API 2.0 connection one-off basis, you can simply tell peewee to turn off auto_increment during the import: data = load_user_csv() # load up a bunch of data User._meta.auto_increment = False # turn off auto incrementing IDs with

connection, calls function, and closes upon returning. db.create_tables(MODELS) # Create schema. load_fixture_data(db) DB-API Connection Object To obtain a reference to the underlying DB-API 2.0 connection off basis, you can simply tell peewee to turn off auto_increment during the import: data = load_user_csv() # load up a bunch of data User._meta.auto_increment = False # turn off auto incrementing IDs with to accomplish the above, without resorting to hacks, is to use the Model.insert_many() API: data = load_user_csv() fields = [User.id, User.username] with db.atomic(): User.insert_many(data, fields=fields)

connection, calls function, and closes upon returning. db.create_tables(MODELS) # Create schema. load_fixture_data(db) DB-API Connection Object To obtain a reference to the underlying DB-API 2.0 connection one-off basis, you can simply tell peewee to turn off auto_increment during the import: data = load_user_csv() # load up a bunch of data User._meta.auto_increment = False # turn off auto incrementing IDs with the Model.insert_many() API: 1.6. Models and Fields 57 peewee Documentation, Release 3.6.0 data = load_user_csv() fields = [User.id, User.username] with db.atomic(): User.insert_many(data, fields=fields)

Schema Creation If you downloaded the SQL file from the PostgreSQL Exercises site, then you can load the data into a PostgreSQL database using the following commands: createdb peewee_test psql -U postgres connection, calls function, and closes upon returning. db.create_tables(MODELS) # Create schema. load_fixture_data(db) DB-API Connection Object To obtain a reference to the underlying DB-API 2.0 connection off basis, you can simply tell peewee to turn off auto_increment during the import: data = load_user_csv() # load up a bunch of data User._meta.auto_increment = False # turn off auto incrementing IDs with

2 Schema Creation If you downloaded the SQL file from the PostgreSQL Exercises site, then you can load the data into a PostgreSQL database using the following commands: createdb peewee_test psql -U postgres connection, calls function, and closes upon returning. db.create_tables(MODELS) # Create schema. load_fixture_data(db) DB-API Connection Object To obtain a reference to the underlying DB-API 2.0 connection one-off basis, you can simply tell peewee to turn off auto_increment during the import: data = load_user_csv() # load up a bunch of data User._meta.auto_increment = False # turn off auto incrementing IDs with