public static SqlFuConnection GetDb(bool noLog = false, DbEngine engine = DbEngine.SqlServer)
{
var cnx = Connex;
switch (engine)
{
case DbEngine.SQLite:
DirectoryInfo dd = new DirectoryInfo(AppDomain.CurrentDomain.BaseDirectory);
var f = dd.Parent.Parent.FullName;
cnx = string.Format(SqliteConnex, Path.Combine(f, "testdb.db"));
//cnx = SqliteConnex;
break;
case DbEngine.MySql:
cnx = MysqlConnex;
break;
case DbEngine.PostgreSQL:
cnx = PostgresConnex;
break;
}
var d = new SqlFuConnection(cnx, engine);
return(d);
}
public UpdateTableTests()
{
_sb = new StringBuilder();
_w = new ExpressionWriter(_sb, new SqlServerBuilderHelper());
_db = Setup.GetDb();
_builder = new UpdateTableBuilder <Post>(_db);
}
public CommonDDLWriter(SqlFuConnection db, DbEngine engine)
{
db.MustNotBeNull();
Db = db;
Builder = new StringBuilder();
_engine = engine;
}
public AlterTableColumnTests()
{
_db = Setup.GetDb();
_writer = new SqlServerDDLWriter(_db);
_table = new ModifyTableBuilder(_db, _writer, "users");
SetupTestTable();
}
public CommonDDLWriter(SqlFuConnection db, DbEngine engine)
{
db.MustNotBeNull();
Db = db;
Builder = new StringBuilder();
_engine = engine;
}
public IDatabaseTools GetTools(SqlFuConnection db)
{
if (_tools == null)
{
_tools = InitTools(db);
}
return(_tools);
}
public IDatabaseTools GetTools(SqlFuConnection db)
{
if (_tools == null)
{
_tools = InitTools(db);
}
return _tools;
}
public void sqlfu_using_another_dbconnection()
{
var conex = new SqlConnection(Setup.Connex);
using (var db = new SqlFuConnection(conex, DbEngine.SqlServer))
{
Assert.True(db.TableExists <Post>());
}
}
public override void Execute(SqlFuConnection db)
{
var tbl = db.DatabaseTools.GetCreateTableBuilder("PlopTable", IfTableExists.Ignore);
tbl.Columns
.Add("Id", DbType.Int32, isNullable: false, autoIncrement: true).AsPrimaryKey()
.Add("PlopField", DbType.String, "50")
.Add("AddField", DbType.String, "50")
.Add("SomeTime", DbType.DateTime, isNullable: false);
tbl.ExecuteDDL();
}
public static void RunMigrations(string connectionString)
{
using (var db = new SqlFuConnection(connectionString))
{
DatabaseMigration <SqlFuConnection>
.ConfigureFor(db)
.SearchAssemblyOf <SqlFuMigration1>()
.WithAutomaticMigrationRepository(new SqlFuAutomaticMigrationRepo(db))
.WithUnitOfWorkCreator(new DatabaseTransactionManager())
.PerformAutomaticMigrations();
}
}
public PostgresqlDDLWriter(SqlFuConnection db)
: base(db, DbEngine.PostgreSQL)
{
}
protected override IDatabaseTools InitTools(SqlFuConnection db)
{
return new SqlServerCompactDatabaseTools(db);
}
public EscapeSqlTests()
{
_db = Config.GetDb();
}
public SqlServerCompactDatabaseTools(SqlFuConnection db) : base(db)
{
}
public MySqlDDLWriter(SqlFuConnection db) : base(db, DbEngine.MySql)
{
}
public MysqlDatabaseTools(SqlFuConnection db) : base(db)
{
}
public CreateTableTests()
{
db = Db;
_ddl = new SqlServerDDLWriter(db);
db.DatabaseTools.DropTable("test");
}
public MysqlDatabaseTools(SqlFuConnection db) : base(db)
{
}
public QueryTests()
{
_db = Config.GetDb();
}
protected override IDatabaseTools InitTools(SqlFuConnection db)
{
return(new SqlServerCompactDatabaseTools(db));
}
public MysqlDropConstraintWriter(StringBuilder builder, SqlFuConnection db)
: base(builder, DbEngine.MySql, db.DatabaseTools)
{
db.MustNotBeNull();
_db = db;
}
public QueriesWithMultiPocoMapper()
{
_db = Config.GetDb();
}
protected override IDatabaseTools InitTools(SqlFuConnection db)
{
return new PostgresDatabaseTools(db);
}
public SqlServerDatabaseTools(SqlFuConnection db) : base(db)
{
}
public SqliteDDLWriter(SqlFuConnection db)
: base(db, DbEngine.SQLite)
{
ColonBeforeConstraints = true;
}
public MysqlDropConstraintWriter(StringBuilder builder, SqlFuConnection db)
: base(builder, DbEngine.MySql, db.DatabaseTools)
{
db.MustNotBeNull();
_db = db;
}
public ComplexTypeMapper()
{
_db = Config.GetDb();
}
protected abstract IDatabaseTools InitTools(SqlFuConnection db);
public SqlServerCompactModifiedColumnsWriter(StringBuilder builder, SqlFuConnection db)
{
Builder = builder;
Db = db;
}
public SqliteDatabaseTools(SqlFuConnection db)
: base(db)
{
}
public SqliteDDLWriter(SqlFuConnection db)
: base(db, DbEngine.SQLite)
{
ColonBeforeConstraints = true;
}
public CommonCreateTableTests()
{
Db = Setup.GetDb(engine: Engine);
SetupTable();
}
public HelpersTests()
{
_db = Config.GetDb();
Config.EnsurePosts();
}
public PostgresDatabaseTools(SqlFuConnection db) : base(db)
{
}
public SqlFuTests()
{
_db = new SqlFuConnection(Config.Connex, DbEngine.SqlServer);
}
public SqlServerDDLWriter(SqlFuConnection db) : base(db, DbEngine.SqlServer)
{
}
public CommonAlterTableTests()
{
Db = Setup.GetDb(engine: Engine);
SetupTable();
Table = Db.DatabaseTools.GetAlterTableBuilder(TableName);
}
//public static void Benchmark(Stopwatch timer,Action bench,string name,bool warm=false)
//{
// var nr = warm ? WarmUp : Iterations;
// timer.Restart();
// for (int i = 0; i < nr; i++) bench();
// timer.Stop();
// if (!warm) Console.WriteLine("{0} took {1} ms",name,timer.Elapsed.TotalMilliseconds);
//}
public static SqlFuConnection GetDb()
{
var d = new SqlFuConnection(Connex, DbEngine.SqlServer);
return(d);
}
public PostgresDatabaseTools(SqlFuConnection db) : base(db)
{
}
public MySqlDDLWriter(SqlFuConnection db) : base(db, DbEngine.MySql)
{
}
protected override IDatabaseTools InitTools(SqlFuConnection db)
{
return new MysqlDatabaseTools(db);
}
public SqliteDatabaseTools(SqlFuConnection db)
: base(db)
{
}
public GenerateSqlFromExpressionsTests()
{
_db = Setup.GetDb();
_db.CreateTable <Pool>();
}
public DbExtrensionsMethodsTests()
{
_db = Config.GetDb();
Config.EnsurePosts();
}
protected override IDatabaseTools InitTools(SqlFuConnection db)
{
return(new MysqlDatabaseTools(db));
}
public SqlServerDDLWriter(SqlFuConnection db) : base(db, DbEngine.SqlServer)
{
}
