Smalltalk › Frameworks & Tools › DBXTalk

How is database schema retrieved by DBXTalk?

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

3 messages Options

Frank Church

How is database schema retrieved by DBXTalk?

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

Mariano Martinez Peck

Re: How is database schema retrieved by DBXTalk?

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):

http://dbxtalk.smallworks.com.ar/tools

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

Guillermo Polito

Re: How is database schema retrieved by DBXTalk?

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):
http://dbxtalk.smallworks.com.ar/tools

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