On Friday, March 02, 2012 07:27:41 AM John Fabiani wrote:
> On Friday, March 02, 2012 01:56:16 PM Dewald Jacobs wrote:
> > Hi,
> >
> > I have a SQLite database with a View (created with the command CREATE
> > VIEW, just to be clear) that was created by combining 2 tables plus and
> > an added column to compute JULIANDAY. How would I go about adding this
> > View in a grid in Class Designer? I want to treat this view exactly the
> > same as a normal table and have tried to implement it as such, but have
> > failed to do so.
> >
> > Any tips or advice would be much appreciated.
> >
> > Thanks
> > Dewald
>
> I don't use SQLite.
> But, looking at the code - dbSQLite.py - the views are not retrieved.
> Something like
> select name from sqlite_master where type = 'view'
> is needed.
>
> Question is how best to add in the views and will anything need changing to
> support ClassDesigner.
>
> Johnf
Opps - sent to fast!
Try this and see if it works.
In dbSQLite.py
def getTables(self, cursor, includeSystemTables=False):
cursor.execute("select * from sqlite_master")
rs = cursor.getDataSet()
if includeSystemTables:
tables = [rec["name"] for rec in rs
if rec["type"] == "table"]
else:
tables = [rec["name"] for rec in rs
if rec["type"] == "table" or
rec['type'] == 'view'
and not
rec["name"].startswith("sqlite_")]
return tuple(tables)
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/1397013.NQbhjzTa81@linux-12
