GNOME.org
 

Re: XML queries

I tried to go to the web site so that I could print out the XML queries
while I was waiting for work to end, and found that the link on the web site
to the XML whitepaper seems to be broken...

----- Original Message -----
From: "Rodrigo Moya" <rodrigo@linuxave.net>
To: "GDA Mailing List" <gnome-db-list@gnome.org>; "Vivien Malerba"
<malerba@linuxave.net>
Sent: Tuesday, April 18, 2000 1:46 PM
Subject: XML queries


> Hi all!
>
> Reading deeper the proposal by Vivien about the XML queries, I've
> noticed lots of possibilities we'll have with this system.
>
> > The XML query will contain an understandable version of
> > what the client wants to do (an XML version of sentenses like "put some
values
> > in that table", "create a new table", "set the reading permission for
this user
> > on that table", "give me the list of shoes for which the sale price is
higher
> > than the average sale price of the blue shoes",...)
> >
> > When the client wants to send a query, it will have to build the query,
then
> > get a string version of it (which can be saved, etc), send it to the
provider,
> > and then discard it. There will be a Gda_Xmlquery object and a lib to
help in
> > the job of creating (,...) the query.
> >
> > Each provider will then have to get the XML string of the query, build
back the
> > corresponding Gda_Xmlquery object, convert it to an understandable query
for
> > the RDBMS it represents, send the query to the RDBMS, discard the
Gda_Xmlquery
> > object and return the result of the query to the client.
> >
> all this will go to the gda-common lib, so that using this on
> clients/providers will be very easy!
>
> > * I hope that in the future, the client will be able to ask the provider
to
> > give him the XML Queries to save the structure and the data of a
database (in
> > the way gda-xml lib does now, but with more accuracy).
> yes! this could be added to the schemas maybe... as we do with the SQL
> command, we could ask for the XML string needed to build that object.
> This would make the import/export tools very easy to implement.
>
> > * It will be possible to ask the provider for an equivalent, in the
language
> > its RDBMS use, of the XML query to give some feedback to the user of the
> > client.
> that's perfect, for importing data exported on a different DBMS
>
> > This query specification allows to ask for only the SELECT, DELETE,
INSERT and
> > UPDATE operations for now, but has the possibility to be extended for
CREATE
> > TABLES, CREATE FUNCTIONS, etc.
> >
> this should be very easy, as soon as we've got the basic commands
> working. I think the most difficult of all these is the SELECT command.
>
>
> The DTD format, in my opinion, fits very well with Cédric's ideas, don't
> you think?
>
> BTW, I'm putting this proposal on the web site.
>
> Cheers
>
>
> --
> To unsubscribe: mail gnome-db-list-request@gnome.org with "unsubscribe"
> as the Subject.
>



Return-Path: <rodrigo@linuxave.net>
Delivered-To: gnome-db-list@gnome.org
Received: from gears.linuxave.net (gears.linuxave.net [208.184.88.8])
	by mail.gnome.org (Postfix) with ESMTP id 96F922BBC9
	for <gnome-db-list@gnome.org>; Sat, 22 Apr 2000 09:45:54 -0400 (EDT)
Received: from linuxave.net ([212.163.104.151])
	by gears.linuxave.net (8.9.3/8.8.7) with ESMTP id JAA07947;
	Sat, 22 Apr 2000 09:43:41 -0400
Message-ID: <39019700.89C1D2A8@linuxave.net>
Date: Sat, 22 Apr 2000 14:11:44 +0200
From: Rodrigo Moya <rodrigo@linuxave.net>
X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.14-15mdk i586)
X-Accept-Language: en
MIME-Version: 1.0
To: malerba@linuxave.net
Cc: gnome-db-list@gnome.org
Subject: Re: Using GnomeDbControl
References: <00041920315504.26749@vivien>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Sender: gnome-db-list-admin@gnome.org
Errors-To: gnome-db-list-admin@gnome.org
X-BeenThere: gnome-db-list@gnome.org
X-Loop: gnome-db-list@gnome.org
X-Mailman-Version: 2.0beta2
Precedence: bulk
List-Id: GNOME database related discussion <gnome-db-list.gnome.org>

Vivien Malerba wrote:

> Hi Rodrigo!
>
> I've started to create config control components for the postgres provider. You
> will find the two new files for this on CVS: gda-postgres-config-main.c and
> gda-postgres-config.gnorba.
>
> At the moment I have created a small component to manage users in the DB (there
> is still nothing behind the widget interface!), and a sample global config
> component which just creates a notebook and set a page with the small widget
> just mentionned above. This is what appears in the .gnorba file, 2 interfaces:
> [control-factory:gnome-db-config]
> [control-factory:gnome-db-users-list]

I'd change this to
[control-factory:gnome-db-config-users]
[control-factory:gnome-db-config-databases]

