SQL Queries

sqlQueries.scala

import zio.experiment.adapter.model.{User => UserStored}

object SQL {
  
  def get(id: Int): Query0[UserStored] =
    sql"""SELECT * FROM USERS WHERE ID = $id """.query[UserStored]
    
  def create(user: UserStored): Update0 =
    sql"""INSERT INTO USERS (id, name) VALUES (${user.id}, ${user.name})""".update
  
  def delete(id: Int): Update0 =
    sql"""DELETE FROM USERS WHERE id = $id""".update
  
  def createUsersTable: doobie.Update0 =
    sql"""CREATE TABLE USERS (id Int, name VARCHAR NOT NULL)""".update
  
  def dropUsersTable: doobie.Update0 =
    sql"""DROP TABLE IF EXISTS USERS""".update
}