Îõ³h$§¬      None %/8>?ÀÁÂÎÖ×Ùéíî”None %/8>?ÀÁÂÎÖ×Ùéíînri-postgresql5A postgres query might fail with one of these errors.None %/8>?ÀÁÂÎÖ×Ùéíî\ None %/8>?ÀÁÂÎÖ×Ùéíîˆ!nri-postgresql$A type representing a time interval."nri-postgresql0Get the duration of an interval in microseconds.#nri-postgresql Create an !* lasting a certain number of microseconds.$nri-postgresql+Get the duration of an interval in seconds.%nri-postgresql Create an !% lasting a certain number of seconds.&nri-postgresql0Get the duration of an interval in milliseconds.'nri-postgresql Create an !* lasting a certain number of milliseconds.!"#$%&'None %/8>?ÀÁÂÎÖ×Ùéíîšnri-postgresql)Postgres connection details. You can use   to create one of these. nri-postgresql Create a 3 value by reading settings from environment values. environment variablePGHOST default value localhostenvironment variablePGPORT default value5432environment variable PGDATABASE default value postgresqlenvironment variablePGUSER default value postgresqlenvironment variable PGPASSWORD default valueenvironment variable PG_POOL_SIZE default value500environment variablePG_POOL_STRIPES default value1environment variablePG_POOL_MAX_IDLE_TIME default value3600environment variablePG_QUERY_TIMEOUT_SECONDS default value5-()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOP QRHelpers for running queries.None %/8>?ÀÁÂÎÖ×Ùéíî ¹ nri-postgresql0A Postgres query. Create one of these using the   quasiquoter.Snri-postgresqlRun a query against PostgresTnri-postgresqlThe raw SQL stringUnri-postgresql&The query string as extracted from an   quasi quote.Vnri-postgresqlSELECT  INSERT , UPDATE / INSERT ON DUPLICATE KEY UPDATE ...Wnri-postgresqlThe main tableview .. queried. nri-postgresql‰Quasi-quoter that allows you to write plain SQL in your code. The query is checked at compile-time using the 'postgresql-typed' library.:Requires the QuasiQuotes language extension to be enabled. '[sql| SELECT name, breed FROM doggos |] XWVSTU YZ None %/8>?ÀÁÂÎÖ×Ùéíî º[nri-postgresql£A database connection type. Defining our own type makes it easier to change it in the future, without having to fix compilation errors all over the codebase.\nri-postgresqlÃBy default a connection pool is passed around. It will: - Create new connections in the pool up to a certain limit. - Remove connections from the pool after a query in a connection errored.]nri-postgresql’A single connection is only used in the context of a transaction, where we need to insure several SQL statements happen on the same connection. nri-postgresqlÄA connection to Postgres. You need this for making Postgres queries. nri-postgresql Create a  . [\] ^_`abc None %/8>?ÀÁÂÉÎÖ×Ùéíî nri-postgresqlPerform a database transaction.nri-postgresqlþRun code in a transaction, then roll that transaction back. Useful in tests that shouldn't leave anything behind in the DB.nri-postgresqlÆRun a query against MySql. This will return a list of rows, where the row1 type is a tuple containing the queried columns. ¥doQuery connection [sql| SELECT name, breed FROM doggos |] (\result -> case result of Ok rows -> Task.succeed rows Err err -> Task.fail err )    None %/8>?ÀÁÂÎÖ×Ùéíî¦nri-postgresql A variant of d³ that is passed a Postgres connection, for doing tests that require access to Postgres. The test body is run within a transaction that gets rolled back after the test completes.Usage:&Postgres.Test.test "My Postgres test"  | Postgres - do -- test stuff!å      !"#$%&'(()*+,-./01233455677899:;;<==>??@AABCCDEFGGHIJKLMNOPQRSTU*)VW X Y Z  [ \ ] ^ _`aânri-postgresql-0.1.0.3-inplacePostgres Postgres.TestPaths_nri_postgresqlPostgres.ErrorPostgres.QueryParser Postgres.TimePostgres.SettingsPostgres.QueryPostgres.Connection/postgresql-typed-0.6.2.0-Enza5MbQTX9JoZANrqGvupDatabase.PostgreSQL.Typed.TypespgEncode PGParameterpgDecodePGColumnErrorTimeoutUniqueViolationOtherSettingsdecoderQuerysql Connection connection transactioninTestTransactiondoQuery$fPGArrayType"jsonb[]"$fPGType"jsonb[]"testversion getBinDir getLibDir getDynLibDir getDataDir getLibexecDir getSysconfDirgetDataFileName QueryMetaqueriedRelation sqlOperationparseInterval microsecondsfromMicrosecondsseconds fromSeconds millisecondsfromMilliseconds PgPoolSize unPgPoolSizePgPoolMaxIdleTimeunPgPoolMaxIdleTime PgPoolStripesunPgPoolStripes PgDatabase unPgDatabasePgUserunPgUserPgHostunPgHost PgPassword unPgPasswordPgPortunPgPort PoolSettings pgPoolStripespgPoolMaxIdleTime pgPoolSizeConnectionSettings pgDatabasepgUserpgHost pgPasswordpgPort pgConnectionpgPoolpgQueryTimeoutdefaultSettingsdecoderWithPrefix toPGDatabaserunQuery sqlStringquasiQuotedStringformatdetails SingleOrPoolPoolSingletimeout doAnything singleOrPool connDetails connectionIOnri-prelude-0.6.0.5-inplace Test.Internal