[14:39:58] <average>	 hey guys
[14:40:30] <average>	 milimetric: wanna ask you something about create_cohort
[14:45:36] <average>	 milimetric: so in create_cohort we get the valid users and we're inserting them in the db. there's no check if they're already in the wiki_user table already or not
[14:46:09] <average>	 I suppose sqlalchemy just takes care of that cornercase
[14:50:40] <average>	 I'm making a test on my machine
[15:00:02] <average>	 ok, so I can add multiple WikiUsers with the same project, mediawiki_userid, mediawiki_username
[15:00:16] <average>	 I think this means we should add some unique constraint to the model
[15:00:23] <average>	 not sure thought
[15:00:56] <average>	 *though
[15:01:43] <ottomata>	 morning average!  I can't help you, just saying hi!
[15:02:31] <drdee>	 morning
[15:02:42] <average>	 hi qchris
[15:02:46] <average>	 morning drdee :)
[15:02:52] <qchris>	 Hi!
[15:10:02] <milimetric>	 hey average, sorry missed your ping too
[15:11:06] <milimetric>	 well, so Evan thought that we should just have duplicate WikiUser records with the same mediawiki_userid
[15:11:11] <milimetric>	 we talked about it for a while
[15:11:43] <milimetric>	 create_test_cohort kind of assumes you have a blank database though
[15:11:53] <milimetric>	 because it's usually run after setUp which deletes everything
[15:13:27] <milimetric>	 does that answer your question average ^?
[15:14:51] <average>	 ok, so no duplicate WikiUsers with the same mediawiki_userid
[15:15:05] <average>	 I just looked at wikiuser.py , didn't see any constraint for that
[15:16:59] <average>	 oh, I misread
[15:17:14] <average>	 so we should have duplicate WikiUsers for the same mediawiki_userid
[15:18:47] <average>	 isn't mediawiki_userid supposed to be unique ? because in the mediawiki schema user.user_id is a primary key http://bit.ly/1cBVMry
[15:20:38] <milimetric>	 right, user_id is unique
[15:20:51] <milimetric>	 but mediawiki_userid does not *need* to be unique
[15:21:08] <milimetric>	 currently it makes no sense for it to not be unique
[15:56:27] <milimetric>	 average: 51k wiki_user records
[15:56:36] <milimetric>	 not a big deal at all.  I'll be worried when it's over 10 million
[16:58:47] <qchris>	 I am only added with to the "process discussion event" for an email address that I cannot log in with at google.
[16:59:03] <qchris>	 Could someone please add my wm address, or my gmail address?
[17:00:45] <qchris>	 milimetric: ^
[17:00:52] <milimetric>	 adding
[17:00:55] <qchris>	 Thanks!
[17:01:36] <milimetric>	 ok, added you christian
[17:02:06] <qchris>	 Thanks.
[17:02:21] <qchris>	 Not seeing it though ... Give google another minute.
[17:05:05] <tnegrin>	 here's the hangout https://plus.google.com/hangouts/_/calendar/dG5lZ3JpbkB3aWtpbWVkaWEub3Jn.luu5l04480ff6um2hv59c2hklk
[17:05:20] <qchris>	 I get "You're not allowed to join this video call."
[17:05:32] <qchris>	 :-(
[17:06:10] <tnegrin>	 we can do bat cave if that works
[17:06:10] <tnegrin>	 we're in the batcave
[17:06:16] <qchris>	 Ok.
[17:11:17] <diegolo_>	 hi, do you know where can I find the number of categories on the wikipedia en?
[18:57:32] <milimetric>	 diegolo: you could get the count from the category table
[18:57:33] <milimetric>	 http://upload.wikimedia.org/wikipedia/commons/thumb/4/42/MediaWiki_1.20_%2844edaa2%29_database_schema.svg/2193px-MediaWiki_1.20_%2844edaa2%29_database_schema.svg.png
[18:57:40] <milimetric>	 select count(*) from category;
[18:58:03] <milimetric>	 one easy place to access that is in labsdb
[18:58:20] <milimetric>	 https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Help
[19:20:52] <ottomata>	 ergghghhh, milimetric, still wanna brain bounce with me?
[19:21:02] <milimetric>	 yea
[19:21:03] <milimetric>	 let
[19:21:05] <milimetric>	 's do it
[20:35:59] <ottomata>	 YESSS
[20:35:59] <ottomata>	 http://ganglia.wikimedia.org/latest/?c=Analytics%20cluster%20eqiad&h=analytics1003.wikimedia.org&m=cpu_report&r=hour&s=descending&hc=4&mc=2
[20:36:03] <ottomata>	 thank you milimetric!