canax / database

     *

     * @return void

     */

    protected function create()

    {

        $this->checkDb();

        $properties = $this->getProperties();

        unset($properties['id']);

        $columns = array_keys($properties);

        $values  = array_values($properties);

        $this->db->connect()

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

                 ->execute($values);

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

    }

     *

     * @return void

     */

    protected function update()

    {

        $this->checkDb();

        $properties = $this->getProperties();

        unset($properties['id']);

        $columns = array_keys($properties);

        $values  = array_values($properties);

        $values[] = $this->id;

        $this->db->connect()

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

                 ->where("id = ?")

                 ->execute($values);

    }