This is what I have:
order = []
for product_id, qty, val in session.cart:
order.append(( product_id, qty, val ))
store.define_table('doacao',
Field('user_id',db.auth_user,requires=IS_IN_DB(db,
db.auth_user.id)),
Field('animais','list:string'),
Field('valores','list:string'),
Field('data','datetime',default=request.now),
)
assuming order = [(12,1,21.4),(15,1,45.3)]
doacao = dict(
user_id=auth.user_id,
animais=[ord[0] for ord in order],
valores=[ord[2] for ord in order],
data=datetime.today()+timedelta(hours=4)
)
session.id_doacao = db.doacao.insert(**doacao)
I got animais with '|12|15|' and valores = '|21.4|45.3|'
2010/11/23 mdipierro <[email protected]>
> No it does not. This is what I get:
>
> >>> db.define_table('name',Field('value','list:string'))
> >>> db.name.insert(value=['hello','world'])
> 1
> >>> db.name(1).value
> ['hello', 'world']
> >>> for row in db(db.name).select(): print row
> <Row {'update_record': <function <lambda> at 0x1698f70>, 'value':
> ['hello', 'world'], 'id': 1, 'delete_record': <function <lambda> at
> 0x16a0030>}>
>
> I think you inserted '|21.5|45.3|' instead of ['21.5','45.3'] and you
> get back what you insert.
>
>
> On Nov 23, 10:08 am, Bruno Rocha <[email protected]> wrote:
> > HI, I am taking advantage of this thread to solve a doubt about
> > list:string,
> > How can I get the values from list:string field rendered as a Python
> 'list'
> > ?
> >
> > Is there a ready way in DAL, or I need to use .split() and .join() ?
> >
> > look:
> >
> > >>> row = db(db.doacao.user_id==23).select()[0]
> > >>> row
> >
> > <Row {'user_id': 23, 'exibir': True, 'twitter': None, 'update_record':
> > <function <lambda> at 0x930ae64>, 'projeto': None, 'animais': '|12|20|',
> > 'valores': '|21.5|45.3|', 'obs': None, 'sorteio': '5796', 'total': 20.0,
> > 'data': datetime.datetime(2010, 11, 23, 10, 7, 48), 'id': 58,
> > 'delete_record': <function <lambda> at 0x930ae2c>}>>>> row.animais
> > '|12|20|'
> > >>> row.valores
> >
> > '|21.5|45.3|'
> >
> > At this point the 'list:string' fields returns 'str' , I can split this
> by
> > '|' and create a new list, but may be DAL has a function for doing that?
> >
> > 2010/10/25 mdipierro <[email protected]>
> >
> >
> >
> > > hmmmm. that is possible. Will look into it.
> >
> > > On Oct 25, 3:59 pm, yamandu <[email protected]> wrote:
> > > > It seems that this widget does not work when there is more than one
> > > > list:string field in a page.
> >
> > > > On Oct 25, 2:01 am, mdipierro <[email protected]> wrote:
> >
> > > > > The list:string is not an alternative to using a tag table and
> > > > > tag_link many-to-many (an example of which is provided by
> > > > > plugin_tagging).
> >
> > > > > Yet you should not have the problem you experience. With recent
> > > > > versions of web2py, Field('keywords', 'list:string') should be
> > > > > rendered by a new widget that takes one keyword per line and adds
> new
> > > > > lines when yo press enter. You should not be using '|' to separate
> > > > > keywords. If you do all keywords will be interpreted as one long
> > > > > keyword containing the '|'s.
> >
> > > > > Massimo
> >
> > > > > On Oct 24, 10:35 pm, rick <[email protected]> wrote:
> >
> > > > > > I'm getting frustrated with the list:string field type.
> >
> > > > > > I store products, each product has "keywords" that describe the
> > > > > > product.
> > > > > > db.define_table('products',
> > > > > > Field('keywords', 'list:string'))
> > > > > > I don't know what the keywords will be, so I can't use
> IS_IN_SET()
> >
> > > > > > It seems to stores the keywords fine, as long as (I'm using Crud)
> > > > > > I separate the keywords like this: green|blue|red
> >
> > > > > > But when I make this call
> > > > > > rows = db(db.products.keywords.contains(keyword)).select()
> > > > > > I don't get all the products back that I should! In fact, it
> seems
> > > > > > that I need to do an update on the product (again using Crud,
> > > > > > and any sort of update) before the product's keywords will be
> > > > > > picked up.
> >
> > > > > > Is this a problem with using Crud?
> > > > > > In all honesty, I'd be more comfortable not using list:string,
> and
> > > > > > having a separate table "keywords" that linked (many-to-one)
> > > > > > to the products table, but I really don't know how I would even
> > > > > > begin to do that in web2py..
> >
> > > > > > Thanks for reading!
> > > > > > - rick
> >
> > --
> >
> > Bruno Rochahttp://about.me/rochacbruno/bio
>
--
Bruno Rocha
http://about.me/rochacbruno/bio
