Skip to content

armgit / Vvveb

Public Imported from GitHub
0

Powerful and easy to use cms to build websites, blogs or ecommerce stores.

3.3 KB
Raw Blame
<?php

/**
 * Vvveb
 *
 * Copyright (C) 2022  Ziadin Givan
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Affero General Public License as
 * published by the Free Software Foundation, either version 3 of the
 * License, or (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU Affero General Public License for more details.
 *
 * You should have received a copy of the GNU Affero General Public License
 * along with this program.  If not, see <https://www.gnu.org/licenses/>.
 *
 */

return
[
	//Parsing regexes

	'functionRegex' => '/(CREATE\s+)?PROCEDURE\s+(?<name>\w+)\((?<params>.*?)\)\s+BEGIN\s+(?<statement>.*?)END(?!\s*@)/ms',

	'paramRegex' => '/(IN|OUT|INOUT|LOCAL)\s+([\.@\w]+)\s*(\w+)?(\(\d+\))?,?(\s*--[^$\n]+)?[$\n]?/ms',

	'valuesRegex' => '/\s*@VALUES\s*\(\s*:(?<list>[\w\[\]]+)\s*\)\s*/ms',

	'eachRegex' => '/\s*@EACH\s*\(\s*(\w+)\s*\,\s*([\w\.]+)\s*\)\s*/ms',

	'eachVarRegex' => '/\s*@EACH\s*\(\s*:(.+?)\s*\)\s*/ms',

	'filterRegex' => '/\s*:?(?<return>[\w_\.]+)?\s*=?\s*@FILTER\s*\(\s*:(?<data>[\w\._]+)\s*\,\s*(?<columns>[\w_]+),?\s*(?<addmissing>true|false)?,?\s*(?<array>true|false)?\s*\)\s*/ms',

	'varRegex' => '/:([\w\.]+)/ms',

	'importRegex' => '/import\(([\w\-\_\.\/]+?)\);?/',

	//Generated model templates

	'placeholder' => '?',

	//Lexer
	'tokenMap' => [
		'@IF\s+.+?\s*THEN' => 'T_IF_START',
		'@ELSE'            => 'T_ELSE',
		'END @IF'          => 'T_IF_END',
		'@KEYS\(.+?\)'     => 'T_KEYS',
		'@LIST\(.+?\)'     => 'T_LIST',
		//'@EACH\(.+?\)'      => 'T_EACH_START',
		//'END @EACH'         => 'T_EACH_END',
		'@SQL_COUNT\(.+?\)' => 'T_SQL_COUNT',
		'@ESC\(.+?\)'       => 'T_ESC',
		'.+?'               => 'T_SQL',
	],

	'macroMap' => [
		//if
		'T_IF_START' => [
			'/\s*@IF\s*(?<cond>.+?)\s*THEN\s*/', //regex
			<<<'PHP'
						';
						if ($%cond) {
							$sql .= '
				PHP
			,
		],

		'T_ELSE' => <<<'PHP'
							';
						} else {
							$sql .= '
			PHP
		,
		'T_IF_END' => '\';
			} //end if

			$sql .= \'',
		//end if
		'T_KEYS' => [
			'/\s*@KEYS\s*\(\s*:(?<keys>[\w_\.]+)\s*\)\s*/ms',
			<<<'PHP'
						';
						$q = $this->db->quote;
						$sql .= $q . implode("$q,$q", $this->db->escapeKeys(array_keys($params['%keys'])));
						$sql .= $q . '
				PHP
		],

		'T_LIST' => [
			'/\s*@LIST\s*\(\s*:(?<list>[\w_\.]+)\s*\)\s*/ms',
			<<<'PHP'
						';

							list($_sql, $_params) = $this->db->expandList($params['%list'], '%list');

							$sql .= ' ' . $_sql;

							if (is_array($_params)) $paramTypes = array_merge($paramTypes, $_params);

							$sql .= ' ' . '
				PHP
		],

		'T_SQL_COUNT' => [
			'/\s*@SQL_COUNT\s*\(\s*(?<column>.+?),\s*(?<table>.+?)\s*\)\s*/ms',
			<<<'PHP'
						';
						$sql .= $this->db->sqlCount($prevSql, '%column', $this->db->prefix . '%table');
						$sql .= '
				PHP
		],
		'T_ESC' => [
			'/@ESC\s*\(\s*:?(?<column>.+?)\s*\)/ms',
			<<<'PHP'
						';
						$sql .= preg_replace('/\W+/', '', $params['%column'] ?? '');
						$sql .= '
				PHP
		],

		//'T_EACH_START'      => 'EACH()',
		//'T_EACH_END'        => '}',
		'@SQL_COUNT\(.+?\)' => 'T_SQL_COUNT',
		'@SQL_LIMIT\(.+?\)' => 'T_SQL_LIMIT',
		'T_SQL'             => '',
	],
];