On Tue, Dec 12, 2006 at 11:34:52AM -0500, David Turner wrote:
> class Role(InheritableSQLObject):
> department = StringCol()
>
> class Student(Role):
> year = IntCol()
>
> Role.createTable()
> Student.createTable()
>
> first_year = Student(department="CS", year=1)
> print Student.select().max('year')
> No RelatedJoin, but it still fails.
Works for me:
1/Query : CREATE TABLE role (
id INTEGER PRIMARY KEY,
child_name VARCHAR(255),
department TEXT
)
1/QueryR : CREATE TABLE role (
id INTEGER PRIMARY KEY,
child_name VARCHAR(255),
department TEXT
)
2/Query : CREATE TABLE student (
id INTEGER PRIMARY KEY,
child_name VARCHAR(255),
year INT
)
2/QueryR : CREATE TABLE student (
id INTEGER PRIMARY KEY,
child_name VARCHAR(255),
year INT
)
3/QueryIns: INSERT INTO role (department, child_name) VALUES ('CS', NULL)
4/QueryOne: SELECT child_name, department FROM role WHERE id = (1)
4/QueryR : SELECT child_name, department FROM role WHERE id = (1)
5/Query : UPDATE role SET child_name = ('Student') WHERE id = (1)
5/QueryR : UPDATE role SET child_name = ('Student') WHERE id = (1)
6/QueryIns: INSERT INTO student (id, child_name, year) VALUES (1, NULL, 1)
7/QueryOne: SELECT child_name, year FROM student WHERE id = (1)
7/QueryR : SELECT child_name, year FROM student WHERE id = (1)
8/QueryOne: SELECT MAX(year) FROM student WHERE 1 = 1
8/QueryR : SELECT MAX(year) FROM student WHERE 1 = 1
1
What am I doing wrong? ;)
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
