public PqsqlCopyFrom(PqsqlConnection conn)
: base(conn)
{
mColBuf = IntPtr.Zero;
mExpBuf = PqsqlWrapper.createPQExpBuffer();
mPos = 0;
}
public PqsqlLargeObject(PqsqlConnection conn)
{
#if CODECONTRACTS
Contract.Requires <ArgumentNullException>(conn != null);
#else
if (conn == null)
{
throw new ArgumentNullException(nameof(conn));
}
#endif
// All large object manipulation using these functions must take place within an SQL transaction block,
// since large object file descriptors are only valid for the duration of a transaction.
// https://www.postgresql.org/docs/current/static/lo-interfaces.html
PGTransactionStatusType transactionStatus = conn.TransactionStatus;
if (transactionStatus != PGTransactionStatusType.PQTRANS_INTRANS &&
transactionStatus != PGTransactionStatusType.PQTRANS_ACTIVE)
{
throw new PqsqlException("PqsqlLargeObject manipulation must take place within an SQL transaction");
}
mConn = conn;
mPGConn = conn.PGConnection;
if (mPGConn == IntPtr.Zero)
{
throw new ArgumentNullException("PqsqlConnection is closed: " + mConn.GetErrorMessage());
}
mOid = 0;
mFd = -1;
mMode = 0;
mPos = -1;
}
protected PqsqlCopyBase(PqsqlConnection conn)
{
mConn = conn;
mRowInfo = null;
mColumns = 0;
}
public PqsqlCopyTo(PqsqlConnection conn)
: base(conn)
{
if (conn == null)
{
throw new ArgumentNullException(nameof(conn));
}
mPGConn = conn.PGConnection;
mBufferPtr = Marshal.AllocHGlobal(sizeof(IntPtr));
*((IntPtr *)mBufferPtr) = IntPtr.Zero;
}
public PqsqlDataAdapter(string selectCommandText, PqsqlConnection selectConnection)
{
PqsqlCommand cmd = null;
try
{
cmd = new PqsqlCommand(selectCommandText, selectConnection);
SelectCommand = cmd;
cmd = null;
}
finally
{
cmd?.Dispose();
}
}
//
// Summary:
// Releases the unmanaged resources used by the System.Data.Common.DbTransaction
// and optionally releases the managed resources.
//
// Parameters:
// disposing:
// If true, this method releases all resources held by any managed objects that
// this System.Data.Common.DbTransaction references.
protected override void Dispose(bool disposing)
{
if (mDisposed)
{
return;
}
if (disposing)
{
SaveTransaction(false); // send rollback if we are in a transaction
mConn = null;
}
base.Dispose(disposing);
mDisposed = true;
}
protected override void Dispose(bool disposing)
{
if (mDisposed)
{
return;
}
if (disposing)
{
// give up references to transaction and connection
mTransaction = null;
mConn = null;
}
base.Dispose(disposing);
mDisposed = true;
}
private void Dispose(bool disposing)
{
if (mDisposed)
{
return;
}
if (disposing)
{
mConn = null; // do not close connection
}
// always release mColBuf and mExpBuf (must not throw exception)
Close();
mDisposed = true;
}
internal PqsqlTransaction(PqsqlConnection conn, IsolationLevel isolationLevel)
{
#if CODECONTRACTS
Contract.Requires <ArgumentNullException>(conn != null);
Contract.Requires <ArgumentException>(isolationLevel != IsolationLevel.Chaos);
#else
if (conn == null)
{
throw new ArgumentNullException(nameof(conn));
}
if (isolationLevel == IsolationLevel.Chaos)
{
throw new ArgumentException("unsupported isolation level", nameof(isolationLevel));
}
#endif
switch (isolationLevel)
{
case IsolationLevel.ReadCommitted:
case IsolationLevel.Unspecified:
isolationLevel = IsolationLevel.ReadCommitted;
TransactionStart = mBeginReadCommitted;
break;
case IsolationLevel.RepeatableRead:
TransactionStart = mBeginRepeatableRead;
break;
case IsolationLevel.Serializable:
case IsolationLevel.Snapshot:
TransactionStart = mBeginSerializable;
break;
case IsolationLevel.ReadUncommitted:
TransactionStart = mBeginReadUncommitted;
break;
}
Connection = conn;
mIsolationLevel = isolationLevel;
}
public PqsqlDataAdapter(string selectCommandText, string selectConnectionString)
{
#if CODECONTRACTS
Contract.Requires <ArgumentNullException>(selectCommandText != null);
Contract.Requires <ArgumentNullException>(selectConnectionString != null);
#else
if (selectCommandText == null)
{
throw new ArgumentNullException(nameof(selectCommandText));
}
if (selectConnectionString == null)
{
throw new ArgumentNullException(nameof(selectConnectionString));
}
#endif
PqsqlConnection conn = null;
PqsqlCommand cmd = null;
try
{
conn = new PqsqlConnection(selectConnectionString);
// ReSharper disable once UseObjectOrCollectionInitializer
cmd = new PqsqlCommand();
cmd.CommandText = selectCommandText;
cmd.Connection = conn;
SelectCommand = cmd;
cmd = null;
conn = null;
}
finally
{
cmd?.Dispose();
conn?.Dispose();
}
}
public PqsqlCommand(string query, PqsqlConnection conn)
{
Init(query);
mParams = new PqsqlParameterCollection();
mConn = conn;
}
public PqsqlCommand(PqsqlConnection conn)
: this(string.Empty, conn)
{
}
