public async Task DropTable(string tableName) { if (await _db.TableExists(tableName)) { await _db.DropTable(tableName); } }
public static bool CastRawValuesToClassTypeProperties(IClickHouseDatabase db) { if (db.TableExists("Test")) { db.DropTable("Test"); } db.CreateTable(new Table { Engine = "MergeTree(date, (date, Id, Number, Cost), 8192)", Name = "Test", Columns = new List <Column>() { new Column("date", "Date"), new Column("Id", "String"), new Column("Number", "Int32"), new Column("Cost", "Float64"), new Column("Name", "String"), new Column("Ushort", "UInt16"), new Column("Uint", "UInt32"), } }); var testItem = new TestDataItem3 { Id = Guid.NewGuid(), Number = -96, Cost = 31, Name = "Jon Skeet", Ushort = 150, Uint = 65536 }; var command = testItem.GetInsertCommand(); db.ExecuteNonQuery(command); command = "SELECT Id, Number, Cost, Name, Ushort, Uint FROM Test"; var resultItem = db.ExecuteQueryMapping <TestDataItem3>(command, convention: new UnderscoreNamingConvention()).Single(); db.DropTable("Test"); return(testItem.Equals(resultItem)); }
private bool MigrationTableExists() { return(_dbProvider.TableExists(MigrationsTableName)); }