[06:46:20] <grrrit-wm>	 (PS1) Rfaulk: mv - aggregator constants to aggregator module. [analytics/user-metrics] - https://gerrit.wikimedia.org/r/80530
[06:46:21] <grrrit-wm>	 (PS1) Rfaulk: mod - change refs to aggregator constants in metrics. [analytics/user-metrics] - https://gerrit.wikimedia.org/r/80531
[06:46:38] <grrrit-wm>	 (CR) Rfaulk: [C: 2 V: 2] mv - aggregator constants to aggregator module. [analytics/user-metrics] - https://gerrit.wikimedia.org/r/80530 (owner: Rfaulk)
[06:46:53] <grrrit-wm>	 (CR) Rfaulk: [C: 2 V: 2] mod - change refs to aggregator constants in metrics. [analytics/user-metrics] - https://gerrit.wikimedia.org/r/80531 (owner: Rfaulk)
[08:01:43] <grrrit-wm>	 (PS1) Rfaulk: fix - refs to aggregator constants. [analytics/user-metrics] - https://gerrit.wikimedia.org/r/80535
[08:02:02] <grrrit-wm>	 (CR) Rfaulk: [C: 2 V: 2] fix - refs to aggregator constants. [analytics/user-metrics] - https://gerrit.wikimedia.org/r/80535 (owner: Rfaulk)
[11:59:56] <milimetric>	 morning everyone, I'll be gone for a couple hours from 9:00 EST to 11:00 EST
[12:00:10] <milimetric>	 just working at my local co-op's farm
[12:01:14] <qchris>	 Sounds great. Have fun :-)
[13:00:36] <grrrit-wm>	 (PS1) JGonera: Story 1071: Add edit errors on daily edit graphs [analytics/limn-mobile-data] - https://gerrit.wikimedia.org/r/80553
[13:38:20] <drdee>	 BAM
[13:40:47] <ottomata>	 bam bam bam
[13:46:40] <drdee>	 yo ottomata
[13:46:42] <drdee>	 yo qchris
[13:48:48] <ottomata>	 yoyo
[13:52:18] <drdee>	 no sleep till brooklyn
[13:53:18] <drdee>	 Foot on the pedal - never ever false metal
[13:53:19] <drdee>	 Engine running hotter than a boiling kettle
[13:53:20] <drdee>	 My job's ain't a job - it's a damn good time
[14:17:24] <drdee>	 yo average
[14:39:25] <average>	 hey drdee
[14:39:26] <average>	 hey milimetric_
[14:39:41] <average>	 do I use ipython to compose the sqlalchemy query ? is it easier ?
[14:41:28] <drdee>	 ipython is an interactive interpreter of python
[14:41:36] <drdee>	 so you can see what your code is doing
[14:41:47] <drdee>	 but it has it's own learning curve
[14:41:53] <drdee>	 i guess it depends on preference
[14:51:02] <average>	 ok so what I did was
[14:51:07] <average>	 I fired up an ipython
[14:51:11] <average>	 and I wrote two things
[14:51:15] <average>	 one to get a db session
[14:51:18] <average>	 and the other one a simple query
[14:51:31] <average>	 from wikimetrics.configurables import db
[14:51:39] <average>	 db_session = db.get_session()
[14:51:46] <average>	 now I should have a db_session
[14:52:15] <average>	 now I import the Revision model
[14:52:16] <average>	 from wikimetrics.models import Page
[14:52:21] <average>	 from wikimetrics.models import Revision
[14:52:44] <average>	 and now a simple query
[14:52:45] <average>	 db_session.query(Page.page_id).all()
[14:52:48] <average>	 and I get an error
[14:52:59] <average>	 OperationalError: (OperationalError) no such table: page u'SELECT page.page_id AS page_page_id \nFROM page' ()
[14:54:41] <average>	 my aim is to get this working, so I can construct my query in ipython and then put it back in the new metric
[14:55:51] <drdee>	 stay on target average :) the metric is more important than ipython particularly as nobody has experience with ipython  IIRC
[14:56:20] <average>	 ok
[16:14:05] <grrrit-wm>	 (PS1) Milimetric: up to 84 percent coverage now [analytics/wikimetrics] - https://gerrit.wikimedia.org/r/80572
[16:14:14] <grrrit-wm>	 (CR) Milimetric: [C: 2 V: 2] up to 84 percent coverage now [analytics/wikimetrics] - https://gerrit.wikimedia.org/r/80572 (owner: Milimetric)
[16:17:11] <drdee>	 WOOT WOOT
[16:52:10] <ottomata>	 woot they've got a webbpage!
[16:52:10] <ottomata>	 http://samza.incubator.apache.org/
[16:55:38] <drdee>	 awesome
[17:01:19] <drdee>	 ottomata scrum
[17:27:48] <drdee>	 ottomata can you join the hangout
[17:44:06] <grrrit-wm>	 (CR) Jdlrobson: [C: 2] Story 1071: Add edit errors on daily edit graphs [analytics/limn-mobile-data] - https://gerrit.wikimedia.org/r/80553 (owner: JGonera)
[17:50:09] <average>	 milimetric: quick q
[18:04:46] <grrrit-wm>	 (CR) JGonera: [C: 2] Story 1071: Add edit errors on daily edit graphs [analytics/limn-mobile-data] - https://gerrit.wikimedia.org/r/80553 (owner: JGonera)
[18:04:51] <grrrit-wm>	 (CR) JGonera: [V: 2] Story 1071: Add edit errors on daily edit graphs [analytics/limn-mobile-data] - https://gerrit.wikimedia.org/r/80553 (owner: JGonera)
[19:55:18] <average>	 ottomata: hey, I tried to go into wikimetrics.pmtpa.wmflabs
[19:55:20] <average>	 ottomata: I wasn't able to
[19:55:36] <average>	 ottomata: can I get some help on that pls
[19:55:38] <ottomata>	 sure
[19:55:39] <ottomata>	 hm
[19:55:44] <ottomata>	 how far did you get?
[19:55:52] <ottomata>	 are you having trouble logging into other labs instances?
[19:56:22] <average>	 https://gist.github.com/wsdookadr/fddf667f06d3bf2332cd
[19:57:31] <average>	 ottomata: ^^
[19:57:42] <average>	 I can access stat1002.eqiad.wmnet
[19:57:43] <average>	 stat1
[19:57:53] <ottomata>	 this is your problem
[19:57:54] <ottomata>	  exec ssh -e none spetrea@analytics1001.wikimedia.org
[19:57:59] <ottomata>	 you can't use analytics1001 as labs proxy
[19:58:28] <ottomata>	 https://wikitech.wikimedia.org/wiki/Help:Access#Using_ProxyCommand_ssh_option
[20:01:01] <average>	 fixed
[20:01:03] <average>	 just got in it
[20:01:14] <average>	 ottomata: thanks for pointing that out, I used it to fix my .ssh/config
[20:03:27] <ottomata>	 cool!
[20:03:28] <ottomata>	 yup!
[20:03:32] <ottomata>	 glad i could help
[20:03:37] <drdee>	 hey average can you push what you have so far for 704
[20:15:30] <grrrit-wm>	 (PS1) Stefan.petrea: Added metric for card 704 [analytics/wikimetrics] - https://gerrit.wikimedia.org/r/80659
[20:15:34] <average>	 drdee: ^^
[20:15:54] <average>	 milimetric: ^^
[20:16:45] <average>	 not ready for review yet
[20:17:50] <milimetric>	 woo!
[20:18:08] <milimetric>	 cool average, thanks for the patchset
[20:18:21] <drdee>	 thanks average!
[20:18:40] <average>	 np
[20:19:23] <milimetric>	 I'm guessing rev_parent_id has to == 0 and not == None
[20:19:25] <milimetric>	 not sure though
[20:19:41] <milimetric>	 also, remember to run flake8, most of it looks like it'll pass tho
[20:19:51] <average>	 milimetric: I was on #wikimedia-dev and asked for the Mediawiki schema
[20:20:05] <average>	 milimetric: turns out rev_parent_id is INTEGER and can be NULL
[20:20:17] <average>	 milimetric: when it is NULL, Sqlalchemy makes it None in Python
[20:20:46] <average>	 and that happens for the first revision (I have to test that theory on real data though, that's one of the reasons why I'm logged into wikimetrics machine on labs)
[20:21:00] <milimetric>	 yep, true
[20:21:05] <milimetric>	 but i think in this case it's actually set to 0 where it's the first revision (page creation revision)
[20:30:21] <average>	 milimetric: and you're right
[20:31:11] <milimetric>	 cool, it wasn't me, it was ryan whose query code we can usually take as gospel
[20:31:25] <milimetric>	 because it's actually being used without many complaints
[20:31:30] <milimetric>	 but it's always good to double check
[21:36:01] <grrrit-wm>	 (PS1) Milimetric: now 88 percent [analytics/wikimetrics] - https://gerrit.wikimedia.org/r/80674
[21:36:19] <grrrit-wm>	 (CR) Milimetric: [C: 2 V: 2] now 88 percent [analytics/wikimetrics] - https://gerrit.wikimedia.org/r/80674 (owner: Milimetric)
[21:38:34] <milimetric>	 hey ottomata, see the airbnb email?
[21:38:45] <milimetric>	 drdee, if you and ottomata are good for it, let's book it!
[21:39:07] <milimetric>	 it's a great place, so I vote Yes
[21:39:15] <ottomata>	 yeah, cool!
[21:39:19] <ottomata>	 ok checking that now
[21:41:11] <ottomata>	 drdee, milimetric:  what are your dates?
[21:41:23] <milimetric>	 8-14
[21:41:35] <milimetric>	 you?
[21:41:39] <ottomata>	 10-19
[21:41:41] <milimetric>	 ah
[21:41:47] <ottomata>	 this might get complicated
[21:41:52] <ottomata>	 dunno
[21:41:55] <milimetric>	 you'll end up footing the bill for 5 days
[21:42:12] <milimetric>	 hotel?
[21:42:13] <milimetric>	 :)
[21:42:19] <ottomata>	 hmm, yeah, maybe I should just book that for the all staff week
[21:42:21] <milimetric>	 I'm sad because that place is awesome
[21:42:28] <ottomata>	 and move to hotel for ops week afterwards?
[21:42:33] <milimetric>	 yeah, sure!
[21:42:34] <milimetric>	 that'd be great
[21:42:39] <ottomata>	 drdee!
[21:42:40] <ottomata>	 dates?
[21:42:49] <milimetric>	 I think he's also 8-14
[21:42:53] <milimetric>	 oh no
[21:42:55] <milimetric>	 he's 9-14
[21:43:14] <ottomata>	 basically same though
[21:43:18] <milimetric>	 yea
[21:43:34] <milimetric>	 checkin 8, checkout 14
[21:43:42] <milimetric>	 and we'll figure budgets out with Ken/Toby
[21:43:58] <ottomata>	 awww it sbeen booked!
[21:45:24] <milimetric>	 :)
[21:45:40] <milimetric>	 well if you find anything else that looks awesome for 3 people, you can totally book it
[21:45:48] <milimetric>	 without checking with me, i'm sure it'll be good
[21:46:00] <milimetric>	 (Indonesian Restaurant style)
[21:46:08] <ottomata>	 haha, awesome
[21:46:09] <ottomata>	 hah
[21:46:18] <ottomata>	 well, we'll see, that one was the one that was close and good for 3
[21:46:24] <ottomata>	 there are others, but  nothign as good
[21:46:32] <milimetric>	 and if not, by Monday or so we'll just tell Doreen let's go with the hotels
[21:46:32] <ottomata>	 maybe we should accept this as a sign and just do hotel?
[21:46:48] <milimetric>	 you can reply to doreen on all our behalf, I'm happy either way
[21:46:51] <milimetric>	 hotel - close to everyone
[21:47:00] <milimetric>	 airbnb - potentially fancy :)
[21:47:23] <milimetric>	 portrero has some cool places, we stayed in a nice one last trip out
[21:47:35] <ottomata>	 o yeah i'm only looking at stuff close to office
[21:47:42] <ottomata>	 i'm ok with being farther out, but i have a bike
[22:55:18] <grrrit-wm>	 (PS2) Stefan.petrea: Added metric for card 704 [analytics/wikimetrics] - https://gerrit.wikimedia.org/r/80659
[22:55:22] <average>	 milimetric: wrote one test, it passes
[22:57:17] <average>	 it's basically ready, but needs more testing
[22:57:21] <average>	 I think I got the query right
[22:57:46] <average>	 didn't yet include the edge case where page is deleted and re-created yet
[23:07:02] <milimetric>	 awesome average, you can submit the patch that way and I'll merge it
[23:07:15] <milimetric>	 then you can improve the test coverage, hopefully to 100% later
[23:07:28] <milimetric>	 but yeah, gj
[23:07:58] <milimetric>	 k, i'm out for the weeekend, later everyone
[23:08:23] <average>	 ok, have a nice weekend