canax / database

     *

     * @return void

     */

    protected function create()

    {

        $this->checkDb();

        $properties = $this->getProperties();

        unset($properties[$this->tableIdColumn]);

        $columns = array_keys($properties);

        $values  = array_values($properties);

        $this->db->connect()

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

                 ->execute($values);

        $this->{$this->tableIdColumn} = $this->db->lastInsertId();

    }

     *

     * @return void

     */

    protected function update()

    {

        $this->checkDb();

        $properties = $this->getProperties();

        unset($properties[$this->tableIdColumn]);

        $columns = array_keys($properties);

        $values  = array_values($properties);

        $values[] = $this->{$this->tableIdColumn};

        $this->db->connect()

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

                 ->where("{$this->tableIdColumn} = ?")

                 ->execute($values);

    }