public async Task PostgresQueryTested(IPostgresQuery query, string name, string id)
{
var dt = DateTime.Now;
query.ConnectionString = connectionString;
var clsName = query.GetType().Name;
Log.Information($"Running {clsName}.Run({name}, true)");
var ret = await query.Run(name, true);
Assert.True(ret > 0);
Log.Information($"Running {clsName}.Run({id})");
ret = await query.Run(id);
Assert.True(ret == 1);
}
public static async Task <IPostgresEntity> ExecuteAsync(IPostgresQuery service, IPostgresEntity queryData, Postgres setting)
{
IPostgresEntity result;
using (NpgsqlConnection conn = new NpgsqlConnection(
"Server=" + setting.Host +
";Port=" + setting.Port +
";User ID=" + setting.UserId +
";Database=" + setting.DatabaseName +
";Password="******";Enlist=true"))
{
//PostgreSQLへ接続
await conn.OpenAsync();
result = service.QueryStart(conn, queryData);
await conn.CloseAsync();
}
return(result);
}
