static ConEgg OpenDB(string DBname)
{
ConEgg ce;
var DB = new MyDataBase(DBname);
// DB.DBCreation();
SQLiteConnection m_dbConnection = new SQLiteConnection(string.Format(
"Data Source={0};Version=3;", DB.DBname));
m_dbConnection.Open();
// SQLiteCommand command = new SQLiteCommand(m_dbConnection);
// begin transaction
SQLiteCommand command = new SQLiteCommand("begin", m_dbConnection);
command.ExecuteNonQuery();
ce.todoOK = true;
ce.SQLiteCon = m_dbConnection;
ce.SQLComm = command;
return(ce);
}
static bool CreateDB(string DBname)
{
File.Delete(DBname); // first delete the file
SQLiteConnection.CreateFile(DBname); // Create DB
var DB = new MyDataBase(DBname);
SQLiteConnection m_dbConnection = new SQLiteConnection(string.Format(
"Data Source={0};Version=3;", DB.DBname));
m_dbConnection.Open();
SQLiteCommand command = new SQLiteCommand(m_dbConnection);
// string sql = "create table highscores (name varchar(20), score int)";
string sql;
sql = "CREATE TABLE 'src' ( `indext` INTEGER NOT NULL UNIQUE, `keyword` TEXT ( 50 ) NOT NULL UNIQUE," +
" `keywordfreq` INTEGER NOT NULL, " +
"`freqpercentage` NUMERIC, `freqmargin` NUMERIC, PRIMARY KEY(`indext`) )";
command.CommandText = sql;
command.ExecuteNonQuery();
sql = "CREATE TABLE 'tgt' ( `indext` INTEGER NOT NULL UNIQUE, `keyword` TEXT ( 50 ) NOT NULL UNIQUE," +
" `keywordfreq` INTEGER NOT NULL, " +
"`freqpercentage` NUMERIC, `freqmargin` NUMERIC, PRIMARY KEY(`indext`) )";
command.CommandText = sql;
command.ExecuteNonQuery();
sql = "CREATE TABLE `srctgt` ( `indexsrc` INTEGER NOT NULL, `indextgt` INTEGER NOT NULL, `freq` INTEGER, PRIMARY KEY(`indexsrc`,`indextgt`) )";
command.CommandText = sql;
command.ExecuteNonQuery();
sql = "CREATE INDEX `idx_srctgt_src` ON `srctgt` ( `indexsrc` )";
command.CommandText = sql;
command.ExecuteNonQuery();
sql = "CREATE INDEX `idx_srctgt_tgt` ON `srctgt` ( `indextgt` )";
command.CommandText = sql;
command.ExecuteNonQuery();
sql = "CREATE INDEX `idx_src_keyword` ON `src` ( `keyword` )";
command.CommandText = sql;
command.ExecuteNonQuery();
sql = "CREATE INDEX `idx_tgt_keyword` ON `tgt` ( `keyword` )";
command.CommandText = sql;
command.ExecuteNonQuery();
sql = "CREATE TABLE `srccand` ( " +
" `indexsrc` NUMERIC NOT NULL, "+
" `indextgt` NUMERIC NOT NULL, "+
" `freqpercentagesample` NUMERIC, "+
" `freqmarginsample` NUMERIC, "+
" `populationsampleratio` NUMERIC, " +
" `freqinsample` NUMERIC, "+
" PRIMARY KEY(`indexsrc`,`indextgt`) " +
" );";
command.CommandText = sql;
command.ExecuteNonQuery();
sql = "CREATE TABLE `tgtcand` ( " +
" `indexsrc` NUMERIC NOT NULL, "+
" `indextgt` NUMERIC NOT NULL, "+
" `freqpercentagesample` NUMERIC, "+
" `freqmarginsample` NUMERIC, "+
" `populationsampleratio` NUMERIC, " +
" `freqinsample` NUMERIC, "+
" PRIMARY KEY(`indexsrc`,`indextgt`) " +
" );";
command.CommandText = sql;
command.ExecuteNonQuery();
m_dbConnection.Close();
return(true);
}
