Esempio n. 1
0
def populate_sitestats(request):
    """fixture used to populate sitestat to test monthly/weekly analytics gathering

        
    """
    site1 = Wifisite.query.filter_by(unifi_id="site1").first()
    now = arrow.now()
    month_start = now.floor("month")
    days = (now.ceil("month") - month_start).days
    for i in range(days):
        day_key = month_start.replace(days=i).floor("day").naive
        daystat = Sitestat(site_id=site1.id, date=day_key)
        daystat.num_visits = 15
        daystat.num_likes = 1
        daystat.num_checkins = 2
        daystat.num_newlogins = 7
        daystat.num_repeats = 3
        daystat.num_emails = 3
        daystat.num_fb = 4
        daystat.num_vouchers = 2
        daystat.num_phones = 1
        db.session.add(daystat)
    db.session.commit()
Esempio n. 2
0
def demo_init():
    with app.app_context():
        from sqlalchemy.exc import OperationalError
        from flask_security.utils import encrypt_password
        from unifispot.models import User
        from unifispot.superadmin.models import Account
        from unifispot.admin.models import Admin
        from unifispot.client.models import Client, Wifisite, Landingpage, Voucherdesign
        from unifispot.guest.models import Guest
        import arrow
        from random import randint
        from unifispot.analytics.models import Sitestat
        from unifispot.base.utils.helper import get_random_integers
        from faker import Factory
        fake = Factory.create()

        try:
            account = Account.query.filter_by(id=1).first()
        except:
            app.logger.debug(
                "No Account table Entry found,could be running migration ")
        else:
            if not account:
                #create default admin user
                enc_pass = encrypt_password('password')
                account = Account()
                db.session.add(account)
                admin_user = Admin(email='*****@*****.**',
                                   password=enc_pass,
                                   displayname="Admin User1",
                                   active=1)
                admin_user2 = Admin(email='*****@*****.**',
                                    password=enc_pass,
                                    displayname="Admin User2",
                                    active=1)
                admin_user3 = Admin(email='*****@*****.**',
                                    password=enc_pass,
                                    displayname="Admin User3",
                                    active=1)
                admin_user.account = account
                admin_user2.account = account
                admin_user3.account = account
                db.session.add(admin_user)
                db.session.add(admin_user2)
                db.session.add(admin_user3)
                client_user1 = Client(email='*****@*****.**',
                                      password=enc_pass,
                                      displayname="client1",
                                      active=1)
                db.session.add(client_user1)
                client_user1.account = account
                site1 = Wifisite(name='Client1 Site1',
                                 unifi_id='site1',
                                 auth_fb_like=1,
                                 timezone="Europe/Copenhagen",
                                 auth_method=AUTH_TYPE_ALL,
                                 smsauth=1)
                db.session.add(site1)
                site1.account = account
                site1.client = client_user1
                landing1 = Landingpage()
                landing1.site = site1
                site1.landingpages.append(landing1)
                db.session.add(landing1)
                db.session.commit()
                site1.default_landing = landing1.id
                design1 = Voucherdesign()
                design1.site = site1
                db.session.add(design1)
                db.session.commit()
                site2 = Wifisite(name='Client1 Site2',
                                 unifi_id='site1',
                                 auth_fb_like=1,
                                 timezone="Europe/Copenhagen",
                                 auth_method=AUTH_TYPE_ALL,
                                 smsauth=1)
                db.session.add(site2)
                site2.account = account
                site2.client = client_user1
                landing2 = Landingpage()
                landing2.site = site2
                site1.landingpages.append(landing2)
                db.session.add(landing2)
                db.session.commit()
                design2 = Voucherdesign()
                design2.site = site2
                db.session.add(design2)
                site1.default_landing = landing2.id
                db.session.commit()
                ##-----------------------Stats for site1
                now = arrow.now()
                month_start = now.floor('month')
                days = (now.ceil('month') - month_start).days
                for i in range(days):
                    day_key = month_start.replace(days=i).floor('day').naive
                    daystat = Sitestat(site_id=site1.id, date=day_key)
                    num_visits = randint(10, 50)
                    num_logins = randint(5, num_visits)
                    num_newlogins = randint(5, num_logins)
                    logins = get_random_integers(4, num_logins)
                    daystat.num_visits = num_visits
                    daystat.num_likes = randint(1, 10)
                    daystat.num_checkins = randint(1, 10)
                    daystat.num_newlogins = num_newlogins
                    daystat.num_repeats = num_logins - num_newlogins
                    daystat.num_emails = logins[0]
                    daystat.num_fb = logins[1]
                    daystat.num_vouchers = logins[2]
                    daystat.num_phones = logins[3]
                    db.session.add(daystat)
                db.session.commit()
                ##-----------------------Stats for site2
                for i in range(days):
                    day_key = month_start.replace(days=i).floor('day').naive
                    daystat = Sitestat(site_id=site2.id, date=day_key)
                    num_visits = randint(10, 50)
                    num_logins = randint(5, num_visits)
                    num_newlogins = randint(5, num_logins)
                    logins = get_random_integers(4, num_logins)
                    daystat.num_visits = num_visits
                    daystat.num_likes = randint(1, 10)
                    daystat.num_checkins = randint(1, 10)
                    daystat.num_newlogins = num_newlogins
                    daystat.num_repeats = num_logins - num_newlogins
                    daystat.num_emails = logins[0]
                    daystat.num_fb = logins[1]
                    daystat.num_vouchers = logins[2]
                    daystat.num_phones = logins[3]
                    db.session.add(daystat)
                db.session.commit()
                ##------------------guests for site1
                for i in range(100):
                    db.session.add(
                        Guest(firstname=fake.first_name(),
                              lastname=fake.last_name(),
                              email=fake.email()))
                db.session.commit()
