upstream/ipython Files · IPython/core/tests/test_imports.py

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.

Matthias Bussonnier - - Load All Authors

File last commit:

r23703:d7af1ed2


                r28168:9a5baf06

Download file

             test_imports.py
        
                    52 lines
            
             | 1.1 KiB
            
                | text/x-python
            
             |
                PythonLexer
            
             / IPython / core / tests / test_imports.py
          
                    History
                
                 |
                  Annotation
                 | Raw
                 |Copy content
                 |Copy permalink

      # encoding: utf-8

      def test_import_completer():

          from IPython.core import completer

      def test_import_crashhandler():

          from IPython.core import crashhandler

      def test_import_debugger():

          from IPython.core import debugger

      def test_import_excolors():

          from IPython.core import excolors

      def test_import_history():

          from IPython.core import history

      def test_import_hooks():

          from IPython.core import hooks

      def test_import_getipython():

          from IPython.core import getipython

      def test_import_interactiveshell():

          from IPython.core import interactiveshell

      def test_import_logger():

          from IPython.core import logger

      def test_import_macro():

          from IPython.core import macro

      def test_import_magic():

          from IPython.core import magic

      def test_import_oinspect():

          from IPython.core import oinspect

      def test_import_prefilter():

          from IPython.core import prefilter

      def test_import_prompts():

          from IPython.core import prompts

      def test_import_release():

          from IPython.core import release

      def test_import_ultratb():

          from IPython.core import ultratb

      def test_import_usage():

          from IPython.core import usage

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
g 0-9	Goto bookmarked items from 0-9
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings
t s	Toggle sidebar on some pages

				# encoding: utf-8

				def test_import_completer():
				from IPython.core import completer

				def test_import_crashhandler():
				from IPython.core import crashhandler

				def test_import_debugger():
				from IPython.core import debugger

				def test_import_excolors():
				from IPython.core import excolors

				def test_import_history():
				from IPython.core import history

				def test_import_hooks():
				from IPython.core import hooks

				def test_import_getipython():
				from IPython.core import getipython

				def test_import_interactiveshell():
				from IPython.core import interactiveshell

				def test_import_logger():
				from IPython.core import logger

				def test_import_macro():
				from IPython.core import macro

				def test_import_magic():
				from IPython.core import magic

				def test_import_oinspect():
				from IPython.core import oinspect

				def test_import_prefilter():
				from IPython.core import prefilter

				def test_import_prompts():
				from IPython.core import prompts

				def test_import_release():
				from IPython.core import release

				def test_import_ultratb():
				from IPython.core import ultratb

				def test_import_usage():
				from IPython.core import usage