On Thu, Nov 5, 2015 at 7:34 AM, Mike Bayer wrote:
>
>
> On 11/03/2015 06:55 PM, Ken Lareau wrote:
>
>> I came across this during a search, and in the four different sites
>> I've checked, I've seen four different release dates varying from
>>
ors of the book, I'm hoping I might be able
to find out more here. :)
--
Ken Lareau
--
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+unsub
eeded. You may find postgres'
> advisory locks useful if any synchronization needs arise.
>
> References:
> http://www.postgresql.org/docs/9.4/static/sql-listen.html
> http://initd.org/psycopg/docs/advanced.html#asynchronous-notifications
>
> - Dave
>
>
> On 9/2/2015 8
bit of reading on events, but not having used them before I'm
unsure if this will work, especially since multiple deployments can be
occurring so the 'listener' will need to be only paying attention to the
entries related to that one given deployment (basically just the
AppDeployment
On Thu, Sep 4, 2014 at 4:54 PM, Michael Bayer
wrote:
>
> On Sep 4, 2014, at 7:50 PM, Ken Lareau wrote:
>
>
> Is there a way to essentially allow something like 'for app in
> project.applications:' without having
> to make an explicit query to the DB first, but av
On Thu, Sep 4, 2014 at 4:35 PM, Michael Bayer
wrote:
>
> On Sep 4, 2014, at 6:58 PM, Ken Lareau wrote:
>
> On Thu, Sep 4, 2014 at 3:30 PM, Michael Bayer
> wrote:
>
>>
>> On Sep 4, 2014, at 5:37 PM, Ken Lareau wrote:
>>
>> So I have a few tables as fo
On Thu, Sep 4, 2014 at 3:30 PM, Michael Bayer
wrote:
>
> On Sep 4, 2014, at 5:37 PM, Ken Lareau wrote:
>
> So I have a few tables as follows (abbreviated for unnecessary columns):
>
> class Project(Base):
> __tablename__ = 'projects'
>
> id = Column(
ombination of the "ondelete='cascade'" settings in the
project_package table and the 'passive_deletes' settings in the
relationships
is what's triggering this, but after try many different searches on Google,
I'm
not finding the right solution to fix this; o
ince it seems that MySQL uses 'PRIMARY' for the name of the constraint
and I'm not even sure that's changeable (been putting together a test data-
base to try it out on)). But I'll see what I can hack together. :)
- Ken
>
>
>
> On 7/2/14, 6:08 PM, Ken Lareau wro
table and
determine each by hand, but I was wondering if there was a less manual
(and error-prone) way to approach this, possibly via the autogeneration
feature? In case it matters, the database server is MySQL.
--
- Ken Lareau
--
You received this message because you are subscribed to the G
**SIGH** Please ignore last message... I had forgotten to actually
update the database schema itself. :( Pardon me while I go shoot
myself...
- Ken
On Tue, Jul 1, 2014 at 4:19 PM, Ken Lareau wrote:
> On Thu, Jun 26, 2014 at 7:47 PM, Ken Lareau wrote:
>
>> On Jun 26, 2014 7:
On Thu, Jun 26, 2014 at 7:47 PM, Ken Lareau wrote:
> On Jun 26, 2014 7:40 PM, "Mike Bayer" wrote:
> >
> > right, so a few emails ago I said:
> >
> > > you need to put .label('environment') on that column before it finds
> its wa
On Tue, Jul 1, 2014 at 2:17 PM, Mike Bayer wrote:
>
> On 7/1/14, 4:54 PM, Ken Lareau wrote:
>
> Related to one of my recent posted threads here, I'm recalling a certain
> conversation at PyCon where I was mentioning how a friend would define
> a many-to-many rel
d I'm sure there other poten-
tial "gotchas", so I guess this leads back to the main question at hand:
Are there times when using "reciprocal" relationships is okay, and are
there certain things that should be done to mitigate potential issues that
can be caused by doing
hanks. Now I'm afraid to ask if you looked at the "after" file,
and if so, considered it insane. :)
- Ken
>
>
>
>
>
> On 6/26/14, 9:50 PM, Ken Lareau wrote:
>>
>> Done, new file attached (this gives the same error message as the one I
showed initially,
Done, new file attached (this gives the same error message as the one I
showed initially, at least on my system).
- Ken
--
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 emai
ase there were any questions
that might come from the code itself; hopefully I didn't miss any, but
if there's still confusion, let me know.
- Ken
>
>
> On 6/26/14, 4:11 PM, Ken Lareau wrote:
>
> On Thu, Jun 26, 2014 at 5:57 AM, Mike Bayer
> wrote:
>
>>
>&
On Thu, Jun 26, 2014 at 5:57 AM, Mike Bayer
wrote:
>
> On 6/25/14, 8:06 PM, Ken Lareau wrote:
>
> On Wed, Jun 25, 2014 at 6:28 AM, Mike Bayer
> wrote:
>
>>
>> On 6/25/14, 2:26 AM, Ken Lareau wrote:
>>
>> On Tue, Jun 24, 2014 at 3:35 PM, Mike Bayer
>
On Wed, Jun 25, 2014 at 6:28 AM, Mike Bayer
wrote:
>
> On 6/25/14, 2:26 AM, Ken Lareau wrote:
>
> On Tue, Jun 24, 2014 at 3:35 PM, Mike Bayer
> wrote:
>
>>
>> On 6/23/14, 8:09 PM, Ken Lareau wrote:
>> >
>> > if apptier:
>
On Tue, Jun 24, 2014 at 3:35 PM, Mike Bayer
wrote:
>
> On 6/23/14, 8:09 PM, Ken Lareau wrote:
> >
> > if apptier:
> > subq = (
> > Session.query(
> > Package.pkg_name,
> > Package.ver
Anyone? This has me dead in the water and nothing in the documentation
has been helping.
- Ken
On Mon, Jun 23, 2014 at 5:09 PM, Ken Lareau wrote:
> On Fri, Jun 20, 2014 at 3:46 PM, Ken Lareau wrote:
>
>> On Fri, Jun 20, 2014 at 1:23 PM, Mike Bayer
>> wrote:
>>
>
On Fri, Jun 20, 2014 at 3:46 PM, Ken Lareau wrote:
> On Fri, Jun 20, 2014 at 1:23 PM, Mike Bayer
> wrote:
>
>>
>> On 6/20/14, 3:38 PM, Ken Lareau wrote:
>>
>> So in the ongoing improvement of one of our internal databases, we
>> created
>> a n
On Fri, Jun 20, 2014 at 1:23 PM, Mike Bayer
wrote:
>
> On 6/20/14, 3:38 PM, Ken Lareau wrote:
>
> So in the ongoing improvement of one of our internal databases, we
> created
> a new table named 'environments' whose SQLA code looks something like
> t
I can see
this coming up again in the future as further schema refactorings occur, so
I turn to those with more expertise to find out if there is a way to
accomplish
what I desire, or if there's really no hope. :) Any insight would be
greatly
appreciated.
--
- Ken Lareau
--
You received
On Fri, Oct 11, 2013 at 5:53 PM, Michael Bayer wrote:
>
> On Oct 11, 2013, at 7:14 PM, Ken Lareau wrote:
>
> In the process of trying to find an efficient way to manage a test database
> for a large set of tests for a database library I'm writing that uses
> SQLAlchemy,
&g
nfigured on mapper
Mapper|Environments|environments or this Session
This does not completely surprise me as my understanding about sessions
in SQLAlchemy is still not solid enough to always understand why my
current code works (and I have a full application using this without issue
at the moment).
LAchemy internals
> are affected by this.
>
> Thank you for your input, Michael.
>
While I'm not using the 'two-step' approach this time, there will be future
column renames that are far more insidious and may require it, so I would
also like to know if the abov
On Tue, Sep 24, 2013 at 2:53 PM, Michael Bayer wrote:
>
> On Sep 24, 2013, at 5:42 PM, Ken Lareau wrote:
>
> On Tue, Sep 24, 2013 at 11:10 AM, Ken Lareau wrote:
>
>>
>> On Tue, Sep 24, 2013 at 10:32 AM, Michael Bayer > > wrote:
>>
>>>
>
On Tue, Sep 24, 2013 at 11:10 AM, Ken Lareau wrote:
>
> On Tue, Sep 24, 2013 at 10:32 AM, Michael Bayer
> wrote:
>
>>
>> On Sep 24, 2013, at 12:00 PM, Ken Lareau wrote:
>>
>> >
>> >
>> >
>> > Of course, this leads back to
On Tue, Sep 24, 2013 at 10:32 AM, Michael Bayer wrote:
>
> On Sep 24, 2013, at 12:00 PM, Ken Lareau wrote:
>
> >
> >
> >
> > Of course, this leads back to the original question... how exactly
> > does one accomplish this? :) Hopefully the clarification a
On Tue, Sep 24, 2013 at 7:25 AM, Michael Bayer wrote:
>
> On Sep 23, 2013, at 10:04 PM, Ken Lareau wrote:
>
> > Hopefully this will make sense...
> >
> > I have a database which is in need of some normalization of the column
> > naming in various tables. In
My searching through the docs so far hasn't turned up anything useful,
I'm afraid...
Thanks in advance.
--
- Ken Lareau
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emai
On Thu, Jan 17, 2013 at 4:26 PM, Michael Bayer wrote:
>
> On Jan 17, 2013, at 7:24 PM, Ken Lareau wrote:
>
>
>
> On Thu, Jan 17, 2013 at 4:13 PM, Michael Bayer
> wrote:
>
>>
>> On Jan 17, 2013, at 7:01 PM, Ken Lareau wrote:
>>
>> On Thu,
On Thu, Jan 17, 2013 at 4:13 PM, Michael Bayer wrote:
>
> On Jan 17, 2013, at 7:01 PM, Ken Lareau wrote:
>
> On Thu, Jan 17, 2013 at 3:54 PM, Michael Bayer
> wrote:
>
>>
>> On Jan 17, 2013, at 6:45 PM, Ken Lareau wrote:
>>
>> Sadly, it looks like when I
On Thu, Jan 17, 2013 at 3:54 PM, Michael Bayer wrote:
>
> On Jan 17, 2013, at 6:45 PM, Ken Lareau wrote:
>
> Sadly, it looks like when I try the code in my full application, it is
> failing miserably.
> I'm seeing errors like this:
>
> sqlalchemy.orm.exc.DetachedInsta
''
is already attached to session '1' (this is '3')
Sadly it's not immediately obvious as to what's going on... not even
certain how
to start debugging this problem.
- Ken
On Tue, Jan 8, 2013 at 2:59 PM, Ken Lareau wrote:
> On Tue, Jan 8, 2013 at 2:16
On Tue, Jan 8, 2013 at 2:16 PM, Michael Bayer wrote:
>
> On Jan 8, 2013, at 4:00 PM, Ken Lareau wrote:
>
>
> Given this and your previous comments, and after some conversations with
> a coworker, I decided to expose the 'engine' variable from the database
> library
On Mon, Jan 7, 2013 at 9:27 AM, Michael Bayer wrote:
>
> On Jan 7, 2013, at 1:11 AM, Ken Lareau wrote:
>
>
> Okay, this is what I suspected and feared. :) Creating new sessions isn't
> much of an
> issue, and I came up with a class to manage this for me before realizi
Michael,
Thanks for the response, see further questions/issues below...
On Fri, Jan 4, 2013 at 8:41 AM, Michael Bayer wrote:
>
> On Jan 3, 2013, at 10:18 PM, Ken Lareau wrote:
>
> I recently (today) ran into an issue that has me perplexed as to how to
> resolve it,
> so I&#x
lease don't hesitate
to ask,
and I thank folks in advance for any assistance they can give.
--
- Ken Lareau
--
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 u
40 matches
Mail list logo
