public static void CreateDatabase(out MycoKeyCreator.Library.Database.IDatabase iDatabase, string folder, string dbName)
{
string path = System.IO.Path.Combine(folder, dbName + ".sqlite");
OpenDatabase(out iDatabase, path);
PetaPoco.NetCore.Database database = (iDatabase as DatabaseWrapper).Database;
SqlQueryBuilders.ISqlQueryBuilder iSqlQueryBuilder = (iDatabase as DatabaseWrapper).ISqlQueryBuilder;
// Create each table
iDatabase.CreateTables();
}
public static void CreateDatabase(out MycoKeyCreator.Library.Database.IDatabase iDatabase, string dataSource, bool useWindowsAuthentication, string userName, string password, string folder, string dbName)
{
// Connect to the master DB to create the requested database
OpenDatabase(out PetaPoco.NetCore.Database database, true, dataSource, null, -1, useWindowsAuthentication, userName, password, "master");
SqlQueryBuilders.SqlServerQueryBuilder iSqlQueryBuilder = new SqlQueryBuilders.SqlServerQueryBuilder();
database.Execute(iSqlQueryBuilder.CreateDatabase(folder, dbName));
database.CloseSharedConnection();
// Connect to the new database
OpenDatabase(out database, true, dataSource, null, -1, useWindowsAuthentication, userName, password, dbName);
iDatabase = new DatabaseWrapper(database);
iDatabase.ISqlQueryBuilder = iSqlQueryBuilder;
// Create each table
iDatabase.CreateTables();
}
public static void CreateDatabase(out MycoKeyCreator.Library.Database.IDatabase iDatabase, string server, int port, bool useWindowsAuthentication, string userName, string password, string dbName)
{
// Connect to the master DB to create the requested database
OpenDatabase(out PetaPoco.NetCore.Database database, server, port, useWindowsAuthentication, userName, password, "MySql");
SqlQueryBuilders.MySqlQueryBuilder iSqlQueryBuilder = new SqlQueryBuilders.MySqlQueryBuilder();
database.Execute(@"CREATE DATABASE " + dbName);
database.CloseSharedConnection();
// Connect to the new database
OpenDatabase(out database, server, port, useWindowsAuthentication, userName, password, dbName);
iDatabase = new DatabaseWrapper(database);
iDatabase.ISqlQueryBuilder = iSqlQueryBuilder;
// Create each table
iDatabase.CreateTables();
}
public static void OpenDatabase(out MycoKeyCreator.Library.Database.IDatabase iDatabase, bool useDataSource, string dataSource, string host, int port, bool useWindowsAuthentication, string userName, string password, string dbName)
{
OpenDatabase(out PetaPoco.NetCore.Database database, useDataSource, dataSource, host, port, useWindowsAuthentication, userName, password, dbName);
iDatabase = new DatabaseWrapper(database);
iDatabase.ISqlQueryBuilder = new SqlQueryBuilders.SqlServerQueryBuilder();
}
