public VoteMap()
{
// nhibernate doesn't support multiple unique key on the same column
Id(x => x.Id).GeneratedBy.GuidComb();
References(x => x.User)
//.UniqueKey("uq_VotesUserDocument")
//.UniqueKey("uq_VotesUserAnswer")
//.UniqueKey("uq_VotesUserQuestion")
.Column("UserId").Not.Nullable().ForeignKey("Votes_User");
References(x => x.Document)
//.UniqueKey("uq_VotesUserDocument")
.Column("DocumentId").Nullable().ForeignKey("Votes_Document");
//References(x => x.Answer)
// //.UniqueKey("uq_VotesUserAnswer")
// .Column("AnswerId").Nullable().ForeignKey("Votes_Answer");
//References(x => x.Question)
// //.UniqueKey("uq_VotesUserQuestion")
// .Column("QuestionId").Nullable().ForeignKey("Votes_Question");
Map(x => x.VoteType).CustomType <VoteType>().Not.Nullable();
Component(x => x.TimeStamp);
SchemaAction.Validate();
}
public override void Down(SchemaAction schema)
{
schema.RenameTable("t_reservations", "t_reservation");
schema.ChangeTable("t_users", t =>
{
t.RenameColumn("enum_profile_user", "enum_profile_users");
});
schema.ChangeTable("t_clients", t =>
{
t.RenameColumn("enum_profile_client", "enum_profile_clients");
});
schema.ChangeTable("t_preferences", t =>
{
t.RenameColumn("id_category", "id_categories");
});
schema.ChangeTable("t_itens", t =>
{
t.RenameColumn("id_movie", "id_movies");
});
schema.ChangeTable("t_sales", t =>
{
t.RenameColumn("enum_status_sale", "enum_status_sales");
});
}
public UniversityMap()
{
DynamicUpdate();
Id(x => x.Id).GeneratedBy.GuidComb();
Map(x => x.Name).UniqueKey("uq_UniversityNameCountry");
Map(x => x.Extra);
Map(x => x.UsersCount);
Map(x => x.Image).Column("ImageUrl");
Map(x => x.Country).Not.Nullable().Length(2).UniqueKey("uq_UniversityNameCountry");
Component(x => x.RowDetail);
//HasMany(x => x.Documents)
// .ReadOnly()
// .Access.CamelCaseField(Prefix.Underscore)
// .Cascade.None();
//HasMany(x => x.Questions)
// .ReadOnly()
// .Access.CamelCaseField(Prefix.Underscore).Cascade.None();
//HasMany(x => x.Users)
// .ReadOnly()
// .Access.CamelCaseField(Prefix.Underscore).Cascade.None();
Map(x => x.State).CustomType <GenericEnumStringType <ItemState> >().Not.Nullable();
SchemaAction.Validate();
}
public void SchemaAction(SchemaAction action)
{
CustomizersHolder.AddCustomizer(typeof(TEntity), (IJoinedSubclassAttributesMapper m) => m.SchemaAction(action));
}
public static bool IncludeAction(SchemaAction actionsSource, SchemaAction includedAction);
public DefaultConfiguration(SchemaAction schemaAction)
{
this.schemaAction = schemaAction;
}
public void CustomShouldHaveCorrectValue()
{
SchemaAction.Custom("a,b").ToString().ShouldEqual("a,b");
}
public static bool Has(this SchemaAction source, SchemaAction value)
{
return((source & value) == value);
}
public void SchemaAction(SchemaAction action)
{
CustomizersHolder.AddCustomizer(typeof(TEntity), (IClassMapper m) => m.SchemaAction(action));
}
public static bool Has(this SchemaAction source, SchemaAction value)
{
return (source & value) == value;
}
public override void Down(SchemaAction schema)
{
//schema.RemoveTable("books");
}
private static void BuildSchema(Configuration config, string connectionStringName, SchemaAction action, bool execute)
{
if ((action & SchemaAction.Drop) == SchemaAction.Drop) {}
if ((action & SchemaAction.Update) == SchemaAction.Update) {
new SchemaUpdate(config).Execute(true, execute);
}
if ((action & SchemaAction.Export) == SchemaAction.Export) {
new SchemaExport(config)
.SetOutputFile(connectionStringName + "schema.sql")
.Create(false, execute);
}
if ((action & SchemaAction.Validate) == SchemaAction.Validate) {
new SchemaValidator(config).Validate();
}
}
public bool Equals(SchemaAction other)
{
return(Equals(other.value, value));
}
private void ExecuteSchemaAction(
SchemaAction schemaAction,
IDatabaseSchema databaseSchema)
{
schemaActionDictionary[schemaAction](databaseSchema);
}
public void SchemaAction(SchemaAction action)
{
classMapping.schemaaction = action.ToSchemaActionString();
}
public DefaultConfiguration(SchemaAction schemaAction)
{
this.schemaAction = schemaAction;
}
public ViewConversationMap()
{
Id(x => x.Id);
Map(x => x.LastMessage);
Map(x => x.UserName);
Map(x => x.UserPhoneNumber);
Map(x => x.UserEmail);
Map(x => x.UserId);
Map(x => x.TutorName);
Map(x => x.TutorPhoneNumber);
Map(x => x.TutorEmail);
Map(x => x.TutorId);
Map(x => x.Status).CustomType <EnumerationType <ChatRoomStatus> >();
Map(x => x.AssignTo);
Map(x => x.RequestFor);
Map(x => x.ConversationStatus);
Map(x => x.StudyRoomExists);
Map(x => x.HoursFromLastMessage);
Map(x => x.Country);
SchemaAction.Validate();
Table("vAdminConversation");
ReadOnly();
/*
* alter VIEW [sb].[vAdminConversation]
*
* as
* with cte as (
* Select
* cr.Id ,
* cra.status2 as status,
* cra.AssignTo,
* cr.Identifier ,
* cr.UpdateTime as lastMessage,
* u.id as userId,
* u.Name,
* u.Email,
* u.PhoneNumberHash,
* CONCAT(l.CourseId, ' ', l.Text) as RequestFor,
* case when (select top 1 UserId from sb.ChatMessage cm where cm.ChatRoomId = cr.id ) = cu.userid then 0 else 1 end as isTutor
*
* from sb.ChatUser cu
* join sb.ChatRoom cr on cu.ChatRoomId = cr.Id
* left join sb.ChatRoomAdmin cra
* on cr.Id = cra.Id
* join sb.[user] u on cu.UserId = u.Id
* left join sb.Lead l on cra.LeadId = l.Id
* )
* select c.Identifier as id,
* c.lastMessage as lastMessage,
* c.Name as UserName,
* c.PhoneNumberHash as UserPhoneNumber,
* c.Email as UserEmail,
* c.userId as UserId,
* d.Name as TutorName,
* d.PhoneNumberHash as TutorPhoneNumber,
* d.Email as TutorEmail,
* d.UserId as TutorId,
* c.status,
* c.AssignTo,
* c.RequestFor,
* (SELECT max (grp) FROM
* (
* SELECT *, COUNT(isstart) OVER( PARTITION BY ChatRoomId ORDER BY Id ROWS UNBOUNDED PRECEDING) AS grp
* FROM (
* SELECT *,
* CASE WHEN ABS(UserId - LAG(UserId) OVER(PARTITION BY ChatRoomId ORDER BY Id)) <= 1 THEN NULL ELSE 1 END AS isstart
* FROM sb.ChatMessage
* where ChatRoomId = c.id
* ) t1
* ) t2) as conversationStatus,
* case when (Select id from sb.StudyRoom where Identifier = c.Identifier) is null then 0 else 1 end as studyRoomExists,
* datediff(HOUR, c.lastMessage, GETUTCDATE()) as HoursFromLastMessage
* from cte c
* inner join cte d on d.id = c.id and c.isTutor = 0 and d.isTutor = 1
*/
}
public static string ToSchemaActionString(this SchemaAction source)
{
return(source == SchemaAction.All ? null : string.Join(",", source.SchemaActionDefinitions().ToArray()));
}
public override void Down(SchemaAction schema)
{
schema.RemoveTable("t_movies");
}
public void SchemaAction(SchemaAction action)
{
classMapping.schemaaction = action.ToSchemaActionString();
}
private void ExecuteSchemaAction(
SchemaAction schemaAction,
IDatabaseSchema databaseSchema)
{
schemaActionDictionary[schemaAction](databaseSchema);
}
