Re: [dabo-users] Grid from SQLite Views

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: Dabo-users@leafe.com