~azzar1/unity/add-show-desktop-key : changes

~azzar1/unity/add-show-desktop-key » Changes from revision 1840

From Revision 710 to 691

Rev	Summary	Authors	Date
710	Tutorial: The tutorial system now presents a table of conten... Tutorial: The tutorial system now presents a table of contents at the top. (This is supposed to be a side bar, but the CSS stylings was too gnarly for me tonight!) The TOC presents all h1,h2,h3 and exercise nodes in a list. The exercises are presented with their green/grey balls to indicate completion. The tutorial JavaScript automatically updates the balls in the table-of-contents to green if they pass, dynamically.	mattgiuca	16 years ago
709	Added "tiny" versions of tutorial complete/incomplete balls ... Added "tiny" versions of tutorial complete/incomplete balls for side panel use.	mattgiuca	16 years ago
708	tutorial: Proper escaping of exercise title and pre-placed s... tutorial: Proper escaping of exercise title and pre-placed solutions. console: Reduced pop-up console height from 20em to 15em. Percentage didn't work ...	mattgiuca	16 years ago
707	tutorialservice: "submit" requests now return "completed" an... tutorialservice: "submit" requests now return "completed" and "attempts" fields as well. They query the DB for the completed and attempt stats. tutorial.js: Handling the submit response: Now updates the summary bar, setting the ball to green and "Complete" if successful, and also updating the number of attempts made dynamically.	mattgiuca	16 years ago
706	tutorial: When loading, gets from the DB the number of attem... tutorial: When loading, gets from the DB the number of attempts and whether each problem is complete. This is currently static, it will not update when submissions are made. It is displayed in a new div at the bottom of each exercise box.	mattgiuca	16 years ago
705	tutorial (Python & JS) tutorial (Python & JS) Submit now behaves like Save in that it greys out the button while waiting for a response from the server, and activates it again once a response comes back.	mattgiuca	16 years ago
704	db.py: Added get_problem_status, which returns a boolean, wh... db.py: Added get_problem_status, which returns a boolean, whether or not the problem has been completed, and the number of attempts made up to and including the first success, for a given problem for a given user.	mattgiuca	16 years ago
703	tutorial: (Python + Javascript) tutorial: (Python + Javascript) Added JS function "set_saved_status", which can activate and deactivate the save button. Modifying the text field now creates a Save timer which takes 10 seconds to elapse, then auto-saves the field. The save button is only enabled if the text has been modified since saving.	mattgiuca	16 years ago
702	tutorial: tutorial: Now calls util.open_exercise_file, instead of opening it itself. Calls DB.get_problem_stored_text to get the last text the user had saved or submitted. This means that reloading the page will now recover your stored text.	mattgiuca	16 years ago
701	Moved "open_exercise_file" from tutorialservice to util. Moved "open_exercise_file" from tutorialservice to util. Will be used by tutorial app as well.	mattgiuca	16 years ago
700	db.py: Now allows unicode strings to be inserted. db.py: Now allows unicode strings to be inserted.	mattgiuca	16 years ago
699	db.py: Replaced method "get_problem_attempt_last_text" with db.py: Replaced method "get_problem_attempt_last_text" with "get_problem_stored_text". This method now finds the last text to have been either saved OR submitted, using one mega query :) Now this represents the last thing the user "saved", where submitting also counts as saving even though it isn't written to the problem_save table.	mattgiuca	16 years ago
698	Added Save feature to tutorial system. Added Save feature to tutorial system. tutorialservice: Added "save" action, which works the same as submit, but saves to the DB instead of making an attempt, and doesn't run the code. Factored out code to open an exercise file. tutorial: Added Save button to exercise boxen. tutorial.js: Added saveexercise function, which makes an Ajax request to the "save" action of tutorialservice.	mattgiuca	16 years ago
697	users.sql: Added database table problem_save, for storing ex... users.sql: Added database table problem_save, for storing exercises that are saved, but not submitted. db: Added method write_problem_save, which writes to problem_save table.	mattgiuca	16 years ago
696	db: Fixed potential SQL injection (unlikely; you'd need a ma... db: Fixed potential SQL injection (unlikely; you'd need a malicious login name! but still bad). In user_authenticate - escaping the login name string.	mattgiuca	16 years ago
695	db: Added function get_problem_attempt_last_text: returns th... db: Added function get_problem_attempt_last_text: returns the last submitted text. Reordered some arguments. (incl. tutorialservice).	mattgiuca	16 years ago
694	db: insert_problem_attempt now takes an exercisename and log... db: insert_problem_attempt now takes an exercisename and login name instead of DB ID keys. So it is higher level. It internally works out the problem ID and login ID before inserting. tutorialservice: Now calls insert_problem_attempt passing the new arguments (again, tutorialservice does a lot less work now).	mattgiuca	16 years ago
693	db: get_problem_problemid now automatically inserts a new en... db: get_problem_problemid now automatically inserts a new entry if the problem doesn't exist (now it is no longer referentially transparent, but it is idempotent). Removed insert_problem - you can just call get_problem_problemid to do this. tutorialservice: No longer tries to insert a new entry if problem doesnt exist, just expects db to do this. No longer calls insert_problem (removed).	mattgiuca	16 years ago
692	db.py: Added new methods for handling problems and problem a... db.py: Added new methods for handling problems and problem attempts: get_user_loginid get_problem_problemid insert_problem insert_problem_attempt These all do things that were previously hard-coded into tutorialservice. tutorialservice: Call the above methods instead of directly inserting them into the DB. This makes the tutorialservice code much cleaner by having all the DB code in the db module.	mattgiuca	16 years ago
691	python-console: Removed "locls" dictionary when calling exec... python-console: Removed "locls" dictionary when calling exec. This was causing variables to be written to locals instead of globals, and thus they would not be available to other functions. (So as a result of this, functions can see globals and call each other, including recursion).	mattgiuca	16 years ago