[web2py] Re: MySQL, migration, and lower()

a blank db and let it generate a dummy sql > > > table. swap the table with the one you changed the table names in step > > > 1 -> after turning off web2py i.e. > > > > -- > > > Praneeth > > > IRC: lifeeth > > > > On Thu, Apr 21, 2011 at

[web2py] MySQL, migration, and lower()

Hi Everybody, Yesterday evening I ran into some issues updating an app from 1.89.6 to 1.94.5 -- specifically with case sensitivity in migrating tables. This occurs on an ubuntu ec2 instance, running mysql as installed by 'aptitude install mysql-server' and accepting defaults. An example. The fie

[web2py] GAE 1.4.3 has support for mysql and sqlite?

Upgrading my GAE sdk this afternoon, I noticed a few new files in google_appengine/google/appengine/api: * rdbms.py * rdbms_mysqldb.py * rdbms_sqlite.py A little exploration through the files and a little googling didn't turn up much telling information. I know Google has promised hosted sql (http

[web2py] db.mytable(myid) syntax throws exception for GAE in 1.86.2

It boils down to this: record = self._db(self._id == id).select(limitby=(0,1)).first() File \"/Users/robertm/backbeat/backbeat/3rd/web2py/gluon/sql.py\", line 1683, in __getattr__ return dict.__getitem__(self,key) KeyError: '_id' I think the issue is that gql.py Table.__init__ does not