Oliver Uvman OliverUv
OliverUv
/ node.nearest.php
Created
July 30, 2012 14:50
This file contains hidden or 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
| $skeleton_rows = $db->getResult( | |
| "SELECT class_instance_a as skeleton_id | |
| FROM class_instance_class_instance cici, | |
| class_instance ca, | |
| class_instance cb | |
| WHERE relation_id = {$relations['model_of']} | |
| AND class_instance_b = $neuronID | |
| AND cici.class_instance_a = ca.id | |
| AND cici.class_instance_b = cb.id | |
| AND ca.class_id = {$classes['skeleton']} |
OliverUv
/ gist:3039666
Created
July 3, 2012 13:21
This file contains hidden or 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
| >>> vncbrowser.models.TextlabelLocation.objects.all() | |
| Traceback (most recent call last): | |
| File "<console>", line 1, in <module> | |
| File "/home/oliver/CATMAID/django/env/local/lib/python2.7/site-packages/django/db/models/query.py", line 69, in __repr__ | |
| data = list(self[:REPR_OUTPUT_SIZE + 1]) | |
| File "/home/oliver/CATMAID/django/env/local/lib/python2.7/site-packages/django/db/models/query.py", line 84, in __len__ | |
| self._result_cache.extend(self._iter) | |
| File "/home/oliver/CATMAID/django/env/local/lib/python2.7/site-packages/django/db/models/query.py", line 273, in iterator | |
| for row in compiler.results_iter(): | |
| File "/home/oliver/CATMAID/django/env/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 680, in results_iter |
OliverUv
/ last.edited.or.added.php
Created
July 1, 2012 13:21
This file contains hidden or 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
| $query = " | |
| SELECT | |
| tn.id AS id, | |
| tn.skeleton_id AS skeleton_id, | |
| (tn.location).x as x, | |
| (tn.location).y as y, | |
| (tn.location).z AS z, | |
| greatest(tn.creation_time, tn.edition_time) AS most_recent, | |
| 'treenode' as type | |
| FROM |
OliverUv
/ transaction.py
Created
June 30, 2012 19:09
This file contains hidden or 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
| from django.db import transaction | |
| from django.http import HttpResponse | |
| class RollbackAndReport(Exception): | |
| def __init__(self, error_json_report): | |
| self.error_json_report = error_json_report | |
| def __str__(self): | |
| return self.error_json_report |
OliverUv
/ pg_lsclusters.txt
Created
June 20, 2012 11:49
This file contains hidden or 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
| Version Cluster Port Status Owner Data directory Log file | |
| 9.1 main 5432 online postgres /var/lib/postgresql/9.1/main /var/log/postgresql/postgresql-9.1-main.log |
OliverUv
/ tests6.log
Created
June 18, 2012 13:21
This file contains hidden or 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
| ..............................................................................................................................................................EFEE.EFFFE.FFFFFFFFFEF......................................................... | |
| ====================================================================== | |
| ERROR: test_stack_insertion (vncbrowser.tests.InsertionTest) | |
| ---------------------------------------------------------------------- | |
| Traceback (most recent call last): | |
| File "/home/oliver/CATMAID/django/applications/vncbrowser/tests.py", line 87, in test_stack_insertion | |
| s = self.insert_stack() | |
| File "/home/oliver/CATMAID/django/applications/vncbrowser/tests.py", line 66, in insert_stack | |
| s.save() | |
| File "/home/oliver/CATMAID/django/env/local/lib/python2.7/site-packages/django/db/models/base.py", line 460, in save |
NewerOlder