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)
