class Memory():
__tablename__ = 'memory'
id = Column(Integer, primary_key=True)
model = Column('model', String(32), unique=True)
frequency = Column('frequency', Integer, default=2133)
maker = Column('maker', String(20))
created_on = Column('created_on', Datetime, default=Datetime.now(tz=timezone('America/Montreal')))
class SSD():
__tablename__ = 'ssd'
id = Column(Integer, primary_key=True)
model = Column('model', String(32))
maker = Column('model', String(20))
capacity = Column('capacity', Integer, default=1)
created_on = Column('created_on', Datetime, default=Datetime.now(tz=timezone('America/Montreal')))
class Gpu():
__tablename__ = 'gpu'
id = Column(Integer, primary_key=True)
model = Column('model', String(32))
ram = Column('ram', String(10), default=1)
maker = Column('maker', String(20))
created_on = Column('created_on', Datetime, default=Datetime.now(tz=timezone('America/Montreal')))
class Motherboard():
__tablename__ = 'motherboard'
id = Column(Integer, primary_key=True)
model = Column('model', String(32))
pcie_qty = Column('pcie_qty', Integer, default=1)
sata_qty = Column('sata_qty', Integer, default=1)
fans_qty = Column('fans_qty', Integer, default=1)
created_on = Column('created_on', Datetime, default=Datetime.now(tz=timezone('America/Montreal')))
class Cpu():
__tablename__ = 'cpu'
id = Column(Integer, primary_key=True)
model = Column('model', String(32), unique=True)
frequency = Column('frequency', Float, default=2.0)
nb_cores = Colum('nb_cores', Integer, default=1)
maker = Column('maker', String(20))
created_on = Column('created_on', Datetime, default=Datetime.now(tz=timezone('America/Montreal')))
class Computer():
__tablename__ = 'computer'
id = Column(Integer, primary_key=True)
owner = Column('model', String(50))
hdd_id = Column(Integer, ForeignKey('hdd.id'))
hdd = relationship('HDD', back_populates='computers')
ssd_id = Column(Integer, ForeignKey('sdd.id'))
ssd = relationship('HDD', back_populates='computers')
memory_id = Column(Integer, ForeignKey('memory.id'))
memory = relationship('HDD', back_populates='computers')
motherboard_id = Column(Integer, ForeignKey('motherboard.id'))
motherboard =
cpu_id = Column(Integer, ForeignKey('cpu.id'))
cpu =
gpu_id = Column(Integer, ForeignKey('gpu.id'))
gpu =
created_on = Column('created_on', Datetime, default=Datetime.now(tz=timezone('America/Montreal')))
