Skip to content

gekomad/doobie-recipes

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

52 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Doobie recipes v.0.13 and v.1

Run test on local PostgreSQL

cd doobie_1 or doobie_0.13
$ curl -O https://raw.githubusercontent.com/tpolecat/doobie/series/0.7.x/world.sql
$ psql -c 'create user postgres createdb'
$ psql -c 'create database world;' -U postgres
$ psql -c '\i world.sql' -d world -U postgres
$ psql -d world -c "create type myenum as enum ('foo', 'bar')" -U postgres

sbt test

Run test with docker

cd doobie_1 or doobie_0.13
docker run -d --name doobie_recipies -p5435:5432 -e POSTGRES_USER=postgres -e POSTGRES_DB=world -e POSTGRES_PASSWORD=postgres tpolecat/skunk-world
sbt test
docker rm -f doobie_recipies

v.1 v.0.13
Selecting
select count select count
join join
MappingRows MappingRows
NestedClass NestedClass
NestedClassMap NestedClassMap
RowMappings RowMappings
SelectMultipleColumns SelectMultipleColumns
SelectOneColumn SelectOneColumn
ShapelessRecord ShapelessRecord
Streaming Streaming
StatementFragments StatementFragments
Timestamp Timestamp
Parameterized queries Parameterized queries
Bigger than Bigger than
IN clauses IN clauses
Parameters Parameters
DDL DDL
Batch Batch
Insert and Read key Insert and Read key
Insert and Read Person class Insert and Read Person class
Insert Read and Update Insert Read and Update
SQLArrays SQLArrays
Rollback Rollback
Vacuum Vacuum
Transactions Transactions
Transaction Transaction
Enum Enum
Enum Enum
CSV CSV
Select with type Select with type
Itto CSV Itto CSV
Load CSV in table Load CSV in table
Spool CSV Spool CSV
Spool paramterized CSV Spool paramterized CSV
Logging Logging
Logging Logging
Error handling Error handling
ErrorHandling ErrorHandling