aboutsummaryrefslogtreecommitdiff
path: root/server/src/Persistence/User.hs
diff options
context:
space:
mode:
Diffstat (limited to 'server/src/Persistence/User.hs')
-rw-r--r--server/src/Persistence/User.hs9
1 files changed, 6 insertions, 3 deletions
diff --git a/server/src/Persistence/User.hs b/server/src/Persistence/User.hs
index 3c3a2b1..89eb57d 100644
--- a/server/src/Persistence/User.hs
+++ b/server/src/Persistence/User.hs
@@ -5,7 +5,7 @@ module Persistence.User
import qualified Data.Maybe as Maybe
import Data.Text (Text)
-import Database.SQLite.Simple (FromRow (fromRow), Only (Only))
+import Database.SQLite.Simple (FromRow (fromRow), NamedParam ((:=)))
import qualified Database.SQLite.Simple as SQLite
import Prelude hiding (id)
@@ -30,8 +30,11 @@ list =
)
get :: Text -> Query (Maybe User)
-get userEmail =
+get email =
Query (\conn -> do
fmap (\(Row u) -> u) . Maybe.listToMaybe <$>
- SQLite.query conn "SELECT * FROM user WHERE email = ? LIMIT 1" (Only userEmail)
+ SQLite.queryNamed
+ conn
+ "SELECT * FROM user WHERE email = :email LIMIT 1"
+ [ ":email" := email ]
)