[02:24:23]  benjaminv (~benjamin@162.202.200-77.rev.gaoland.net) joined #markus.
 [02:24:40]  benjaminv (~benjamin@162.202.200-77.rev.gaoland.net) left irc: Remote host closed the connection
 [08:52:41]  jerboaa (~jerboaa@CPE0013f7f849da-CM0013f7f849d6.cpe.net.cable.rogers.com) joined #markus.
 [08:52:51]  #markus: mode change '+o jerboaa' by MarkUsBot!~MarkUsBot@li136-145.members.linode.com
 [10:47:50]  divarvel (~divarvel@90.84.146.189) joined #markus.
 [10:47:55] <divarvel>  hi
 [10:48:24] <divarvel>  I'm having some trouble to make active record use joins in a query
 [10:49:38] <jerboaa>  divarvel, you aren't trying to use sql in your conditions, are you?
 [10:50:01] <divarvel>  nope
 [10:50:08] <divarvel>  I use find
 [10:50:11] <divarvel>  with :include
 [10:50:18] <jerboaa>  divarvel, joins are mostly transparent - for most of MarkUs' code
 [10:50:21] <divarvel>  but it generates 2 requests
 [10:50:24] <jerboaa>  divarvel, ok - what's the problem
 [10:50:54] <divarvel>  instead on one with a join
 [10:50:56] <jerboaa>  divarvel, aah, I see - it's really an eager loading question? correct?
 [10:50:59] <divarvel>  s/on/of
 [10:51:09] <jerboaa>  divarvel, ok
 [10:51:09] <divarvel>  exactly
 [10:51:41] <jerboaa>  divarvel, so what do you want to find?
 [10:51:44] <divarvel>  # Retrieve annotations
 [10:51:45] <divarvel>  124 @submission_file = SubmissionFile.find(params[:submission_file_id],
 [10:51:47] <divarvel>  125 :include => [:annotations])
 [10:52:19] <divarvel>  I want to retrieve the annotations associated to a submission file
 [10:52:30] <divarvel>  It generates 2 queries
 [10:52:42] <jerboaa>  what does the submission_file model say in terms of annotations?
 [10:53:11] <jerboaa>  I mean - how do the associations look like?
 [10:53:59] <divarvel>  in the SubmissionFile model
 [10:54:32] <divarvel>  has_many :annotations
 [10:54:32] <divarvel>  in the Annotation model
 [10:54:32] <divarvel>  belongs_to :submission_file
 [10:55:26] <divarvel>  the generated queries :
 [10:55:27] <divarvel>  SubmissionFile Load (0.4ms) SELECT * FROM "submission_files" WHERE ("submission_files"."id" = 2)
 [10:57:19] <divarvel>  Annotation Load (0.6ms) SELECT "annotations".* FROM "annotations" WHERE ("annotations".submission_file_id = 2)
 [11:02:57]  divarvel (~divarvel@90.84.146.189) left irc: Ping timeout: 265 seconds
 [11:06:21]  divarvel (~divarvel@90.84.146.189) joined #markus.
 [11:06:26] <jerboaa>  hmm - I think you have to use something like SubmissionFile.find(:all, :conditions => ['annotation_id =?', params[:submission_file_id]], :include => [:annotations])
 [11:06:34] <jerboaa>  divarvel, --^
 [11:07:06] <jerboaa>  s/annotation_id/submission_file_id/
 [11:07:13] <jerboaa>  or some such
 [11:07:22] <jerboaa>  http://api.rubyonrails.org/classes/ActiveRecord/Associations/ClassMethods.html
 [11:07:57] <jerboaa>  look for "Eager loading of associations" section
 [11:10:27]  AndChat| (~divarvel@80.10.46.72) joined #markus.
 [11:10:58]  divarvel (~divarvel@90.84.146.189) left irc: Ping timeout: 245 seconds
 [11:11:19]  divarvel (~divarvel@80.10.46.84) joined #markus.
 [11:11:29] <divarvel>  Sorry
 [11:11:41] <divarvel>  Connection problems
 [11:11:57] <NelleV>  AndChat|: xD
 [11:12:16] <jerboaa>  not sure if you got my response divarvel
 [11:12:34] <divarvel>  Yup. I'm on my cellphone
 [11:12:54] <divarvel>  I didn't get it
 [11:12:59] <NelleV>  it's hadopi reacting to you downloading illegally and blaming your neighbours for it :p
 [11:13:22] <jerboaa>  hmm - I think you have to use something like SubmissionFile.find(:all, :conditions => ['annotation_id =?', params[:submission_file_id]], :include => [:annotations])
 [11:13:27] <jerboaa>  s/annotation_id/submission_file_id/
 [11:13:32] <jerboaa>  divarvel, --^
 [11:13:37] <jerboaa>  http://api.rubyonrails.org/classes/ActiveRecord/Associations/ClassMethods.html
 [11:13:54] <divarvel>  ok
 [11:14:26] <divarvel>  I'm not familiar with activerecord
 [11:14:51]  AndChat| (~divarvel@80.10.46.72) left irc: Ping timeout: 250 seconds
 [11:15:14] <divarvel>  I've read this page
 [11:16:06] <divarvel>  But your query filters on annotation_id
 [11:16:35] <jerboaa>  divarvel, on second thought - you might need to do it the other way round:
 [11:16:46] <divarvel>  Select anrotaions
 [11:17:26] <divarvel>  and join submission_file
 [11:17:27] <divarvel>  ?
 [11:17:43] <jerboaa>  Annotations.find(:all, :conditions => ['submission_file_id = ?', id], :include => [:submission_file]
 [11:17:58] <divarvel>  I was thinking of doing that
 [11:18:34] <divarvel>  I'll try when I'm at home
 [11:19:02] <NelleV>  mmh
 [11:19:10] <jerboaa>  divarvel, it depends on what you are trying to do - just doing the query optimization is too less context for me
 [11:19:27] <NelleV>  divarvel: what exactly are you trying to do ?
 [11:19:58] <divarvel>  retrieve the annotations associated to a submission file
 [11:20:00] <NelleV>  Annotation.find_by_submission_file_id(:all, :conditions => [bla bla])
 [11:20:10] <NelleV>  add an s to annotation
 [11:20:37] <divarvel>  It's the first thing I said ;-)
 [11:21:04] <NelleV>  divarvel: what is the first thing you said ? This query ?
 [11:21:51] <divarvel>  What I was trying to do
 [11:22:00] <NelleV>  yep but I was too lazy to scroll up :D
 [11:23:56] <divarvel>  Anyway, see you in 30 minutes
 [11:24:10] <divarvel>  i'm in a trolley
 [11:24:25] <divarvel>  Not easy to chat on irc
 [11:24:42] <NelleV>  Annotation.find_by_submission_file_id(id, :include => blabla)
 [11:24:52] <NelleV>  try that
 [11:25:16] <NelleV>  and use the console to test
 [11:25:39] <divarvel>  I'll need to retrieve other things after that
 [11:26:08] <divarvel>  we're working on a drawing tool
 [11:26:31]  benjaminv (~benjamin@162.202.200-77.rev.gaoland.net) joined #markus.
 [11:26:32]  *** NelleV nods
 [11:26:38] <divarvel>  So an annotation can be a set of lines
 [11:26:51]  *** NelleV will have a look at the patch
 [11:27:16] <divarvel>  a curve es stored as a set EF points
 [11:27:25] <NelleV>  benjaminv: je peux le kicker stp ?
 [11:27:52] <divarvel>  So I'll need to retrieve the points in the same query
 [11:27:57] <divarvel>  Pas besoin
 [11:28:04] <NelleV>  :-(
 [11:28:07] <divarvel>  je me casse
 [11:28:23] <NelleV>  that sounds like what we did on OOo
 [11:28:29] <divarvel>  Trop d'amabilité sur ce chan
 [11:28:46]  divarvel (~divarvel@80.10.46.84) left irc: Quit: Live long and prosper
 [11:28:50] <benjaminv>  il se passe quoi sur ce chan ?
 [11:28:54] <benjaminv>  what ?
 [11:28:56] <NelleV>  je l'ai vexé xD
 [11:29:14]  *** NelleV benjaminv beh en gros t'as tout vu
 [11:29:14] <benjaminv>  NelleV, Can you copy and paste previous conversation ?
 [11:29:19] <NelleV>  ok
 [11:29:27] <benjaminv>  :-)
 [11:29:34] <NelleV>  he was asking about annotation and queries to database
 [11:29:41] <benjaminv>  divarvel and I worked hard on MarkUs today
 [11:29:43] <benjaminv>  yes
 [11:30:47] <NelleV>  http://bpaste.net/show/11315/
 [11:46:20]  divarvel (~divarvel@cam44-2-82-235-243-104.fbx.proxad.net) joined #markus.
 [11:46:33] <divarvel>  I'm back
 [11:52:58]  karenreid (~karenreid@red-gw43.cs.toronto.edu) joined #markus.
 [11:53:23]  #markus: mode change '+o karenreid' by MarkUsBot!~MarkUsBot@li136-145.members.linode.com
 [11:58:49]  m_conley (~m_conley@173-230-185-103.cable.teksavvy.com) joined #markus.
 [11:59:02]  #markus: mode change '+o m_conley' by MarkUsBot!~MarkUsBot@li136-145.members.linode.com
 [12:33:04]  mi_sa (~chatzilla@b2240-01.cdf.toronto.edu) joined #markus.
 [12:53:20]  Hora (~Hora@S01060016b62644df.vc.shawcable.net) joined #markus.
 [12:53:37] <Hora>  hi everyone
 [12:53:43] <m_conley>  hey Hora
 [12:53:44] <benjaminv>  hi Hora
 [12:55:51] <mi_sa>  hi
 [12:57:05] <karenreid>  hi
 [12:57:48] <divarvel>  hi
 [12:58:17]  evanb (~Evan@bas15-toronto63-1177891691.dsl.bell.ca) joined #markus.
 [12:58:36] <karenreid>  Nice big group today! Welcome
 [12:58:59]  kschmidt (~KurtisSch@wi-secure-3921.cc.umanitoba.ca) joined #markus.
 [12:59:11] <evanb>  hi
 [12:59:17] <Hora>  hi!
 [12:59:27] <karenreid>  I think we have everyone now. I haven't heard from Jiahui in a while. (I've sent her email today)
 [12:59:34] <kschmidt>  Hi Everyone
 [12:59:48] <kschmidt>  I have to go before 12:30 (my time) because I'm doing a presentation for my co-op
 [12:59:55] <karenreid>  How is everyone surviving with 3ish weeks to go?
 [13:00:01] <karenreid>  kschmidt: no problem
 [13:00:34]  viv (~viviensue@74.198.87.52) joined #markus.
 [13:00:53] <Hora>  karenreid, it's getting pretty crazy with assignments and projects, but i'm staying alive
 [13:00:59] <karenreid>  (maybe I shouldn't ask questions like that at the beginning of a meeting)
 [13:01:03] <evanb>  I'm surviving :)
 [13:01:12] <viv>  hi everyone~
 [13:01:20] <kschmidt>  Hey Team, sorry I just got a phone call and something came up that I need to go
 [13:01:28] <kschmidt>  I'll try to do a blog post to update on what I've been working on
 [13:01:28] <karenreid>  Hi viv, we are just getting started
 [13:01:40] <karenreid>  kschmidt: sounds good, keep us posted.
 [13:01:45] <kschmidt>  Ok Bye
 [13:01:48]  kschmidt (~KurtisSch@wi-secure-3921.cc.umanitoba.ca) left irc: Quit: kschmidt
 [13:02:07] <karenreid>  Hora do you want to start?
 [13:02:11] <Hora>  sure
 [13:02:33] <Hora>  so this week was a little bit slow, i've been working on some final projects
 [13:02:40] <Hora>  but i figured out how to do the caching
 [13:02:56] <Hora>  i had to learn about migrations in rails
 [13:03:24] <Hora>  i wrote a blog post mostly for documentation purposes, but also to hear what other had to say
 [13:03:32] <Hora>  karenreid, thanks for the reply to it
 [13:03:43] <karenreid>  sounds good, have you made any changes to what you are thinking about the caching
 [13:03:44] <karenreid>  ?
 [13:04:05] <Hora>  changes?
 [13:04:11] <Hora>  i thought you agreed with my approach
 [13:04:19] <Hora>  or maybe i don't understand the question :P
 [13:04:25] <karenreid>  I do, just wondering if anything has come up since
 [13:04:44] <Hora>  oh, no everything is going well
 [13:04:49] <karenreid>  Great!
 [13:05:15] <Hora>  yep, so i should have the first review for caching up very soon
 [13:05:22] <karenreid>  even better :-)
 [13:05:34] <Hora>  other than that, i've been trying to do some more reviews and i've been playing with testdrive
 [13:05:45] <m_conley>  Hora helped me find a bug in TestDrive, which was awesome
 [13:05:59] <karenreid>  nice
 [13:06:12] <Hora>  yep, so now i'm just waiting for the next update :)
 [13:06:14] <m_conley>  Hora: it's good to have you in on the reviews. Much appreciated. :)
 [13:06:19] <Hora>  no problem
 [13:06:21] <m_conley>  Hora: this weekend, hopefully.
 [13:06:29] <Hora>  ok cool! can't wait to try it out
 [13:06:35] <karenreid>  Yes, it's nice to see!
 [13:06:48] <Hora>  also, i was browsing the issues and i found one that i claimed back at the sprint
 [13:06:57] <Hora>  i completely forgot i did... so i started working on that too
 [13:07:01] <Hora>  that's issue 106
 [13:07:06] <Hora>  also i meant to ask
 [13:07:25] <Hora>  github sorts them by 'priority', but i don't think we figured out a way to actually rank them, did we?
 [13:08:01] <karenreid>  I've been trying to move ones to the top that I care about, but I haven't checked in while.
 [13:08:10] <Hora>  ah, ok
 [13:08:15] <m_conley>  There is the ability to "vote" on issues
 [13:08:21] <Hora>  so they're somewhat ranked then..
 [13:08:26] <m_conley>  but no, priority hasn't been addressed
 [13:08:27] <karenreid>  That helps too.
 [13:08:59] <Hora>  since the semester is getting closer to the end, maybe you could tell us which issues you'd like to see closed before we finish?
 [13:09:15] <karenreid>  I wonder if we should add an urgent/important tag
 [13:09:29] <Hora>  that might get more of them resolved
 [13:09:31] <karenreid>  Yes, I'll put together a list of the ones that are highest priority.
 [13:09:38] <Hora>  ok
 [13:09:49] <Hora>  i think that's it for me this wekk
 [13:09:55] <karenreid>  great!
 [13:10:04] <karenreid>  evanb: nearing completion on the token management?
 [13:10:09] <evanb>  yes I am
 [13:10:14] <karenreid>  :-)
 [13:10:27] <evanb>  It actually is complete although it is not on reviewboard yet
 [13:11:00] <evanb>  currently it gives the ability to have tokens refresh hourly, daily or not at all... is there any other options I should add to that?
 [13:11:24] <karenreid>  I think that is a good start. I think we should wait to see what users want before adding others.
 [13:11:36] <evanb>  alright
 [13:11:39] <benjaminv>  evanb, karenreid I am writing a tuto to use the test framework
 [13:11:54] <evanb>  benjaminv, great!
 [13:12:16] <evanb>  I was thinking that after I get the current token stuff committed I should work on the examples and the ANT side of things for the last few weeks
 [13:12:21] <evanb>  and of course any major bugs that come up