Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
  • 01:47
    zzzeek milestoned #7094
  • 01:47
    zzzeek opened #7094
  • 01:47
    zzzeek labeled #7094
  • 01:38
    zzzeek labeled #6234
  • 01:37
    zzzeek closed #6234
  • 01:34
    zzzeek labeled #6729
  • 01:34
    zzzeek closed #6729
  • Sep 26 14:36
    zzzeek labeled #7089
  • Sep 26 14:36
    zzzeek unlabeled #7089
  • Sep 26 14:36
    zzzeek labeled #7089
  • Sep 26 14:25
    zzzeek reopened #4123
  • Sep 26 06:36
    ChaosGod opened #7089
  • Sep 26 06:36
    ChaosGod labeled #7089
  • Sep 26 06:36
    ChaosGod labeled #7089
  • Sep 25 18:43
    zzzeek review_requested #7087
  • Sep 25 15:21
    zkl2 edited #7087
  • Sep 25 15:21
    zkl2 edited #7087
  • Sep 25 15:19
    zkl2 synchronize #7087
  • Sep 25 15:16
    zkl2 edited #7087
  • Sep 25 14:20
    jvanasco commented on 52e8545
Jonathan Vanasco
@jvanasco

The last week was pure misery. On a scale of 1-10, the "pain" was 0 -- but "discomfort" was 9,999,999,999. I had these silicon nasal splits in each nostril that were the size of my pinky, and made me feel congested + waterboarded. I've only slept 45mins each day, and have been delirious.

They're out now though, and I can breathe and feel GREAT

Federico Caselli
@CaselIT
that does not sound like fun at all!
Jonathan Vanasco
@jvanasco
I'm hoping to finish all the docs tickets I assigned myself. That'll drop us down to one page.
Federico Caselli
@CaselIT

@CaselIT i filled in some answers

nice, will look at them later

mike bayer
@zzzeek
@jvanasco glad you are through that
Federico Caselli
@CaselIT
btw dvarrazzo has been super helpuful in the psycopg issue
mike bayer
@zzzeek
i see that
Jonathan Vanasco
@jvanasco

@CaselIT Yeah, I collapsed from exhaustion a few times and it was a psychedelic experience. Oddly no pain though - I only took one pill the first night.

@zzzeek thanks. it's nice to be amongst the living again.

Federico Caselli
@CaselIT
is he also here? @dvarrazzo
btw shame we had to do 24->25 right away for a setup issue :(
Jonathan Vanasco
@jvanasco
@CaselIT
Federico Caselli
@CaselIT
@jvanasco
Jonathan Vanasco
@jvanasco
@CaselIT any idea on what to use for an example on #3086
mike brainstromed an example, but it's postgres specfic. i'd like to make it sqlite compatible.
Federico Caselli
@CaselIT
off the top of my head I can't think of any similar construct that's general
Jonathan Vanasco
@jvanasco
i can't either. driving me batty
Federico Caselli
@CaselIT
for row we don't have a construct and it's also pg only
tuple has no sqltype type
Jonathan Vanasco
@jvanasco
maybe i'll just set up a test db and make a postgres-only example
Jonathan Vanasco
@jvanasco
ok, went with the postgres example. i remove the literal_columns bit, because it generates the same sql as bare words
Jonathan Vanasco
@jvanasco
@CaselIT is there a label for issues that I can triage with an initial sorting/labeling, but should go to you or mike for schedulding? or should i leave triage in there after sorting with labels.
Federico Caselli
@CaselIT
I don't think we have one
I usually leave them alone if I don't know how to handle them, so that mike does its thing
Jonathan Vanasco
@jvanasco
sounds good. i'll add triage to the issue.
since I'm on the team, if i descope a comment into a new issue it doesn't add the triage label.
mike bayer
@zzzeek
@CaselIT propose we shut down sqlalchemy/alembic#926 and associated issue entirely
Jonathan Vanasco
@jvanasco
@zzzeek i still don't know what "insert=True" does
Does it make the listener run first?
mike bayer
@zzzeek
@jvanasco when you call event.listen(), the function you give it is appended to a list of listener functions. When the event triggers, the handler iterates through this list and calls each listener function in order. Therefore if you register two event listeners A and B in that order, the "A" function will run first, then the "B" function second
with insert=True, you can say: event.listen(target, A); event.listen(target, B, insert=True), and then "B" will invoke first
with that mysql example, SQLAlchemy uses the "first_connect" listener itself to inspect the connection. so if we want to change the sql_mode, we want to change that before SQLAlchemy gets to check it
Jonathan Vanasco
@jvanasco
Ok. That's sort of what I thought after reading lots of code but was not sure.
So.... "The default behavior for event handlers is to append the user defined function to an internal list of registered event listeners upon discovery. If a user registers a function with insert=True, SQLAlchemy will insert (prepend) this function to the internal list upon discovery. This can be used to ensure certain functions run before others."
Federico Caselli
@CaselIT
@zzzeek the import issue is whatever, there is no correct solution as I mentioned, so I'm fine either way :)
Jonathan Vanasco
@jvanasco
Ok. I'm closing out #3160 on postgresql to_tsquery docs, but... I opened #7086 to do a breaking change in the next major release
Federico Caselli
@CaselIT
I saw that, thanks
Jonathan Vanasco
@jvanasco
after coming back to this for years, and a lot of though, .match() uses to_tsquery but should have been using plainto_tsquery -- the former expects a specific postgresql input syntax, the latter expects input that is more compatible with other databases.
Jonathan Vanasco
@jvanasco
we could also just use contains for match, and leave the tsquery stuff to explicit .func usage
Federico Caselli
@CaselIT
what you mean by contains?
Jonathan Vanasco
@jvanasco
oh wait, postgresql doesn't implement contains
it's part of the sql standard and reserved, but not implemented
Jonathan Vanasco
@jvanasco
I'm working on the docs to close out #4201 and can't figure something out
I'm using the example the user provided to show the different ways we can correctly repopulate the objects
instead of using session_obj.commit(), I was under the impression we should be able to use session_obj.expire_all()
that doesn't work though.
that ends up loading an empty collection into baz.bars
am i missing something obvious?
oh wait, i see
baz.foos was not commited
Jonathan Vanasco
@jvanasco

Wow!

i'm actually glad i decided to sprint on the docs. This has been forcing me to really understand a lot of random aspects of SQLAlchemy.

mike bayer
@zzzeek
i love it