void TestLong()
{
Select sel = Qb.Select("*")
.From("tab")
.Where(Cond.Equal("col", DateTime.Now.Ticks));
AnyDbFactory factory = new AnyDbFactory(new AnyDbSetting());
string sql = factory.GetSql(sel);
Update upd = Qb.Update("tab")
.Values(
Value.New("col", DateTime.Now.Ticks)
);
sql = factory.GetSql(upd);
}
void InitDb()
{
if (_factory.Provider == DatabaseProvider.PostgreSql)
{
PgDbSetting ps = new PgDbSetting();
Npgsql.NpgsqlConnectionStringBuilder sb = new Npgsql.NpgsqlConnectionStringBuilder(ps.ConnectionString);
sb.Database = "postgres";
ps.ConnectionString = sb.ToString();
AnyDbFactory f = new AnyDbFactory(ps);
using (AnyDbConnection con = f.OpenConnection())
{
con.Execute("drop database if exists qb_test");
con.Execute("create database qb_test");
}
}
if (_factory.Provider == DatabaseProvider.SqLite)
{
Microsoft.Data.Sqlite.SqliteConnectionStringBuilder sb = new Microsoft.Data.Sqlite.SqliteConnectionStringBuilder(_factory.ConnectionString);
if (File.Exists(sb.DataSource))
{
File.Delete(sb.DataSource);
}
}
using (AnyDbConnection con = _factory.OpenConnection())
{
con.Execute(@"
CREATE TABLE customer (
id serial NOT NULL,
first_name varchar(50) NULL,
last_name varchar(50) NULL,
CONSTRAINT customer_pk PRIMARY KEY (id)
);");
for (int i = 0; i < 100; i++)
{
con.Execute($"insert into customer (first_name, last_name) values ('F_{i}', 'L_{i}')");
}
}
}
public FileDbService(AnyDbFactory factory, ILogger <FileDbService> logger)
{
_factory = factory;
_logger = logger;
}
private DapperTest()
{
_factory = new AnyDbFactory(new PgDbSetting(), new Annonce());
//_factory = new AnyDbFactory(new SqliteDbSetting(), new Annonce());
}
