Package: python-gadfly
Version: 1.0.0-15.1
Severity: normal
Hi.
I suspect there's a problem with gadfly with Python 2.7 at the moment.
It seems I can't retrieve a table that I have created, wheras gfplus is able to
query it :-/
Here's my first program which populates a DB :
$ mkdir gadflybd/
$ python createdb.py :
-----
#!/usr/bin/python
# -*- coding: utf-8 -*-
import gadfly
connection = gadfly.gadfly()
connection.startup("MYDATABASE", "gadflybd")
cursor = connection.cursor()
cursor.execute("CREATE TABLE TEL (NOM VARCHAR, TEL VARCHAR)")
connection.commit()
cursor.execute("INSERT INTO TEL(NOM, TEL) VALUES ('christian', '4098')")
connection.commit()
cursor.execute("SELECT * FROM TEL")
for x in cursor.fetchall():
print x
connection.commit()
cursor.execute("select * from __table_names__")
print cursor.pp()
-----
Which gives :
('christian', '4098')
TABLE_NAME | IS_VIEW
=========================
__INDEXCOLS__ | 1
__COLUMNS__ | 1
TEL | 0
__TABLE_NAMES__ | 1
DUAL | 1
__INDICES__ | 1
__DATADEFS__ | 1
Gfplus also reports :
$ gfplus MYDATABASE gadflybd
GF> select * from tel;
NOM | TEL
================
christian | 4098
Then if I run a little script to query the same DB :
$ python readdb.py
-----
#!/usr/bin/python
# -*- coding: utf-8 -*-
import gadfly
connection = gadfly.gadfly()
connection.startup("MYDATABASE", "gadflybd")
cursor = connection.cursor()
cursor.execute("select * from __table_names__")
print cursor.pp()
cursor.execute("SELECT * FROM TEL")
for x in cursor.fetchall():
print x
connection.commit()
-----
Then, I get an error :
TABLE_NAME | IS_VIEW
=========================
__INDEXCOLS__ | 1
__COLUMNS__ | 1
__TABLE_NAMES__ | 1
DUAL | 1
__INDICES__ | 1
__DATADEFS__ | 1
Traceback (most recent call last):
File "schu/Codes/readdb.py", line 15, in <module>
cursor.execute("SELECT * FROM TEL")
File "/usr/lib/python2.7/dist-packages/gadfly/database.py", line 366, in
execute
cs[i] = cs[i].relbind(database)
File "/usr/lib/python2.7/dist-packages/gadfly/semantics.py", line 2548, in
relbind
test = db.bindings(tl)
File "/usr/lib/python2.7/dist-packages/gadfly/store.py", line 288, in bindings
raise NameError, `name` + " no such relation in DB"
NameError: 'TEL' no such relation in DB
Indeed, the instrospection didn't find the table :-/
Thanks in advance.
Best regards,
-- System Information:
Debian Release: 7.0
APT prefers testing
APT policy: (900, 'testing')
Architecture: i386 (i686)
Kernel: Linux 3.2.0-4-686-pae (SMP w/2 CPU cores)
Locale: LANG=fr_FR.utf8, LC_CTYPE=fr_FR.utf8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Versions of packages python-gadfly depends on:
ii python 2.7.3-4
Versions of packages python-gadfly recommends:
ii python-kjbuckets 1:1.0.0-15.1
python-gadfly suggests no packages.
-- debconf-show failed
--
To UNSUBSCRIBE, email to [email protected]
with a subject of "unsubscribe". Trouble? Contact [email protected]
