shipments_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_shipment_t.h"

Include dependency graph for shipments_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_shipments (char *shipments_sql, Vroom_shipment_t **shipments, size_t *total_shipments, bool is_plain)
	Reads the VROOM shipments. More...

Function Documentation

get_vroom_shipments()

void get_vroom_shipments	(	char *	sql,
		Vroom_shipment_t **	rows,
		size_t *	total_rows,
		bool	is_plain
	)

Reads the VROOM shipments.

Parameters

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

Definition at line 216 of file shipments_input.c.

                   {
  int kColumnCount = 12;
  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";
 
  /* pickup shipments */
  info[1].name = "p_location_id";
  info[2].name = "p_setup";
  info[3].name = "p_service";
 
  /* delivery shipments */
  info[4].name = "d_location_id";
  info[5].name = "d_setup";
  info[6].name = "d_service";
 
  info[7].name = "amount";
  info[8].name = "skills";
  info[9].name = "priority";
  info[10].name = "p_data";
  info[11].name = "d_data";
 
  info[2].eType = INTEGER;            // p_setup
  info[3].eType = INTEGER;            // p_service
  info[5].eType = INTEGER;            // d_setup
  info[6].eType = INTEGER;            // d_service
  info[7].eType = ANY_INTEGER_ARRAY;  // amount
  info[8].eType = INTEGER_ARRAY;      // skills
  info[9].eType = INTEGER;            // priority
  info[10].eType = JSONB;             // p_data
  info[11].eType = JSONB;             // d_data
 
  if (!is_plain) {
    info[2].eType = INTERVAL;         // p_setup
    info[3].eType = INTERVAL;         // p_service
    info[5].eType = INTERVAL;         // d_setup
    info[6].eType = INTERVAL;         // d_service
  }
 
  /* id and location_id of pickup and delivery are mandatory */
  info[0].strict = true;
  info[1].strict = true;
  info[4].strict = true;
 
  db_get_shipments(sql, rows, total_rows, info, kColumnCount, is_plain);
}

References ANY_INTEGER, ANY_INTEGER_ARRAY, Column_info_t::colNumber, db_get_shipments(), 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().