public void BuildSQliteDatabase()
{
/**
* NOTE:
* This is VERY bad practice.
* I would normally NEVER have straight sql commands inline like this.
* It is much better practice to use stored procedures through a DataAccess Layer.
*
*/
TwitterAPIDAO dao = new TwitterAPIDAO();
dao.ExecuteNonQuery("DROP TABLE IF EXISTS tweets");
dao.ExecuteNonQuery(@"CREATE TABLE tweets(id INTEGER PRIMARY KEY, text TEXT, date INTEGER, source TEXT, lang TEXT, like INTEGER, reTweet INTEGER, hasUrl INTEGER, hasImage INTEGER, hasEmoji INTEGER)");
dao.ExecuteNonQuery("DROP TABLE IF EXISTS hashtags");
dao.ExecuteNonQuery(@"CREATE TABLE hashtags(id INTEGER PRIMARY KEY, tag TEXT)");
dao.ExecuteNonQuery("DROP TABLE IF EXISTS urls");
dao.ExecuteNonQuery(@"CREATE TABLE urls(id INTEGER PRIMARY KEY, url TEXT, hostname TEXT)");
dao.ExecuteNonQuery("DROP TABLE IF EXISTS emojis");
dao.ExecuteNonQuery(@"CREATE TABLE emojis(id INTEGER PRIMARY KEY, value TEXT)");
dao.ExecuteNonQuery("DROP TABLE IF EXISTS mentions");
dao.ExecuteNonQuery(@"CREATE TABLE mentions(id INTEGER PRIMARY KEY, name TEXT)");
}
public void RunSQLiteCommand(string CommandText, List <SQLiteParameter> Parameters)
{
TwitterAPIDAO dao = new TwitterAPIDAO();
dao.ExecuteNonQuery(CommandText, Parameters);
}