protected override void CreateEntityColumns(ICreateTableWithColumnSyntax entityTable)
{
entityTable.WithColumn("UserId").AsInt32()
.WithColumn("PhoneNumber").AsString()
.WithColumn("Code").AsString()
.WithColumn("Expires").AsDateTime();
}
public static ICreateTableColumnOptionOrWithColumnSyntax WithCommonColumns(this ICreateTableWithColumnSyntax table)
{
return(table
.WithColumn("Id").AsInt32().NotNullable().PrimaryKey().Identity()
.WithColumn("Name").AsString(255).NotNullable()
.WithColumn("Description").AsString(500).Nullable());
}
public static ICreateTableColumnOptionOrWithColumnSyntax WithTimeStamps(
this ICreateTableWithColumnSyntax tableWithColumnSyntax)
{
return(tableWithColumnSyntax
.WithColumn("CreatedAt").AsDateTime2().NotNullable()
.WithColumn("ModifiedAt").AsDateTime2().NotNullable());
}
public static ICreateTableWithColumnSyntax CreateBase(this ICreateTableWithColumnSyntax create, bool userFK = true)
{
create
.WithColumn("Id")
.AsInt32()
.NotNullable()
.Identity()
.PrimaryKey()
.WithColumn("Active")
.AsBoolean()
.NotNullable()
.WithDefaultValue(true)
.WithColumn("CreateDate")
.AsDateTime()
.NotNullable()
.WithDefaultValue(SystemMethods.CurrentDateTime);
if (userFK)
{
create
.WithColumn("IdUsuario")
.AsInt32()
.NotNullable()
.ForeignKey("Usuario", "Id");
}
return(create);
}
public static ICreateTableWithColumnSyntax WithAuditColumns(this ICreateTableWithColumnSyntax tableWithColumnSyntax)
{
return(tableWithColumnSyntax.WithColumn("CreatedBy").AsString().WithDefaultValue("Migrator")
.WithColumn("CreationDate").AsDateTime().WithDefaultValue(DateTime.UtcNow)
.WithColumn("ModifiedBy").AsString().WithDefaultValue("Migrator")
.WithColumn("ModificationDate").AsDateTime().WithDefaultValue(DateTime.UtcNow));
}
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()")));
}
protected override void CreateEntityColumns(ICreateTableWithColumnSyntax entityTable)
{
entityTable.WithColumn("UserName").AsString(50)
.WithColumn("DisplayName").AsString(50).Nullable()
.WithColumn("HashedPassword").AsString(2000).Nullable()
.WithColumn("LastSeenAt").AsDateTime().Nullable();
}
protected override void CreateEntityColumns(ICreateTableWithColumnSyntax entityTable)
{
entityTable
.WithColumn("TopicId").AsInt32()
.WithColumn("CreatedBy").AsInt32()
.WithColumn("Content").AsString(int.MaxValue);
}
protected override void CreateEntityColumns(ICreateTableWithColumnSyntax entityTable)
{
entityTable.WithColumn("WxId").AsString()
.WithColumn("NickName").AsString()
.WithColumn("WxAccount").AsString().Nullable()
.WithColumn("AvatarFileId").AsInt32().Nullable();
}
protected override void CreateEntityColumns(ICreateTableWithColumnSyntax entityTable)
{
entityTable.WithColumn("RequireUserPhoneNumberVerified").AsBoolean()
.WithColumn("PublicHostName").AsString()
.WithColumn("EnableNewUserRegistration").AsBoolean()
.WithColumn("EnableNewTopicCreation").AsBoolean()
.WithColumn("EnableNewReplyCreation").AsBoolean()
.WithColumn("IsReadonly").AsBoolean()
.WithColumn("FooterNoticeLeft").AsString().Nullable()
.WithColumn("FooterNoticeRight").AsString().Nullable()
.WithColumn("HeaderLink1Text").AsString().Nullable()
.WithColumn("HeaderLink1Url").AsString().Nullable()
.WithColumn("HeaderLink2Text").AsString().Nullable()
.WithColumn("HeaderLink2Url").AsString().Nullable()
.WithColumn("HeaderLink3Text").AsString().Nullable()
.WithColumn("HeaderLink3Url").AsString().Nullable()
.WithColumn("HeaderLink4Text").AsString().Nullable()
.WithColumn("HeaderLink4Url").AsString().Nullable();
}
public static ICreateTableColumnOptionOrWithColumnSyntax WithTimestamps(this ICreateTableWithColumnSyntax that)
{
return(that.
WithColumn("created_at").AsDateTime().
WithColumn("updated_at").AsDateTime().Nullable()
.WithColumn("deleted_at").AsDateTime().Nullable());
}
public static ICreateTableColumnOptionOrWithColumnSyntax WithVersionColumn(this ICreateTableWithColumnSyntax tableWithColumnSyntax)
{
return(tableWithColumnSyntax
.WithColumn("Version")
.AsInt32()
.NotNullable());
}
WithNameColumn(this ICreateTableWithColumnSyntax tableWithColumnSyntax)
{
return(tableWithColumnSyntax
.WithColumn("name")
.AsString(StringLength.Hundred)
.NotNullable());
}
protected override void CreateEntityColumns(ICreateTableWithColumnSyntax entityTable)
{
entityTable
.WithColumn("UploadedBy").AsInt32()
.WithColumn("Size").AsInt64()
.WithColumn("OriginalName").AsString()
.WithColumn("StoragePath").AsString(2000);
}
public static ICreateTableColumnOptionOrWithColumnSyntax WithTimestampColumns(
this ICreateTableWithColumnSyntax tableWithColumnSyntax)
{
return(tableWithColumnSyntax
.WithColumn("DeletedAt").AsDateTime().Nullable().WithDefaultValue(null)
.WithColumn("CreatedAt").AsDateTime()
.WithColumn("ModifiedAt").AsDateTime());
}
WithIdColumn(this ICreateTableWithColumnSyntax tableWithColumnSyntax)
{
return(tableWithColumnSyntax
.WithColumn("id")
.AsInt32()
.NotNullable()
.PrimaryKey()
.Identity());
}
public static ICreateTableColumnOptionOrWithColumnSyntax WithBaseModel(
this ICreateTableWithColumnSyntax table
)
{
return(table
.WithColumn("Created").AsDateTime().NotNullable()
.WithColumn("Modified").AsDateTime().Nullable()
.WithColumn("IsDeleted").AsBoolean().NotNullable());
}
protected override void CreateEntityColumns(ICreateTableWithColumnSyntax entityTable)
{
entityTable
.WithColumn("UserId").AsInt32()
.WithColumn("EmailAddress").AsString(50)
.WithColumn("OldEmailAddress").AsString(50)
.WithColumn("CallbackToken").AsString(300)
.WithColumn("IsActivated").AsBoolean();
}
public static ICreateTableColumnOptionOrWithColumnSyntax WithCommonColumns(this ICreateTableWithColumnSyntax tableWithColumnSyntax)
{
return(tableWithColumnSyntax
.WithIdColumn()
.WithColumn("DeletedAt").AsDateTime().Nullable()
.WithColumn("IsActive").AsBoolean().NotNullable().WithDefaultValue(true)
.WithColumn("CreatedAt").AsDateTime().NotNullable().WithDefault(SystemMethods.CurrentUTCDateTime)
.WithColumn("UpdatedAt").AsDateTime().NotNullable().WithDefault(SystemMethods.CurrentUTCDateTime));
}
public static ICreateTableColumnOptionOrWithColumnSyntax WithIdColumn(this ICreateTableWithColumnSyntax tableWithColumnSyntax)
{
return(tableWithColumnSyntax
.WithColumn("Id")
.AsInt32()
.NotNullable()
.PrimaryKey()
.Identity());
}
public static ICreateTableWithColumnSyntax CommonFields(this ICreateTableWithColumnSyntax e)
{
return(e.WithColumn("Remarks").AsString(500).Nullable()
.WithColumn("TenantId").AsInt64().Nullable().ForeignKey("Tenant", "Id")
.WithColumn("IUserId").AsInt64().Nullable()
.WithColumn("EUserId").AsInt64().Nullable()
.WithColumn("IDate").AsDateTime().Nullable().WithDefault(SystemMethods.CurrentDateTime)
.WithColumn("EDate").AsDateTime().Nullable());
}
public static ICreateTableWithColumnSyntax WithTimeStamps(
this ICreateTableWithColumnSyntax table,
string columnCreatedAt,
string columnUpdatedAt)
{
return(table
.WithColumn(columnCreatedAt).AsDateTime()
.WithColumn(columnUpdatedAt).AsDateTime());
}
public static ICreateTableWithColumnSyntax WithColumn(
this ICreateTableWithColumnSyntax columnSyntax,
string columnName,
Func <ICreateTableColumnAsTypeSyntax, ICreateTableWithColumnSyntax> columnOptions
)
{
var column = columnSyntax.WithColumn(columnName);
return(columnOptions.Invoke(column));
}
protected override void CreateEntityColumns(ICreateTableWithColumnSyntax entityTable)
{
entityTable.WithColumn("Title").AsString(255).NotNullable()
.WithColumn("Content").AsString(int.MaxValue).Nullable()
.WithColumn("Type").AsInt16().NotNullable()
.WithColumn("CreatedBy").AsInt32().NotNullable()
.WithColumn("LastRepliedAt").AsDateTime().Nullable()
.WithColumn("ReplyCount").AsInt32()
.WithColumn("ViewCount").AsInt32();
}
/// <summary>
/// Create a foreign columnName to the table <paramref name="primaryTableName"/><br/>
/// ------------------------------------------------------------------ <br/>
/// If <paramref name="columnName"/> is specified, the new column-name will follow that value<br/>
/// If <paramref name="columnName"/> is unspecified, the new column-name will be computed<br/>
/// <br/>
/// If <paramref name="primaryColumnName"/> is specified, the primary-table-column will follow that value<br/>
/// If <paramref name="primaryColumnName"/> is unspecified, the primary-table-column will be computed<br/>
/// <br/>
/// i.e:<br/>
/// <paramref name="columnName"/> is unspecified and <paramref name="primaryTableName"/> is "Parent" => column-name will be computed to "ParentId"<br/>
/// <br/>
/// <paramref name="primaryColumnName"/> is unspecified => the primary-table-column will be "Id"<br/>
/// </summary>
/// <param name="syntax"></param>
/// <param name="primaryTableName"></param>
/// <param name="migration"></param>
/// <param name="columnName"></param>
/// <param name="primaryColumnName"></param>
/// <param name="errors"></param>
/// <returns></returns>
public static ICreateTableColumnAsTypeSyntax WithForeignKeyColumn(
this ICreateTableWithColumnSyntax syntax,
string primaryTableName,
MigrationModel migration,
string columnName = null,
string primaryColumnName = null,
params int[] errors)
{
return(syntax.WithForeignKeyColumn(primaryTableName, migration, migration.SchemaPrefixId, columnName, primaryColumnName, errors));
}
public static ICreateTableColumnOptionOrWithColumnSyntax WithColumnForForeignKeyTo <TEntity>(
this ICreateTableWithColumnSyntax tableWithColumnSyntax, string columnName = null, bool nullable = false)
where TEntity : class, IEntity
{
var defaultColumnName = ColumnName.ForeignKeyTo <TEntity>();
var columnDefinition = tableWithColumnSyntax.WithColumn(columnName ?? defaultColumnName).AsInt32();
return(nullable
? columnDefinition.Nullable()
: columnDefinition.NotNullable());
}
/// <summary>
/// Make <paramref name="columnName"/> Nullable
/// </summary>
/// <param name="syntax"></param>
/// <param name="columnName"></param>
/// <returns></returns>
// ReSharper disable once UnusedMember.Global
public static ICreateTableColumnAsTypeSyntax WithNullableColumn(this ICreateTableWithColumnSyntax syntax, string columnName)
{
var column = syntax.WithColumn(columnName);
if (column is CreateTableExpressionBuilder builder)
{
builder.CurrentColumn.IsNullable = true;
}
return(column);
}
WithTimeStamps(this ICreateTableWithColumnSyntax tableWithColumnSyntax)
{
return(tableWithColumnSyntax
.WithColumn("created_at")
.AsDateTime()
.NotNullable()
.WithColumn("modified_at")
.AsDateTime()
.NotNullable());
}
public static ICreateTableWithColumnSyntax CreateBaseNoCreateDate(this ICreateTableWithColumnSyntax create, bool userFK = true)
{
create
.WithColumn("Id")
.AsInt32()
.NotNullable()
.Identity()
.PrimaryKey();
return(create);
}
public static ICreateTableColumnOptionOrWithColumnSyntax WithId(
this ICreateTableWithColumnSyntax table,
string columnName
)
{
return(table
.WithColumn(columnName)
.AsInt32()
.NotNullable()
.PrimaryKey()
.Identity());
}
