public static ICreateTableWithColumnSyntax WithIdColumn(this ICreateTableWithColumnSyntax tableWithColumnSyntax)
{
return(tableWithColumnSyntax.WithColumn("Id").AsGuid().NotNullable().PrimaryKey());
}
public static ICreateTableWithColumnSyntax Timestamps(this ICreateTableWithColumnSyntax migration)
{
return(migration
.WithColumn("CreatedAt").AsDateTime().NotNullable().WithDefault(SystemMethods.CurrentDateTime)
.WithColumn("UpdatedAt").AsDateTime().Nullable());
}
/// <summary>
/// Adds modification auditing columns to a table. See <see cref="IModificationAudited"/>.
/// </summary>
public static ICreateTableColumnOptionOrForeignKeyCascadeOrWithColumnSyntax WithModificationAuditColumns(this ICreateTableWithColumnSyntax table)
{
return(table
.WithColumn("LastModificationTime").AsDateTime().Nullable()
.WithColumn("LastModifierUserId").AsInt64().Nullable().ForeignKey("AbpUsers", "Id"));
}
/// <summary>
/// Adds IsDeleted column to the table. See <see cref="ISoftDelete"/>.
/// </summary>
public static ICreateTableColumnOptionOrWithColumnSyntax WithIsDeletedColumn(this ICreateTableWithColumnSyntax table)
{
return(table
.WithColumn("IsDeleted").AsBoolean().NotNullable().WithDefaultValue(false));
}
/// <summary>
/// Ads CreationTime field to the table for <see cref="IHasCreationTime"/> interface.
/// </summary>
public static ICreateTableColumnOptionOrWithColumnSyntax WithCreationTimeColumn(this ICreateTableWithColumnSyntax table)
{
return(table
.WithColumn("CreationTime").AsDateTime().NotNullable().WithDefault(SystemMethods.CurrentDateTime));
}
/// <summary>
/// Определяет новый столбец с именем на основе свойства или поля, переданного в выражении <paramref name="columnAccessor"/>.
/// </summary>
/// <returns>См. <see cref="ICreateTableWithColumnSyntax.WithColumn(string)"/>.</returns>
/// <remarks>В качестве имени столбцы используется значение атрибута <see cref="ColumnAttribute"/> или имя свойства/типа из выражения <paramref name="columnAccessor"/>.</remarks>
public static ICreateTableColumnAsTypeSyntax WithColumn <TTable, TProperty>(this ICreateTableWithColumnSyntax table, Expression <Func <TTable, TProperty> > columnAccessor)
{
return(table.WithColumn(GetColumnName(columnAccessor)));
}
/// <summary>
/// Adds IsDeleted column to the table. See <see cref="IPassivable"/>.
/// </summary>
public static ICreateTableColumnOptionOrWithColumnSyntax WithIsActiveColumn(this ICreateTableWithColumnSyntax table, bool defaultValue = true)
{
return(table
.WithColumn("IsActive").AsBoolean().NotNullable().WithDefaultValue(defaultValue));
}
/// <summary>
/// Adds DeleterUserId field to a table. See <see cref="IDeletionAudited"/>.
/// </summary>
public static ICreateTableColumnOptionOrWithColumnSyntax WithDeleterUserIdColumn(this ICreateTableWithColumnSyntax table)
{
return(table
.WithColumn(SheshaDatabaseConsts.DeleterUserIdColumn).AsInt64().Nullable().ForeignKey(SheshaDatabaseConsts.UsersTable, SheshaDatabaseConsts.IdColumn));
}
/// <summary>
/// Adds TenantId column to a table as nullable. See <see cref="AbpTenant{TUser}"/>.
/// </summary>
public static ICreateTableColumnOptionOrForeignKeyCascadeOrWithColumnSyntax WithTenantIdAsNullable(this ICreateTableWithColumnSyntax table)
{
return(table
.WithColumn(SheshaDatabaseConsts.TenantIdColumn).AsInt32().Nullable().ForeignKey(SheshaDatabaseConsts.TenantsTable, SheshaDatabaseConsts.IdColumn));
}
/// <summary>
/// Adds DeleterUserId field to a table. See <see cref="IDeletionAudited"/>.
/// </summary>
public static ICreateTableColumnOptionOrForeignKeyCascadeOrWithColumnSyntax WithDeleterUserIdColumn(this ICreateTableWithColumnSyntax table)
{
return(table
.WithColumn("DeleterUserId").AsInt64().Nullable().ForeignKey("AbpUsers", "Id"));
}
protected override void CreateEntityColumns(ICreateTableWithColumnSyntax entityTable)
{
entityTable.WithColumn("PhoneNumber").AsString();
}
public static ICreateTableWithColumnSyntax WithId(this ICreateTableWithColumnSyntax table)
{
return(table.WithColumn("Id").AsId());
}
protected override void CreateEntityColumns(ICreateTableWithColumnSyntax entityTable)
{
entityTable.WithColumn("Title").AsString(255);
}
public static ICreateTableColumnOptionOrWithColumnSyntax WithTimeStamps(this ICreateTableWithColumnSyntax tableWithColumnSyntax)
{
return(tableWithColumnSyntax
.WithColumn("CreatedAt").AsDateTime().NotNullable()
.WithColumn("ModifiedAt").AsDateTime().NotNullable());
}
public static ICreateTableColumnOptionOrWithColumnSyntax WithIdColumn(this ICreateTableWithColumnSyntax table,
string columnName)
{
return(table.WithColumn(columnName).AsInt32().NotNullable().PrimaryKey().Identity());
}
public static ICreateTableColumnOptionOrForeignKeyCascadeOrWithColumnSyntax WithNullableUserId(this ICreateTableWithColumnSyntax table, string columnName)
{
return(table
.WithColumn(columnName).AsInt64().Nullable().ForeignKey(SheshaDatabaseConsts.UsersTable, SheshaDatabaseConsts.IdColumn));
}
public static ICreateTableColumnOptionOrForeignKeyCascadeOrWithColumnSyntax WithNullableUserId(this ICreateTableWithColumnSyntax table, string columnName)
{
return(table
.WithColumn(columnName).AsInt64().Nullable().ForeignKey("AbpUsers", "Id"));
}
/// <summary>
/// Adds an <see cref="Guid"/> primary key to the table.
/// </summary>
public static ICreateTableColumnOptionOrWithColumnSyntax WithIdAsGuid(this ICreateTableWithColumnSyntax table)
{
return(table
.WithColumn(SheshaDatabaseConsts.IdColumn).AsGuid().NotNullable().PrimaryKey());
}
/// <summary>
/// Adds LastModificationTime field to a table. See <see cref="IModificationAudited"/>.
/// </summary>
public static ICreateTableColumnOptionOrWithColumnSyntax WithLastModificationTimeColumn(this ICreateTableWithColumnSyntax table, bool defaultValue = true)
{
return(table
.WithColumn("LastModificationTime").AsDateTime().Nullable());
}
/// <summary>
/// Adds DeletionTime column to a table. See <see cref="IDeletionAudited"/>.
/// </summary>
public static ICreateTableColumnOptionOrWithColumnSyntax WithDeletionTimeColumn(this ICreateTableWithColumnSyntax table)
{
return(table
.WithColumn(SheshaDatabaseConsts.DeletionTimeColumn).AsDateTime().Nullable());
}
/// <summary>
/// Adds an auto increment <see cref="long"/> primary key to the table.
/// </summary>
public static ICreateTableColumnOptionOrWithColumnSyntax WithIdAsInt64(this ICreateTableWithColumnSyntax table)
{
return(table
.WithColumn("Id").AsInt64().NotNullable().PrimaryKey().Identity());
}
/// <summary>
/// Adds foreign key column (Int64) to the table
/// </summary>
public static ICreateTableColumnOptionOrWithColumnSyntax WithForeignKeyColumnInt64(this ICreateTableWithColumnSyntax table, string foreignColumn, string masterTable)
{
return(table.WithColumn(foreignColumn).AsInt64().Nullable().ForeignKey(masterTable, SheshaDatabaseConsts.IdColumn).Indexed());
}
/// <summary>
/// Adds DeletionTime column to a table. See <see cref="IDeletionAudited"/>.
/// </summary>
public static ICreateTableColumnOptionOrWithColumnSyntax WithDeletionTimeColumn(this ICreateTableWithColumnSyntax table)
{
return(table
.WithColumn("DeletionTime").AsDateTime().Nullable());
}
/// <summary>
/// Adds discriminator field to a table.
/// </summary>
public static ICreateTableColumnOptionOrWithColumnSyntax WithDiscriminator(this ICreateTableWithColumnSyntax table)
{
return(table.WithColumn(SheshaDatabaseConsts.DiscriminatorColumn).AsString(SheshaDatabaseConsts.DiscriminatorMaxSize));
}
public static ICreateTableWithColumnSyntax WithEntityBaseColumes(this ICreateTableWithColumnSyntax table)
{
return(table.WithColumn("Id").AsInt32().PrimaryKey().Identity().NotNullable()
.WithColumn("CreatedAtUtc").AsDateTime().NotNullable()
.WithColumn("ModifiedAtUtc").AsDateTime().NotNullable());
}
/// <summary>
/// Adds columns for <see cref="IHasOwningEntityLink"/>
/// </summary>
public static ICreateTableColumnOptionOrWithColumnSyntax WithMultipleOwnerColumns(this ICreateTableWithColumnSyntax table, int ownerIdSize = 40)
{
return(table
.WithColumn(SheshaDatabaseConsts.OwnerIdColumn).AsString(ownerIdSize).Nullable().Indexed()
.WithColumn(SheshaDatabaseConsts.OwnerTypeColumn).AsString(100).Nullable().Indexed());
}
public static ICreateTableWithColumnSyntax EffectiveDates(this ICreateTableWithColumnSyntax migration)
{
return(migration
.WithColumn("StartDate").AsDateTime().NotNullable().WithDefault(SystemMethods.CurrentDateTime)
.WithColumn("EndDate").AsDateTime().Nullable());
}
/// <summary>
/// Adds columns for <see cref="IHasEntityLink"/>
/// </summary>
public static ICreateTableColumnOptionOrWithColumnSyntax WithEntityLinkColumns(this ICreateTableWithColumnSyntax table)
{
return(table
.WithColumn(SheshaDatabaseConsts.EntityIdColumn).AsString(40).Nullable().Indexed()
.WithColumn(SheshaDatabaseConsts.EntityTypeColumn).AsString(100).Nullable().Indexed());
}
/// <summary>
/// Adds TenantId column to a table as nullable. See <see cref="AbpTenant{TTenant,TUser}"/>.
/// </summary>
public static ICreateTableColumnOptionOrForeignKeyCascadeOrWithColumnSyntax WithTenantIdAsNullable(this ICreateTableWithColumnSyntax table)
{
return(table
.WithColumn("TenantId").AsInt32().Nullable().ForeignKey("AbpTenants", "Id"));
}
public static ICreateTableWithColumnSyntax WithArchiveColumn(this ICreateTableWithColumnSyntax tableWithColumnSyntax)
{
return(tableWithColumnSyntax.WithColumn("IsArchived").AsBoolean().NotNullable().WithDefaultValue(false));
}
