Salysali/df-web-development-using-python-3d2c

1from sqlalchemy import (Column,String,Integer,ForeignKey)
2from sqlalchemy.orm import (relationship,backref)
3from sqlalchemy.ext.declarative import declarative_base
4from sqlalchemy import create_engine
5
6Base=declarative_base()
7
8class Owner(Base):
9	__tablename__='owners'
10	id=Column(Integer,primary_key=True)
11	name=Column(String(100),nullable=False)
12	email=Column(String(200),nullable=False)
13	password=Column(String(25),nullable=False)
14
15class Item(Base):
16	__tablename__='items'
17	id=Column(Integer,primary_key=True)
18	brandname=Column(String(100),nullable=False)
19	image=Column(String(500),nullable=False)
20	model=Column(String(100),nullable=False)
21	cost=Column(Integer)
22	description=Column(String(500),nullable=False)
23	owner_id=Column(Integer,ForeignKey('owners.id'))
24	owner=relationship(Owner,backref='items')
25engine=create_engine('sqlite:///mydb.db')
26Base.metadata.create_all(engine)
27