private static void OpenDatabase(out PetaPoco.NetCore.Database database, bool useDataSource, string dataSource, string host, int port, bool useWindowsAuthentication, string userName, string password, string dbName)
{
string connectionString = MakeConnectionString(useDataSource, dataSource, host, port, useWindowsAuthentication, userName, password, dbName);
database = new PetaPoco.NetCore.Database(connectionString, "System.Data.SqlClient");
database.OpenSharedConnection();
}
private static void OpenDatabase(out PetaPoco.NetCore.Database database, string server, int port, bool useWindowsAuthentication, string userName, string password, string dbName)
{
string connectionString = MakeConnectionString(server, port, useWindowsAuthentication, userName, password, dbName);
database = new PetaPoco.NetCore.Database(connectionString, "MySql.Data.MySqlClient");
database.OpenSharedConnection();
}
public static void OpenDatabase(out PetaPoco.NetCore.Database database, string host, int port, bool useWindowsAuthentication, string userName, string password, string dbName)
{
string connectionString = MakeConnectionString(host, port, useWindowsAuthentication, userName, password, dbName);
database = new PetaPoco.NetCore.Database(connectionString, "Npgsql");
database.OpenSharedConnection();
}
/// <summary>
/// 配置文件中的数据库连接名
/// </summary>
/// <param name="connectString"> </param>
protected DALBase()
{
var config = new ConfigurationBuilder()
.SetBasePath(Directory.GetCurrentDirectory())
.AddJsonFile("appsettings.json")
.Build();
_connectionString = config.GetConnectionString("DefaultConnection");
db = new PetaPoco.NetCore.Database(new MySqlConnection(_connectionString));
}
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 DatabaseWrapper(PetaPoco.NetCore.Database database)
{
Database = database;
}
/// <summary>
/// 配置文件中的数据库连接名
/// </summary>
/// <param name="connectString"> </param>
protected DALBase(string connectString)
{
db = new PetaPoco.NetCore.Database(new MySqlConnection(connectString));
}
public Table(SqlQueryBuilders.ISqlQueryBuilder iSqlQueryBuilder, PetaPoco.NetCore.Database database, string tableName)
{
_iSqlQueryBuilder = iSqlQueryBuilder;
_database = database;
_tableName = tableName;
}
private static void OpenDatabase(out PetaPoco.NetCore.Database database, string path)
{
database = new PetaPoco.NetCore.Database("Data Source=" + path + ";Version=3;", "System.Data.SQLite");
database.OpenSharedConnection();
}
public AttributeTable(SqlQueryBuilders.ISqlQueryBuilder iSqlQueryBuilder, PetaPoco.NetCore.Database database) : base(iSqlQueryBuilder, database, Database.TableNames.Attribute)
{
}
public SpeciesAttributeSizeTable(SqlQueryBuilders.ISqlQueryBuilder iSqlQueryBuilder, PetaPoco.NetCore.Database database) : base(iSqlQueryBuilder, database, Database.TableNames.SpeciesAttributeSize)
{
}
public KeyTable(SqlQueryBuilders.ISqlQueryBuilder iSqlQueryBuilder, PetaPoco.NetCore.Database database) : base(iSqlQueryBuilder, database, Database.TableNames.Key)
{
}
public QueryManager(PetaPoco.NetCore.Database database)
{
_database = database;
}
public LiteratureTable(SqlQueryBuilders.ISqlQueryBuilder iSqlQueryBuilder, PetaPoco.NetCore.Database database) : base(iSqlQueryBuilder, database, Database.TableNames.Literature)
{
}
