如何在PHPixie中为模型指定数据库表名？

Question

I've got an error

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'phpixie.persons' doesn't exist

when queuering table 'people':

public function getPerson($person_id)
{
    return $this->components()->orm()->query('person')
        ->where('id', $person_id)
        ->findOne();
}

From documentation:

By default ORM assumes that the table name is the plural of the name of the model, and that the name of the primary key is ‘id’.

How can i specify table name directly?

PS Or specify rules list like EnglishPluralizationService:

{"child", "children"} {"corpus","corpora"} {"person", "people"}

Answer 1

Depending on which version of PHPixie you are using, there are different solutions to specify the table name for a model:

2.x

Assuming you already have a Person model, you can specify the table name using the $table field:

class Person extends \PHPixie\ORM\Model
{
     public $table = 'person';
}

For reference, see:

• https://phpixie.com/2.x/orm.html

3.x

You can override the default assumptions in your configuration file:

return array(
    'models' => array(
        'person' => array(
            'table'=> 'persons',
        ),
    );
);

For reference, see:

• https://phpixie.com/components/orm.html#configuration