def setup_mysql_db(request):
if os.environ.get("TRAVIS", False):
# Using Travis-CI - https://travis-ci.org/
password = ""
db_name = "myapp_test"
else:
password = ""
db_name = "cork_functional_test"
uri = "mysql://*****:*****@localhost/%s" % (password, db_name)
mb = SqlAlchemyBackend(uri, initialize=True)
## Purge DB
mb._drop_all_tables()
assert len(mb.roles) == 0
assert len(mb.users) == 0
# Create roles
mb.roles.insert({"role": "special", "level": 200})
mb.roles.insert({"role": "admin", "level": 100})
mb.roles.insert({"role": "editor", "level": 60})
mb.roles.insert({"role": "user", "level": 50})
# Create admin
mb.users.insert(
{
"username": "******",
"email_addr": "*****@*****.**",
"desc": "admin test user",
"role": "admin",
"hash": "cLzRnzbEwehP6ZzTREh3A4MXJyNo+TV8Hs4//EEbPbiDoo+dmNg22f2RJC282aSwgyWv/O6s3h42qrA6iHx8yfw=",
"creation_date": "2012-10-28 20:50:26.286723",
"last_login": "******",
}
)
assert len(mb.roles) == 4
assert len(mb.users) == 1
def fin():
return # TODO: fix
mb._drop_all_tables()
assert len(mb.roles) == 0
assert len(mb.users) == 0
request.addfinalizer(fin)
return mb
def setup_mysql_db(request):
if os.environ.get('TRAVIS', False):
# Using Travis-CI - https://travis-ci.org/
password = ''
db_name = 'myapp_test'
else:
password = ''
db_name = 'cork_functional_test'
uri = "mysql://*****:*****@localhost/%s" % (password, db_name)
mb = SqlAlchemyBackend(uri, initialize=True)
## Purge DB
mb._drop_all_tables()
assert len(mb.roles) == 0
assert len(mb.users) == 0
# Create roles
mb.roles.insert({'role': 'special', 'level': 200})
mb.roles.insert({'role': 'admin', 'level': 100})
mb.roles.insert({'role': 'editor', 'level': 60})
mb.roles.insert({'role': 'user', 'level': 50})
# Create admin
mb.users.insert({
"username": "******",
"email_addr": "*****@*****.**",
"desc": "admin test user",
"role": "admin",
"hash": "cLzRnzbEwehP6ZzTREh3A4MXJyNo+TV8Hs4//EEbPbiDoo+dmNg22f2RJC282aSwgyWv/O6s3h42qrA6iHx8yfw=",
"creation_date": "2012-10-28 20:50:26.286723",
"last_login": "******"
})
assert len(mb.roles) == 4
assert len(mb.users) == 1
def fin():
return # TODO: fix
mb._drop_all_tables()
assert len(mb.roles) == 0
assert len(mb.users) == 0
request.addfinalizer(fin)
return mb
def setup_postgresql_db(request):
if os.environ.get('TRAVIS', False):
# Using Travis-CI - https://travis-ci.org/
db_name = 'myapp_test'
else:
db_name = 'cork_functional_test'
uri = "postgresql+psycopg2://postgres:@/%s" % db_name
mb = SqlAlchemyBackend(uri, initialize=True)
# Purge DB
mb._drop_all_tables()
assert len(mb.roles) == 0
assert len(mb.users) == 0
# Create roles
mb.roles.insert({'role': 'special', 'level': 200})
mb.roles.insert({'role': 'admin', 'level': 100})
mb.roles.insert({'role': 'editor', 'level': 60})
mb.roles.insert({'role': 'user', 'level': 50})
# Create admin
mb.users.insert({
"username": "******",
"email_addr": "*****@*****.**",
"desc": "admin test user",
"role": "admin",
"hash":
"cLzRnzbEwehP6ZzTREh3A4MXJyNo+TV8Hs4//EEbPbiDoo+dmNg22f2RJC282aSwgyWv/O6s3h42qrA6iHx8yfw=",
"creation_date": "2012-10-28 20:50:26.286723",
"last_login": "******"
})
assert len(mb.roles) == 4
assert len(mb.users) == 1
def fin():
mb._drop_all_tables()
assert len(mb.roles) == 0
assert len(mb.users) == 0
request.addfinalizer(fin)
return mb
def setup_sqlalchemy_with_sqlite_in_memory_db(request):
# Setup an SqlAlchemyBackend backend using an in-memory SQLite DB
mb = SqlAlchemyBackend("sqlite:///:memory:", initialize=True)
## Purge DB
mb._drop_all_tables()
assert len(mb.roles) == 0
assert len(mb.users) == 0
# Create roles
mb.roles.insert({"role": "special", "level": 200})
mb.roles.insert({"role": "admin", "level": 100})
mb.roles.insert({"role": "editor", "level": 60})
mb.roles.insert({"role": "user", "level": 50})
# Create admin
mb.users.insert(
{
"username": "******",
"email_addr": "*****@*****.**",
"desc": "admin test user",
"role": "admin",
"hash": "cLzRnzbEwehP6ZzTREh3A4MXJyNo+TV8Hs4//EEbPbiDoo+dmNg22f2RJC282aSwgyWv/O6s3h42qrA6iHx8yfw=",
"creation_date": "2012-10-28 20:50:26.286723",
"last_login": "******",
}
)
assert len(mb.roles) == 4
assert len(mb.users) == 1
def fin():
mb._drop_all_tables()
assert len(mb.roles) == 0
assert len(mb.users) == 0
request.addfinalizer(fin)
return mb
def setup_sqlalchemy_with_sqlite_in_memory_db(request):
# Setup an SqlAlchemyBackend backend using an in-memory SQLite DB
mb = SqlAlchemyBackend('sqlite:///:memory:', initialize=True)
## Purge DB
mb._drop_all_tables()
assert len(mb.roles) == 0
assert len(mb.users) == 0
# Create roles
mb.roles.insert({'role': 'special', 'level': 200})
mb.roles.insert({'role': 'admin', 'level': 100})
mb.roles.insert({'role': 'editor', 'level': 60})
mb.roles.insert({'role': 'user', 'level': 50})
# Create admin
mb.users.insert({
"username": "******",
"email_addr": "*****@*****.**",
"desc": "admin test user",
"role": "admin",
"hash": "cLzRnzbEwehP6ZzTREh3A4MXJyNo+TV8Hs4//EEbPbiDoo+dmNg22f2RJC282aSwgyWv/O6s3h42qrA6iHx8yfw=",
"creation_date": "2012-10-28 20:50:26.286723",
"last_login": "******"
})
assert len(mb.roles) == 4
assert len(mb.users) == 1
def fin():
mb._drop_all_tables()
assert len(mb.roles) == 0
assert len(mb.users) == 0
request.addfinalizer(fin)
return mb
def purge_test_db():
# Purge DB
mb = SqlAlchemyBackend('mysql://*****:*****@localhost/cork_functional_test', initialize=True)
mb._drop_all_tables()
