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

Paul Ivanov - - Load All Authors

File last commit:

r22963:2961b531


                r28168:9a5baf06

Download file

             colorable.py
        
                    25 lines
            
             | 786 B
            
                | text/x-python
            
             |
                PythonLexer
            
             / IPython / utils / colorable.py
          
                    History
                
                 |
                  Source
                 | Raw
                 |Copy content
                 |Copy permalink

        Matthias Bussonnier
    
Introduce some classes necessary fro Pygments refactor.

              r22109
            
      #*****************************************************************************

      # Copyright (C) 2016 The IPython Team <ipython-dev@scipy.org>

      #

      # Distributed under the terms of the BSD License.  The full license is in

      # the file COPYING, distributed as part of this software.

      #*****************************************************************************

      """

      Color managing related utilities

      """

      import pygments

      from traitlets.config import Configurable

      from traitlets import Unicode

        Matthias Bussonnier
    
Make everyone happy with a neutral colortheme by default.

              r22609
            
      available_themes = lambda : [s for s in pygments.styles.get_all_styles()]+['NoColor','LightBG','Linux', 'Neutral']

        Matthias Bussonnier
    
Introduce some classes necessary fro Pygments refactor.

              r22109
            
      class Colorable(Configurable):

          """

          A subclass of configurable for all the classes that have a `default_scheme`

          """

        Matthias Bussonnier
    
Start refactoring handling of color....

              r22911
            
          default_style=Unicode('LightBG').tag(config=True)

        Matthias Bussonnier
    
Introduce some classes necessary fro Pygments refactor.

              r22109

	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

Matthias Bussonnier Introduce some classes necessary fro Pygments refactor.	r22109	#*****************************************************************************
		# Copyright (C) 2016 The IPython Team <ipython-dev@scipy.org>
		#
		# Distributed under the terms of the BSD License. The full license is in
		# the file COPYING, distributed as part of this software.
		#*****************************************************************************

		"""
		Color managing related utilities
		"""

		import pygments

		from traitlets.config import Configurable
		from traitlets import Unicode


Matthias Bussonnier Make everyone happy with a neutral colortheme by default.	r22609	available_themes = lambda : [s for s in pygments.styles.get_all_styles()]+['NoColor','LightBG','Linux', 'Neutral']
Matthias Bussonnier Introduce some classes necessary fro Pygments refactor.	r22109
		class Colorable(Configurable):
		"""
		A subclass of configurable for all the classes that have a `default_scheme`
		"""
Matthias Bussonnier Start refactoring handling of color....	r22911	default_style=Unicode('LightBG').tag(config=True)
Matthias Bussonnier Introduce some classes necessary fro Pygments refactor.	r22109