SQLHELP

package sqlhelptest contains helper functions for testing database functions.

AddSearchPath adds a search path to postgres dsn string.

Collect2 collects all values from the iterator into a slice.

Delete deletes rows from the table matching where argument.

ExistsByID checks if a record with the given ID exists.

Insert is a generic function to insert a record into a table.

InsertFull is a generic function to insert a record into a table, if omitEmpty is specified, fields with empty values will be omitted from the insert statement.

InsertPSQL is a Postgres flavour of Insert.

InsertPSQLFull is a Postgres flavour of InsertFull.

JustErr is a helper function to return just an error from a function that returns two values, where the first one is not needed and the second is an error.

Select selects rows from a table.

SelectRow selects a row from a table.

SelectRowByID selects a row by ID (assuming that ID column is named "id").

SelectRowByIntegrationID selects a row by integration_id (assuming that there is an "integration_id" column).

Update updates a record.

UpdateByID updates a record by ID.