OCA\OcSms\Db\ConversationStateMapper::migrate PHP Method

migrate() public method

* Migration steps
public migrate ( )
    public function migrate()
    {
        $sql = 'SELECT user_id, datakey, datavalue FROM ' . '*PREFIX*ocsms_user_datas WHERE datakey LIKE \'lastReadDate-%\'';
        $query = \OCP\DB::prepare($sql);
        $result = $query->execute(array());
        while ($row = $result->fetchRow()) {
            $pn = preg_replace("#lastReadDate[-]#", "", $row["datakey"]);
            $this->setLast($row["user_id"], $pn, $row["datavalue"]);
        }
        $query = \OCP\DB::prepare("DELETE FROM *PREFIX*ocsms_user_datas WHERE datakey LIKE 'lastReadDate-%'");
        $query->execute(array());
    }