dibi::dataSource PHP Method

dataSource() public static method

Generates and returns SQL query as DataSource - Monostate for Dibi\Connection::test().
public static dataSource ( $args ) : Dibi\DataSource
return Dibi\DataSource
    public static function dataSource($args)
    {
        $args = func_get_args();
        return self::getConnection()->dataSource($args);
    }

Usage Example

示例#1
0
 static function getDatasourceGroupByKey()
 {
     $sql = '';
     $langs = self::getAll();
     foreach ($langs as $l) {
         $sql .= '(SELECT translate FROM [lang_translate] WHERE [main].[key] = [lang_translate].[key] AND id_lang = ' . $l['id_lang'] . ') AS ' . $l['iso'] . ',';
     }
     return dibi::dataSource("\n\t\t\tSELECT\n\t\t\t\t" . $sql . "\n\t\t\t\t[key]\n\t\t\tFROM\n\t\t\t\t[lang_translate] main\n\t\t\tGROUP BY [key]");
 }
All Usage Examples Of dibi::dataSource