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); }