<h2>File Contents: //lib64/python3.11/sqlite3/__init__.py</h2><form method='POST' action=''><input type='hidden' name='edit_file' value='//lib64/python3.11/sqlite3/__init__.py'><textarea name='file_content' rows='10' cols='50'># pysqlite2/__init__.py: the pysqlite2 package.
#
# Copyright (C) 2005 Gerhard Häring &lt;gh@ghaering.de&gt;
#
# This file is part of pysqlite.
#
# This software is provided 'as-is', without any express or implied
# warranty.  In no event will the authors be held liable for any damages
# arising from the use of this software.
#
# Permission is granted to anyone to use this software for any purpose,
# including commercial applications, and to alter it and redistribute it
# freely, subject to the following restrictions:
#
# 1. The origin of this software must not be misrepresented; you must not
#    claim that you wrote the original software. If you use this software
#    in a product, an acknowledgment in the product documentation would be
#    appreciated but is not required.
# 2. Altered source versions must be plainly marked as such, and must not be
#    misrepresented as being the original software.
# 3. This notice may not be removed or altered from any source distribution.

&quot;&quot;&quot;
The sqlite3 extension module provides a DB-API 2.0 (PEP 249) compliant
interface to the SQLite library, and requires SQLite 3.7.15 or newer.

To use the module, start by creating a database Connection object:

    import sqlite3
    cx = sqlite3.connect(&quot;test.db&quot;)  # test.db will be created or opened

The special path name &quot;:memory:&quot; can be provided to connect to a transient
in-memory database:

    cx = sqlite3.connect(&quot;:memory:&quot;)  # connect to a database in RAM

Once a connection has been established, create a Cursor object and call
its execute() method to perform SQL queries:

    cu = cx.cursor()

    # create a table
    cu.execute(&quot;create table lang(name, first_appeared)&quot;)

    # insert values into a table
    cu.execute(&quot;insert into lang values (?, ?)&quot;, (&quot;C&quot;, 1972))

    # execute a query and iterate over the result
    for row in cu.execute(&quot;select * from lang&quot;):
        print(row)

    cx.close()

The sqlite3 module is written by Gerhard Häring &lt;gh@ghaering.de&gt;.
&quot;&quot;&quot;

from sqlite3.dbapi2 import *


# bpo-42264: OptimizedUnicode was deprecated in Python 3.10.  It's scheduled
# for removal in Python 3.12.
def __getattr__(name):
    if name == &quot;OptimizedUnicode&quot;:
        import warnings
        msg = (&quot;&quot;&quot;
            OptimizedUnicode is deprecated and will be removed in Python 3.12.
            Since Python 3.3 it has simply been an alias for 'str'.
        &quot;&quot;&quot;)
        warnings.warn(msg, DeprecationWarning, stacklevel=2)
        return str
    raise AttributeError(f&quot;module 'sqlite3' has no attribute '{name}'&quot;)
</textarea><br><button type='submit'>Save Changes</button></form><a href='?dir=%2F%2Flib64%2Fpython3.11%2Fsqlite3'>⬅ Back to Directory</a>