this
db.TABLENAME.id[id] = dict(field=value,field=value)
should be
db.TABLENAME[id] = dict(field=value,field=value)
if id is 0, this is create and if is>0 this is update.
On Mar 5, 12:47 am, compassiontara <[email protected]> wrote:
> Thank you!
>
> Mengu on irc helped make me all smart as well.
>
> For completeness sakes in case someone else gets as dumb as me, a very
> very quick reference, based on what I've learned today.
>
> #make the DB.
> db.define_table('tablename',Field('fieldname','type',options)
>
> INSERT:
> db.TABLENAME.insert(field=value,field=value)
>
> UPDATE:
> get object from query
> object.update_record(field=value,field=value)
>
> you *can* do this, but well....
> db.TABLENAME.id[id] = dict(field=value,field=value)
>
> DELETE:
> db(db.table.id == 5).delete()
>
> QUERY:
> db(WHERE CLAUSE).select(WHAT TO GET)
>
> get first entry:
> object = db(where).select().first()
>
> On Mar 4, 7:10 pm, mdipierro <[email protected]> wrote:
>
> > It is not
>
> > >>> db().select(db.test.id>0)
>
> > but
>
> > >>> db(db.test.id>0).select()
>
> > db(condition).select(*fields,orderby=..,groupby=...,limitby=...,cache=...,distinct=...)
>
> > On Mar 4, 5:26 pm, compassiontara <[email protected]> wrote:
>
> > > Hi everyone. I'm having an issue with select() working after an
> > > insert.
>
> > > See below for what I'm doing:
>
> > > zulu ~/web2py % ./web2py.py -S welcome
> > > web2py Enterprise Web Framework
> > > Created by Massimo Di Pierro, Copyright 2007-2010
> > > Version 1.76.3 (2010-03-03 10:47:17)
> > > Database drivers available: SQLite3
> > > WARNING:root:import IPython error, use default python shell
> > > Python 2.5.1 (r251:54863, Feb 6 2009, 19:02:12)
> > > [GCC 4.0.1 (Apple Inc. build 5465)] on darwin
> > > Type "help", "copyright", "credits" or "license" for more information.
> > > (InteractiveConsole)>>> db=DAL('sqlite://test.db')
> > > >>> db.define_table('test',Field('first','string'),Field('last','string'))
>
> > > <CUT for readability>>>> db().select(db.test.id>0)
>
> > > <gluon.sql.Rows object at 0x1920ff0>>>>
> > > db.test.insert(first='tara',last='birl')
> > > 1
> > > >>> db().select(db.test.id>0)
>
> > > Traceback (most recent call last):
> > > File "<console>", line 1, in <module>
> > > File "/Users/tara/web2py/gluon/sql.py", line 3056, in select
> > > return self.parse(db,rows,self.colnames)
> > > File "/Users/tara/web2py/gluon/sql.py", line 3073, in parse
> > > field = table[fieldname]
> > > File "/Users/tara/web2py/gluon/sql.py", line 1556, in __getitem__
> > > return dict.__getitem__(self, str(key))
> > > KeyError: 'id>0'>>> db.commit()
> > > >>> db().select(db.test.id>0)
>
> > > Traceback (most recent call last):
> > > File "<console>", line 1, in <module>
> > > File "/Users/tara/web2py/gluon/sql.py", line 3056, in select
> > > return self.parse(db,rows,self.colnames)
> > > File "/Users/tara/web2py/gluon/sql.py", line 3073, in parse
> > > field = table[fieldname]
> > > File "/Users/tara/web2py/gluon/sql.py", line 1556, in __getitem__
> > > return dict.__getitem__(self, str(key))
> > > KeyError: 'id>0'
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
