public void VerifyDatabaseTypeName() { // Arrange & Act var database = new PostgreSQLDatabase(); // Assert Assert.Equal("Oqtane.Database.PostgreSQL.PostgreSQLDatabase, Oqtane.Database.PostgreSQL", database.TypeName); }
public static BaseDatabase GetDatabase(Type ownersType) { var retval = new PostgreSQLDatabase( objectsOwner: DATABASE_OBJECTS_OWNER, connectionString: "Pooling=false;" + "CommandTimeout=20;" + // 20 seconds. Corresponds to default value "Server=127.0.0.1;" + "Port=5432;" + "User Id=agorapide;" + // TODO: Do of course not store details like this in source-code. "Password=agorapide;" + // TODO: Instead use a configuration file kept outside of your source-code repository (outside of GitHub) "Database=agorapide", // TODO: In this case database is just for sample purposes so nothing sensitive is exposed. tableName: DATABASE_TABLE_NAME, applicationType: ownersType ); retval.LogEvent += LogFinal; /// Note how <see cref="LogEvent"/> and <see cref="HandledExceptionEvent"/> is deliberately left out of AgoRapide so you may implement your own logging mechanism instead retval.HandledExceptionEvent += LogException; // TODO: Is that a good idea? Why not have them as standard within the AgoRapide-library? return(retval); }
/// <summary> /// Constructor that takes a PostgreSQLDatabase instance. /// </summary> /// <param name="database"></param> public RoleTable(PostgreSQLDatabase database) { _database = database; }
//TODO: Adicionar os campos faltantes para validação de lockout, phonenumber, e two steps authentication /// <summary> /// Construtor que Instancia a base postgresql /// </summary> /// <param name="database"></param> public UserTable(PostgreSQLDatabase database) { _database = database; }
/// <summary> /// Constructor that takes a PostgreSQLDatabase instance. /// </summary> /// <param name="database"></param> public RoleTable(PostgreSQLDatabase database) { _database = database; _userClaimsTable = new UserClaimsTable(database); }
private void _buttonOpenDatabase_Click(object sender, RoutedEventArgs e) { OpenControls.Wpf.Serialisation.RegistryItemSerialiser registryItemSerialiser = new OpenControls.Wpf.Serialisation.RegistryItemSerialiser(_keyPath); OpenControls.Wpf.DatabaseDialogs.Model.DatabaseConfiguration databaseConfiguration = new OpenControls.Wpf.DatabaseDialogs.Model.DatabaseConfiguration(registryItemSerialiser); if (registryItemSerialiser.OpenKey()) { databaseConfiguration.Load(); } OpenControls.Wpf.DatabaseDialogs.ViewModel.OpenDatabaseViewModel openDatabaseViewModel = new OpenControls.Wpf.DatabaseDialogs.ViewModel.OpenDatabaseViewModel(databaseConfiguration); OpenControls.Wpf.DatabaseDialogs.View.OpenDatabaseView openDatabaseView = new OpenControls.Wpf.DatabaseDialogs.View.OpenDatabaseView(new OpenControls.Wpf.DatabaseDialogs.Model.Encryption()); openDatabaseView.DataContext = openDatabaseViewModel; if (openDatabaseView.ShowDialog() != true) { return; } if (!registryItemSerialiser.IsOpen) { registryItemSerialiser.CreateKey(); } databaseConfiguration.Save(); registryItemSerialiser.Close(); try { if (openDatabaseViewModel.SelectedDatabaseProvider == OpenControls.Wpf.DatabaseDialogs.Model.DatabaseProvider.SQLite) { SQLiteDatabase.OpenDatabase(this, openDatabaseViewModel.SQLite_Filename); IDatabaseHost.IConfigurationStore = new DBStore.SQLiteConfigurationStore(IDatabaseHost.Database); IDatabaseHost.ISpeciesStore = new DBStore.SQLiteSpeciesStore(IDatabaseHost.Database); IDatabaseHost.IImagePathsStore = new DBStore.SQLiteImagePathsStore(IDatabaseHost.Database); IDatabaseHost.IImageStore = new DBStore.SQLiteImageStore(IDatabaseHost.Database); } else if (openDatabaseViewModel.SelectedDatabaseProvider == OpenControls.Wpf.DatabaseDialogs.Model.DatabaseProvider.MicrosoftSQLServer) { string server = (openDatabaseViewModel.SqlServerInstances.Count > 0) ? openDatabaseViewModel.SqlServerInstances[openDatabaseViewModel.SelectedSqlServerInstance] : null; SQLServerDatabase.OpenDatabase( this, openDatabaseViewModel.SQLServer_UseLocalServer, server, openDatabaseViewModel.SQLServer_IPAddress, openDatabaseViewModel.SQLServer_Port, openDatabaseViewModel.SQLServer_UseWindowsAuthentication, openDatabaseViewModel.SQLServer_UserName, openDatabaseViewModel.SQLServer_Password, openDatabaseViewModel.SQLServer_DatabaseName); IDatabaseHost.IConfigurationStore = new DBStore.SQLServerConfigurationStore(IDatabaseHost.Database); IDatabaseHost.ISpeciesStore = new DBStore.SQLServerSpeciesStore(IDatabaseHost.Database); IDatabaseHost.IImagePathsStore = new DBStore.SQLServerImagePathsStore(IDatabaseHost.Database); IDatabaseHost.IImageStore = new DBStore.SQLServerImageStore(IDatabaseHost.Database); } else if (openDatabaseViewModel.SelectedDatabaseProvider == OpenControls.Wpf.DatabaseDialogs.Model.DatabaseProvider.PostGreSQL) { PostgreSQLDatabase.OpenDatabase(this, openDatabaseViewModel.PostgreSQL_IPAddress, openDatabaseViewModel.PostgreSQL_Port, openDatabaseViewModel.PostgreSQL_UseWindowsAuthentication, openDatabaseViewModel.PostgreSQL_UserName, openDatabaseViewModel.PostgreSQL_Password, openDatabaseViewModel.PostgreSQL_DatabaseName); IDatabaseHost.IConfigurationStore = new DBStore.PostgreSQLConfigurationStore(IDatabaseHost.Database); IDatabaseHost.ISpeciesStore = new DBStore.PostgreSQLSpeciesStore(IDatabaseHost.Database); IDatabaseHost.IImagePathsStore = new DBStore.PostgreSQLImagePathsStore(IDatabaseHost.Database); IDatabaseHost.IImageStore = new DBStore.PostgreSQLImageStore(IDatabaseHost.Database); } else if (openDatabaseViewModel.SelectedDatabaseProvider == OpenControls.Wpf.DatabaseDialogs.Model.DatabaseProvider.MySQL) { MySQLDatabase.OpenDatabase(this, openDatabaseViewModel.MySQL_IPAddress, openDatabaseViewModel.MySQL_Port, openDatabaseViewModel.MySQL_UseWindowsAuthentication, openDatabaseViewModel.MySQL_UserName, openDatabaseViewModel.MySQL_Password, openDatabaseViewModel.MySQL_DatabaseName); IDatabaseHost.IConfigurationStore = new DBStore.MySQLConfigurationStore(IDatabaseHost.Database); IDatabaseHost.ISpeciesStore = new DBStore.MySQLSpeciesStore(IDatabaseHost.Database); IDatabaseHost.IImagePathsStore = new DBStore.MySQLImagePathsStore(IDatabaseHost.Database); IDatabaseHost.IImageStore = new DBStore.MySQLImageStore(IDatabaseHost.Database); } else { throw new Exception("Unsupported database type"); } } catch (Exception exception) { System.Windows.Forms.MessageBox.Show(exception.Message); return; } ShowSpeciesListView(IDatabaseHost.Database); }
public RoleStore(PostgreSQLDatabase context, IdentityErrorDescriber describer = null) : base(context, describer) { }