public SqlEventStore(IMessageQueue messageQueue, ISqlConnectionFactory sqlConnectionFactory, IDapperWrapper dapper, ISqlEventStoreSettings settings)
{
_settings = settings;
_messageQueue = messageQueue;
_sqlConnectionFactory = sqlConnectionFactory;
_dapper = dapper;
}
public LoginUserValidator(IDapperWrapper dapperWrapper)
{
CascadeMode = CascadeMode.Stop;
RuleFor(user => user.Username)
.Must(username => !string.IsNullOrWhiteSpace(username)).WithMessage("Username field must contain a value")
.MustAsync(async(username, cancellation) =>
{
var sql = @"SELECT COUNT(1)
FROM Users
WHERE Username = @username";
return(await dapperWrapper.QuerySingleAsync <bool>(sql, new { username }));
}).WithMessage("Username does not exist!");
;
RuleFor(user => user.Password)
.Must(password => !string.IsNullOrWhiteSpace(password)).WithMessage("Password field must contain a value")
.MustAsync(async(user, password, cancellation) =>
{
var sql = @"SELECT COUNT(1)
FROM Users
WHERE Username = @Username
AND Password = @password";
return(await dapperWrapper.QuerySingleAsync <bool>(sql, new { user.Username, password }));
}).WithMessage("Incorrect Password!");
}
public SaveTest()
{
_writeDbConnection = A.Fake <IDbConnection>();
_transaction = A.Fake <IDbTransaction>();
A.CallTo(() => _writeDbConnection.BeginTransaction()).Returns(_transaction);
var sqlConnectionFactory = A.Fake <ISqlConnectionFactory>();
_dapper = A.Fake <IDapperWrapper>();
A.CallTo(() => sqlConnectionFactory.GetWriteConnection()).Returns(_writeDbConnection);
_eventList = new List <TestEvent> {
new TestEvent {
Id = "12345"
}
};
_messageQueue = A.Fake <IMessageQueue>();
var settings = A.Fake <ISqlEventStoreSettings>();
A.CallTo(() => settings.CommandType).Returns(CommandType.StoredProcedure);
_sqlEventStore = new SqlEventStore(_messageQueue, sqlConnectionFactory, _dapper, settings);
var jsonSerializerSettings = new JsonSerializerSettings {
TypeNameHandling = TypeNameHandling.All
};
_serializedEvent = JsonConvert.SerializeObject(_eventList.First(), jsonSerializerSettings);
}
public QueryLocator(IDapperWrapper dapper, Assembly assembly = null, Type[] ignoreTypes = null)
{
_ignoreTypes = ignoreTypes ?? new Type[0];
_dapper = dapper;
// The default is to look for SQL resources in this assembly
_assembly = assembly ?? Assembly.GetExecutingAssembly();
}
public RegisterUserValidator(IDapperWrapper dapperWrapper, IBrickLinkRequestFactory requestFactory)
{
CascadeMode = CascadeMode.Stop;
RuleFor(user => user.Username)
.Must(username => !string.IsNullOrWhiteSpace(username)).WithMessage("Username field must contain a value")
.MustAsync(async(username, cancellation) =>
{
var sql = @"SELECT COUNT(1)
FROM Users
WHERE Username = @username";
return(!await dapperWrapper.QuerySingleAsync <bool>(sql, new { username }));
}).WithMessage("Username already exists!");
;
RuleFor(user => user.Password)
.Must(password => !string.IsNullOrWhiteSpace(password)).WithMessage("Password field must contain a value");
RuleFor(user => user.ConsumerKey)
.Must(consumerKey => !string.IsNullOrWhiteSpace(consumerKey)).WithMessage("Consumer Key field must contain a value");
RuleFor(user => user.ConsumerSecret)
.Must(consumerSecret => !string.IsNullOrWhiteSpace(consumerSecret)).WithMessage("Consumer Secret field must contain a value");
RuleFor(user => user.TokenValue)
.Must(tokenValue => !string.IsNullOrWhiteSpace(tokenValue)).WithMessage("Token Value field must contain a value");
RuleFor(user => user.TokenSecret)
.Must(tokenSecret => !string.IsNullOrWhiteSpace(tokenSecret)).WithMessage("Token Secret field must contain a value");
RuleFor(user => user)
.MustAsync(async(user, cancellation) =>
{
var response = await requestFactory.GetResponse("orders", user);
JObject json = null;
using (var stream = await response.Content.ReadAsStreamAsync())
{
var reader = new StreamReader(stream, Encoding.UTF8);
string jsonString = reader.ReadToEnd();
json = JObject.Parse(jsonString);
}
var meta = json.SelectToken("meta");
return(meta.Value <int>("code") == 200);
}).WithMessage("Invalid API credentials");
}
public SqlQuery(Type queryType, QueryAttribute attribute, IDapperWrapper dapperWrapper, string commandText = null)
: base(queryType, attribute.QueryName, queryType.Name, attribute.MetricTransformEnum)
{
_dapperWrapper = dapperWrapper;
QueryAttribute = attribute;
if (attribute.MetricPattern != null)
{
MetricPattern = attribute.MetricPattern;
}
// Get the SQL resource from the same assembly as the type, when commandText is not supplied
CommandText = commandText ?? queryType.Assembly.SearchForStringResource(attribute.ResourceName);
// Get a pointer to the correctly typed Query method below with the QueryType as the generic parameter
_genericMethod = typeof(IDatabaseMetric).IsAssignableFrom(queryType)
? _DatabaseMetricQueryMethod.MakeGenericMethod(queryType)
: _QueryMethod.MakeGenericMethod(queryType);
}
public DBProvider(IDbConnection dbconnection, IDapperWrapper dapper, IDBHelper dbHelper)
{
_dbconnection = dbconnection;
_dapper = dapper;
_dbHelper = dbHelper;
}
public LoginRepository(IDapperWrapper dapperWrapper, IValidator <User> validator)
{
_dapperWrapper = dapperWrapper;
_validator = validator;
}
public QueryLocator(IDapperWrapper dapper, Assembly assembly = null)
{
_dapper = dapper;
// The default is to look for SQL resources in this assembly
_assembly = assembly ?? Assembly.GetExecutingAssembly();
}
public ForumRepository(IDapperWrapper dapperWrapper)
{
_dapperWrapper = dapperWrapper;
}
public QueryLocator(IDapperWrapper dapper, Assembly assembly = null)
{
_dapper = dapper;
// The default is to look for SQL resources in this assembly
_assembly = assembly ?? Assembly.GetExecutingAssembly();
}
public StatsRepository(string connectionString, IDapperWrapper dapperWrapper)
{
ConnectionString = connectionString;
_dapperWrapper = dapperWrapper;
}
public OrdersDatabaseInitializer(IDapperWrapper dapperWrapper)
{
_dapperWrapper = dapperWrapper;
}
public DatabaseUpdater(IDapperWrapper dapperWrapper, IOrderRepository orderRepository)
{
_dapperWrapper = dapperWrapper;
_orderRepository = orderRepository;
}
public RegisterRepository(IDapperWrapper dapperWrapper, IValidator <User> validator)
{
_dapperWrapper = dapperWrapper;
_validator = validator;
}
public OrderRepository(IDapperWrapper dapperWrapper)
{
_dapperWrapper = dapperWrapper;
}
