Exemple #1
0
 public static function insertMultiple($tracks)
 {
     // build insert multiple data
     $model = self::model();
     $track_sql = "INSERT IGNORE INTO {$model->tableName()} (hash, title, artist_hash, created_at, updated_at) VALUES ";
     $values_sql = array();
     foreach ($tracks as $hash => $track) {
         $title = Artist::mres($track['title']);
         $values_sql[] = "('{$hash}', '{$title}', '{$track['artist_hash']}', NOW(), NOW())";
     }
     $track_sql .= implode(', ', $values_sql);
     return Yii::app()->getDb()->createCommand($track_sql)->execute();
 }