function recommender_insert_rows in Recommender API 7.5

Parameters

string $type: could be 'preference', 'prediction', 'similarity'

string $recommender: any recommender name.

array $rows: an array of values, each value is a tuple of [source_id, target_id, score, updated], where the last 2 columns are optional.

2 calls to recommender_insert_rows()

recommender_precompute_mlt in ./recommender.module

rec_example_reload_ratings in rec_example/rec_example.module

File

./recommender.module, line 114

Providing generic recommender system algorithms.

Code

function recommender_insert_rows($type, $recommender, $rows) {
  $table_name = "recommender_{$type}";
  $insert = db_insert($table_name)
    ->fields(array(
    'recommender',
    'source_id',
    'target_id',
    'score',
    'updated',
  ));
  foreach ($rows as $row) {
    $insert
      ->values(array(
      'recommender' => $recommender,
      'source_id' => $row[0],
      'target_id' => $row[1],
      'score' => isset($row[2]) ? $row[2] : 1,
      'updated' => isset($row[3]) ? $row[3] : time(),
    ));
  }
  $insert
    ->execute();
}