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_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_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