Interesting the bug is because of an off feature of GAE (at least on
localhost). If two fields are type StringListProperty they must be two
different instances of the StringListProperty class else the two
fields are just alias of each other. I did not see this documented
anywhere.
Massimo
On Sep 1, 6:24 am, "Martin.Mulone" <mulone.mar...@gmail.com> wrote:
> *********************
> /models/db.py
> ******************
>
> db.define_table('posts',
> db.Field('id', 'id'),
> db.Field('keywords', 'list:string'), #tags
> db.Field('fulltext', 'list:string'), migrate=True)
>
> posts=db(db.posts.id>0).select()
> if not posts:
>
> db.posts.insert(keywords=['key1','key2','key3'],fulltext=['full1','full2','full3'])
>
> db.posts.insert(keywords=['key10','key20','key30'],fulltext=['full10','full20','full30'])
>
> **************************
> /controllers/default.py
> **************************
>
> def index():
> response.flash = T('Welcome to web2py')
>
> keywords=[]
> fulltext=[]
> posts = db(db.posts.id == 1).select()
> if posts:
> post = posts[0]
> keywords = post.keywords
> fulltext = post.fulltext
>
> return dict(message=T('Hello
> World'),keywords=keywords,fulltext=fulltext)
>
> ****************************
> /views/default/index.html
> *****************************
>
> {{extend 'layout.html'}}
>
> {{if 'message' in globals():}}{{=H2(message)}}{{else:}}
> {{=BEAUTIFY(response._vars)}}{{pass}}
>
> <hr />
> <h1>List Problem</h1>
> <p>The problem is only on gae... correct: full1,full2,full3 ....
> key1,key2,key3</p>
>
> {{=BEAUTIFY(response._vars)}}
>
> *************************************************************
>
> And show this:
>
> In local sqlite:http://yfrog.com/0tcorrectsqlitep
>
> But in local-gae:http://yfrog.com/j3problemgaep
>
> On Sep 1, 7:16 am, "Martin.Mulone" <mulone.mar...@gmail.com> wrote:
>
> > This is a writing mistake, Massimo please take a look to the
> > application, i make it with keywords = ['keywords1','keywords2'] and
> > the problem still there.
>
> > On 1 sep, 00:21, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > > there is an error right here:
>
> > > post.update_record(keywords = 'keywords1 keywords2')
>
> > > should be
>
> > > post.update_record(keywords = ['keywords1','keywords2'])
>
> > > On Aug 31, 9:45 am, "Martin.Mulone" <mulone.mar...@gmail.com> wrote:
>
> > > > I don't get the logic of this problem. This problem only ocurrs in
> > > > GAE, local works fine.
>
> > > > I'am using the new introduce features list:string
>
> > > > My db definition is similar to this (only the necesary):
>
> > > > db.define_table('posts',
> > > > db.Field('id', 'id'),
> > > > db.Field('keywords', 'list:string'), #tags
> > > > db.Field('fulltext', 'list:string'), migrate=true)
>
> > > > When i changed the content with this (before i insert the record with
> > > > no problem):
>
> > > > posts = db(db.posts.id == id).select()
> > > > if posts:
> > > > post = posts[0]
> > > > post.update_record(keywords = 'keywords1 keywords2')
>
> > > > I list the db and all is fine.
>
> > > > Then I modified the same record with this
>
> > > > posts = db(db.posts.id == id).select()
> > > > if posts:
> > > > post = posts[0]
> > > > post.update_record(fulltext = 'fulltext1 fulltext2')
>
> > > > I list the db and I have:
>
> > > > ------------> keywords = 'fulltext1 fulltext2'
>
> > > > I am really stuck with this problem.
