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

2352 Commity (sql-list-parameters)

Autor SHA1 Wiadomość Data
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
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 bb030ba46f More margin on /-/allow-debug page 2022-11-02 22:10:59 -07:00
Simon Willison c51d9246b9 Permission check testing tool, refs #1881 2022-11-02 22:10:07 -07:00
Simon Willison 9b5a73ba4c Applied Black 2022-11-02 21:46:05 -07:00
Simon Willison 719e757252 Return method not allowed error in JSON in some situations 
Added this while playing with the new API explorer, refs #1871
 2022-11-02 20:12:13 -07:00
Simon Willison 000eeb4464 Link to Datasette API docs from /-/api, refs #1871 2022-11-01 22:45:05 -07:00
Simon Willison 042881a522 Ran Prettier, refs #1871 2022-11-01 22:30:16 -07:00
Simon Willison 0b166befc0 API explorer can now do GET, has JSON syntax highlighting 
Refs #1871
 2022-11-01 17:31:22 -07:00
Simon Willison 497290beaf Handle database errors in /-/insert, refs #1866, #1873 
Also improved API explorer to show HTTP status of response, refs #1871
 2022-11-01 12:59:17 -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 93a02281da Show interrupted query in resizing textarea, closes #1876 2022-11-01 10:38:24 -07:00
Simon Willison 2ec5583629 Show interrupted query in resizing textarea, closes #1876 2022-11-01 10:22:26 -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