class Korisnik(db.Model):
__table_args__ = {'extend_existing': True}
id = db.Column(db.Integer, primary_key=True)
email = db.Column(db.String(120), unique=True, nullable=False)
lozinka = db.Column(db.String(60), nullable=False)
racuni = db.relationship('Racun', backref='uplatio', lazy=True)
def __repr__(self):
return f"Korisnik('{self.email}', '{self.lozinka}')"
class Sastojak(db.Model):
__table_args__ = {'extend_existing': True}
id = db.Column(db.Integer, primary_key=True)
naziv = db.Column(db.String(50), unique=True, nullable=False)
jedinica = db.Column(db.String(20), nullable=False)
proizvodi = db.relationship("Sastojci_Proizvoda", back_populates="sastojak")
def __repr__(self):
return f"Sastojak('{self.naziv}', '{self.jedinica}')"
class Zaposleni(db.Model):
__table_args__ = {'extend_existing': True}
id = db.Column(db.Integer, primary_key=True)
ime = db.Column(db.String(30), nullable=False)
prezime = db.Column(db.String(30), nullable=False)
lozinka = db.Column(db.String(60), nullable=False)
JMBG = db.Column(db.String(20), unique=True, nullable=False)
admin = db.Column(db.Boolean, nullable=False, default=False)
racuni = db.relationship('Racun', backref='naplatio', lazy=True)
def __repr__(self):
return f"Zaposleni('{self.ime}', '{self.prezime}', '{self.lozinka}', '{self.JMBG}', '{self.admin}')"
class Proizvod(db.Model):
__table_args__ = {'extend_existing': True}
id = db.Column(db.Integer, primary_key=True)
naziv = db.Column(db.String(50), unique=True, nullable=False)
cena = db.Column(db.Float, nullable=False)
tip = db.Column(db.String(25), nullable=False)
slika = db.Column(db.String(20), nullable=True)
racuni = db.relationship("Stavke_Racuna", back_populates="proizvod")
sastojci = db.relationship("Sastojci_Proizvoda", back_populates="proizvod", cascade="all, delete-orphan")
def __repr__(self):
return f"Proizvod('{self.naziv}', '{self.cena}', '{self.tip}')"
class Racun(db.Model):
__table_args__ = {'extend_existing': True}
id = db.Column(db.Integer, primary_key=True)
sto = db.Column(db.Integer, nullable=False)
public_id = db.Column(db.String(50), unique=True)
datum = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
korisnikID = db.Column(db.Integer, db.ForeignKey('korisnik.id'), nullable=False)
zaposleniID = db.Column(db.Integer, db.ForeignKey('zaposleni.id'), nullable=False)
proizvodi = db.relationship("Stavke_Racuna", back_populates="racun", cascade="all, delete-orphan")
def __repr__(self):
return f"Racun('{self.sto}', '{self.datum}')"