default:
  context:
    node_name: '@node'
    node: complex
    visitor: complex_admin
    site: complex
  src: ""
  sql: "[\"SELECT nodes.* FROM nodes WHERE nodes.parent_id = ? AND (#{@node.secure_scope('nodes')}) ORDER BY nodes.position ASC, nodes.name ASC\", @node.id]"
  res: "courses, cskin, employees, jobs"

assigned_jobs:
  context:
    node: roger
  src: assigned_jobs
  res: "driver, technician"

courses_assigned_to_driver_team:
  context:
    node: driver_team
  src: assigned_courses
  res: "formulate_problems, transmit_information"

all_courses_in_driver:
  context:
    node: driver
  src: assigned_courses from pages in project
  res: "dangerous_transportations, engine, formulate_problems, transmit_information"

all_courses_for_roger:
  context:
    node: roger
  src: assigned_courses from pages in project from assigned_jobs
  res: "dangerous_transportations, engine, fiber_junction, formulate_problems, radio_usage, secure_a_site, transmit_information, winch_usage"
all_courses_for_joe:
  context:
    node: joe
  src: assigned_courses from pages in project from assigned_jobs
  res: "fiber_junction, formulate_problems, radio_usage, secure_a_site, transmit_information, winch_usage"

all_courses_for_mike:
  context:
    node: mike
  src: assigned_courses from pages in project from assigned_jobs
  # TODO: optimization
  #sql: "[\"SELECT no1.*,li1.id AS link_id,links.status AS l_status,links.comment AS l_comment,links.date AS l_date FROM nodes,links,nodes AS no1,links AS li1 WHERE no1.id = li1.target_id AND li1.relation_id = 512923747 AND li1.source_id = nodes.id AND nodes.kpath LIKE 'NP%' AND nodes.project_id = links.target_id AND links.relation_id = 813976280 AND links.source_id = \#{@node.id} AND (\#{@node.secure_scope('no1')}) GROUP BY no1.id ORDER BY no1.position ASC, no1.name ASC\"]"
  res: "fiber_junction, formulate_problems, radio_usage, resp_management, secure_a_site, team_motivation, transmit_information, vision, winch_usage"

all_achieved_formations_for_roger:
  context:
    node: roger
  src: assigned_formations where l_status eq 100
  res: fiber2003, form2006, transm2001, transm2002, transp2004

custom_query_form_date:
  context:
    node: roger
  src: emp_form_date order by name ASC
  res: "dangerous_transportations, engine, fiber_junction, formulate_problems, radio_usage, secure_a_site, transmit_information, winch_usage"

custom_query_form_with_where:
  context:
    node: roger
    ref_date: 2005-03-01
  src: emp_form_dates where last_date is null or (repeat_every is not null and next_date lt REF_DATE + 6 month)
  res: "secure_a_site, winch_usage, engine, transmit_information, fiber_junction, radio_usage"

find_employees_related_to_a_course__formulate_problems:
  context:
    node: transmit_information
  src: assigned_employees from project from assigned_pages
  res: 'joe, mike, roger'

find_employees_related_to_a_course__fiber_junction:
  context:
    node: fiber_junction
  src: assigned_employees from project from assigned_pages
  res: 'joe, mike, roger'


find_employees_related_to_a_course__vision:
  context:
    node: vision
  src: assigned_employees from project from assigned_pages
  res: 'mike'

course_emp_date:
  context:
    node: transmit_information
  src: "course_emp_dates"
  res: "joe, mike, roger"

all_course_emp_date:
  src: "assigned_employees from project from assigned_pages from courses in site"
  res: "joe, mike, roger"

courses_with_rep:
  src: "courses where custom_a is not null in site order by name asc"
  res: "dangerous_transportations, engine, fiber_junction, radio_usage, resp_management, secure_a_site, team_motivation, transmit_information, vision, winch_usage"