GRASS GIS 7 Programmer's Manual  7.9.dev(2021)-e5379bbd7
sql.c File Reference
#include <stdlib.h>
#include <stdio.h>
#include <string.h>
#include <ctype.h>
#include <assert.h>
#include <grass/sqlp.h>
Include dependency graph for sql.c:

Go to the source code of this file.

Functions

int sqpSaveStr (SQLPVALUE *val, char *c)
 
void sqpInitValue (SQLPVALUE *val)
 
void sqpCopyValue (SQLPVALUE *from, SQLPVALUE *to)
 
int sqpInitParser (SQLPSTMT *st)
 
void sqpCommand (int command)
 
void sqpTable (char *tbl)
 
void sqpColumn (char *col)
 
void sqpColumnDef (char *col, int type, int width, int decimals)
 
void sqpValue (char *strval, int intval, double dblval, int type)
 
void sqpAssignment (char *col, char *strval, int intval, double dblval, SQLPNODE *expval, int type)
 
void sqpOrderColumn (char *col, int dir)
 
SQLPNODEsqpNewNode (void)
 
SQLPNODEsqpNewExpressionNode (int oper, SQLPNODE *left, SQLPNODE *right)
 
SQLPNODEsqpNewColumnNode (char *name)
 
SQLPNODEsqpNewValueNode (char *strval, int intval, double dblval, int type)
 
void sqpFreeNode (SQLPNODE *np)
 
int sqpOperatorCode (char *oper)
 
char * sqpOperatorName (int oper)
 

Variables

SQLPSTMTsqlpStmt
 

Function Documentation

◆ sqpAssignment()

void sqpAssignment ( char *  col,
char *  strval,
int  intval,
double  dblval,
SQLPNODE expval,
int  type 
)

Definition at line 162 of file sql.c.

◆ sqpColumn()

void sqpColumn ( char *  col)

Definition at line 102 of file sql.c.

References SQLPSTMT::Col, SQLPSTMT::nCol, sqpAllocCol(), and sqpSaveStr().

◆ sqpColumnDef()

void sqpColumnDef ( char *  col,
int  type,
int  width,
int  decimals 
)

Definition at line 114 of file sql.c.

◆ sqpCommand()

void sqpCommand ( int  command)

Definition at line 90 of file sql.c.

References SQLPSTMT::command.

◆ sqpCopyValue()

void sqpCopyValue ( SQLPVALUE from,
SQLPVALUE to 
)

Definition at line 61 of file sql.c.

References SQLPVALUE::d, free(), SQLPVALUE::i, SQLPVALUE::s, and SQLPVALUE::type.

◆ sqpFreeNode()

void sqpFreeNode ( SQLPNODE np)

Definition at line 260 of file sql.c.

References sqlpnode::column_name, free(), sqlpnode::left, sqlpnode::right, SQLPVALUE::s, and sqlpnode::value.

Referenced by sqpFreeStmt().

◆ sqpInitParser()

◆ sqpInitValue()

void sqpInitValue ( SQLPVALUE val)

Definition at line 53 of file sql.c.

References SQLPVALUE::d, SQLPVALUE::i, NULL, SQLPVALUE::s, SQLP_NULL, and SQLPVALUE::type.

◆ sqpNewColumnNode()

SQLPNODE* sqpNewColumnNode ( char *  name)

Definition at line 231 of file sql.c.

References sqlpnode::column_name, sqlpnode::node_type, SQLP_NODE_COLUMN, and sqpNewNode().

◆ sqpNewExpressionNode()

SQLPNODE* sqpNewExpressionNode ( int  oper,
SQLPNODE left,
SQLPNODE right 
)

◆ sqpNewNode()

SQLPNODE* sqpNewNode ( void  )

Definition at line 209 of file sql.c.

Referenced by sqpNewColumnNode(), and sqpNewExpressionNode().

◆ sqpNewValueNode()

SQLPNODE* sqpNewValueNode ( char *  strval,
int  intval,
double  dblval,
int  type 
)

Definition at line 243 of file sql.c.

◆ sqpOperatorCode()

int sqpOperatorCode ( char *  oper)

Definition at line 280 of file sql.c.

◆ sqpOperatorName()

char* sqpOperatorName ( int  oper)

◆ sqpOrderColumn()

void sqpOrderColumn ( char *  col,
int  dir 
)

Definition at line 200 of file sql.c.

References SQLPSTMT::orderCol, and SQLPSTMT::orderDir.

◆ sqpSaveStr()

int sqpSaveStr ( SQLPVALUE val,
char *  c 
)

Definition at line 41 of file sql.c.

Referenced by sqpColumn().

◆ sqpTable()

void sqpTable ( char *  tbl)

Definition at line 96 of file sql.c.

References SQLP_MAX_TABLE, and SQLPSTMT::table.

◆ sqpValue()

void sqpValue ( char *  strval,
int  intval,
double  dblval,
int  type 
)

Definition at line 129 of file sql.c.

Variable Documentation

◆ sqlpStmt

SQLPSTMT* sqlpStmt

Definition at line 38 of file sql.c.

Referenced by sqpPrintStmt().