canax / database

     *

     * @return void

     */

    private function create()

    {

        $db = $this->db;

        $properties = $this->getProperties();

        unset($properties['id']);

        $columns = array_keys($properties);

        $values  = array_values($properties);

        $db->connect()

           ->insert($this->tableName, $columns)

           ->execute($values);

        $this->id = $this->db->lastInsertId();

    }

     *

     * @return void

     */

    private function update($values)

    {

        $db = $this->db;

        $properties = $this->getProperties();

        unset($properties['id']);

        $columns = array_keys($properties);

        $values  = array_values($properties);

        $values[] = $this->id;

        $db->connect()

           ->update($this->tableName, $columns)

           ->where("id = ?")

           ->execute($values);

    }