Thanks Jim; perfect. As for buying a book... I am a QA engineer trying to write a very basic webframework that displays some testing Urls from a database. I am not planning on being a web designer. But the suggestion is appreciated.
On Jul 2, 1:33 pm, Jim Steil <[EMAIL PROTECTED]> wrote: > I do the same thing that you want. Here is how I would do it: > > class WebAppPages(SQLObject): > class sqlmeta: > style=Style(longID=True) > idName = 'pageID' > > url = StringCol() > pageName = StringCol() > post = IntCol() > > SMERSH009 wrote: > > Hi All, > > When this code gets executed from my model.py file, it causes 2 > > problems for me. > > > class WebAppPages(SQLObject): > > pageID = IntCol() > > url = StringCol() > > pageName = StringCol() > > post = IntCol() > > > here is what the output looks like: > > D:\Temp\1Python\WebappsPy\WebAppTesting1>tg-admin sql sql > > Using database URI mysql://root:[EMAIL PROTECTED]/test > > CREATE TABLE web_app_pages ( > > id INT PRIMARY KEY AUTO_INCREMENT, > > page_id INT, > > url TEXT, > > page_name TEXT, > > post INT > > ); > > > The first issue is that I do not want this column created at all: > > id INT PRIMARY KEY AUTO_INCREMENT, > > > instead, I want the column pageID to be my primary key by default. Is > > there a way to declare this beforehand? > > > The second, but not as vital issue, is that capital letters in the > > names get changed to underscores. > > So for example pageID = IntCol() gets created as page_id INT > > > Much thanks for the assistance. > > Sam --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" 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/turbogears?hl=en -~----------~----~----~----~------~----~------~--~---
