Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Re: DBI trace has limited output

by kcott (Bishop)
on Oct 23, 2021 at 18:34 UTC ( #11137922=note: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    SQL - trace SQL statements executed
          (not yet implemented in DBI but implemented in some DBDs)
    
  2. or download this
    $ sqlite3 pm_11137916_anon
    SQLite version 3.34.0 2020-12-01 16:14:00
    ...
    5|Jupiter|gas
    9|Pluto|dwarf
    sqlite>
    
  3. or download this
    #!/usr/bin/env perl
    
    ...
    my $dbh = DBI->connect('dbi:SQLite:dbname=pm_11137916_anon');
    
    print join('|', @$_), "\n" for $dbh->selectall_array('select * from Pl
    +anet');
    
  4. or download this
    $ ./trace_none.pl
    3|Earth|rock
    5|Jupiter|gas
    9|Pluto|dwarf
    
  5. or download this
    $ ls -al *.out
    -rw-r--r-- 1 ken None  1839 Oct 24 03:50 trace_dbi_1.out
    ...
    -rw-r--r-- 1 ken None  6570 Oct 24 03:45 trace_dbi_4_sql.out
    -rw-r--r-- 1 ken None 10574 Oct 24 04:02 trace_dbi_5.out
    -rw-r--r-- 1 ken None 10632 Oct 24 04:03 trace_dbi_5_sql.out
    

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://11137922]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (2)
As of 2022-05-21 00:47 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Do you prefer to work remotely?



    Results (76 votes). Check out past polls.

    Notices?