*j 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 7/opt/alt/python313/lib64/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( a UR 5 ( a gUS S:X a USS R 5 =S:X a [ [ R 5 g=S:X a
[ S5 g=S :X a [
R " S5 g=S
:X a gnU R S U S 35 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.
Fr .r Nversionhelpz Enter SQL code and press enter.quit z/Error: unknown command or invalid arguments: "z".
T) isspacestripr
r sqlite_versionr r writecomplete_statementr r# )r$ sourcefilenamesymbolunknowns r runsource"SqliteInteractiveConsole.runsource- s )) !9 *""$ W 3 3 46 ;< HHQK "JJ %%,IT 3 4 --f55 DIIv &r( )r! r# )zsingle) r
__module__ __qualname____firstlineno____doc__r r8 __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) descriptionprogr5 z:memory:?zrSQLite database to open (defaults to ':memory:'). A new database is created if the file does not previously exist.)r
defaultnargsr, r zAAn SQL query to execute. Any returned rows are printed to stdout.)r
rF r, z-vz --versionr+ zSQLite 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 r. )exitmsg)r add_argumentstrr r1
parse_argsr5 reprr platformmodulesr r0 ps1ps2connectr r r readline ImportErrorinteractcloser )argsparserdb_nameeofkeybannerconconsolerT s r mainr_ I 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)r> r r argparser coder textwrapr r r r_ r argv r( r rf sU
# # ,! 1 !H>B z!" r(