public void TestCreateParameterNameGenerator() { //---------------Set up test pack------------------- IDatabaseConnection databaseConnection = new DatabaseConnectionFirebird("", ""); //---------------Assert PreConditions--------------- //---------------Execute Test ---------------------- IParameterNameGenerator generator = databaseConnection.CreateParameterNameGenerator(); //---------------Test Result ----------------------- Assert.AreEqual("@", generator.PrefixCharacter); //---------------Tear Down ------------------------- }
public void Test_CreateCustomConnectionString() { //---------------Set up test pack------------------- string connectString = ""; DatabaseConnection databaseConnection = new DatabaseConnectionFirebird("", "", connectString); //---------------Assert Precondition---------------- //---------------Execute Test ---------------------- string setConnectionString = databaseConnection.ConnectionString; //---------------Test Result ----------------------- Assert.AreEqual(setConnectionString, connectString); }
public void TestSqlFormatter() { //---------------Set up test pack------------------- DatabaseConnection databaseConnection = new DatabaseConnectionFirebird("", ""); //---------------Assert Precondition---------------- //---------------Execute Test ---------------------- ISqlFormatter defaultSqlFormatter = databaseConnection.SqlFormatter; //---------------Test Result ----------------------- Assert.IsInstanceOf(typeof(SqlFormatter), defaultSqlFormatter); SqlFormatter formatter = (SqlFormatter)defaultSqlFormatter; Assert.AreEqual("", formatter.LeftFieldDelimiter); Assert.AreEqual("", formatter.RightFieldDelimiter); Assert.AreEqual("FIRST", formatter.LimitClauseAtBeginning); Assert.AreEqual("", formatter.LimitClauseAtEnd); }
private static string CreateTemporaryFirebirdDatabase() { var databaseFile = Path.GetTempFileName(); File.Delete(databaseFile); var conn = new DatabaseConnectionFirebird("FirebirdSql.Data.FirebirdClient", "FirebirdSql.Data.FirebirdClient.FbConnection"); File.Delete(databaseFile); conn.ConnectionString = CreateFirebirdEmbeddedConnectionStringFor(databaseFile); TestUsingDatabase.WriteOutFirebirdEmbeddedLibrariesToCurrentDirectory(); var concrete = conn.GetConnection(); var creatorMethod = concrete.GetType().GetMethods().Where(mi => { if (mi.Name != "CreateDatabase") return false; var parameters = mi.GetParameters(); if (parameters.Length != 2) return false; if (parameters[0].Name != "connectionString") return false; if (parameters[0].ParameterType != typeof (string)) return false; if (parameters[1].Name != "overwrite") return false; if (parameters[1].ParameterType != typeof (bool)) return false; return true; }).FirstOrDefault(); creatorMethod.Invoke(conn, new object[] {conn.ConnectionString, true}); return databaseFile; }
public void Test_CreateSqlFormatter_AlternateConstructor_Firebird() { //---------------Set up test pack------------------- string connectionString = new DatabaseConfig(DatabaseConfig.SqlServer, "test", "test", "test", "test", "1000").GetConnectionString (); IDatabaseConnection dbConn = new DatabaseConnectionFirebird ("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("FIRST", sqlFormatter.LimitClauseAtBeginning); Assert.AreEqual("", 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 void Test_IsolationLevel_Firebird() { //---------------Execute Test ---------------------- DatabaseConnection conn = new DatabaseConnectionFirebird("FirebirdSql.Data.FirebirdClient", "FirebirdSql.Data.FirebirdClient.FbConnection"); //---------------Test Result ----------------------- Assert.AreEqual(IsolationLevel.RepeatableRead, conn.IsolationLevel); }
public void Test_CreateDatabaseConnection_Firebird() { DatabaseConnection conn = new DatabaseConnectionFirebird ("FirebirdSql.Data.FirebirdClient", "FirebirdSql.Data.FirebirdClient.FbConnection"); conn.ConnectionString = new DatabaseConfig (DatabaseConfig.Firebird, "testserver", "testdatabase", "testusername", "testpassword", "3050"). GetConnectionString(); Assert.AreEqual ("FirebirdSql.Data.FirebirdClient", conn.TestConnection.GetType().Namespace, "Namespace of firebird connection is wrong."); }
public void Test_CreateSqlFormatter_Firebird() { //---------------Set up test pack------------------- IDatabaseConnection dbConn = new DatabaseConnectionFirebird("System.Data", "System.Data.SqlClient.SqlConnection"); //---------------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("FIRST", sqlFormatter.LimitClauseAtBeginning); Assert.AreEqual("", sqlFormatter.LimitClauseAtEnd); Assert.AreEqual(sqlFormatter.LeftFieldDelimiter, dbConn.LeftFieldDelimiter); Assert.AreEqual(sqlFormatter.RightFieldDelimiter, dbConn.RightFieldDelimiter); }