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