PHP FluentSql\StaticSQL::RAW Exemples

Exemple #1

Fichier : nfcNormalizeVideos.php Projet : Tjorriemorrie/app

 /**
  * Return an array of videos
  *
  * @param DatabaseMysql $db
  * @return array
  */
 protected static function getVideoRows(DatabaseMysql $db)
 {
     return (new WikiaSQL())->SELECT('img_name', 'img_metadata', 'img_sha1')->FROM('image')->WHERE('img_media_type')->EQUAL_TO('VIDEO')->AND_(FluentSql\StaticSQL::RAW('img_name <> CONVERT(img_name USING ASCII)'))->runLoop($db, function (&$videos, $row) {
         $videos[] = $row;
     });
 }