public static void Init(string dbFileName,SqliteInitInfo initInfo)
{
_dbFileName = dbFileName;
Connect((c) => {
CreateTableIfNotExist(initInfo, c);
});
}
private static void CreateTableIfNotExist(SqliteInitInfo initInfo, SQLiteConnection c)
{
var existCommandText = string.Format("SELECT COUNT(*) FROM sqlite_master where type='table' and name='{0}'", initInfo.TableName);
SQLiteCommand cmd = new SQLiteCommand(existCommandText, c);
var dataAdapter = new SQLiteDataAdapter(cmd);
var ds = new DataSet();
dataAdapter.Fill(ds);
if (ds.Tables[0].Rows[0][0].ToString() != "1")
{
cmd.CommandText = initInfo.CreateSql;
var r = cmd.ExecuteNonQuery();
}
}
public static void Init(string dbName)
{
var tableName = "Record";
SqliteInitInfo initInfo = new SqliteInitInfo
{
TableName = tableName,
CreateSql = string.Format(
@"create table {0} (
Id varchar(36) not null,
Title nvarchar(36) not null ,
Project nvarchar(100) ,
Description text,
Tag nvarchar(300) ,
Status int,
DealWith text ,
CreateDate datetime,
LastEditDate datetime,
PRIMARY KEY('Id'))",
tableName)
};
SqliteHelper.Init(dbName, initInfo);
}
