| https://github.com/simonw/datasette/issues/1257#issuecomment-852681622 |
https://api.github.com/repos/simonw/datasette/issues/1257 |
852681622 |
MDEyOklzc3VlQ29tbWVudDg1MjY4MTYyMg== |
9599 |
2021-06-02T03:12:18Z |
2021-06-02T03:12:18Z |
OWNER |
Created a test database like this:
% sqlite-utils create-table quote-in-name.db "this'hasquoteinname" id integer name text --pk id
% datasette quote-in-name.db -p 8025 --pdb
INFO: Started server process [86046]
INFO: Waiting for application startup.
INFO: Application startup complete.
INFO: Uvicorn running on http://127.0.0.1:8025 (Press CTRL+C to quit)
> /Users/simon/Dropbox/Development/datasette/datasette/utils/__init__.py(530)detect_fts()
-> rows = conn.execute(detect_fts_sql(table)).fetchall()
(Pdb) c
Traceback (most recent call last):
File "/Users/simon/Dropbox/Development/datasette/datasette/app.py", line 1124, in route_path
response = await view(request, send)
File "/Users/simon/Dropbox/Development/datasette/datasette/views/base.py", line 147, in view
return await self.dispatch_request(
File "/Users/simon/Dropbox/Development/datasette/datasette/views/base.py", line 122, in dispatch_request
return await handler(request, *args, **kwargs)
File "/Users/simon/Dropbox/Development/datasette/datasette/views/index.py", line 72, in get
"fts_table": await db.fts_table(table),
File "/Users/simon/Dropbox/Development/datasette/datasette/database.py", line 279, in fts_table
return await self.execute_fn(lambda conn: detect_fts(conn, table))
File "/Users/simon/Dropbox/Development/datasette/datasette/database.py", line 155, in execute_fn
return await asyncio.get_event_loop().run_in_executor(
File "/Users/simon/.pyenv/versions/3.8.2/lib/python3.8/concurrent/futures/thread.py", line 57, in run
result = self.fn(*self.args, **self.kwargs)
File "/Users/simon/Dropbox/Development/datasette/datasette/database.py", line 153, in in_thread
return fn(conn)
File "/Users/simon/Dropbox/Development/datasette/datasette/database.py", line 279, in <lambda>
return await self.execute_fn(lambda conn: detect_fts(conn, table))
File "/Users/simon/Dropbox/Development/datasette/datasette/utils/__init__.py", line 530, in detect_fts
rows = conn.execute(detect_fts_sql(table)).fetchall()
sqlite3.OperationalError: near "hasquoteinname": syntax error
|
{
"total_count": 0,
"+1": 0,
"-1": 0,
"laugh": 0,
"hooray": 0,
"confused": 0,
"heart": 0,
"rocket": 0,
"eyes": 0
} |
828811618 |
|