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()"))); }