public void SqlServerCreatesSqWithBooleanDefault() { var mapper = new ColumnPropertiesMapper(new SqlServerDialect(), "bit"); mapper.MapColumnProperties(new Column("foo", DbType.Boolean, 0, false)); Assert.AreEqual("foo bit DEFAULT 0", mapper.ColumnSql); mapper.MapColumnProperties(new Column("bar", DbType.Boolean, 0, true)); Assert.AreEqual("bar bit DEFAULT 1", mapper.ColumnSql); }
public void SqlServerCreatesSqWithBooleanDefault() { var mapper = new ColumnPropertiesMapper(new SqlServerDialect(), "bit"); mapper.MapColumnProperties(new Column("foo", DbType.Boolean, 0, false)); Assert.AreEqual("foo bit DEFAULT 0", mapper.ColumnSql); mapper.MapColumnProperties(new Column("bar", DbType.Boolean, 0, true)); Assert.AreEqual("bar bit DEFAULT 1", mapper.ColumnSql); }
public void SqlServerCreatesSqWithNullDefault() { var mapper = new ColumnPropertiesMapper(new SqlServerDialect(), "varchar(30)"); mapper.MapColumnProperties(new Column("foo", DbType.String, 0, "NULL")); Assert.AreEqual("foo varchar(30) DEFAULT NULL", mapper.ColumnSql); }
public void SqlServerCreatesNotNullSql() { var mapper = new ColumnPropertiesMapper(new SqlServerDialect(), "varchar(30)"); mapper.MapColumnProperties(new Column("foo", DbType.String, ColumnProperty.NotNull)); Assert.AreEqual("foo varchar(30) NOT NULL", mapper.ColumnSql); }
public void PostgresIndexSqlIsNullWhenIndexedFalse() { var mapper = new ColumnPropertiesMapper(new PostgreSQLDialect(), "char(1)"); mapper.MapColumnProperties(new Column("foo", DbType.StringFixedLength, 1, 0)); Assert.IsNull(mapper.IndexSql); }
public void OracleIndexSqlIsNoNullWhenIndexed() { var mapper = new ColumnPropertiesMapper(new OracleDialect(), "char(1)"); mapper.MapColumnProperties(new Column("foo", DbType.StringFixedLength, 1, ColumnProperty.Indexed)); Assert.IsNotNull(mapper.IndexSql); }
public void OracleCreatesSql() { var mapper = new ColumnPropertiesMapper(new OracleDialect(), "varchar(30)"); mapper.MapColumnProperties(new Column("foo", DbType.String, 0)); Assert.AreEqual("foo varchar(30)", mapper.ColumnSql); }
public void SqlServerCreatesSql() { var mapper = new ColumnPropertiesMapper(new SqlServerDialect(), "varchar(30)"); mapper.MapColumnProperties(new Column("foo", DbType.String, 0)); Assert.AreEqual("[foo] varchar(30)", mapper.ColumnSql); }
public void SQLiteIndexSqlWithEmptyStringDefault() { var mapper = new ColumnPropertiesMapper(new SQLiteDialect(), "varchar(30)"); mapper.MapColumnProperties(new Column("foo", DbType.String, 1, ColumnProperty.NotNull, string.Empty)); Assert.AreEqual("foo varchar(30) NOT NULL DEFAULT ''", mapper.ColumnSql); }
public void SqlServerCreatesSqWithDefault() { ColumnPropertiesMapper mapper = new ColumnPropertiesMapper(new SqlServerDialect(), "varchar(30)"); mapper.MapColumnProperties(new Column("foo", DbType.String, 0, "'NEW'")); Assert.AreEqual("foo varchar(30) DEFAULT 'NEW'", mapper.ColumnSql); }
public void SqlServerCreatesSql() { ColumnPropertiesMapper mapper = new ColumnPropertiesMapper(new SqlServerDialect(), "varchar(30)"); mapper.MapColumnProperties(new Column("foo", DbType.String, 0)); Assert.AreEqual("foo varchar(30)", mapper.ColumnSql); }
public void PostgresIndexSqlIsNullWhenIndexedFalse() { ColumnPropertiesMapper mapper = new ColumnPropertiesMapper(new PostgreSQLDialect(), "char(1)"); mapper.MapColumnProperties(new Column("foo", DbType.StringFixedLength, 1, 0)); Assert.IsNull(mapper.IndexSql); }
public void OracleIndexSqlIsNoNullWhenIndexed() { ColumnPropertiesMapper mapper = new ColumnPropertiesMapper(new OracleDialect(), "char(1)"); mapper.MapColumnProperties(new Column("foo", DbType.StringFixedLength, 1, ColumnProperty.Indexed)); Assert.IsNotNull(mapper.IndexSql); }
public void OracleCreatesNotNullSql() { ColumnPropertiesMapper mapper = new ColumnPropertiesMapper(new OracleDialect(), "varchar(30)"); mapper.MapColumnProperties(new Column("foo", DbType.String, ColumnProperty.NotNull)); Assert.AreEqual("foo varchar(30) NOT NULL", mapper.ColumnSql); }
public void SqlServerCreatesNotNullSql() { var mapper = new ColumnPropertiesMapper(new SqlServerDialect(), "varchar(30)"); mapper.MapColumnProperties(new Column("foo", DbType.String, ColumnProperty.NotNull)); Assert.AreEqual("[foo] varchar(30) NOT NULL", mapper.ColumnSql); }
public void SQLiteIndexSqlWithEmptyStringDefault() { var mapper = new ColumnPropertiesMapper(new SQLiteDialect(), "varchar(30)"); mapper.MapColumnProperties(new Column("foo", DbType.String, 1, ColumnProperty.NotNull, string.Empty)); Assert.AreEqual("foo varchar(30) NOT NULL DEFAULT ''", mapper.ColumnSql); }