gmane.comp.db.firebird.python

FDB release 1.3

Pavel Cisar — 2013-06-07T11:15:51

FDB release 1.3 is out:
http://pypi.python.org/pypi/fdb

New Features

* fdb.monitor submodule for access to / work with monitoring tables.
* New fdb.Connection.monitor property for access to monitoring tables.

Improvements

* closed property and clear() method for Schema.
* Unit tests reworked.

Bugs Fixed

* Unregistered: Bug in fdb.schema.Schema.close() and 
fdb.schema.Schema.bind().

Next version 1.4 will provide access to/work with privileges to database 
objects.

best regards
Pavel Cisar
IBPhoenix


------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/firebird-python/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/firebird-python/join
    (Yahoo! ID required)

<*> To change settings via email:
    firebird-python-digest-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org 
    firebird-python-fullfeatured-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org

<*> To unsubscribe from this group, send an email to:
    firebird-python-unsubscribe-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/

FDB release 1.2

Pavel Cisar — 2013-05-31T18:16:31

FDB release 1.2 is out:
http://pypi.python.org/pypi/fdb

New Features

* fdb.schema submodule for access to / work with database metadata.
* fdb.utils submodule with various helper classes and functions.
* New fdb.Connection.schema property for access to database schema.
* New ConnectionWithSchema connection class that provides more direct 
access to database schema than Connection.
* New fdb.Connection.firebird_version, fdb.Connection.version and 
fdb.Connection.engine_version properties.
* New Connection.ods read only property that returns ODS version number 
of connected database. There are also new module-level constants 
ODS_FB_20, ODS_FB_21 and ODS_FB_25.
* New fdb.Connection.query_transaction property. This is ReadOnly 
ReadCommitted transaction that could be active indefinitely without 
blocking garbage collection. It’s used internally to query metadata, but 
it’s generally useful.

Improvements

* Optional PEP 249 (Python DB API 2.0) Extensions

   - Connection.Error, Connection.ProgrammingError, etc.

     All exception classes defined by the DB API standard are exposed on 
the Connection objects as attributes (in addition to being available at 
module scope).

   - Cursor.connection

     This read-only attribute return a reference to the Connection 
object on which the cursor was created.

* Cursor.transaction read-only attribute returns a reference to the 
Transaction object on which the cursor was created.
* Optimized wekref management, especially for PreparedStatement.
* create_database now supports two methods for database screation. You 
can specify CREATE DATABASE statement (as before) or provide set of 
named database parameters (SQL statement is created automatically from 
them).
* Functions connection and create_database now take optional keyword 
parameter connection_class to obtain instances of different class 
instead Connection.
* Support for legacy (pre-2.5) shutdown mode with mode 
fdb.services.SHUT_LEGACY.
* fdb.Cursor.executemany() returns self, so it could be used directly as 
iterator.
* Documentation improvements.

Bugs Fixed

* Unregistered: buffers parameter of fdb.connection doesn’t support 
values greater than 255.
* Unregistered: Lowercase character set name passed to fdb.connect may 
result in wrong funcion of automatic data conversions and other failures 
(exceptions raised).

Next version 1.3 will have similar support for monitoring tables.

best regards
Pavel Cisar
IBPhoenix


------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/firebird-python/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/firebird-python/join
    (Yahoo! ID required)

<*> To change settings via email:
    firebird-python-digest-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org 
    firebird-python-fullfeatured-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org

<*> To unsubscribe from this group, send an email to:
    firebird-python-unsubscribe-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/

RFC: Metadata extensions for FDB

Pavel Cisar — 2013-05-14T15:54:13

Hi all,

