Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
  • 17:43
    CaselIT labeled #5731
  • 17:43
    CaselIT unlabeled #5731
  • 17:37
    CaselIT unlabeled #5735
  • 17:37
    CaselIT labeled #5735
  • 17:33
    zzzeek milestoned #5735
  • 17:33
    zzzeek labeled #5735
  • 17:33
    zzzeek labeled #5735
  • 17:33
    zzzeek labeled #5735
  • 16:46

    sqlalchemy-bot on master

    Disallow bug reports based on f… (compare)

  • 16:36
    zzzeek closed #5718
  • 16:34
    zzzeek review_requested #763
  • 16:33
    zzzeek unlabeled #745
  • 16:33
    zzzeek labeled #745
  • 16:33
    zzzeek unlabeled #764
  • 16:33
    zzzeek labeled #764
  • 16:32
    zzzeek labeled #764
  • 16:32
    zzzeek labeled #764
  • 16:32
    zzzeek unlabeled #764
  • 16:31
    zzzeek labeled #745
  • 14:36
    brmzkw edited #5735
mike bayer
@zzzeek
@CaselIT yes that may be the case now
Federico Caselli
@CaselIT
added an issue, since I've noticed that alembic is also missing tests for sqlite computed
Federico Caselli
@CaselIT
@zzzeek i've got a problem I don't know how to best solve:
if I have a Column('foo', Integer, Identity()) this renders the default, but when reflecting I get back Identity(start=1, increment=1, minvalue=1, maxvalue=2147483647, cycle=False, cache=1)
how do I compare that and decide that they are the same?
mike bayer
@zzzeek
I just broke jenkins, fixing
@CaselIT with that kind of thing we look at the attributes and if an attribute is not set, we dont comapre it to the reflected one
we assume it's a DB default
the type comparison logic does this, actualy it does it in both directions which is probbly less than ideal
Federico Caselli
@CaselIT

I just broke jenkins, fixing

so you can check off the daily to do list:
[x] fight against the ci

@CaselIT with that kind of thing we look at the attributes and if an attribute is not set, we dont comapre it to the reflected one

that makes sense. thanks

Jonathan Vanasco
@jvanasco
@zzzeek if it's 100W when idle, you could test the power draw at a few lower load levels, to see if the power supply has a high minimum draw. you might be able to just swap out a more efficient power supply.
2 replies
mike bayer
@zzzeek
im still trying to find a way to not spin up 16 digital ocean instances at once
20 cents a pop this is an expensive way to debug
Federico Caselli
@CaselIT
why do you need 16?
mike bayer
@zzzeek
i dont
:)
i told it 4 and then put a bunch of jobs in
i have another theory what might help, about to try that
OK running it again :)
mike bayer
@zzzeek
fail
what a piece of shit
Federico Caselli
@CaselIT
I sense a zzzeek-jenkins-cloud-thingy in the future
mike bayer
@zzzeek
i added to the jira with more of what my theory is and if they have the decency to say "yup", I can try for a PR
have to get the java band back together
ugh
Federico Caselli
@CaselIT
Good luck, I guess
Gord Thompson
@gordthompson

have to get the java band back together

"Please be advised that since Java 9 the minimum requirement has been increased to at least a 20-piece orchestra. You may need to upgrade your rehearsal space and tour bus arrangements accordingly. Sincerely, Oracle and/or its affiliates." ;)

(Is it just me or does the Gitter web UI get weirder with each passing day?)
Jonathan Vanasco
@jvanasco

@zzzeek @CaselIT would it make sense to document what each supported database+version reflects Identity() back as?

I'm not thinking about this as much for use by automated detection, but just so we get an idea of what this behavior and variances are.

Federico Caselli
@CaselIT
I guess so. But the odd one is mostly mssql that always reflect identity now
Jonathan Vanasco
@jvanasco
Actually, it might be a good idea to create a unittest that checks this - to catch when any of the databases reflect this differently
Federico Caselli
@CaselIT
I think there is already
Jonathan Vanasco
@jvanasco
the core functionality of this is covered by existing tests, but i mean checking every attribute that is relected
i overtest.
Federico Caselli
@CaselIT
so identity is standard so it should be all or nothing*
*mssql is the odd one, since it does not support the standard :)
Jonathan Vanasco
@jvanasco
sorry if i complicated the odbc quesiton. i didn't mean to suggest there are no reasons, just that 99.9% of people will want to use the other two drivers.
Federico Caselli
@CaselIT
Will we skip the meeting today given the Thanksgiving?
Gord Thompson
@gordthompson
Not Thanksgiving here; ours was weeks ago.
Federico Caselli
@CaselIT
oh, canada also has one?
do you also have the 🦃?
Gord Thompson
@gordthompson
Yeah, second Monday in October. Our harvests are earlier up here.
Weird. Chrome can't render the emoji but Firefox can.
Federico Caselli
@CaselIT
oh strange.
Gord Thompson
@gordthompson
Yup, turkey is traditional here, too. Ham is also popular. I always vote for "both", especially if I'm not the one doing the cooking.
One thing we don't (typically) do is "sweet potato pie". Never had it, myself.
It's usually pumpkin pie for us.
mike bayer
@zzzeek
hey, sorry yes today was no meeting :) big long day here
Jonathan Vanasco
@jvanasco
Sweet Potato Pie is terrible. Pumpkin Pie is rarely made of actual pumpkins. "canned pumpkin" is from the Dickinson Squash which was renamed "Dickinson Pumpkin"; it's closer to a butternut squash. (happy to ruin thanksgiving for all!)
Federico Caselli
@CaselIT
I believe I've never tasted them. sweet potatos are not common here
Jonathan Vanasco
@jvanasco
They are very similar to Yams, if you have had those.