1. class
  2. App
  3. \
  4. G6K
  5. \
  6. Manager
  7. \
  8. Json
  9. \
  10. JsonSQL
  11. \
  12. DDLParser

DDLParser

class DDLParser extends Parser

This class allows you to store and retrieve data from files in JSON format using SQL standard.

  • The data are described by a json schema in compliance with the spécifications of http://json-schema.org

  • This schema can be generated on this site: http://jsonschema.net

  • The API is very similar to PDO

  • The JSON schema is saved in a file whose name is in the form .schema.json

  • The data is saved in a file whose name is in the form .json

Constants

SQL_SELECT_KEYWORD

SQL_FROM_KEYWORD

SQL_WHERE_KEYWORD

SQL_ORDER_BY_KEYWORD

SQL_LIMIT_KEYWORD

SQL_OFFSET_KEYWORD

SQL_UPDATE_KEYWORD

SQL_CREATE_KEYWORD

SQL_DELETE_KEYWORD

Properties

protected JsonSQL $jsonsql A pointer on the JsonSQL owner. from Parser
protected Engine $engine A pointer on JSON database engine. from Parser
protected string $sql The sql request. from Parser
private array $datatypes Conversion table of SQL data types in JSON data types

Methods

void
__construct(JsonSQL $jsonsql, string $sql)

Constructor of class DDLParser

static Parser
create(JsonSQL $jsonsql, $sql)

Parser factory.

from Parser
object
parse()

Parses the sql statement.

from Parser
object
parseSelect(string $sql)

function parseSelect

object
parseSetOperations(string $sql)

function parseSetOperations

object
parseInsert(string $sql)

function parseInsert

object
parseUpdate(string $sql)

function parseUpdate

object
parseDelete(string $sql)

function parseDelete

object
parseCreate(string $sql)

Parses a sql create table statement according to this two BNF syntax :

object
parseAlter(string $sql)

Parses a sql alter table statement according to this two BNF syntax :

object
parseTruncate(string $sql)

function parseTruncate

object
parseDropTable(string $sql)

Parses a sql drop table statement according to this BNF syntax :

void
fillTableField(string $table, string $field, array $scolumns)

Copy the definitions of columns

string
encodeLiteral(string $text)

Encode text between quote with base64

string
decodeLiteral($text, $withQuotes = false)

Decode text encoded with base64

Details

at line 104
void __construct(JsonSQL $jsonsql, string $sql)

Constructor of class DDLParser

Parameters

JsonSQL $jsonsql The JsonSQL instance
string $sql The sql request

Return Value

void

in Parser at line 138
static Parser create(JsonSQL $jsonsql, $sql)

Parser factory.

Parameters

JsonSQL $jsonsql
$sql

Return Value

Parser The parsed request

Exceptions

JsonSQLException

in Parser at line 169
object parse()

Parses the sql statement.

Return Value

object The parsed request

Exceptions

JsonSQLException

at line 744
protected object parseSelect(string $sql)

function parseSelect

Parameters

string $sql The select statement

Return Value

object The parsed request

Exceptions

JsonSQLException

at line 757
protected object parseSetOperations(string $sql)

function parseSetOperations

Parameters

string $sql The select statement

Return Value

object The parsed request

Exceptions

JsonSQLException

at line 770
protected object parseInsert(string $sql)

function parseInsert

Parameters

string $sql The insert into statement

Return Value

object The parsed request

Exceptions

JsonSQLException

at line 783
protected object parseUpdate(string $sql)

function parseUpdate

Parameters

string $sql The update statement

Return Value

object The parsed request

Exceptions

JsonSQLException

at line 796
protected object parseDelete(string $sql)

function parseDelete

Parameters

string $sql The delete from statement

Return Value

object The parsed request

Exceptions

JsonSQLException

at line 141
protected object parseCreate(string $sql)

Parses a sql create table statement according to this two BNF syntax :

CREATE [ LOCAL | GLOBAL ] TABLE [ IF NOT EXISTS ] table_name ( column_name datatype [ CONSTRAINT constraint_name] [ NOT NULL|NULLABLE ] [ DEFAULT default ] [ PRIMARY KEY ] [ AUTOINCREMENT|AUTO_INCREMENT|SERIAL ] { ', ' column_name datatype [ CONSTRAINT constraint_name] [ NOT NULL|NULLABLE ] [ DEFAULT default ] [ PRIMARY KEY ] [ AUTOINCREMENT|AUTO_INCREMENT|SERIAL ] } { ', ' FOREIGN KEY (column_name { ', ' column_name} ) REFERENCES table_name (column_name { ', ' column_name} ) } [ ', ' PRIMARY KEY (column_name { ', ' column_name} ) ] )

or

CREATE [ LOCAL | GLOBAL ] TABLE [ IF NOT EXISTS ] table_name [ (column_name, { ', ' column_name }) ] AS select_statement [ WITH [ NO ] DATA ]

or eBNF syntax :

