diff options
Diffstat (limited to 'app/model.py')
-rw-r--r-- | app/model.py | 161 |
1 files changed, 0 insertions, 161 deletions
diff --git a/app/model.py b/app/model.py deleted file mode 100644 index 1cf59d8..0000000 --- a/app/model.py +++ /dev/null @@ -1,161 +0,0 @@ -# import SQLAlchemy -from flask_sqlalchemy import SQLAlchemy -from datetime import datetime - -db = SQLAlchemy() - - -class Module(db.Model): - name = db.Column( - "Name", db.String(20), unique=True, nullable=False, primary_key=True - ) - description = db.Column("Description", db.String(50), nullable=False) - - def __repr__(self): - return f"<Module {self.name}>" - - -class Customer(db.Model): - primary_key = db.Column("CustomerId", db.Integer, nullable=False, primary_key=True) - name = db.Column("Name", db.String(20), nullable=False) - name_alternative = db.Column("NameAlternative", db.String(20)) - date_time_created = db.Column("DateTimeCreated", db.String(20), nullable=False) - date_time_updated = db.Column("DateTimeUpdated", db.String(20), nullable=False) - code_customer = db.Column("CodeCustomer", db.String(20), unique=True) - code_accounting = db.Column("CodeAccounting", db.String(20), unique=True) - address = db.Column("Address", db.String(20)) - postal_code = db.Column("PostalCode", db.Integer) - city = db.Column("City", db.String(20)) - country = db.Column("Country", db.String(20)) - phone = db.Column("Phone", db.String(20)) - website = db.Column("Website", db.String(20)) - email = db.Column("Email", db.String(20)) - professional_id_1 = db.Column("ProfessionalId1", db.String(20), unique=True) - professional_id_2 = db.Column("ProfessionalId2", db.String(20), unique=True) - tax_id = db.Column("TaxId", db.String(20), unique=True) - payment_terms = db.Column("PaymentTerms", db.String(20), unique=True) - - def __repr__(self): - return f"<Customer {self.name}>" - - -class Product(db.Model): - primary_key = db.Column("ProductId", db.Integer, primary_key=True) - name = db.Column("Name", db.String(20), nullable=False, unique=True) - code_accounting = db.Column("CodeAccounting", db.String(20)) - unit_weight = db.Column("UnitWeight", db.Float) - price_net = db.Column("PriceNet", db.Float) - price_gross = db.Column("PriceGross", db.Float) - tax_rate = db.Column("TaxRate", db.Float) - date_time_created = db.Column( - "DateTimeCreated", - db.String, - default=datetime.now().strftime("%Y-%m-%d %H:%M:%S"), - ) - date_time_updated = db.Column( - "DateTimeUpdated", - db.String, - default=datetime.now().strftime("%Y-%m-%d %H:%M:%S"), - ) - - def __init__( - self, - name, - code_accounting, - unit_weight, - price_net, - price_gross, - tax_rate, - ): - self.name = name - self.code_accounting = code_accounting - self.unit_weight = unit_weight - self.price_net = price_net - self.price_gross = price_gross - self.tax_rate = tax_rate - - def __repr__(self): - return f"<Product {self.name}>" - - -class Log(db.Model): - primary_key = db.Column("LogId", db.Integer, primary_key=True) - target = db.Column("Target", db.String, default="False") - nno3 = db.Column("NNO3", db.Float, default=0) - p = db.Column("P", db.Float, default=0) - k = db.Column("K", db.Float, default=0) - ca = db.Column("Ca", db.Float, default=0) - mg = db.Column("Mg", db.Float, default=0) - s = db.Column("S", db.Float, default=0) - na = db.Column("Na", db.Float, default=0) - cl = db.Column("Cl", db.Float, default=0) - fe = db.Column("Fe", db.Float, default=0) - zn = db.Column("Zn", db.Float, default=0) - b = db.Column("B", db.Float, default=0) - mn = db.Column("Mn", db.Float, default=0) - cu = db.Column("Cu", db.Float, default=0) - mo = db.Column("Mo", db.Float, default=0) - si = db.Column("Si", db.Float, default=0) - nnh4 = db.Column("NNH4", db.Float, default=0) - date_time_created = db.Column( - "DateTimeCreated", - db.String, - default=datetime.now().strftime("%Y-%m-%d %H:%M:%S"), - ) - date_time_updated = db.Column( - "DateTimeUpdated", - db.String, - default=datetime.now().strftime("%Y-%m-%d %H:%M:%S"), - ) - - def __init__( - self, target, nno3, p, k, ca, mg, s, na, cl, fe, zn, b, mn, cu, mo, si, nnh4 - ): - self.target = target - self.nno3 = nno3 - self.p = p - self.k = k - self.ca = ca - self.mg = mg - self.s = s - self.na = na - self.cl = cl - self.fe = fe - self.zn = zn - self.b = b - self.mn = mn - self.cu = cu - self.mo = mo - self.si = si - self.nnh4 = nnh4 - self.date_time_created = datetime.now().strftime("%Y-%m-%d %H:%M:%S") - - def __repr__(self): - return f"<Log from {self.date_time_created} updated {self.date_time_updated}>" - - -# Everything after here is garbage - - -class User(db.Model): - id = db.Column(db.Integer, primary_key=True) - name_first = db.Column(db.String(20), nullable=False) - name_last = db.Column(db.String(20), nullable=False) - email = db.Column(db.String(20), nullable=False) - phone_mobile = db.Column(db.Integer, nullable=False) - phone_alternative = db.Column(db.Integer) - updated = db.Column(db.String) - - def __repr__(self): - return f"<User {self.name_first} {self.name_last}>" - - -class Order(db.Model): # TODO - id = db.Column(db.Integer, primary_key=True) - date = db.Column(db.String(20), nullable=False) - customer = db.Column(db.String(20), nullable=False) - content = db.Column(db.String(10), nullable=False) - updated = db.Column(db.String) - - def __repr__(self): - return f"<Order {self.name} at {self.updated}>" |