class UserRoles(db.Model): __tablename__ = 'user_roles' id = db.Column(db.Integer(), primary_key=True) user_id = db.Column(db.Integer(), db.ForeignKey('users.id', ondelete='CASCADE')) role_id = db.Column(db.Integer(), db.ForeignKey('roles.id', ondelete='CASCADE'))
class VideoLikes(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) video = db.Column(db.Integer(), db.ForeignKey("videos.id")) ocenio = db.Column(db.Integer(), db.ForeignKey("users.id")) def __repr__(self): return self.id
class KomentariNaVideu(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) komentar = db.Column(db.Text(400), nullable=False) napisano = db.Column(db.DateTime(), nullable=False, default=datetime.datetime.utcnow) video = db.Column(db.Integer(), db.ForeignKey("videos.id")) napisao = db.Column(db.Integer(), db.ForeignKey("users.id")) korisnici = db.relationship('Users', backref=db.backref('napisao', lazy='dynamic')) def __repr__(self): return self.id
class Subscriptions(db.Model): __tablename__ = 'subscriptions' id = db.Column(db.Integer(), primary_key=True) bill_to_customer = db.Column(db.String(50)) reseller = db.Column(db.String(50)) end_customer = db.Column(db.String(50)) offer_name = db.Column(db.String(50)) subscription_id = db.Column(db.String(50)) status = db.Column(db.String(50)) start_date = db.Column(db.DateTime) initial_term = db.Column(db.String(50)) renewal_date = db.Column(db.DateTime) currency = db.Column(db.String(50)) monthly_charge = db.Column(db.String(50)) auto_renewal_term = db.Column(db.String(50)) billing_model = db.Column(db.String(50)) purchase_order_number = db.Column(db.String(50)) weborderid = db.Column(db.String(50)) site_url = db.Column(db.String(50)) customer_success_manager = db.Column(db.String(50)) partner_success_manager = db.Column(db.String(50)) sales_owner = db.Column(db.String(50)) customer_success_manager_email = db.Column(db.String(50)) partner_success_manager_email = db.Column(db.String(50)) sales_owner_email = db.Column(db.String(50)) account_type = db.Column(db.String(50)) days_until_renewal = db.Column(db.String(50))
class Sales_Orders(db.Model): __tablename__ = 'sales_orders' id = db.Column(db.Integer(), primary_key=True) so_number = db.Column(db.String(50)) customer_id = db.Column(db.String(50), db.ForeignKey('customer_ids.customer_id'))
class Customer_Aliases(db.Model): __tablename__ = 'customer_aliases' id = db.Column(db.Integer(), primary_key=True) customer_alias = db.Column(db.String(100)) customer_id = db.Column(db.String(50), db.ForeignKey('customer_ids.customer_id'))
class Archive_Bookings_Repo(db.Model): __tablename__ = 'archive_bookings_repo' id = db.Column(db.Integer(), primary_key=True) fiscal_year = db.Column(db.String(50)) fiscal_quarter_id = db.Column(db.String(50)) fiscal_period_id = db.Column(db.String(50)) sales_level_1 = db.Column(db.String(50)) sales_level_2 = db.Column(db.String(50)) sales_level_3 = db.Column(db.String(50)) sales_level_4 = db.Column(db.String(50)) sales_level_5 = db.Column(db.String(50)) sales_level_6 = db.Column(db.String(50)) sales_agent_name = db.Column(db.String(50)) email_id = db.Column(db.String(50)) erp_sales_order_number = db.Column(db.String(50)) # erp_sales_order_number = db.Column(db.String(50), db.ForeignKey('sales_orders.so_number'), nullable=True) web_order_id = db.Column(db.String(50)) erp_end_customer_name = db.Column(db.String(100)) end_customer_global_ultimate_name = db.Column(db.String(100)) end_customer_global_ultimate_id = db.Column(db.String(50)) tms_level_2_sales_allocated = db.Column(db.String(50)) product_family = db.Column(db.String(50)) bundle_product_id = db.Column(db.String(50)) product_id = db.Column(db.String(50)) tms_sales_allocated_product_bookings_net = db.Column(db.Float) tms_sales_allocated_service_bookings_net = db.Column(db.Float) hash_value = db.Column(db.String(100)) date_added = db.Column(db.DateTime)
class Test_Table(db.Model): __tablename__ = 'test_table' # Use this to specify a default schema/db for this table # __table_args__ = {'schema': 'dev'} # Us this to specify a different bind/sql server for this table # __bind_key__ = 'dev' id = db.Column(db.Integer(), primary_key=True) first_name = db.Column(db.String(40)) last_name = db.Column(db.String(40)) qty_on_hand = db.Column(db.Integer) cost = db.Column(db.Float) date_added = db.Column(db.DateTime) password_hash = db.Column(db.String(128)) @staticmethod def newest(): return Test_Table.query.all() def newest_name(num): return Test_Table.query.order_by(Test_Table.first_name).limit(num) def __repr__(self): return "<name {}: '{} , {}'>".format(self.id, self.pss_name,self.tsa_name)
class Videos(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) naslov = db.Column(db.String(80), nullable=False) podforum = db.Column(db.String(30), nullable=False) objavljeno = db.Column(db.DateTime(), nullable=False, default=lambda: datetime.datetime.utcnow()) slika = db.Column(db.String(255), nullable=False) dl_link = db.Column(db.String(80), nullable=False) objavio = db.Column(db.Integer(), db.ForeignKey("users.id")) url_view = db.Column(db.String(60), nullable=False, unique=True, default=lambda nbytes=16: secrets.token_hex(nbytes)) korisnici = db.relationship('Users', backref=db.backref('objavio', lazy='dynamic')) def __init__(self, naslov, podforum, dl_link, objavio=1): self.naslov = naslov self.podforum = podforum self.dl_link = dl_link self.objavio = objavio self.slika = "" def __repr__(self): return str(self.id) def __str__(self): return str(self.id) def get_time_for_index(podforum): obj = Videos.query.filter(Videos.podforum == podforum).order_by( Videos.id.desc()).first() vreme = (datetime.datetime.utcnow() - obj.objavljeno).total_seconds() return vreme
class Web_Orders(db.Model): __tablename__ = 'web_orders' id = db.Column(db.Integer(), primary_key=True) erp_end_customer_name = db.Column(db.String(100)) offer_name = db.Column(db.String(50)) web_order_id = db.Column(db.String(50)) subscription_id = db.Column(db.String(50))
class Console(db.Model): id = db.Column(db.Integer, primary_key=True) titulo = db.Column(db.String(100)) genero = db.Column(db.String(100)) temporadas = db.Integer(db.Integer) media = db.Float(db.Float) active = db.Integer(db.Integer) def __init__(self, titulo, genero, temporadas, media, active): self.titulo = titulo self.genero = genero self.temporadas = temporadas self.media = media self.active = active def __repr__(self): return 'Console {0}'.format(self.id)
class Role(db.Model): id = db.Column(db.Integer(), primary_key=True) name = db.Column(db.String(80), unique=True) description = db.Column(db.String(255)) def __init__(self, name): self.name = name def __repr__(self): return '<Role {}>'.format(self.name)
class Review(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(100)) rating = db.Column(db.Integer()) body = db.Column(db.String(1000)) def __init__(self, title, rating, body): self.title = title self.rating = rating self.body = body def __repr__(self): return '<Review %d>' % self.id
class JFW_Projects(db.Model): __tablename__ = 'jfw_projects' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(255), nullable=False) address = db.Column(db.String(255), nullable=False) locality = db.Column(db.String(100), nullable=False) ref_number = db.Column(db.Integer()) pa_number = db.Column(db.String(50), nullable=False) ref_client = db.Column(db.Integer(), db.ForeignKey('jfw_clients.id')) status_id = db.Column(db.Integer(), db.ForeignKey('jfw_status.id')) category_id = db.Column(db.Integer(), db.ForeignKey('jfw_categories.id')) date = db.Column(db.Date) content = db.Column(db.Text) published = db.Column(db.String(20)) images = db.relationship('JFW_Images', backref='project', lazy='dynamic') def __repr__(self): return "<{} - {}>".format(self.id, self.name) def __init__(self, name, address, locality, ref_number, pa_number, ref_client, status_id, category_id, date, content): self.name = name self.address = address self.locality = locality self.ref_number = ref_number self.ref_client = ref_client self.pa_number = pa_number self.status_id = status_id self.category_id = category_id self.date = date self.content = content self.published = 'draft'
class JFW_Images(db.Model): __tablename__ = 'jfw_images' id = db.Column(db.Integer, primary_key=True) use = db.Column(db.String(50), nullable=True) project_id = db.Column(db.Integer(), db.ForeignKey('jfw_projects.id')) url = db.Column(db.String(255), nullable=False, index=True) thumbnail = db.Column(db.String(50), nullable=True) def __init__(self, url, use=None, project_id=None, thumbnail=None): self.url = url self.use = use self.project_id = project_id self.thumbnail = thumbnail def __repr__(self): return "<{}>".format(self.url) def __str__(self): return "{}".format(self.url)
class Archive_Services_Repo(db.Model): __tablename__ = 'archive_services_repo' id = db.Column(db.Integer(), primary_key=True) pid = db.Column(db.String(50)) delivery_manager = db.Column(db.String(50)) end_customer = db.Column(db.String(50)) project_department_name = db.Column(db.String(50)) op_pm = db.Column(db.String(50)) color_indicator = db.Column(db.String(50)) delivery_pm = db.Column(db.String(50)) tracking_status = db.Column(db.String(50)) tracking_sub_status = db.Column(db.String(50)) comments = db.Column(db.String(50)) dmc_updates = db.Column(db.String(50)) dmc_act_fcst_end = db.Column(db.String(50)) op_forecast = db.Column(db.String(50)) cost_index = db.Column(db.String(50)) sku = db.Column(db.String(50)) project_name = db.Column(db.String(50)) unit = db.Column(db.String(50)) region = db.Column(db.String(50)) wm_in_op = db.Column(db.String(50)) so = db.Column(db.String(50)) as_approved_cost_budget = db.Column(db.String(50)) as_approved_revenue_budget = db.Column(db.String(50)) actual_total_costs = db.Column(db.String(50)) actual_revenue = db.Column(db.String(50)) status = db.Column(db.String(50)) project_class = db.Column(db.String(50)) project_scheduled_start_date = db.Column(db.DateTime) scheduled_end_date = db.Column(db.DateTime) project_creation_date = db.Column(db.DateTime) project_closed_date = db.Column(db.DateTime) traffic_lights_account_team = db.Column(db.String(50)) tracking_responsible = db.Column(db.String(50)) hash_value = db.Column(db.String(50)) date_added = db.Column(db.DateTime) def __repr__(self): return f"Services for ('{self.pid}' , '{self.end_customer}')"
class Archive_Telemetry_Repo(db.Model): __tablename__ = 'archive_telemetry_repo' id = db.Column(db.Integer(), primary_key=True) # as_of = db.Column(db.DateTime) type = db.Column(db.String(10)) erp_cust_name = db.Column(db.String(100)) erp_cust_id = db.Column(db.String(50)) so_number = db.Column(db.String(50)) sub_id = db.Column(db.String(50)) start_date = db.Column(db.DateTime) name = db.Column(db.String(25)) vrf = db.Column(db.Integer) licensed = db.Column(db.Integer) installed = db.Column(db.Integer) inactive = db.Column(db.Integer) autoupg = db.Column(db.Integer) windows = db.Column(db.Integer) linux = db.Column(db.Integer) aix = db.Column(db.Integer) lightwt = db.Column(db.Integer) legacy = db.Column(db.Integer) deepvis = db.Column(db.Integer) enforce = db.Column(db.Integer) enforce_enabled = db.Column(db.Integer) pid_enabled = db.Column(db.Integer) forensics_enabled = db.Column(db.Integer) inventory = db.Column(db.Integer) anyconnect = db.Column(db.Integer) anyproxy = db.Column(db.Integer) erspan = db.Column(db.Integer) f5 = db.Column(db.Integer) netflow = db.Column(db.Integer) netscaler = db.Column(db.Integer) others = db.Column(db.Integer) hash_value = db.Column(db.String(50)) date_added = db.Column(db.DateTime)
class Archive_Subscriptions_Repo(db.Model): __tablename__ = 'archive_subscriptions_repo' id = db.Column(db.Integer(), primary_key=True) bill_to_customer = db.Column(db.String(50)) reseller = db.Column(db.String(50)) end_customer = db.Column(db.String(50)) offer_name = db.Column(db.String(50)) consumption_health = db.Column(db.String(50)) over_consumed_tf_groups = db.Column(db.String(50)) next_true_forward = db.Column(db.String(50)) subscription_id = db.Column(db.String(50)) status = db.Column(db.String(50)) start_date = db.Column(db.DateTime) initial_term = db.Column(db.String(50)) renewal_date = db.Column(db.DateTime) currency = db.Column(db.String(50)) monthly_charge = db.Column(db.String(50)) auto_renewal_term = db.Column(db.String(50)) billing_model = db.Column(db.String(50)) purchase_order_number = db.Column(db.String(50)) weborderid = db.Column(db.String(50)) site_url = db.Column(db.String(50)) customer_success_manager = db.Column(db.String(50)) partner_success_manager = db.Column(db.String(50)) sales_owner = db.Column(db.String(50)) customer_success_manager_email = db.Column(db.String(50)) partner_success_manager_email = db.Column(db.String(50)) sales_owner_email = db.Column(db.String(50)) account_type = db.Column(db.String(50)) days_until_renewal = db.Column(db.String(50)) recent_milestone_date = db.Column(db.String(50)) tf_order_status = db.Column(db.String(50)) tf_order_date = db.Column(db.String(50)) hash_value = db.Column(db.String(50)) date_added = db.Column(db.DateTime)
class Role(db.Model): id = db.Column(db.Integer(), primary_key=True) name = db.Column(db.String(50), unique=True)
class UserRoles(db.Model): id = db.Column(db.Integer(), primary_key=True) user_id = db.Column(db.Integer(), db.ForeignKey('user.id', ondelete='CASCADE')) role_id = db.Column(db.Integer(), db.ForeignKey('role.id', ondelete='CASCADE'))
class Role(db.Model): __tablename__ = 'roles' id = db.Column(db.Integer(), primary_key=True) name = db.Column(db.String(50), unique=True)