class SessionsCategoryModel(db.Model): __tablename__ = 'sessions_category' id = db.Column(db.Integer, primary_key=True) country = db.Column('country', db.String(30)) organicSearch = db.Column('organic_search', db.Integer) direct = db.Column('direct', db.Integer) referral = db.Column('referral', db.Integer) social = db.Column('social', db.Integer) paidSearch = db.Column('paid_search', db.Integer) email = db.Column('email', db.Integer) date = db.Column('date', db.Date) def __init__(self, country, organicSearch, direct, referral, social, paidSearch, email, date): self.country = country self.organicSearch = organicSearch self.direct = direct self.referral = referral self.social = social self.paidSearch = paidSearch self.email = email self.date = date def save_to_db(self): db.session.add(self) db.session.commit()
class EventsModel(db.Model): __tablename__ = 'events' id = db.Column(db.Integer, primary_key=True) country = db.Column('country', db.String(30)) HelloBarEvents = db.Column('hello_bar_events', db.String(30)) date = db.Column('date', db.Date) def __init__(self, country, HelloBarEvents, date): self.country = country self.HelloBarEvents = HelloBarEvents self.date = date def save_to_db(self): db.session.add(self) db.session.commit()
class SessionsModel(db.Model): __tablename__ = 'sessions' id = db.Column(db.Integer, primary_key=True) country = db.Column('country', db.String(30)) totalSessions = db.Column('total', db.String(30)) date = db.Column('date', db.Date) def __init__(self, country, totalSessions, date): self.country = country self.totalSessions = totalSessions self.date = date def save_to_db(self): db.session.add(self) db.session.commit()
class SideBtnModel(db.Model): __tablename__ = 'side_btn' id = db.Column(db.Integer, primary_key=True) recentlyViewedPortfolios = db.Column('recently_viewed_portfolios', db.String(30)) Help = db.Column('Help', db.String(30)) date = db.Column('date', db.Date) def __init__(self, recentlyViewedPortfolios, Help, date): self.recentlyViewedPortfolios = recentlyViewedPortfolios self.Help = Help self.date = date def save_to_db(self): db.session.add(self) db.session.commit()
class DevicesModel(db.Model): __tablename__ = 'devices' id = db.Column(db.Integer, primary_key=True) mobile = db.Column('mobile', db.String(30)) tablet = db.Column('tablet', db.String(30)) desktop = db.Column('desktop', db.String(30)) date = db.Column('date', db.Date) def __init__(self, mobile, tablet, desktop, date): self.mobile = mobile self.tablet = tablet self.desktop = desktop self.date = date def save_to_db(self): db.session.add(self) db.session.commit()
class AgentsModel(db.Model): __tablename__ = 'agents' id = db.Column(db.Integer, primary_key=True) click = db.Column('click', db.String(30)) emailClick = db.Column('email_click', db.String(30)) callClick = db.Column('call_click', db.String(30)) date = db.Column('date', db.Date) def __init__(self, click, emailClick, callClick, date): self.click = click self.emailClick = emailClick self.callClick = callClick self.callClick = callClick self.date = date def save_to_db(self): db.session.add(self) db.session.commit()
class TopConversionsModel(db.Model): __tablename__ = 'top_conversions' id = db.Column(db.Integer, primary_key=True) MobileTablet = db.Column('mobile_tablet', db.String(30)) BounceRate = db.Column('bounce_rate', db.String(30)) ReturningConversions = db.Column('returning_conversions', db.String(30)) UniqueConversions = db.Column('unique_conversions', db.String(30)) SessionDuration = db.Column('session_duration', db.String(30)) date = db.Column('date', db.Date) def __init__(self, MobileTablet, BounceRate, ReturningConversions, UniqueConversions, SessionDuration, date): self.MobileTablet = MobileTablet self.BounceRate = BounceRate self.ReturningConversions = ReturningConversions self.UniqueConversions = UniqueConversions self.SessionDuration = SessionDuration self.date = date def save_to_db(self): db.session.add(self) db.session.commit()
class PortflioModel(db.Model): __tablename__ = 'portfolio' id = db.Column(db.Integer, primary_key=True) PDFDownloads = db.Column('PDF_downloads', db.String(30)) EmailClicks = db.Column('email_clicks', db.String(30)) CallClicks = db.Column('call_clicks', db.String(30)) VideoImageClicks = db.Column('video_Image_Clicks', db.String(30)) date = db.Column('date', db.Date) def __init__(self, PDFDownloads, EmailClicks, CallClicks, VideoImageClicks, date): self.PDFDownloads = PDFDownloads self.EmailClicks = EmailClicks self.CallClicks = CallClicks self.VideoImageClicks = VideoImageClicks self.date = date def save_to_db(self): db.session.add(self) db.session.commit()
class CPCModel(db.Model): __tablename__ = 'cpc' id = db.Column(db.Integer, primary_key=True) google = db.Column('google', db.String(30)) Bingads = db.Column('Bingads', db.String(30)) facebookads = db.Column('facebookads', db.String(30)) Instagram = db.Column('Instagram', db.String(30)) date = db.Column('date', db.Date) def __init__(self, google, Bingads, facebookads, Instagram, date): self.google = google self.Bingads = Bingads self.facebookads = facebookads self.Instagram = Instagram self.date = date def save_to_db(self): db.session.add(self) db.session.commit()