it's just a detail, but as with the libraries, to have the same naming cnventions.
Although I think this must be changed, as we can't have several components having
the same GOAD ID, and right now, ODBC and postgres are configured with the same
GOAD ID. So this should change to:

[control-factory:gda-postgres-config]
[control-factory:gda-postgres-config-users]
....
[control-factory:gda-odbc-config]

What is repeated among all GNORBA entries is the repo_id entry, but not the name.

>
>
> It seems to be working quite correctly. But I have a problem with the
> declaration of properties: for now I cannot declare any more properties than
> what will be declared in the control_factory() function from gnome-db-control.c
> (what I will then call 'global properties' because they apply to ALL
> GnomeDbControl objects)
>
> Enabling components to declare their own specific properties is necessary:
> every component will 'inherit' the global properties as a GnomeDbObject, but
> needs to set its own specific properties.
>
> What I suggest is that we declare:
>
> typedef void (*GnomeDbControlProps)(BonoboPropertyBag  *pb, GtkWidget *data);
> struct _GnomeDbControl
> {
>   BonoboObject          bonobo_object;
>   BonoboGenericFactory* factory;
>   GnomeDbControlFunc    create_widget_cb;
>   GnomeDbControlProps   declare_props;
> };
>
> and change function _new to:
> GtkObject*  gnome_db_control_new(const gchar *id,
>                                  GnomeDbControlFunc func,
>                                  GnomeDbControlProps props);
>
> a GnomeDbControlProps migth be something like:
>
> void declare_users_list_props_cb (BonoboPropertyBag  *pb, GtkWidget *data)
> {
>   bonobo_property_bag_add_full(pb, "my_prop", 1, BONOBO_ARG_BOOLEAN, NULL,
>                                "Component's own property", 0,
>                                my_set_prop_func, my_get_prop_func, data);
> }
>
> and we modify the function control_factory() by adding a line (after line 93):
> if (control->declare_props) control->declare_props(pb, widget);
>
>

Yes, you're right, I hadn't thought too much about the properties. In the
beginmning I had thought of setting the specific properties in the
create_widget_cb function, but this really shows that I hadn't thought too much
since at that moment (when this function is called) the BonoboControl is not
created yet.

I've changed this as you suggested, the only thing I've changed are some names,
for avoiding confusion:

GnomeDbControlProps -> GnomeDbControlPropsFunc

So, what do you think now about bonobo, after looking at the code? don't you think
it's very well done and easy to use (the Bonobo API I mean)?

Cheers






Return-Path: <rodrigo@linuxave.net>
Delivered-To: gnome-db-list@gnome.org
Received: from gears.linuxave.net (gears.linuxave.net [208.184.88.8])
	by mail.gnome.org (Postfix) with ESMTP id B8BB42BBCE
	for <gnome-db-list@gnome.org>; Sat, 22 Apr 2000 09:45:58 -0400 (EDT)
Received: from linuxave.net ([212.163.104.151])
	by gears.linuxave.net (8.9.3/8.8.7) with ESMTP id JAA07951;
	Sat, 22 Apr 2000 09:43:46 -0400
Message-ID: <390197DC.C4C8167B@linuxave.net>
Date: Sat, 22 Apr 2000 14:15:24 +0200
From: Rodrigo Moya <rodrigo@linuxave.net>
X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.14-15mdk i586)
X-Accept-Language: en
MIME-Version: 1.0
To: malerba@linuxave.net
Cc: gnome-db-list@gnome.org
Subject: Re: gda config component
References: <00041813510706.04815@vivien> <00041910523403.26749@vivien> <38FD7856.3411CA74@linuxave.net> <00042012280900.27556@vivien>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Sender: gnome-db-list-admin@gnome.org
Errors-To: gnome-db-list-admin@gnome.org
X-BeenThere: gnome-db-list@gnome.org
X-Loop: gnome-db-list@gnome.org
X-Mailman-Version: 2.0beta2
Precedence: bulk
List-Id: GNOME database related discussion <gnome-db-list.gnome.org>

>
> > yes, having one bonoboControl for each of the config profiles should do
> > it. For the 'big' component, this should implement a BonoboContainer, as
> > the gda-mgr application does.
>
> Why? The 'big' component can be considered as a simple control component, no?
>

Yes, you're right (sorry, I'm on holidays and thinking is quite hard!). As the other
widgets (the ones to be sent over for the BonoboControl) are in the same process, the
big config component just should insert the GtkWidgets (not the BonoboControl) on it.





Return-Path: <rodrigo@linuxave.net>
Delivered-To: gnome-db-list@gnome.org
Received: from gears.linuxave.net (gears.linuxave.net [208.184.88.8])
	by mail.gnome.org (Postfix) with ESMTP id C715D2BAD7
	for <gnome-db-list@gnome.org>; Fri, 21 Apr 2000 10:39:28 -0400 (EDT)
