def setUp(self): self.config = testing.setUp() settings = get_appsettings('development.ini') engine = engine_from_config(settings, 'sqlalchemy.') from tof.models import Base DBSession.configure(bind=engine) Base.metadata.create_all(engine)
def setUp(self): self.config = testing.setUp() from sqlalchemy import create_engine engine = create_engine('sqlite://') from tof.models import ( Base, MyModel, ) DBSession.configure(bind=engine) Base.metadata.create_all(engine) with transaction.manager: model = MyModel(name='one', value=55) DBSession.add(model)
def main(argv=sys.argv): if len(argv) != 2: usage(argv) config_uri = argv[1] setup_logging(config_uri) settings = get_appsettings(config_uri) engine = engine_from_config(settings, 'sqlalchemy.') DBSession.configure(bind=engine) Base.metadata.create_all(engine) with transaction.manager: character = Character(name='Jet Black, Flying Soldier', played_by="John", fate_points=11, refresh_rate=11) DBSession.add(character) aspect = Aspect(name='Amazing Jet Pack!') DBSession.add(aspect) skill = Skill(name='Athletics', level=Ladder.superb) DBSession.add(skill) stunt = Stunt(name='The Amazing Jet Pack') DBSession.add(stunt) character = Character(name='Henry White, Gentelman Thief', played_by="Radek", fate_points=10, refresh_rate=3) DBSession.add(character)