Query by non-primary keys.

36 Posts

nowhinjing Reply #1, 19 years, 6 months ago

Hi,

I am trying to retrieve a record using a non primary key. The statement that I am currently using generates an error - but no error message - it just stops.

I am trying to return the Template Variable record for a TV called ’tags’ : T huh

he code is :

$ctvcrit= $xpdo->newQuery('modTemplateVar', array('name:=' => 'tags'));

I have looked at it for hours (well almost) - have I got the wrong end of the stick (again) ?

Any help much appreciated.

NWJ

MODX Staff
10,725 Posts

opengeek Reply #2, 19 years, 6 months ago

@nowhinjing:

The newQuery method simply creates an xPDOQuery object to use in another method that accepts criteria. To execute that query and get an object returned just add this after your code:

$obj= $xpdo->getObject('modTemplateVar', $ctvcrit);

But you don’t need an xPDOQuery object just to retrieve an object by a simple condition:

$obj= $xpdo->getObject('modTemplateVar', array ('name' => 'tags'));

...is all it takes.

Jason Coward
Chief Architect @ MODX
http://www.jasoncoward.com | http://twitter.com/drumshaman | https://github.com/opengeek

36 Posts

nowhinjing Reply #3, 19 years, 6 months ago

Thanks, Jason,

I will try it out and let you know.

NWJ

36 Posts

nowhinjing Reply #4, 19 years, 6 months ago

Sorry, still no luck sad

Here is the snippet I am calling uncached; it returns "Starting : " then stops. If I comment out the getObject line, it returns "Starting :" - "No Record Found" and "Ending :"

I am using xPDO 34 that I retrieved via SVN.

<?php
global $modx;
define('XPDO_MODE', 2);
include_once ( $modx->config['base_path'] . 'xpdo/xpdo.class.php');

//  setup and connect to the database
$xpdo= new xPDO('mysql:host=localhost;dbname=mdx', 'mdxAdmin', 'mdxAdminLouches', 'modx_');
$xpdo->setPackage('modx095');
$xpdo->setDebug(true);

echo "<br>Starting :";
//  get the record to be worked on
$ctvdocm= $xpdo->getObject('modTemplateVar', array ('name' => 'tags'));
if ($ctvdocm) {
    echo "</br>Record Found";
} else {
    echo "</br>No Record Found";
}

echo "</br>Ending :";
return "";
?>

Thanks in advance for your help.

By the way, could I help you document xPDO, perhaps by providing worked examples as in Noddy’s Guide ?

NWJ

MODX Staff
10,725 Posts

opengeek Reply #5, 19 years, 6 months ago

Try

return print_r($xpdo->errorInfo(), 1);

immediately after the getObject call. I have a feeling the legacy MODx error handling or output buffering is preventing proper reporting of the xPDO error logging.

Regarding documentation, I will be enabling user-contributions once I stabilize the changes coming in 1.0 beta, but by all means, feel free to assist with documentation in any way you feel you can. I’m working on having tutorials and extended documentation be authored into DocBook format and linked directly into the API documentation. I can then use PhpDocumentor to produce CHM, HTML, PDF, and many other formats for distribution along with the API docs. More details on this soon...

Jason Coward
Chief Architect @ MODX
http://www.jasoncoward.com | http://twitter.com/drumshaman | https://github.com/opengeek

36 Posts

nowhinjing Reply #6, 19 years, 6 months ago

Hi, Jason,

Thanks for your quick response.

Unfortunately I am still getting nothing - "Starting :" and then blank.

Commenting out the getObject line and running again gives "Starting :Array ( [0] => )" which I suppose is logical.

Should I update to a newer SVN ?

NWJ

MODX Staff
10,725 Posts

opengeek Reply #7, 19 years, 6 months ago

Can you put your code in a php file and try it directly, rather than via MODx snippet? You need to figure out why it’s not returning a record. With debug on, you should be getting all kinds of output...

Jason Coward
Chief Architect @ MODX
http://www.jasoncoward.com | http://twitter.com/drumshaman | https://github.com/opengeek

36 Posts

nowhinjing Reply #8, 19 years, 6 months ago

Hi, Jason,

Have done as you suggested, but no luck so far.

Results are exactly as described above.

doncha luv computers !

NWJ.

36 Posts

nowhinjing Reply #9, 19 years, 6 months ago

Hi, Jason,

I think I’m getting somewhere. I tried changing the table being queried and all of a sudden it all jumped into life. I guess this points to an error in the schema / class map, so I am attaching them for your perusal as I must confess its all greek to me. When I understand how it works I would be happy to write a noddys guide; the fields I understand, but the afregates and composits huh

