I can confirm your problem and its present even if you use
Gda.Connection.parse_sql_string, the return value is a tuple with the
object you need inside it. I'm using Gda from master with python 2.7.2 and
with python 3.2.2 with python-gobject 3.0.0.
I've used that functions in Vala and its not present.
I've review GIR file and it's correct.
I think this is a python-gobject problem.
In the middle you can use:
stm = parser.parse_string ("YOUR SQL")
statement = stm[0]
This is because the first element in the list is a Gda.Statement, witch you
can use.
Or use Gda.Connection functions to execute directly string commands like:
execute_non_select, execute_select, they return Gda.DataModel objects (I
tested them and works in python)
2012/1/23 Carlos Savoretti <[email protected]>
> Hi !!!
>
> Being you're working (a lot and well) with libgda introspection, I'd
> like to make you some question.
>
> In the latest version of Gda I've found a problem w introspection
> binding Python
>
> Here it is test.py
> --------------------------------------------------------------------------
> from gi.repository import Gda
>
> connection = Gda.Connection().open_from_dsn("test", None, 0)
> print connection.get_cnc_string()
> parser = Gda.SqlParser ()
> print parser
> statement = parser.parse_string("SELECT * FROM customers")
> print statement
> if statement.check_structure():
> print "yes"
> else:
> print "no"
> print statement
> data_model = connection.statement_execute_select(statement, set1)
> print data_model
> connection.close()
> --------------------------------------------------------------------------
>
> python ./test.py
>
> DB_NAME=sales_test.db;DB_DIR=%2fusr%2flocal%2fetc%2flibgda-5.0%2f;EXTRA_FUNCTIONS=TRUE;REGEXP=TRUE;EXTRA_COLLATIONS=TRUE
> <SqlParser object at 0xb73f616c (GdaSqlParser at 0x856f2a0)>
> (<Statement object at 0xb73f634c (GdaStatement at 0x8568210)>, None)
> Traceback (most recent call last):
> File "./test.py", line 9, in <module>
> if statement.check_structure():
> AttributeError: 'tuple' object has no attribute 'check_structure'
>
> Conclussion: It seems (after some debugging) that the parsed statement
> DOES NOT
> return a GdaStatement Object, but rather a 'tuple' Python object...
> Of course connection.statement_execute_select() claims for the same
> issue...
> the object statement is not an 'GdaStatment'...
>
> Could you give some clue about the problem is Python, the introspecton
> libs, or
> what ? It is in order to correct the bug (if any)
>
> Many thanks for your help ...
>
> Regards
>
> Carlos Savoretti
> ------------------
>
--
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)
_______________________________________________
gnome-db-list mailing list
[email protected]
http://mail.gnome.org/mailman/listinfo/gnome-db-list
