public void InsertData_WhenCalled_InsertsData()
{
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");
var row = table.NewRow();
row[0] = true;
row[1] = DateTime.Now;
row[2] = long.MaxValue;
row[3] = "string";
row[4] = "";
var parameters = new Tuple <string, object>[] {
new Tuple <string, object>("param0", true),
new Tuple <string, object>("param1", DateTime.Now),
new Tuple <string, object>("param2", long.MaxValue),
new Tuple <string, object>("param3", "string"),
new Tuple <string, object>("param4", "")
};
var query = $"INSERT INTO table([boolColumn], [dateColumn], [longColumn], [textColumn], [noTypeColumn]) " +
$"VALUES ({string.Join(", ", parameters.Select(p => p.Item1))})";
dbBuilder.InsertData(row);
sqliteService.Verify(x =>
x.ExecuteQuery(query, null, It.IsAny <IEnumerable <Tuple <string, object> > >()));
}
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();
}
