public void Notice()
{
using (var conn = OpenConnection())
{
// Make sure messages are in English
conn.ExecuteNonQuery(@"SET lc_messages='en_US.UTF8'");
conn.ExecuteNonQuery(@"
CREATE OR REPLACE FUNCTION pg_temp.emit_notice() RETURNS VOID AS
'BEGIN RAISE NOTICE ''testnotice''; END;'
LANGUAGE 'plpgsql';
");
PostgresNotice notice = null;
NoticeEventHandler action = (sender, args) => notice = args.Notice;
conn.Notice += action;
try
{
conn.ExecuteNonQuery("SELECT pg_temp.emit_notice()::TEXT"); // See docs for CreateSleepCommand
Assert.That(notice, Is.Not.Null, "No notice was emitted");
Assert.That(notice.MessageText, Is.EqualTo("testnotice"));
Assert.That(notice.Severity, Is.EqualTo("NOTICE"));
}
finally
{
conn.Notice -= action;
}
}
}
private void Init()
{
NoticeDelegate = new NoticeEventHandler(OnNotice);
NotificationDelegate = new NotificationEventHandler(OnNotification);
promotable = new NpgsqlPromotableSinglePhaseNotification(this);
}
public void Notice()
{
// Make sure messages are in English
ExecuteNonQuery(@"SET lc_messages='English_United States.1252'");
ExecuteNonQuery(@"
CREATE OR REPLACE FUNCTION emit_notice() RETURNS VOID AS
'BEGIN RAISE NOTICE ''testnotice''; END;'
LANGUAGE 'plpgsql';
");
NpgsqlNotice notice = null;
NoticeEventHandler action = (sender, args) => notice = args.Notice;
Conn.Notice += action;
try
{
ExecuteNonQuery("SELECT emit_notice()::TEXT"); // See docs for CreateSleepCommand
Assert.That(notice, Is.Not.Null, "No notice was emitted");
Assert.That(notice.MessageText, Is.EqualTo("testnotice"));
Assert.That(notice.Severity, Is.EqualTo("NOTICE"));
}
finally
{
Conn.Notice -= action;
}
}
/// <summary>
/// Initializes a new instance of the
/// <see cref="Npgsql.NpgsqlConnection">NpgsqlConnection</see> class
/// and sets the <see cref="Npgsql.NpgsqlConnection.ConnectionString">ConnectionString</see>.
/// </summary>
/// <param name="ConnectionString">The connection used to open the PostgreSQL database.</param>
public NpgsqlConnection(String ConnectionString)
{
NpgsqlEventLog.LogMethodEnter(LogLevel.Debug, CLASSNAME, CLASSNAME, "NpgsqlConnection()");
NpgsqlConnectionStringBuilder builder = cache[ConnectionString];
if (builder == null)
{
settings = new NpgsqlConnectionStringBuilder(ConnectionString);
}
else
{
settings = builder.Clone();
}
LogConnectionString();
NoticeDelegate = new NoticeEventHandler(OnNotice);
NotificationDelegate = new NotificationEventHandler(OnNotification);
ProvideClientCertificatesCallbackDelegate = new ProvideClientCertificatesCallback(DefaultProvideClientCertificatesCallback);
// Fix authentication problems. See https://bugzilla.novell.com/show_bug.cgi?id=MONO77559 and
// http://pgfoundry.org/forum/message.php?msg_id=1002377 for more info.
RSACryptoServiceProvider.UseMachineKeyStore = true;
promotable = new NpgsqlPromotableSinglePhaseNotification(this);
}
/// <summary>
/// Initializes a new instance of the
/// <see cref="Npgsql.NpgsqlConnection">NpgsqlConnection</see> class
/// and sets the <see cref="Npgsql.NpgsqlConnection.ConnectionString">ConnectionString</see>.
/// </summary>
/// <param name="ConnectionString">The connection used to open the PostgreSQL database.</param>
public NpgsqlConnection(String ConnectionString)
{
NpgsqlEventLog.LogMethodEnter(LogLevel.Debug, CLASSNAME, CLASSNAME, "NpgsqlConnection()");
connection_string = NpgsqlConnectionString.ParseConnectionString(ConnectionString);
LogConnectionString();
NoticeDelegate = new NoticeEventHandler(OnNotice);
NotificationDelegate = new NotificationEventHandler(OnNotification);
CertificateValidationCallbackDelegate = new CertificateValidationCallback(DefaultCertificateValidationCallback);
CertificateSelectionCallbackDelegate = new CertificateSelectionCallback(DefaultCertificateSelectionCallback);
PrivateKeySelectionCallbackDelegate = new PrivateKeySelectionCallback(DefaultPrivateKeySelectionCallback);
}
private void Init()
{
NoticeDelegate = new NoticeEventHandler(OnNotice);
NotificationDelegate = new NotificationEventHandler(OnNotification);
ProvideClientCertificatesCallbackDelegate = new ProvideClientCertificatesCallback(DefaultProvideClientCertificatesCallback);
CertificateValidationCallbackDelegate = new CertificateValidationCallback(DefaultCertificateValidationCallback);
CertificateSelectionCallbackDelegate = new CertificateSelectionCallback(DefaultCertificateSelectionCallback);
PrivateKeySelectionCallbackDelegate = new PrivateKeySelectionCallback(DefaultPrivateKeySelectionCallback);
ValidateRemoteCertificateCallbackDelegate = new ValidateRemoteCertificateCallback(DefaultValidateRemoteCertificateCallback);
// Fix authentication problems. See https://bugzilla.novell.com/show_bug.cgi?id=MONO77559 and
// http://pgfoundry.org/forum/message.php?msg_id=1002377 for more info.
RSACryptoServiceProvider.UseMachineKeyStore = true;
promotable = new NpgsqlPromotableSinglePhaseNotification(this);
}
/// <summary>
/// Initializes a new instance of the
/// <see cref="Npgsql.NpgsqlConnection">NpgsqlConnection</see> class
/// and sets the <see cref="Npgsql.NpgsqlConnection.ConnectionString">ConnectionString</see>.
/// </summary>
/// <param name="ConnectionString">The connection used to open the PostgreSQL database.</param>
public NpgsqlConnection(String ConnectionString)
{
NpgsqlEventLog.LogMethodEnter(LogLevel.Debug, CLASSNAME, CLASSNAME, "NpgsqlConnection()");
LoadConnectionStringBuilder(ConnectionString);
NoticeDelegate = new NoticeEventHandler(OnNotice);
NotificationDelegate = new NotificationEventHandler(OnNotification);
ProvideClientCertificatesCallbackDelegate = new ProvideClientCertificatesCallback(DefaultProvideClientCertificatesCallback);
CertificateValidationCallbackDelegate = new CertificateValidationCallback(DefaultCertificateValidationCallback);
CertificateSelectionCallbackDelegate = new CertificateSelectionCallback(DefaultCertificateSelectionCallback);
PrivateKeySelectionCallbackDelegate = new PrivateKeySelectionCallback(DefaultPrivateKeySelectionCallback);
ValidateRemoteCertificateCallbackDelegate = new ValidateRemoteCertificateCallback(DefaultValidateRemoteCertificateCallback);
// Fix authentication problems. See https://bugzilla.novell.com/show_bug.cgi?id=MONO77559 and
// http://pgfoundry.org/forum/message.php?msg_id=1002377 for more info.
RSACryptoServiceProvider.UseMachineKeyStore = true;
promotable = new NpgsqlPromotableSinglePhaseNotification(this);
}
public void FunctionCallStringEscape()
{
int warnings = 0;
NoticeEventHandler countWarn = delegate(Object c, NpgsqlNoticeEventArgs e) { warnings += 1; };
Conn.Notice += countWarn;
var testStrPar = "This string has a 'literal' backslash \\";
var command = new NpgsqlCommand("trim", Conn);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new NpgsqlParameter());
command.Parameters[0].NpgsqlDbType = NpgsqlDbType.Varchar;
command.Parameters[0].Value = testStrPar;
try //the next command will fail on earlier postgres versions, but that is not a bug in itself.
{
new NpgsqlCommand("set escape_string_warning=on", Conn).ExecuteNonQuery();
new NpgsqlCommand("set standard_conforming_strings=off", Conn).ExecuteNonQuery();
} catch {
}
using (IDataReader rdr = command.ExecuteReader()) {
rdr.Read();
Assert.AreEqual(testStrPar, rdr.GetString(0));
}
try //the next command will fail on earlier postgres versions, but that is not a bug in itself.
{
new NpgsqlCommand("set standard_conforming_strings=on", Conn).ExecuteNonQuery();
} catch {
}
using (IDataReader rdr = command.ExecuteReader()) {
rdr.Read();
Assert.AreEqual(testStrPar, rdr.GetString(0));
}
Conn.Notice -= countWarn;
Assert.AreEqual(0, warnings);
}
public void Notice()
{
if (Environment.GetEnvironmentVariable("TRAVIS") != null)
{
Assert.Ignore("Test mysteriously fails on Travis only");
}
using (var conn = OpenConnection())
{
// Make sure messages are in English
conn.ExecuteNonQuery(@"SET lc_messages='en_US.UTF8'");
conn.ExecuteNonQuery(@"
CREATE OR REPLACE FUNCTION pg_temp.emit_notice() RETURNS VOID AS
'BEGIN RAISE NOTICE ''testnotice''; END;'
LANGUAGE 'plpgsql';
");
var mre = new ManualResetEvent(false);
PostgresNotice notice = null;
NoticeEventHandler action = (sender, args) =>
{
notice = args.Notice;
mre.Set();
};
conn.Notice += action;
try
{
conn.ExecuteNonQuery("SELECT pg_temp.emit_notice()::TEXT"); // See docs for CreateSleepCommand
mre.WaitOne(5000);
Assert.That(notice, Is.Not.Null, "No notice was emitted");
Assert.That(notice.MessageText, Is.EqualTo("testnotice"));
Assert.That(notice.Severity, Is.EqualTo("NOTICE"));
}
finally
{
conn.Notice -= action;
}
}
}
public void Notice()
{
ExecuteNonQuery(@"
CREATE OR REPLACE FUNCTION emit_notice() RETURNS VOID AS
'BEGIN RAISE NOTICE ''testnotice''; END;'
LANGUAGE 'plpgsql';
");
NpgsqlNotice notice = null;
NoticeEventHandler action = (sender, args) => notice = args.Notice;
Conn.Notice += action;
try
{
ExecuteNonQuery("SELECT emit_notice()");
Assert.That(notice, Is.Not.Null, "No notice was emitted");
Assert.That(notice.MessageText, Is.EqualTo("testnotice"));
Assert.That(notice.Severity, Is.EqualTo(ErrorSeverity.Notice));
}
finally
{
Conn.Notice -= action;
}
}
private void Init()
{
NoticeDelegate = new NoticeEventHandler(OnNotice);
NotificationDelegate = new NotificationEventHandler(OnNotification);
ProvideClientCertificatesCallbackDelegate = new ProvideClientCertificatesCallback(DefaultProvideClientCertificatesCallback);
CertificateValidationCallbackDelegate = new CertificateValidationCallback(DefaultCertificateValidationCallback);
CertificateSelectionCallbackDelegate = new CertificateSelectionCallback(DefaultCertificateSelectionCallback);
PrivateKeySelectionCallbackDelegate = new PrivateKeySelectionCallback(DefaultPrivateKeySelectionCallback);
ValidateRemoteCertificateCallbackDelegate = new ValidateRemoteCertificateCallback(DefaultValidateRemoteCertificateCallback);
// Fix authentication problems. See https://bugzilla.novell.com/show_bug.cgi?id=MONO77559 and
// http://pgfoundry.org/forum/message.php?msg_id=1002377 for more info.
RSACryptoServiceProvider.UseMachineKeyStore = true;
promotable = new NpgsqlPromotableSinglePhaseNotification(this);
}
/// <summary>
/// Initializes a new instance of the
/// <see cref="Npgsql.NpgsqlConnection">NpgsqlConnection</see> class
/// and sets the <see cref="Npgsql.NpgsqlConnection.ConnectionString">ConnectionString</see>.
/// </summary>
/// <param name="ConnectionString">The connection used to open the PostgreSQL database.</param>
public NpgsqlConnection(String ConnectionString)
{
NpgsqlEventLog.LogMethodEnter(LogLevel.Debug, CLASSNAME, CLASSNAME, "NpgsqlConnection()");
connection_string = NpgsqlConnectionString.ParseConnectionString(ConnectionString);
LogConnectionString();
NoticeDelegate = new NoticeEventHandler(OnNotice);
NotificationDelegate = new NotificationEventHandler(OnNotification);
CertificateValidationCallbackDelegate = new CertificateValidationCallback(DefaultCertificateValidationCallback);
CertificateSelectionCallbackDelegate = new CertificateSelectionCallback(DefaultCertificateSelectionCallback);
PrivateKeySelectionCallbackDelegate = new PrivateKeySelectionCallback(DefaultPrivateKeySelectionCallback);
}
/// <summary>
/// Initializes a new instance of the
/// <see cref="Npgsql.NpgsqlConnection">NpgsqlConnection</see> class
/// and sets the <see cref="Npgsql.NpgsqlConnection.ConnectionString">ConnectionString</see>.
/// </summary>
/// <param name="ConnectionString">The connection used to open the PostgreSQL database.</param>
public NpgsqlConnection(String ConnectionString)
{
NpgsqlEventLog.LogMethodEnter(LogLevel.Debug, CLASSNAME, CLASSNAME, "NpgsqlConnection()");
NpgsqlConnectionStringBuilder builder = cache[ConnectionString];
if (builder == null)
{
settings = new NpgsqlConnectionStringBuilder(ConnectionString);
}
else
{
settings = builder.Clone();
}
LogConnectionString();
NoticeDelegate = new NoticeEventHandler(OnNotice);
NotificationDelegate = new NotificationEventHandler(OnNotification);
ProvideClientCertificatesCallbackDelegate = new ProvideClientCertificatesCallback(DefaultProvideClientCertificatesCallback);
// Fix authentication problems. See https://bugzilla.novell.com/show_bug.cgi?id=MONO77559 and
// http://pgfoundry.org/forum/message.php?msg_id=1002377 for more info.
RSACryptoServiceProvider.UseMachineKeyStore = true;
promotable = new NpgsqlPromotableSinglePhaseNotification(this);
}
/// <summary>
/// Initializes a new instance of the
/// <see cref="Npgsql.NpgsqlConnection">NpgsqlConnection</see> class
/// and sets the <see cref="Npgsql.NpgsqlConnection.ConnectionString">ConnectionString</see>.
/// </summary>
/// <param name="ConnectionString">The connection used to open the PostgreSQL database.</param>
public NpgsqlConnection(String ConnectionString)
{
NpgsqlEventLog.LogMethodEnter(LogLevel.Debug, CLASSNAME, CLASSNAME, "NpgsqlConnection()");
LoadConnectionStringBuilder(ConnectionString);
NoticeDelegate = new NoticeEventHandler(OnNotice);
NotificationDelegate = new NotificationEventHandler(OnNotification);
ProvideClientCertificatesCallbackDelegate = new ProvideClientCertificatesCallback(DefaultProvideClientCertificatesCallback);
CertificateValidationCallbackDelegate = new CertificateValidationCallback(DefaultCertificateValidationCallback);
CertificateSelectionCallbackDelegate = new CertificateSelectionCallback(DefaultCertificateSelectionCallback);
PrivateKeySelectionCallbackDelegate = new PrivateKeySelectionCallback(DefaultPrivateKeySelectionCallback);
ValidateRemoteCertificateCallbackDelegate = new ValidateRemoteCertificateCallback(DefaultValidateRemoteCertificateCallback);
// Fix authentication problems. See https://bugzilla.novell.com/show_bug.cgi?id=MONO77559 and
// http://pgfoundry.org/forum/message.php?msg_id=1002377 for more info.
RSACryptoServiceProvider.UseMachineKeyStore = true;
promotable = new NpgsqlPromotableSinglePhaseNotification(this);
}
