def test_mysql():
from openid.store import sqlstore
try:
import MySQLdb
except ImportError:
pass
else:
db_user = '******'
db_passwd = ''
db_name = getTmpDbName()
from MySQLdb.constants import ER
# Change this connect line to use the right user and password
conn = MySQLdb.connect(user=db_user, passwd=db_passwd, host = db_host)
conn.query('CREATE DATABASE %s;' % db_name)
try:
conn.query('USE %s;' % db_name)
# OK, we're in the right environment. Create store and
# create the tables.
store = sqlstore.MySQLStore(conn)
store.createTables()
# At last, we get to run the test.
testStore(store)
finally:
# Remove the database. If you want to do post-mortem on a
# failing test, comment out this line.
conn.query('DROP DATABASE %s;' % db_name)
def test_mysql():
from openid.store import sqlstore
try:
import MySQLdb
except ImportError:
raise unittest.SkipTest("Skipping MySQL store tests. "
"Could not import MySQLdb.")
else:
db_host = os.environ.get("TEST_MYSQL_HOST", "localhost")
db_user = os.environ.get("TEST_MYSQL_USER", "openid_test")
db_passwd = os.environ.get("TEST_MYSQL_PASSWORD", "password")
db_name = getTmpDbName()
from MySQLdb.constants import ER
# Change this connect line to use the right user and password
try:
conn = MySQLdb.connect(user=db_user,
passwd=db_passwd,
host=db_host)
except MySQLdb.OperationalError as why:
if why.args[0] == 2005:
raise unittest.SkipTest(
"Skipping MySQL store test. "
"Cannot connect to server on host %r." % (db_host, ))
else:
raise
conn.query("CREATE DATABASE %s;" % db_name)
try:
conn.query("USE %s;" % db_name)
# OK, we're in the right environment. Create store and
# create the tables.
store = sqlstore.MySQLStore(conn)
store.createTables()
# At last, we get to run the test.
testStore(store)
finally:
# Remove the database. If you want to do post-mortem on a
# failing test, comment out this line.
conn.query("DROP DATABASE %s;" % db_name)
def test_mysql():
# TODO fix
from openid.store import sqlstore
try:
import MySQLdb
except ImportError:
warnings.warn("Could not import MySQLdb. Skipping MySQL store tests.")
pass
else:
db_user = '******'
db_passwd = ''
db_name = getTmpDbName()
from MySQLdb.constants import ER
# Change this connect line to use the right user and password
try:
conn = MySQLdb.connect(user=db_user,
passwd=db_passwd,
host=db_host)
except MySQLdb.OperationalError as why:
if int(why) == 2005:
print(('Skipping MySQL store test (cannot connect '
'to test server on host %r)' % (db_host, )))
return
else:
raise
conn.query('CREATE DATABASE %s;' % db_name)
try:
conn.query('USE %s;' % db_name)
# OK, we're in the right environment. Create store and
# create the tables.
store = sqlstore.MySQLStore(conn)
store.createTables()
# At last, we get to run the test.
testStore(store)
finally:
# Remove the database. If you want to do post-mortem on a
# failing test, comment out this line.
conn.query('DROP DATABASE %s;' % db_name)
