[Openinteract-help] SPOPS: Multiple-Filed ID Fields, Relationships

[Gert T. <th...@ba...>]

Sorry,

but the SPOPS documentation is *very* incomplete.

1) Multiple-Field ID Fields

I declared as follows:

      'articleprices' =3D> {
        'object_name'     =3D> 'articleprice',
        'class'           =3D> 'BaerShopSF::data::articleprices',
        'isa'             =3D> [ qw/ SPOPS::DBI::MySQL SPOPS::DBI / ],
        'rules_from'      =3D> [ qw/ SPOPS::Tool::DBI::Datasource=20
SPOPS::Tool::DBI::DiscoverField SPOPS::Tool::ReadOnly / ],
        'base_table'      =3D> 'ARTIKEL_VKPREIS',
        'field_discover'  =3D> 'yes',
        'id_field'        =3D> [ 'ARTIKEL', 'LAND', 'WAEHRUNG' ],
        'increment_field' =3D> 'no',
        'dbi_config'      =3D> {
                               dsn      =3D> $r->dir_config('ShopSF_DbA_S=
'),
                               username =3D> $r->dir_config('ShopSF_DbA_U=
'),
                               password =3D> $r->dir_config('ShopSF_DbA_P=
'),
                             },
        'track'           =3D> { create =3D> 1, update =3D> 1, delete =3D=
> 1 },
      },

nevertheless this fails:

    $articlespecialprice =3D BaerShopSF::data::articlespecialprices->fetc=
h( [$a,=20
$country, $currency] );

Why? Can you give some examples?

2) Relationships (has_a, links_to)

How do has_a and links_to work?
Can you give some examples?

Gert.