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(); }