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_del(self):
self.assertEqual([], self.luct_glo.listing())
inst = LucteriosInstance("inst_c", self.path_dir)
inst.add()
self.assertEqual(["inst_c"], self.luct_glo.listing())
inst = LucteriosInstance("inst_d", self.path_dir)
inst.add()
list_res = self.luct_glo.listing()
list_res.sort()
self.assertEqual(["inst_c", "inst_d"], list_res)
inst = LucteriosInstance("inst_c", self.path_dir)
inst.delete()
self.assertEqual(["inst_d"], self.luct_glo.listing())
inst = LucteriosInstance("inst_d", self.path_dir)
inst.delete()
self.assertEqual([], self.luct_glo.listing())
def delete_inst_name(self, instance_name):
inst = LucteriosInstance(instance_name)
inst.delete()
self.refresh()
def delete_inst_name(self, instance_name):
inst = LucteriosInstance(instance_name)
inst.delete()
self.refresh()