private static void CreateDB()
{
if (TfSettings.Database.CreateDB)
{
var connectionString = TfSettings.Database.DefaultConnectionString;
var dbName = TfSettings.Database.DatabaseName;
var param = ConnectProvider.Param();
var query = new Query(
connectionString,
$"{Operations.SELECT} COUNT('datname') FROM pg_catalog.pg_database where datname = {param}dbName;",
new Dictionary <string, object>()
{
{ "dbName", dbName }
});
if (query.GetScalar() > 0)
{
return;
}
var userId = TfSettings.Database.UserId;
var encoding = TfSettings.Database.Encoding;
var nonQuery = new NonQuery(
connectionString,
$"{Operations.CREATE_DATABASE.GetString()} {dbName} WITH OWNER = {userId} ENCODING = '{encoding}';",
null);
nonQuery.ExecuteNonQuery(Operations.CREATE_DATABASE);
}
}
private int ExecuteNonQuery(string sql, Dictionary <string, object> parameters, Operations operations)
{
if (this.NonQuery == null)
{
var nonQuery = new NonQuery(sql, parameters)
{
TableName = this.TableName
};
return(nonQuery.ExecuteNonQuery(operations));
}
else
{
this.NonQuery.WriteSql(sql, parameters);
return(this.NonQuery.ExecuteNonQuery(operations));
}
}