6' d Z ddlZddlZddlmZ ddlmZ ddlmZ d dZ G d de Z
d Z e d
k( r e ej d d yy)
zA simple SQLite CLI for the sqlite3 module.
Apart from using 'argparse' for the command-line interface,
this module implements the REPL as a thin wrapper around
the InteractiveConsole class from the 'code' stdlib module.
N)ArgumentParser)InteractiveConsole)dedentc | j | D ]
}t | y# t j $ r}t | j
} t | d|j d| t j n/# t $ r# t | d| t j Y nw xY w|st j d Y d}~yY d}~yd}~ww xY w)zHelper that wraps execution of SQL code.
This is used both by the REPL and by direct execution from the CLI.
'c' may be a cursor or a connection.
'sql' is the SQL string to execute.
z (z): )filez: N) executeprintsqlite3Errortype__name__sqlite_errornamesysstderrAttributeErrorexit)csqlsuppress_errorsrowetps '/usr/lib/python3.12/sqlite3/__main__.pyr r s
99S>C #J " ==
!W
1 RD1--.c!5CJJ G 1 RD1#,SZZ 0 1 HHQKK
s8 !$ CC
-A;:C ;)B'$C &B''C Cc * e Zd ZdZ fdZddZ xZS )SqliteInteractiveConsolezA simple SQLite REPL.c Z t | || _ |j | _ y )N)super__init___concursor_cur)self
connection __class__s r r z!SqliteInteractiveConsole.__init__( s%
%%' c |xdk( r t t j yxdk( r
t d ydk( rt j d y t j
| syt
| j | y)zOverride runsource, the core of the InteractiveConsole REPL.
Return True if more input is needed; buffering is done automatically.
Return False is input is a complete statement ready for execution.
z.versionz.helpz Enter SQL code and press enter.z.quitr TF)r
r sqlite_versionr r complete_statementr r" )r# sourcefilenamesymbols r runsourcez"SqliteInteractiveConsole.runsource- so //02 78
11&9 6*r& )zsingle)r
__module__ __qualname____doc__r r-
__classcell__)r% s @r r r % s (
r& r c ^ t dd }|j dt ddd |j d t dd
|j d d
ddt j d |j
| } | j dk( rd}nt | j }t j dk( rdt j vrd}nd}t dt j d| d| d j }dt _
d t _ t j | j d } | j rt# || j d n t% | }|j' |d ! |j) t j* d" y # |j) w xY w)#NzPython sqlite3 CLIzpython -m sqlite3) descriptionprogr+ z:memory:?zrSQLite database to open (defaults to ':memory:'). A new database is created if the file does not previously exist.)r
defaultnargshelpr zAAn SQL query to execute. Any returned rows are printed to stdout.)r
r8 r9 z-vz --versionversionzSQLite version z'Print underlying SQLite library version)actionr: r9 z a transient in-memory databasewin32z idlelib.runzCTRL-ZzCTRL-Dz2
sqlite3 shell, running on SQLite version z
Connected to z}
Each command will be run using execute() on the cursor.
Type ".help" for more information; type ".quit" or z to quit.
zsqlite> z ... )isolation_levelF)r )exitmsgr )r add_argumentstrr r(
parse_argsr+ reprr platformmodulesr stripps1ps2connectr r r interactcloser )argsparserdb_nameeofkeybannerconconsoles r mainrS A s
(
F j
O
Cs
7 k)!'"8"8!9:
6
6 d #D }}
"2t}}% ||w = #C
2292H2H1I J Y < =C8 D
CGCG
//$--
>C 88 C5 9 /s3G VR 0 HHQK s
1AF F,__main__r )T)r1 r r argparser coder textwrapr r r rS r argv r& r rZ sT
# # , 1 8:z z!" r&