I have "metadata" extension for FDB in development for some time now, 
and I'm getting close to release it (intended for 1.2 release). The 
basic idea is to provide database metadata (and other selected useful 
information like common queries/operations on top of monitoring tables) 
as collections of Python objects for easy access and manipulation. 
However, this is huge addition to "basic" functionality mandated by 
Python DB API 2.0, and it's not necessary for work with databases. So I 
tend to keep it separated from core functionality. On the other hand, 
this all naturally fits to Connection class, so I would appreciate some 
feedback from end FDB users here.

Right now these extensions are separated into independent submodule 
fdb.utils. The main "access" point is Database class, but this module 
also contains other metadata classes (tables, domains, indices etc.). 
The submodule was introduced to keep indirectly used classes/code from 
main FDB namespace, and import only Database class into it (or not).

There are several arrangements I currently consider:

1. Database is subclass of Connection returned by 
connect/create_database instead Connection on request. These functions 
will have optional connection_class named parameter (defaults to 
Connection) to return instance of any (either Database from fdb.utils or 
user created) Connection subclass instead Connection. Other option is 
addition of connect/create_database also in fdb.utils, but these 
functions would return Database instead Connection, but parametrized 
ones are imho better.

The obvious advantage of this scenario is that you have both 
functionalities in single object. Disadvatage is that you would get big 
ball of code/attributes which you may not use very often - if at all.

2. Database is independent class working with Connection instance 
provided on creation. This arrangement clearly separates both 
functionalities. Database instance provides extended attributes and 
functions only, for basic access you'll use the Connection instance, so 
you may need to keep around both. On the other hand it's easier and more 
effective arrangement if you don't want to use metadata functionality 
extensively, as you can easily ignore it or drop the Database object any 
time without disruption to core (Connection) functionality of your 
application.

3. Hybrid case between 1. a 2. Database is independent class (like in 
2.) but works as transparent proxy to Connection provided, i.e. has 
getattr that passes calls to directly unhandled names to Connection.

Extreme cases:

4. Don't bother and extend Connection class directly.

5. Create separate (namespace?) package with this extended functionality 
to keep driver package pure. Who needs such extension can easily install 
it from PyPI. The connection to FDB Connection could be either 1. or 2. 
method.

My personal preference is slightly toward option 1 (maybe as 5.), but 
I'm open to any suggestions.

What is your preference?

best regards
Pavel Cisar
IBPhoenix



------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/firebird-python/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/firebird-python/join
    (Yahoo! ID required)

<*> To change settings via email:
    firebird-python-digest-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org 
    firebird-python-fullfeatured-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org

<*> To unsubscribe from this group, send an email to:
    firebird-python-unsubscribe-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/

FDB release 1.1.1

Pavel Cisar — 2013-05-14T11:41:08

FDB release 1.1.1 is out:
http://pypi.python.org/pypi/fdb

Bugs Fixed:

- http://tracker.firebirdsql.org/browse/PYFB-34
- http://tracker.firebirdsql.org/browse/PYFB-35

best regards
Pavel Cisar
IBPhoenix


------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/firebird-python/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/firebird-python/join
    (Yahoo! ID required)

<*> To change settings via email:
    firebird-python-digest-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org 
    firebird-python-fullfeatured-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org

<*> To unsubscribe from this group, send an email to:
    firebird-python-unsubscribe-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/

FDB Blocking Cursor

josef_gschwendtner — 2013-05-06T14:55:58

We depend on a third party framework which uses one Cursor Instance for
the execution of many queries. There are some select queries and also
ddl statements which get executed with one Cursor instance.

After each execution of a statement the fetch method gets called. Also
for the ddl statements which produces no result.  But in fdb this leads
to an exception "WindowsError: exception: access violation reading
0x0000000000000000". After this exception the cursor is no longer
usable. The next call of cur.execute() with a select statement blocks
and never returns.

This situation can be simulated with the following script. Instead of a
ddl statement it is also possible to use an update statement.



import fdb

import traceback





def execute(cur, stmt, parameters = None):

     print "-----------------------------------"

     print "Execute ", stmt

     cur.execute(stmt, parameters)

    try:

         for row in cur.fetchall():

             print row

     except Exception, e:

         print traceback.format_exc()





