public void Can_generate_select_sql_with_pagination() { string sql = _dialect.GetSelectSql(new[] { TABLE_NAME }, new[] { "*" }); string sqlWithPagination = _dialect.WrapSelectSqlWithPagination(sql, 10, 20); AssertSql.AreEqual(GetResultFor_Can_generate_select_sql_with_pagination(10, 20), sqlWithPagination); }
public virtual void Can_convert_column_to_sql__autoIncrement_and_primary_key() { Column column = Column.AutoIncrement("col").AsPrimaryKey().Object; string sql = _dialect.GetColumnToSqlWhenCreate(column); AssertSql.AreEqual(GetResultFor_Can_convert_column_to_sql__autoIncrement_and_primary_key(), sql); }
public void Can_select_with_multiple_tables_sql_2() { var tables = new string[] { "table1 t1", "table2 t2" }; var columns = new string[] { "t1.col1", "t2.col1", "t2.col2" }; string sql = _dialect.GetSelectSql(tables, columns); AssertSql.AreEqual("select t1.col1 ,t2.col1, t2.col2 from table1 t1 ,table2 t2", sql); }
public virtual void Can_convert_column_to_sql__default_value() { Column column = Column.String("col") .DefaultValue("some string").Object; string sql = _dialect.GetColumnToSqlWhenCreate(column); AssertSql.AreEqual(GetResultFor_Can_convert_column_to_sql__default_value(), sql.ToUpper()); }
public void Can_generate_insert_sql() { string[] cols = { "id", "name" }; object[] values = { 1, "name1" }; string sql = _dialect.GetInsertSql("foo", cols, values); AssertSql.AreEqual(GetInsertSql(), sql); }
public void Can_convert_column_to_sql__with_not_null() { Column column = Column.String("col") .Size(255) .NotNull().Object; string sql = _dialect.GetColumnToSqlWhenCreate(column); AssertSql.AreEqual(GetResultFor_Can_convert_column_to_sql__with_not_null(), sql); }
public void Can_create_table_sql() { Table table = new Table("myTable"); table.Columns.Add(Column.AutoIncrement("id").AsPrimaryKey().Object); table.Columns.Add(Column.String("name").NotNull().Object); string[] sqls = _dialect.GetCreateTableSqls(table); AssertSql.AreEqual(GetResultFor_Can_create_table_sql(), sqls); }
public void Can_convert_column_to_sql__with_primary_key() { Column column = Column.String("col") .Size(255) .AsPrimaryKey() .Object; string sql = _dialect.GetColumnToSqlWhenCreating(column); AssertSql.AreEqual(GetResultFor_Can_convert_column_to_sql__with_primary_key(), sql); }
public void Can_generate_insert_sql_with_null_parameters() { string[] cols = { "id", "name" }; object[] values = { 1, null }; string sql = _dialect.GetInsertSql("foo", cols, values); AssertSql.AreEqual(GetInsertSql(), sql); sql = _dialect.GetInsertSql("foo", cols, null); AssertSql.AreEqual(GetInsertSql(), sql); }
public void Can_order_by_ascending_sql() { string sql = _dialect.GetOrderBySql(OrderBy.Ascending("col1")); AssertSql.AreEqual("order by col1", sql); }
public void Can_drop_table() { string[] sqls = _dialect.GetDropTableSqls("myTable"); AssertSql.AreEqual(GetResultFor_Can_drop_table(), sqls); }
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_index_sql() { string sql = _dialect.GetDropIndexSql("indexName", "foo"); AssertSql.AreEqual(GetResutFor_Can_drop_index_sql(), sql); }
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_create_index_sql() { string sql = _dialect.GetCreateIndexSql("index", TABLE_NAME, "col1"); AssertSql.AreEqual("create index index on myTable (col1)", 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_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 void Can_generate_count_sql() { string sql = _dialect.GetCountSql(TABLE_NAME); AssertSql.AreEqual(GetResultFor_Can_generate_count_sql(), 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 void Can_generate_select_all_sql() { string sql = _dialect.GetSelectSql(new[] { TABLE_NAME }, new[] { "*" }); AssertSql.AreEqual(GetSelectAllSql(), 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 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); }