Re: [SQLObject] ViewSQLObject ID's

[Hans G. S. <geo...@sc...>]

On Thu, Jun 21, 2012 at 10:15:03AM +0200, Petr Jakeš wrote:
> 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.

I suppose I was looking for the ViewSQLObject class as a way to achieve
the same thing with a lesser need to learn more SQL ...

Anyway, thanks for the code example.  I reckon I can figure out how
it works by reading up on hash joins.  

> 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

-- 
:-- Hans Georg