def main():

     con = fdb.connect(dsn='localhost/3050:employee', user='sysdba',
password='masterkey')

     cur = con.cursor()





     execute(cur, "select * from COUNTRY")

     #execute(cur, "UPDATE COUNTRY SET CURRENCY = 'Euro' where COUNTRY =
                    'Germany'")

     execute(cur, "CREATE SEQUENCE TEST_SEQ_1")

     execute(cur,  "select * from COUNTRY")



     con.commit()

     con.close()

     print "Finished"



main()







We got the following output:



-----------------------------------

Execute  select * from COUNTRY

('USA', 'Dollar')

('England', 'Pound')

('Canada', 'CdnDlr')

('Switzerland', 'SFranc')

('Japan', 'Yen')

('Italy', 'Lira')

('France', 'FFranc')

('Germany', 'Euro')

('Australia', 'ADollar')

('Hong Kong', 'HKDollar')

('Netherlands', 'Guilder')

('Belgium', 'BFranc')

('Austria', 'Schilling')

('Fiji', 'FDollar')

-----------------------------------

Execute  CREATE SEQUENCE TEST_SEQ_1

Traceback (most recent call last):

   File "C:\Development\Workspaces\PySnippets\fdb_fetch_problem.py", line
10, in execute

     for row in cur.fetchall():

   File
"C:\Development\VirtualEnvs\web\lib\site-packages\fdb-1.1-py2.7.egg\fdb\\
fbcore.py", line 3188, in fetchall

     return [row for row in self]

   File
"C:\Development\VirtualEnvs\web\lib\site-packages\fdb-1.1-py2.7.egg\fdb\\
fbcore.py", line 2951, in next

     row = self.fetchone()

   File
"C:\Development\VirtualEnvs\web\lib\site-packages\fdb-1.1-py2.7.egg\fdb\\
fbcore.py", line 3148, in fetchone

     return self._ps._fetchone()

   File
"C:\Development\VirtualEnvs\web\lib\site-packages\fdb-1.1-py2.7.egg\fdb\\
fbcore.py", line 2820, in _fetchone

     ctypes.cast(ctypes.pointer(self.out_sqlda), XSQLDA_PTR))

WindowsError: exception: access violation reading 0x0000000000000000



-----------------------------------

Execute  select * from COUNTRY



The execution of the second select statement never returns. The
application is still running.



We think that a call to fetch after a sql statement without a result
should not lead to an access violation.

The same test with kinterbasdb leads to an exception like this:



