queries.md

SQL queries

Insert event

INSERT INTO event (title, description, start, end_date, room, party_report_id) VALUES (
    'Fun Event',
    'A verry good event',
    '2021-08-10T21:00' ,
    '2021-08-10T22:00',
    'BIG_HUB',
    null);

Insert party report

INSERT INTO party_report (responsible_name, responsible_number, responsible_email) VALUES (
  'Alice',
  '1234',
  '[email protected]') RETURNING id;

Inner join select

SELECT * FROM party_report INNER JOIN event
ON event.id=party_report.event_id;

SELECT (responsible_name, responsible_email) as event, (title, start as start) as party_report
FROM party_report INNER JOIN event
ON event.id=party_report.event_id;

GraphQL Queries

Query all

{
  events {
    id
    title
  }
}

Query specific

query GetEvent($id: String!) {
  event(id: $id) {
    id
  }
}

Variables

{
  "id": "1068380c-f9f7-11eb-9702-0242ac1a0002"
}