def setup():
NORMAL_TITLES = ("CREATE TABLE `Authors` ("
" `Id` INT NOT NULL,"
" `main_name` TEXT,"
" `normal_name` TEXT,"
" `metaphone_name` TEXT,"
" PRIMARY KEY (`Id`)"
") ENGINE= {} CHARSET=utf8mb4")
connector = MariaDb()
storage_engine = get_config("MISC")["storage_engine"]
connector.create_database(DB_NAME)
connector.createTable("dvfds", NORMAL_TITLES.format(storage_engine))
try:
connector.execute_ex(
"CREATE FULLTEXT INDEX main_name_idx ON Authors (main_name)", ())
connector.execute_ex(
"CREATE FULLTEXT INDEX normal_name_idx ON Authors (normal_name)",
())
connector.execute_ex(
"CREATE FULLTEXT INDEX metaphone_name_idx ON Authors (metaphone_name)",
())
except:
print("Index already exists")
connector.close_connection()
def setup():
"""
create database and table structure
:return:
"""
connector = MariaDb()
storage_engine = get_config("MISC")["storage_engine"]
# create database
connector.create_database(DB_NAME)
connector.createTable("dates", DATE_TABLE.format(storage_engine))
connector.createTable("publication year", PUB_YEAR_TABLE.format(storage_engine))
connector.createTable("popular_words", POPULAR.format(storage_engine))
connector.createTable("title_length", TITLE_LENGTH.format(storage_engine))
connector.createTable("popular names", N_POPULAR.format(storage_engine))
connector.createTable("number authors", NUM_AUTHOR.format(storage_engine))
connector.createTable("Authors", AUTHORS.format(storage_engine))
connector.createTable("Normal Titles", NORMAL_TITLES.format(storage_engine))
connector.createTable("Career",CAREER.format(storage_engine))
# create index
try:
connector.execute_ex("CREATE FULLTEXT INDEX title_idx ON normal_title (titles)", ())
except:
print("Index already exists")
connector.close_connection()
def test_create_table(self):
x = MariaDb()
x.create_database(DB_NAME)
x.createTable("test", ("CREATE TABLE `muhz` ("
" `dblp_key` varchar(100) NOT NULL,"
" PRIMARY KEY (`dblp_key`)"
") ENGINE={} CHARSET=utf8mb4"))
x.close_connection()
def setup(TABLE_NAME):
"""
create database and table structure
:return:
"""
connector = MariaDb()
storage_engine = get_config("MISC")["storage_engine"]
# create database
connector.create_database(DB_NAME)
connector.createTable(TABLE_NAME, TITLES.format(TABLE_NAME,storage_engine))
connector.close_connection()
def test_execute_ex(self):
x = MariaDb()
x.create_database(DB_NAME)
x.createTable("test", ("CREATE TABLE `muhz` ("
" `ID` int NOT NULL AUTO_INCREMENT,"
" `dblp_key` varchar(100) NOT NULL,"
" PRIMARY KEY (`ID`)"
") ENGINE={} CHARSET=utf8mb4"))
idx = x.execute_ex("INSERT INTO muhz (dblp_key) VALUES (%s)", ('mi'))
self.assertEqual(idx, 1)
x.close_connection()
def test_create_db(self):
x = MariaDb()
x.create_database(DB_NAME)
x.create_database(DB_NAME)
x.close_connection()
