-
Notifications
You must be signed in to change notification settings - Fork 11
Expand file tree
/
Copy pathschema.py
More file actions
23 lines (20 loc) · 738 Bytes
/
schema.py
File metadata and controls
23 lines (20 loc) · 738 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
import sqlalchemy
from databases import Database
from sqlalchemy.sql.sqltypes import Boolean
DATABASE_URL = "sqlite:///./login_demo.db"
database = Database(DATABASE_URL)
metadata = sqlalchemy.MetaData()
engine = sqlalchemy.create_engine(
DATABASE_URL, echo = True, connect_args={"check_same_thread": False}
)
users = sqlalchemy.Table(
'users',
metadata,
sqlalchemy.Column("id", sqlalchemy.Integer, primary_key=True,
autoincrement=True),
sqlalchemy.Column("email", sqlalchemy.String, unique=True),
sqlalchemy.Column("password", sqlalchemy.String),
sqlalchemy.Column("is_active", sqlalchemy.Boolean,
server_default=sqlalchemy.sql.expression.false(), nullable=False)
)
metadata.create_all(engine)