On Oct 22, 3:59 am, Christian MICHON <[email protected]>
wrote:
> Hi,
>
> I'm currently using Sequel with jruby and some java connectors
> (sqlserver,mysql,informix...) and in some of the databases I wish to
> connect to, I know I've tables and views.
>
> Once I'm do a DB=Sequel.connect(...), I can access DB.tables to have a
> list of the tables.
>
> But how do I find the list of the views ? I checked with java programs
> like ExecuteQuery using the same java connectors, and indeed the views
> are listed.
Sequel doesn't currently have a method for listing views. You can use
Database#synchronize to get access to the underlying connection
object:
DB.synchronize do |conn|
conn.#{some jdbc view listing method here}
end
Or if you know the necessary SQL for your database:
DB['view listing SQL code here'].all
I wouldn't have a problem adding a Database#views method similar to
the Database#tables method. It just hasn't been requested before.
Jeremy
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sequel-talk?hl=en.
