def test_add_read(self):
self.assertEqual([], self.luct_glo.listing())
inst = LucteriosInstance("inst_psql", self.path_dir)
inst.set_database(
"postgresql:name=" + self.data['dbname'] + ",user=puser,password=123456,host=localhost")
inst.add()
self.assertEqual(["inst_psql"], self.luct_glo.listing())
inst = LucteriosInstance("inst_psql", self.path_dir)
inst.read()
self.assertEqual("postgresql", inst.database[0])
self.assertEqual("localhost", inst.database[1]['host'])
self.assertEqual(self._testMethodName, inst.database[1]['name'])
self.assertEqual("123456", inst.database[1]['password'])
self.assertEqual("puser", inst.database[1]['user'])
self.assertEqual("lucterios.standard", inst.appli_name)
self.assertEqual((), inst.modules)
table_list = list(self.run_psql_cmd(
"SELECT tablename FROM pg_catalog.pg_tables WHERE schemaname='public'"))
table_list = table_list[2:-2]
table_list.sort()
self.assertEqual(self.waiting_table, table_list)
inst = LucteriosInstance("inst_psql", self.path_dir)
inst.clear()
table_list = list(self.run_psql_cmd(
"SELECT tablename FROM pg_catalog.pg_tables WHERE schemaname='public'"))
table_list = table_list[2:-2]
self.assertEqual([], table_list)
inst = LucteriosInstance("inst_psql", self.path_dir)
inst.delete()
self.assertEqual([], self.luct_glo.listing())
def test_add_read(self):
self.assertEqual([], self.luct_glo.listing())
inst = LucteriosInstance("inst_mysql", self.path_dir)
inst.set_database(
"mysql:name=testv2,user=myuser,password=123456,host=localhost")
inst.add()
self.assertEqual(["inst_mysql"], self.luct_glo.listing())
inst = LucteriosInstance("inst_mysql", self.path_dir)
inst.read()
self.assertEqual("mysql", inst.database[0])
self.assertEqual("localhost", inst.database[1]['host'])
self.assertEqual("testv2", inst.database[1]['name'])
self.assertEqual("123456", inst.database[1]['password'])
self.assertEqual("myuser", inst.database[1]['user'])
self.assertEqual("lucterios.standard", inst.appli_name)
self.assertEqual((), inst.modules)
table_list = list(self.run_mysql_cmd("use testv2;show tables;"))
if "Tables_in_testv2" in table_list:
table_list.remove("Tables_in_testv2")
table_list.sort()
self.assertEqual(self.waiting_table, table_list)
inst = LucteriosInstance("inst_mysql", self.path_dir)
inst.clear()
table_list = list(self.run_mysql_cmd("use testv2;show tables;"))
self.assertEqual([], table_list)
inst = LucteriosInstance("inst_mysql", self.path_dir)
inst.delete()
self.assertEqual([], self.luct_glo.listing())
def test_add_read(self):
self.assertEqual([], self.luct_glo.listing())
inst = LucteriosInstance("inst_a", self.path_dir)
inst.add()
self.assertEqual(["inst_a"], self.luct_glo.listing())
inst = LucteriosInstance("inst_a", self.path_dir)
inst.read()
self.assertEqual(("sqlite", {}), inst.database)
self.assertEqual("lucterios.standard", inst.appli_name)
self.assertEqual((), inst.modules)
table_list = list(self.run_sqlite_cmd(
"inst_a", "SELECT name FROM sqlite_master WHERE type='table';"))
if "sqlite_sequence" in table_list:
table_list.remove("sqlite_sequence")
table_list.sort()
self.assertEqual(self.waiting_table, table_list)
inst = LucteriosInstance("inst_a", self.path_dir)
inst.clear()
table_list = list(self.run_sqlite_cmd(
"inst_a", "SELECT name FROM sqlite_master WHERE type='table';"))
if "sqlite_sequence" in table_list:
table_list.remove("sqlite_sequence")
table_list.sort()
self.assertEqual([], table_list)
self.assertEqual(["inst_a"], self.luct_glo.listing())
def test_add_read(self):
self.assertEqual([], self.luct_glo.listing())
inst = LucteriosInstance("inst_mysql", self.path_dir)
inst.set_database(
"mysql:name=testv2,user=myuser,password=123456,host=localhost")
inst.add()
self.assertEqual(["inst_mysql"], self.luct_glo.listing())
inst = LucteriosInstance("inst_mysql", self.path_dir)
inst.read()
self.assertEqual("mysql", inst.database[0])
self.assertEqual("localhost", inst.database[1]['host'])
self.assertEqual("testv2", inst.database[1]['name'])
self.assertEqual("123456", inst.database[1]['password'])
self.assertEqual("myuser", inst.database[1]['user'])
self.assertEqual("lucterios.standard", inst.appli_name)
self.assertEqual((), inst.modules)
table_list = list(self.run_mysql_cmd("use testv2;show tables;"))
if "Tables_in_testv2" in table_list:
table_list.remove("Tables_in_testv2")
table_list.sort()
self.assertEqual(self.waiting_table, table_list)
inst = LucteriosInstance("inst_mysql", self.path_dir)
inst.clear()
table_list = list(self.run_mysql_cmd("use testv2;show tables;"))
self.assertEqual([], table_list)
inst = LucteriosInstance("inst_mysql", self.path_dir)
inst.delete()
self.assertEqual([], self.luct_glo.listing())
def test_add_read(self):
self.assertEqual([], self.luct_glo.listing())
inst = LucteriosInstance("inst_psql", self.path_dir)
inst.set_database("postgresql:name=" + self.data['dbname'] +
",user=puser,password=123456,host=localhost")
inst.add()
self.assertEqual(["inst_psql"], self.luct_glo.listing())
inst = LucteriosInstance("inst_psql", self.path_dir)
inst.read()
self.assertEqual("postgresql", inst.database[0])
self.assertEqual("localhost", inst.database[1]['host'])
self.assertEqual(self._testMethodName, inst.database[1]['name'])
self.assertEqual("123456", inst.database[1]['password'])
self.assertEqual("puser", inst.database[1]['user'])
self.assertEqual("lucterios.standard", inst.appli_name)
self.assertEqual((), inst.modules)
table_list = list(
self.run_psql_cmd(
"SELECT tablename FROM pg_catalog.pg_tables WHERE schemaname='public'"
))
table_list = table_list[2:-2]
table_list.sort()
self.assertEqual(self.waiting_table, table_list)
inst = LucteriosInstance("inst_psql", self.path_dir)
inst.clear()
table_list = list(
self.run_psql_cmd(
"SELECT tablename FROM pg_catalog.pg_tables WHERE schemaname='public'"
))
table_list = table_list[2:-2]
self.assertEqual([], table_list)
inst = LucteriosInstance("inst_psql", self.path_dir)
inst.delete()
self.assertEqual([], self.luct_glo.listing())
