+
Bi R t ^ RIt^ RIt^ RIHt ^ RIHt ^ RIHt R R lt ! R R]4 t
R t ] R 8X d ] ! ]P R
, 4 R# R# ) 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 V P V4 F p\ V4 K R# \ P d p\ T4 P
p \ T RTP RT 2\ P R7 M1 \ d$ \ T RT 2\ P R7 Mi ; iT' g \ P ! ^4 Rp?R# Rp?R# Rp?ii ; i)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.14/sqlite3/__main__.pyr r s
99S>C #J " ==
!W
1 RD1--.c!5CJJ G 1 RD1#,SZZ 0 1 HHQKK
s> #' C C-B ?C +B.+C-B..
C9CC c @ a a ] tR t^%t oRtV 3R ltRR ltRtVtV ;t # )SqliteInteractiveConsolezA simple SQLite REPL.c Z < \ SV ` 4 Wn VP 4 V n R # )N)super__init___concursor_cur)self
connection __class__s &&r r !SqliteInteractiveConsole.__init__( s#
%%' c V' d VP 4 ' d R# V^ , R8X d VR, P 4 ;R8X d \ \ P 4 R# ;R8X d \ R4 R# ;R8X d \
P ! ^ 4 R# ;R8X d R# pV P R V R
24 R# \ P ! V4 ' g R # \ V P V4 R# ) zOverride runsource, the core of the InteractiveConsole REPL.
Return True if more input is needed; buffering is done automatically.
Return False if input is a complete statement ready for execution.
F. NNversionhelpz 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 r7 __static_attributes____classdictcell__
__classcell__)r#
__classdict__s @@r r r % s (
r% r c \ R RR7 pVP R\ RRRR7 VP R\ RR R
7 VP R R R
R\ P 2RR7 VP
! V ! p V P R8X d RpM\ V P 4 p\ P R8X d R\ P 9 d RpMRp\ R\ P RV RV R24 P 4 pR\ n
R\ n \ P ! V P R R 7 p V P ' d \# WPP R R 7 M#\% V4 p ^ R IpVP+ VR R!7 VP- 4 \ P. ! ^ 4 R # \( d LHi ; i TP- 4 i ; i)"zPython sqlite3 CLIT) descriptioncolorr4 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 rG 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 ... N)isolation_levelF)r r- )exitmsg)r add_argumentstrr r0
parse_argsr4 reprr platformmodulesr r/ ps1ps2connectr r r readline ImportErrorinteractcloser )argsparserdb_nameeofkeybannerconconsolerU 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
888 C5 9 /s3G
VR 0 HHQK
s0 :5G 0F/ 4G / F=:G <F==G G__main__r( )T)r= r r argparser coder textwrapr r r r` r argv r% r rg sS
# # ,! 1 !H>B z" r%