Simon Willison
1154048f79
Compound primary key support for /db/-/create - closes #1911
...
Needed for tests in #1864
2022-11-29 10:47:48 -08:00
Simon Willison
484bef0d3b
/db/table/pk/-/update endpoint, closes #1863
2022-11-29 10:06:19 -08:00
Simon Willison
21f8aab531
Release 0.63.2
...
Refs #1904 , #1905
2022-11-18 16:59:05 -08:00
Simon Willison
733447d7c7
Upgrade to Python 3.11 on Heroku, refs #1905
2022-11-18 16:44:46 -08:00
Simon Willison
72ac9bf82f
--generate-dir option to publish heroku, refs #1905
2022-11-18 16:34:33 -08:00
Simon Willison
5be728c2dd
Pin httpx in Pyodide test, refs #1904
...
Should help get tests to pass for #1896 too
2022-11-18 14:52:05 -08:00
Simon Willison
0fe1619910
Pin httpx in Pyodide test, refs #1904
...
Should help get tests to pass for #1896 too
2022-11-18 14:50:19 -08:00
Simon Willison
ee64130fa8
Refactor to use new resolve_database/table/row methods, refs #1896
2022-11-18 14:46:25 -08:00
Simon Willison
c588a89f26
db.view_exists() method, needed by #1896
2022-11-18 14:16:38 -08:00
Simon Willison
b29ccb59c7
Add test for db.view_names()
2022-11-18 14:13:48 -08:00
Brian Grinstead
3ecd131e57
Use DOMContentLoaded instead of load event for CodeMirror initialization. Closes #1894 ( #1898 )
2022-11-17 23:29:00 -08:00
Simon Willison
63f923d013
Remove min-height on CodeMirror, closes #1899
2022-11-17 23:21:00 -08:00
Simon Willison
3db37e9a21
Remove min-height on CodeMirror, closes #1899
2022-11-17 23:20:49 -08:00
Simon Willison
83a6872d1b
Include views in SQL autocomplete, refs #1897
2022-11-17 18:53:48 -08:00
Simon Willison
52bf222d48
/db/-/create API endpoint, closes #1882
2022-11-17 17:24:46 -08:00
Simon Willison
98611b3da0
Include SQL schema for CodeMirror on query pages, closes #1897
...
Refs #1893
2022-11-17 17:24:44 -08:00
Simon Willison
22bade4562
Use table_columns context for CodeMirror schema, if available - refs #1897
2022-11-17 17:23:35 -08:00
Simon Willison
8494be07ae
Prettier should ignore bundle.js file - refs #1893
2022-11-17 17:23:35 -08:00
Brian Grinstead
710be684b8
Upgrade to CodeMirror 6, add SQL autocomplete ( #1893 )
...
* Upgrade to CodeMirror 6
* Update contributing docs
* Change how resizing works
* Define a custom SQLite autocomplete dialect
* Add meta-enter to submit
* Add fixture schema for testing
2022-11-17 17:23:35 -08:00
Simon Willison
b35522c6dd
Updated test, refs #1890
2022-11-17 17:23:35 -08:00
Simon Willison
b470ab5c41
Fix for datalist against foreign key facets
...
Refs https://github.com/simonw/datasette/issues/1890#issuecomment-1314850524
2022-11-17 17:23:35 -08:00
Simon Willison
df2cc923c6
Applied prettier, refs #1890
2022-11-17 17:23:35 -08:00
Simon Willison
e15ff2d86e
datalist autocomplete for facet filters, refs #1890
2022-11-17 17:23:35 -08:00
Simon Willison
3e61a41b9b
Include SQL schema for CodeMirror on query pages, closes #1897
...
Refs #1893
2022-11-17 17:19:37 -08:00
Simon Willison
aff7a6985e
Use table_columns context for CodeMirror schema, if available - refs #1897
2022-11-17 16:41:25 -08:00
Simon Willison
00e233d7a7
Prettier should ignore bundle.js file - refs #1893
2022-11-16 15:53:27 -08:00
Brian Grinstead
ae11fa5887
Upgrade to CodeMirror 6, add SQL autocomplete ( #1893 )
...
* Upgrade to CodeMirror 6
* Update contributing docs
* Change how resizing works
* Define a custom SQLite autocomplete dialect
* Add meta-enter to submit
* Add fixture schema for testing
2022-11-16 15:49:06 -08:00
Simon Willison
6f610e1d94
Updated test, refs #1890
2022-11-15 19:04:24 -08:00
Simon Willison
eac028d3f7
Fix for datalist against foreign key facets
...
Refs https://github.com/simonw/datasette/issues/1890#issuecomment-1314850524
2022-11-14 22:57:11 -08:00
Simon Willison
3652b7472a
Applied prettier, refs #1890
2022-11-14 22:41:10 -08:00
Simon Willison
f156bf9e6b
datalist autocomplete for facet filters, refs #1890
2022-11-14 22:31:29 -08:00
Simon Willison
187d91d686
/db/-/create API endpoint, closes #1882
2022-11-14 21:57:28 -08:00
Simon Willison
518fc63224
API explorer: no error if you format JSON on empty string
...
Refs #1871
2022-11-13 22:06:45 -08:00
Simon Willison
575a29c424
API explorer: respect immutability, closes #1888
2022-11-13 22:01:56 -08:00
Simon Willison
264d0ab471
Renamed return_rows to return in insert API
...
Refs https://github.com/simonw/datasette/issues/1866#issuecomment-1313128913
2022-11-13 21:49:23 -08:00
Simon Willison
65521f03db
Error for drop against immutable database, closes #1874
2022-11-13 21:40:10 -08:00
Simon Willison
612da8eae6
confirm: true mechanism for drop table API, closes #1887
2022-11-13 21:17:18 -08:00
Simon Willison
db796771e2
Example links for API explorer, closes #1871
2022-11-13 20:58:45 -08:00
Simon Willison
c603faac5b
API explorer: persist form state in # in URL, refs #1871
2022-11-13 20:12:36 -08:00
Simon Willison
ca66ea57d2
GET and POST areas toggle each other, refs #1871
2022-11-13 13:12:51 -08:00
Simon Willison
51d60d7ddf
details-menu class to avoid accidential details closure
...
Refs https://github.com/simonw/datasette/issues/1871#issuecomment-1312821031
2022-11-13 13:06:58 -08:00
Simon Willison
f832435b88
Release 0.63.1
...
Refs ##1843, #1876 , #1883
2022-11-12 12:29:59 -08:00
Simon Willison
fa9cc9efaf
Fix for redirects ignoring base_url, refs #1883
2022-11-12 12:29:59 -08:00
Simon Willison
26262d08f3
Test form actions use prefix, refs #1883
2022-11-12 12:29:59 -08:00
Simon Willison
9f54f00a50
Release 0.63.1
...
Refs ##1843, #1876 , #1883
2022-11-10 23:01:20 -08:00
Simon Willison
8d9a957c63
Fix for redirects ignoring base_url, refs #1883
2022-11-10 22:49:54 -08:00
Simon Willison
bbaab3b38e
Test form actions use prefix, refs #1883
2022-11-10 22:20:40 -08:00
Simon Willison
aacf25cf19
Improvements to API token docs, refs #1852
2022-11-05 23:54:32 -07:00
Simon Willison
bcc781f4c5
Implementation and tests for _r field on actor, refs #1855
...
New mechanism for restricting permissions further for a given actor.
This still needs documentation. It will eventually be used by the mechanism to issue
signed API tokens that are only able to perform a subset of actions.
This also adds tests that exercise the POST /-/permissions tool, refs #1881
2022-11-03 17:12:23 -07:00
Simon Willison
fb8b6b2311
Refactor _error helper function
2022-11-03 16:36:43 -07:00