databases (like
Elasticsearch indexes), for which I effectively just use a basic
datamanager to post data, without any need for synchronized transactions...
Best regards,
Thierry
--
https://www.ulthar.net -- http://pyams.readthedocs.io
Le mer. 27 janv. 2021 à 20:40, Mike Bayer a
écrit :
&g
to Github
and made a pull request. But I don't know how to provide a test case as a
two-phase commit is not supported by SQLite...
I'll try anyway to provide a description of a "method" I use to reproduce
this!
Best regards,
Thierry
--
https://www.ulthar.net -- http://pyams.readthe
)!
Is it normal behaviour, and what does this value mean?
Best regards,
Thierry
--
https://www.ulthar.net -- http://pyams.readthedocs.io
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example code, please provide an MCVE: Minimal
Dear SQLAlchemy experts,
I'm having difficulty generating an SQL query with SQLAlchemy.
I'm trying to query a list of messages with their originator and
recipients. Each message is sent by one host to one or more hosts. Hosts
are all stored in one table (host). There are two types of messages
Hi,
For Pyramid, another interesting package is SQLTap, which provides useful
informations about execution of SQLAlchemy queries...
Best regards,
Thierry
2016-10-31 11:05 GMT+01:00 Simon King <si...@simonking.org.uk>:
> On Sun, Oct 30, 2016 at 9:36 PM, Alfred Perlstein
> &l
...I
> think this comes up a lot over there it's like an OCI thing.
>
>
>
> On 09/12/2016 03:20 PM, Thierry Florac wrote:
>
>> Hi Mike,
>>
>> I really agrea with you on all the points you mentionned. And I won't
>> add anything about the cost of an
DBA can't find
any solution to it, I'm just trying to find a bypass on the ORM side.
I definitively agree with SA ORM's way of handling all this. I was quite
sure in fact that there was no easy way to bypass the ORM...
Thanks anyway,
Thierry
2016-09-12 20:53 GMT+02:00 Mike Bayer <m
" function), so that selects performances are good, but is
there a way to use such literals while performing updates ou deletes
through the ORM using sessions?
Best regards,
Thierry
--
http://www.imagesdusport.com -- http://www.ztfy.org
--
You received this message because you are subscribed
Hi,
I don't think that the solution can come from SQLAlchemy.
You may have to create a database link between your two databases to be
able to query both of them with a single instruction...
Best regards,
Thierry
2016-02-23 11:43 GMT+01:00 Mehdi <mese1...@gmail.com>:
> Hi
> Is it
Hi !
Did you try "session.delete(myrecord)" ?
Best regards,
Thierry
2016-02-06 5:16 GMT+01:00 Alex Hall <ah...@autodist.com>:
> Hello all,
> Another basic question: given an instance of a record, can I somehow
> delete the record from a table? The longer story i
What database server do you use?
2015-01-17 0:49 GMT+01:00 Brian Glogower bglogo...@ifwe.co:
Hi all,
I am trying to do a join between two tables, each residing on a separate
databases.
Here is the table info for both. I have removed extraneous columns from
each table.
Table A from DB 1:
looking for is a way to close a given connection which
is returned to the pool if it wasn't used for a given amount of time...
Any idea ?
Best regards,
Thierry
--
http://www.imagesdusport.com -- http://www.ztfy.org
--
You received this message because you are subscribed to the Google Groups
connection. Do you think that using pool events to monitor a pool's
connections could be a good starting point?
Best regards,
Thierry
2014-09-25 18:04 GMT+02:00 Michael Bayer mike...@zzzcomputing.com:
On Sep 25, 2014, at 4:33 AM, Thierry Florac tflo...@gmail.com wrote:
Hi,
I have a multi
queries. Even if only a small set or arguments data
types are supported, how could I use it?
Best regards,
Thierry
2014-05-13 0:37 GMT+02:00 Michael Bayer mike...@zzzcomputing.com:
On May 12, 2014, at 6:12 PM, Thierry Florac tflo...@gmail.com wrote:
Hi,
I use Python and SQLAlchemy to access
Hi Michael,
I just tried using literal_column function and now performances are as
good as they can :-/
As my problem is only limited to a single use case, using this method, even
if not perfect (arguments must be carefully verified!), if far better than
a global option.
Many thanks,
Thierry
to not use prepared statements ??
Best regards,
Thierry
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group
That sounds really great.
Simple question : is there any way to use SQLTap in a multi-processes WSGI
environment ??
Best regards,
Thierry
2014-03-10 5:28 GMT+01:00 Michael Bayer mike...@zzzcomputing.com:
hey that looks pretty nice, ill give it a shoutout.
On Mar 9, 2014, at 9:21 PM, Alan
.
Maybe you can have a look if that can help... =
https://pypi.python.org/pypi/ztfy.alchemy
Best regards,
Thierry
2013/12/11 Jeff Dairiki dair...@dairiki.org
I just noticed my connection pool isn't pooling. Whenever a connection
which has been used only for reading is returned to the pool
and without real updates:
do_begin_twophase
do_prepare_twophase = False
do_commit_twophase
oci_prepared = False
no commit !
That's great, for me it works like a charm!
Do you think that this patch could be backported to a new 0.7.x release of
SA ?
Best regards,
Thierry
2012/11/21 Michael
.139760315672320 A storage error occurred
during the second phase of the two-phase commit. Resources may be in an
inconsistent state.
after rollback
Hope this can help to understand the problem; any advise is greatly
welcome...
Best regards,
Thierry
2012/11/20 Michael Bayer mike...@zzzcomputing.com
is : in the context of an SA session, who is
responsible of the prepare/commit statements, so that commit is not called
if prepared was not OK ?
Best regards,
Thierry
2012/11/20 Michael Bayer mike...@zzzcomputing.com
Googling for the ORA code yields the usual tautological answers that say
Le Mon, 19 Nov 2012 10:23:14 -0500,
Michael Bayer mike...@zzzcomputing.com a écrit:
On Nov 19, 2012, at 8:10 AM, Thierry Florac wrote:
Hi,
I'm using SQLALchemy (currently 0.7.3 in this project, also tested
with 0.7.9) with cx_Oracle-5.1.1 in a Zope3 project. SQLAlchemy
-linux-x86_64.egg/sqlalchemy/orm/properties.py,
line 1458, in _refers_to_parent_table
pt.is_derived_from(c.table) and \
AttributeError: '_BinaryExpression' object has no attribute 'table'
So what parameters should I use to create the back reference ?
Best regards,
Thierry
--
You received
Hi,
Le lundi 18 juin 2012 12:07:46 UTC+2, Thierry Florac a écrit :
Hi Michael,
Le samedi 16 juin 2012 17:54:21 UTC+2, Michael Bayer a écrit :
On Jun 16, 2012, at 11:41 AM, Michael Bayer wrote:
It's not a basic question at all as this is a rare edge case, and it's
not a foreign key
way to build an SQLAlchemy relation between these
two tables ?
Best regards,
Thierry
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email
:-)
I'll try to test this quickly, but not before monday morning in
fact when being back at work :-/
Many thanks,
Thierry
Le Sat, 16 Jun 2012 11:41:29 -0400, Michael Bayer
mike...@zzzcomputing.com a �crit:
It's not a basic question at all as this is a rare edge case, and
it's not a foreign
also add that I **have to** use declarative form of SQLAlchemy,
because GeoAlchemy doesn't seem to handle anything else :-/
Any help would be greatly welcome !
Best regards,
Thierry
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To view
Le vendredi 15 juin 2012 12:00:28 UTC+2, Thierry Florac a écrit :
Hi,
I'm using SQLAlchemy (0.7.4) with GeoAlchemy to map tables containing
geographic entities from a PostgreSQL/PostGIS database.
As I have to handle data from several parts of the world, each part using
it's own
Hi
I'm trying to mimick the example from the documentation (employee/
manager/engineer)
I've been able to add employees, and engineers, and all works as
expected
now my next step would be, creating an 'Employee' object, and some
time later, decide that he's in fact an engineer.
so my first
2011/12/2 Michael Bayer mike...@zzzcomputing.com:
On Dec 1, 2011, at 7:09 PM, Thierry Florac wrote:
2011/12/2 Michael Bayer mike...@zzzcomputing.com:
On Dec 1, 2011, at 5:38 PM, Thierry Florac wrote:
Hi,
So it seems that when resources are in the form and NOT modified, the
matching task
ON
projetsdi.activite.id_tache_am = tache_1.id
LEFT OUTER JOIN projetsdi.tache tache_2 ON
projetsdi.activite.id_tache_pm = tache_2.id
Any idea about how to get such a result ??
Many thanks,
Thierry
--
http://www.imagesdusport.com -- http://www.ztfy.org
--
You received this message because
) \
.outerjoin(TaskPM, Activity.task_pm) \
.filter(...)
Best regards,
Thierry
2011/12/1 Thierry Florac tflo...@gmail.com:
Hi,
I have a little problem with outer joins (I use QSLAlchemy 0.5.6).
I have two tables, managing tasks and activities :
class Task(Base
!!!
Best regards,
Thierry
--
http://www.imagesdusport.com -- http://www.ztfy.org
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email
2011/12/2 Michael Bayer mike...@zzzcomputing.com:
On Dec 1, 2011, at 5:38 PM, Thierry Florac wrote:
Hi,
So it seems that when resources are in the form and NOT modified, the
matching task is not flagged dirty and is not saved in database. I
just don't understand why !!!
Only a full usage
Yes, that's what I thought...
I actually use a pool_recycle parameter of 3600 to recycle active
connections every hour, but the problem remains the same as before
(with default value of -1).
So I'm a bit stuck :-(
Regards,
Thierry
2010/12/20 Michael Bayer mike...@zzzcomputing.com
Is there anyway to print the query with the params in place?
example:
products = sa.query(entity_object).filter
(entity_table.c.created_attime_object)
print products
Prints the query, but without the params.
For debugging it would be nice if it could produce something i can
paste and execute
36 matches
Mail list logo