OperationalError
sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) connection to
server at "dev.wiilink24.com" (127.0.0.1), port 5432 failed: FATAL:
password authentication failed for user "postgresql"
(Background on this error at: https://sqlalche.me/e/20/e3q8)
Traceback (most rece
On Wednesday, March 16, 2016 at 4:41:38 PM UTC+1, Simon King wrote:
>
>
> Hmm, ok. In that case, does it work if you use "TextValue.id.in_(ids)"
> rather than Node? I can't tell from your
>
Yes, this works – see my last post in this thread.
> description if the "id" and "value" columns are bo
On Wednesday, March 16, 2016 at 3:51:16 PM UTC+1, Simon King wrote:
>
> On Wed, Mar 16, 2016 at 1:43 PM, Piotr Dobrogost <
> p...@2016.groups.google.dobrogost.net > wrote:
>
>> Hi!
>>
>> When executing below code
>>
>> DBSession.query(TextValue).\
>> filter(Node.id.in_(ids)).\
>> up
On 03/16/2016 11:23 AM, Piotr Dobrogost wrote:
so TextValue and Node should be implicitly joined according to rules for
joined table polymorphism in SA.
this is not supported - please read the caveats at
http://docs.sqlalchemy.org/en/rel_1_0/orm/query.html?highlight=query.update#sqlalchemy
Hi!
When executing below code
DBSession.query(TextValue).\
filter(Node.id.in_(ids)).\
update({TextValue.value: appstruct['text_value']},
synchronize_session=False)
I get this error:
OperationalError: (sqlite3.OperationalError) near "FROM": syntax error
[SQL:
On Wed, Mar 16, 2016 at 3:23 PM, Piotr Dobrogost <
p...@2016.groups.google.dobrogost.net> wrote:
> On Wednesday, March 16, 2016 at 3:51:16 PM UTC+1, Simon King wrote:
>>
>> On Wed, Mar 16, 2016 at 1:43 PM, Piotr Dobrogost <
>> p...@2016.groups.google.dobrogost.net> wrote:
>>
>>> Hi!
>>>
>>> When e
On Wed, Mar 16, 2016 at 1:43 PM, Piotr Dobrogost <
p...@2016.groups.google.dobrogost.net> wrote:
> Hi!
>
> When executing below code
>
> DBSession.query(TextValue).\
> filter(Node.id.in_(ids)).\
> update({TextValue.value: appstruct['text_value']},
> synchronize
Hi all,
I'm writing using Flask, Python 2.7.11, Sqlalchemy 1.0.11 and Postgresql
9.4.6 to write a web application but
I keep getting this error when I try to access the database. First, my
config file:
import os
basedir = os.path.abspath(os.path.dirname(__file__))
SECRET_KEY = 'chara'
W
Thanks Michael.
On Saturday, 21 November 2015 22:35:14 UTC, Michael Bayer wrote:
>
>
>
> On 11/20/2015 12:20 PM, Martin Pengelly-Phillips wrote:
> > Hi there,
> >
> > Using SQLAlchemy 1.0.9
> >
> > I am dealing with some legacy code and came across the following issue.
> > It appears that in
On 11/20/2015 12:20 PM, Martin Pengelly-Phillips wrote:
> Hi there,
>
> Using SQLAlchemy 1.0.9
>
> I am dealing with some legacy code and came across the following issue.
> It appears that in a polymorphic relationship SQLAlchemy is not able to
> correctly determine what to load for a relations
Hi there,
Using SQLAlchemy 1.0.9
I am dealing with some legacy code and came across the following issue. It
appears that in a polymorphic relationship SQLAlchemy is not able to
correctly determine what to load for a relationship when using a subselect
(due to limit on query) and child class ha
the patch takes advantage of other improvements in 0.8 and would be
destabilizing for 0.7. it's a pretty major rethink of how join() works.
On Apr 26, 2013, at 4:58 AM, gvv wrote:
> Hi Michael,
>
> Sorry to be a pain, but will these patches be applied to 7.10?
> My app needs a lot of mods fo
Hi Michael,
Sorry to be a pain, but will these patches be applied to 7.10?
My app needs a lot of mods for it to work in 8.0.
If not don't worry, I guess it is time for me to move on to 8.
I'll try it out this weekend.
Thanks
On Friday, April 26, 2013 8:33:45 AM UTC+10, Michael Bayer wrote:
>
I may have come up with a really great solution for all of this, if you'd like
to try the branch I have at https://bitbucket.org/zzzeek/sa_2714 - all the
original use cases seem to be working.
I'll be testing this branch over the next day or so and will have it committed
soon. 0.8.1 is also du
Hi Michael,
Thank you very much for your help and quick response.
The workaround worked.
I really like the simplicity of the query api that i automate the
generation of it.
I will try to incorporate the workaround.
Thanks again
On Thursday, April 25, 2013 7:31:49 AM UTC+10, Michael Bayer wrot
Here's a technique you should be able to use as a workaround:
1. for every mapper that you're joining *to* which is also a joined inheritance
subclass, transform it into an aliased() construct
2. any join involving an aliased() construct, construct the ON criterion
manually.
These two technique
oh. this *fails in 0.7 also*. I thought this was a regression.Yeah, this
query is a little crazier than we've planned for, I can see the general thing
it's failing to do but will have to see what's involved to get it going. But
not a regression is good news at least.
On Apr 24, 2013,
this is logged as http://www.sqlalchemy.org/trac/ticket/2714 for further study,
this is an extremely complicated use case and I may have insight on it today,
or I might not have insight on it until next week.I will have to find the
time to look into it more deeply.
On Apr 24, 2013, at 8:
Hi All,
using 7.10 but falls over also in 8.0.
User has a One2One UserPerson.
UserPerson inherits from Person.
Person has a One2Many PersonAddress.
PersonAddress inherits from Address.
Address has a One2Many Phone and One2Many Email.
The following query falls over with an (OperationalError) no s
Hi,
I'm trying to load my database with fixtures, but it fails with "database
is locked" error.
The setup is the following:
1. I set up database connection, sessions and create the tables
2. I run a post setup script to add some relationships and other data that
were not known before
3. I load th
Michael Bayer wrote
> On Jun 28, 2011, at 1:31 PM, King Simon-NFHD78 wrote:
> >
> > FWIW, I *really* appreciate that you keep the old versions of the
> docs
> > around - I have an application that I maintain using SA 0.3, and
> just
> > last week I needed to refer back to the docs. I hope they neve
On Jun 28, 2011, at 1:31 PM, King Simon-NFHD78 wrote:
> Michael Bayer wrote:
>> - I am loathe to reference the 0.5 docs as people keep finding them
>> and thinking they are current, but an example of this is at
>> http://www.sqlalchemy.org/docs/05/ormtutorial.html#querying-with-
>> joins
>>
>> (
Michael Bayer wrote:
> - I am loathe to reference the 0.5 docs as people keep finding them
> and thinking they are current, but an example of this is at
> http://www.sqlalchemy.org/docs/05/ormtutorial.html#querying-with-
> joins
>
> (Note to people reading this: these are the *OLD DOCS* regarding
On Jun 28, 2011, at 12:26 PM, Oliver wrote:
> I want to have the following query in sqlalchemy:
>
> SELECT t_objects_1.tid AS t_objects_1_tid FROM t_objects AS
> t_objects_2 INNER JOIN c_objects AS c_objects_1 ON t_objects_2.tid =
> c_objects_1.tid INNER JOIN t_objects AS t_objects_1 ON t_object
I want to have the following query in sqlalchemy:
SELECT t_objects_1.tid AS t_objects_1_tid FROM t_objects AS
t_objects_2 INNER JOIN c_objects AS c_objects_1 ON t_objects_2.tid =
c_objects_1.tid INNER JOIN t_objects AS t_objects_1 ON t_objects_1.tid
= t_objects_2.parent_id WHERE c.id = 1;
this wo
make sure the Session is closed when not in use. Make a new session when its
time to talk to the database again. This is in the notes for pool_recycle -
it works upon checkout from the pool.
On Jan 23, 2011, at 2:40 PM, emcconne wrote:
> I'm new to SQLAlchemy and don't understand how I can
I'm new to SQLAlchemy and don't understand how I can maintain my
connections to Postgres over long periods of time... (or reestablish
them automatically). I am getting this error after my web application
sits idle for long periods of time. I am using scopedSession() and
and creating the engine li
On Oct 18, 2010, at 2:46 PM, Jasper K wrote:
> Hi Group,
>
> I am using SqlAlchemy 0.5.8
>
> I get an "(OperationalError) no such column: child.child_id" error
> when trying to eagerload a viewonly many-to-many relationship that
> uses the Association Object pattern with a custom secondaryjoin
Hi Group,
I am using SqlAlchemy 0.5.8
I get an "(OperationalError) no such column: child.child_id" error
when trying to eagerload a viewonly many-to-many relationship that
uses the Association Object pattern with a custom secondaryjoin
condition (http://www.sqlalchemy.org/docs/05/mappers.html#ass
I’ve been stuck trying to get the pylons application to connect to my
database. I was able to connect to the database through a python
shell in the “virtualenv” as you can see below. The app acts like it
can connect to the database, but not to the table.
I admit this is my first pylons project a
Hi,
Im getting a (OperationalError) Could not decode to UTF-8 column. Ok,
I know how to fix this to prevent it, but I have this on a database
that i need intact and I cant query on the row to make an object to
manipulate, delete etc. Any advice? If I could just delete the record,
that would suffi
Hi.
I'm having problems with the exception in subject, with pysqlite (on
Debian Lenny).
Unfortunately, I'm unable to reproduce the problem, but basically it is
an update statement in a transaction.
If there is only one row in the table, all is ok; but if there are more
then one rows, I get t
32 matches
Mail list logo