public void CreateTable_WhenCalled_CreatesTable()
{
var table = new DataTable();
table.Columns.Add("boolColumn", typeof(bool));
table.Columns.Add("dateColumn", typeof(DateTime));
table.Columns.Add("longColumn", typeof(long));
table.Columns.Add("textColumn", typeof(string));
table.Columns.Add("noTypeColumn");
table.Rows.Add(table.NewRow());
dbBuilder.CreateTable(table);
sqliteService.Verify(x =>
x.ExecuteQuery("CREATE TABLE table (boolColumn BOOLEAN, dateColumn DATETIME, longColumn BIGINT, textColumn TEXT, noTypeColumn TEXT)", null, null));
}
private void StoreDataToDb(object sender, EventArgs e)
{
const string tableName = "myTable";
const string dbName = "temp.sqlite";
string dbPath = Application.StartupPath + "\\" + dbName;
if (File.Exists(dbPath))
{
File.Delete(dbPath);
}
var sqliteService = new SqliteService(tableName, dbPath);
var dbBuilder = new DbBuilder(tableName, sqliteService);
dbBuilder.CreateTable(_dataTable.Columns);
dbBuilder.InsertData(_dataTable.Rows);
}
private void View_OnStoreDb(object sender, EventArgs e)
{
Cursor.Current = Cursors.WaitCursor;
if (File.Exists(DbPath))
{
File.Delete(DbPath);
}
var dbBuilder = new DbBuilder(
DbPath,
TableName,
ExcelTable,
ColumnInfos.Where(info => info.Keep).ToList(),
View.XCoordinateHeader,
View.YCoordinateHeader,
View.Projection
);
dbBuilder.CreateTable();
dbBuilder.InsertData();
}
