How to create all tables defined in models using peewee

python orm peewee
Alexander.Li picture Alexander.Li · Feb 7, 2014 · Viewed 7.4k times · Source

I define a lot of model classes using peewee. ClassName.create_table() can generate the table,but only one table. How could I create all tables using a single statement?

Answer

coleifer picture coleifer · Feb 7, 2014

Peewee has a helper that will create the tables in the correct order, but you still need to explicitly pass in all the models:

from peewee import *
db = SqliteDatabase(':memory:')
db.create_tables([ModelA, ModelB, ModelC])

Related questions

How to get columns/fields with peewee query?

For a model class User(db.Model, BaseUser): name = CharField() phone = CharField() age = IntegerField() points = IntegerField() and a list of fields, lst = ['phone', 'name', 'points'] Is there a way to get your query to return the fields in lst? I …

Read More
Reconnecting MySQL on timeout

I have a Python program which runs on background for weeks, and does database queries every once in a while. For that, I am using the ORM peewee (version 2.2.1). I am using MySQL as a backend. Lately I've encountered a …

Read More
How to do query with `WHERE value IN list` in the Python Peewee ORM?

I'm using the (awesome) Python Peewee ORM for my Flask project, but I now got stuck trying to do a query with a where value in ['a', 'b', 'c']. I tried doing it as follows: MyModel.select().where(MyModel.sell_…

Read More