ZOO-Project
sqlapi.h
Go to the documentation of this file.
1 /*
2  * Author : David Saggiorato
3  *
4  * Copyright 2008-2009 GeoLabs SARL. All rights reserved.
5  *
6  * Permission is hereby granted, free of charge, to any person obtaining a copy
7  * of this software and associated documentation files (the "Software"), to deal
8  * in the Software without restriction, including without limitation the rights
9  * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
10  * copies of the Software, and to permit persons to whom the Software is
11  * furnished to do so, subject to the following conditions:
12  *
13  * The above copyright notice and this permission notice shall be included in
14  * all copies or substantial portions of the Software.
15  *
16  * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
17  * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
18  * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
19  * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
20  * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
21  * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
22  * THE SOFTWARE.
23  */
24 
25 #ifndef ZOO_SQLAPI_H
26 #define ZOO_SQLAPI_H 1
27 
28 #if defined(META_DB) || defined(USE_AMQP)
29 #include "ogrsf_frmts.h"
30 #include "ogr_p.h"
31 #if GDAL_VERSION_MAJOR >= 2
32 #include <gdal_priv.h>
33 #endif
34 #endif
35 
36 #include "service.h"
37 #include "service_internal.h"
38 
39 #define SQL_AVAILABLE_SLOT "SELECT %s.checkAvailableExecutionSlot('%s','%s','%s',%d);"
40 
41 #if defined(META_DB) || defined(USE_AMQP)
42 extern "C"
43 #if GDAL_VERSION_MAJOR >=2
44  GDALDataset
45 #else
46  OGRDataSource
47 #endif
48  **ppoZooDS;
49 #endif
50 
51 #ifdef __cplusplus
52 extern "C" {
53 #endif
54 
55 #if defined(META_DB) || defined(USE_AMQP)
56  ZOO_DLL_EXPORT char* _createInitString(maps*,const char*);
57  ZOO_DLL_EXPORT int _init_sql(maps*,const char*);
58  ZOO_DLL_EXPORT OGRLayer *fetchSql(maps*,int,const char*);
59  ZOO_DLL_EXPORT void cleanFetchSql(maps*,int,OGRLayer*);
61 #endif
62 #ifdef RELY_ON_DB
64  ZOO_DLL_EXPORT void close_sql(maps*,int);
65  ZOO_DLL_EXPORT int execSql(maps*,int,const char*);
66  ZOO_DLL_EXPORT char* runSqlQuery(maps*,char*);
67  ZOO_DLL_EXPORT void recordStoredFile(maps*,const char*,const char*,const char*);
68  ZOO_DLL_EXPORT void recordServiceStatus(maps*);
69  ZOO_DLL_EXPORT void recordResponse(maps*,char*);
70  ZOO_DLL_EXPORT void recordRequest(maps*,map*);
71  ZOO_DLL_EXPORT void readFinalRes(maps*,char*,map*);
72  ZOO_DLL_EXPORT int isRunning(maps*,char*);
73  ZOO_DLL_EXPORT char* getStatusId(maps*,char*);
74  ZOO_DLL_EXPORT void removeService(maps*,char*);
75  ZOO_DLL_EXPORT void end_sql();
76  ZOO_DLL_EXPORT void filterJobByUser(maps*,char**,char*);
77 #endif
78 
79 #ifdef __cplusplus
80 }
81 #endif
82 
83 #endif
_createInitString
char * _createInitString(maps *pmsConf, const char *pccKey)
Create a GDAL / OGR string for connecting to a db backend defined in the key section.
Definition: sqlapi.c:60
close_sql
void close_sql(maps *pmsConf, int iConnectionId)
Close any connection to the db backend.
Definition: sqlapi.c:228
execSql
int execSql(maps *pmsConf, int iConnectionId, const char *pcSqlQuery)
Execute a SQL query to the SQL Database Backend.
Definition: sqlapi.c:305
service.h
filterJobByUser
void filterJobByUser(maps *pmsConf, char **pcaClauseFinal, char *pcaClauseDate)
Definition: service_json.c:2246
end_sql
void end_sql()
Call OGRCleanupAll.
Definition: sqlapi.c:261
maps
linked list of map pointer
Definition: service.h:678
cleanFetchSql
void cleanFetchSql(maps *pmsConf, int iConnectionId, OGRLayer *poLayer)
Clean any memory allocated by executing a request.
Definition: sqlapi.c:291
readFinalRes
void readFinalRes(maps *conf, char *pid, map *statusInfo)
Read the Result file (.res).
Definition: server_internal.c:941
isRunning
int isRunning(maps *conf, char *pid)
Check if a service is running.
Definition: server_internal.c:976
service_internal.h
map
KVP linked list.
Definition: service.h:657
ZOO_DLL_EXPORT
#define ZOO_DLL_EXPORT
Definition: service.h:34
fetchSql
OGRLayer * fetchSql(maps *pmsConf, int iConnectionId, const char *pcSqlQuery)
Fetch a tuple set by executing a SQL query to the Database Backend.
Definition: sqlapi.c:272
getStatusId
char * getStatusId(maps *conf, char *pid)
Read the sid file attached of a service if any.
Definition: service_internal.c:236
_init_sql
int _init_sql(maps *pmsConf, const char *pccKey)
Connect to a db backend.
Definition: sqlapi.c:148
init_sql
int init_sql(maps *pmsConf)
Connect to the db backend.
Definition: sqlapi.c:218
ppoZooDS
OGRDataSource ** ppoZooDS
Global GDALDataset pointer.
Definition: sqlapi.c:45
getCurrentId
int getCurrentId(maps *pmsConf)
Get the identifier of the current database.
Definition: sqlapi.c:335