Here's where the schema is hard-coded at the moment:

datasette/datasette/templates/_codemirror_foot.html

Lines 2 to 7 in 00e233d

    
           const schema = { 
        
             "123_starts_with_digits": ["content"], 
        
             "Table With Space In Name": ["content", "pk"], 
        
             attraction_characteristic: ["name", "pk"], 
        
             binary_data: ["data"], 
        
             complex_foreign_keys: ["f1", "f2", "f3", "pk"],

I figured out how to extract that data from the _internal table in this comment: #1893 (comment)

Although that used JSON functions which may (in a real edge-case) not be available in the version of SQLite that Datasette is running on, so probably going to use a regular SQL query and then assemble the JSON separately.

	const schema = {
	"123_starts_with_digits": ["content"],
	"Table With Space In Name": ["content", "pk"],
	attraction_characteristic: ["name", "pk"],
	binary_data: ["data"],
	complex_foreign_keys: ["f1", "f2", "f3", "pk"],

Uh oh!

Serve schema JSON to the SQL editor to enable autocomplete #1897

Description

Metadata

Metadata

Assignees

Labels

Projects

Milestone

Relationships

Development

Issue actions