Skip to content

Instantly share code, notes, and snippets.

View pjanik's full-sized avatar

Piotr Janik pjanik

  • Kraków, Poland
View GitHub Profile
@pjanik
pjanik / gist:d07f634454959eb40ebc
Created February 26, 2016 01:27
new student/status
Around 50ms in total:
Started GET "/portal/students/5/status.json" for 127.0.0.1 at 2016-02-25 17:27:03 -0800
Processing by Portal::StudentsController#status as JSON
Parameters: {"id"=>"5"}
User Load (1.3ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 14 AND (`users`.`state` NOT IN ('disabled')) LIMIT 1
Portal::Teacher Load (1.1ms) SELECT `portal_teachers`.* FROM `portal_teachers` WHERE `portal_teachers`.`user_id` = 14 LIMIT 1
Portal::Student Load (1.0ms) SELECT `portal_students`.* FROM `portal_students` WHERE `portal_students`.`user_id` = 14 LIMIT 1
Portal::Student Load (1.0ms) SELECT `portal_students`.* FROM `portal_students` WHERE `portal_students`.`id` = 5 LIMIT 1
Portal::Learner Load (1.1ms) SELECT `portal_learners`.* FROM `portal_learners` WHERE `portal_learners`.`student_id` = 5 ORDER BY student_id ASC
@pjanik
pjanik / gist:f5a6bb2794952e737d96
Created February 26, 2016 01:30
new student/status, more offerings
around 160ms in total:
Started GET "/portal/students/2/status.json" for 127.0.0.1 at 2016-02-25 17:30:23 -0800
Processing by Portal::StudentsController#status as JSON
Parameters: {"id"=>"2"}
User Load (1.2ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 10 AND (`users`.`state` NOT IN ('disabled')) LIMIT 1
Portal::Teacher Load (1.2ms) SELECT `portal_teachers`.* FROM `portal_teachers` WHERE `portal_teachers`.`user_id` = 10 LIMIT 1
Portal::Student Load (1.1ms) SELECT `portal_students`.* FROM `portal_students` WHERE `portal_students`.`user_id` = 10 LIMIT 1
Portal::Student Load (1.1ms) SELECT `portal_students`.* FROM `portal_students` WHERE `portal_students`.`id` = 2 LIMIT 1
Portal::Learner Load (1.0ms) SELECT `portal_learners`.* FROM `portal_learners` WHERE `portal_learners`.`student_id` = 2 ORDER BY student_id ASC
@pjanik
pjanik / gist:8e9adcdba471029b2f1c
Created February 26, 2016 01:34
old student/status, more offerings
around 40ms in total:
Started GET "/portal/students/2/status.json" for 127.0.0.1 at 2016-02-25 17:33:34 -0800
Processing by Portal::StudentsController#status as JSON
Parameters: {"id"=>"2"}
User Load (1.4ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 10 AND (`users`.`state` NOT IN ('disabled')) LIMIT 1
Portal::Teacher Load (1.2ms) SELECT `portal_teachers`.* FROM `portal_teachers` WHERE `portal_teachers`.`user_id` = 10 LIMIT 1
Portal::Student Load (1.2ms) SELECT `portal_students`.* FROM `portal_students` WHERE `portal_students`.`user_id` = 10 LIMIT 1
Portal::Student Load (1.2ms) SELECT `portal_students`.* FROM `portal_students` WHERE `portal_students`.`id` = 2 LIMIT 1
Report::Learner Load (1.3ms) SELECT `report_learners`.* FROM `report_learners` WHERE `report_learners`.`student_id` = 2
@pjanik
pjanik / gist:eabb213b8c9af6017572
Created February 26, 2016 02:29
optimized students/status, more offerings
around 85ms in total:
Started GET "/portal/students/2/status.json" for 127.0.0.1 at 2016-02-25 18:28:24 -0800
Processing by Portal::StudentsController#status as JSON
Parameters: {"id"=>"2"}
User Load (1.2ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 10 AND (`users`.`state` NOT IN ('disabled')) LIMIT 1
Portal::Teacher Load (1.1ms) SELECT `portal_teachers`.* FROM `portal_teachers` WHERE `portal_teachers`.`user_id` = 10 LIMIT 1
Portal::Student Load (1.0ms) SELECT `portal_students`.* FROM `portal_students` WHERE `portal_students`.`user_id` = 10 LIMIT 1
Portal::Student Load (1.2ms) SELECT `portal_students`.* FROM `portal_students` WHERE `portal_students`.`id` = 2 LIMIT 1
Portal::Learner Load (1.2ms) SELECT `portal_learners`.* FROM `portal_learners` WHERE `portal_learners`.`student_id` = 2 ORDER BY student_id ASC
@pjanik
pjanik / report.json
Created March 2, 2016 02:14
GET api/v1/reports/offering?id=:id
{
"class": {
"name": "test",
"students": [{
"id": 13,
"name": "John 1"
}, {
"id": 14,
"name": "John 2"
}, {
@pjanik
pjanik / report.json
Created March 2, 2016 02:15
GET api/v1/reports/offering?id=:id
{
"class": {
"name": "test",
"students": [{
"id": 13,
"name": "John 1"
}, {
"id": 14,
"name": "John 2"
}, {
{
"embeddables_filtering_enabled": false,
"is_offering_external": true,
"class": {
"name": "test",
"students": [{
"id": 13,
"name": "John 1",
"started_offering": true
}, {
<style>
#new-account-form fieldset.ng-scope .group .f-row {
vertical-align: middle
}
#flash {
left: 50%;
margin: 0 0 0 -480px;
position: absolute;
top: 60px;
<canvas width="1480" height="1806"
style="transform-origin: 50% 50% 0px; width: 740px; height: 903px; transform:
translate3d(470px, -4px, 0px); cursor: inherit;"
>
</canvas>
{
"name": null,
"guid": 1,
"components": [
{
"type": "DG.GameView",
"guid": 2,
"componentStorage": {
"currentGameUrl": "https://sage.concord.org/sage.html",
"allowInitGameOverride": true,