How is database schema retrieved by DBXTalk?

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

How is database schema retrieved by DBXTalk?

Frank Church
How is database schema retrieved by DBXTalk?

After making a successful connection, what command is needed to get a list of the tables, columns, indices etcetra from the database?

On that note I tried to install DBXBrowser - ConfigurationOfDBXBrowser(GuillermoPolito.10) and I got this error,  receiver of loadUsing is nil. Fetching 2.0 of ConfigurationOfDBXBrowser.

I notice that [hidden email] reported the same issue 77 on October.

/vfclists
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: How is database schema retrieved by DBXTalk?

Mariano Martinez Peck


On Tue, Jan 8, 2013 at 9:57 PM, vfclists <[hidden email]> wrote:
How is database schema retrieved by DBXTalk?

After making a successful connection, what command is needed to get a list of the tables, columns, indices etcetra from the database?


Sorry for the late answer. OpenDBXDriver itself does not take care of that.
However, the package Phoseydon provides such features (besides other ones):

I don't have much time to check now. Let me know if you find it and if you don't, I can check.

Best, 
 
On that note I tried to install DBXBrowser - ConfigurationOfDBXBrowser(GuillermoPolito.10) and I got this error,  receiver of loadUsing is nil. Fetching 2.0 of ConfigurationOfDBXBrowser.

I notice that [hidden email] reported the same issue 77 on October.

/vfclists



--
Mariano
http://marianopeck.wordpress.com
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: How is database schema retrieved by DBXTalk?

Guillermo Polito
Hi! I'm back from vacations :).

Now, opendbx per se does not resolve the schema retrieval since it depends on each database vendor. We made a little tool which you can try from here:

Gofer it
squeaksource: 'DBXTalk';
package: 'ConfigurationOfDBXTools';
load.

(ConfigurationOfDBXTools project version: #stable) load: 'DBXDatabaseModel'.
(ConfigurationOfDBXTools project version: #stable) load: 'DBXDatabaseModelTests'.

Look at the tests for example of usage so far...

For sure the API should be polished since it was not originally written to be used independently of other tools.

Regarding the DBXBrowser, I'll try to reserve some hours on it to make it work again...

Cheers,
Guille

On Tue, Jan 15, 2013 at 5:07 PM, Mariano Martinez Peck <[hidden email]> wrote:


On Tue, Jan 8, 2013 at 9:57 PM, vfclists <[hidden email]> wrote:
How is database schema retrieved by DBXTalk?

After making a successful connection, what command is needed to get a list of the tables, columns, indices etcetra from the database?


Sorry for the late answer. OpenDBXDriver itself does not take care of that.
However, the package Phoseydon provides such features (besides other ones):

I don't have much time to check now. Let me know if you find it and if you don't, I can check.

Best, 
 
On that note I tried to install DBXBrowser - ConfigurationOfDBXBrowser(GuillermoPolito.10) and I got this error,  receiver of loadUsing is nil. Fetching 2.0 of ConfigurationOfDBXBrowser.

I notice that [hidden email] reported the same issue 77 on October.

/vfclists



--
Mariano
http://marianopeck.wordpress.com

Loading...