Give a look here:
http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Legacy-databases-and-keyed-tables
But I think it won't work in your case because name is a string.
Our you can model it another way.
db.define_table('tiers',
Field('name', 'string'),
Field('created_on', 'datetime', default=request.now),
format = '%(name)s')
db.define_table('metrics',
Field('tier_name', 'string', requires=IS_IN_DB(db, 'tiers.name
',%(name)s')),
Field('total_count', 'integer'),
Field('total_size', 'bigint'),
Field('created_on', 'datetime', default=request.now))
However, this will not enforce reference at db level, only in application.
But you can query an join it by name without problems.
query = db(db.tiers.name == db.metrics.tier_name).select()
metric = db(db.metrics.tier_name == 'name').select()
or you can obviously write a helper function to short it
get_metrics = lambda name: db(db.metrics.tier_name == name).select()
get_tier = lambda name: db(db.tier.name == name).select().first()
tier = get_tier(name)
tier_metrics = get_metrics(name)
2014-05-27 21:35 GMT-03:00 'Michael Gheith' via web2py-users <
web2py@googlegroups.com>:
> I have two pretty basic tables:
>
> db.define_table('tiers',
> Field('name', 'string'),
> Field('created_on', 'datetime', default=request.now),
> format = '%(name)s')
>
> db.define_table('metrics',
> Field('tier_id', 'reference tiers'),
> Field('total_count', 'integer'),
> Field('total_size', 'bigint'),
> Field('created_on', 'datetime', default=request.now))
>
> I pre populated my tiers table with data. When I store data in my metrics
> table, I don't know off hand the tier_id. I know the tier name though. Is
> there a way I can use the tier name instead of the tier_id in this
> reference?
>
> --
> Resources:
> - http://web2py.com
> - http://web2py.com/book (Documentation)
> - http://github.com/web2py/web2py (Source code)
> - https://code.google.com/p/web2py/issues/list (Report Issues)
> ---
> You received this message because you are subscribed to the Google Groups
> "web2py-users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>
--
Att.
Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom
EL MELECH NEEMAN!
אָמֵן
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
