#!/usr/bin/env php
<?php

namespace Gazelle;

require __DIR__ . '/../../lib/bootstrap.php';

$db = DB::DB();

$db->prepared_query("
    SELECT UserID, NavItems FROM users_info WHERE NavItems != '';
");

$manager = new Manager\User();

$n = 0;
foreach ($db->to_array(false, MYSQLI_NUM) as [$id, $items]) {
    $user = $manager->findById($id);
    if (is_null($user)) {
        continue;
    }
    $user->setField('nav_list', array_map('intval', explode(',', $items)))->modify();
    ++$n;
}

echo  "migrated $n users\n";