Received: from linuxave.net ([212.163.104.125])
	by gears.linuxave.net (8.9.3/8.8.7) with ESMTP id KAA19336
	for <gnome-db-list@gnome.org>; Fri, 21 Apr 2000 10:37:21 -0400
Message-ID: <39005269.82B4D50@linuxave.net>
Date: Fri, 21 Apr 2000 15:06:49 +0200
From: Rodrigo Moya <rodrigo@linuxave.net>
X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.14-15mdk i586)
X-Accept-Language: en
MIME-Version: 1.0
To: gnome-db-list@gnome.org
Subject: Re: Help...
References: <00041813510706.04815@vivien> <00041816342000.26749@vivien> <38FC7482.BB9D6AAC@linuxave.net> <00041817343401.26749@vivien> <38FCCC12.F46A791E@ics.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Sender: gnome-db-list-admin@gnome.org
Errors-To: gnome-db-list-admin@gnome.org
X-BeenThere: gnome-db-list@gnome.org
X-Loop: gnome-db-list@gnome.org
X-Mailman-Version: 2.0beta2
Precedence: bulk
List-Id: GNOME database related discussion <gnome-db-list.gnome.org>

Hi Jim!

> Hi, i have just finished compiling the gnome DB, and am having some problems
> getting anyone to find the name server... this is what i am doing...
>
> 1) I have a postgesql database up and running, i can verify this with psql
>
> I start the postmaster like so...
>
> > postmaster -D/mypostsqldb
>
>  again, we know this works since i can query the db with psql etc..
> Now i try to start the name server, after reading the developer documentation or
> ORBIT
> i figured i needed to start it like this...
>
> > orbit-name-server > /tmp/name-service-ior &
>

starting it like this shouldn't be necessary, AFAIK. And you should start the
gnome-name-serv process instead of orbit-name-server. And this process, as soon as
you start GNOME, it should be started. Maybe you are trying to run the gda-postgres
without X being run?

This will change when we switch to OAF instead of GNORBA for the object activation,
but for the moment, you need to be running X for the CORBA stuff to work, as
GNOME-DB right now uses GNORBA.

you should just start your GNOME session (don't run the GDA providers), and from
within gdafe, the corresponding GDA provider should be started when you select a data
source to connect to. so there is no need to manually start them.

>
> Now i want to start my postgress gda right??
>
> so i do
>
> > whoopi (250) > gda-postgres-srv
>
> and i get:....
>
> ** WARNING **: Could not get name service!
>
> 2) Acutaly i have done this before (actualy i did alot of things and i was able to
> get gdafe up,
>     log into the database, and do a query, * i was so HAPPY * ) then the machine
> got rebooted (by someone else).
>     unfortunatly i was not sure exactly what i did to get the name server up and
> running. I had this problem before
>     any i kept playing but now i cant repeate my luck..
>





Return-Path: <rodrigo@linuxave.net>
Delivered-To: gnome-db-list@gnome.org
Received: from gears.linuxave.net (gears.linuxave.net [208.184.88.8])
	by mail.gnome.org (Postfix) with ESMTP id 1F5882BBC9
	for <gnome-db-list@gnome.org>; Sat, 22 Apr 2000 09:46:26 -0400 (EDT)
Received: from linuxave.net ([212.163.104.151])
	by gears.linuxave.net (8.9.3/8.8.7) with ESMTP id JAA07996;
	Sat, 22 Apr 2000 09:44:09 -0400
Message-ID: <39019CB8.32E5FF34@linuxave.net>
Date: Sat, 22 Apr 2000 14:36:08 +0200
From: Rodrigo Moya <rodrigo@linuxave.net>
X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.14-15mdk i586)
X-Accept-Language: en
MIME-Version: 1.0
To: Chris Wiegand <cwiegand@urgentmail.com>
Cc: gnome-db-list@gnome.org
Subject: Re: XML queries
References: <38FCBBA0.E2391A60@linuxave.net> <003001bfab99$0b09c980$f0140818@aurora1.co.home.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Sender: gnome-db-list-admin@gnome.org
Errors-To: gnome-db-list-admin@gnome.org
X-BeenThere: gnome-db-list@gnome.org
X-Loop: gnome-db-list@gnome.org
X-Mailman-Version: 2.0beta2
Precedence: bulk
List-Id: GNOME database related discussion <gnome-db-list.gnome.org>

Chris Wiegand wrote:

> I tried to go to the web site so that I could print out the XML queries
> while I was waiting for work to end, and found that the link on the web site
> to the XML whitepaper seems to be broken...
>

A really strange thing has happened! The full URL for this page is:

http://www.gnome.org/gnome-db/doc/white-papers/XML_queries_proposal.html

and if you click on it,

http://developer.gnome.org/whitepapers.... (or something like this)

appears!

I've already talked about this to the gnome-hackers-list, I hope to have an
answer ASAP. But what do you think may be happening? some apache redirection or
something like this?
[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]