[symfony-users] Re: Is there a better way to find a related record other than looping?
I would just create a new method:
$entry->findOneMetaDataByType(EntryMeta::Superscript);
In there, for now you can have your loop (no problem with that.. loops
are not all evil).
If at some point you come up with a better solution (for performance
reasons or whatever) you can just change the inner workings of that
method, without breaking the rest of your code.
Everything else would be early optimization I think.
Have a great day,
Daniel
On May 14, 2:22 pm, nick wrote:
> I'm assuming you also need all of the Entry objects, for some reason
> that you did not mention? Because, clearly, if you didn't need all of
> the Entry objects, you could just get the EntryMeta objects that you
> want with a JOIN statement. But, assuming you need the extra data for
> some other reason, you could use a built-in PHP function, like
> array_walk(), to look through the array of Entry objects that were
> returned from database. I think this still involves a loop, but the
> loop is no longer happening in your code, it gets moved to the innards
> of array-walk().
>
> On May 13, 11:59 pm, joshuacoady wrote:
>
> > The schema for this is below, but say I'm working with the Entry
> > object and the query that loads the Entry object also loads the
> > related EntryMeta at the same time. Now, I want to find the Entry's
> > MetaData record that has a particular value for type. Is there a
> > better way to do this than to loop through all of the Entry's
> > MetaData?
>
> > foreach($entry->MetaData as $meta)
> > {
> > if($meta->type == EntryMeta::Superscript)
> > {
> > $superscript = $meta->value;
> > break;
> > }
> > }
>
> > Is there a way to do something more like the following?
>
> > $superscript = $entry->MetaData->findOneByType(EntryMeta::Superscript)-
>
> > >value;
>
> > And neither of these should query the DB since I've already loaded all
> > the Entry's MetaData when I originally queried the DB for the Entry.
> > Is there some way to do this that I'm missing?
>
> > Thanks!
>
> > Entry:
> > columns:
> > id:
> > type: integer
> > primary: true
> > autoincrement: true
> > notnull: true
> > slug:
> > type: string(255)
> > notnull: true
> > headword:
> > type: string(255)
> > notnull: true
> > options:
> > type: INNODB
> > collate: utf8_unicode_ci
> > charset: utf8
> > indexes:
> > slug:
> > fields: [slug]
>
> > EntryMeta:
> > columns:
> > id:
> > type: integer
> > primary: true
> > autoincrement: true
> > notnull: true
> > entry_id:
> > type: integer
> > notnull: true
> > type:
> > type: integer
> > notnull: true
> > value:
> > type: string(2000)
> > notnull: true
> > indexes:
> > uk_type:
> > fields: [entry_id, type]
> > type: unique
> > relations:
> > Entry:
> > local: entry_id
> > foreign: id
> > foreignAlias: MetaData
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"symfony users" group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~--~~~~--~~--~--~---
[symfony-users] Re: Is there a better way to find a related record other than looping?
I'm assuming you also need all of the Entry objects, for some reason
that you did not mention? Because, clearly, if you didn't need all of
the Entry objects, you could just get the EntryMeta objects that you
want with a JOIN statement. But, assuming you need the extra data for
some other reason, you could use a built-in PHP function, like
array_walk(), to look through the array of Entry objects that were
returned from database. I think this still involves a loop, but the
loop is no longer happening in your code, it gets moved to the innards
of array-walk().
On May 13, 11:59 pm, joshuacoady wrote:
> The schema for this is below, but say I'm working with the Entry
> object and the query that loads the Entry object also loads the
> related EntryMeta at the same time. Now, I want to find the Entry's
> MetaData record that has a particular value for type. Is there a
> better way to do this than to loop through all of the Entry's
> MetaData?
>
> foreach($entry->MetaData as $meta)
> {
> if($meta->type == EntryMeta::Superscript)
> {
> $superscript = $meta->value;
> break;
> }
> }
>
> Is there a way to do something more like the following?
>
> $superscript = $entry->MetaData->findOneByType(EntryMeta::Superscript)-
>
> >value;
>
> And neither of these should query the DB since I've already loaded all
> the Entry's MetaData when I originally queried the DB for the Entry.
> Is there some way to do this that I'm missing?
>
> Thanks!
>
> Entry:
> columns:
> id:
> type: integer
> primary: true
> autoincrement: true
> notnull: true
> slug:
> type: string(255)
> notnull: true
> headword:
> type: string(255)
> notnull: true
> options:
> type: INNODB
> collate: utf8_unicode_ci
> charset: utf8
> indexes:
> slug:
> fields: [slug]
>
> EntryMeta:
> columns:
> id:
> type: integer
> primary: true
> autoincrement: true
> notnull: true
> entry_id:
> type: integer
> notnull: true
> type:
> type: integer
> notnull: true
> value:
> type: string(2000)
> notnull: true
> indexes:
> uk_type:
> fields: [entry_id, type]
> type: unique
> relations:
> Entry:
> local: entry_id
> foreign: id
> foreignAlias: MetaData
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"symfony users" group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~--~~~~--~~--~--~---
[symfony-users] Re: Is there a better way to find a related record other than looping?
Depending on how the data is organised you can try:
$entry->MetaData[EntryMeta::Superscript]['value'] or
$entry->MetaData[EntryMeta::Superscript]->value
-Original Message-
From: symfony-users@googlegroups.com [mailto:symfony-us...@googlegroups.com]
On Behalf Of joshuacoady
Sent: 14 May 2009 05:59
To: symfony users
Subject: [symfony-users] Is there a better way to find a related record
other than looping?
The schema for this is below, but say I'm working with the Entry
object and the query that loads the Entry object also loads the
related EntryMeta at the same time. Now, I want to find the Entry's
MetaData record that has a particular value for type. Is there a
better way to do this than to loop through all of the Entry's
MetaData?
foreach($entry->MetaData as $meta)
{
if($meta->type == EntryMeta::Superscript)
{
$superscript = $meta->value;
break;
}
}
Is there a way to do something more like the following?
$superscript = $entry->MetaData->findOneByType(EntryMeta::Superscript)-
>value;
And neither of these should query the DB since I've already loaded all
the Entry's MetaData when I originally queried the DB for the Entry.
Is there some way to do this that I'm missing?
Thanks!
Entry:
columns:
id:
type: integer
primary: true
autoincrement: true
notnull: true
slug:
type: string(255)
notnull: true
headword:
type: string(255)
notnull: true
options:
type: INNODB
collate: utf8_unicode_ci
charset: utf8
indexes:
slug:
fields: [slug]
EntryMeta:
columns:
id:
type: integer
primary: true
autoincrement: true
notnull: true
entry_id:
type: integer
notnull: true
type:
type: integer
notnull: true
value:
type: string(2000)
notnull: true
indexes:
uk_type:
fields: [entry_id, type]
type: unique
relations:
Entry:
local: entry_id
foreign: id
foreignAlias: MetaData
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"symfony users" group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~--~~~~--~~--~--~---
[symfony-users] Re: Is there a better way to find a related record other than looping?
Heh J
From: symfony-users@googlegroups.com [mailto:symfony-us...@googlegroups.com] On
Behalf Of Thomas Rabaix
Sent: 14 May 2009 10:53
To: symfony-users@googlegroups.com
Subject: [symfony-users] Re: Is there a better way to find a related record
other than looping?
Hello,
If there is only one type per entry then you should use index by
feature. The key of the doctrine collection will be type ... so no
looping is needed
$entry->MetaData[EntryMeta::Superscript] will return the meta data model
On Thu, May 14, 2009 at 5:59 AM, joshuacoady wrote:
The schema for this is below, but say I'm working with the Entry
object and the query that loads the Entry object also loads the
related EntryMeta at the same time. Now, I want to find the Entry's
MetaData record that has a particular value for type. Is there a
better way to do this than to loop through all of the Entry's
MetaData?
foreach($entry->MetaData as $meta)
{
if($meta->type == EntryMeta::Superscript)
{
$superscript = $meta->value;
break;
}
}
Is there a way to do something more like the following?
$superscript = $entry->MetaData->findOneByType(EntryMeta::Superscript)-
>value;
And neither of these should query the DB since I've already loaded all
the Entry's MetaData when I originally queried the DB for the Entry.
Is there some way to do this that I'm missing?
Thanks!
Entry:
columns:
id:
type: integer
primary: true
autoincrement: true
notnull: true
slug:
type: string(255)
notnull: true
headword:
type: string(255)
notnull: true
options:
type: INNODB
collate: utf8_unicode_ci
charset: utf8
indexes:
slug:
fields: [slug]
EntryMeta:
columns:
id:
type: integer
primary: true
autoincrement: true
notnull: true
entry_id:
type: integer
notnull: true
type:
type: integer
notnull: true
value:
type: string(2000)
notnull: true
indexes:
uk_type:
fields: [entry_id, type]
type: unique
relations:
Entry:
local: entry_id
foreign: id
foreignAlias: MetaData
--
Thomas Rabaix
http://rabaix.net
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"symfony users" group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~--~~~~--~~--~--~---
[symfony-users] Re: Is there a better way to find a related record other than looping?
Hello,
If there is only one type per entry then you should use index by
feature. The key of the doctrine collection will be type ... so no
looping is needed
$entry->MetaData[EntryMeta::Superscript] will return the meta data model
On Thu, May 14, 2009 at 5:59 AM, joshuacoady wrote:
>
> The schema for this is below, but say I'm working with the Entry
> object and the query that loads the Entry object also loads the
> related EntryMeta at the same time. Now, I want to find the Entry's
> MetaData record that has a particular value for type. Is there a
> better way to do this than to loop through all of the Entry's
> MetaData?
>
> foreach($entry->MetaData as $meta)
> {
> if($meta->type == EntryMeta::Superscript)
> {
>$superscript = $meta->value;
>break;
> }
> }
>
> Is there a way to do something more like the following?
>
> $superscript = $entry->MetaData->findOneByType(EntryMeta::Superscript)-
> >value;
>
> And neither of these should query the DB since I've already loaded all
> the Entry's MetaData when I originally queried the DB for the Entry.
> Is there some way to do this that I'm missing?
>
> Thanks!
>
>
> Entry:
> columns:
>id:
> type: integer
> primary: true
> autoincrement: true
> notnull: true
>slug:
> type: string(255)
> notnull: true
>headword:
> type: string(255)
> notnull: true
> options:
>type: INNODB
>collate: utf8_unicode_ci
>charset: utf8
> indexes:
>slug:
> fields: [slug]
>
> EntryMeta:
> columns:
>id:
> type: integer
> primary: true
> autoincrement: true
> notnull: true
>entry_id:
> type: integer
> notnull: true
>type:
> type: integer
> notnull: true
>value:
> type: string(2000)
> notnull: true
> indexes:
>uk_type:
> fields: [entry_id, type]
> type: unique
> relations:
>Entry:
> local: entry_id
> foreign: id
> foreignAlias: MetaData
>
> >
>
--
Thomas Rabaix
http://rabaix.net
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"symfony users" group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~--~~~~--~~--~--~---