Schema

    <object class="modTemplateVar" table="site_tmplvars" extends="modElement">
        <field key="type" dbtype="varchar" precision="20" phptype="string" null="false" default="" />
        <field key="name" dbtype="varchar" precision="50" phptype="string" null="false" default="" />
        <field key="caption" dbtype="varchar" precision="80" phptype="string" null="false" default="" />
        <field key="description" dbtype="varchar" precision="255" phptype="string" null="false" default="" />
        <field key="editor_type" dbtype="int" precision="11" phptype="integer" null="false" default="0" />
        <field key="category" dbtype="int" precision="11" phptype="integer" null="false" default="0" />
        <field key="locked" dbtype="tinyint" precision="4" phptype="integer" null="false" default="0" />
        <field key="elements" dbtype="text" phptype="string" null="false" default="" />
        <field key="rank" dbtype="int" precision="11" phptype="integer" null="false" default="0" index="index" />
        <field key="display" dbtype="varchar" precision="20" phptype="string" null="false" default="" />
        <field key="display_params" dbtype="text" phptype="string" null="false" default="" />
        <field key="default_text" dbtype="text" phptype="string" null="false" default="" />
        <aggregate class="modCategory" key="id" local="category" foreign="id" cardinality="one" />
        <composite class="modTemplateVarTemplate" key="id" local="tmplvarid" foreign="id" cardinality="many" />
        <composite class="modTemplateVarDocument" key="id" local="tmplvarid" foreign="id" cardinality="one" />
        <composite class="modTemplateVarDocumentGroup" key="id" local="tmplvarid" foreign="id" cardinality="many" />
    </object>

Map

$xpdo_meta_map['modTemplateVar']= array (
  'table' => 'site_tmplvars',
  'fields' => 
  array (
    'type' => '',
    'name' => '',
    'caption' => '',
    'description' => '',
    'editor_type' => '0',
    'category' => '0',
    'locked' => '0',
    'elements' => '',
    'rank' => '0',
    'display' => '',
    'display_params' => '',
    'default_text' => '',
  ),
  'fieldMeta' => 
  array (
    'type' => 
    array (
      'dbtype' => 'varchar',
      'precision' => '20',
      'phptype' => 'string',
      'null' => 'false',
    ),
    'name' => 
    array (
      'dbtype' => 'varchar',
      'precision' => '50',
      'phptype' => 'string',
      'null' => 'false',
    ),
    'caption' => 
    array (
      'dbtype' => 'varchar',
      'precision' => '80',
      'phptype' => 'string',
      'null' => 'false',
    ),
    'description' => 
    array (
      'dbtype' => 'varchar',
      'precision' => '255',
      'phptype' => 'string',
      'null' => 'false',
    ),
    'editor_type' => 
    array (
      'dbtype' => 'int',
      'precision' => '11',
      'phptype' => 'integer',
      'null' => 'false',
    ),
    'category' => 
    array (
      'dbtype' => 'int',
      'precision' => '11',
      'phptype' => 'integer',
      'null' => 'false',
    ),
    'locked' => 
    array (
      'dbtype' => 'tinyint',
      'precision' => '4',
      'phptype' => 'integer',
      'null' => 'false',
    ),
    'elements' => 
    array (
      'dbtype' => 'text',
      'phptype' => 'string',
      'null' => 'false',
    ),
    'rank' => 
    array (
      'dbtype' => 'int',
      'precision' => '11',
      'phptype' => 'integer',
      'null' => 'false',
      'index' => 'index',
    ),
    'display' => 
    array (
      'dbtype' => 'varchar',
      'precision' => '20',
      'phptype' => 'string',
      'null' => 'false',
    ),
    'display_params' => 
    array (
      'dbtype' => 'text',
      'phptype' => 'string',
      'null' => 'false',
    ),
    'default_text' => 
    array (
      'dbtype' => 'text',
      'phptype' => 'string',
      'null' => 'false',
    ),
  ),
  'aggregates' => 
  array (
    'modCategory' => 
    array (
      'id' => 
      array (
        'local' => 'category',
        'foreign' => 'id',
        'cardinality' => 'one',
      ),
    ),
  ),
  'composites' => 
  array (
    'modTemplateVarTemplate' => 
    array (
      'id' => 
      array (
        'local' => 'tmplvarid',
        'foreign' => 'id',
        'cardinality' => 'many',
      ),
    ),
    'modTemplateVarDocument' => 
    array (
      'id' => 
      array (
        'local' => 'tmplvarid',
        'foreign' => 'id',
        'cardinality' => 'one',
      ),
    ),
    'modTemplateVarDocumentGroup' => 
    array (
      'id' => 
      array (
        'local' => 'tmplvarid',
        'foreign' => 'id',
        'cardinality' => 'many',
      ),
    ),
  ),
);
$xpdo_meta_map['modtemplatevar']= & $xpdo_meta_map['modTemplateVar'];

Thank you for taking the time to help - I really do appreciate your efforts and xPDO is just wonderful !

NWJ

36 Posts

nowhinjing Reply #10, 19 years, 6 months ago

Bump !

Can anyone help - pretty please kiss

NWJ