Error  (0L, 'Attempt to fetch row of results after statement that does
not produce result set.  That statement was:  CREATE SEQUENCE
TEST_SEQ_1')



After this exception the cursor from kinterbasdb is still usable.



This behavior seems to be conform to PEP 249 -- Python Database API
Specification v2.0



From: http://www.python.org/dev/peps/pep-0249/#id19
<http://www.python.org/dev/peps/pep-0249/#id19>



.fetchone <http://www.python.org/dev/peps/pep-0249/#fetchone> ()

Fetch the next row of a query result set, returning a single sequence,
or None when no more data is available. [6]
<http://www.python.org/dev/peps/pep-0249/#id45>

An Error <http://www.python.org/dev/peps/pep-0249/#error>  (or subclass)
exception is raised if the previous call to .execute*()
<http://www.python.org/dev/peps/pep-0249/#id14>  did not produce any
result set or no call was issued yet.



One solution  could be, that inside the fetchone operation of the Cursor
is a check like this:

  if not self._ps.statement_type in [isc_info_sql_stmt_select,
isc_info_sql_stmt_select_for_upd,

                                          
isc_info_sql_stmt_exec_procedure]:

             raise Database.Error("Attempt to fetch row of results  after
statement that does not
                                   produce result set.")


We found a similar check inside the C source of kinterbasdb (see
function *_Cursor_fetchtuple from
http://python-kinterbasdb.sourcearchive.com/documentation/3.2/__kicore__\
cursor_8c-source.html
<http://python-kinterbasdb.sourcearchive.com/documentation/3.2/__kicore_\
_cursor_8c-source.html> ).
    Is it possible that a patch like this could be integrated to fdb?

Thank you,

Josef

Huge Firebird memory usage using FDB

josef_gschwendtner — 2013-04-30T10:20:14

Hi,

We got a problem when we use the Firebird driver for Python (fdb) inside
a connection pool. If a single connection is used for the execution of

many queries and each query uses a separate cursor instance we observed
an increasing memory usage on the server side (the fbserver process).

Only when the connection gets closed the memory usage of the fbserver
process gets back to a "normal" value.

An equal situation can be simulated with this short python script.

import fdb

con = fdb.connect(dsn='localhost/3050:C:\\Development\\DB\\mydb.fdb',
user='sysdba',
password='masterkey')

for i in range(10000):

cur = con.cursor()

cur.execute( "select * from RDB$Relations")

for row in cur.fetchall():

print i, row[0]

con.commit()

t = raw_input('Press Key')

con.close()

print "Finished"

When the loop has finished and before closing the connection the
fbserver process uses almost one GB of memory. This is independent of
the table being used.

RDB$Relations is only used for demonstration. The same happens also with
every other table. After closing the connection everything is fine on
the server

(fbserver memory usage is back to 7 MB).

We found out that releasing the Cursor instance does not permanently
free the prepared statement on the server side. During the destructor of
the Cursor instance

the internal managed PreparedStatement instances will also be released.
This will call the method _close from PreparedStatement. Inside the
_close Method the

release of the server side statement resource will only be triggered if
there is an open connection. But to get this connection the
PreparedStatement instance uses the

cursor Attribute which is a weak reference to the Cursor instance. But
this Cursor instance is no longer available because the program
execution is inside the

destructor (__del__) of this cursor. The weak reference is dead.

It seems that Cursor and PreparedStatement instances are released on the
client side but the following statement from the _close method of
PreparedStatement doesn't get executed.

api.isc_dsql_free_statement(self._isc_status, stmt_handle,

ibase.DSQL_drop)

But this statement is required for releasing the server side resources
and also the memory used for these resources.

Thanks for your help,

Josef

WG: FDB Bug Report

Josef Gschwendtner — 2013-04-30T09:28:04

Von: Markus Holzner
Gesendet: Dienstag, 30. April 2013 10:30
An: Josef Gschwendtner
Betreff: FDB Bug Report

We got a problem when we use the Firebird driver for Python (fdb) inside a connection pool. If a single connection is used for the execution of

many queries and each query uses a separate cursor instance we observed an increasing memory usage on the server side (the fbserver process).

Only when the connection gets closed the memory usage of the fbserver process gets back to a "normal" value.

An equal situation can be simulated with this short python script.

import fdb

con = fdb.connect(dsn='localhost/3050:C:\\Development\\DB\\mydb.fdb', user='sysdba',
password='masterkey')

for i in range(10000):

cur = con.cursor()

cur.execute( "select * from RDB$Relations")

for row in cur.fetchall():

print i, row[0]

con.commit()

t = raw_input('Press Key')

con.close()

print "Finished"

When the loop has finished and before closing the connection the fbserver process uses almost one GB of memory. This is independent of the table being used.

RDB$Relations is only used for demonstration. The same happens also with every other table. After closing the connection everything is fine on the server

(fbserver memory usage is back to 7 MB).

We found out that releasing the Cursor instance does not permanently free the prepared statement on the server side. During the destructor of the Cursor instance

the internal managed PreparedStatement instances will also be released. This will call the method _close from PreparedStatement. Inside the _close Method the

release of the server side statement resource will only be triggered if there is an open connection. But to get this connection the PreparedStatement instance uses the

cursor Attribute which is a weak reference to the Cursor instance. But this Cursor instance is no longer available because the program execution is inside the

destructor (__del__) of this cursor. The weak reference is dead.

It seems that Cursor and PreparedStatement instances are released on the client side but the following statement from the _close method of PreparedStatement doesn't get executed.

api.isc_dsql_free_statement(self._isc_status, stmt_handle,

ibase.DSQL_drop)

But this statement is required for releasing the server side resources and also the memory used for these resources.

-------------------------------------------------------------

Quattro-Soft GmbH

Traunsteiner Straße 29, 83334 Inzell

Tel. 08665/1708, Fax 08665/1710

Markus.Holzner-a/aOGbxzuYeapf4nk6Pq9w< at >public.gmane.org <mailto:Markus.Holzner-a/aOGbxzuYeapf4nk6Pq9w< at >public.gmane.org>

www.quattro-soft.de <http://www.quattro-soft.de>

Amtsgericht Traunstein HR B 12426

Geschäftsführer: Richard Hütter

-------------------------------------------------------------

FDB release 1.1

Pavel Cisar — 2013-04-09T10:55:58

FDB release 1.1 is out:
http://pypi.python.org/pypi/fdb

New Features:

- Context Manager for transactions.

Bugs Fixed:

- http://tracker.firebirdsql.org/browse/PYFB-30

best regards
Pavel Cisar
IBPhoenix


------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/firebird-python/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/firebird-python/join
    (Yahoo! ID required)

<*> To change settings via email:
    firebird-python-digest-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org 
    firebird-python-fullfeatured-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org

<*> To unsubscribe from this group, send an email to:
    firebird-python-unsubscribe-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/

reading blob from table

Hamish Moffatt — 2013-04-06T13:18:59

Hi,

I am using fdb 0.9.9 and Firebird 2.1 and I trying to fetch some data 
out of tables containing blobs. However the blobs I get back are always 
truncated at the first null.


One such table is defined as

SQL> show table g_mididrum;
DRUM_NUMBER                     INTEGER Not Null
DRUM_NAME                       (DOM_MIDI_NAME) VARCHAR(30) Nullable
DRUM_WAVE                       BLOB segment 80, subtype BINARY 
CHARACTER SET NONE Nullable
DRUM_WAVE_6                     BLOB segment 80, subtype BINARY 
CHARACTER SET NONE Nullable
DRUM_WAVE_12                    BLOB segment 80, subtype BINARY 
CHARACTER SET NONE Nullable
CONSTRAINT PK_G_MIDIDRUM:
   Primary key (DRUM_NUMBER)

I'm making the query "SELECT * FROM G_MIDIDRUM". The cursor's 
description field after the query says

(('DRUM_NUMBER', <type 'int'>, 11, 4, 0, 0, False), ('DRUM_NAME', <type 
'str'>, 120, 120, 0, 0, True), ('DRUM_WAVE', <type 'str'>, 0, 8, 0, 0, 
True), ('DRUM_WAVE_6', <type 'str'>, 0, 8, 0, 0, True), ('DRUM_WAVE_12', 
<type 'str'>, 0, 8, 0, 0, True))

The data in DRUM_WAVE (for example) is coming back as a string with 
len() of only 6 or 7 octets. However if I ask firebird to select the 
OCTET_LENGTH(DRUM_WAVE), it tells me the real length which are all 7000 
bytes up to >128k.

I tried using stream blob mode on this column, I get a BlobReader, and 
when I read() all the data from it I still only get 6 or 7 octets.

The connection charset is "UTF8".

I got the same effect in kinterbasdb. We access this table from a C++/Qt 
app with the same query ok though. Can you point out my mistake?



thanks
Hamish


------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/firebird-python/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/firebird-python/join
    (Yahoo! ID required)

<*> To change settings via email:
    firebird-python-digest-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org 
    firebird-python-fullfeatured-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org

<*> To unsubscribe from this group, send an email to:
    firebird-python-unsubscribe-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/

fdb current repository

Maximiliano Robaina — 2013-04-04T20:32:13

Hi,

Which is the current public repo of fdb?

I'm pointing to https://firebird.svn.sourceforge.net/svnroot/firebird/python/fdb/trunk/
but the version here is 

__version__ = '0.9.9'

https://firebird.svn.sourceforge.net/svnroot/firebird/python/fdb/trunk/fdb/fbcore.py

The current fdb version is 1.0, right?



 
--
Maxi


------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/firebird-python/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/firebird-python/join
    (Yahoo! ID required)

<*> To change settings via email:
    firebird-python-digest-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org 
    firebird-python-fullfeatured-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org

<*> To unsubscribe from this group, send an email to:
    firebird-python-unsubscribe-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/

FDB release 1.0

Pavel Cisar — 2013-03-07T16:24:58

FDB release 1.0 is out:
http://pypi.python.org/pypi/fdb

Improvements:

- Removed dependency on presence of fbclient library at import time. 
This caused some confusion to new users when fdb install failed when 
Firebird was not (yet) installed.

Bugs Fixed:

- http://tracker.firebirdsql.org/browse/PYFB-25

best regards
Pavel Cisar
IBPhoenix


------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/firebird-python/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/firebird-python/join
    (Yahoo! ID required)

<*> To change settings via email:
    firebird-python-digest-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org 
    firebird-python-fullfeatured-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org

<*> To unsubscribe from this group, send an email to:
    firebird-python-unsubscribe-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/

segfault in fdb driver

mariuz — 2013-02-26T10:36:45

Long story short when i do a migration with south in django 1.5 i get a segfault 

python2.7[16781]: segfault at 0 ip 00007fc33e049d95 sp 00007fff02447070 error 4 in libfbclient.so.2.5.2[7fc33dff5000+c0000]

Any tips on howto debug it ?

Here is the full disscussion and i can show howto reproduce it 

https://groups.google.com/d/msg/django-firebird-dev/AP14csAqCtI/ok7kTeWb-u4J



------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/firebird-python/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/firebird-python/join
    (Yahoo! ID required)

<*> To change settings via email:
    firebird-python-digest-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org 
    firebird-python-fullfeatured-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org

<*> To unsubscribe from this group, send an email to:
    firebird-python-unsubscribe-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/

Django Firebird driver now available for install from pypi

mariuz — 2013-02-21T18:03:18

Here is the url 
https://pypi.python.org/pypi/django-firebird

This was announced on twitter by Maximiliano Robaina

https://twitter.com/maxirobaina/status/304636118069018624



------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/firebird-python/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/firebird-python/join
    (Yahoo! ID required)

<*> To change settings via email:
    firebird-python-digest-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org 
    firebird-python-fullfeatured-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org

<*> To unsubscribe from this group, send an email to:
    firebird-python-unsubscribe-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/

Again: can't install fdb

skoczian — 2013-01-06T11:26:17

Hello,

trying to install fdb 0.9.9 using Python 3.3 I get the same error message as in July with 0.8.5 and Python 3.2:

D:\home\Sibylle\Downloads\setup\fdb-0.9.9>python setup.py install
Traceback (most recent call last):
  File "setup.py", line 7, in 
    from fdb import __version__
  File "D:\home\Sibylle\Downloads\setup\fdb-0.9.9\fdb\__init__.py", line 23, in
 
    from fdb.fbcore import *
  File "D:\home\Sibylle\Downloads\setup\fdb-0.9.9\fdb\fbcore.py", line 26, in
 
    from . import ibase
  File "D:\home\Sibylle\Downloads\setup\fdb-0.9.9\fdb\ibase.py", line 39, in
 
    fb_library = WinDLL(fb_library_name)
  File "c:\Python33\lib\ctypes\__init__.py", line 353, in __init__
    self._handle = _dlopen(self._name, mode)
TypeError: bad argument type for built-in operation

Only this time it doesn't help that fbclient.dll (64bit version)is in the Windows\system32 directory _and_ the firebird bin directory is in the path. Everything is 64bit:
Windows 7 Home Premium
Firebird 2.5.2
Python 3.3

Testing with ctypes gives quite normal results:

'c:\\program files\\firebird\\firebird_2_5\\bin\\fbclient.dll'
< WinDLL 'c:\program files\firebird\firebird_2_5\bin\fbclient.dll', handle 10000000 at 32ca0f0 > 

< WinDLL 'c:\windows\system32\fbclient.dll', handle 3fb0000 at 33407f0 > 

So what could be wrong this time?




------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/firebird-python/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/firebird-python/join
    (Yahoo! ID required)

<*> To change settings via email:
    firebird-python-digest-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org 
    firebird-python-fullfeatured-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org

<*> To unsubscribe from this group, send an email to:
    firebird-python-unsubscribe-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/

Firebird and Djangos WordPress alternative : Mezzanine

mariuz — 2012-12-17T16:20:11

http://www.firebirdnews.org/?p=8103



------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/firebird-python/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/firebird-python/join
    (Yahoo! ID required)

<*> To change settings via email:
    firebird-python-digest-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org 
    firebird-python-fullfeatured-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org

<*> To unsubscribe from this group, send an email to:
    firebird-python-unsubscribe-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/

PyFirebirdSQL 0.7.1 pure Python driver is released with many fixes

mariuz — 2012-12-13T15:50:31

http://www.firebirdnews.org/?p=8077



------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/firebird-python/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/firebird-python/join
    (Yahoo! ID required)

<*> To change settings via email:
    firebird-python-digest-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org 
    firebird-python-fullfeatured-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org

<*> To unsubscribe from this group, send an email to:
    firebird-python-unsubscribe-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/

Making SQLAlchemy 0.8.0b1 to work with FDB 0.9.x

mariuz — 2012-12-01T16:32:52

If you use SQLAlchemy 0.8.0b1 with fdb there is one issue loading the driver solved in the 
next release of SQLAlchemy

http://www.reddit.com/r/Python/comments/1400nh/firebird_python_driver_fdb_099_is_released/c78p7fy



------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/firebird-python/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/firebird-python/join
    (Yahoo! ID required)

<*> To change settings via email:
    firebird-python-digest-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org 
    firebird-python-fullfeatured-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org

<*> To unsubscribe from this group, send an email to:
    firebird-python-unsubscribe-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/

FDB release 0.9.9

Pavel Cisar — 2012-11-29T13:41:10

FDB release 0.9.9 (a.k.a. almost final) is out:
http://pypi.python.org/pypi/fdb

New Features:

- Firebird ARRAY support.

Other changes:

- Cursor.execute() returns Self, so it could be used as iterator.
- Reading output from Services now uses more efficient method to get 
data from server.

Bugs Fixed:

- Fix: precision_cache in Connection works as intended.

This was supposed to be 1.0 final release, but I've decided to make 1.0 
mode optimized. So 0.9.9 is feature complete driver, and 1.0 release 
planed for January 2013 would contain only optimizations (and bug fixes 
if needed).

best regards
Pavel Cisar
IBPhoenix


------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/firebird-python/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/firebird-python/join
    (Yahoo! ID required)

<*> To change settings via email:
    firebird-python-digest-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org 
    firebird-python-fullfeatured-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org

<*> To unsubscribe from this group, send an email to:
    firebird-python-unsubscribe-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/

SQLAlchemy 0.8.0b1 released with fdb support

mariuz — 2012-10-31T06:54:54

News via \r\python

http://www.reddit.com/r/Python/comments/12dkj8/sqlalchemy_080b1_released/

An experimental dialect for the Firebird : fdb driver is added with this version please test it with Firebird 2.5.2 http://docs.sqlalchemy.org/en/latest/changelog/changelog_08.html#change-274d52dddd6cd76f57ce87648cc1473c





------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/firebird-python/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/firebird-python/join
    (Yahoo! ID required)

<*> To change settings via email:
    firebird-python-digest-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org 
    firebird-python-fullfeatured-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org

<*> To unsubscribe from this group, send an email to:
    firebird-python-unsubscribe-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/

[fdb] Fail on insert BIGINT limits values

Maximiliano Robaina — 2012-10-29T13:56:28

Hi,

In fdb, the BIGINT fail on insert with lower limit value.


Traceback (most recent call last):
  File "<console>", line 1, in <module>
  File "/usr/local/lib/python2.7/dist-packages/fdb/fbcore.py", line 2697, in execute
    self._ps._execute(parameters)
  File "/usr/local/lib/python2.7/dist-packages/fdb/fbcore.py", line 2375, in _execute
    self.__Tuple2XSQLDA(self.in_sqlda, parameters)
  File "/usr/local/lib/python2.7/dist-packages/fdb/fbcore.py", line 2217, in __Tuple2XSQLDA
    int_to_bytes(value, sqlvar.sqllen))), buf_pointer)
  File "/usr/local/lib/python2.7/dist-packages/fdb/fbcore.py", line 443, in int_to_bytes
    return struct.pack(fmt, val)