('CREATE' ( 'LOCAL' | 'GLOBAL' ) ? 'TABLE' ( 'IF NOT EXISTS' ) ? table_name '(' column_name datatype ( 'CONSTRAINT' constraint_name ) ? ( 'NOT NULL' | 'NULLABLE' ) ? ( 'DEFAULT' default ) ? ( 'PRIMARY KEY' ) ? ( 'AUTOINCREMENT' | 'AUTO_INCREMENT' | 'SERIAL' ) ? ( ', ' column_name datatype ( 'CONSTRAINT' constraint_name ) ? ( 'NOT NULL' | 'NULLABLE' ) ? ( 'DEFAULT' default ) ? ( 'PRIMARY KEY' ) ? ( 'AUTOINCREMENT' | 'AUTO_INCREMENT' | 'SERIAL' ) ? ) * ( ', ' 'FOREIGN KEY' '(' column_name ( ', ' column_name ) * ')' 'REFERENCES' table_name '(' column_name ( ', ' column_name ) * ')' ) * ( ', ' 'PRIMARY KEY' '(' column_name ( ', ' column_name ) * ')' ) ? ')' | 'CREATE' ( 'LOCAL' | 'GLOBAL' ) ? 'TABLE' ( 'IF NOT EXISTS' ) ? table_name ( '(' column_name ( ', ' column_name ) * ')' ) ? 'AS' select_statement ( 'WITH' ( 'NO' ) ? 'DATA' ) ? )

Parameters

string $sql The create table statement

Return Value

object The parsed request

Exceptions

JsonSQLException

at line 403
protected object parseAlter(string $sql)

Parses a sql alter table statement according to this two BNF syntax :

ALTER TABLE table_name [ RENAME TO new_table_name | RENAME COLUMN column_name TO new_column_name | DROP [ COLUMN ] [IF EXISTS] column_name | DROP COMMENT | MODIFY COMMENT comment | MODIFY [ COLUMN ] column_name [ SET TYPE datatype | [ SET | REMOVE ] NOT NULL | [ SET DEFAULT default ] | REMOVE DEFAULT | [ SET | REMOVE ] PRIMARY KEY | [ SET | REMOVE ] [ AUTOINCREMENT|AUTO_INCREMENT|SERIAL ] | [ SET COMMENT comment ] | REMOVE COMMENT ] | [ SET TITLE title ] | REMOVE TITLE ] | ADD [ COLUMN ] column_name datatype [ NOT NULL|NULLABLE ] [ DEFAULT default ] [ PRIMARY KEY ] [ AUTOINCREMENT|AUTO_INCREMENT|SERIAL ] [ COMMENT comment ] ]

or eBNF syntax :

'ALTER' 'TABLE' table_name ( 'RENAME TO' new_table_name | 'RENAME COLUMN' column_name 'TO' new_column_name | 'DROP' 'COLUMN' ? 'IF EXISTS' ? column_name | 'DROP' 'COMMENT' | 'MODIFY' 'COMMENT' comment | 'MODIFY' 'COLUMN' ? column_name ( 'SET TYPE' datatype | ( ('SET' | 'REMOVE' ) 'NOT NULL' ) | ( 'SET DEFAULT' default ) | 'REMOVE DEFAULT' | ( 'SET' | 'REMOVE' ) 'PRIMARY KEY' | ( 'SET' | 'REMOVE' ) ('AUTOINCREMENT'|'AUTO_INCREMENT'|'SERIAL') | ( 'SET TITLE' title ) | 'REMOVE TITLE') | 'ADD' 'COLUMN' ? column_name datatype 'NOT NULL' ? ( 'DEFAULT' default ) ? ( 'PRIMARY KEY' ) ? ( 'AUTOINCREMENT' | 'AUTO_INCREMENT' | 'SERIAL' ) ? ( 'TITLE' title ) ? ( 'COMMENT' comment ) ? )

Parameters

string $sql The create alter statement

Return Value

object The parsed request

Exceptions

JsonSQLException

at line 809
protected object parseTruncate(string $sql)

function parseTruncate

Parameters

string $sql The truncate table statement

Return Value

object The parsed request

Exceptions

JsonSQLException

at line 679
protected object parseDropTable(string $sql)

Parses a sql drop table statement according to this BNF syntax :

DROP TABLE [ IF EXISTS ] table_name { ', ' table_name }

or eBNF syntax :

'DROP TABLE' ( 'IF EXISTS' ) ? table_name ( ', ' table_name ) *

Parameters

string $sql The drop table statement

Return Value

object The parsed request

Exceptions

JsonSQLException

at line 353
private void fillTableField(string $table, string $field, array $scolumns)

Copy the definitions of columns

Parameters

string $table The name of the table
string $field The name of the field
array $scolumns &$scolumns The columns of the table

Return Value

void

at line 702
private string encodeLiteral(string $text)

Encode text between quote with base64

Parameters

string $text The text to encode

Return Value

string The encoded text.

at line 728
private string decodeLiteral($text, $withQuotes = false)

Decode text encoded with base64

Parameters

$text
$withQuotes

Return Value

string The decoded text.