public static void ResetUsers(OrmLiteAuthRepository authRepo)
{
authRepo.DropAndReCreateTables();
CreateUser(authRepo, 1, "test", "test", new List<string> { "TheRole" }, new List<string> { "ThePermission" });
CreateUser(authRepo, 2, "test2", "test2");
}
public void CreateUsers(Container container)
{
var userRep = new OrmLiteAuthRepository(container.Resolve<IDbConnectionFactory>());
userRep.DropAndReCreateTables();
container.Register<IUserAuthRepository>(userRep);
var appSettings = container.Resolve<PlacesToVisitAppSettings>();
var dataRepository = container.Resolve<IPlacesToVisitRepository>();
userRep.DropAndReCreateTables();
string pwHash;
string pwSalt;
new SaltedHash().GetHashAndSaltString(
appSettings.Get("Salt", "debugSalt"),
out pwHash,
out pwSalt);
var userAuth1 = userRep.CreateUserAuth(new UserAuth
{
Email = "*****@*****.**",
DisplayName = "Darren",
UserName = "******",
FirstName = "Darren",
LastName = "Reid",
PasswordHash = pwHash,
Salt = pwSalt,
Roles = {"Admin"}
}, "abc123");
var user1 = userAuth1.ConvertTo<User>();
dataRepository.CreateUserIfNotExists(user1);
var userAuth2 = userRep.CreateUserAuth(new UserAuth
{
Email = "*****@*****.**",
DisplayName = "Kyle",
UserName = "******",
FirstName = "Kyle",
LastName = "Hodgson",
PasswordHash = pwHash,
Salt = pwSalt,
Roles = {"Admin"}
}, "123abc");
var user2 = userAuth2.ConvertTo<User>();
dataRepository.CreateUserIfNotExists(user2);
}
public override IUserAuthRepository CreateAuthRepo()
{
var connStr = @"Server={0};Database=test;User Id=test;Password=test;".Fmt(Environment.GetEnvironmentVariable("CI_HOST"));
var sqlServerFactory = new OrmLiteConnectionFactory(connStr, SqlServerDialect.Provider);
var sqlServerRepo = new OrmLiteAuthRepository(sqlServerFactory);
InitTest(sqlServerRepo);
sqlServerRepo.DropAndReCreateTables();
return sqlServerRepo;
}
private static void ResetAll(Container container, OrmLiteAuthRepository authRepo)
{
authRepo.DropAndReCreateTables();
using (var db = container.Resolve<IDbConnectionFactory>().Open())
{
db.DropAndCreateTable<EmailRegistration>();
db.DropAndCreateTable<SMessageReceipt>();
}
container.Resolve<IRedisClientsManager>().Exec(r => r.FlushAll());
}
private void CreateAuthDb(Container container) {
var db = container.Resolve<ICredentialsDbConnectionFactory>();
var repo = new OrmLiteAuthRepository(db);
repo.DropAndReCreateTables();
var admin_user = repo.CreateUserAuth(new UserAuth {
UserName = "******",
Email = "*****@*****.**",
}, "password");
repo.SaveUserAuth(admin_user);
}
private void CreateAuthDb(Container container) {
var db = container.Resolve<ICredentialsDbConnectionFactory>();
var repo = new OrmLiteAuthRepository(db);
repo.DropAndReCreateTables();
var userauth = repo.CreateUserAuth(new UserAuth
{
UserName = "******",
Email = "*****@*****.**"
}, "password");
repo.SaveUserAuth(userauth);
repo.AssignRoles(userauth, new [] { RoleNames.Admin });
}
public void SetUp()
{
try
{
tests = new OAuthUserSessionTests();
appHost = new BasicAppHost().Init();
var inMemoryRepo = new InMemoryAuthRepository();
inMemoryRepo.Clear();
userAuthRepositorys.Add(inMemoryRepo);
var appSettings = new AppSettings();
var redisRepo = new RedisAuthRepository(new BasicRedisClientManager(new[] { appSettings.GetString("Redis.Host") ?? "localhost" }));
redisRepo.Clear();
userAuthRepositorys.Add(redisRepo);
if (OAuthUserSessionTestsBase.UseSqlServer)
{
var connStr = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\App_Data\auth.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
var sqlServerFactory = new OrmLiteConnectionFactory(connStr, SqlServerOrmLiteDialectProvider.Instance);
var sqlServerRepo = new OrmLiteAuthRepository(sqlServerFactory);
sqlServerRepo.DropAndReCreateTables();
}
else
{
var sqliteInMemoryRepo = new OrmLiteAuthRepository(dbFactory);
sqliteInMemoryRepo.InitSchema();
sqliteInMemoryRepo.Clear();
userAuthRepositorys.Add(sqliteInMemoryRepo);
var sqliteDbFactory = new OrmLiteConnectionFactory(
"~/App_Data/auth.sqlite".MapProjectPath());
var sqliteDbRepo = new OrmLiteAuthRepository(sqliteDbFactory);
sqliteDbRepo.InitSchema();
userAuthRepositorys.Add(sqliteDbRepo);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw;
}
}
public static void Main()
{
const string adminName = "Administrator";
const string adminPassword = "******";
const string userName = "******";
const string userPassword = "******";
var recreateAuthTables = ConfigurationManager.AppSettings["RecreateAuthTables"];
var dbConnectionFactory = new OrmLiteConnectionFactory(ConfigurationManager.ConnectionStrings["AuthDB"].ConnectionString, SqlServerDialect.Provider);
_authRepository = new OrmLiteAuthRepository(dbConnectionFactory);
if ("true".Equals(recreateAuthTables, StringComparison.CurrentCultureIgnoreCase))
{
_authRepository.DropAndReCreateTables(); //Drop and re-create all Auth and registration tables
CreateUser(1, adminName, "*****@*****.**", adminPassword, new List<string> {"Admin"}, new List<string> {"Administrator"});
CreateUser(2, userName, null, userPassword, new List<string> { "TheRole" }, new List<string> { "ThePermission" });
}
else
{
_authRepository.InitSchema(); //Create only the missing tables
}
}
public static void Setup_Test_Database(IDbConnectionFactory appDbFactory = null, IDbConnectionFactory authDbFactory = null)
{
var appDbConnectionFactory = appDbFactory;
var authDbConnectionFactory = authDbFactory;
if (appDbConnectionFactory == null)
{
var connectionString = ConfigurationManager.ConnectionStrings["AppDb"].ConnectionString;
appDbConnectionFactory = new OrmLiteConnectionFactory(connectionString, SqlServerDialect.Provider);
}
if (authDbConnectionFactory == null)
{
var connectionString = ConfigurationManager.ConnectionStrings["AuthDb"].ConnectionString;
authDbConnectionFactory = new OrmLiteConnectionFactory(connectionString, SqlServerDialect.Provider);
}
using (var db = appDbConnectionFactory.OpenDbConnection())
{
if (db.TableExists("Transaction")) db.DropTable<Transaction>();
if (db.TableExists("CurrencyType")) db.DropTable<CurrencyType>();
if (db.TableExists("TransactionStatusType")) db.DropTable<TransactionStatusType>();
if (db.TableExists("TransactionNotificationStatusType")) db.DropTable<TransactionNotificationStatusType>();
if (db.TableExists("TransactionType")) db.DropTable<TransactionType>();
db.CreateTable<TransactionType>();
db.CreateTable<TransactionNotificationStatusType>();
db.CreateTable<TransactionStatusType>();
db.CreateTable<CurrencyType>();
db.CreateTable<Transaction>();
db.Insert(new TransactionType {Id = (long) TRANSACTION_TYPE.AuthorizeAndCapture, Description = "Authorize and Capture"});
db.Insert(new TransactionType {Id = (long) TRANSACTION_TYPE.AuthorizeOnly, Description = "Authorize Only"});
db.Insert(new TransactionType {Id = (long) TRANSACTION_TYPE.CapturePrior, Description = "Capture Prior Authorization"});
db.Insert(new TransactionType {Id = (long) TRANSACTION_TYPE.Refund, Description = "Refund"});
db.Insert(new TransactionType {Id = (long) TRANSACTION_TYPE.Void, Description = "Void"});
db.Insert(new TransactionType {Id = (long) TRANSACTION_TYPE.ZeroDollar, Description = "An internal zero dollar transaction"});
db.Insert(new TransactionType {Id = (long) TRANSACTION_TYPE.Unknown, Description = "The transaction type is unknown"});
db.Insert(new TransactionNotificationStatusType {Id = (long) TRANSACTION_NOTIFICATION_STATUS.None, Status = "Processing"});
db.Insert(new TransactionNotificationStatusType {Id = (long) TRANSACTION_NOTIFICATION_STATUS.DeclinedNotification, Status = "Declined Notification Sent"});
db.Insert(new TransactionNotificationStatusType {Id = (long) TRANSACTION_NOTIFICATION_STATUS.ErrorNotification, Status = "Error Notifications Sent"});
db.Insert(new TransactionNotificationStatusType {Id = (long) TRANSACTION_NOTIFICATION_STATUS.SettledNotification, Status = "Settled Notifications Sent"});
db.Insert(new TransactionNotificationStatusType {Id = (long) TRANSACTION_NOTIFICATION_STATUS.RefundedNotification, Status = "Refunded Notifications Sent"});
db.Insert(new TransactionNotificationStatusType {Id = (long) TRANSACTION_NOTIFICATION_STATUS.VoidedNotification, Status = "Voided Notifications Sent"});
db.Insert(new TransactionStatusType {Id = (long) TRANSACTION_STATUS.Pending, Status = "Transaction Approved but pending completion"});
db.Insert(new TransactionStatusType {Id = (long) TRANSACTION_STATUS.Settled, Status = "Transaction completed. Funds received."});
db.Insert(new TransactionStatusType {Id = (long) TRANSACTION_STATUS.Refunded, Status = "Transaction completed. Customer refunded."});
db.Insert(new TransactionStatusType {Id = (long) TRANSACTION_STATUS.Voided, Status = "Transaction voided."});
db.Insert(new TransactionStatusType {Id = (long) TRANSACTION_STATUS.Expired, Status = "Transaction has expired."});
db.Insert(new TransactionStatusType {Id = (long) TRANSACTION_STATUS.Declined, Status = "Transaction Declinded.", IsErrorStatus = true});
db.Insert(new TransactionStatusType {Id = (long) TRANSACTION_STATUS.Error, Status = "Transaction Error.", IsErrorStatus = true});
db.Insert(new CurrencyType {Id = (long) CURRENCY_TYPE.USDollar, Description = "US Dollar", Code = "USD", Symbol = "$"});
db.Insert(new CurrencyType {Id = (long) CURRENCY_TYPE.CandianDollar, Description = "Canadian Dollar", Code = "CAD", Symbol = "$"});
db.Insert(new CurrencyType {Id = (long) CURRENCY_TYPE.Peso, Description = "Mexican Peso", Code = "MXN", Symbol = "$"});
}
var userRepo = new OrmLiteAuthRepository(authDbConnectionFactory);
userRepo.DropAndReCreateTables();
var defaultAdmin = new UserAuth
{
DisplayName = DefaultAdmin.Email,
Email = DefaultAdmin.Email,
Roles = DefaultAdmin.Roles,
Permissions = DefaultAdmin.Permissions
};
CreateUser(userRepo, defaultAdmin, DefaultAdmin.Password);
var testUser = new UserAuth
{
DisplayName = TestUser.FirstName + " " + TestUser.LastName,
Email = TestUser.Email,
FirstName = TestUser.FirstName,
LastName = TestUser.LastName,
Roles = TestUser.Roles,
Permissions = TestUser.Permissions
};
CreateUser(userRepo, testUser, TestUser.Password);
}
