F\hu S r SSKrSSKrSSKJr SSKJr SSKJr S S jr " S S\5 r
S r \ S
:X a \ " \R S S 5 gg)
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 U R U5 H n[ U5 M g! [ R a n[ U5 R
n [ U SUR SU 3[ R S9 O-! [ a [ U SU 3[ R S9 Of = fU( d [ R " S5 SnAg SnAgSnAff = f)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.13/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%% CCc 6 ^ \ rS rSrSrU 4S jrSS jrSrU =r$ )SqliteInteractiveConsole% zA simple SQLite REPL.c X > [ TU ] 5 Xl UR 5 U l g )N)super__init___concursor_cur)self
connection __class__s r r !SqliteInteractiveConsole.__init__( s#
%%' c U=S:X a [ [ R 5 g=S:X a
[ S5 gS:X a [ R " S5 g [ R
" U5 ( d g[
U R U5 g)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 runsource"SqliteInteractiveConsole.runsource- sr //02 78
11&99 6*r( )r! r# )zsingle) r
__module__ __qualname____firstlineno____doc__r r/ __static_attributes__
__classcell__)r& s @r r r % s (
r( r c r [ SSS9nUR S[ SSSS9 UR S [ SS
S 9 UR S S
SS[ R 3SS9 UR
" U 6 n U R S:X a SnO[ U R 5 n[ R S:X a S[ R ; a SnOSn[ S[ R SU SU S35 R 5 nS[ l
S [ l [ R " U R S S 9n U R ( a [# XPR S S 9 O [% U5 n S S KnUR+ US!S"9 UR- 5 [ R. " S 5 g ! [( a NCf = f! UR- 5 f = f)#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
r= r> z-vz --versionversionzSQLite version z'Print underlying SQLite library version)actionr? r> 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 r )exitmsg)r add_argumentstrr r*
parse_argsr- reprr platformmodulesr stripps1ps2connectr r r readline ImportErrorinteractcloser )argsparserdb_nameeofkeybannerconconsolerO s r mainrZ A s
(
F j
O
Cs
7 k)!'"8"8!9:
6
d #D }}
"2t}}% ||w = #C
2292H2H1I J Y < =C8 D
CGCG
//$--
>C
88 C5 9 /s3G
VR 0 HHQK
s0 '1F$ F F$
F! F$ F!!F$ $F6__main__r )T)r5 r r argparser coder textwrapr r r rZ r argv r( r ra sT
# # , 1 8>B z!" r(