public override void Up()
{
Alter.Table("User")
.AddColumn("CreationDate").AsDateTimeOffset().Nullable();
Update.Table("User").Set(new { CreationDate = RawSql.Insert("SYSDATETIMEOFFSET()") }).AllRows();
Alter.Table("User")
.AlterColumn("CreationDate").AsDateTimeOffset().NotNullable();
}
public void CanInsertAtAtIdentity()
{
var expression = new InsertDataExpression {
TableName = "TestTable"
};
expression.Rows.Add(new InsertionDataDefinition
{
new KeyValuePair <string, object>("Id", 1),
new KeyValuePair <string, object>("Name", RawSql.Insert("@@IDENTITY")),
new KeyValuePair <string, object>("Website", "codethinked.com")
});
var result = Generator.Generate(expression);
result.ShouldBe("INSERT INTO [dbo].[TestTable] ([Id], [Name], [Website]) VALUES (1, @@IDENTITY, N'codethinked.com')");
}
public void CanInsertScopeIdentity()
{
var expression = new InsertDataExpression();
expression.TableName = "TestTable";
expression.Rows.Add(new InsertionDataDefinition
{
new KeyValuePair <string, object>("Id", 1),
new KeyValuePair <string, object>("Name", RawSql.Insert("SCOPE_IDENTITY()")),
new KeyValuePair <string, object>("Website", "codethinked.com")
});
var sql = generator.Generate(expression);
var expected = "INSERT INTO [dbo].[TestTable] ([Id], [Name], [Website]) VALUES (1, SCOPE_IDENTITY(), 'codethinked.com')";
sql.ShouldBe(expected);
}
protected virtual InsertionDataDefinition CreateVersionInfoInsertionData(long version, string description)
{
return(new InsertionDataDefinition
{
new KeyValuePair <string, object>(VersionTableMetaData.ColumnName, version),
new KeyValuePair <string, object>(VersionTableMetaData.AppliedOnColumnName, RawSql.Insert("CURRENT_TIMESTAMP")),
new KeyValuePair <string, object>(VersionTableMetaData.DescriptionColumnName, description)
});
}
public override void Up()
{
Create.Table("usuarios")
.WithColumn("id").AsString(36).NotNullable().PrimaryKey().WithDefaultValue(RawSql.Insert("gen_random_uuid()"))
.WithColumn("nome").AsAnsiString(80).NotNullable()
.WithColumn("email").AsAnsiString(250).Unique().NotNullable()
.WithColumn("criadoem").AsDateTime().NotNullable()
.WithColumn("alteradoem").AsDateTime().Nullable();
Create.Table("leiloes")
.WithColumn("id").AsString(36).NotNullable().PrimaryKey().WithDefaultValue(RawSql.Insert("gen_random_uuid()"))
.WithColumn("titulo").AsString(250).NotNullable()
.WithColumn("descricao").AsString().Nullable()
.WithColumn("leiloadoporid").AsString(36).NotNullable()
.WithColumn("lanceminimo").AsDecimal(10, 2)
.WithColumn("datainicio").AsDateTime().NotNullable()
.WithColumn("datafim").AsDateTime().Nullable()
.WithColumn("ispublico").AsBoolean().NotNullable().WithDefaultValue(false)
.WithColumn("status").AsInt32().Nullable()
.WithColumn("lanceganhadorid").AsString(36).Nullable()
.WithColumn("criadoem").AsDateTime().NotNullable()
.WithColumn("alteradoem").AsDateTime().Nullable();
Create.Table("lances")
.WithColumn("id").AsString(36).NotNullable().PrimaryKey().WithDefaultValue(RawSql.Insert("gen_random_uuid()"))
.WithColumn("valor").AsDecimal(10, 2).NotNullable()
.WithColumn("interessadoid").AsString(36).NotNullable()
.WithColumn("leilaoid").AsString(36).NotNullable()
.WithColumn("criadoem").AsDateTime().NotNullable();
Create.ForeignKey("FK_LEILOES_USUARIOS")
.FromTable("leiloes").ForeignColumn("leiloadoporid")
.ToTable("usuarios").PrimaryColumn("id");
Create.ForeignKey("FK_LANCES_LEILOES")
.FromTable("lances").ForeignColumn("leilaoid")
.ToTable("leiloes").PrimaryColumn("id");
Create.ForeignKey("FK_LANCES_USUARIOS")
.FromTable("lances").ForeignColumn("interessadoid")
.ToTable("usuarios").PrimaryColumn("id");
}
public static ICreateTableColumnOptionOrWithColumnSyntax WithTimeStamps(
this ICreateTableWithColumnSyntax tableWithColumnSyntax)
{
return(tableWithColumnSyntax
.WithColumn("created_at").AsDateTime().NotNullable().WithDefaultValue(RawSql.Insert("now()"))
.WithColumn("updated_at").AsDateTime().NotNullable().WithDefaultValue(RawSql.Insert("now()")));
}