private void Initialize()
{
var dataFileName = PathUtil.GetAppPath("user_data.db");
if (!System.IO.File.Exists(dataFileName))
{
CreatePasswordDatabase(dataFileName);
}
this.DatabaseManager = new DatabaseManager(QueryFactoryBuilder.BuildForSqlite(dataFileName));
}
private void CreatePasswordDatabase(string dataFileName)
{
SQLiteConnection.CreateFile(dataFileName);
var db = QueryFactoryBuilder.BuildForSqlite(dataFileName);
db.Connection.Open();
var statement =
"CREATE TABLE \"crendentials\"(" +
"\"id\" INTEGER NOT NULL UNIQUE," +
"\"title\" TEXT NOT NULL," +
"\"location\" TEXT," +
"\"username\" TEXT NOT NULL," +
"\"password\" TEXT NOT NULL," +
"PRIMARY KEY(\"id\" AUTOINCREMENT)" +
");";
var cmd = new SQLiteCommand(statement, (SQLiteConnection)db.Connection);
cmd.ExecuteNonQuery();
db.Connection.Close();
}
