upstream/ipython Files · IPython/utils/module_paths.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:

r27764:aefe51c6


                r28168:9a5baf06

Download file

             module_paths.py
        
                    70 lines
            
             | 2.3 KiB
            
                | text/x-python
            
             |
                PythonLexer
            
             / IPython / utils / module_paths.py
          
                    History
                
                 |
                  Annotation
                 | Raw
                 |Copy content
                 |Copy permalink

      """Utility functions for finding modules

      Utility functions for finding modules on sys.path.

      """

      #-----------------------------------------------------------------------------

      # Copyright (c) 2011, the IPython Development Team.

      #

      # Distributed under the terms of the Modified BSD License.

      #

      # The full license is in the file COPYING.txt, distributed with this software.

      #-----------------------------------------------------------------------------

      #-----------------------------------------------------------------------------

      # Imports

      #-----------------------------------------------------------------------------

      # Stdlib imports

      import importlib

      import sys

      # Third-party imports

      # Our own imports

      #-----------------------------------------------------------------------------

      # Globals and constants

      #-----------------------------------------------------------------------------

      #-----------------------------------------------------------------------------

      # Local utilities

      #-----------------------------------------------------------------------------

      #-----------------------------------------------------------------------------

      # Classes and functions

      #-----------------------------------------------------------------------------

      def find_mod(module_name):

          """

          Find module `module_name` on sys.path, and return the path to module `module_name`.

            - If `module_name` refers to a module directory, then return path to __init__ file.

              - If `module_name` is a directory without an __init__file, return None.

            - If module is missing or does not have a `.py` or `.pyw` extension, return None.

              - Note that we are not interested in running bytecode.

            - Otherwise, return the fill path of the module.

          Parameters

          ----------

          module_name : str

          Returns

          -------

          module_path : str

              Path to module `module_name`, its __init__.py, or None,

              depending on above conditions.

          """

          spec = importlib.util.find_spec(module_name)

          module_path = spec.origin

          if module_path is None:

              if spec.loader in sys.meta_path:

                  return spec.loader

              return None

          else:

              split_path = module_path.split(".")

              if split_path[-1] in ["py", "pyw"]:

                  return module_path

              else:

                  return None

	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

				"""Utility functions for finding modules

				Utility functions for finding modules on sys.path.

				"""
				#-----------------------------------------------------------------------------
				# Copyright (c) 2011, the IPython Development Team.
				#
				# Distributed under the terms of the Modified BSD License.
				#
				# The full license is in the file COPYING.txt, distributed with this software.
				#-----------------------------------------------------------------------------

				#-----------------------------------------------------------------------------
				# Imports
				#-----------------------------------------------------------------------------

				# Stdlib imports
				import importlib
				import sys

				# Third-party imports

				# Our own imports


				#-----------------------------------------------------------------------------
				# Globals and constants
				#-----------------------------------------------------------------------------

				#-----------------------------------------------------------------------------
				# Local utilities
				#-----------------------------------------------------------------------------

				#-----------------------------------------------------------------------------
				# Classes and functions
				#-----------------------------------------------------------------------------

				def find_mod(module_name):
				"""
				Find module `module_name` on sys.path, and return the path to module `module_name`.

				- If `module_name` refers to a module directory, then return path to __init__ file.
				- If `module_name` is a directory without an __init__file, return None.
				- If module is missing or does not have a `.py` or `.pyw` extension, return None.
				- Note that we are not interested in running bytecode.
				- Otherwise, return the fill path of the module.

				Parameters
				----------
				module_name : str

				Returns
				-------
				module_path : str
				Path to module `module_name`, its __init__.py, or None,
				depending on above conditions.
				"""
				spec = importlib.util.find_spec(module_name)
				module_path = spec.origin
				if module_path is None:
				if spec.loader in sys.meta_path:
				return spec.loader
				return None
				else:
				split_path = module_path.split(".")
				if split_path[-1] in ["py", "pyw"]:
				return module_path
				else:
				return None