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()); }