public virtual void Can_add_comment_to_column() { string sql = _dialect.GetAddCommentToColumnSql(TABLE_NAME, "col1", "this is a comment"); AssertSql.AreEqual(GetResultFor_Can_add_comment_to_column(), sql); }
public void Can_drop_table() { string[] sqls = _dialect.GetDropTableSqls("myTable"); AssertSql.AreEqual(GetResultFor_Can_drop_table(), sqls); }
public void Can_create_index_with_multiple_columns_sql() { string sql = _dialect.GetCreateIndexSql("indexName", TABLE_NAME, "col1", "col2", "col3"); AssertSql.AreEqual("create index indexName on myTable (col1, col2, col3)", sql); }
public void Can_drop_index_sql() { string sql = _dialect.GetDropIndexSql("indexName", "foo"); AssertSql.AreEqual(GetResutFor_Can_drop_index_sql(), sql); }
public void Can_order_by_ascending_with_multiple_columns_sql() { string sql = _dialect.GetOrderBySql(OrderBy.Ascending("col1"), OrderBy.Ascending("col2")); AssertSql.AreEqual("order by col1, col2", sql); }
public void Can_create_index_sql() { string sql = _dialect.GetCreateIndexSql("index", TABLE_NAME, "col1"); AssertSql.AreEqual("create index index on myTable (col1)", sql); }
public void Can_generate_count_sql() { string sql = _dialect.GetCountSql(TABLE_NAME); AssertSql.AreEqual(GetResultFor_Can_generate_count_sql(), sql); }
public void Can_order_by_ascending_sql() { string sql = _dialect.GetOrderBySql(OrderBy.Ascending("col1")); AssertSql.AreEqual("order by col1", sql); }
public void Can_generate_select_all_sql() { string sql = _dialect.GetSelectSql(new[] { TABLE_NAME }, new[] { "*" }); AssertSql.AreEqual(GetSelectAllSql(), sql); }
public void Can_create_check_if_table_exists_sql() { string sql = _dialect.GetTableExistsSql("myTable"); AssertSql.AreEqual(GetResultFor_Can_create_check_if_table_exists_sql(), sql); }
public virtual void Can_order_by_ascending_and_descending_with_multiple_columns_sql() { var sql = _dialect.GetOrderBySql(OrderBy.Ascending("col1"), OrderBy.Descending("col2")); AssertSql.AreEqual("order by col1, col2 desc", sql); }
public virtual void Can_order_by_descending_sql() { var sql = _dialect.GetOrderBySql(OrderBy.Descending("col1")); AssertSql.AreEqual("order by col1 desc", sql); }
public virtual void Can_create_check_if_table_exists_in_schema_sql() { var sql = _dialect.GetTableExistsSql("dbo.myTable"); AssertSql.AreEqual(GetResultFor_Can_create_check_if_table_exists_in_schema_sql("dbo", "myTable"), sql); }