[firebird-python] Re: save and retrive datetime data type

[maxiroba...@gmail.com [firebird-python]]

Ok, memory failure.

It was disccused here before: 
https://groups.yahoo.com/neo/groups/firebird-python/conversations/topics/574 
https://groups.yahoo.com/neo/groups/firebird-python/conversations/topics/574

[firebird-python] Re: save and retrive datetime data type

[maxiroba...@gmail.com [firebird-python]]

Ok, memory failure.

It was disccused here before:
https://groups.yahoo.com/neo/groups/firebird-python/conversations/topics/574 
https://groups.yahoo.com/neo/groups/firebird-python/conversations/topics/574

Re: [firebird-python] sql replace params

[maxiroba...@gmail.com [firebird-python]]

 Hi Pavel,

Thaks for response.
The SO question clarifeid me about this Firebird limitation.

Regards.



---In firebird-python@yahoogroups.com,  wrote :

 Hi,
 
 This has nothing to do with FDB. Parameters (?) are implemented by 
 Firebird engine itself, FDB just supports it. So you should ask such 
 question in Firebird-support list, or check out 
 
https://stackoverflow.com/questions/37348807/data-type-unknown-in-case-expression-with-only-parameters-as-values
 
https://stackoverflow.com/questions/37348807/data-type-unknown-in-case-expression-with-only-parameters-as-values
 
 regards
 Pavel Cisar
 IBPhoenix
 
 Dne 15.4.2018 v 03:03 maxirobaina@... mailto:maxirobaina@... [firebird-python] 
napsal(a):
 > Hi,
 > 
 > I have the next sql command
 > 
 > sql = 'SELECT
 > "EXPRESSIONS_COMPANY"."ID",
 > "EXPRESSIONS_COMPANY"."NAME",
 > "EXPRESSIONS_COMPANY"."NUM_EMPLOYEES",
 > "EXPRESSIONS_COMPANY"."NUM_CHAIRS",
 > "EXPRESSIONS_COMPANY"."CEO_ID",
 > "EXPRESSIONS_COMPANY"."POINT_OF_CONTACT_ID",
 > ? AS "FOO"
 > FROM "EXPRESSIONS_COMPANY"
 > WHERE ? = ?
 > ORDER BY "EXPRESSIONS_COMPANY"."NAME" ASC'
 > 
 > Running this sql
 > cur.execute(sql, ['value', 'value', 'value'])
 > 
 > Raise an exception:
 > SQL error code = -804 - Data type unknown'
 > 
 > Of course, fdb doesn't replace params from entire sql command, just from 
 > where clause.
 > 
 > Is this behavior the standard according to python db-api ?
 > Is there another approach to accomplish using fdb without make a string 
 > replacement ?
 > 
 > 
 > Regards
 > Maxi
 > 
 > 
 > 
 > 
 > 
 > 
 > 
 > 
 > 
 > 
 > 
 > 

  

[firebird-python] sql replace params

[maxiroba...@gmail.com [firebird-python]]

Hi,

I have the next sql command

sql = 'SELECT  
   "EXPRESSIONS_COMPANY"."ID", 
   "EXPRESSIONS_COMPANY"."NAME", 
   "EXPRESSIONS_COMPANY"."NUM_EMPLOYEES",
   "EXPRESSIONS_COMPANY"."NUM_CHAIRS", 
   "EXPRESSIONS_COMPANY"."CEO_ID", 
   "EXPRESSIONS_COMPANY"."POINT_OF_CONTACT_ID", 
   ? AS "FOO" 
   FROM "EXPRESSIONS_COMPANY" 
   WHERE ? = ? 
   ORDER BY "EXPRESSIONS_COMPANY"."NAME" ASC'

Running this sql
cur.execute(sql, ['value', 'value', 'value'])

Raise an exception:
 SQL error code = -804 - Data type unknown'

Of course, fdb doesn't replace params from entire sql command, just from where 
clause.

Is this behavior the standard according to python db-api ?
Is there another approach to accomplish using fdb without make a string 
replacement ?


Regards
Maxi










 

Re: [firebird-python] FDB Python driver for Firebird v1.6.1 released

[Maxi maxiroba...@gmail.com [firebird-python]]

2016-11-30 11:26 GMT-03:00 Pavel Cisar pci...@ibphoenix.cz
[firebird-python] :

> FDB v1.6.1 is available for download. This version fixes few bugs.
>
> https://pypi.python.org/pypi/fdb
>
>


Great work!

Thank you.

[firebird-python] fdb connect to non default port

[Maxi maxiroba...@gmail.com [firebird-python]]

Hi,

The connect function of fdb has a port parameter, but into function doc it
says:

:param integer port: Port used by Firebird server **(not used)**.

The fdb doc [1] doesn't clarify about it, so port parameter is ignored and
we have to use the dsn format connection always.

Is that correct?

[1] http://pythonhosted.org//fdb/usage-guide.html#databases

---
Maxi

Re: [firebird-python] fdb smallint ranges fails

[Maxi maxiroba...@gmail.com [firebird-python]]

2016-04-11 7:07 GMT-03:00 Pavel Cisar pci...@ibphoenix.cz [firebird-python]
:

>
>
> Hi,
>
> Dne 10.4.2016 v 17:01 Maximiliano Robaina maxi_roba...@yahoo.com.ar
> [firebird-python] napsal(a):
> > Why in fdb.ibase.py smaillint min range is defined as SHRT_MIN = -32767
> ?
>
> It's a bug, sorry. Fix committed, will appear in next version. You can
> fix it manually for now.
>
> see http://tracker.firebirdsql.org/browse/PYFB-65
>
>
Hi Pavel,

Thanks for create the ticket.
Yes, I fix this in my local copy and it works fine.

BTW, Are you taking into consideration add fdb project into FirebirdSQL
github repos [1] ?
Would be great for a better contribution.

Best regards.
---
Maxi


[1] https://github.com/FirebirdSQL/