##// END OF EJS Templates
Use single quotes in sql string literal (#13968)...
Use single quotes in sql string literal (#13968) the SQL spec requires that string literals use single quotes and column references (or other identifiers) use double quotes. sqlite permits the use of double quotes for string literals in "unambiguous cases". For some reason, its understanding of what constitutes unambiguous has changed recently - I'm on FreeBSD 14.0-CURRENT with sqlite 3.41.0 - and attempting to do anything with ipython throws a very strange sqlite operation error: ``` [+] ~% ipython --version (test) audrey@daisy [12:18:02 AM] 8.11.0 [+] ~% ipython (test) audrey@daisy [12:18:04 AM] [TerminalIPythonApp] ERROR | Failed to create history session in /usr/home/audrey/.ipython/profile_default/history.sqlite. History will not be saved. Traceback (most recent call last): File "/usr/home/audrey/.virtualenvs/test/lib/python3.9/site-packages/IPython/core/history.py", line 545, in __init__ self.new_session() File "/usr/home/audrey/.virtualenvs/test/lib/python3.9/site-packages/decorator.py", line 232, in fun return caller(func, *(extras + args), **kw) File "/usr/home/audrey/.virtualenvs/test/lib/python3.9/site-packages/IPython/core/history.py", line 60, in only_when_enabled return f(self, *a, **kw) File "/usr/home/audrey/.virtualenvs/test/lib/python3.9/site-packages/IPython/core/history.py", line 570, in new_session cur = conn.execute("""INSERT INTO sessions VALUES (NULL, ?, NULL, sqlite3.OperationalError: no such column: Python 3.9.16 (main, Feb 28 2023, 01:31:45) Type 'copyright', 'credits' or 'license' for more information IPython 8.11.0 -- An enhanced Interactive Python. Type '?' for help. ``` This patch fixes it. idk if this constitutes a bug in sqlite3, but this is, I guess, more correct.

File last commit:

r27747:f5d4e0ac
r28168:9a5baf06 merge
Show More
tempdir.py
59 lines | 1.8 KiB | text/x-python | PythonLexer
Srinivas Reddy Thatiparthy
Add docstring
r23288 """ This module contains classes - NamedFileInTemporaryDirectory, TemporaryWorkingDirectory.
Srinivas Reddy Thatiparthy
remove unused imports
r23701 These classes add extra features such as creating a named file in temporary directory and
Srinivas Reddy Thatiparthy
Add docstring
r23288 creating a context manager for the working directory which is also temporary.
"""
Min RK
Revert "use testpath.tempdir for utils.tempdir"
r21102 import os as _os
Jakub Klus
Use pathlib in utils/tempdir.
r26192 from pathlib import Path
Srinivas Reddy Thatiparthy
Remove TemporaryDirectory class...
r23287 from tempfile import TemporaryDirectory
Min RK
Revert "use testpath.tempdir for utils.tempdir"
r21102
Srinivas Reddy Thatiparthy
remove unused imports
r23701
Min RK
Revert "use testpath.tempdir for utils.tempdir"
r21102 class NamedFileInTemporaryDirectory(object):
Matthias Bussonnier
MAINT: cleanup imports of tempdir....
r27509 def __init__(self, filename, mode="w+b", bufsize=-1, add_to_syspath=False, **kwds):
Min RK
Revert "use testpath.tempdir for utils.tempdir"
r21102 """
Open a file named `filename` in a temporary directory.
This context manager is preferred over `NamedTemporaryFile` in
stdlib `tempfile` when one needs to reopen the file.
Arguments `mode` and `bufsize` are passed to `open`.
Rest of the arguments are passed to `TemporaryDirectory`.
"""
self._tmpdir = TemporaryDirectory(**kwds)
Jakub Klus
Use pathlib in utils/tempdir.
r26192 path = Path(self._tmpdir.name) / filename
gousaiyang
Format code
r27495 encoding = None if "b" in mode else "utf-8"
gousaiyang
Fix EncodingWarning on Python 3.10
r27494 self.file = open(path, mode, bufsize, encoding=encoding)
Min RK
Revert "use testpath.tempdir for utils.tempdir"
r21102
def cleanup(self):
self.file.close()
self._tmpdir.cleanup()
__del__ = cleanup
def __enter__(self):
return self.file
def __exit__(self, type, value, traceback):
self.cleanup()
class TemporaryWorkingDirectory(TemporaryDirectory):
"""
Creates a temporary directory and sets the cwd to that directory.
Automatically reverts to previous cwd upon cleanup.
Usage example:
with TemporaryWorkingDirectory() as tmpdir:
...
"""
Matthias Bussonnier
MAINT: run black on files that ends up in a single line change....
r27747
Min RK
Revert "use testpath.tempdir for utils.tempdir"
r21102 def __enter__(self):
Jakub Klus
Use pathlib in utils/tempdir.
r26192 self.old_wd = Path.cwd()
Min RK
Revert "use testpath.tempdir for utils.tempdir"
r21102 _os.chdir(self.name)
return super(TemporaryWorkingDirectory, self).__enter__()
def __exit__(self, exc, value, tb):
_os.chdir(self.old_wd)
return super(TemporaryWorkingDirectory, self).__exit__(exc, value, tb)