sqls.h

Go to the documentation of this file.

#ifndef __SQLS_H__
#define __SQLS_H__

#ifdef __cplusplus
extern "C" {
#endif


#define SQL_COL_ID_RAWS                 "id_raws" 
#define SQL_COL_TIMESTAMP               "timestamp" 
#define SQL_COL_ID_MODEM                "id_modem" 
#define SQL_COL_SNR                     "snr" 
#define SQL_COL_STATION                 "station" 
#define SQL_COL_ACK                     "ack" 
#define SQL_COL_DATA_STR                "data_str" 
#define SQL_COL_DATA_HEX                "data_hex" 
#define SQL_COL_DUPLICATE               "duplicate" 
#define SQL_COL_AVG_SIGNAL              "avg_signal" 
#define SQL_COL_RSSI                    "rssi" 
#define SQL_COL_LATITUDE                "latitude" 
#define SQL_COL_LONGITUDE               "longitude" 
#define SQL_COL_SEQ_NUMBER              "seq_number" 
#define SQL_COL_LONG_POLLING            "long_polling" 
#define SQL_COL_ATTRIBUTION             "attribution" 
#define SQL_COL_TIMESTAMP_ATTRIBUTION   "timestamp_attribution"        


#define SQL_IDX_ID_RAWS     0  
#define SQL_IDX_TIMESTAMP   1  
#define SQL_IDX_ID_MODEM    2  
#define SQL_IDX_SNR         3  
#define SQL_IDX_STATION     4  
#define SQL_IDX_ACK         5  
#define SQL_IDX_DATA_STR    6  
#define SQL_IDX_DATA_HEX    7  
#define SQL_IDX_DUPLICATE   8  
#define SQL_IDX_AVG_SIGNAL  9  
#define SQL_IDX_RSSI        10  
#define SQL_IDX_LATITUDE    11  
#define SQL_IDX_LONGITUDE   12  
#define SQL_IDX_SEQ_NUMBER  13  


#define CREATE_SIGFOX_TABLES \
    "-- CREATION OF THE SIGFOX TABLES WITH SOME DATA\n" \
    "\n" \
    "--\n" \
    "-- Create 'raws' table\n" \
    "--\n" \
    "CREATE TABLE IF NOT EXISTS `raws` (\n" \
    "  `id_raws` INTEGER PRIMARY KEY AUTOINCREMENT,\n" \
    "  `timestamp` INTEGER NOT NULL,\n" \
    "  `id_modem` TEXT NOT NULL,\n" \
    "  `snr` REAL NOT NULL,\n" \
    "  `station` TEXT NOT NULL,\n" \
    "  `ack` INTEGER,\n" \
    "  `data_str` TEXT NOT NULL,\n" \
    "  `data_hex` BLOB NOT NULL,\n" \
    "  `duplicate` INTEGER NOT NULL,\n" \
    "  `avg_signal` REAL NOT NULL,\n" \
    "  `rssi` REAL NOT NULL,\n" \
    "  `latitude` INTEGER NOT NULL,\n" \
    "  `longitude` INTEGER NOT NULL,\n" \
    "  `seq_number` INTEGER NOT NULL\n" \
    ");\n" \
    "\n" \
    "\n" \
    "--\n" \
    "-- Create 'devices' table\n" \
    "--\n" \
    "CREATE TABLE IF NOT EXISTS `devices` (\n" \
    "  `id_modem` TEXT NOT NULL UNIQUE,\n" \
    "  `attribution` INTEGER,\n" \
    "  `timestamp_attribution` INTEGER\n" \
    ");"


#define DROP_SIGFOX_TABLES \
    "-- DELETION OF THE SIGFOX TABLES\n" \
    "\n" \
    "-- Delete the tables if they exists\n" \
    "DROP TABLE IF EXISTS `raws`;\n" \
    "DROP TABLE IF EXISTS `devices`;"


#define SELECT_RAWS \
    "SELECT timestamp, id_modem, snr, station, ack, data_str, data_hex, duplicate, avg_signal," \
    "rssi, latitude, longitude, seq_number FROM `raws`"


#define SELECT_DEVICES  "SELECT * FROM `devices`;"


#define DELETE_RAWS     "DELETE FROM raws;"


#define INSERT_DEVICES  "INSERT INTO `devices` VALUES (?, ?, ?);"


#define INSERT_RAWS     "INSERT INTO `raws` VALUES (NULL, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);"

#ifdef     __cplusplus
}
#endif

#endif          // __SQLS_H__