bitemyapp/esqueleto

Missing docs for SQL functions

Open

#93 aperta il 16 giu 2018

Vedi su GitHub
 (5 commenti) (0 reazioni) (0 assegnatari)Haskell (106 fork)github user discovery
easyhelp wanted

Metriche repository

Star
 (395 star)
Metriche merge PR
 (Metriche PR in attesa)

Descrizione

If I'm not missing something completely obvious, the core tutorial at https://www.stackage.org/haddock/lts-10.10/esqueleto-2.5.3/Database-Esqueleto.html doesn't really teach how to use SQL functions/expressions, such as date, random, now, substr, etc.

Coupled with the fact that the modules Database.Esqueleto.SQLite and Database.Esqueleto.MySQL don't show up in the package contents, I was under the impression that Esqueleto had absolutely no way to groupBy date(timestampCol) in SQLIte. After going through https://github.com/bitemyapp/esqueleto/blob/master/src/Database/Esqueleto/PostgreSQL.hs I realise that unsafeSQLFuntion is that escape hatch.

Guida contributor