def main(argv=sys.argv): if len(argv) != 2: usage(argv) config_uri = argv[1] setup_logging(config_uri) settings = get_appsettings(config_uri, name="main") engine = engine_from_config(settings, "sqlalchemy.") DBSession.configure(bind=engine) Base.metadata.bind = engine from szcz import models Base.metadata.create_all() with transaction.manager: user1 = models.User(email=u"*****@*****.**", given_name=u"Andrew", family_name=u"Mleczko") DBSession.add(user1) user2 = models.User(email=u"*****@*****.**", given_name=u"Jan", family_name=u"Kowalski") DBSession.add(user2) user3 = models.User(email=u"*****@*****.**", given_name=u"Jan", family_name=u"Nowak") DBSession.add(user3) user4 = models.User(email=u"*****@*****.**", given_name=u"Piotr", family_name=u"Krauze") DBSession.add(user4) user5 = models.User(email=u"*****@*****.**", given_name=u"John", family_name=u"Smith") DBSession.add(user5) user6 = models.User(email=u"*****@*****.**", given_name=u"Marco", family_name=u"Rossi") DBSession.add(user6) user7 = models.User(email=u"*****@*****.**", given_name=u"Gustaw", family_name=u"Flawiusz") DBSession.add(user7) user8 = models.User(email=u"*****@*****.**", given_name=u"Roman", family_name=u"Kowalski") DBSession.add(user8) user9 = models.User(email=u"*****@*****.**", given_name=u"Marceli", family_name=u"Szpak") DBSession.add(user9) all_books = DBSession.query(models.Book).all() group1 = models.Group(name=u"Grupa krakowska") for i in range(10): group1.add_book(random.choice(all_books)) group1.add_member(user1, "owner") group1.add_member(user2, "member") group1.add_member(user3, "member") DBSession.add(group1) group2 = models.Group(name=u"Grupa z Ferrary") for i in range(10): group2.add_book(random.choice(all_books)) group2.add_member(user1, "member") group2.add_member(user4, "member") group2.add_member(user5, "member") group2.add_member(user6, "member") group2.add_member(user7, "member") group2.add_member(user8, "member") group2.add_member(user9, "member") DBSession.add(group2) group3 = models.Group(name=u"Grupa Lakoona") group3.add_member(user1, "owner") for i in range(10): group3.add_book(random.choice(all_books)) DBSession.add(group3)