04:06 ltbarcly1
04:06 ltbarcly #sqlalchemy
04:06 ltbarcly is there a way to tell sqlalchemy not to instrument results of a query?
04:56 tux21b #sqlalchemy
05:32 atomekk #sqlalchemy
05:36 hyperboreean
05:44 hyperboreean #sqlalchemy
05:47 squigle
05:53 asabil #sqlalchemy
06:06 bag_ #sqlalchemy
06:21 bag_
06:39 bag_ #sqlalchemy
06:40 saju_m #sqlalchemy
06:41 saju_m how find variance(). have any funcion available like fun.avg() and fun.sum()
06:42 afd_ #sqlalchemy
06:43 saju_m ther is no function func.variance() in sqllalchemy
06:49 lelit #sqlalchemy
06:50 btami #sqlalchemy
06:52 btami
06:54 bag_
06:54 drakkan1000 #sqlalchemy
06:58 btami #sqlalchemy
07:26 ignas #sqlalchemy
07:27 Ramonster #sqlalchemy
07:28 gronky__
07:34 psino #sqlalchemy
07:35 alekibango
07:41 zhicheng #sqlalchemy
07:41 ignas
07:55 gronky__ #sqlalchemy
07:56 harobed #sqlalchemy
08:05 btami
08:10 d0ugal #sqlalchemy
08:10 atomekk
08:24 atomekk #sqlalchemy
08:39 ignas #sqlalchemy
08:40 saju_m
08:41 saju_m #sqlalchemy
  saju_m
08:42 saju_m #sqlalchemy
08:44 Shyde #sqlalchemy
08:48 alekibango #sqlalchemy
08:53 gthb #sqlalchemy
08:54 Shyde
09:02 jeffszusz #sqlalchemy
09:02 sector119 saju_m: write your own.
09:09 gthb
09:10 pjenvey
09:11 pjenvey #sqlalchemy
09:18 gthb #sqlalchemy
09:39 jhauser #sqlalchemy
09:39 saju_m
09:40 saju_m #sqlalchemy
09:53 gthb
10:13 zhicheng
10:27 gronky__
10:39 saju_m
10:40 saju_m #sqlalchemy
10:41 saju_m
  saju_m #sqlalchemy
10:43 btami #sqlalchemy
10:48 gthb #sqlalchemy
11:07 Ergo^ #sqlalchemy
11:20 btami
11:23 gthb
11:30 gthb #sqlalchemy
11:32 ignas
11:32 gthb
11:40 saju_m
  saju_m #sqlalchemy
11:44 orutherfurd
11:55 gthb #sqlalchemy
12:03 orutherfurd #sqlalchemy
12:05 marianom #sqlalchemy
12:19 saju_m
12:30 ignas #sqlalchemy
12:35 Shyde #sqlalchemy
12:36 Shyde
12:41 ignas having a funny problem...
    if I execute query using python Mysql directly
    hmm, a sec, something's not ok ;)
12:44 THC4k #sqlalchemy
12:52 ignas is there a way to pass some parameters to the MySQLdb.connect call from sqlalchemy side?
13:02 btami #sqlalchemy
13:12 nosklo #sqlalchemy
13:15 asabil
13:16 orutherfurd
13:28 maxpn #sqlalchemy
13:44 maxpn
13:51 d0ugal
14:03 agronholm you mean like ?charset=utf8&use_unicode=0 in the connect url?
14:07 ignas nope, I mean like connection_args = {'conv': {my_converters}}
    found that out
    now another question
    I use session.query(MyObject).filter_by().one() to get an object
    then I do db.connection.execute() that updates it's properties
14:08 ignas how do I tell sqlalchemy that objects are dirty and should be refreshed?
    session.flush() is not doing that
14:08 THC4k
14:10 d0ugal #sqlalchemy
14:11 d0ugal
14:11 ignas session.expire_all() seems to be doing what I want, is it the right thing to do?
14:14 mattmtl #sqlalchemy
14:21 btami
14:22 psino
14:22 squigle #sqlalchemy
14:37 psino #sqlalchemy
14:49 orutherfurd #sqlalchemy
14:57 drakkan1000
15:02 mage__ #sqlalchemy
15:04 Maurits_ #sqlalchemy
15:05 mage_
15:05 agronholm
15:07 agronholm #sqlalchemy
15:10 explodes #sqlalchemy
15:21 keithgcascio #sqlalchemy
15:26 Thorn #sqlalchemy
15:33 marianom
15:36 ignas
15:40 marianom #sqlalchemy
15:46 squigle
15:47 jdg #sqlalchemy
15:47 laggo #sqlalchemy
15:47 drakkan1000 #sqlalchemy
15:47 laggo how do i select the result of a function and then order by the label given to the result?
15:48 laggo like SELECT myfunc() AS anon_1 FROM mytable ORDER BY anon_1
15:48 hacked
15:49 yekinabud #sqlalchemy
15:50 Ramonster
15:50 vinces_ #sqlalchemy
15:51 vinces_ #sqlalchemy
15:52 hacked #sqlalchemy
15:54 hacked
16:00 jeffszusz_ #sqlalchemy
16:00 jeffszusz
  jeffszusz #sqlalchemy
