Dotclear 2.24
Loading...
Searching...
No Matches
dcTruncateStatement Class Reference
Inheritance diagram for dcTruncateStatement:
dcSqlStatement

Public Member Functions

 statement ()
 
 truncate ()
 
 run ()
 
- Public Member Functions inherited from dcSqlStatement
 __construct ()
 
 __get (string $property)
 
 __set (string $property, $value)
 
 __isset (string $property)
 
 __unset (string $property)
 
 __invoke ()
 
 statement ()
 
 columns ($c, bool $reset=false)
 
 fields ($c, bool $reset=false)
 
 column ($c, bool $reset=false)
 
 field ($c, bool $reset=false)
 
 from ($c, bool $reset=false, bool $first=false)
 
 where ($c, bool $reset=false)
 
 on ($c, bool $reset=false)
 
 cond ($c, bool $reset=false)
 
 and ($c, bool $reset=false)
 
 andGroup ($c)
 
 or ($c, bool $reset=false)
 
 orGroup ($c)
 
 sql ($c, bool $reset=false)
 
 escape (string $value)
 
 quote ($value, bool $escape=true)
 
 alias (string $name, string $alias)
 
 as (string $name, string $alias)
 
 in ($list, string $cast='')
 
 inSelect (string $field, dcSelectStatement $sql)
 
 dateFormat (string $field, string $pattern)
 
 like (string $field, string $pattern)
 
 regexp (string $value)
 
 unique (string $field)
 
 count (string $field, ?string $as=null, bool $unique=false)
 
 avg (string $field, ?string $as=null)
 
 max (string $field, ?string $as=null)
 
 min (string $field, ?string $as=null)
 
 sum (string $field, ?string $as=null)
 
 isNull (string $field)
 
 isNotNull (string $field)
 
 isSame (string $local, string $external)
 
 compare (string $external, bool $trigger_error=false, bool $dump=false, bool $print=false)
 

Additional Inherited Members

- Protected Attributes inherited from dcSqlStatement
const VERBOSE_SQL_ALIAS = false
 
 $con
 
 $syntax
 
 $_AS = ' '
 
 $columns = []
 
 $from = []
 
 $where = []
 
 $cond = []
 
 $sql = []
 

Detailed Description

Truncate Statement : small utility to build truncate queries

Member Function Documentation

◆ statement()

statement ( )

Returns the truncate statement

Returns
string the statement

Reimplemented from dcSqlStatement.

References dcCore\app(), dcSqlStatement\count(), and dcSqlStatement\from().

Referenced by truncate().

◆ truncate()

truncate ( )

Run the SQL select query and return result

Returns
bool

References dcSqlStatement\$sql, and statement().

Referenced by run().

◆ run()

run ( )

truncate() alias

Returns
bool

References truncate().


The documentation for this class was generated from the following file: