def populate_passwords():
session = DBSession()
password = '******'
with transaction.manager:
for user_id in range(1,6):
pw = Password(user_id, password)
session.add(pw)
def populate_venues():
session = DBSession()
venues = ['Jackie Dole', 'Thirsty Hippo', 'Town Square Park']
with transaction.manager:
for venue in venues:
v = Venue(1, venue, 1)
session.add(v)
def populate_feeds():
session = DBSession()
feeds = [f.split('|') for f in FEEDS]
with transaction.manager:
for name, url in feeds:
f = Feed(name, url)
session.add(f)
def populate_sitetext():
session = DBSession()
try:
with transaction.manager:
page = SiteText("FrontPage", "This is the front page.", type="tutwiki")
session.add(page)
except IntegrityError:
pass
def populate_groups():
session = DBSession()
# I may remove guest group
groups = ['user', 'host', 'admin', 'guest']
with transaction.manager:
for groupname in groups:
group = Group(groupname)
session.add(group)
def populate_usergroups():
session = DBSession()
with transaction.manager:
admins = [(1, 1)] # admin user should be 1
ulist = admins
for gid, uid in ulist:
row = UserGroup(gid, uid)
session.add(row)
def initialize_sql(engine):
DBSession.configure(bind=engine)
Base.metadata.bind = engine
Base.metadata.create_all(engine)
try:
populate()
except IntegrityError:
transaction.abort()
def populate_usergroups():
session = DBSession()
with transaction.manager:
admins = [(1, 1)] # admin user should be 1
ulist = admins
for gid, uid in ulist:
row = UserGroup(gid, uid)
session.add(row)
def populate_batman_venues():
session = DBSession()
venues = ['Wayne Manor', 'Bat Cave', 'City Hall']
with transaction.manager:
u = session.query(User).filter_by(username='******').one()
with transaction.manager:
for v in venues:
vv = Venue(u.id, v, 1)
session.add(vv)
def populate_eventtypes():
session = DBSession()
event_types = ['Musical Performance', 'Monthly Special',
'Weekly Special', 'Live Performance',
"Trader's Market", 'Social Gathering', 'Seminar']
with transaction.manager:
for etype in event_types:
event_type = EventType(etype)
session.add(event_type)
def populate_groups():
session = DBSession()
groups = ['admin', 'editor', 'manager']
for gname in groups:
try:
with transaction.manager:
group = Group(gname)
session.add(group)
except IntegrityError:
pass
def populate_groups():
session = DBSession()
groups = ['admin', 'editor', 'manager']
for gname in groups:
try:
with transaction.manager:
group = Group(gname)
session.add(group)
except IntegrityError:
pass
def populate_usergroups():
session = DBSession()
# I may remove guest group
#groups = ['user', 'host', 'admin', 'guest']
users = [(1,u) for u in range(1,6)]
hosts = [(2,3), (2,4), (2,5), (2,1)]
admins = [(3,1), (3,2)]
all_giduid = users + hosts + admins
with transaction.manager:
for gid, uid in all_giduid:
row = UserGroup(gid, uid)
session.add(row)
def populate_locations():
session = DBSession()
# locations come first
# admin must suppy locations
# since a user has a default audience(location)
# The default location for bootstrapping
# is home base of application
locations = ['Hattiesburg', 'Petal', 'Oak Grove', 'New Orleans', 'Laurel',
'Sumrall']
with transaction.manager:
for location in locations:
a = Audience(location)
session.add(a)
def populate_contacts():
session = DBSession()
contacts = [
('Joseph', 'Rawson', '*****@*****.**', '(601)-297-2819'),
('Greg', 'Prine', '*****@*****.**'),
('Clark', 'Kent', '*****@*****.**'),
('Bruce', 'Wayne', '*****@*****.**'),
('Hattie', 'Hardy', '*****@*****.**')
]
with transaction.manager:
for contact_args in contacts:
contact = Contact(*contact_args)
session.add(contact)
def populate_users():
session = DBSession()
users = [
('umeboshi', 1, 'admin'),
('gpprine', 2, 'admin'),
('superman', 3, 'host'),
('batman', 4, 'host'),
('hubclerk', 5, 'host')
]
with transaction.manager:
for uname, id, role in users:
user = User(uname, id)
user.role = role
user.default_audience_id = 1
session.add(user)
def populate_users(admin_username):
from trumpet.security import encrypt_password
session = DBSession()
with transaction.manager:
users = [admin_username]
# Using id_count to presume
# the user's id, which should work
# when filling an empty database.
id_count = 0
for uname in users:
id_count += 1
user = User(uname)
password = encrypt_password(uname)
session.add(user)
pw = Password(id_count, password)
session.add(pw)
class DBMeta(object):
def __init__(self, user_id=None):
self.session = DBSession()
self.user_id = user_id
def user(self, *args, **kwargs):
return User(self.session, *args, **kwargs)
def datasource(self, *args, **kwargs):
return Ds(self.session, *args, user_id=self.user_id, **kwargs)
def vtable(self, *args, **kwargs):
return VTable(self.session, *args, user_id=self.user_id, **kwargs)
def chart(self, *args, **kwargs):
return Chart(self.session, *args, user_id=self.user_id, **kwargs)
def dashboard(self, *args, **kwargs):
return Dashboard(self.session, *args, user_id=self.user_id, **kwargs)
def commit(self):
return self.session.commit()
def __del__(self):
try:
self.commit()
except Exception, e:
logger.warn(str(e), exc_info=True)
def populate_users(admin_username):
from paella.security import encrypt_password
session = DBSession()
with transaction.manager:
users = [admin_username]
# Using id_count to presume
# the user's id, which should work
# when filling an empty database.
id_count = 0
for uname in users:
id_count += 1
user = User(uname)
password = encrypt_password(uname)
session.add(user)
pw = Password(id_count, password)
session.add(pw)
config = UserConfig(id_count, '')
session.add(config)
def get_or_create(obj, cls, name):
with DBSession.no_autoflush:
# print 'START', obj, get_state(obj), cls, name
# is_pend = is_pending(obj)
#if is_pend: DBSession.expunge(obj)
try:
res = DBSession.query(cls).filter_by(name=name).one()
except NoResultFound:
res = cls(name=name)
# DBSession.add(res)
# DBSession.flush()
# TODO: hier vielleicht nicht jedem Benutzer erlauben, Sprachen/Tags anzulegen
# if is_pend: DBSession.add(obj)
# print 'END', obj, get_state(obj), cls, name
return res
def _populate_():
transaction.begin()
session = DBSession()
session.flush()
transaction.commit()
"""
Module for executing calculation about parameters
Learning Algorithm - 2015 - Subena
"""
from compiler.ast import flatten
import itertools
from sqlalchemy.sql.functions import func
from base import DBSession, logging
import numpy as np
from subena.io.package.model.tables import Criterion, Value, Stats,Alerts
session = DBSession()
criteria = session.query(Criterion).all()
def execute():
logging.info( "\nStart learning parameters..." )
#calcul all proba dependencies according to proba and their parenthood
getProbaForAllMeasures()
def getAlertsFromStats():
"""
Get alerts from calculated stats (see getProbaForAllMeasures)
for each stat if a pattern does not correspond then create an alert
"""
stats = None
def __init__(self, user_id=None):
self.session = DBSession()
self.user_id = user_id
"""
Module for executing calculation about parameters
Learning Algorithm - 2015 - Subena
"""
from compiler.ast import flatten
import itertools
from sqlalchemy.sql.functions import func
from base import DBSession, logging
import numpy as np
from package.model.tables import Criterion, Value, Stats,Alerts
session = DBSession()
criteria = session.query(Criterion).all()
def execute():
logging.info( "\nStart learning parameters..." )
#calcul all proba dependencies according to proba and their parenthood
getProbaForAllMeasures()
def getAlertsFromStats():
"""
Get alerts from calculated stats (see getProbaForAllMeasures)
for each stat if a pattern does not correspond then create an alert
"""
stats = None
