public void NotificationQueries_UpsertTest()
{
//параметры
Exception exception;
var logger = new ShoutExceptionLogger();
var target = new NotificationQueries(logger
, SignaloBotTestParameters.ConnectionString, SignaloBotTestParameters.SqlPrefix);
Notification notify = NotificationsTestCommonCreator.CreateNotification();
List<NotificationMeta> notifyMetas = new List<NotificationMeta>()
{
NotificationsTestCommonCreator.CreateNotificationMeta(notify.NotificationID),
NotificationsTestCommonCreator.CreateNotificationMeta(notify.NotificationID, "AuthorName"),
};
List<Guid> userIDs = new List<Guid>()
{
SignaloBotTestParameters.ExistingUserID,
SequentialGuid.NewGuid(),
SequentialGuid.NewGuid(),
SequentialGuid.NewGuid()
};
//проверка
target.Upsert(notify, notifyMetas, userIDs, out exception);
}
public void NotificationQueries_UpdateDirtyTest()
{
//параметры
Exception exception;
var logger = new ShoutExceptionLogger();
NotificationQueries target = new NotificationQueries(logger
, SignaloBotTestParameters.ConnectionString, SignaloBotTestParameters.SqlPrefix);
int total;
List<Notification> notifies = target.SelectUpdateLastVisit(SignaloBotTestParameters.ExistingUserID
, false, out total, 0, 10, out exception);
//проверка
target.UpdateDirty(notifies, out exception);
}
//инициализация
public NotificationManagerSettings(ICommonLogger logger, string connectionStringOrName, string sqlPrefix = null)
{
NotificationQueries = new NotificationQueries(logger, connectionStringOrName, sqlPrefix);
NotificationMetaQueries = new NotificationMetaQueries(logger, connectionStringOrName, sqlPrefix);
}
public void NotificationQueries_SelectUpdateLastVisitTest()
{
//параметры
Exception exception;
var logger = new ShoutExceptionLogger();
NotificationQueries target = new NotificationQueries(logger
, SignaloBotTestParameters.ConnectionString, SignaloBotTestParameters.SqlPrefix);
int firstIndex = 1;
int lastIndex = 10;
bool updateLastVisit = true;
int total;
//проверка
List<Notification> notifies = target.SelectUpdateLastVisit(SignaloBotTestParameters.ExistingUserID
, updateLastVisit, out total, firstIndex, lastIndex, out exception);
}
public void NotificationQueries_DeleteTagTest()
{
//параметры
Exception exception;
var logger = new ShoutExceptionLogger();
NotificationQueries target = new NotificationQueries(logger
, SignaloBotTestParameters.ConnectionString, SignaloBotTestParameters.SqlPrefix);
//проверка
target.DeleteTag(SignaloBotTestParameters.ExistingUserID, SignaloBotTestParameters.ExistingCategoryID
, "tag", out exception);
}