error: integer out of range for 'Q' format code



The table structure is:

CREATE TABLE MODEL_FIELDS_BIGINT
(
  ID Integer NOT NULL,
  "VALUE" Bigint NOT NULL,
  NULL_VALUE Bigint,
  PRIMARY KEY (ID)
);



 
--
Maxi


b: http://maxirobaina.tumblr.com
t: http://twitter.com/maxirobaina


------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/firebird-python/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/firebird-python/join
    (Yahoo! ID required)

<*> To change settings via email:
    firebird-python-digest-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org 
    firebird-python-fullfeatured-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org

<*> To unsubscribe from this group, send an email to:
    firebird-python-unsubscribe-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/

fdb 0.9.1: possible issue with varchar fields

Maximiliano Robaina — 2012-10-25T22:48:12

I'm testing django-firebird using fdb 0.9.1 

I fall into strange problem testing models with CharFields which are defined as varchar field at database level.

Then, I tried to isolate the problem testing directly with fdb. 


Environment:
Ubuntu 11.04 32 bits
Python 2.7.1
Firebird2.5-super 

fdb 0.9.1


Table structure:

DATABASE CHARSET ISO8859_1, PAGE SIZE 4096


CREATE TABLE TEST_BASE_BIGS
(
  ID Integer NOT NULL,
  S Varchar(255) NOT NULL,
  PRIMARY KEY (ID)
);


First, I insert by hand (using FlameRobin) a record in TEST_BASE_BIGS

INSERT INTO TEST_BASE_BIGS (ID, S) VALUES ('1', 'slugslugslugslugslugslugslugslugslugslugslugslugslugslugslugslugslugslugslugslugslugslugslugslugslugslugslugslugslugslugslugslugslugslugslugslugslugslugslugslugslugslugslugslugslugslugslugslugslugslug');



Now:


('',)


As we can see, It return a empty string instead of the correct value from "s" field


But, adding ID field into query:


(1, '')


Am I doing something wrong?
Is it just a fdb bug ?


--
Maxi


------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/firebird-python/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/firebird-python/join
    (Yahoo! ID required)

<*> To change settings via email:
    firebird-python-digest-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org 
    firebird-python-fullfeatured-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org

<*> To unsubscribe from this group, send an email to:
    firebird-python-unsubscribe-hHKSG33TihhbjbujkaE4pw< at >public.gmane.org

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/