jobs_input.h File Reference

#include <stddef.h>
#include "c_common/get_check_data.h"
#include "c_types/column_info_t.h"
#include "c_types/vroom/vroom_job_t.h"

Include dependency graph for jobs_input.h:

This graph shows which files directly or indirectly include this file:

Go to the source code of this file.

Functions
void	get_vroom_jobs (char *jobs_sql, Vroom_job_t **jobs, size_t *total_jobs, bool is_plain)
	Reads the VROOM jobs. More...

Function Documentation

get_vroom_jobs()

void get_vroom_jobs	(	char *	sql,
		Vroom_job_t **	rows,
		size_t *	total_rows,
		bool	is_plain
	)

Reads the VROOM jobs.

Parameters

[in]	sql	SQL query to execute
[out]	rows	C Container that holds the data
[out]	total_rows	Total rows recieved

Definition at line 213 of file jobs_input.c.

                   {
  int kColumnCount = 9;
  Column_info_t info[kColumnCount];
 
  for (int i = 0; i < kColumnCount; ++i) {
    info[i].colNumber = -1;
    info[i].type = 0;
    info[i].strict = false;
    info[i].eType = ANY_INTEGER;
  }
 
  info[0].name = "id";
  info[1].name = "location_id";
  info[2].name = "setup";
  info[3].name = "service";
  info[4].name = "delivery";
  info[5].name = "pickup";
  info[6].name = "skills";
  info[7].name = "priority";
  info[8].name = "data";
 
  info[2].eType = INTEGER;            // setup
  info[3].eType = INTEGER;            // service
  info[4].eType = ANY_INTEGER_ARRAY;  // delivery
  info[5].eType = ANY_INTEGER_ARRAY;  // pickup
  info[6].eType = INTEGER_ARRAY;      // skills
  info[7].eType = INTEGER;            // priority
  info[8].eType = JSONB;              // data
 
  if (!is_plain) {
    info[2].eType = INTERVAL;         // setup
    info[3].eType = INTERVAL;         // service
  }
 
  /* Only id and location_id are mandatory */
  info[0].strict = true;
  info[1].strict = true;
 
  db_get_jobs(sql, rows, total_rows, info, kColumnCount, is_plain);
}

References ANY_INTEGER, ANY_INTEGER_ARRAY, Column_info_t::colNumber, db_get_jobs(), Column_info_t::eType, INTEGER, INTEGER_ARRAY, INTERVAL, JSONB, Column_info_t::name, Column_info_t::strict, and Column_info_t::type.

Referenced by process().