Re: [gnome-db] PyGObject for web Development

[Christophe Bastin <bastin chris gmail com>]

With the binding, you can use Gda for web applications.

You just need to import the library. 

I made a example in Python 3 with cherrypy library for the web server.

Hope it helps !

import cherrypy

from gi.repository import Gda

from gi.repository import GLib

class MyWebsite (object):

    def __init__(self):

        self.conn = None

        self.list_names = []

        self.setup_database()

        self.insert_data()

        self.get_data()

    def setup_database(self):

        self.conn = Gda.Connection(provider = Gda.Config.get_provider("SQLite"),

                                          cnc_string = "DB_DIR=.;DB_NAME=test")

        self.conn.open()

        try:

            dm = self.conn.execute_select_command("select * from user")

        except GLib.GError:

            self.conn.execute_non_select_command("create table user (id integer primary key, username text)")

        self.conn.close()

    def insert_data(self):

        self.conn.open()

        b = Gda.SqlBuilder(stmt_type=Gda.SqlStatementType.INSERT)

        b.set_table("user")

        b.add_field_value_as_gvalue("username", "John")

        try:

            stmt = b.get_statement()

            self.conn.statement_execute_non_select(stmt, None)

        except GLib.GError:

            print("insert error !")

        self.conn.close()

    def get_data(self):

        self.conn.open()

        try:

            # get all names

            dm= self.conn.execute_select_command("select * from user")

            iter = dm.create_iter()

            while(iter.move_next()):

              

                l = [Gda.value_stringify(iter.get_value_at(1))]

                self.list_names.append(l)

        except GLib.GError:

            print("Error getting data")

        self.conn.close()

        for name in self.list_names:

            print(name)

    

    def index(self):

       

        return "Hello " + str(self.list_names[0][0])

    index.exposed = True

    

cherrypy.quickstart(MyWebsite(), config="cherry.conf")

Le dim 26 oct 2014 à 14:32, Daniel Espinosa <esodan gmail com> a écrit :

Is not a Django problem.

GdaData library gives you access to  database objects through a Vala/GObject API and is inspired on Django. Thats all about Django.

I try, as a test, use apache mod_phython to run a GObject Introspection code accessing to a database through a GDA query but when I return the Gda.DataModel simply don't shows any value on printing to the web page.

The point here is how can I use PyGObject on web. Could be a plus if it can be used in any web framework.

El 26/10/2014 01:48, "Gergely Polonkai" <gergely polonkai eu> escribió:

Which, in this case, makes it a Django related problem :-) I may be able to help with that, but I would need an error message and some context (and it clearly doesn't belong to these lists).

On 26 Oct 2014 02:00, "Daniel Espinosa" <esodan gmail com> wrote:

Yes. In GDA, I've developed a library to easy access to Database objects a la Django. Is developed in Vala and provides GObject Introspection bindings.

From Python I can access to GDA and GdaData (my library) using "from gi.repositoy import GDA, GdaData", and use to access database objects.

But I've tried apache mod_python, and after configure a site with that, I just found that a query data, can't be returned to  be displayed in a routing that is called to handle a request. I call a function when a requests with a path in the URL, it calls a function using my library from GObject Introspection, but when returns the data to the caller it simple don't shows any value.

2014-10-25 16:14 GMT-05:00 Gergely Polonkai <gergely polonkai eu>:

It’s a bit unclear to me, what exactly you want to achieve.

What I understand (correct me if I’m wrong) is that you wrote a library in Vala, which uses GDA, and you want to use your library from a web app written in Python.

If I’m right, then all you have to do is to create some GObject Introspection files for your library, so in Python you can simply use the form »from gi.repository import YourLibrary«. How to do this is beyond my knowledge, as I’m pretty beginner with Vala itself; you may want to go directly to the Vala mailing list, or their IRC channel.

On 25 October 2014 21:39, Daniel Espinosa <esodan gmail com> wrote:

I would like to use PyGObject to use GDA & its Vala extensions to develop a web app.

Ar there any one using this way?

If you ask why? Its because I'm developing Vala libraries and I would like to use them in web applications.

_______________________________________________
gnome-db-list mailing list
gnome-db-list gnome org
https://mail.gnome.org/mailman/listinfo/gnome-db-list

--
Trabajar, la mejor arma para tu superación
"de grano en grano, se hace la arena" (R) (en trámite, pero para los cuates: LIBRE)