github

Custom SQL query returning 15 rows (hide)

Query parameters

This data as json, CSV

shamessageauthor_datecommitter_dateraw_authorraw_committerrepoauthorcommitter
03572ae35573c2ea802a540624ce116f540ba1ac Allow --load-extension to be set via environment variable I tesed this by first building and running a container using the new Dockerfile from #114: docker build . docker run -it -p 8001:8001 6c9ca7e29181 /bin/sh Then I ran this inside the container itself: apt update && apt-get install wget -y \ && wget http://www.gaia-gis.it/spatialite-2.3.1/test-2.3.sqlite.gz \ && gunzip test-2.3.sqlite.gz \ && mv test-2.3.sqlite test23.sqlite \ && datasette -h 0.0.0.0 test23.sqlite I visited this URL to confirm I got an error due to spatialite not being loaded: http://localhost:8001/test23-c88bc35?sql=select+ST_AsText%28Geometry%29+from+HighWays+limit+1 Then I checked that loading it with `--load-extension` worked correctly: datasette -h 0.0.0.0 test23.sqlite \ --load-extension=/usr/lib/x86_64-linux-gnu/mod_spatialite.so Then, finally, I tested it with the new environment variable option: SQLITE_EXTENSIONS=/usr/lib/x86_64-linux-gnu/mod_spatialite.so \ datasette -h 0.0.0.0 test23.sqlite Running it with an invalid environment variable option shows an error: $ SQLITE_EXTENSIONS=/usr/lib/x86_64-linux-gnu/blah.so datasette \ -h 0.0.0.0 test23.sqlite Usage: datasette -h [OPTIONS] [FILES]... Error: Invalid value for "--load-extension": Path "/usr/lib/x86_64-linux-gnu/blah.so" does not exist. Closes #112 2017-11-17T14:13:35Z 2017-11-17T14:13:35Z 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 107914493 9599 9599
084350b0f1343d988928cae63cfedbeb6205e25e Switched to gather_request=False for Sanic tests Gets rid of those ugly _, response = lines. 2017-11-17T14:53:37Z 2017-11-17T14:53:37Z 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 107914493 9599 9599
0b702f3679a2ffd4e3efb5c34b9fe30221172ccb Fixed weird edge-case with foreign key detection It turns out it is possible for a SQLite table to define a foreign key relationship to a table that does not actually exist We should still be able to handle these databases. 2017-11-17T16:18:26Z 2017-11-17T16:18:26Z 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 107914493 9599 9599
1a6cfcc10f9abcc743b45437996c7264cc2a57b2 Added a .dockerignore Figured this would be useful while testing out 03572ae3557 2017-11-17T14:18:23Z 2017-11-17T14:18:23Z 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 107914493 9599 9599
45e502aace6cc1198cc5f9a04d61b4a1860a012b Added unit tests for inspect() foreign key detection Used them to fix a bug with it. Refs #85 2017-11-17T16:08:11Z 2017-11-17T16:08:11Z 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 107914493 9599 9599
54d58ef690f6123415d3a250951946e4431ecfb0 Merge branch 'master' into publish-heroku 2017-11-17T21:36:50Z 2017-11-17T21:36:50Z 2035bd0fdcffb9aa3b95f21a684665482bd8c80f 2035bd0fdcffb9aa3b95f21a684665482bd8c80f 107914493 21148 21148
6a007f632258e6cfd3c5e9e229683deb0efd87be Row pages show incoming foreign key relationships 2017-11-17T18:15:44Z 2017-11-18T03:15:49Z 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 107914493 9599 9599
6eb23d21435eece1ec3c3fe996a9c36b6b967fc7 Moved `datasette build` to a post_compile hook. 2017-11-17T20:09:01Z 2017-11-17T20:09:01Z 2035bd0fdcffb9aa3b95f21a684665482bd8c80f 2035bd0fdcffb9aa3b95f21a684665482bd8c80f 107914493 21148 21148
7feb746efe8c5ed80f477475acc546370bae89e4 Fixed bug where 0 values were showing up blank 2017-11-17T18:14:01Z 2017-11-18T03:15:49Z 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 107914493 9599 9599
8b4c600d98b85655b3a1454ebf64f858b5fe54c8 Add spatialite, switch to debian and local build (#114) 2017-11-17T03:50:51Z 2017-11-17T03:50:51Z 959507cc7596b555bf4292e84f335b02cca843f8 2946d096d0cdefdc017559e6b57e87658736e843 107914493 54999 9599
b9af49be6c68d6e551c1ae23132711f22cb7c63c Fix case for Sanic dependency On PyPI it has a capital letter: https://pypi.python.org/pypi/Sanic I think this is why the list of "Requires Distributions" on https://pypi.python.org/pypi/datasette links to all of the other dependencies but does not link to Sanic. 2017-11-17T13:26:05Z 2017-11-17T13:26:05Z 2946d096d0cdefdc017559e6b57e87658736e843 cd792325681cbad9f663f2879d8b69f1edbb678f 107914493 9599 19864447
e16ca1169cc49fbb5b0325564d248becad3a4b7f Refactored table column/row display logic Simplified the template and made the way for upcoming foreign key work. Refs #85 Also fixed   bug on database page - closes #113 2017-11-17T15:39:36Z 2017-11-17T15:39:36Z 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 107914493 9599 9599
ed2b3f25beac720f14869350baacc5f62b065194 add support for ?field__isnull=1 (#107) * add support for ?field__isnull=1 * Add unit test and conditional formatting for ?field__isnull 2017-11-17T13:29:22Z 2017-11-17T13:29:22Z 19245be93da11be3d5e72991646660a06a9d3449 2946d096d0cdefdc017559e6b57e87658736e843 107914493 3433657 9599
eda848b37f8452dba7913583ef101f39d9b130ba Add keyboard shortcut to execute SQL query (#115) 2017-11-17T14:22:55Z 2017-11-17T14:22:55Z 106fe7fbf8b80a01038e265a137b3b703422db48 2946d096d0cdefdc017559e6b57e87658736e843 107914493 198537 9599
f3445e2d13e2c38bfbf75f35c2aa3e50df0040f1 Install python3-dev rothar than python-dev 2017-11-17T14:18:49Z 2017-11-17T14:18:49Z 2946d096d0cdefdc017559e6b57e87658736e843 2946d096d0cdefdc017559e6b57e87658736e843 107914493 9599 9599