<commit_before>package com.github.huangzhiyi.shpmdir.db;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.LinkedList;
import java.util.List;

import com.github.huangzhiyi.shpmdir.CityDir;
import com.github.huangzhiyi.shpmdir.CitySet;


public class CityDirDao {

	private static final DBMngr DBMNGR=H2Mngr.instance();
	
	public static void createTable(){
		try{
			Connection conn=DBMNGR.getConnection();
			PreparedStatement stat=conn.prepareStatement("CREATE TABLE IF NOT EXISTS citydir(name varchar(128),orig varchar(1000),dest varchar(1000))");
			stat.execute();
		}catch(Exception e){
			e.printStackTrace();<commit_msg>Add a comment option for MySQL DB Manager<commit_after>package com.github.huangzhiyi.shpmdir.db;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.LinkedList;
import java.util.List;

import com.github.huangzhiyi.shpmdir.CityDir;
import com.github.huangzhiyi.shpmdir.CitySet;


public class CityDirDao {

	/**
	 * Use H2 database
	 */
	private static final DBMngr DBMNGR=H2Mngr.instance();
	
	/**
	 * Use MySQL
	 */
//	private static final DBMngr DBMNGR=MysqlMngr.instance();
	
	public static void createTable(){
		try{
			Connection conn=DBMNGR.getConnection();
			PreparedStatement stat=conn.prepareStatement("CREATE TABLE IF NOT EXISTS citydir(name varchar(128),orig varchar(1000),dest varchar(1000))");
			stat.execute();
		}catch(Exception e){
			e.printStackTrace();
{'fraction_non_alphanumeric': 0.11401273885350319, 'fraction_numerical': 0.01592356687898089, 'mean_word_length': 5.3861788617886175, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '6438926', 'n_tokens_mistral': 582, 'n_tokens_neox': 508, 'n_words': 110}