private static void SetupSQLServerCeConnection() { var uri = new Uri(Path.GetDirectoryName(Assembly.GetExecutingAssembly().GetName().CodeBase) ?? ""); var databaseFile = Path.Combine(uri.LocalPath, "sqlserverce-testdb.sdf"); var databaseConfig = new DatabaseConfig(DatabaseConfig.SqlServerCe, "", databaseFile, "", "", null); DatabaseConnection.CurrentConnection = databaseConfig.GetDatabaseConnection(); }
public void SetupFixture() { DatabaseConfig databaseConfig = new DatabaseConfig("Mysql", "localhost", "habanero_temp", "root", "root", "3306"); IDatabaseConnection databaseConnection = databaseConfig.GetDatabaseConnection(); _setupDatabase = new SetupDatabase(databaseConnection); _setupDatabase.ClearDatabase(); }
public Migrator(DatabaseConfig databaseConfig) { _databaseConfig = databaseConfig; NamespaceContainingMigrations = "Habanero.Test.Migrations"; AssemblyContainingMigrations = Assembly.GetExecutingAssembly(); MigrationProcessorFactory = GetMigrationProcessorFactory(databaseConfig); Announcer = new TextWriterAnnouncer(s => System.Diagnostics.Debug.WriteLine(s)); _databaseInitialiser = new DatabaseInitialiser(databaseConfig); }
public void TestDatabaseConfigAlternateConstructor() { DatabaseConfig d = new DatabaseConfig(DatabaseConfig.MySql, "a", "b", "c", "d", "e"); Assert.AreEqual(DatabaseConfig.MySql, d.Vendor); Assert.AreEqual("a", d.Server); Assert.AreEqual("b", d.Database); Assert.AreEqual("c", d.UserName); Assert.AreEqual("d", d.Password); Assert.AreEqual("e", d.Port); }
public void TestDatabaseConfigSettings() { DatabaseConfig d = new DatabaseConfig(settingsMySql); Assert.AreEqual(DatabaseConfig.MySql, d.Vendor); Assert.AreEqual("b", d.Server); Assert.AreEqual("c", d.Database); Assert.AreEqual("d", d.UserName); Assert.AreEqual("e", d.Password); Assert.AreEqual("f", d.Port); }
public void TestCreateConnectionFireBird() { //---------------Set up test pack------------------- DatabaseConfig config = new DatabaseConfig(DatabaseConfig.Firebird, "test", "test", "test", "test", "1000"); //---------------Execute Test ---------------------- IDatabaseConnection connection = new DatabaseConnectionFactory().CreateConnection(config); IDbConnection dbConnection = connection.GetConnection(); //---------------Test Result ----------------------- Assert.AreEqual("FirebirdSql.Data.FirebirdClient", dbConnection.GetType().Namespace); }
public void TestCreateConnectionSqlServer() { //---------------Set up test pack------------------- DatabaseConfig config = new DatabaseConfig(DatabaseConfig.SqlServer, "test", "test", "test", "test", "1000"); //---------------Execute Test ---------------------- IDatabaseConnection connection = new DatabaseConnectionFactory().CreateConnection(config); IDbConnection dbConnection = connection.GetConnection(); //---------------Test Result ----------------------- Assert.AreEqual("System.Data.SqlClient", dbConnection.GetType().Namespace); }
public void SetupTestFixture() { var config = new DatabaseConfig(DatabaseConfig.SqlServer, "test", "test", "test", "test", "1000"); _connection = new DatabaseConnectionFactory().CreateConnection(config); _testStatement = new SqlStatement(_connection); _rawStatement = "insert into tb1 (field1, field2, field3) values (@Param1, @Param2, @Param3)"; _testStatement.Statement.Append(_rawStatement); _addedParameter = _testStatement.AddParameter("Param1", "12345"); _testStatement.AddParameter("Param2", "67890"); _testStatement.AddParameter("Param3", "13579"); _command = _connection.GetConnection().CreateCommand(); _testStatement.SetupCommand(_command); }
public static DatabaseConfig GetDatabaseConfig() { IDictionary settings = new Hashtable(); settings.Add("vendor", DatabaseConfig.MySql); settings.Add("server", "localhost"); settings.Add("database", "habanero_test_trunk"); settings.Add("username", "root"); settings.Add("password", "root"); settings.Add("port", "3306"); DatabaseConfig config = new DatabaseConfig(settings); return config; }
public void Setup() { encryptedConfig = new DatabaseConfig(DatabaseConfig.MySql, "a", "b", "c", encryptedPassword, "e"); }
public void TestToStringEncryptedPassword() { encryptedConfig.SetPrivateKey(rsa.ToXmlString(true)); DatabaseConfig d2 = new DatabaseConfig(DatabaseConfig.MySql, "a", "b", "c", encryptedPassword, "e"); Assert.AreEqual(d2.ToString(), encryptedConfig.ToString()); }
public void TestUsingDatabaseConfigMySql() { DatabaseConfig config = new DatabaseConfig(settingsMySql); String connectString = new ConnectionStringMySqlFactory().GetConnectionString("b", "c", "d", "e", "f"); Assert.AreEqual(connectString, config.GetConnectionString(), "ConnectionStringFactory not working for MySql using ConfigData"); }
private static void SetupSQLServerConnection() { var databaseConfig = new DatabaseConfig("SqlServer", "localhost", "habanero_test_trunk", "sa", "sa", null); //var databaseConfig = new DatabaseConfig("SqlServer", @"localhost\sqlexpress", "habanero_test_branch_2_6", "sa", "sa", null); DatabaseConnection.CurrentConnection = databaseConfig.GetDatabaseConnection(); }
private static void EnsureDatabaseMigrated(DatabaseConfig databaseConfig) { var migrator = new Migrator(databaseConfig); migrator.EnsureDatabseExists(); migrator.MigrateToLatest(); }
public void TestUsingCustomAssembly() { //---------------Set up test pack------------------- DatabaseConfig config = new DatabaseConfig(DatabaseConfig.Oracle, "test", "test", "test", "test", "1000"); config.AssemblyName = "System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"; config.FullClassName = "System.Data.SqlClient.SqlConnection"; //---------------Execute Test ---------------------- IDatabaseConnection connection = new DatabaseConnectionFactory().CreateConnection(config); IDbConnection dbConnection = connection.GetConnection(); //---------------Test Result ----------------------- Assert.AreEqual("System.Data.SqlClient", dbConnection.GetType().Namespace); StringAssert.Contains("System.Data, ", dbConnection.GetType().Assembly.FullName); StringAssert.Contains(", Culture=neutral, PublicKeyToken=b77a5c561934e089", dbConnection.GetType().Assembly.FullName); //---------------Tear Down ------------------------- }
public void TestCreateConnectionPostgreSql() { //---------------Set up test pack------------------- DatabaseConfig config = new DatabaseConfig(DatabaseConfig.PostgreSql, "test", "test", "test", "test", "1000"); //---------------Execute Test ---------------------- IDatabaseConnection connection = new DatabaseConnectionFactory().CreateConnection(config); IDbConnection dbConnection = connection.GetConnection(); //---------------Test Result ----------------------- Assert.AreEqual("Npgsql", dbConnection.GetType().Namespace); }
public void SetupTestFixture() { var config = new DatabaseConfig(DatabaseConfig.SqlServer, "test", "test", "test", "test", "1000"); _connection = new DatabaseConnectionFactory().CreateConnection(config); }
/// <summary> /// Sets up the database connection. If not provided, then /// reads the connection from the config file. /// </summary> protected override void SetupDatabaseConnection() { if (DatabaseConnection.CurrentConnection != null) return; if (_databaseConfig == null) _databaseConfig = DatabaseConfig.ReadFromConfigFile(); string vendor = _databaseConfig.Vendor; if (string.IsNullOrEmpty(vendor) || vendor.ToLower().Contains("memory")) { BORegistry.DataAccessor = new DataAccessorInMemory(); } else { if (_privateKey != null) _databaseConfig.SetPrivateKey(_privateKey); DatabaseConnection.CurrentConnection = _databaseConfig.GetDatabaseConnection(); BORegistry.DataAccessor = new DataAccessorDB(); } }
protected internal DatabaseConfig Clone() { var databaseConfig = new DatabaseConfig(Vendor, Server, Database, UserName, Password, Port); databaseConfig._passwordCrypter = _passwordCrypter; databaseConfig.AssemblyName = AssemblyName; databaseConfig.FullClassName = FullClassName; databaseConfig.ConnectionStringFactoryAssemblyName = ConnectionStringFactoryAssemblyName; databaseConfig.ConnectionStringFactoryClassName = ConnectionStringFactoryClassName; return databaseConfig; }
public void Test_CreateSqlFormatter_AlternateConstructor_SQLite() { //---------------Set up test pack------------------- string connectionString = new DatabaseConfig(DatabaseConfig.SqlServer, "test", "test", "test", "test", "1000").GetConnectionString (); IDatabaseConnection dbConn = new DatabaseConnectionSQLite ("System.Data", "System.Data.SqlClient.SqlConnection", connectionString); //---------------Assert Precondition---------------- //---------------Execute Test ---------------------- ISqlFormatter defaultSqlFormatter = dbConn.SqlFormatter; //---------------Test Result ----------------------- Assert.IsInstanceOf(typeof(SqlFormatter), defaultSqlFormatter); SqlFormatter sqlFormatter = (SqlFormatter)defaultSqlFormatter; Assert.IsNotNull(sqlFormatter); Assert.AreEqual("\"", sqlFormatter.LeftFieldDelimiter); Assert.AreEqual("\"", sqlFormatter.RightFieldDelimiter); Assert.AreEqual("", sqlFormatter.LimitClauseAtBeginning); Assert.AreEqual("limit", sqlFormatter.LimitClauseAtEnd); Assert.AreEqual(sqlFormatter.LeftFieldDelimiter, dbConn.LeftFieldDelimiter); Assert.AreEqual(sqlFormatter.RightFieldDelimiter, dbConn.RightFieldDelimiter); // StringAssert.Contains(sqlFormatter.LimitClauseAtBeginning, dbConn.GetLimitClauseForBeginning(1)); // StringAssert.Contains(sqlFormatter.LimitClauseAtEnd, dbConn.GetLimitClauseForEnd(1)); }
public DatabaseInitialiser(DatabaseConfig databaseConfig) { _databaseConfig = databaseConfig; }