16:01 jeffszusz_
16:01 vinces_ #sqlalchemy
16:04 cwillu_at_work #sqlalchemy
16:09 jdg
16:18 jdg #sqlalchemy
16:19 harobed
16:22 vinces_ #sqlalchemy
16:23 vinces_ #sqlalchemy
16:23 hacked #sqlalchemy
16:26 agronholm I haven't been able to do that in either sqlalchemy or hibernate
    I mean
    you basically CAN do it
16:27 agronholm but it seems to translate to ORDER BY myfunc() or something iirc
16:28 d0ugal #sqlalchemy
16:28 agronholm laggo: create a statement myfunc() and a label from that
16:29 agronholm and use the label object in the select and order_by
    no wait, not in the select
16:30 agronholm never done it that way so can't be sure
16:35 jdg
16:37 jdg #sqlalchemy
16:38 laggo i tried
    im not sure how to use the labels, ended up with some weird errors
16:40 d0ugal
16:41 THC4k #sqlalchemy
16:43 aberrant #sqlalchemy
16:55 jdg
16:59 jdg #sqlalchemy
17:05 YGingras
17:07 nosklo
17:12 jdg
17:14 dialtone #sqlalchemy
  dialtone #sqlalchemy
17:20 pipoun
17:26 blaflamme #sqlalchemy
17:28 psino
17:31 lelit laggo: maybe "select ... group by 1" ?
17:33 ltbarcly
  ltbarcly #sqlalchemy
17:35 gronky #sqlalchemy
17:38 agronholm what would adding grouping help
17:39 drakkan1000
17:40 lelit little :) but it will do the sort :)
    I actually meant order by 1, which does not exist iirc
17:41 eyeris #sqlalchemy
17:42 gronky
17:43 lelit oh, postgres recognize "order by 1", btw
17:46 lelit
17:47 eyeris Could someone look at this paste and tell me what I'm missing that's causing my subquery to fail? http://paste.pocoo.org/show/258160/
17:49 eyeris One more difference between my code and the example code is that one side of their join is a mapped user class while I use a Table on each side
17:51 _diana_1 #sqlalchemy
17:52 YGingras #sqlalchemy
17:54 nosklo #sqlalchemy
  nosklo #sqlalchemy
17:55 gronky #sqlalchemy
17:57 YGingras
17:58 _diana_ #sqlalchemy
18:00 _diana_1
18:04 YGingras #sqlalchemy
18:07 ltbarcly1 #sqlalchemy
18:08 _diana_1 #sqlalchemy
18:09 YGingras
18:09 ltbarcly
18:11 _diana_
18:12 afd_
18:13 DanielHolth #sqlalchemy
18:22 YGingras #sqlalchemy
18:38 jeffszusz
18:41 eyeris So apparently when you do a join, one side must be a mapped user class.
18:47 tux21b
18:50 tux21b #sqlalchemy
19:08 gronky
19:23 YGingras
19:26 gronky #sqlalchemy
19:26 eyeris
19:39 btami #sqlalchemy
19:50 gronky
19:54 atomekk
19:54 YGingras #sqlalchemy
19:56 grdnerd eyeris: well if your using the orm, then yes, but not for the sql layer
    woops just noticed that was from an hour ago
20:06 gronky #sqlalchemy
20:15 yekinabud
20:16 btami
20:25 nosklo
20:29 YGingras
20:37 bag_ #sqlalchemy
20:56 martinknyc #sqlalchemy
21:01 aberrant
21:15 DanielHolth
21:17 percious #sqlalchemy
21:27 martinknyc
21:56 gronky
22:06 bag_
22:07 tux21b
22:08 tux21b #sqlalchemy
  tux21b
22:47 marianom
22:51 blaflamme
23:00 alekibango
23:06 jhauser
23:18 squigle #sqlalchemy
23:21 percious
23:25 explodes
23:33 psino #sqlalchemy
23:35 ToadP #sqlalchemy
23:40 alekibango #sqlalchemy
23:48 squigle
23:50 squigle #sqlalchemy
00:00 percious #sqlalchemy
00:28 keithgcascio
00:34 laggo
01:08 jonanin #sqlalchemy
01:08 jonanin is it posisble to add a a 'hook' to session.commit() to provide some additional functionality?
01:22 psino