public void PqsqlCopyFromTest6() { PqsqlTransaction tran = null; PqsqlCopyFrom copy = null; try { tran = mConnection.BeginTransaction(); mCmd.Transaction = tran; copy = new PqsqlCopyFrom(mConnection) { CopyTimeout = 5 }; copy.Start(); Assert.Fail(); } finally { copy?.Dispose(); tran?.Dispose(); } }
public void PqsqlCopyFromTest7() { PqsqlTransaction tran = null; PqsqlCopyFrom copy = null; try { tran = mConnection.BeginTransaction(); mCmd.Transaction = tran; mCmd.CommandText = "CREATE TEMP TABLE temp (id int4, val int4, txt text)"; mCmd.CommandTimeout = 200; mCmd.CommandType = CommandType.Text; int q = mCmd.ExecuteNonQuery(); Assert.AreEqual(0, q); copy = new PqsqlCopyFrom(mConnection) { Table = "temp", CopyTimeout = 5 }; copy.WriteInt4(42); // write without Start() copy.WriteInt4(42); // write without Start() copy.WriteText("42"); // write without Start() copy.End(); copy.Close(); Assert.Fail(); } finally { copy?.Dispose(); tran?.Dispose(); } }
public void PqsqlCopyFromTest4() { PqsqlTransaction tran = null; PqsqlCopyFrom copy = null; try { tran = mConnection.BeginTransaction(); mCmd.Transaction = tran; mCmd.CommandText = "CREATE TEMP TABLE temp (id int4, val int4, txt text)"; mCmd.CommandTimeout = 200; mCmd.CommandType = CommandType.Text; int q = mCmd.ExecuteNonQuery(); Assert.AreEqual(0, q); copy = new PqsqlCopyFrom(mConnection) { Table = "temp", CopyTimeout = 1 }; copy.Start(); System.Threading.Thread.Sleep(1500); copy.End(); Assert.Fail(); } finally { copy?.Dispose(); tran?.Dispose(); } }
public void PqsqlCopyFromTest9() { PqsqlTransaction tran = null; PqsqlCopyFrom copy = null; try { tran = mConnection.BeginTransaction(); mCmd.Transaction = tran; mCmd.CommandText = "CREATE TEMP TABLE temp (col timestamp)"; mCmd.CommandTimeout = 200; mCmd.CommandType = CommandType.Text; int q = mCmd.ExecuteNonQuery(); Assert.AreEqual(0, q); copy = new PqsqlCopyFrom(mConnection) { Table = "temp", CopyTimeout = 5 }; copy.Start(); copy.WriteDate(DateTime.UtcNow); copy.End(); copy.Close(); Assert.Fail(); } finally { copy?.Dispose(); tran?.Dispose(); } }