Perl 6 - the future is here, just unevenly distributed

IRC log for #webwork, 2012-02-27

| Channels | #webwork index | Today | | Search | Google Search | Plain-Text | summary

All times shown according to UTC.

Time Nick Message
14:12 aubreyja joined #webwork
14:16 aubreyja Hi
14:24 aubreyja joined #webwork
20:00 aubreyja Hi Mike (mgage,mgage_) - around?
20:01 mgage hi
20:02 mgage aubreyja: hi
20:02 aubreyja hi - I'm wondering if anyone has ever tried to change the user id of a student?
20:03 aubreyja I can imagine looping through each table in the course and each row in each table to look for the old id and replace it with the new id, but I'm wondering how dangerous this would be?
20:03 mgage there is no easy way to do this --- This is why in the nextdabase the login will NOT be a primary key
20:04 aubreyja or, I could just find records for the old user, change the id, then put the records for the new user
20:05 mgage yes -- you could do this using direct access to mysql -- it's a little dangerous but if you tested the script well it could be done.
20:06 mgage that is effectively what I have done before (without actually changing the database) -- I knew a student had two logins, one for the first half of the course and one for the second and I just added the scores in the grading spread sheet
20:07 aubreyja that seems less dangerous - (slowly building the new user out of the old user) - ok, if you're around I might bounce this script off of you- two students in one weekend had their user id's changed to staff user ids because they got work study jobs...
20:07 mgage it hasn't come up often which is why there hasn't been more urgency about the database.  My mantra for the next database is that every row has a unique id (say the integer of when it was created) and a time stamp --- whether I can think of any use for the time stamp or not.  and the uniqueID cannot have any other meaning other than identifying the row
20:09 mgage well a tested script like that might be useful until we get the right database.  For two students you could probably handle it just by combine the four logins into two at the appropriate grading time
20:10 mgage headed for class -- back around 4:50 EST
20:10 aubreyja yeah, but the stat prof wants them to be able to have access to their old sets/past answers, etc. I've made this harder by forcing logins to go through LDAP and I could just disable that and the student could have two logins, but then what would I do all afternoon? :)

| Channels | #webwork index | Today | | Search | Google Search | Plain-Text | summary