Re: [SQLObject] ViewSQLObject ID's

[Petr J. <pet...@tp...>]

Hi,
I am not sure if following is what are you looking for, but in my case, I
have a view defined manually on the SQL server side.
in the SQLObject I am working with the VIEW like it with an ordinary table,
see my code below:

=========== SQLObject part ===============
class HashView(SQLObject):
    class sqlmeta:
        fromDatabase = True
        columnList = True
=========================================

================== server part =====================================

CREATE VIEW HASH_VIEW (ID, OSOBY_ID, JMENO_1, JMENO_2, IBUTTON, MD5_HASH,
T_STAMP)
AS
select m.id, deriv.osoby_id, deriv.jmeno_1, deriv.jmeno_2, deriv.ibutton,
m.md5_hash, deriv.t_stamp
from hash m
join
    (
    select m1.osoby_id, p.jmeno_1, p.jmeno_2, p.ibutton, max(m1.t_stamp)
    from hash m1
       join osoby p on (p.id = m1.osoby_id)
    group by 1,2,3,4)
        as deriv (osoby_id, jmeno_1, jmeno_2, ibutton, t_stamp)  on
m.osoby_id = deriv.osoby_id

where deriv.t_stamp = m.t_stamp;

GRANT DELETE, INSERT, REFERENCES, SELECT, UPDATE
 ON HASH_VIEW TO  SYSDBA WITH GRANT OPTION;
=====================================================================

HTH

Petr