public static async Task AddJSONSupportAsync(this PgSQLConnection connection) { // TODO detect if we already added support... await connection.TypeRegistry.AddTypeFunctionalitiesAsync( ("json", CreateJSONSupport), ("jsonb", CreateJSONBSupport) ); }
protected static async Task AssertThatQueryProducesSameResults(PgSQLConnection connection, String query, params Object[] values) { var queryCount = 0; await connection.PrepareStatementForExecution(query).EnumerateAsync(async item => { Assert.AreEqual(values[queryCount++], await((SQLDataRow)item).GetValueAsObjectAsync(0)); }); Assert.AreEqual(values.Length, queryCount); }
private void btnInsert_Click(object sender, EventArgs e) { cmds[0] = tbQuery1.Text; cmds[1] = tbQuery2.Text; if (rbMySQL.Checked == true) { MySQLConnection MySQLCon = new MySQLConnection(); MySQLCon.MySQLServer = tbServidor.Text; MySQLCon.MySQLPort = tbPort.Text; MySQLCon.MySQLUser = tbUser.Text; MySQLCon.MySQLPass = tbPass.Text; MySQLCon.TransacaoMySQL(cmds); } else if (rbMSSQL.Checked == true) { MSSQLConnection MSSQLCon = new MSSQLConnection(); MSSQLCon.MSSQLServer = tbServidor.Text; MSSQLCon.MSSQLPort = tbPort.Text; MSSQLCon.MSSQLUser = tbUser.Text; MSSQLCon.MSSQLPass = tbPass.Text; MSSQLCon.TransacaoMSSQL(cmds); } else if (rbPgSQL.Checked == true) { PgSQLConnection PgSQLCon = new PgSQLConnection(); PgSQLCon.PgSQLServer = tbServidor.Text; PgSQLCon.PgSQLPort = tbPort.Text; PgSQLCon.PgSQLUser = tbUser.Text; PgSQLCon.PgSQLPass = tbPass.Text; PgSQLCon.TransacaoPgSQL(cmds); } else if (rbFirebird.Checked == true) { FirebirdConnection FirebirdCon = new FirebirdConnection(); FirebirdCon.FirebirdServer = tbServidor.Text; FirebirdCon.FirebirdPort = tbPort.Text; FirebirdCon.FirebirdUser = tbUser.Text; FirebirdCon.FirebirdPass = tbPass.Text; FirebirdCon.TransacaoFirebird(cmds); } else { MessageBox.Show("ERRO"); } }
protected static async Task AssertThatQueryProducesSameResults_IgnoreOrder(PgSQLConnection connection, String query, params Object[] values) { var valuesSet = new HashSet <Object>(values); var querySet = new HashSet <Object>(); var queryCount = 0; await connection.PrepareStatementForExecution(query).EnumerateAsync(async item => { querySet.Add(await((SQLDataRow)item).GetValueAsObjectAsync(0)); ++queryCount; }); Assert.AreEqual(values.Length, queryCount); Assert.IsTrue(valuesSet.SetEquals(querySet)); }
protected static async Task AssertThatConnectionIsStillUseable(PgSQLConnection connection) { var selectResult = await connection.GetFirstOrDefaultAsync <Int32>("SELECT 1"); Assert.AreEqual(1, selectResult); }