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
-~----------~----~----~----~------~----~------~--~---

Reply via email to