protected override void TearDown () { DropTable (); connection.Close(); connection = null; }
protected override void SetUp () { string host = TestSettings.GetString ("HOST"); string connectionString = "HOST=" + host + ";UID=dba;PWD=dba;"; connection = new VirtuosoConnection (connectionString); connection.Open (); }
protected override void SetUp () { string host = TestSettings.GetString ("HOST"); string connectionString = "HOST=" + host + ";UID=dba;PWD=dba;DATABASE=db;"; connection = new VirtuosoConnection (connectionString); connection.Open (); CreateTable (); for (int i = 0; i < NRows; i++) { InsertRow (i); } }
public void State (TestCaseResult result) { string host = TestSettings.GetString ("HOST"); string connectionString = "HOST=" + host + ";UID=dba;PWD=dba;"; VirtuosoConnection conn = new VirtuosoConnection (connectionString); try { result.FailIfNotEqual (ConnectionState.Closed, conn.State); conn.Open (); result.FailIfNotEqual (ConnectionState.Open, conn.State); conn.Close (); result.FailIfNotEqual (ConnectionState.Closed, conn.State); } finally { conn.Dispose (); } }
public void DisposeInvalid (TestCaseResult result) { VirtuosoConnection conn = null; try { string connectionString = "InvalidConnectionString"; conn = new VirtuosoConnection (connectionString); } catch (ArgumentException) { // suppress ArgumentException } finally { if (conn != null) conn.Dispose (); } }
public void Enlist (VirtuosoConnection conn) { conn.EnlistDistributedTransaction ((ITransaction) ContextUtil.Transaction); }
public void DisposeNew (TestCaseResult result) { VirtuosoConnection conn = new VirtuosoConnection (); conn.Dispose (); }
public void PersistSecurityInfo (TestCaseResult result) { string host = TestSettings.GetString ("HOST"); string connectionString = "HOST=" + host + ";UID=dba;PWD=dba;Persist Security Info=true;"; VirtuosoConnection conn = new VirtuosoConnection (connectionString); try { result.FailIfNotEqual (connectionString, conn.ConnectionString); conn.Open (); result.FailIfNotEqual (connectionString, conn.ConnectionString); conn.Close (); result.FailIfNotEqual (connectionString, conn.ConnectionString); } finally { conn.Dispose (); } }
public void OdbcConnectionWithoutPooling (TestCaseResult result) { string host = TestSettings.GetString ("HOST"); string connectionString = "HOST=" + host + ";UID=dba;PWD=dba;Pooling=False;"; VirtuosoConnection conn = new VirtuosoConnection (connectionString); try { conn.Open (); conn.Close (); } finally { conn.Dispose (); } }
public void DoWork (VirtuosoConnection conn, Worker worker) { worker.InsertRow (conn, 3); worker.InsertRow (conn, 4); }
public void DropTable (VirtuosoConnection connection) { VirtuosoCommand drop = connection.CreateCommand (); drop.CommandText = "drop table foo"; try { drop.ExecuteNonQuery(); } catch (Exception) { } finally { drop.Dispose(); } }
/// <summary> /// Creates a Manager for a Virtuoso Native Quad Store /// </summary> /// <param name="connectionString">Connection String</param> /// <remarks> /// Allows the end user to specify a customised connection string /// </remarks> public VirtuosoManager(String connectionString) { this._db = new VirtuosoConnection(); this._db.ConnectionString = connectionString; this._customConnString = true; }
/// <summary> /// Creates a Manager for a Virtuoso Native Quad Store /// </summary> /// <param name="server">Server</param> /// <param name="port">Port</param> /// <param name="db">Database Name</param> /// <param name="user">Username</param> /// <param name="password">Password</param> public VirtuosoManager(String server, int port, String db, String user, String password) { //Set the Connection Properties this._dbserver = server; this._dbname = db; this._dbuser = user; this._dbpwd = password; this._dbport = port; //Create the Connection Object this._db = new VirtuosoConnection(); this._db.ConnectionString = "Server=" + this._dbserver + ":" + this._dbport + ";Database=" + this._dbname + ";uid=" + this._dbuser + ";pwd=" + this._dbpwd + ";Charset=utf-8"; }
public VirtuosoConnection Connect (string connectionString) { VirtuosoConnection connection = new VirtuosoConnection (connectionString); connection.Open (); return connection; }
protected override void SetUp () { string host = TestSettings.GetString ("HOST", "localhost"); string connectionString = "HOST=" + host + ";UID=dba;PWD=dba;"; connection = new VirtuosoConnection (connectionString); connection.Open (); worker = new Worker (); worker.DropTable (connection); worker.CreateTable (connection); }
public void CheckTable (VirtuosoConnection connection, TestCaseResult result) { VirtuosoCommand select = connection.CreateCommand (); select.CommandText = "select * from foo"; VirtuosoDataAdapter adapter = new VirtuosoDataAdapter (); adapter.SelectCommand = (VirtuosoCommand) select; DataSet dataset = new DataSet (); adapter.Fill (dataset); DataTable table = dataset.Tables["Table"]; result.FailIfNotEqual (checkTable.Rows.Count, table.Rows.Count); result.FailIfNotEqual (checkTable.Columns.Count, table.Columns.Count); for (int i = 0; i < table.Rows.Count; i++) { DataRow row = table.Rows[i]; DataRow checkRow = checkTable.Rows[i]; for (int j = 0; j < table.Columns.Count; j++) { string name = table.Columns[j].ColumnName; result.FailIfNotEqual (checkRow[name], row[name]); } } }
public void InsertRow (VirtuosoConnection connection, int i) { string s = new string (new char[3] { (char) ('a' + i), (char) ('b' + i), (char) ('c' + i) }); VirtuosoCommand insert = connection.CreateCommand(); insert.CommandText = "insert into foo values (" + i + ", '" + s + "')"; insert.ExecuteNonQuery(); insert.Dispose(); DataRow row = checkTable.NewRow (); row["id"] = i; row["txt"] = s; checkTable.Rows.Add (row); }
public void CreateTable (VirtuosoConnection connection) { VirtuosoCommand create = connection.CreateCommand (); create.CommandText = "create table foo (id int primary key, txt varchar(100))"; create.ExecuteNonQuery(); create.Dispose(); checkTable = new DataTable (); checkTable.Columns.Add ("id", typeof (int)); checkTable.Columns.Add ("txt", typeof (string)); InsertRow (connection, 1); InsertRow (connection, 2); }
public void UnEnlist (VirtuosoConnection conn) { conn.EnlistDistributedTransaction (null); }
public EngineVirtuoso(string connectionstring, string graph) { this.connection = new OpenLink.Data.Virtuoso.VirtuosoConnection(connectionstring); this.graph = graph; //this.connectionstring = cstring; }