Yogesh Kumar kyogesh
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| workbooks=# select count(term_id) from student_course_term where student_id='213210964' group by term_id; | |
| count | |
| ------- | |
| 1 | |
| 1 | |
| 2 | |
| 2 | |
| 2 | |
| 1 | |
| 2 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| File "test_analytics.py", line 133, in test_total_terms_registered | |
| self.assertEqual(self._get('total_terms_registered', '213210964'), 10) | |
| AssertionError: 12L != 10 | |
| ---------------------------------------------------------------------- | |
| Ran 30 tests in 204.711s | |
| FAILED (failures=1) |
kyogesh
/ gist:1b277449317a96bfc9d9
Created
July 22, 2015 09:35
total terms registered excluding summer
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| workbooks=# select distinct(term_id) from student_course_term where student_id='334244614'; | |
| term_id | |
| --------- | |
| 199905 | |
| 199901 | |
| 200005 | |
| 200008 | |
| 199908 | |
| 199808 | |
| 200001 |
kyogesh
/ gist:3ad9cf5f0e3003dc39f4
Created
July 22, 2015 09:42
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| select distinct(standard_term.term_id) from student_course_term, standard_term where student_id='334244614' and standard_term.term_id=student_course_term.term_id and not period_type='Summer'; | |
| term_id | |
| --------- | |
| 199808 | |
| 199901 | |
| 199908 | |
| 200001 | |
| 200008 | |
| (5 rows) |
kyogesh
/ gist:fcb88c72f88d19ca0a39
Created
July 22, 2015 09:47
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| workbooks=# select distinct(standard_term.term_id) from student_major_term, standard_term where student_id='334244614' and standard_term.term_id=student_major_term.term_id and not period_type='Summer'; | |
| term_id | |
| --------- | |
| 199808 | |
| 199901 | |
| 199908 | |
| 200001 | |
| 200008 | |
| 200401 | |
| 200901 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| workbooks=# select yr1_cumulative_gpa from historical_analytics_finaltable ; | |
| yr1_cumulative_gpa | |
| -------------------- | |
| BU | |
| AS | |
| HS | |
| BU | |
| AS | |
| BU | |
| BU |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| student_id | term_id | | |
| ------------+---------+ | |
| 481105362 | 199803 | | |
| 481105362 | 199808 | | |
| 481105362 | 199905 | | |
| 481105362 | 199908 | | |
| 481105362 | 200005 | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| student_id | term_id | | |
| ------------+---------+ | |
| 481105362 | 199803 | | |
| 481105362 | 199808 | | |
| 481105362 | 199905 | | |
| 481105362 | 199908 | | |
| 481105362 | 200005 | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Traceback (most recent call last): | |
| File "/Users/yogeshkumar/.virtualenvs/pySparta/lib/python2.7/site-packages/rq/worker.py", line 558, in perform_job | |
| rv = job.perform() | |
| File "/Users/yogeshkumar/.virtualenvs/pySparta/lib/python2.7/site-packages/rq/job.py", line 495, in perform | |
| self._result = self.func(*self.args, **self.kwargs) | |
| File "/Users/yogeshkumar/.virtualenvs/pySparta/lib/python2.7/site-packages/rq/job.py", line 206, in func | |
| return import_attribute(self.func_name) | |
| File "/Users/yogeshkumar/.virtualenvs/pySparta/lib/python2.7/site-packages/rq/utils.py", line 150, in import_attribute | |
| module = importlib.import_module(module_name) | |
| File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/importlib/__init__.py", line 37, in import_module |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "error": "Error in model.predict function\nError in value[[3L]](cond): [ERROR] Service failed: Error in postgresqlExecStatement(conn, statement, ...): RS-DBI driver: (could not Retrieve the result : ERROR: relation \"pdapi_mv_std_course_term\" does not exist\nLINE 1: SELECT * FROM (SELECT * FROM pdapi_mv_std_course_term) AS \"_...\n ^\n)\n\n\nmodel.predict <- function (params) \n{\n flog.info(\"Executing request: %s, %s\", params$request_type, \n params$institution_id)\n con <- max_con_src_postgres(host = cf$dbhost, user = cf$dbuser, \n password = cf$dbpassword, dbname = cf$dbname)\n dbGetQuery(con$con, sprintf(\"SET search_path TO %s\", params$institution_id))\n tryCatch(switch(params$request_type, grades = serv_grades(params, \n con), credit_buckets = serv_credit_buckets(params, con), \n student_groups = serv_stu_groups(params, con), courses = serv_courses(params, \n con), majors = serv_major(params, con), term_list |
OlderNewer