Esempio n. 3
0
def demo_init():
    with app.app_context():
        from  sqlalchemy.exc import OperationalError    
        from flask_security.utils import encrypt_password
        from unifispot.models import User  
        from unifispot.superadmin.models import Account
        from unifispot.admin.models import Admin       
        from unifispot.client.models import Client,Wifisite,Landingpage 
        from unifispot.guest.models import Guest
        import arrow
        from random import randint 
        from unifispot.analytics.models import Sitestat  
        from unifispot.base.utils.helper import get_random_integers 
        from faker import Factory
        fake = Factory.create()

        try:
            account = Account.query.filter_by(id=1).first()
        except :
            app.logger.debug( "No Account table Entry found,could be running migration ")
        else:
            if not account:
                #create default admin user
                enc_pass        = encrypt_password('password')
                account         = Account()
                db.session.add(account)
                admin_user  = Admin(email='*****@*****.**',password=enc_pass,displayname= "Admin User1",active=1)
                admin_user2 = Admin(email='*****@*****.**',password=enc_pass,displayname= "Admin User2",active=1)
                admin_user3 = Admin(email='*****@*****.**',password=enc_pass,displayname= "Admin User3",active=1)
                admin_user.account = account
                admin_user2.account = account
                admin_user3.account = account
                db.session.add(admin_user)
                db.session.add(admin_user2)
                db.session.add(admin_user3)
                client_user1      = Client(email='*****@*****.**',password=enc_pass,displayname= "client1",active=1)
                db.session.add(client_user1)
                client_user1.account = account
                site1           = Wifisite(name='Client1 Site1',unifi_id='site1',auth_fb_like=1,timezone="Europe/Copenhagen",
                                        auth_method= AUTH_TYPE_ALL,smsauth=1)    
                db.session.add(site1)
                site1.account   = account
                site1.client    = client_user1
                landing1        = Landingpage()   
                landing1.site           = site1
                site1.landingpages.append(landing1) 
                db.session.add(landing1)
                db.session.commit()    
                site1.default_landing = landing1.id                  
                db.session.commit()
                site2           = Wifisite(name='Client1 Site2',unifi_id='site1',auth_fb_like=1,timezone="Europe/Copenhagen",
                                        auth_method= AUTH_TYPE_ALL,smsauth=1)    
                db.session.add(site2)
                site2.account   = account
                site2.client    = client_user1
                landing2        = Landingpage()   
                landing2.site           = site2
                site1.landingpages.append(landing2) 
                db.session.add(landing2)
                db.session.commit()    
                site1.default_landing = landing2.id                  
                db.session.commit()
                ##-----------------------Stats for site1
                now = arrow.now()
                month_start = now.floor('month')
                days        = (now.ceil('month') - month_start).days
                for i in range(days):
                    day_key = month_start.replace(days=i).floor('day').naive
                    daystat = Sitestat(site_id=site1.id,date=day_key)
                    num_visits             = randint(10,50)
                    num_logins             = randint(5,num_visits)
                    num_newlogins          = randint(5,num_logins) 
                    logins                 = get_random_integers(4,num_logins)
                    daystat.num_visits     = num_visits
                    daystat.num_likes      = randint(1,10)
                    daystat.num_checkins   = randint(1,10)
                    daystat.num_newlogins  = num_newlogins
                    daystat.num_repeats    = num_logins - num_newlogins
                    daystat.num_emails     = logins[0]
                    daystat.num_fb         = logins[1]
                    daystat.num_vouchers   = logins[2]
                    daystat.num_phones     = logins[3]
                    db.session.add(daystat)
                db.session.commit()                
                ##-----------------------Stats for site2
                for i in range(days):
                    day_key = month_start.replace(days=i).floor('day').naive
                    daystat = Sitestat(site_id=site2.id,date=day_key)
                    num_visits             = randint(10,50)
                    num_logins             = randint(5,num_visits)
                    num_newlogins          = randint(5,num_logins) 
                    logins                 = get_random_integers(4,num_logins)
                    daystat.num_visits     = num_visits
                    daystat.num_likes      = randint(1,10)
                    daystat.num_checkins   = randint(1,10)
                    daystat.num_newlogins  = num_newlogins
                    daystat.num_repeats    = num_logins - num_newlogins
                    daystat.num_emails     = logins[0]
                    daystat.num_fb         = logins[1]
                    daystat.num_vouchers   = logins[2]
                    daystat.num_phones     = logins[3]
                    db.session.add(daystat)
                db.session.commit()     
                ##------------------guests for site1
                for i in range(100):
                    db.session.add(Guest(firstname=fake.first_name(),lastname=fake.last_name(),email=fake.email()))
                db.session.commit()
Esempio n. 4
0
def populate_sitestats(request):
    '''fixture used to populate sitestat to test monthly/weekly analytics gathering

        
    '''
    site1 = Wifisite.query.filter_by(unifi_id='site1').first()
    now = arrow.now()
    month_start = now.floor('month')
    days = (now.ceil('month') - month_start).days
    for i in range(days):
        day_key = month_start.replace(days=i).floor('day').naive
        daystat = Sitestat(site_id=site1.id, date=day_key)
        daystat.num_visits = 15
        daystat.num_likes = 1
        daystat.num_checkins = 2
        daystat.num_newlogins = 7
        daystat.num_repeats = 3
        daystat.num_emails = 3
        daystat.num_fb = 4
        daystat.num_vouchers = 2
        daystat.num_phones = 1
        db.session.add(daystat)
    db.session.commit()