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()