src/app/domain/occurrence/sql/insert_new_occurence.sql at main

kacaii.dev / senac-brigade-server

fork atom

wip: currently rewriting the project as a full stack application tangled.org/kacaii.dev/sigo

gleam

fork atom

senac-brigade-server / src / app / domain / occurrence / sql / insert_new_occurence.sql

at main 24 lines 404 B view raw

wrap content

kacaii.dev :art: lowercase all sql code 3mo ago

61f7a9ea

 1--   Inserts a new occurrence into the database
 2insert into public.occurrence as o (
 3    applicant_id,
 4    occurrence_category,
 5    occurrence_subcategory,
 6    priority,
 7    description,
 8    occurrence_location,
 9    reference_point
10) values (
11    $1,
12    $2,
13    $3,
14    $4,
15    $5,
16    $6,
17    $7
18)
19returning
20    o.id,
21    o.occurrence_category,
22    o.priority,
23    o.applicant_id,
24    o.created_at;