mysql - Foreign key relationship methods deferred and never created in RDBO -

-

i'm playing rosedb::object on employees test dataset, , reason, can't foreign key relationships ('department' , 'employee') work on deptemp object. (class structure below).

when try $e->dept_emp->[0]->department, get:

can't locate object method "department" via package "my::fakeemployees::deptemp"  methods following relationships , foreign keys deferred , never created in class my::fakeemployees::deptemp.  type            name ----            ---- foreign key     department foreign key     employee

i'm sure have set wrong in class structure, what?

class structure (some classes omitted clarity):

i created various objects using instructions in rdbo tutorial:

package my::fakeemployees::employee;  use strict;  use base qw(my::fakeemployees::db::object);  __package__->meta->setup(     table => 'employees',      columns => [         emp_no     => { type => 'serial',  not_null => 1 },         birth_date => { type => 'date',    not_null => 1 },         first_name => { type => 'varchar', length   => 14, not_null => 1 },         last_name  => { type => 'varchar', length   => 16, not_null => 1 },         gender     => { type => 'enum',    check_in => [ 'm', 'f' ], not_null => 1 },         hire_date  => { type => 'date',    not_null => 1 },     ],      primary_key_columns => ['emp_no'],     'relationships'     => [         'departments' => {             'type'      => 'many many',             'map_class' => 'my::fakeemployees::deptemp',         },         'dept_emp' => {             'type' => 'one many',             'class' => 'my::fakeemployees::deptemp',             'column_map' => { 'emp_no' => 'emp_no' },         },         'dept_manager' => {             'type' => 'one many',             'class' => 'my::fakeemployees::deptmanager',             'column_map' => { 'emp_no' => 'emp_no' },         },         'salaries' => {             'type' => 'one many',             'class' => 'my::fakeemployees::salary',             'column_map' => { 'emp_no' => 'emp_no' },         },         'titles' => {             'type' => 'one many',             'class' => 'my::fakeemployees::title',             'column_map' => { 'emp_no' => 'emp_no' },         },     ], );  __package__->meta->make_manager_class('employees');  1;  package my::fakeemployees::deptemp;  use strict;  use base qw(my::fakeemployees::db::object);  __package__->meta->setup(     table => 'dept_emp',      columns => [         dept_no   => { type => 'character', not_null => 1 },         emp_no    => { type => 'integer',   not_null => 1 },         from_date => { type => 'date' },         to_date   => { type => 'date' },     ],      primary_key_columns => [ 'emp_no', 'dept_no' ],      foreign_keys => [         department => {             class       => 'my::fakeemployees::departments',             key_columns => { dept_no => 'dept_no' },         },          employee => {             class       => 'my::fakeemployees::employees',             key_columns => { emp_no => 'emp_no' },         },     ], ); __package__->meta->make_manager_class('dept_emp');   1;  package my::fakeemployees::department;  use strict;  use base qw(my::fakeemployees::db::object);  __package__->meta->setup(     table => 'departments',      columns => [         dept_no   => { type => 'character', length => 4,  not_null => 1 },         dept_name => { type => 'varchar',   length => 40, not_null => 1 },     ],      primary_key_columns => ['dept_no'],      unique_key => ['dept_name'],      'relationships'     => [         'employees' => {             'type'      => 'many many',             'map_class' => 'my::fakeemployees::deptemp',         },     ], ); __package__->meta->make_manager_class('departments');  1;

your foreign key has typo:

foreign_keys => [     department => {         class       => 'my::fakeemployees::departments',

that should 'department', not 'departments'


Comments

Post a Comment

Popular posts from this blog

c# - Better 64-bit byte array hash -

-
i need hash algorithm produces 64-bit hash code ( long ) fewer collisions string.gethashcode() , fast (no expensive calls cryptographic functions). here's implementation of fnv still shows 3% of collisions after testing 2 million random strings. need number way lower. void main() { const string chars = "abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz!#@$%^&*()_+}{\":?><,./;'[]0123456789\\"; const int n = 2000000; var random = new random(); var hashes = new hashset<long>(); int collisions = 0; for(int = 0; < n; i++) { var len = random.next(chars.length); var str = new char[len]; (int j = 0; j < len; j++) { str[j] = chars[random.next(chars.length)]; } var s = new string(str); if(!hashes.add(get64bithash( s ))) collisions++; } console.writeline("collision percentage after " + n + " random strings: " + ((doubl
Read more

webrtc - Which ICE candidate am I using and why? -

-
[questions in bold below] i have setup kurento media server 5.1.3 in datacenter behind firewall running os ubuntu 14.04. has 2 network cards: 222.222.222.222 (eth0 - private ip) 111.111.111.111 (eth1 - public ip) attached below sdp (setremotedescription) when browser connected kurento media server type: answer, sdp: v=0 o=- 5487318114793304426 0 in ip4 0.0.0.0 s=kurento media server c=in ip4 0.0.0.0 t=0 0 a=group:bundle audio video m=audio 59068 rtp/savpf 111 0 c=in ip4 111.111.111.111 a=rtpmap:111 opus/48000/2 a=rtpmap:0 pcmu/8000 a=sendrecv a=rtcp:59068 in ip4 111.111.111.111 a=rtcp-mux a=ssrc:669011897 cname:user39019747@host-6e83e4c2 a=extmap:3 http://www.webrtc.org/experiments/rtp-hdrext/abs-send-time a=mid:audio b=as:20 a=ice-ufrag:ymdk a=ice-pwd:lylifk5ueqzpwm91ddj37e a=fingerprint:sha-256 ff:0f:81:8c:41:4e:b4:b6:c6:d8:36:f3:d6:5f:09:fd:5f:af:13:b3:9d:fc:12:66:ac:f3:56:d6:5b:0a:73:5d a=candidate:1 1 udp 2013266431 111.111.111.111 55239 typ host a=candidate:2 1 udp
Read more

php - Zend Framework / Skeleton-Application / Composer install issue -

-
i trying create zend framework application using skeleton in netbeans. when run composer install, following error message: "c:\php\php.exe" "c:\composer\composer.phar" "--ansi" "--no-interaction" "update" "--dev" using deprecated option "dev". dev packages installed default now. loading composer repositories package information updating dependencies (including require-dev) requirements not resolved installable set of packages. problem 1 - package requires php >=5.5 php version (5.4.42) not satisfy requirement. problem 2 - installation request zendframework/zendframework 2.5.1 -> satisfiable zendframework/zendframework[2.5.1]. - zendframework/zendframework 2.5.1 requires php >=5.5 -> php version (5.4.42) not satisfy requirement. done. apparently, zend framework only needs php 5.3+ contradicts above. need use php 5.4. my composer.json following: { "name": "
Read more