Re: [SQLObject] ViewSQLObject ID's

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

Hi again,

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.
> in the SQLObject I am working with the VIEW like it with an ordinary table,
> see my code below:

your approach does not seem to work; I get

  AssertionError: No primary key found in table 'scaled_feature_value'

As far as I can see, there is no way to define a primary key on a view.
I have managed to get an id column which should be unique.  Is there
something I have missed?  Such as a way to tell SQLObject not to check
for the restriction?

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