mirror
/
datasette
kopia lustrzana https://github.com/simonw/datasette
1
0
Forkuj 0
Kod Zgłoszenia Packages Projekty Wydania Wiki Aktywność
2 591 Commity
131 Gałęzie
148 Tagi
75 MiB
Wykres commitów

1031 Commity (main)

Autor SHA1 Wiadomość Data
Simon Willison a3593c9015 on_success_message_sql, closes #2138 2023-08-09 17:32:07 -07:00
Simon Willison 4a42476bb7 datasette plugins --requirements, closes #2133 2023-08-09 15:04:16 -07:00
Simon Willison 90cb9ca58d JSON changes in release notes, refs #2135 2023-08-09 12:11:16 -07:00
Simon Willison 856ca68d94 Update default JSON representation docs, refs #2135 2023-08-09 12:04:40 -07:00
Simon Willison 8920d425f4 1.0a3 release notes, smaller changes section - refs #2135 2023-08-09 10:20:58 -07:00
Simon Willison 1377a290cd
New JSON design for query views (#2118) 
* Refs #2111, closes #2110
* New Context dataclass/subclass mechanism, refs #2127
* Define QueryContext and extract get_tables() method, refs #2127
* Fix OPTIONS bug by porting DaatbaseView to be a View subclass
* Expose async_view_for_class.view_class for test_routes test
* Error/truncated aruments for renderers, closes #2130
 2023-08-07 18:47:39 -07:00
Simon Willison 0818182399 Update cli-reference for editable change, refs #2106 2023-07-26 11:52:57 -07:00
Simon Willison 278ac91a4d datasette install -e option, closes #2106 2023-07-22 11:42:46 -07:00
Simon Willison 0f7192b615 One last YAML/JSON change, closes #1153 2023-07-08 13:08:09 -07:00
Simon Willison 42ca574720 Removed accidental test code I added, refs #1153 2023-07-08 12:50:22 -07:00
Simon Willison 2fd871a906 Drop support for Python 3.7, refs #2097 2023-07-08 11:40:19 -07:00
Simon Willison 50a6355c08 Workaround to get sphinx-build working again, refs 1153 2023-07-08 11:22:21 -07:00
Simon Willison c076fb65e0 Applied sphinx-inline-tabs to remaining examples, refs #1153 2023-07-08 11:00:08 -07:00
Simon Willison 0183e1a72d Preserve JSON key order in YAML, refs #1153 2023-07-08 10:27:36 -07:00
Simon Willison 38fcc96e67 Removed duplicate imports, refs #1153 2023-07-08 10:09:26 -07:00
Simon Willison 3b336d8071 Utility function for cog for generating YAML/JSON tabs, refs #1153 2023-07-08 09:37:47 -07:00
Simon Willison d7b21a8623 metadata.yaml now treated as default in docs 
Added sphinx-inline-tabs to provide JSON and YAML tabs to show examples.

Refs #1153
 2023-07-08 09:37:01 -07:00
Simon Willison 99ba051188 Fixed spelling error, refs #2089 
Also ensure codespell runs as part of just lint
 2023-06-29 07:46:22 -07:00
Simon Willison d1d78ec0eb
Better docs for startup() hook 2023-06-23 13:06:35 -07:00
Simon Willison b49fa446d6 --cors Access-Control-Max-Age: 3600, closes #2079 2023-05-25 15:05:58 -07:00
Simon Willison 5890a20c37 Mention API tokens in DATASETTE_SECRET docs 2023-03-31 09:45:16 -07:00
Simon Willison 4c1e277edb Updated JSON API shape documentation, refs #262 2023-03-28 23:21:42 -07:00
Simon Willison c025b0180f
Drop jQuery dependency 2023-03-26 16:38:58 -07:00
Simon Willison db8cf899e2
Use block scripts instead, refs #1608 2023-03-26 16:27:58 -07:00
Simon Willison 5c1cfa451d
Link docs /latest/ to /stable/ again 
Re-implementing the pattern from https://til.simonwillison.net/readthedocs/link-from-latest-to-stable

Refs #1608
 2023-03-26 16:23:28 -07:00
Simon Willison 56b0758a5f 0.64 release notes, refs #2036 2023-03-08 12:52:37 -08:00
Simon Willison 1ad92a1d87 datasette install -r requirements.txt, closes #2033 2023-03-06 14:27:30 -08:00
Simon Willison 0b4a286914 render_cell(..., request) argument, closes #2007 2023-01-27 19:34:14 -08:00
Simon Willison e4ebef082d
Fixed link text 2023-01-21 07:37:29 -08:00
Simon Willison 6a352e99ab
Added missing import to example 2023-01-11 11:04:11 -08:00
Simon Willison 25a612fe09 Release 0.64.1 
Refs #1985, #1987
 2023-01-11 10:23:49 -08:00
Simon Willison 2c86774179
Link to non-spam Python 3 setup instructions 
Refs #1987
 2023-01-11 09:59:40 -08:00
Simon Willison 7dd671310a Release notes for 0.64, with a warning against arbitrary SQL with SpatiaLite 
Refs #1409, #1771, #1979

Refs https://github.com/simonw/datasette.io/issues/132
 2023-01-09 08:40:24 -08:00
Simon Willison 5e672df168 Explicitly explain allow_sql: false 2023-01-09 08:25:07 -08:00
Simon Willison 0f7c71a86f What to do if extensions will not load, refs #1979 2023-01-07 15:49:28 -08:00
Simon Willison fee658ad05 Improved wording in allow_sql docs 2023-01-05 09:22:49 -08:00
Simon Willison c41278b46f default_allow_sql setting, closes #1409 
Refs #1410
 2023-01-04 16:51:26 -08:00
Simon Willison adfcec51d6 Fixed broken example links in _where= docs 2023-01-04 16:51:26 -08:00
Simon Willison deb5fcbed4
Fixed table_action example in docs 2023-01-04 10:25:04 -08:00
Simon Willison 5bbe2bcc50 Rename filtered_table_rows_count to count, refs #782 2022-12-31 12:52:57 -08:00
Simon Willison 3af313e165 Fix for Sphinx extlinks warning, closes #1972 2022-12-31 11:13:14 -08:00
Chris Holdgraf 994ce46ed4
Add favicon to documentation (#1967) 
Co-authored-by: Simon Willison <swillison@gmail.com>
 2022-12-31 11:00:31 -08:00
Simon Willison 8059c8a27c Fixed typo 2022-12-31 10:54:25 -08:00
Simon Willison 234230e595 Default JSON shape is now objects - refs #1914, #1709 2022-12-31 10:52:37 -08:00
Simon Willison 1fda4806d4 Small documentation tweaks 2022-12-31 10:52:37 -08:00
Simon Willison c635f6ebac Moved CORS bit to its own documentation section 2022-12-31 10:52:37 -08:00
Simon Willison 3bd05b854a -e/--expires-after in create-token docs 2022-12-31 10:52:37 -08:00
Simon Willison 677ba9dddd Fix rST warning in changelog 2022-12-31 10:52:37 -08:00
Simon Willison 23335e123b Release notes for 0.63.3 
Refs #1963
 2022-12-17 19:26:25 -08:00
Simon Willison 63fb750f39 Replace AsgiLifespan with AsgiRunOnFirstRequest, refs #1955 2022-12-17 14:14:34 -08:00
Simon Willison 5ee954e34b
Link to annotated release notes for 1.0a2 2022-12-15 17:03:37 -08:00
Simon Willison 0b68996cc5 Revert "Replace AsgiLifespan with AsgiRunOnFirstRequest, refs #1955" 
This reverts commit dc18f62089.
 2022-12-15 13:06:45 -08:00
Simon Willison dc18f62089 Replace AsgiLifespan with AsgiRunOnFirstRequest, refs #1955 2022-12-15 09:34:07 -08:00
Simon Willison e054704fb6 Added missing rST label 2022-12-14 21:38:28 -08:00
Simon Willison 6e1e815c78
It's an update-or-insert 2022-12-14 18:41:30 -08:00
Simon Willison 8b9d7fdbd8 Fixed typo in release notes, refs #1953 2022-12-14 18:02:42 -08:00
Simon Willison 8cac6ff301 Release 1.0a2 
Refs #1636, #1855, #1878, #1927, #1937, #1940, #1947, #1951

Closes #1953
 2022-12-14 18:01:02 -08:00
Simon Willison 9ad76d279e Applied blacken-docs, refs #1937 2022-12-14 14:49:13 -08:00
Simon Willison c094dde3ff Extra permission rules for /-/create, closes #1937 2022-12-14 12:21:18 -08:00
Simon Willison 6e5ab9e7b3 Note in docs about new /-/create-token features, refs #1947 2022-12-13 21:07:03 -08:00
Simon Willison fdf7c27b54 datasette.create_token() method, closes #1951 2022-12-13 18:42:01 -08:00
Simon Willison d4cc1374f4 Improved --help for create-token, refs #1947 2022-12-13 14:28:59 -08:00
Simon Willison 2aa2adaa8b Docs for new create-token options, refs #1855 2022-12-12 20:56:40 -08:00
Simon Willison c13dada2f8 datasette --get --token option, closes #1946, refs #1855 2022-12-12 20:36:42 -08:00
Simon Willison 14f1cc4984 Update CLI reference help, refs #1855 2022-12-12 20:21:48 -08:00
Simon Willison 98eff2cde9 Ignore spelling of alls, refs #1855 2022-12-12 20:19:17 -08:00
Simon Willison 8bf06a76b5
register_permissions() plugin hook (#1940) 
* Docs for permissions: in metadata, refs #1636
* Refactor default_permissions.py to help with implementation of #1636
* register_permissions() plugin hook, closes #1939 - also refs #1938
* Tests for register_permissions() hook, refs #1939
* Documentation for datasette.permissions, refs #1939
* permission_allowed() falls back on Permission.default, refs #1939
* Raise StartupError on duplicate permissions
* Allow dupe permisisons if exact matches
 2022-12-12 18:05:54 -08:00
David Larlet e539c1c024
Typo in JSON API `Updating a row` documentation (#1930) 2022-12-08 13:12:34 -08:00
Simon Willison 05daa15aac Documentation for /-/create ignore/replace, closes #1927 2022-12-07 17:42:54 -08:00
Simon Willison 272982e8a6
/db/table/-/upsert API 
Close #1878

Also made a few tweaks to how _r works in tokens and actors,
refs #1855 - I needed that mechanism for the tests.
 2022-12-07 17:12:15 -08:00
Simon Willison cab5b60e09
datasette-auth-passwords is another actor_from_request example 2022-12-02 08:39:52 -08:00
Simon Willison 692fbfc40a Release 1.0a1 
Refs #1922, #1917, #1915, #1916, #1918, #1924
 2022-12-01 13:30:39 -08:00
Simon Willison 99da46f725 Docs for insert API ignore/replace - closes #1924 2022-11-30 18:07:48 -08:00
Simon Willison 7fde34cfcb Documentation and test for UNIQUE constraint failed, refs #1924 2022-11-30 18:05:29 -08:00
Simon Willison f0fadc28dd Access-Control-Allow-Headers: Authorization, Content-Type - refs #1922 2022-11-30 15:11:18 -08:00
Simon Willison 6bfd71f5c6 Access-Control-Allow-Methods: GET, POST, HEAD, OPTIONS - refs #1922 2022-11-30 12:25:12 -08:00
Simon Willison b8fc8e2cd7
Merge branch 'main' into 1.0-dev 2022-11-29 11:34:39 -08:00
Simon Willison 4d49a5a397 Release 1.0a0 
Refs #1850, #1851, #1852, #1856, #1858, #1863, #1864, #1871, #1874, #1882

Closes #1891
 2022-11-29 11:22:54 -08:00
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 72ac9bf82f --generate-dir option to publish heroku, refs #1905 2022-11-18 16:34:33 -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
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
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 187d91d686 /db/-/create API endpoint, closes #1882 2022-11-14 21:57:28 -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 f832435b88 Release 0.63.1 
Refs ##1843, #1876, #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 aacf25cf19
Improvements to API token docs, refs #1852 2022-11-05 23:54:32 -07:00
Simon Willison 867e0abd34 Tests now close SQLite database connections and files explicitly, refs #1843 
Also added a db.close() method to the Database class.
 2022-11-03 13:37:26 -07:00
Simon Willison 2355067ef5 Tests now close SQLite database connections and files explicitly, refs #1843 
Also added a db.close() method to the Database class.
 2022-11-03 13:36:11 -07:00
Simon Willison 9bec7c38eb ignore and replace options for bulk inserts, refs #1873 
Also removed the rule that you cannot include primary keys in the rows you insert.

And added validation that catches invalid parameters in the incoming JSON.

And renamed "inserted" to "rows" in the returned JSON for return_rows: true
 2022-11-01 11:08:17 -07:00
Simon Willison 00632ded30 Initial attempt at /db/table/row/-/delete, refs #1864 2022-10-30 16:16:00 -07:00
Simon Willison 2865d3956f /db/table/-/drop API, closes #1874 2022-10-30 15:17:21 -07:00
Simon Willison 4f16e14d7a Update cog 2022-10-30 14:53:33 -07:00
Simon Willison c35859ae3d API for bulk inserts, closes #1866 2022-10-29 23:03:45 -07:00
Simon Willison 61171f0154 Release 0.63 
Refs #1646, #1786, #1787, #1789, #1794, #1800, #1804, #1805, #1808, #1809, #1816, #1819, #1825, #1829, #1831, #1834, #1844, #1853, #1860

Closes #1869
 2022-10-27 17:58:41 -07:00
Simon Willison 26af9b9c4a Release notes for 0.63, refs #1869 2022-10-27 17:58:41 -07:00
Simon Willison bf00b0b59b Release 0.63 
Refs #1646, #1786, #1787, #1789, #1794, #1800, #1804, #1805, #1808, #1809, #1816, #1819, #1825, #1829, #1831, #1834, #1844, #1853, #1860

Closes #1869
 2022-10-27 15:11:26 -07:00
Simon Willison e5e0459a0b Release notes for 0.63, refs #1869 2022-10-27 13:58:00 -07:00
Simon Willison 6e788b49ed New URL design /db/table/-/insert, refs #1851 2022-10-27 13:18:05 -07:00
Simon Willison a51608090b Slight tweak to insert row API design, refs #1851 
https://github.com/simonw/datasette/issues/1851#issuecomment-1292997608
 2022-10-27 12:06:18 -07:00
Simon Willison 51c436fed2 First draft of insert row write API, refs #1851 2022-10-26 20:57:02 -07:00
Simon Willison 382a871583 max_signed_tokens_ttl setting, closes #1858 
Also redesigned token format to include creation time and optional duration.
 2022-10-26 20:14:59 -07:00
Simon Willison c7956eed77 datasette create-token command, refs #1859 2022-10-25 21:26:12 -07:00
Simon Willison c23fa850e7 allow_signed_tokens setting, closes #1856 2022-10-25 19:55:47 -07:00
Simon Willison 0f013ff497 Mechanism to prevent tokens creating tokens, closes #1857 2022-10-25 19:43:55 -07:00
Simon Willison 7ab091e8ef Tests and docs for /-/create-token, refs #1852 2022-10-25 19:04:05 -07:00
Simon Willison 9676b2deb0 Upgrade Docker images to Python 3.11, closes #1853 2022-10-25 12:04:53 -07:00
Simon Willison 02ae1a0029 Upgrade Docker images to Python 3.11, closes #1853 2022-10-25 12:04:25 -07:00
Simon Willison a0dd5fa02f Fixed typo in release notes 2022-10-23 20:14:49 -07:00
Simon Willison 602c0888ce Release 0.63a1 
Refs #1646, #1819, #1825, #1829, #1831, #1832, #1834, #1844, #1848
 2022-10-23 20:07:09 -07:00
Simon Willison 78dad236df
check_visibility can now take multiple permissions into account 
Closes #1829
 2022-10-23 19:11:33 -07:00
Simon Willison fdf9891c3f Use shot-scraper images from datasette-screenshots repo, closes #1844 2022-10-14 12:57:00 -07:00
Simon Willison b7fec7f902 .sqlite/.sqlite3 extensions for config directory mode 
Closes #1646
 2022-10-07 16:03:30 -07:00
Simon Willison b6ba117b79
Clarify request or None for two hooks 2022-10-04 18:25:52 -07:00
Simon Willison 4218c9cd74
reST markup fix 2022-10-04 11:45:36 -07:00
Simon Willison 34defdc10a
Browse the plugins directory 2022-09-28 17:39:36 -07:00
Adam Simpson 984b1df12c
Add documentation for serving via OpenRC (#1825) 
* Add documentation for serving via OpenRC
 2022-09-27 21:21:36 -07:00
Simon Willison 7fb4ea4e39
Update note about render_cell signature, refs #1826 2022-09-27 21:06:40 -07:00
Simon Willison 212137a90b Release 0.63a0 
Refs #1786, #1787, #1789, #1794, #1800, #1804, #1805, #1808, #1809, #1816
 2022-09-26 14:14:25 -07:00
Simon Willison ddc999ad12 Async support for prepare_jinja2_environment, closes #1809 2022-09-16 20:38:24 -07:00
Simon Willison b40872f5e5 prepare_jinja2_environment(datasette) argument, refs #1809 2022-09-14 14:31:54 -07:00
Simon Willison fb7e70d5e7 Database(is_mutable=) now defaults to True, closes #1808 
Refs https://github.com/simonw/datasette-upload-dbs/issues/6
 2022-09-09 09:19:20 -07:00
Simon Willison ff9c87197d Fixed Sphinx warnings on cli-reference page 2022-09-06 11:26:21 -07:00
Simon Willison d0476897e1 Fixed Sphinx warning about language = None 2022-09-06 11:24:30 -07:00
Simon Willison 0a7815d203 Documentation for facet_size in metadata, closes #1804 2022-09-06 11:06:49 -07:00
Simon Willison 456dc155d4 Ran cog, refs #1789 2022-08-23 11:40:48 -07:00
Simon Willison 0d9d33955b Clarify you can publish multiple files, closes #1788 2022-08-18 16:06:12 -07:00
Simon Willison aff3df03d4 Ignore ro which stands for read only 
Refs #1787 where it caused tests to break
 2022-08-18 14:55:08 -07:00
Simon Willison 6c0ba7c00c Improved CLI reference documentation, refs #1787 2022-08-18 14:52:04 -07:00
Simon Willison 09a41662e7 Fix typo 2022-08-18 09:10:48 -07:00
Simon Willison 481eb96d85
https://datasette.io/tutorials/clean-data tutorial 
Refs #1783
 2022-08-15 13:17:28 -07:00
Simon Willison a107e3a028
datasette-sentry is an example of handle_exception 2022-08-14 16:07:46 -07:00
Simon Willison 815162cf02 Release 0.62 
Refs #903, #1300, #1683, #1701, #1712, #1717, #1718, #1728, #1733, #1738, #1739, #1744, #1746, #1748, #1759, #1766, #1768, #1770, #1773, #1779

Closes #1782
 2022-08-14 10:32:42 -07:00
Simon Willison 5e6c5c9e31 Document datasette.config_dir, refs #1766 2022-08-14 10:18:47 -07:00
Simon Willison 82167105ee --min-instances and --max-instances Cloud Run publish options, closes #1779 2022-08-14 10:07:30 -07:00
Simon Willison 080d4b3e06 Switch to python:3.10.6-slim-bullseye for datasette publish - refs #1768 2022-08-14 08:49:14 -07:00
Simon Willison 8eb699de7b
Datasette Lite in Getting Started docs, closes #1781 2022-08-14 08:24:39 -07:00
Simon Willison 8cfc723368 Ran blacken-docs 2022-08-09 11:21:53 -07:00
Simon Willison 7af67b54b7 How to register temporary plugins in tests, closes #903 2022-07-18 14:31:17 -07:00
Simon Willison ed1ebc0f1d Run blacken-docs, refs #1770 2022-07-17 18:03:33 -07:00
Simon Willison 6d5e195547 Release 0.62a1 
Refs #1300, #1739, #1744, #1746, #1748, #1759, #1770
 2022-07-17 17:59:20 -07:00
Simon Willison e543a095cc Updated default plugins in docs, refs #1770 2022-07-17 17:57:41 -07:00
Simon Willison 58fd1e33ec Hint that you can render templates for these hooks, refs #1770 2022-07-17 16:30:58 -07:00
Simon Willison c09c53f345 New handle_exception plugin hook, refs #1770 
Also refs:
- https://github.com/simonw/datasette-sentry/issues/1
- https://github.com/simonw/datasette-show-errors/issues/2
 2022-07-17 16:24:39 -07:00