public void DatabaseExistsTest() { ConnectionSetup connectionSetup = new ConnectionSetup(hostName, "", "", true); connectionSetup.Timeout = 1; SQLServerConnector conn = new SQLServerConnector(connectionSetup); Assert.Contains(dbTestName, conn.GetDatabaseNames().ToList()); }
public void NonWindowsLoginTest() { ConnectionSetup connectionSetup = new ConnectionSetup(hostName, "TestUser", "TestPass", false); connectionSetup.Timeout = 1; SQLServerConnector conn = new SQLServerConnector(connectionSetup); Assert.IsNotEmpty(conn.GetDatabaseNames()); }
public void TimeoutTest() { string hostNameDoesntExist = "testest"; ConnectionSetup connectionSetup = new ConnectionSetup(hostNameDoesntExist, "", "", true); connectionSetup.Timeout = 1; SQLServerConnector conn = new SQLServerConnector(connectionSetup); conn.GetDatabaseNames(); }
public void Connect(string ip) { try { connector = new SQLServerConnector("http://" + ip + ":8080/CarTickets/DBSrv"); } catch (Exception e) { throw e; } }
public void ColumnsExistsTest() { ConnectionSetup connectionSetup = new ConnectionSetup(hostName, "", "", true); connectionSetup.Timeout = 1; SQLServerConnector conn = new SQLServerConnector(connectionSetup); Database db = conn.GetDatabase(dbTestName); DBTable personTable = db.Tables.Where(t => t.Name == "Person").First(); string[] columnNames = personTable.Columns.Select(c => c.Name).ToArray(); Assert.Contains("p_id", columnNames); Assert.Contains("FirstName", columnNames); Assert.Contains("LastName", columnNames); Assert.Contains("a_id", columnNames); }
public void TablesExistsTest() { ConnectionSetup connectionSetup = new ConnectionSetup(hostName, "", "", true); connectionSetup.Timeout = 1; SQLServerConnector conn = new SQLServerConnector(connectionSetup); Database db = conn.GetDatabase(dbTestName); string[] tableNames = db.Tables.Select(t => t.Name).ToArray(); Assert.AreEqual(4, db.Tables.Count); Assert.Contains("Address", tableNames); Assert.Contains("Person", tableNames); Assert.Contains("ContactInfo", tableNames); Assert.Contains("ContactInfoType", tableNames); }
public ImportConfiguration Load() { ImportConfiguration config = null; using (XmlReader reader = XmlReader.Create(filePath)) { ConnectionSetup connectionSetup = readConnectionSetup(reader); string databaseName = readDatabaseName(reader); ErrorHandling errorHandling = readErrorHandling(reader); SQLServerConnector dbConnector = new SQLServerConnector(connectionSetup); Database database = dbConnector.GetDatabase(databaseName); TableMapping[] tableMappings = readTableMappings(reader, database); config = new ImportConfiguration(tableMappings, connectionSetup, databaseName, errorHandling); } return(config); }
public SQLServerConnectionAdapter(SQLServerDatabase sql) { connection = SQLServerConnector.GetConnection(sql); }