Assume the following tables: minisites { id campaign_id title }</p

OK, 2 things need be done here: proper inflector singular/plur

table and columns names about notorm HOT 2 CLOSED

vrana commented on June 27, 2024

table and columns names

from notorm.

Comments (2)

bystac commented on June 27, 2024

OK, 2 things need be done here:

proper inflector singular/plural functions
when joining automatic prepend tablename to avoid ambiguous fields errors,

Here how I solved it:
$res = $_minisites->select('minisites.id, minisites.title, campaigns.title')->fetch();

And override the Structure class:

class My_NotORM_Conversion extends NotORM_Structure_Convention {
function __construct() {
    $this->primary = 'id';
    $this->foreign = '%s_id';
    $this->table = '%s';
}
function getReferencedColumn($name, $table) {
    if ($this->table != '%s' && preg_match('(^' . str_replace('%s', '(.*)', preg_quote($this->table)) . '$)', $name, $match)) {
        $name = $match[1];
    }

    $inflector = new Inflect();
    $name = $inflector->singularize($name);
    return sprintf($this->foreign, $name, $table);
}
}

will be waiting for official solution.

from notorm.

vrana commented on June 27, 2024

$m->campaign['title'] works for me with your database structure and your $structure.

from notorm.

Recommend Projects