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_migration(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())
mirg = MigrateFromV1("inst_psql", self.path_dir, "")
mirg.filename = join(
dirname(self.path_dir), 'data', 'archive_demo.bkf')
mirg.restore()
def test_archive(self):
self.assertEqual([], self.luct_glo.listing())
inst = LucteriosInstance("inst_h", self.path_dir)
inst.add()
inst.filename = join(self.path_dir, "inst_h.arc")
self.assertEqual(True, inst.archive())
inst = LucteriosInstance("inst_psql", self.path_dir)
inst.set_database(
"postgresql:name=" + self.data['dbname'] + ",user=puser,password=123456,host=localhost")
inst.add()
inst.filename = join(self.path_dir, "inst_h.arc")
self.assertEqual(True, inst.restore())
def test_archive(self):
self.assertEqual([], self.luct_glo.listing())
inst = LucteriosInstance("inst_g", self.path_dir)
inst.add()
inst.filename = join(self.path_dir, "inst_g.arc")
self.assertEqual(True, inst.archive())
inst = LucteriosInstance("inst_mysql", self.path_dir)
inst.set_database(
"mysql:name=testv2,user=myuser,password=123456,host=localhost")
inst.add()
inst.filename = join(self.path_dir, "inst_g.arc")
self.assertEqual(True, inst.restore())
def add_modif_inst_result(self, result, to_create):
inst = LucteriosInstance(result[0])
inst.set_extra("LANGUAGE_CODE='%s'" % result[5])
inst.set_appli(result[1])
inst.set_module(result[2])
inst.set_database(result[4])
if to_create:
inst.add()
else:
inst.modif()
inst = LucteriosInstance(result[0])
inst.set_extra(result[3])
inst.security()
self.refresh(result[0])
def add_modif_inst_result(self, result, to_create):
inst = LucteriosInstance(result[0])
inst.set_extra("LANGUAGE_CODE=%s" % result[5])
inst.set_appli(result[1])
inst.set_module(result[2])
inst.set_database(result[4])
if to_create:
inst.add()
else:
inst.modif()
inst = LucteriosInstance(result[0])
inst.set_extra(result[3])
inst.security()
self.refresh(result[0])
def test_add_modif(self):
self.assertEqual([], self.luct_glo.listing())
inst = LucteriosInstance("inst_b", self.path_dir)
inst.add()
self.assertEqual(["inst_b"], self.luct_glo.listing())
inst = LucteriosInstance("inst_b", self.path_dir)
inst.set_database("sqlite")
inst.appli_name = "lucterios.standard"
inst.modules = ('lucterios.dummy',)
inst.modif()
inst = LucteriosInstance("inst_b", self.path_dir)
inst.read()
self.assertEqual(("sqlite", {}), inst.database)
self.assertEqual("lucterios.standard", inst.appli_name)
self.assertEqual(('lucterios.dummy',), inst.modules)
inst = LucteriosInstance("inst_b", self.path_dir)
inst.refresh()