How to use the emmett.orm.Database function in emmett
To help you get started, we’ve selected a few emmett examples, based on popular ways it is used in public projects.
Secure your code as it's written. Use Snyk Code to scan source code in minutes - no build needed - and fix issues immediately.
emmett-framework / emmett / tests / test_migrations.py View on Github 
def test_step_one_no_diff_in_migration(app):
db = Database(app, auto_migrate=False)
db.define_models(StepOneThing)
ops = _make_ops(db)
ops2 = _make_ops(db, ops)
assert len(ops2.as_diffs()) == 0def test_step_three_drop_column(app):
db = Database(app, auto_migrate=False)
db.define_models(StepThreeThingTwo)
ops = _make_ops(db)
db2 = Database(app, auto_migrate=False)
db2.define_models(StepThreeThingThree)
ops2 = _make_ops(db2, ops)
op = ops2.ops[0]
sql = _make_sql(db, op)
assert sql == _step_three_sql_dropdef test_step_one_drop_table(app):
db = Database(app, auto_migrate=False)
db.define_models(StepOneThing)
ops = _make_ops(db)
db2 = Database(app, auto_migrate=False)
db2.define_models()
ops2 = _make_ops(db2, ops)
diffs = ops2.as_diffs()
assert len(diffs) == 1 and diffs[0][0] == "remove_table"
op = ops2.ops[0]
sql = _make_sql(db2, op)
assert sql == _step_one_sql_dropdef test_step_three_create_column(app):
db = Database(app, auto_migrate=False)
db.define_models(StepThreeThingOne)
ops = _make_ops(db)
db2 = Database(app, auto_migrate=False)
db2.define_models(StepThreeThingTwo)
ops2 = _make_ops(db2, ops)
op = ops2.ops[0]
sql = _make_sql(db, op)
assert sql == _step_three_sqldef test_step_one_create_table(app):
db = Database(app, auto_migrate=False)
db.define_models(StepOneThing)
ops = _make_ops(db)
diffs = ops.as_diffs()
assert len(diffs) == 1 and diffs[0][0] == "add_table"
op = ops.ops[0]
sql = _make_sql(db, op)
assert sql == _step_one_sqldef test_step_five_indexes(app):
db = Database(app, auto_migrate=False)
db.define_models(StepFiveThing)
ops = _make_ops(db)
index_ops = ops.ops[1:]
for op in index_ops:
sql = _make_sql(db, op)
assert sql in _step_five_sql_before
db2 = Database(app, auto_migrate=False)
db2.define_models(StepFiveThingEdit)
ops2 = _make_ops(db2, ops)
for op in ops2.ops:
sql = _make_sql(db, op)
assert sql in _step_five_sql_afterdef test_step_five_indexes(app):
db = Database(app, auto_migrate=False)
db.define_models(StepFiveThing)
ops = _make_ops(db)
index_ops = ops.ops[1:]
for op in index_ops:
sql = _make_sql(db, op)
assert sql in _step_five_sql_before
db2 = Database(app, auto_migrate=False)
db2.define_models(StepFiveThingEdit)
ops2 = _make_ops(db2, ops)
for op in ops2.ops:
sql = _make_sql(db, op)
assert sql in _step_five_sql_afterdef test_step_three_drop_column(app):
db = Database(app, auto_migrate=False)
db.define_models(StepThreeThingTwo)
ops = _make_ops(db)
db2 = Database(app, auto_migrate=False)
db2.define_models(StepThreeThingThree)
ops2 = _make_ops(db2, ops)
op = ops2.ops[0]
sql = _make_sql(db, op)
assert sql == _step_three_sql_dropdef test_step_two_create_table(app):
db = Database(app, auto_migrate=False)
db.define_models(StepTwoThing)
ops = _make_ops(db)
op = ops.ops[0]
sql = _make_sql(db, op)
assert sql == _step_two_sqldef db():
app = App(__name__)
db = Database(
app, config=sdict(
uri='sqlite:memory', auto_migrate=True, auto_connect=True))
db.define_models(Register)
return db
Popular emmett functions
- emmett._shortcuts.to_bytes
- emmett.App
- emmett.asgi.handlers.Handler.on_event
- emmett.ctx.current
- emmett.ctx.current._close_
- emmett.ctx.current._init_
- emmett.ctx.current.app
- emmett.datastructures.sdict
- emmett.http.HTTP
- emmett.http.HTTPResponse
- emmett.orm.Database
- emmett.orm.Field
- emmett.orm.helpers.Callback
- emmett.orm.migrations.base.Migration.register_operation
- emmett.orm.migrations.exceptions.MultipleHeads
- emmett.orm.migrations.exceptions.RevisionError
- emmett.orm.migrations.helpers.to_tuple
- emmett.orm.Model
- emmett.url
- emmett.utils.cachedprop