You are currently viewing the 0.11 branch api documentation. Switch to 1.0 or 1.1

0.11 Doctrine_Expression_Sqlite

Doctrine Expression Sqlite

Inheritence

Doctrine_Expression_Sqlite  < Doctrine_Expression_Driver  < Doctrine_Connection_Module

Method Summary

Returns Name Description
string concatImpl
string locateImpl
ltrimImpl
string md5Impl
string modImpl
string now
string random
string regexp
rtrimImpl
sha1Impl
string soundex The string "?000" is returned if the argument is NULL.
string substring Note: Not SQL92, but common functionality. SQLite only supports the 2 parameter variant of this function
trimImpl

Methods inherited from Doctrine_Expression_Driver

pi , upper , avg , md5 , add , between , length , ltrim , __call , trim , cos , regexp , not , mul , substring , rtrim , neq , in , mod , now , sum , isNull , sub , lte , sin , gte , count , getIdentifiers , guid , max , eq , getIdentifier , round , lt , gt , div , lower , isNotNull , soundex , concat , acos , locate , min

Method Details

  • (string) concatImpl()

    Returns a concatenation of the data that SQLite's concat() function receives.


  • $substr literal string to find
    $str literal string

    (string) locateImpl($substr, $str)

    locate returns the position of the first occurrence of substring $substr in string $str that SQLite's locate() function receives


  • ltrimImpl($str)


  • (string) md5Impl($data)

    Returns the md5 sum of the data that SQLite's md5() function receives.


  • (string) modImpl($dividend, $divisor)

    Returns the modules of the data that SQLite's mod() function receives.


  • (string) now($type = 'timestamp')

    Return string to call a variable with the current timestamp inside an SQL statement There are three special variables for current date and time.

    Doctrine_Expression_Sqlite


  • (string) random()

    return string to call a function to get random value inside an SQL statement

    Doctrine_Expression_Sqlite


  • (string) regexp()

    returns the regular expression operator


  • rtrimImpl($str)


  • sha1Impl($str)


  • (string) soundex($value)

    soundex Returns a string to call a function to compute the soundex encoding of a string

    The string "?000" is returned if the argument is NULL.

    Doctrine_Expression_Sqlite


  • $value an sql string literal or column name/alias
    $position where to start the substring portion
    $length the substring portion length

    (string) substring($value, $position, $length = null)

    return string to call a function to get a substring inside an SQL statement

    Note: Not SQL92, but common functionality.
    SQLite only supports the 2 parameter variant of this function

    Doctrine_Expression_Sqlite


  • trimImpl($str)