1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021 |
- <?php
- namespace OCP\DB\QueryBuilder;
- use Doctrine\DBAL\Connection;
- use OCP\DB\Exception;
- use OCP\DB\IResult;
- interface IQueryBuilder {
-
- public const PARAM_NULL = \PDO::PARAM_NULL;
-
- public const PARAM_BOOL = \PDO::PARAM_BOOL;
-
- public const PARAM_INT = \PDO::PARAM_INT;
-
- public const PARAM_STR = \PDO::PARAM_STR;
-
- public const PARAM_LOB = \PDO::PARAM_LOB;
-
- public const PARAM_DATE = 'datetime';
-
- public const PARAM_JSON = 'json';
-
- public const PARAM_INT_ARRAY = Connection::PARAM_INT_ARRAY;
-
- public const PARAM_STR_ARRAY = Connection::PARAM_STR_ARRAY;
-
- public const MAX_ROW_DELETION = 100000;
-
- public function automaticTablePrefix($enabled);
-
- public function expr();
-
- public function func();
-
- public function getType();
-
- public function getConnection();
-
- public function getState();
-
- public function execute();
-
- public function executeQuery(): IResult;
-
- public function executeStatement(): int;
-
- public function getSQL();
-
- public function setParameter($key, $value, $type = null);
-
- public function setParameters(array $params, array $types = []);
-
- public function getParameters();
-
- public function getParameter($key);
-
- public function getParameterTypes();
-
- public function getParameterType($key);
-
- public function setFirstResult($firstResult);
-
- public function getFirstResult();
-
- public function setMaxResults($maxResults);
-
- public function getMaxResults();
-
- public function select(...$selects);
-
- public function selectAlias($select, $alias);
-
- public function selectDistinct($select);
-
- public function addSelect(...$select);
-
- public function delete($delete = null, $alias = null);
-
- public function update($update = null, $alias = null);
-
- public function insert($insert = null);
-
- public function from($from, $alias = null);
-
- public function join($fromAlias, $join, $alias, $condition = null);
-
- public function innerJoin($fromAlias, $join, $alias, $condition = null);
-
- public function leftJoin($fromAlias, $join, $alias, $condition = null);
-
- public function rightJoin($fromAlias, $join, $alias, $condition = null);
-
- public function set($key, $value);
-
- public function where(...$predicates);
-
- public function andWhere(...$where);
-
- public function orWhere(...$where);
-
- public function groupBy(...$groupBys);
-
- public function addGroupBy(...$groupBy);
-
- public function setValue($column, $value);
-
- public function values(array $values);
-
- public function having(...$having);
-
- public function andHaving(...$having);
-
- public function orHaving(...$having);
-
- public function orderBy($sort, $order = null);
-
- public function addOrderBy($sort, $order = null);
-
- public function getQueryPart($queryPartName);
-
- public function getQueryParts();
-
- public function resetQueryParts($queryPartNames = null);
-
- public function resetQueryPart($queryPartName);
-
- public function createNamedParameter($value, $type = self::PARAM_STR, $placeHolder = null);
-
- public function createPositionalParameter($value, $type = self::PARAM_STR);
-
- public function createParameter($name);
-
- public function createFunction($call);
-
- public function getLastInsertId(): int;
-
- public function getTableName($table);
-
- public function getColumnName($column, $tableAlias = '');
- }
|