def test_old_connection_unix_port(self):
open_ihm_config = OpenHEAConfig()
config_file = """
[database]
superuser = master
superuser_password = password
port = 3307
unix_socket = /home/jenkins/mysql/mysql.sock
"""
open_ihm_config.readfp(io.BytesIO(config_file))
sexpected = {
'host': 'localhost',
'database': 'openheadb',
'user': '******',
'password': '******',
'charset': 'utf8',
'use_unicode': True,
'get_warnings': True,
'unix_socket': '/home/jenkins/mysql/mysql.sock',
}
self.assertEqual(sexpected, open_ihm_config.superuser_dbinfo())
expected = {
'host': 'localhost',
'database': 'openheadb',
'user': '******',
'password': '******',
'charset': 'utf8',
'use_unicode': True,
'get_warnings': True,
'unix_socket': '/home/jenkins/mysql/mysql.sock',
}
self.assertEqual(expected, open_ihm_config.dbinfo())
def test_schema_script_path(self):
open_ihm_config = OpenHEAConfig()
# FIXME: might need to use a regex to make this pass
# on windows?
expected = 'model/scripts'
script_path = open_ihm_config.schema_script_path()
self.assertEqual(expected, script_path[0 - len(expected):])
def test_database_config_issue_38(self):
# this issue was caused by not protecting the
# default values dictionary so it got broken
# after using it for one purpose.
open_ihm_config = OpenHEAConfig()
expected = {
'host': 'localhost',
'database': 'openheadb',
'user': '******',
'password': '******',
'charset': 'utf8',
'use_unicode': True,
'get_warnings': True,
}
self.assertEqual(expected, open_ihm_config.dbinfo())
expected = {
'host': 'localhost',
'database': 'openheadb',
'user': '******',
'password': '',
'charset': 'utf8',
'use_unicode': True,
'get_warnings': True,
}
self.assertEqual(expected, open_ihm_config.superuser_dbinfo())
def __init__(self):
config = OpenHEAConfig()
self.config = config
self.test_dir = os.path.dirname(__file__)
config_file = os.path.join(self.test_dir, '..', 'test_openhea.cfg')
read = config.read(config_file)
if len(read) != 1:
m = 'Need test_openhea.cfg setup with database parameters'
e = unittest.SkipTest(m)
raise e
info = config.dbinfo()
self.database = info['database']
def test_database_config_superuser_dbinfo(self):
open_ihm_config = OpenHEAConfig()
expected = {
'host': 'localhost',
'database': 'openheadb',
'user': '******',
'password': '',
'charset': 'utf8',
'use_unicode': True,
'get_warnings': True,
}
self.assertEqual(expected, open_ihm_config.superuser_dbinfo())
def test_sqlalchemy_config_file(self):
open_ihm_config = OpenHEAConfig()
config_file = """
[database]
superuser = master
superuser_password = password
driver = mysql+mysqlconnector
"""
open_ihm_config.readfp(io.BytesIO(config_file))
expected = 'mysql+mysqlconnector://master:password@localhost/openheadb'
self.assertEqual(expected,
open_ihm_config.sqlalchemy_superuser_connection_string())
def test_database_config(self):
open_ihm_config = OpenHEAConfig()
expected = {
'host': 'localhost',
'database': 'openheadb',
'user': '******',
'password': '******',
'port': 3306,
'superuser': '******',
'superuser_password': '',
}
self.assertEqual(expected, open_ihm_config.database_config())
def test_read_config_file_port_default(self):
open_ihm_config = OpenHEAConfig()
config_file = """
[database]
superuser = master
superuser_password = password
"""
open_ihm_config.readfp(io.BytesIO(config_file))
expected = {
'host': 'localhost',
'database': 'openheadb',
'user': '******',
'password': '******',
'port': 3306,
'superuser': '******',
'superuser_password': '******',
}
self.assertEqual(expected, open_ihm_config.database_config())
def test_sqlalchemy_config(self):
open_ihm_config = OpenHEAConfig()
expected = 'mysql+mysqldb://openhea:hea2012@localhost/openheadb'
self.assertEqual(expected,
open_ihm_config.sqlalchemy_connection_string())
