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