| Commit | Line | Data |
|---|
| 8e30e889 |
1 | <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
| 2 | <html xmlns="http://www.w3.org/1999/xhtml"> |
| 3 | <!-- |
| 4 | This file was generated by Devel::NYTProf version 4.06 |
| 5 | --> |
| 6 | <head> |
| 7 | <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> |
| 8 | <meta http-equiv="Content-Language" content="en-us" /> |
| 9 | <title>Profile of DBD/SQLite.pm</title> |
| 10 | <link rel="stylesheet" type="text/css" href="style.css" /> |
| 11 | <script type="text/javascript" src="js/jquery-min.js"></script> |
| 12 | |
| 13 | <script type="text/javascript" src="js/jquery-tablesorter-min.js"></script> |
| 14 | <link rel="stylesheet" type="text/css" href="js/style-tablesorter.css" /> |
| 15 | <script type="text/javascript"> |
| 16 | // when a column is first clicked on to sort it, use descending order |
| 17 | // XXX doesn't seem to work (and not just because the tablesorter formatSortingOrder() is broken) |
| 18 | $.tablesorter.defaults.sortInitialOrder = "desc"; |
| 19 | // add parser through the tablesorter addParser method |
| 20 | $.tablesorter.addParser({ |
| 21 | id: 'fmt_time', // name of this parser |
| 22 | is: function(s) { |
| 23 | return false; // return false so this parser is not auto detected |
| 24 | }, |
| 25 | format: function(orig) { // format data for normalization |
| 26 | // console.log(orig); |
| 27 | val = orig.replace(/ns/,''); |
| 28 | if (val != orig) { return val / (1000*1000*1000); } |
| 29 | val = orig.replace(/µs/,''); /* XXX use µ ? */ |
| 30 | if (val != orig) { return val / (1000*1000); } |
| 31 | var val = orig.replace(/ms/,''); |
| 32 | if (val != orig) { return val / (1000); } |
| 33 | var val = orig.replace(/s/,''); |
| 34 | if (val != orig) { return val; } |
| 35 | if (orig == '0') { return orig; } |
| 36 | console.log('no match for fmt_time of '.concat(orig)); |
| 37 | return orig; |
| 38 | }, |
| 39 | type: 'numeric' // set type, either numeric or text |
| 40 | }); |
| 41 | </script> |
| 42 | </head> |
| 43 | |
| 44 | <body > |
| 45 | <div class="header" style="position: relative; overflow-x: hidden; overflow-y: hidden; z-index: 0; "> |
| 46 | <div class="header_back"> |
| 47 | <a href="index.html">← Index</a> |
| 48 | </div> |
| 49 | <div class="headerForeground" style="float: left"> |
| 50 | <span class="siteTitle">NYTProf Performance Profile</span> |
| 51 | <span class="siteSubtitle">  <span>« <span class="mode_btn"><a href="DBD-SQLite-pm-2618-block.html">block view</a></span> • <span class="mode_btn mode_btn_selected">line view</span> • <span class="mode_btn"><a href="DBD-SQLite-pm-2618-sub.html">sub view</a></span> »</span><br /> |
| 52 | For script/nytprof.pl |
| 53 | </span> |
| 54 | </div> |
| 55 | <div class="headerForeground" style="float: right; text-align: right"> |
| 56 | <span class="siteTitle"> </span> |
| 57 | <span class="siteSubtitle">Run on Thu May 31 16:49:15 2012<br />Reported on Thu May 31 16:56:42 2012</span> |
| 58 | </div> |
| 59 | <div style="position: absolute; left: 0px; top: 0%; width: 100%; height: 101%; z-index: -1; background-color: rgb(17, 136, 255); "></div> |
| 60 | <div style="position: absolute; left: 0px; top: 2%; width: 100%; height: 99%; z-index: -1; background-color: rgb(16, 134, 253); "></div> |
| 61 | <div style="position: absolute; left: 0px; top: 4%; width: 100%; height: 97%; z-index: -1; background-color: rgb(16, 133, 252); "></div> |
| 62 | <div style="position: absolute; left: 0px; top: 6%; width: 100%; height: 95%; z-index: -1; background-color: rgb(15, 131, 250); "></div> |
| 63 | <div style="position: absolute; left: 0px; top: 8%; width: 100%; height: 93%; z-index: -1; background-color: rgb(15, 130, 249); "></div> |
| 64 | <div style="position: absolute; left: 0px; top: 10%; width: 100%; height: 91%; z-index: -1; background-color: rgb(15, 129, 248); "></div> |
| 65 | <div style="position: absolute; left: 0px; top: 12%; width: 100%; height: 89%; z-index: -1; background-color: rgb(14, 127, 246); "></div> |
| 66 | <div style="position: absolute; left: 0px; top: 14%; width: 100%; height: 87%; z-index: -1; background-color: rgb(14, 126, 245); "></div> |
| 67 | <div style="position: absolute; left: 0px; top: 16%; width: 100%; height: 85%; z-index: -1; background-color: rgb(14, 125, 244); "></div> |
| 68 | <div style="position: absolute; left: 0px; top: 18%; width: 100%; height: 83%; z-index: -1; background-color: rgb(13, 123, 242); "></div> |
| 69 | <div style="position: absolute; left: 0px; top: 20%; width: 100%; height: 81%; z-index: -1; background-color: rgb(13, 122, 241); "></div> |
| 70 | <div style="position: absolute; left: 0px; top: 22%; width: 100%; height: 79%; z-index: -1; background-color: rgb(13, 121, 240); "></div> |
| 71 | <div style="position: absolute; left: 0px; top: 24%; width: 100%; height: 77%; z-index: -1; background-color: rgb(12, 119, 238); "></div> |
| 72 | <div style="position: absolute; left: 0px; top: 26%; width: 100%; height: 75%; z-index: -1; background-color: rgb(12, 118, 237); "></div> |
| 73 | <div style="position: absolute; left: 0px; top: 28%; width: 100%; height: 73%; z-index: -1; background-color: rgb(12, 116, 235); "></div> |
| 74 | <div style="position: absolute; left: 0px; top: 30%; width: 100%; height: 71%; z-index: -1; background-color: rgb(11, 115, 234); "></div> |
| 75 | <div style="position: absolute; left: 0px; top: 32%; width: 100%; height: 69%; z-index: -1; background-color: rgb(11, 114, 233); "></div> |
| 76 | <div style="position: absolute; left: 0px; top: 34%; width: 100%; height: 67%; z-index: -1; background-color: rgb(11, 112, 231); "></div> |
| 77 | <div style="position: absolute; left: 0px; top: 36%; width: 100%; height: 65%; z-index: -1; background-color: rgb(10, 111, 230); "></div> |
| 78 | <div style="position: absolute; left: 0px; top: 38%; width: 100%; height: 63%; z-index: -1; background-color: rgb(10, 110, 229); "></div> |
| 79 | <div style="position: absolute; left: 0px; top: 40%; width: 100%; height: 61%; z-index: -1; background-color: rgb(10, 108, 227); "></div> |
| 80 | <div style="position: absolute; left: 0px; top: 42%; width: 100%; height: 59%; z-index: -1; background-color: rgb(9, 107, 226); "></div> |
| 81 | <div style="position: absolute; left: 0px; top: 44%; width: 100%; height: 57%; z-index: -1; background-color: rgb(9, 106, 225); "></div> |
| 82 | <div style="position: absolute; left: 0px; top: 46%; width: 100%; height: 55%; z-index: -1; background-color: rgb(9, 104, 223); "></div> |
| 83 | <div style="position: absolute; left: 0px; top: 48%; width: 100%; height: 53%; z-index: -1; background-color: rgb(8, 103, 222); "></div> |
| 84 | <div style="position: absolute; left: 0px; top: 50%; width: 100%; height: 51%; z-index: -1; background-color: rgb(8, 102, 221); "></div> |
| 85 | <div style="position: absolute; left: 0px; top: 52%; width: 100%; height: 49%; z-index: -1; background-color: rgb(8, 100, 219); "></div> |
| 86 | <div style="position: absolute; left: 0px; top: 54%; width: 100%; height: 47%; z-index: -1; background-color: rgb(7, 99, 218); "></div> |
| 87 | <div style="position: absolute; left: 0px; top: 56%; width: 100%; height: 45%; z-index: -1; background-color: rgb(7, 97, 216); "></div> |
| 88 | <div style="position: absolute; left: 0px; top: 58%; width: 100%; height: 43%; z-index: -1; background-color: rgb(7, 96, 215); "></div> |
| 89 | <div style="position: absolute; left: 0px; top: 60%; width: 100%; height: 41%; z-index: -1; background-color: rgb(6, 95, 214); "></div> |
| 90 | <div style="position: absolute; left: 0px; top: 62%; width: 100%; height: 39%; z-index: -1; background-color: rgb(6, 93, 212); "></div> |
| 91 | <div style="position: absolute; left: 0px; top: 64%; width: 100%; height: 37%; z-index: -1; background-color: rgb(6, 92, 211); "></div> |
| 92 | <div style="position: absolute; left: 0px; top: 66%; width: 100%; height: 35%; z-index: -1; background-color: rgb(5, 91, 210); "></div> |
| 93 | <div style="position: absolute; left: 0px; top: 68%; width: 100%; height: 33%; z-index: -1; background-color: rgb(5, 89, 208); "></div> |
| 94 | <div style="position: absolute; left: 0px; top: 70%; width: 100%; height: 31%; z-index: -1; background-color: rgb(5, 88, 207); "></div> |
| 95 | <div style="position: absolute; left: 0px; top: 72%; width: 100%; height: 29%; z-index: -1; background-color: rgb(4, 87, 206); "></div> |
| 96 | <div style="position: absolute; left: 0px; top: 74%; width: 100%; height: 27%; z-index: -1; background-color: rgb(4, 85, 204); "></div> |
| 97 | <div style="position: absolute; left: 0px; top: 76%; width: 100%; height: 25%; z-index: -1; background-color: rgb(4, 84, 203); "></div> |
| 98 | <div style="position: absolute; left: 0px; top: 78%; width: 100%; height: 23%; z-index: -1; background-color: rgb(3, 82, 201); "></div> |
| 99 | <div style="position: absolute; left: 0px; top: 80%; width: 100%; height: 21%; z-index: -1; background-color: rgb(3, 81, 200); "></div> |
| 100 | <div style="position: absolute; left: 0px; top: 82%; width: 100%; height: 19%; z-index: -1; background-color: rgb(3, 80, 199); "></div> |
| 101 | <div style="position: absolute; left: 0px; top: 84%; width: 100%; height: 17%; z-index: -1; background-color: rgb(2, 78, 197); "></div> |
| 102 | <div style="position: absolute; left: 0px; top: 86%; width: 100%; height: 15%; z-index: -1; background-color: rgb(2, 77, 196); "></div> |
| 103 | <div style="position: absolute; left: 0px; top: 88%; width: 100%; height: 13%; z-index: -1; background-color: rgb(2, 76, 195); "></div> |
| 104 | <div style="position: absolute; left: 0px; top: 90%; width: 100%; height: 11%; z-index: -1; background-color: rgb(1, 74, 193); "></div> |
| 105 | <div style="position: absolute; left: 0px; top: 92%; width: 100%; height: 9%; z-index: -1; background-color: rgb(1, 73, 192); "></div> |
| 106 | <div style="position: absolute; left: 0px; top: 94%; width: 100%; height: 7%; z-index: -1; background-color: rgb(1, 72, 191); "></div> |
| 107 | <div style="position: absolute; left: 0px; top: 96%; width: 100%; height: 5%; z-index: -1; background-color: rgb(0, 70, 189); "></div> |
| 108 | <div style="position: absolute; left: 0px; top: 98%; width: 100%; height: 3%; z-index: -1; background-color: rgb(0, 69, 188); "></div> |
| 109 | <div style="position: absolute; left: 0px; top: 100%; width: 100%; height: 1%; z-index: -1; background-color: rgb(0, 68, 187); "></div> |
| 110 | </div> |
| 111 | |
| 112 | <div class="body_content"><br /> |
| 113 | <table class="file_summary"><tr><td class="h">Filename</td><td align="left"><a href="file:///Users/edenc/perl5/lib/perl5/darwin-multi-2level/DBD/SQLite.pm">/Users/edenc/perl5/lib/perl5/darwin-multi-2level/DBD/SQLite.pm</a></td></tr> |
| 114 | <tr><td class="h">Statements</td><td align="left">Executed 89 statements in 77.3ms</td></tr></table> |
| 115 | |
| 116 | <table id="subs_table" border="1" cellpadding="0" class="tablesorter"> |
| 117 | <caption>Subroutines</caption> |
| 118 | <thead> |
| 119 | <tr> |
| 120 | <th>Calls</th> |
| 121 | <th><span title="Number of Places sub is called from">P</span></th> |
| 122 | <th><span title="Number of Files sub is called from">F</span></th> |
| 123 | <th>Exclusive<br />Time</th> |
| 124 | <th>Inclusive<br />Time</th> |
| 125 | <th>Subroutine</th> |
| 126 | </tr> |
| 127 | </thead> |
| 128 | <tbody> |
| 129 | <tr><td class="c3">1</td><td class="c3">1</td><td class="c3">1</td><td class="c0"><span title="0.2%">73.7ms</span></td><td class="c0"><span title="0.2%">73.7ms</span></td><td class="sub_name"><span style="display: none;">DBD::SQLite::db::::_login</span> DBD::SQLite::db::<a href="DBD-SQLite-pm-2618-line.html#DBD__SQLite__db___login">_login</a> (xsub)</span></td></tr> |
| 130 | <tr><td class="c3">1</td><td class="c3">1</td><td class="c3">1</td><td class="c0"><span title="0.0%">209µs</span></td><td class="c0"><span title="0.0%">209µs</span></td><td class="sub_name"><span style="display: none;">DBD::SQLite::::bootstrap</span> DBD::SQLite::<a href="DBD-SQLite-pm-2618-line.html#DBD__SQLite__bootstrap">bootstrap</a> (xsub)</span></td></tr> |
| 131 | <tr><td class="c3">1</td><td class="c3">1</td><td class="c3">1</td><td class="c0"><span title="0.0%">108µs</span></td><td class="c0"><span title="0.2%">74.0ms</span></td><td class="sub_name"><span style="display: none;">DBD::SQLite::dr::::connect</span> DBD::SQLite::dr::<a href="DBD-SQLite-pm-2618-line.html#79">connect</a></span></td></tr> |
| 132 | <tr><td class="c3">1</td><td class="c3">1</td><td class="c3">1</td><td class="c0"><span title="0.0%">75µs</span></td><td class="c0"><span title="0.0%">488µs</span></td><td class="sub_name"><span style="display: none;">DBD::SQLite::::driver</span> DBD::SQLite::<a href="DBD-SQLite-pm-2618-line.html#38">driver</a></span></td></tr> |
| 133 | <tr><td class="c1">2</td><td class="c3">1</td><td class="c3">1</td><td class="c0"><span title="0.0%">34µs</span></td><td class="c0"><span title="0.0%">432µs</span></td><td class="sub_name"><span style="display: none;">DBD::SQLite::db::::prepare</span> DBD::SQLite::db::<a href="DBD-SQLite-pm-2618-line.html#185">prepare</a></span></td></tr> |
| 134 | <tr><td class="c3">1</td><td class="c3">1</td><td class="c3">1</td><td class="c0"><span title="0.0%">26µs</span></td><td class="c3"><span title="0.0%">26µs</span></td><td class="sub_name"><span style="display: none;">DBD::SQLite::::BEGIN@3</span> DBD::SQLite::<a href="DBD-SQLite-pm-2618-line.html#3">BEGIN@3</a></span></td></tr> |
| 135 | <tr><td class="c3">1</td><td class="c3">1</td><td class="c3">1</td><td class="c0"><span title="0.0%">23µs</span></td><td class="c3"><span title="0.0%">35µs</span></td><td class="sub_name"><span style="display: none;">DBD::SQLite::::BEGIN@5</span> DBD::SQLite::<a href="DBD-SQLite-pm-2618-line.html#5">BEGIN@5</a></span></td></tr> |
| 136 | <tr><td class="c3">1</td><td class="c3">1</td><td class="c3">1</td><td class="c3"><span title="0.0%">11µs</span></td><td class="c1"><span title="0.0%">58µs</span></td><td class="sub_name"><span style="display: none;">DBD::SQLite::::BEGIN@30</span> DBD::SQLite::<a href="DBD-SQLite-pm-2618-line.html#30">BEGIN@30</a></span></td></tr> |
| 137 | <tr><td class="c3">1</td><td class="c3">1</td><td class="c3">1</td><td class="c3"><span title="0.0%">11µs</span></td><td class="c3"><span title="0.0%">11µs</span></td><td class="sub_name"><span style="display: none;">DBD::SQLite::::BEGIN@12</span> DBD::SQLite::<a href="DBD-SQLite-pm-2618-line.html#12">BEGIN@12</a></span></td></tr> |
| 138 | <tr><td class="c3">1</td><td class="c3">1</td><td class="c3">1</td><td class="c3"><span title="0.0%">10µs</span></td><td class="c3"><span title="0.0%">13µs</span></td><td class="sub_name"><span style="display: none;">DBD::SQLite::dr::::BEGIN@178</span> DBD::SQLite::dr::<a href="DBD-SQLite-pm-2618-line.html#178">BEGIN@178</a></span></td></tr> |
| 139 | <tr><td class="c3">1</td><td class="c3">1</td><td class="c3">1</td><td class="c3"><span title="0.0%">10µs</span></td><td class="c3"><span title="0.0%">13µs</span></td><td class="sub_name"><span style="display: none;">DBD::SQLite::::BEGIN@34</span> DBD::SQLite::<a href="DBD-SQLite-pm-2618-line.html#34">BEGIN@34</a></span></td></tr> |
| 140 | <tr><td class="c3">1</td><td class="c3">1</td><td class="c3">1</td><td class="c3"><span title="0.0%">10µs</span></td><td class="c3"><span title="0.0%">10µs</span></td><td class="sub_name"><span style="display: none;">DBD::SQLite::_WriteOnceHash::::TIEHASH</span>DBD::SQLite::_WriteOnceHash::<a href="DBD-SQLite-pm-2618-line.html#599">TIEHASH</a></span></td></tr> |
| 141 | <tr><td class="c3">1</td><td class="c3">1</td><td class="c3">1</td><td class="c3"><span title="0.0%">9µs</span></td><td class="c1"><span title="0.0%">49µs</span></td><td class="sub_name"><span style="display: none;">DBD::SQLite::::BEGIN@8</span> DBD::SQLite::<a href="DBD-SQLite-pm-2618-line.html#8">BEGIN@8</a></span></td></tr> |
| 142 | <tr><td class="c3">1</td><td class="c3">1</td><td class="c3">1</td><td class="c3"><span title="0.0%">9µs</span></td><td class="c3"><span title="0.0%">12µs</span></td><td class="sub_name"><span style="display: none;">DBD::SQLite::::BEGIN@4</span> DBD::SQLite::<a href="DBD-SQLite-pm-2618-line.html#4">BEGIN@4</a></span></td></tr> |
| 143 | <tr><td class="c3">1</td><td class="c3">1</td><td class="c3">1</td><td class="c3"><span title="0.0%">7µs</span></td><td class="c0"><span title="0.0%">72µs</span></td><td class="sub_name"><span style="display: none;">DBD::SQLite::::BEGIN@9</span> DBD::SQLite::<a href="DBD-SQLite-pm-2618-line.html#9">BEGIN@9</a></span></td></tr> |
| 144 | <tr><td class="c3">1</td><td class="c3">1</td><td class="c3">1</td><td class="c3"><span title="0.0%">7µs</span></td><td class="c3"><span title="0.0%">26µs</span></td><td class="sub_name"><span style="display: none;">DBD::SQLite::::BEGIN@10</span> DBD::SQLite::<a href="DBD-SQLite-pm-2618-line.html#10">BEGIN@10</a></span></td></tr> |
| 145 | <tr><td class="c1">2</td><td class="c1">2</td><td class="c3">1</td><td class="c3"><span title="0.0%">6µs</span></td><td class="c3"><span title="0.0%">6µs</span></td><td class="sub_name"><span style="display: none;">DBD::SQLite::_WriteOnceHash::::STORE</span>DBD::SQLite::_WriteOnceHash::<a href="DBD-SQLite-pm-2618-line.html#603">STORE</a></span></td></tr> |
| 146 | <tr><td class="c0">3</td><td class="c0">3</td><td class="c3">1</td><td class="c3"><span title="0.0%">5µs</span></td><td class="c3"><span title="0.0%">5µs</span></td><td class="sub_name"><span style="display: none;">DBD::SQLite::dr::::CORE:match</span> DBD::SQLite::dr::<a href="DBD-SQLite-pm-2618-line.html#DBD__SQLite__dr__CORE_match">CORE:match</a> (opcode)</span></td></tr> |
| 147 | <tr><td class="c3">1</td><td class="c3">1</td><td class="c3">1</td><td class="c3"><span title="0.0%">4µs</span></td><td class="c3"><span title="0.0%">4µs</span></td><td class="sub_name"><span style="display: none;">DBD::SQLite::::BEGIN@6</span> DBD::SQLite::<a href="DBD-SQLite-pm-2618-line.html#6">BEGIN@6</a></span></td></tr> |
| 148 | <tr><td class="c3">0</td><td class="c3">0</td><td class="c3">0</td><td class="c3"><span title="0.0%">0s</span></td><td class="c3"><span title="0.0%">0s</span></td><td class="sub_name"><span style="display: none;">DBD::SQLite::::CLONE</span> DBD::SQLite::<a href="DBD-SQLite-pm-2618-line.html#72">CLONE</a></span></td></tr> |
| 149 | <tr><td class="c3">0</td><td class="c3">0</td><td class="c3">0</td><td class="c3"><span title="0.0%">0s</span></td><td class="c3"><span title="0.0%">0s</span></td><td class="sub_name"><span style="display: none;">DBD::SQLite::_WriteOnceHash::::DELETE</span>DBD::SQLite::_WriteOnceHash::<a href="DBD-SQLite-pm-2618-line.html#608">DELETE</a></span></td></tr> |
| 150 | <tr><td class="c3">0</td><td class="c3">0</td><td class="c3">0</td><td class="c3"><span title="0.0%">0s</span></td><td class="c3"><span title="0.0%">0s</span></td><td class="sub_name"><span style="display: none;">DBD::SQLite::::__ANON__[:33]</span> DBD::SQLite::<a href="DBD-SQLite-pm-2618-line.html#33">__ANON__[:33]</a></span></td></tr> |
| 151 | <tr><td class="c3">0</td><td class="c3">0</td><td class="c3">0</td><td class="c3"><span title="0.0%">0s</span></td><td class="c3"><span title="0.0%">0s</span></td><td class="sub_name"><span style="display: none;">DBD::SQLite::::__ANON__[:34]</span> DBD::SQLite::<a href="DBD-SQLite-pm-2618-line.html#34">__ANON__[:34]</a></span></td></tr> |
| 152 | <tr><td class="c3">0</td><td class="c3">0</td><td class="c3">0</td><td class="c3"><span title="0.0%">0s</span></td><td class="c3"><span title="0.0%">0s</span></td><td class="sub_name"><span style="display: none;">DBD::SQLite::db::::_attached_database_list</span> DBD::SQLite::db::<a href="DBD-SQLite-pm-2618-line.html#235">_attached_database_list</a></span></td></tr> |
| 153 | <tr><td class="c3">0</td><td class="c3">0</td><td class="c3">0</td><td class="c3"><span title="0.0%">0s</span></td><td class="c3"><span title="0.0%">0s</span></td><td class="sub_name"><span style="display: none;">DBD::SQLite::db::::_get_version</span> DBD::SQLite::db::<a href="DBD-SQLite-pm-2618-line.html#218">_get_version</a></span></td></tr> |
| 154 | <tr><td class="c3">0</td><td class="c3">0</td><td class="c3">0</td><td class="c3"><span title="0.0%">0s</span></td><td class="c3"><span title="0.0%">0s</span></td><td class="sub_name"><span style="display: none;">DBD::SQLite::db::::column_info</span> DBD::SQLite::db::<a href="DBD-SQLite-pm-2618-line.html#480">column_info</a></span></td></tr> |
| 155 | <tr><td class="c3">0</td><td class="c3">0</td><td class="c3">0</td><td class="c3"><span title="0.0%">0s</span></td><td class="c3"><span title="0.0%">0s</span></td><td class="sub_name"><span style="display: none;">DBD::SQLite::db::::do</span> DBD::SQLite::db::<a href="DBD-SQLite-pm-2618-line.html#199">do</a></span></td></tr> |
| 156 | <tr><td class="c3">0</td><td class="c3">0</td><td class="c3">0</td><td class="c3"><span title="0.0%">0s</span></td><td class="c3"><span title="0.0%">0s</span></td><td class="sub_name"><span style="display: none;">DBD::SQLite::db::::get_info</span> DBD::SQLite::db::<a href="DBD-SQLite-pm-2618-line.html#228">get_info</a></span></td></tr> |
| 157 | <tr><td class="c3">0</td><td class="c3">0</td><td class="c3">0</td><td class="c3"><span title="0.0%">0s</span></td><td class="c3"><span title="0.0%">0s</span></td><td class="sub_name"><span style="display: none;">DBD::SQLite::db::::primary_key_info</span> DBD::SQLite::db::<a href="DBD-SQLite-pm-2618-line.html#366">primary_key_info</a></span></td></tr> |
| 158 | <tr><td class="c3">0</td><td class="c3">0</td><td class="c3">0</td><td class="c3"><span title="0.0%">0s</span></td><td class="c3"><span title="0.0%">0s</span></td><td class="sub_name"><span style="display: none;">DBD::SQLite::db::::table_info</span> DBD::SQLite::db::<a href="DBD-SQLite-pm-2618-line.html#250">table_info</a></span></td></tr> |
| 159 | <tr><td class="c3">0</td><td class="c3">0</td><td class="c3">0</td><td class="c3"><span title="0.0%">0s</span></td><td class="c3"><span title="0.0%">0s</span></td><td class="sub_name"><span style="display: none;">DBD::SQLite::db::::type_info_all</span> DBD::SQLite::db::<a href="DBD-SQLite-pm-2618-line.html#418">type_info_all</a></span></td></tr> |
| 160 | <tr><td class="c3">0</td><td class="c3">0</td><td class="c3">0</td><td class="c3"><span title="0.0%">0s</span></td><td class="c3"><span title="0.0%">0s</span></td><td class="sub_name"><span style="display: none;">DBD::SQLite::dr::::install_collation</span> DBD::SQLite::dr::<a href="DBD-SQLite-pm-2618-line.html#159">install_collation</a></span></td></tr> |
| 161 | <tr><td class="c3">0</td><td class="c3">0</td><td class="c3">0</td><td class="c3"><span title="0.0%">0s</span></td><td class="c3"><span title="0.0%">0s</span></td><td class="sub_name"><span style="display: none;">DBD::SQLite::dr::::regexp</span> DBD::SQLite::dr::<a href="DBD-SQLite-pm-2618-line.html#177">regexp</a></span></td></tr> |
| 162 | </tbody></table> |
| 163 | Call graph for these subroutines as a |
| 164 | <a href="http://en.wikipedia.org/wiki/Graphviz">Graphviz</a> |
| 165 | <a href="Users-edenc-perl5-lib-perl5-darwin-multi-2level-DBD-SQLite-pm.dot">dot language file</a>. |
| 166 | |
| 167 | <table border="1" cellpadding="0"> |
| 168 | <thead> |
| 169 | <tr><th>Line</th> |
| 170 | <th><span title="Number of statements executed">State<br />ments</span></th> |
| 171 | <th><span title="Time spend executing statements on the line, |
| 172 | excluding time spent executing statements in any called subroutines">Time<br />on line</span></th> |
| 173 | <th><span title="Number of subroutines calls">Calls</span></th> |
| 174 | <th><span title="Time spent in subroutines called (inclusive)">Time<br />in subs</span></th> |
| 175 | <th class="left_indent_header">Code</th> |
| 176 | </tr> |
| 177 | |
| 178 | </thead> |
| 179 | <tbody> |
| 180 | <tr><td class="h"><a name="1"></a>1</td><td></td><td></td><td></td><td></td><td class="s">package DBD::SQLite;</td></tr> |
| 181 | <tr><td class="h"><a name="2"></a>2</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 182 | <tr><td class="h"><a name="3"></a>3</td><td class="c1">2</td><td class="c0"><span title="Avg 26µs">52µs</span></td><td class="c3">1</td><td class="c2">26µs</td><td class="s"><div class="calls"><div class="calls_in"># spent 26µs within DBD::SQLite::BEGIN@3 which was called: |
| 183 | # once (26µs+0s) by DBI::install_driver at <a href="DBD-SQLite-pm-2618-line.html#3">line 3</a></div></div>use 5.006;<div class="calls"><div class="calls_out"># spent 26µs making 1 call to <a href="DBD-SQLite-pm-2618-line.html#3">DBD::SQLite::BEGIN@3</a></div></div></td></tr> |
| 184 | <tr><td class="h"><a name="4"></a>4</td><td class="c1">2</td><td class="c0"><span title="Avg 13µs">26µs</span></td><td class="c1">2</td><td class="c3">15µs</td><td class="s"><div class="calls"><div class="calls_in"># spent 12µs (9+3) within DBD::SQLite::BEGIN@4 which was called: |
| 185 | # once (9µs+3µs) by DBI::install_driver at <a href="DBD-SQLite-pm-2618-line.html#4">line 4</a></div></div>use strict;<div class="calls"><div class="calls_out"># spent 12µs making 1 call to <a href="DBD-SQLite-pm-2618-line.html#4">DBD::SQLite::BEGIN@4</a> |
| 186 | # spent 3µs making 1 call to <a href="strict-pm-3-line.html#34">strict::import</a></div></div></td></tr> |
| 187 | <tr><td class="h"><a name="5"></a>5</td><td class="c0">3</td><td class="c0"><span title="Avg 19µs">56µs</span></td><td class="c1">2</td><td class="c0">48µs</td><td class="s"><div class="calls"><div class="calls_in"># spent 35µs (23+12) within DBD::SQLite::BEGIN@5 which was called: |
| 188 | # once (23µs+12µs) by DBI::install_driver at <a href="DBD-SQLite-pm-2618-line.html#5">line 5</a></div></div>use DBI 1.57 ();<div class="calls"><div class="calls_out"># spent 35µs making 1 call to <a href="DBD-SQLite-pm-2618-line.html#5">DBD::SQLite::BEGIN@5</a> |
| 189 | # spent 12µs making 1 call to <a href="UNIVERSAL-pm-738-line.html#UNIVERSAL__VERSION">UNIVERSAL::VERSION</a></div></div></td></tr> |
| 190 | <tr><td class="h"><a name="6"></a>6</td><td class="c1">2</td><td class="c0"><span title="Avg 13µs">26µs</span></td><td class="c3">1</td><td class="c3">4µs</td><td class="s"><div class="calls"><div class="calls_in"># spent 4µs within DBD::SQLite::BEGIN@6 which was called: |
| 191 | # once (4µs+0s) by DBI::install_driver at <a href="DBD-SQLite-pm-2618-line.html#6">line 6</a></div></div>use DynaLoader ();<div class="calls"><div class="calls_out"># spent 4µs making 1 call to <a href="DBD-SQLite-pm-2618-line.html#6">DBD::SQLite::BEGIN@6</a></div></div></td></tr> |
| 192 | <tr><td class="h"><a name="7"></a>7</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 193 | <tr><td class="h"><a name="8"></a>8</td><td class="c1">2</td><td class="c0"><span title="Avg 17µs">35µs</span></td><td class="c1">2</td><td class="c0">90µs</td><td class="s"><div class="calls"><div class="calls_in"># spent 49µs (9+40) within DBD::SQLite::BEGIN@8 which was called: |
| 194 | # once (9µs+40µs) by DBI::install_driver at <a href="DBD-SQLite-pm-2618-line.html#8">line 8</a></div></div>use vars qw($VERSION @ISA);<div class="calls"><div class="calls_out"># spent 49µs making 1 call to <a href="DBD-SQLite-pm-2618-line.html#8">DBD::SQLite::BEGIN@8</a> |
| 195 | # spent 40µs making 1 call to <a href="vars-pm-6-line.html#10">vars::import</a></div></div></td></tr> |
| 196 | <tr><td class="h"><a name="9"></a>9</td><td class="c1">2</td><td class="c0"><span title="Avg 14µs">27µs</span></td><td class="c1">2</td><td class="c0">137µs</td><td class="s"><div class="calls"><div class="calls_in"># spent 72µs (7+65) within DBD::SQLite::BEGIN@9 which was called: |
| 197 | # once (7µs+65µs) by DBI::install_driver at <a href="DBD-SQLite-pm-2618-line.html#9">line 9</a></div></div>use vars qw{$err $errstr $drh $sqlite_version $sqlite_version_number};<div class="calls"><div class="calls_out"># spent 72µs making 1 call to <a href="DBD-SQLite-pm-2618-line.html#9">DBD::SQLite::BEGIN@9</a> |
| 198 | # spent 65µs making 1 call to <a href="vars-pm-6-line.html#10">vars::import</a></div></div></td></tr> |
| 199 | <tr><td class="h"><a name="10"></a>10</td><td class="c1">2</td><td class="c0"><span title="Avg 30µs">60µs</span></td><td class="c1">2</td><td class="c0">44µs</td><td class="s"><div class="calls"><div class="calls_in"># spent 26µs (7+18) within DBD::SQLite::BEGIN@10 which was called: |
| 200 | # once (7µs+18µs) by DBI::install_driver at <a href="DBD-SQLite-pm-2618-line.html#10">line 10</a></div></div>use vars qw{%COLLATION};<div class="calls"><div class="calls_out"># spent 26µs making 1 call to <a href="DBD-SQLite-pm-2618-line.html#10">DBD::SQLite::BEGIN@10</a> |
| 201 | # spent 18µs making 1 call to <a href="vars-pm-6-line.html#10">vars::import</a></div></div></td></tr> |
| 202 | <tr><td class="h"><a name="11"></a>11</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 203 | <tr><td class="h"><a name="12"></a>12</td><td></td><td></td><td></td><td></td><td class="s"><div class="calls"><div class="calls_in"># spent 11µs within DBD::SQLite::BEGIN@12 which was called: |
| 204 | # once (11µs+0s) by DBI::install_driver at <a href="DBD-SQLite-pm-2618-line.html#25">line 25</a></div></div>BEGIN {</td></tr> |
| 205 | <tr><td class="h"><a name="13"></a>13</td><td class="c3">1</td><td class="c3"><span title="Avg 500ns">500ns</span></td><td></td><td></td><td class="s"> $VERSION = '1.35';</td></tr> |
| 206 | <tr><td class="h"><a name="14"></a>14</td><td class="c3">1</td><td class="c2"><span title="Avg 6µs">6µs</span></td><td></td><td></td><td class="s"> @ISA = 'DynaLoader';</td></tr> |
| 207 | <tr><td class="h"><a name="15"></a>15</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 208 | <tr><td class="h"><a name="16"></a>16</td><td></td><td></td><td></td><td></td><td class="s"> # Initialize errors</td></tr> |
| 209 | <tr><td class="h"><a name="17"></a>17</td><td class="c3">1</td><td class="c3"><span title="Avg 200ns">200ns</span></td><td></td><td></td><td class="s"> $err = undef;</td></tr> |
| 210 | <tr><td class="h"><a name="18"></a>18</td><td class="c3">1</td><td class="c3"><span title="Avg 100ns">100ns</span></td><td></td><td></td><td class="s"> $errstr = undef;</td></tr> |
| 211 | <tr><td class="h"><a name="19"></a>19</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 212 | <tr><td class="h"><a name="20"></a>20</td><td></td><td></td><td></td><td></td><td class="s"> # Driver singleton</td></tr> |
| 213 | <tr><td class="h"><a name="21"></a>21</td><td class="c3">1</td><td class="c3"><span title="Avg 100ns">100ns</span></td><td></td><td></td><td class="s"> $drh = undef;</td></tr> |
| 214 | <tr><td class="h"><a name="22"></a>22</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 215 | <tr><td class="h"><a name="23"></a>23</td><td></td><td></td><td></td><td></td><td class="s"> # sqlite_version cache</td></tr> |
| 216 | <tr><td class="h"><a name="24"></a>24</td><td class="c3">1</td><td class="c3"><span title="Avg 4µs">4µs</span></td><td></td><td></td><td class="s"> $sqlite_version = undef;</td></tr> |
| 217 | <tr><td class="h"><a name="25"></a>25</td><td class="c3">1</td><td class="c0"><span title="Avg 37µs">37µs</span></td><td class="c3">1</td><td class="c3">11µs</td><td class="s">}<div class="calls"><div class="calls_out"># spent 11µs making 1 call to <a href="DBD-SQLite-pm-2618-line.html#12">DBD::SQLite::BEGIN@12</a></div></div></td></tr> |
| 218 | <tr><td class="h"><a name="26"></a>26</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 219 | <tr><td class="h"><a name="27"></a>27</td><td class="c3">1</td><td class="c0"><span title="Avg 11µs">11µs</span></td><td class="c3">1</td><td class="c0">742µs</td><td class="s">__PACKAGE__->bootstrap($VERSION);<div class="calls"><div class="calls_out"># spent 742µs making 1 call to <a href="DynaLoader-pm-71-line.html#108">DynaLoader::bootstrap</a></div></div></td></tr> |
| 220 | <tr><td class="h"><a name="28"></a>28</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 221 | <tr><td class="h"><a name="29"></a>29</td><td></td><td></td><td></td><td></td><td class="s"># New or old API?</td></tr> |
| 222 | <tr><td class="h"><a name="30"></a>30</td><td class="c1">2</td><td class="c0"><span title="Avg 35µs">71µs</span></td><td class="c1">2</td><td class="c0">105µs</td><td class="s"><div class="calls"><div class="calls_in"># spent 58µs (11+47) within DBD::SQLite::BEGIN@30 which was called: |
| 223 | # once (11µs+47µs) by DBI::install_driver at <a href="DBD-SQLite-pm-2618-line.html#30">line 30</a></div></div>use constant NEWAPI => ($DBI::VERSION >= 1.608);<div class="calls"><div class="calls_out"># spent 58µs making 1 call to <a href="DBD-SQLite-pm-2618-line.html#30">DBD::SQLite::BEGIN@30</a> |
| 224 | # spent 47µs making 1 call to <a href="constant-pm-28-line.html#42">constant::import</a></div></div></td></tr> |
| 225 | <tr><td class="h"><a name="31"></a>31</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 226 | <tr><td class="h"><a name="32"></a>32</td><td class="c3">1</td><td class="c2"><span title="Avg 6µs">6µs</span></td><td class="c3">1</td><td class="c3">10µs</td><td class="s">tie %COLLATION, 'DBD::SQLite::_WriteOnceHash';<div class="calls"><div class="calls_out"># spent 10µs making 1 call to <a href="DBD-SQLite-pm-2618-line.html#599">DBD::SQLite::_WriteOnceHash::TIEHASH</a></div></div></td></tr> |
| 227 | <tr><td class="h"><a name="33"></a>33</td><td class="c3">1</td><td class="c1"><span title="Avg 9µs">9µs</span></td><td class="c3">1</td><td class="c3">4µs</td><td class="s">$COLLATION{perl} = sub { $_[0] cmp $_[1] };<div class="calls"><div class="calls_out"># spent 4µs making 1 call to <a href="DBD-SQLite-pm-2618-line.html#603">DBD::SQLite::_WriteOnceHash::STORE</a></div></div></td></tr> |
| 228 | <tr><td class="h"><a name="34"></a>34</td><td class="c0">3</td><td class="c0"><span title="Avg 240µs">720µs</span></td><td class="c0">3</td><td class="c3">18µs</td><td class="s"><div class="calls"><div class="calls_in"># spent 13µs (10+3) within DBD::SQLite::BEGIN@34 which was called: |
| 229 | # once (10µs+3µs) by DBI::install_driver at <a href="DBD-SQLite-pm-2618-line.html#34">line 34</a></div></div>$COLLATION{perllocale} = sub { use locale; $_[0] cmp $_[1] };<div class="calls"><div class="calls_out"># spent 13µs making 1 call to <a href="DBD-SQLite-pm-2618-line.html#34">DBD::SQLite::BEGIN@34</a> |
| 230 | # spent 3µs making 1 call to <a href="locale-pm-2141-line.html#32">locale::import</a> |
| 231 | # spent 2µs making 1 call to <a href="DBD-SQLite-pm-2618-line.html#603">DBD::SQLite::_WriteOnceHash::STORE</a></div></div></td></tr> |
| 232 | <tr><td class="h"><a name="35"></a>35</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 233 | <tr><td class="h"><a name="36"></a>36</td><td class="c3">1</td><td class="c3"><span title="Avg 300ns">300ns</span></td><td></td><td></td><td class="s">my $methods_are_installed = 0;</td></tr> |
| 234 | <tr><td class="h"><a name="37"></a>37</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 235 | <tr><td class="h"><a name="38"></a>38</td><td></td><td></td><td></td><td></td><td class="s"><div class="calls"><div class="calls_in"># spent 488µs (75+413) within DBD::SQLite::driver which was called: |
| 236 | # once (75µs+413µs) by DBI::install_driver at <a href="DBI-pm-1359-line.html#808">line 808 of DBI.pm</a></div></div>sub driver {</td></tr> |
| 237 | <tr><td class="h"><a name="39"></a>39</td><td class="c3">1</td><td class="c3"><span title="Avg 300ns">300ns</span></td><td></td><td></td><td class="s"> return $drh if $drh;</td></tr> |
| 238 | <tr><td class="h"><a name="40"></a>40</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 239 | <tr><td class="h"><a name="41"></a>41</td><td class="c3">1</td><td class="c3"><span title="Avg 2µs">2µs</span></td><td></td><td></td><td class="s"> if (!$methods_are_installed && $DBI::VERSION >= 1.608) {</td></tr> |
| 240 | <tr><td class="h"><a name="42"></a>42</td><td class="c3">1</td><td class="c3"><span title="Avg 2µs">2µs</span></td><td class="c3">1</td><td class="c3">20µs</td><td class="s"> DBI->setup_driver('DBD::SQLite');<div class="calls"><div class="calls_out"> # spent 20µs making 1 call to <a href="DBI-pm-1359-line.html#826">DBI::setup_driver</a></div></div></td></tr> |
| 241 | <tr><td class="h"><a name="43"></a>43</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 242 | <tr><td class="h"><a name="44"></a>44</td><td class="c3">1</td><td class="c2"><span title="Avg 6µs">6µs</span></td><td class="c3">1</td><td class="c0">47µs</td><td class="s"> DBD::SQLite::db->install_method('sqlite_last_insert_rowid');<div class="calls"><div class="calls_out"> # spent 47µs making 1 call to <a href="DBI-pm-1359-line.html#1368">DBD::_::common::install_method</a></div></div></td></tr> |
| 243 | <tr><td class="h"><a name="45"></a>45</td><td class="c3">1</td><td class="c3"><span title="Avg 2µs">2µs</span></td><td class="c3">1</td><td class="c3">23µs</td><td class="s"> DBD::SQLite::db->install_method('sqlite_busy_timeout');<div class="calls"><div class="calls_out"> # spent 23µs making 1 call to <a href="DBI-pm-1359-line.html#1368">DBD::_::common::install_method</a></div></div></td></tr> |
| 244 | <tr><td class="h"><a name="46"></a>46</td><td class="c3">1</td><td class="c3"><span title="Avg 2µs">2µs</span></td><td class="c3">1</td><td class="c3">21µs</td><td class="s"> DBD::SQLite::db->install_method('sqlite_create_function');<div class="calls"><div class="calls_out"> # spent 21µs making 1 call to <a href="DBI-pm-1359-line.html#1368">DBD::_::common::install_method</a></div></div></td></tr> |
| 245 | <tr><td class="h"><a name="47"></a>47</td><td class="c3">1</td><td class="c3"><span title="Avg 2µs">2µs</span></td><td class="c3">1</td><td class="c3">21µs</td><td class="s"> DBD::SQLite::db->install_method('sqlite_create_aggregate');<div class="calls"><div class="calls_out"> # spent 21µs making 1 call to <a href="DBI-pm-1359-line.html#1368">DBD::_::common::install_method</a></div></div></td></tr> |
| 246 | <tr><td class="h"><a name="48"></a>48</td><td class="c3">1</td><td class="c3"><span title="Avg 2µs">2µs</span></td><td class="c3">1</td><td class="c3">20µs</td><td class="s"> DBD::SQLite::db->install_method('sqlite_create_collation');<div class="calls"><div class="calls_out"> # spent 20µs making 1 call to <a href="DBI-pm-1359-line.html#1368">DBD::_::common::install_method</a></div></div></td></tr> |
| 247 | <tr><td class="h"><a name="49"></a>49</td><td class="c3">1</td><td class="c3"><span title="Avg 2µs">2µs</span></td><td class="c3">1</td><td class="c3">20µs</td><td class="s"> DBD::SQLite::db->install_method('sqlite_collation_needed');<div class="calls"><div class="calls_out"> # spent 20µs making 1 call to <a href="DBI-pm-1359-line.html#1368">DBD::_::common::install_method</a></div></div></td></tr> |
| 248 | <tr><td class="h"><a name="50"></a>50</td><td class="c3">1</td><td class="c3"><span title="Avg 2µs">2µs</span></td><td class="c3">1</td><td class="c3">20µs</td><td class="s"> DBD::SQLite::db->install_method('sqlite_progress_handler');<div class="calls"><div class="calls_out"> # spent 20µs making 1 call to <a href="DBI-pm-1359-line.html#1368">DBD::_::common::install_method</a></div></div></td></tr> |
| 249 | <tr><td class="h"><a name="51"></a>51</td><td class="c3">1</td><td class="c3"><span title="Avg 2µs">2µs</span></td><td class="c3">1</td><td class="c3">21µs</td><td class="s"> DBD::SQLite::db->install_method('sqlite_commit_hook');<div class="calls"><div class="calls_out"> # spent 21µs making 1 call to <a href="DBI-pm-1359-line.html#1368">DBD::_::common::install_method</a></div></div></td></tr> |
| 250 | <tr><td class="h"><a name="52"></a>52</td><td class="c3">1</td><td class="c3"><span title="Avg 2µs">2µs</span></td><td class="c3">1</td><td class="c3">20µs</td><td class="s"> DBD::SQLite::db->install_method('sqlite_rollback_hook');<div class="calls"><div class="calls_out"> # spent 20µs making 1 call to <a href="DBI-pm-1359-line.html#1368">DBD::_::common::install_method</a></div></div></td></tr> |
| 251 | <tr><td class="h"><a name="53"></a>53</td><td class="c3">1</td><td class="c3"><span title="Avg 2µs">2µs</span></td><td class="c3">1</td><td class="c3">20µs</td><td class="s"> DBD::SQLite::db->install_method('sqlite_update_hook');<div class="calls"><div class="calls_out"> # spent 20µs making 1 call to <a href="DBI-pm-1359-line.html#1368">DBD::_::common::install_method</a></div></div></td></tr> |
| 252 | <tr><td class="h"><a name="54"></a>54</td><td class="c3">1</td><td class="c3"><span title="Avg 2µs">2µs</span></td><td class="c3">1</td><td class="c3">20µs</td><td class="s"> DBD::SQLite::db->install_method('sqlite_set_authorizer');<div class="calls"><div class="calls_out"> # spent 20µs making 1 call to <a href="DBI-pm-1359-line.html#1368">DBD::_::common::install_method</a></div></div></td></tr> |
| 253 | <tr><td class="h"><a name="55"></a>55</td><td class="c3">1</td><td class="c3"><span title="Avg 1µs">1µs</span></td><td class="c3">1</td><td class="c3">20µs</td><td class="s"> DBD::SQLite::db->install_method('sqlite_backup_from_file');<div class="calls"><div class="calls_out"> # spent 20µs making 1 call to <a href="DBI-pm-1359-line.html#1368">DBD::_::common::install_method</a></div></div></td></tr> |
| 254 | <tr><td class="h"><a name="56"></a>56</td><td class="c3">1</td><td class="c3"><span title="Avg 2µs">2µs</span></td><td class="c3">1</td><td class="c3">20µs</td><td class="s"> DBD::SQLite::db->install_method('sqlite_backup_to_file');<div class="calls"><div class="calls_out"> # spent 20µs making 1 call to <a href="DBI-pm-1359-line.html#1368">DBD::_::common::install_method</a></div></div></td></tr> |
| 255 | <tr><td class="h"><a name="57"></a>57</td><td class="c3">1</td><td class="c3"><span title="Avg 2µs">2µs</span></td><td class="c3">1</td><td class="c3">20µs</td><td class="s"> DBD::SQLite::db->install_method('sqlite_enable_load_extension');<div class="calls"><div class="calls_out"> # spent 20µs making 1 call to <a href="DBI-pm-1359-line.html#1368">DBD::_::common::install_method</a></div></div></td></tr> |
| 256 | <tr><td class="h"><a name="58"></a>58</td><td class="c3">1</td><td class="c3"><span title="Avg 2µs">2µs</span></td><td class="c3">1</td><td class="c3">21µs</td><td class="s"> DBD::SQLite::db->install_method('sqlite_register_fts3_perl_tokenizer');<div class="calls"><div class="calls_out"> # spent 21µs making 1 call to <a href="DBI-pm-1359-line.html#1368">DBD::_::common::install_method</a></div></div></td></tr> |
| 257 | <tr><td class="h"><a name="59"></a>59</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 258 | <tr><td class="h"><a name="60"></a>60</td><td class="c3">1</td><td class="c3"><span title="Avg 900ns">900ns</span></td><td></td><td></td><td class="s"> $methods_are_installed++;</td></tr> |
| 259 | <tr><td class="h"><a name="61"></a>61</td><td></td><td></td><td></td><td></td><td class="s"> }</td></tr> |
| 260 | <tr><td class="h"><a name="62"></a>62</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 261 | <tr><td class="h"><a name="63"></a>63</td><td class="c3">1</td><td class="c1"><span title="Avg 7µs">7µs</span></td><td class="c3">1</td><td class="c0">57µs</td><td class="s"> $drh = DBI::_new_drh( "$_[0]::dr", {<div class="calls"><div class="calls_out"> # spent 57µs making 1 call to <a href="DBI-pm-1359-line.html#1225">DBI::_new_drh</a></div></div></td></tr> |
| 262 | <tr><td class="h"><a name="64"></a>64</td><td></td><td></td><td></td><td></td><td class="s"> Name => 'SQLite',</td></tr> |
| 263 | <tr><td class="h"><a name="65"></a>65</td><td></td><td></td><td></td><td></td><td class="s"> Version => $VERSION,</td></tr> |
| 264 | <tr><td class="h"><a name="66"></a>66</td><td></td><td></td><td></td><td></td><td class="s"> Attribution => 'DBD::SQLite by Matt Sergeant et al',</td></tr> |
| 265 | <tr><td class="h"><a name="67"></a>67</td><td></td><td></td><td></td><td></td><td class="s"> } );</td></tr> |
| 266 | <tr><td class="h"><a name="68"></a>68</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 267 | <tr><td class="h"><a name="69"></a>69</td><td class="c3">1</td><td class="c3"><span title="Avg 3µs">3µs</span></td><td></td><td></td><td class="s"> return $drh;</td></tr> |
| 268 | <tr><td class="h"><a name="70"></a>70</td><td></td><td></td><td></td><td></td><td class="s">}</td></tr> |
| 269 | <tr><td class="h"><a name="71"></a>71</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 270 | <tr><td class="h"><a name="72"></a>72</td><td></td><td></td><td></td><td></td><td class="s">sub CLONE {</td></tr> |
| 271 | <tr><td class="h"><a name="73"></a>73</td><td></td><td></td><td></td><td></td><td class="s"> undef $drh;</td></tr> |
| 272 | <tr><td class="h"><a name="74"></a>74</td><td></td><td></td><td></td><td></td><td class="s">}</td></tr> |
| 273 | <tr><td class="h"><a name="75"></a>75</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 274 | <tr><td class="h"><a name="76"></a>76</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 275 | <tr><td class="h"><a name="77"></a>77</td><td></td><td></td><td></td><td></td><td class="s">package DBD::SQLite::dr;</td></tr> |
| 276 | <tr><td class="h"><a name="78"></a>78</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 277 | <tr><td class="h"><a name="79"></a>79</td><td></td><td></td><td></td><td></td><td class="s"><div class="calls"><div class="calls_in"># spent 74.0ms (108µs+73.9) within DBD::SQLite::dr::connect which was called: |
| 278 | # once (108µs+73.9ms) by DBI::dr::connect at <a href="DBI-pm-1359-line.html#658">line 658 of DBI.pm</a></div></div>sub connect {</td></tr> |
| 279 | <tr><td class="h"><a name="80"></a>80</td><td class="c3">1</td><td class="c3"><span title="Avg 1µs">1µs</span></td><td></td><td></td><td class="s"> my ($drh, $dbname, $user, $auth, $attr) = @_;</td></tr> |
| 280 | <tr><td class="h"><a name="81"></a>81</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 281 | <tr><td class="h"><a name="82"></a>82</td><td></td><td></td><td></td><td></td><td class="s"> # Default PrintWarn to the value of $^W</td></tr> |
| 282 | <tr><td class="h"><a name="83"></a>83</td><td></td><td></td><td></td><td></td><td class="s"> # unless ( defined $attr->{PrintWarn} ) {</td></tr> |
| 283 | <tr><td class="h"><a name="84"></a>84</td><td></td><td></td><td></td><td></td><td class="s"> # $attr->{PrintWarn} = $^W ? 1 : 0;</td></tr> |
| 284 | <tr><td class="h"><a name="85"></a>85</td><td></td><td></td><td></td><td></td><td class="s"> # }</td></tr> |
| 285 | <tr><td class="h"><a name="86"></a>86</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 286 | <tr><td class="h"><a name="87"></a>87</td><td class="c3">1</td><td class="c3"><span title="Avg 3µs">3µs</span></td><td class="c3">1</td><td class="c0">35µs</td><td class="s"> my $dbh = DBI::_new_dbh( $drh, {<div class="calls"><div class="calls_out"> # spent 35µs making 1 call to <a href="DBI-pm-1359-line.html#1260">DBI::_new_dbh</a></div></div></td></tr> |
| 287 | <tr><td class="h"><a name="88"></a>88</td><td></td><td></td><td></td><td></td><td class="s"> Name => $dbname,</td></tr> |
| 288 | <tr><td class="h"><a name="89"></a>89</td><td></td><td></td><td></td><td></td><td class="s"> } );</td></tr> |
| 289 | <tr><td class="h"><a name="90"></a>90</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 290 | <tr><td class="h"><a name="91"></a>91</td><td class="c3">1</td><td class="c3"><span title="Avg 600ns">600ns</span></td><td></td><td></td><td class="s"> my $real = $dbname;</td></tr> |
| 291 | <tr><td class="h"><a name="92"></a>92</td><td class="c3">1</td><td class="c1"><span title="Avg 7µs">7µs</span></td><td class="c3">1</td><td class="c3">1µs</td><td class="s"> if ( $dbname =~ /=/ ) {<div class="calls"><div class="calls_out"> # spent 1µs making 1 call to <a href="DBD-SQLite-pm-2618-line.html#DBD__SQLite__dr__CORE_match">DBD::SQLite::dr::CORE:match</a></div></div></td></tr> |
| 292 | <tr><td class="h"><a name="93"></a>93</td><td class="c3">1</td><td class="c3"><span title="Avg 2µs">2µs</span></td><td></td><td></td><td class="s"> foreach my $attrib ( split(/;/, $dbname) ) {</td></tr> |
| 293 | <tr><td class="h"><a name="94"></a>94</td><td class="c3">1</td><td class="c3"><span title="Avg 2µs">2µs</span></td><td></td><td></td><td class="s"> my ($key, $value) = split(/=/, $attrib, 2);</td></tr> |
| 294 | <tr><td class="h"><a name="95"></a>95</td><td class="c3">1</td><td class="c1"><span title="Avg 7µs">7µs</span></td><td class="c3">1</td><td class="c3">3µs</td><td class="s"> if ( $key =~ /^(?:db(?:name)?|database)$/ ) {<div class="calls"><div class="calls_out"> # spent 3µs making 1 call to <a href="DBD-SQLite-pm-2618-line.html#DBD__SQLite__dr__CORE_match">DBD::SQLite::dr::CORE:match</a></div></div></td></tr> |
| 295 | <tr><td class="h"><a name="96"></a>96</td><td></td><td></td><td></td><td></td><td class="s"> $real = $value;</td></tr> |
| 296 | <tr><td class="h"><a name="97"></a>97</td><td></td><td></td><td></td><td></td><td class="s"> } else {</td></tr> |
| 297 | <tr><td class="h"><a name="98"></a>98</td><td></td><td></td><td></td><td></td><td class="s"> $attr->{$key} = $value;</td></tr> |
| 298 | <tr><td class="h"><a name="99"></a>99</td><td></td><td></td><td></td><td></td><td class="s"> }</td></tr> |
| 299 | <tr><td class="h"><a name="100"></a>100</td><td></td><td></td><td></td><td></td><td class="s"> }</td></tr> |
| 300 | <tr><td class="h"><a name="101"></a>101</td><td></td><td></td><td></td><td></td><td class="s"> }</td></tr> |
| 301 | <tr><td class="h"><a name="102"></a>102</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 302 | <tr><td class="h"><a name="103"></a>103</td><td></td><td></td><td></td><td></td><td class="s"> # To avoid unicode and long file name problems on Windows,</td></tr> |
| 303 | <tr><td class="h"><a name="104"></a>104</td><td></td><td></td><td></td><td></td><td class="s"> # convert to the shortname if the file (or parent directory) exists.</td></tr> |
| 304 | <tr><td class="h"><a name="105"></a>105</td><td class="c3">1</td><td class="c3"><span title="Avg 4µs">4µs</span></td><td class="c3">1</td><td class="c3">800ns</td><td class="s"> if ( $^O =~ /MSWin32/ and $real ne ':memory:' and $real ne '') {<div class="calls"><div class="calls_out"> # spent 800ns making 1 call to <a href="DBD-SQLite-pm-2618-line.html#DBD__SQLite__dr__CORE_match">DBD::SQLite::dr::CORE:match</a></div></div></td></tr> |
| 305 | <tr><td class="h"><a name="106"></a>106</td><td></td><td></td><td></td><td></td><td class="s"> require Win32;</td></tr> |
| 306 | <tr><td class="h"><a name="107"></a>107</td><td></td><td></td><td></td><td></td><td class="s"> require File::Basename;</td></tr> |
| 307 | <tr><td class="h"><a name="108"></a>108</td><td></td><td></td><td></td><td></td><td class="s"> my ($file, $dir, $suffix) = File::Basename::fileparse($real);</td></tr> |
| 308 | <tr><td class="h"><a name="109"></a>109</td><td></td><td></td><td></td><td></td><td class="s"> my $short = Win32::GetShortPathName($real);</td></tr> |
| 309 | <tr><td class="h"><a name="110"></a>110</td><td></td><td></td><td></td><td></td><td class="s"> if ( $short && -f $short ) {</td></tr> |
| 310 | <tr><td class="h"><a name="111"></a>111</td><td></td><td></td><td></td><td></td><td class="s"> # Existing files will work directly.</td></tr> |
| 311 | <tr><td class="h"><a name="112"></a>112</td><td></td><td></td><td></td><td></td><td class="s"> $real = $short;</td></tr> |
| 312 | <tr><td class="h"><a name="113"></a>113</td><td></td><td></td><td></td><td></td><td class="s"> } elsif ( -d $dir ) {</td></tr> |
| 313 | <tr><td class="h"><a name="114"></a>114</td><td></td><td></td><td></td><td></td><td class="s"> # We are creating a new file.</td></tr> |
| 314 | <tr><td class="h"><a name="115"></a>115</td><td></td><td></td><td></td><td></td><td class="s"> # Does the directory it's in at least exist?</td></tr> |
| 315 | <tr><td class="h"><a name="116"></a>116</td><td></td><td></td><td></td><td></td><td class="s"> $real = join '', grep { defined } Win32::GetShortPathName($dir), $file, $suffix;</td></tr> |
| 316 | <tr><td class="h"><a name="117"></a>117</td><td></td><td></td><td></td><td></td><td class="s"> } else {</td></tr> |
| 317 | <tr><td class="h"><a name="118"></a>118</td><td></td><td></td><td></td><td></td><td class="s"> # SQLite can't do mkpath anyway.</td></tr> |
| 318 | <tr><td class="h"><a name="119"></a>119</td><td></td><td></td><td></td><td></td><td class="s"> # So let it go through as it and fail.</td></tr> |
| 319 | <tr><td class="h"><a name="120"></a>120</td><td></td><td></td><td></td><td></td><td class="s"> }</td></tr> |
| 320 | <tr><td class="h"><a name="121"></a>121</td><td></td><td></td><td></td><td></td><td class="s"> }</td></tr> |
| 321 | <tr><td class="h"><a name="122"></a>122</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 322 | <tr><td class="h"><a name="123"></a>123</td><td></td><td></td><td></td><td></td><td class="s"> # Hand off to the actual login function</td></tr> |
| 323 | <tr><td class="h"><a name="124"></a>124</td><td class="c3">1</td><td class="c0"><span title="Avg 73.7ms">73.7ms</span></td><td class="c3">1</td><td class="c0">73.7ms</td><td class="s"> DBD::SQLite::db::_login($dbh, $real, $user, $auth, $attr) or return undef;<div class="calls"><div class="calls_out"> # spent 73.7ms making 1 call to <a href="DBD-SQLite-pm-2618-line.html#DBD__SQLite__db___login">DBD::SQLite::db::_login</a></div></div></td></tr> |
| 324 | <tr><td class="h"><a name="125"></a>125</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 325 | <tr><td class="h"><a name="126"></a>126</td><td></td><td></td><td></td><td></td><td class="s"> # Register the on-demand collation installer, REGEXP function and</td></tr> |
| 326 | <tr><td class="h"><a name="127"></a>127</td><td></td><td></td><td></td><td></td><td class="s"> # perl tokenizer</td></tr> |
| 327 | <tr><td class="h"><a name="128"></a>128</td><td class="c3">1</td><td class="c3"><span title="Avg 2µs">2µs</span></td><td></td><td></td><td class="s"> if ( DBD::SQLite::NEWAPI ) {</td></tr> |
| 328 | <tr><td class="h"><a name="129"></a>129</td><td class="c3">1</td><td class="c0"><span title="Avg 37µs">37µs</span></td><td class="c3">1</td><td class="c3">19µs</td><td class="s"> $dbh->sqlite_collation_needed( \&install_collation );<div class="calls"><div class="calls_out"> # spent 19µs making 1 call to <a href="script-nytprof-pl-1-line.html#DBI__db__sqlite_collation_needed">DBI::db::sqlite_collation_needed</a></div></div></td></tr> |
| 329 | <tr><td class="h"><a name="130"></a>130</td><td class="c3">1</td><td class="c0"><span title="Avg 28µs">28µs</span></td><td class="c3">1</td><td class="c3">16µs</td><td class="s"> $dbh->sqlite_create_function( "REGEXP", 2, \&regexp );<div class="calls"><div class="calls_out"> # spent 16µs making 1 call to <a href="script-nytprof-pl-1-line.html#DBI__db__sqlite_create_function">DBI::db::sqlite_create_function</a></div></div></td></tr> |
| 330 | <tr><td class="h"><a name="131"></a>131</td><td class="c3">1</td><td class="c0"><span title="Avg 136µs">136µs</span></td><td class="c3">1</td><td class="c0">122µs</td><td class="s"> $dbh->sqlite_register_fts3_perl_tokenizer();<div class="calls"><div class="calls_out"> # spent 122µs making 1 call to <a href="script-nytprof-pl-1-line.html#DBI__db__sqlite_register_fts3_perl_tokenizer">DBI::db::sqlite_register_fts3_perl_tokenizer</a></div></div></td></tr> |
| 331 | <tr><td class="h"><a name="132"></a>132</td><td></td><td></td><td></td><td></td><td class="s"> } else {</td></tr> |
| 332 | <tr><td class="h"><a name="133"></a>133</td><td></td><td></td><td></td><td></td><td class="s"> $dbh->func( \&install_collation, "collation_needed" );</td></tr> |
| 333 | <tr><td class="h"><a name="134"></a>134</td><td></td><td></td><td></td><td></td><td class="s"> $dbh->func( "REGEXP", 2, \&regexp, "create_function" );</td></tr> |
| 334 | <tr><td class="h"><a name="135"></a>135</td><td></td><td></td><td></td><td></td><td class="s"> $dbh->func( "register_fts3_perl_tokenizer" );</td></tr> |
| 335 | <tr><td class="h"><a name="136"></a>136</td><td></td><td></td><td></td><td></td><td class="s"> }</td></tr> |
| 336 | <tr><td class="h"><a name="137"></a>137</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 337 | <tr><td class="h"><a name="138"></a>138</td><td></td><td></td><td></td><td></td><td class="s"> # HACK: Since PrintWarn = 0 doesn't seem to actually prevent warnings</td></tr> |
| 338 | <tr><td class="h"><a name="139"></a>139</td><td></td><td></td><td></td><td></td><td class="s"> # in DBD::SQLite we set Warn to false if PrintWarn is false.</td></tr> |
| 339 | <tr><td class="h"><a name="140"></a>140</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 340 | <tr><td class="h"><a name="141"></a>141</td><td></td><td></td><td></td><td></td><td class="s"> # NOTE: According to the explanation by timbunce,</td></tr> |
| 341 | <tr><td class="h"><a name="142"></a>142</td><td></td><td></td><td></td><td></td><td class="s"> # "Warn is meant to report on bad practices or problems with</td></tr> |
| 342 | <tr><td class="h"><a name="143"></a>143</td><td></td><td></td><td></td><td></td><td class="s"> # the DBI itself (hence always on by default), while PrintWarn</td></tr> |
| 343 | <tr><td class="h"><a name="144"></a>144</td><td></td><td></td><td></td><td></td><td class="s"> # is meant to report warnings coming from the database."</td></tr> |
| 344 | <tr><td class="h"><a name="145"></a>145</td><td></td><td></td><td></td><td></td><td class="s"> # That is, if you want to disable an ineffective rollback warning</td></tr> |
| 345 | <tr><td class="h"><a name="146"></a>146</td><td></td><td></td><td></td><td></td><td class="s"> # etc (due to bad practices), you should turn off Warn,</td></tr> |
| 346 | <tr><td class="h"><a name="147"></a>147</td><td></td><td></td><td></td><td></td><td class="s"> # and to silence other warnings, turn off PrintWarn.</td></tr> |
| 347 | <tr><td class="h"><a name="148"></a>148</td><td></td><td></td><td></td><td></td><td class="s"> # Warn and PrintWarn are independent, and turning off PrintWarn</td></tr> |
| 348 | <tr><td class="h"><a name="149"></a>149</td><td></td><td></td><td></td><td></td><td class="s"> # does not silence those warnings that should be controlled by</td></tr> |
| 349 | <tr><td class="h"><a name="150"></a>150</td><td></td><td></td><td></td><td></td><td class="s"> # Warn.</td></tr> |
| 350 | <tr><td class="h"><a name="151"></a>151</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 351 | <tr><td class="h"><a name="152"></a>152</td><td></td><td></td><td></td><td></td><td class="s"> # unless ( $attr->{PrintWarn} ) {</td></tr> |
| 352 | <tr><td class="h"><a name="153"></a>153</td><td></td><td></td><td></td><td></td><td class="s"> # $attr->{Warn} = 0;</td></tr> |
| 353 | <tr><td class="h"><a name="154"></a>154</td><td></td><td></td><td></td><td></td><td class="s"> # }</td></tr> |
| 354 | <tr><td class="h"><a name="155"></a>155</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 355 | <tr><td class="h"><a name="156"></a>156</td><td class="c3">1</td><td class="c0"><span title="Avg 12µs">12µs</span></td><td></td><td></td><td class="s"> return $dbh;</td></tr> |
| 356 | <tr><td class="h"><a name="157"></a>157</td><td></td><td></td><td></td><td></td><td class="s">}</td></tr> |
| 357 | <tr><td class="h"><a name="158"></a>158</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 358 | <tr><td class="h"><a name="159"></a>159</td><td></td><td></td><td></td><td></td><td class="s">sub install_collation {</td></tr> |
| 359 | <tr><td class="h"><a name="160"></a>160</td><td></td><td></td><td></td><td></td><td class="s"> my $dbh = shift;</td></tr> |
| 360 | <tr><td class="h"><a name="161"></a>161</td><td></td><td></td><td></td><td></td><td class="s"> my $name = shift;</td></tr> |
| 361 | <tr><td class="h"><a name="162"></a>162</td><td></td><td></td><td></td><td></td><td class="s"> my $collation = $DBD::SQLite::COLLATION{$name};</td></tr> |
| 362 | <tr><td class="h"><a name="163"></a>163</td><td></td><td></td><td></td><td></td><td class="s"> unless ($collation) {</td></tr> |
| 363 | <tr><td class="h"><a name="164"></a>164</td><td></td><td></td><td></td><td></td><td class="s"> warn "Can't install unknown collation: $name" if $dbh->{PrintWarn};</td></tr> |
| 364 | <tr><td class="h"><a name="165"></a>165</td><td></td><td></td><td></td><td></td><td class="s"> return;</td></tr> |
| 365 | <tr><td class="h"><a name="166"></a>166</td><td></td><td></td><td></td><td></td><td class="s"> }</td></tr> |
| 366 | <tr><td class="h"><a name="167"></a>167</td><td></td><td></td><td></td><td></td><td class="s"> if ( DBD::SQLite::NEWAPI ) {</td></tr> |
| 367 | <tr><td class="h"><a name="168"></a>168</td><td></td><td></td><td></td><td></td><td class="s"> $dbh->sqlite_create_collation( $name => $collation );</td></tr> |
| 368 | <tr><td class="h"><a name="169"></a>169</td><td></td><td></td><td></td><td></td><td class="s"> } else {</td></tr> |
| 369 | <tr><td class="h"><a name="170"></a>170</td><td></td><td></td><td></td><td></td><td class="s"> $dbh->func( $name => $collation, "create_collation" );</td></tr> |
| 370 | <tr><td class="h"><a name="171"></a>171</td><td></td><td></td><td></td><td></td><td class="s"> }</td></tr> |
| 371 | <tr><td class="h"><a name="172"></a>172</td><td></td><td></td><td></td><td></td><td class="s">}</td></tr> |
| 372 | <tr><td class="h"><a name="173"></a>173</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 373 | <tr><td class="h"><a name="174"></a>174</td><td></td><td></td><td></td><td></td><td class="s"># default implementation for sqlite 'REGEXP' infix operator.</td></tr> |
| 374 | <tr><td class="h"><a name="175"></a>175</td><td></td><td></td><td></td><td></td><td class="s"># Note : args are reversed, i.e. "a REGEXP b" calls REGEXP(b, a)</td></tr> |
| 375 | <tr><td class="h"><a name="176"></a>176</td><td></td><td></td><td></td><td></td><td class="s"># (see http://www.sqlite.org/vtab.html#xfindfunction)</td></tr> |
| 376 | <tr><td class="h"><a name="177"></a>177</td><td></td><td></td><td></td><td></td><td class="s">sub regexp {</td></tr> |
| 377 | <tr><td class="h"><a name="178"></a>178</td><td class="c1">2</td><td class="c0"><span title="Avg 876µs">1.75ms</span></td><td class="c1">2</td><td class="c3">15µs</td><td class="s"><div class="calls"><div class="calls_in"># spent 13µs (10+2) within DBD::SQLite::dr::BEGIN@178 which was called: |
| 378 | # once (10µs+2µs) by DBI::install_driver at <a href="DBD-SQLite-pm-2618-line.html#178">line 178</a></div></div> use locale;<div class="calls"><div class="calls_out"> # spent 13µs making 1 call to <a href="DBD-SQLite-pm-2618-line.html#178">DBD::SQLite::dr::BEGIN@178</a> |
| 379 | # spent 2µs making 1 call to <a href="locale-pm-2141-line.html#32">locale::import</a></div></div></td></tr> |
| 380 | <tr><td class="h"><a name="179"></a>179</td><td></td><td></td><td></td><td></td><td class="s"> return if !defined $_[0] || !defined $_[1];</td></tr> |
| 381 | <tr><td class="h"><a name="180"></a>180</td><td></td><td></td><td></td><td></td><td class="s"> return scalar($_[1] =~ $_[0]);</td></tr> |
| 382 | <tr><td class="h"><a name="181"></a>181</td><td></td><td></td><td></td><td></td><td class="s">}</td></tr> |
| 383 | <tr><td class="h"><a name="182"></a>182</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 384 | <tr><td class="h"><a name="183"></a>183</td><td></td><td></td><td></td><td></td><td class="s">package DBD::SQLite::db;</td></tr> |
| 385 | <tr><td class="h"><a name="184"></a>184</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 386 | <tr><td class="h"><a name="185"></a>185</td><td></td><td></td><td></td><td></td><td class="s"><div class="calls"><div class="calls_in"># spent 432µs (34+398) within DBD::SQLite::db::prepare which was called 2 times, avg 216µs/call: |
| 387 | # 2 times (34µs+398µs) by DBI::db::prepare at <a href="DBI-pm-1359-line.html#1706">line 1706 of DBI.pm</a>, avg 216µs/call</div></div>sub prepare {</td></tr> |
| 388 | <tr><td class="h"><a name="186"></a>186</td><td class="c1">2</td><td class="c3"><span title="Avg 600ns">1µs</span></td><td></td><td></td><td class="s"> my $dbh = shift;</td></tr> |
| 389 | <tr><td class="h"><a name="187"></a>187</td><td class="c1">2</td><td class="c3"><span title="Avg 750ns">2µs</span></td><td></td><td></td><td class="s"> my $sql = shift;</td></tr> |
| 390 | <tr><td class="h"><a name="188"></a>188</td><td class="c1">2</td><td class="c3"><span title="Avg 500ns">1µs</span></td><td></td><td></td><td class="s"> $sql = '' unless defined $sql;</td></tr> |
| 391 | <tr><td class="h"><a name="189"></a>189</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 392 | <tr><td class="h"><a name="190"></a>190</td><td class="c1">2</td><td class="c1"><span title="Avg 4µs">9µs</span></td><td class="c1">2</td><td class="c0">76µs</td><td class="s"> my $sth = DBI::_new_sth( $dbh, {<div class="calls"><div class="calls_out"> # spent 76µs making 2 calls to <a href="DBI-pm-1359-line.html#1273">DBI::_new_sth</a>, avg 38µs/call</div></div></td></tr> |
| 393 | <tr><td class="h"><a name="191"></a>191</td><td></td><td></td><td></td><td></td><td class="s"> Statement => $sql,</td></tr> |
| 394 | <tr><td class="h"><a name="192"></a>192</td><td></td><td></td><td></td><td></td><td class="s"> } );</td></tr> |
| 395 | <tr><td class="h"><a name="193"></a>193</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 396 | <tr><td class="h"><a name="194"></a>194</td><td class="c1">2</td><td class="c0"><span title="Avg 168µs">335µs</span></td><td class="c1">2</td><td class="c0">322µs</td><td class="s"> DBD::SQLite::st::_prepare($sth, $sql, @_) or return undef;<div class="calls"><div class="calls_out"> # spent 322µs making 2 calls to <a href="script-nytprof-pl-1-line.html#DBD__SQLite__st___prepare">DBD::SQLite::st::_prepare</a>, avg 161µs/call</div></div></td></tr> |
| 397 | <tr><td class="h"><a name="195"></a>195</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 398 | <tr><td class="h"><a name="196"></a>196</td><td class="c1">2</td><td class="c1"><span title="Avg 4µs">8µs</span></td><td></td><td></td><td class="s"> return $sth;</td></tr> |
| 399 | <tr><td class="h"><a name="197"></a>197</td><td></td><td></td><td></td><td></td><td class="s">}</td></tr> |
| 400 | <tr><td class="h"><a name="198"></a>198</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 401 | <tr><td class="h"><a name="199"></a>199</td><td></td><td></td><td></td><td></td><td class="s">sub do {</td></tr> |
| 402 | <tr><td class="h"><a name="200"></a>200</td><td></td><td></td><td></td><td></td><td class="s"> my ($dbh, $statement, $attr, @bind_values) = @_;</td></tr> |
| 403 | <tr><td class="h"><a name="201"></a>201</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 404 | <tr><td class="h"><a name="202"></a>202</td><td></td><td></td><td></td><td></td><td class="s"> my @copy = @{[@bind_values]};</td></tr> |
| 405 | <tr><td class="h"><a name="203"></a>203</td><td></td><td></td><td></td><td></td><td class="s"> my $rows = 0;</td></tr> |
| 406 | <tr><td class="h"><a name="204"></a>204</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 407 | <tr><td class="h"><a name="205"></a>205</td><td></td><td></td><td></td><td></td><td class="s"> while ($statement) {</td></tr> |
| 408 | <tr><td class="h"><a name="206"></a>206</td><td></td><td></td><td></td><td></td><td class="s"> my $sth = $dbh->prepare($statement, $attr) or return undef;</td></tr> |
| 409 | <tr><td class="h"><a name="207"></a>207</td><td></td><td></td><td></td><td></td><td class="s"> $sth->execute(splice @copy, 0, $sth->{NUM_OF_PARAMS}) or return undef;</td></tr> |
| 410 | <tr><td class="h"><a name="208"></a>208</td><td></td><td></td><td></td><td></td><td class="s"> $rows += $sth->rows;</td></tr> |
| 411 | <tr><td class="h"><a name="209"></a>209</td><td></td><td></td><td></td><td></td><td class="s"> # XXX: not sure why but $dbh->{sqlite...} wouldn't work here</td></tr> |
| 412 | <tr><td class="h"><a name="210"></a>210</td><td></td><td></td><td></td><td></td><td class="s"> last unless $dbh->FETCH('sqlite_allow_multiple_statements');</td></tr> |
| 413 | <tr><td class="h"><a name="211"></a>211</td><td></td><td></td><td></td><td></td><td class="s"> $statement = $sth->{sqlite_unprepared_statements};</td></tr> |
| 414 | <tr><td class="h"><a name="212"></a>212</td><td></td><td></td><td></td><td></td><td class="s"> }</td></tr> |
| 415 | <tr><td class="h"><a name="213"></a>213</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 416 | <tr><td class="h"><a name="214"></a>214</td><td></td><td></td><td></td><td></td><td class="s"> # always return true if no error</td></tr> |
| 417 | <tr><td class="h"><a name="215"></a>215</td><td></td><td></td><td></td><td></td><td class="s"> return ($rows == 0) ? "0E0" : $rows;</td></tr> |
| 418 | <tr><td class="h"><a name="216"></a>216</td><td></td><td></td><td></td><td></td><td class="s">}</td></tr> |
| 419 | <tr><td class="h"><a name="217"></a>217</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 420 | <tr><td class="h"><a name="218"></a>218</td><td></td><td></td><td></td><td></td><td class="s">sub _get_version {</td></tr> |
| 421 | <tr><td class="h"><a name="219"></a>219</td><td></td><td></td><td></td><td></td><td class="s"> return ( DBD::SQLite::db::FETCH($_[0], 'sqlite_version') );</td></tr> |
| 422 | <tr><td class="h"><a name="220"></a>220</td><td></td><td></td><td></td><td></td><td class="s">}</td></tr> |
| 423 | <tr><td class="h"><a name="221"></a>221</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 424 | <tr><td class="h"><a name="222"></a>222</td><td class="c3">1</td><td class="c3"><span title="Avg 4µs">4µs</span></td><td></td><td></td><td class="s">my %info = (</td></tr> |
| 425 | <tr><td class="h"><a name="223"></a>223</td><td></td><td></td><td></td><td></td><td class="s"> 17 => 'SQLite', # SQL_DBMS_NAME</td></tr> |
| 426 | <tr><td class="h"><a name="224"></a>224</td><td></td><td></td><td></td><td></td><td class="s"> 18 => \&_get_version, # SQL_DBMS_VER</td></tr> |
| 427 | <tr><td class="h"><a name="225"></a>225</td><td></td><td></td><td></td><td></td><td class="s"> 29 => '"', # SQL_IDENTIFIER_QUOTE_CHAR</td></tr> |
| 428 | <tr><td class="h"><a name="226"></a>226</td><td></td><td></td><td></td><td></td><td class="s">);</td></tr> |
| 429 | <tr><td class="h"><a name="227"></a>227</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 430 | <tr><td class="h"><a name="228"></a>228</td><td></td><td></td><td></td><td></td><td class="s">sub get_info {</td></tr> |
| 431 | <tr><td class="h"><a name="229"></a>229</td><td></td><td></td><td></td><td></td><td class="s"> my($dbh, $info_type) = @_;</td></tr> |
| 432 | <tr><td class="h"><a name="230"></a>230</td><td></td><td></td><td></td><td></td><td class="s"> my $v = $info{int($info_type)};</td></tr> |
| 433 | <tr><td class="h"><a name="231"></a>231</td><td></td><td></td><td></td><td></td><td class="s"> $v = $v->($dbh) if ref $v eq 'CODE';</td></tr> |
| 434 | <tr><td class="h"><a name="232"></a>232</td><td></td><td></td><td></td><td></td><td class="s"> return $v;</td></tr> |
| 435 | <tr><td class="h"><a name="233"></a>233</td><td></td><td></td><td></td><td></td><td class="s">}</td></tr> |
| 436 | <tr><td class="h"><a name="234"></a>234</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 437 | <tr><td class="h"><a name="235"></a>235</td><td></td><td></td><td></td><td></td><td class="s">sub _attached_database_list {</td></tr> |
| 438 | <tr><td class="h"><a name="236"></a>236</td><td></td><td></td><td></td><td></td><td class="s"> my $dbh = shift;</td></tr> |
| 439 | <tr><td class="h"><a name="237"></a>237</td><td></td><td></td><td></td><td></td><td class="s"> my @attached;</td></tr> |
| 440 | <tr><td class="h"><a name="238"></a>238</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 441 | <tr><td class="h"><a name="239"></a>239</td><td></td><td></td><td></td><td></td><td class="s"> my $sth_databases = $dbh->prepare( 'PRAGMA database_list' );</td></tr> |
| 442 | <tr><td class="h"><a name="240"></a>240</td><td></td><td></td><td></td><td></td><td class="s"> $sth_databases->execute;</td></tr> |
| 443 | <tr><td class="h"><a name="241"></a>241</td><td></td><td></td><td></td><td></td><td class="s"> while ( my $db_info = $sth_databases->fetchrow_hashref ) {</td></tr> |
| 444 | <tr><td class="h"><a name="242"></a>242</td><td></td><td></td><td></td><td></td><td class="s"> push @attached, $db_info->{name} if $db_info->{seq} >= 2;</td></tr> |
| 445 | <tr><td class="h"><a name="243"></a>243</td><td></td><td></td><td></td><td></td><td class="s"> }</td></tr> |
| 446 | <tr><td class="h"><a name="244"></a>244</td><td></td><td></td><td></td><td></td><td class="s"> return @attached;</td></tr> |
| 447 | <tr><td class="h"><a name="245"></a>245</td><td></td><td></td><td></td><td></td><td class="s">}</td></tr> |
| 448 | <tr><td class="h"><a name="246"></a>246</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 449 | <tr><td class="h"><a name="247"></a>247</td><td></td><td></td><td></td><td></td><td class="s"># SQL/CLI (ISO/IEC JTC 1/SC 32 N 0595), 6.63 Tables</td></tr> |
| 450 | <tr><td class="h"><a name="248"></a>248</td><td></td><td></td><td></td><td></td><td class="s"># Based on DBD::Oracle's</td></tr> |
| 451 | <tr><td class="h"><a name="249"></a>249</td><td></td><td></td><td></td><td></td><td class="s"># See also http://www.ch-werner.de/sqliteodbc/html/sqlite3odbc_8c.html#a213</td></tr> |
| 452 | <tr><td class="h"><a name="250"></a>250</td><td></td><td></td><td></td><td></td><td class="s">sub table_info {</td></tr> |
| 453 | <tr><td class="h"><a name="251"></a>251</td><td></td><td></td><td></td><td></td><td class="s"> my ($dbh, $cat_val, $sch_val, $tbl_val, $typ_val, $attr) = @_;</td></tr> |
| 454 | <tr><td class="h"><a name="252"></a>252</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 455 | <tr><td class="h"><a name="253"></a>253</td><td></td><td></td><td></td><td></td><td class="s"> my @where = ();</td></tr> |
| 456 | <tr><td class="h"><a name="254"></a>254</td><td></td><td></td><td></td><td></td><td class="s"> my $sql;</td></tr> |
| 457 | <tr><td class="h"><a name="255"></a>255</td><td></td><td></td><td></td><td></td><td class="s"> if ( defined($cat_val) && $cat_val eq '%'</td></tr> |
| 458 | <tr><td class="h"><a name="256"></a>256</td><td></td><td></td><td></td><td></td><td class="s"> && defined($sch_val) && $sch_val eq ''</td></tr> |
| 459 | <tr><td class="h"><a name="257"></a>257</td><td></td><td></td><td></td><td></td><td class="s"> && defined($tbl_val) && $tbl_val eq '') { # Rule 19a</td></tr> |
| 460 | <tr><td class="h"><a name="258"></a>258</td><td></td><td></td><td></td><td></td><td class="s"> $sql = <<'END_SQL';</td></tr> |
| 461 | <tr><td class="h"><a name="259"></a>259</td><td></td><td></td><td></td><td></td><td class="s">SELECT NULL TABLE_CAT</td></tr> |
| 462 | <tr><td class="h"><a name="260"></a>260</td><td></td><td></td><td></td><td></td><td class="s"> , NULL TABLE_SCHEM</td></tr> |
| 463 | <tr><td class="h"><a name="261"></a>261</td><td></td><td></td><td></td><td></td><td class="s"> , NULL TABLE_NAME</td></tr> |
| 464 | <tr><td class="h"><a name="262"></a>262</td><td></td><td></td><td></td><td></td><td class="s"> , NULL TABLE_TYPE</td></tr> |
| 465 | <tr><td class="h"><a name="263"></a>263</td><td></td><td></td><td></td><td></td><td class="s"> , NULL REMARKS</td></tr> |
| 466 | <tr><td class="h"><a name="264"></a>264</td><td></td><td></td><td></td><td></td><td class="s">END_SQL</td></tr> |
| 467 | <tr><td class="h"><a name="265"></a>265</td><td></td><td></td><td></td><td></td><td class="s"> }</td></tr> |
| 468 | <tr><td class="h"><a name="266"></a>266</td><td></td><td></td><td></td><td></td><td class="s"> elsif ( defined($cat_val) && $cat_val eq ''</td></tr> |
| 469 | <tr><td class="h"><a name="267"></a>267</td><td></td><td></td><td></td><td></td><td class="s"> && defined($sch_val) && $sch_val eq '%'</td></tr> |
| 470 | <tr><td class="h"><a name="268"></a>268</td><td></td><td></td><td></td><td></td><td class="s"> && defined($tbl_val) && $tbl_val eq '') { # Rule 19b</td></tr> |
| 471 | <tr><td class="h"><a name="269"></a>269</td><td></td><td></td><td></td><td></td><td class="s"> $sql = <<'END_SQL';</td></tr> |
| 472 | <tr><td class="h"><a name="270"></a>270</td><td></td><td></td><td></td><td></td><td class="s">SELECT NULL TABLE_CAT</td></tr> |
| 473 | <tr><td class="h"><a name="271"></a>271</td><td></td><td></td><td></td><td></td><td class="s"> , t.tn TABLE_SCHEM</td></tr> |
| 474 | <tr><td class="h"><a name="272"></a>272</td><td></td><td></td><td></td><td></td><td class="s"> , NULL TABLE_NAME</td></tr> |
| 475 | <tr><td class="h"><a name="273"></a>273</td><td></td><td></td><td></td><td></td><td class="s"> , NULL TABLE_TYPE</td></tr> |
| 476 | <tr><td class="h"><a name="274"></a>274</td><td></td><td></td><td></td><td></td><td class="s"> , NULL REMARKS</td></tr> |
| 477 | <tr><td class="h"><a name="275"></a>275</td><td></td><td></td><td></td><td></td><td class="s">FROM (</td></tr> |
| 478 | <tr><td class="h"><a name="276"></a>276</td><td></td><td></td><td></td><td></td><td class="s"> SELECT 'main' tn</td></tr> |
| 479 | <tr><td class="h"><a name="277"></a>277</td><td></td><td></td><td></td><td></td><td class="s"> UNION SELECT 'temp' tn</td></tr> |
| 480 | <tr><td class="h"><a name="278"></a>278</td><td></td><td></td><td></td><td></td><td class="s">END_SQL</td></tr> |
| 481 | <tr><td class="h"><a name="279"></a>279</td><td></td><td></td><td></td><td></td><td class="s"> for my $db_name (_attached_database_list($dbh)) {</td></tr> |
| 482 | <tr><td class="h"><a name="280"></a>280</td><td></td><td></td><td></td><td></td><td class="s"> $sql .= " UNION SELECT '$db_name' tn\n";</td></tr> |
| 483 | <tr><td class="h"><a name="281"></a>281</td><td></td><td></td><td></td><td></td><td class="s"> }</td></tr> |
| 484 | <tr><td class="h"><a name="282"></a>282</td><td></td><td></td><td></td><td></td><td class="s"> $sql .= ") t\n";</td></tr> |
| 485 | <tr><td class="h"><a name="283"></a>283</td><td></td><td></td><td></td><td></td><td class="s"> }</td></tr> |
| 486 | <tr><td class="h"><a name="284"></a>284</td><td></td><td></td><td></td><td></td><td class="s"> elsif ( defined($cat_val) && $cat_val eq ''</td></tr> |
| 487 | <tr><td class="h"><a name="285"></a>285</td><td></td><td></td><td></td><td></td><td class="s"> && defined($sch_val) && $sch_val eq ''</td></tr> |
| 488 | <tr><td class="h"><a name="286"></a>286</td><td></td><td></td><td></td><td></td><td class="s"> && defined($tbl_val) && $tbl_val eq ''</td></tr> |
| 489 | <tr><td class="h"><a name="287"></a>287</td><td></td><td></td><td></td><td></td><td class="s"> && defined($typ_val) && $typ_val eq '%') { # Rule 19c</td></tr> |
| 490 | <tr><td class="h"><a name="288"></a>288</td><td></td><td></td><td></td><td></td><td class="s"> $sql = <<'END_SQL';</td></tr> |
| 491 | <tr><td class="h"><a name="289"></a>289</td><td></td><td></td><td></td><td></td><td class="s">SELECT NULL TABLE_CAT</td></tr> |
| 492 | <tr><td class="h"><a name="290"></a>290</td><td></td><td></td><td></td><td></td><td class="s"> , NULL TABLE_SCHEM</td></tr> |
| 493 | <tr><td class="h"><a name="291"></a>291</td><td></td><td></td><td></td><td></td><td class="s"> , NULL TABLE_NAME</td></tr> |
| 494 | <tr><td class="h"><a name="292"></a>292</td><td></td><td></td><td></td><td></td><td class="s"> , t.tt TABLE_TYPE</td></tr> |
| 495 | <tr><td class="h"><a name="293"></a>293</td><td></td><td></td><td></td><td></td><td class="s"> , NULL REMARKS</td></tr> |
| 496 | <tr><td class="h"><a name="294"></a>294</td><td></td><td></td><td></td><td></td><td class="s">FROM (</td></tr> |
| 497 | <tr><td class="h"><a name="295"></a>295</td><td></td><td></td><td></td><td></td><td class="s"> SELECT 'TABLE' tt UNION</td></tr> |
| 498 | <tr><td class="h"><a name="296"></a>296</td><td></td><td></td><td></td><td></td><td class="s"> SELECT 'VIEW' tt UNION</td></tr> |
| 499 | <tr><td class="h"><a name="297"></a>297</td><td></td><td></td><td></td><td></td><td class="s"> SELECT 'LOCAL TEMPORARY' tt</td></tr> |
| 500 | <tr><td class="h"><a name="298"></a>298</td><td></td><td></td><td></td><td></td><td class="s">) t</td></tr> |
| 501 | <tr><td class="h"><a name="299"></a>299</td><td></td><td></td><td></td><td></td><td class="s">ORDER BY TABLE_TYPE</td></tr> |
| 502 | <tr><td class="h"><a name="300"></a>300</td><td></td><td></td><td></td><td></td><td class="s">END_SQL</td></tr> |
| 503 | <tr><td class="h"><a name="301"></a>301</td><td></td><td></td><td></td><td></td><td class="s"> }</td></tr> |
| 504 | <tr><td class="h"><a name="302"></a>302</td><td></td><td></td><td></td><td></td><td class="s"> else {</td></tr> |
| 505 | <tr><td class="h"><a name="303"></a>303</td><td></td><td></td><td></td><td></td><td class="s"> $sql = <<'END_SQL';</td></tr> |
| 506 | <tr><td class="h"><a name="304"></a>304</td><td></td><td></td><td></td><td></td><td class="s">SELECT *</td></tr> |
| 507 | <tr><td class="h"><a name="305"></a>305</td><td></td><td></td><td></td><td></td><td class="s">FROM</td></tr> |
| 508 | <tr><td class="h"><a name="306"></a>306</td><td></td><td></td><td></td><td></td><td class="s">(</td></tr> |
| 509 | <tr><td class="h"><a name="307"></a>307</td><td></td><td></td><td></td><td></td><td class="s">SELECT NULL TABLE_CAT</td></tr> |
| 510 | <tr><td class="h"><a name="308"></a>308</td><td></td><td></td><td></td><td></td><td class="s"> , TABLE_SCHEM</td></tr> |
| 511 | <tr><td class="h"><a name="309"></a>309</td><td></td><td></td><td></td><td></td><td class="s"> , tbl_name TABLE_NAME</td></tr> |
| 512 | <tr><td class="h"><a name="310"></a>310</td><td></td><td></td><td></td><td></td><td class="s"> , TABLE_TYPE</td></tr> |
| 513 | <tr><td class="h"><a name="311"></a>311</td><td></td><td></td><td></td><td></td><td class="s"> , NULL REMARKS</td></tr> |
| 514 | <tr><td class="h"><a name="312"></a>312</td><td></td><td></td><td></td><td></td><td class="s"> , sql sqlite_sql</td></tr> |
| 515 | <tr><td class="h"><a name="313"></a>313</td><td></td><td></td><td></td><td></td><td class="s">FROM (</td></tr> |
| 516 | <tr><td class="h"><a name="314"></a>314</td><td></td><td></td><td></td><td></td><td class="s"> SELECT 'main' TABLE_SCHEM, tbl_name, upper(type) TABLE_TYPE, sql</td></tr> |
| 517 | <tr><td class="h"><a name="315"></a>315</td><td></td><td></td><td></td><td></td><td class="s"> FROM sqlite_master</td></tr> |
| 518 | <tr><td class="h"><a name="316"></a>316</td><td></td><td></td><td></td><td></td><td class="s">UNION ALL</td></tr> |
| 519 | <tr><td class="h"><a name="317"></a>317</td><td></td><td></td><td></td><td></td><td class="s"> SELECT 'temp' TABLE_SCHEM, tbl_name, 'LOCAL TEMPORARY' TABLE_TYPE, sql</td></tr> |
| 520 | <tr><td class="h"><a name="318"></a>318</td><td></td><td></td><td></td><td></td><td class="s"> FROM sqlite_temp_master</td></tr> |
| 521 | <tr><td class="h"><a name="319"></a>319</td><td></td><td></td><td></td><td></td><td class="s">END_SQL</td></tr> |
| 522 | <tr><td class="h"><a name="320"></a>320</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 523 | <tr><td class="h"><a name="321"></a>321</td><td></td><td></td><td></td><td></td><td class="s"> for my $db_name (_attached_database_list($dbh)) {</td></tr> |
| 524 | <tr><td class="h"><a name="322"></a>322</td><td></td><td></td><td></td><td></td><td class="s"> $sql .= <<"END_SQL";</td></tr> |
| 525 | <tr><td class="h"><a name="323"></a>323</td><td></td><td></td><td></td><td></td><td class="s">UNION ALL</td></tr> |
| 526 | <tr><td class="h"><a name="324"></a>324</td><td></td><td></td><td></td><td></td><td class="s"> SELECT '$db_name' TABLE_SCHEM, tbl_name, upper(type) TABLE_TYPE, sql</td></tr> |
| 527 | <tr><td class="h"><a name="325"></a>325</td><td></td><td></td><td></td><td></td><td class="s"> FROM "$db_name".sqlite_master</td></tr> |
| 528 | <tr><td class="h"><a name="326"></a>326</td><td></td><td></td><td></td><td></td><td class="s">END_SQL</td></tr> |
| 529 | <tr><td class="h"><a name="327"></a>327</td><td></td><td></td><td></td><td></td><td class="s"> }</td></tr> |
| 530 | <tr><td class="h"><a name="328"></a>328</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 531 | <tr><td class="h"><a name="329"></a>329</td><td></td><td></td><td></td><td></td><td class="s"> $sql .= <<'END_SQL';</td></tr> |
| 532 | <tr><td class="h"><a name="330"></a>330</td><td></td><td></td><td></td><td></td><td class="s">UNION ALL</td></tr> |
| 533 | <tr><td class="h"><a name="331"></a>331</td><td></td><td></td><td></td><td></td><td class="s"> SELECT 'main' TABLE_SCHEM, 'sqlite_master' tbl_name, 'SYSTEM TABLE' TABLE_TYPE, NULL sql</td></tr> |
| 534 | <tr><td class="h"><a name="332"></a>332</td><td></td><td></td><td></td><td></td><td class="s">UNION ALL</td></tr> |
| 535 | <tr><td class="h"><a name="333"></a>333</td><td></td><td></td><td></td><td></td><td class="s"> SELECT 'temp' TABLE_SCHEM, 'sqlite_temp_master' tbl_name, 'SYSTEM TABLE' TABLE_TYPE, NULL sql</td></tr> |
| 536 | <tr><td class="h"><a name="334"></a>334</td><td></td><td></td><td></td><td></td><td class="s">)</td></tr> |
| 537 | <tr><td class="h"><a name="335"></a>335</td><td></td><td></td><td></td><td></td><td class="s">)</td></tr> |
| 538 | <tr><td class="h"><a name="336"></a>336</td><td></td><td></td><td></td><td></td><td class="s">END_SQL</td></tr> |
| 539 | <tr><td class="h"><a name="337"></a>337</td><td></td><td></td><td></td><td></td><td class="s"> $attr = {} unless ref $attr eq 'HASH';</td></tr> |
| 540 | <tr><td class="h"><a name="338"></a>338</td><td></td><td></td><td></td><td></td><td class="s"> my $escape = defined $attr->{Escape} ? " ESCAPE '$attr->{Escape}'" : '';</td></tr> |
| 541 | <tr><td class="h"><a name="339"></a>339</td><td></td><td></td><td></td><td></td><td class="s"> if ( defined $sch_val ) {</td></tr> |
| 542 | <tr><td class="h"><a name="340"></a>340</td><td></td><td></td><td></td><td></td><td class="s"> push @where, "TABLE_SCHEM LIKE '$sch_val'$escape";</td></tr> |
| 543 | <tr><td class="h"><a name="341"></a>341</td><td></td><td></td><td></td><td></td><td class="s"> }</td></tr> |
| 544 | <tr><td class="h"><a name="342"></a>342</td><td></td><td></td><td></td><td></td><td class="s"> if ( defined $tbl_val ) {</td></tr> |
| 545 | <tr><td class="h"><a name="343"></a>343</td><td></td><td></td><td></td><td></td><td class="s"> push @where, "TABLE_NAME LIKE '$tbl_val'$escape";</td></tr> |
| 546 | <tr><td class="h"><a name="344"></a>344</td><td></td><td></td><td></td><td></td><td class="s"> }</td></tr> |
| 547 | <tr><td class="h"><a name="345"></a>345</td><td></td><td></td><td></td><td></td><td class="s"> if ( defined $typ_val ) {</td></tr> |
| 548 | <tr><td class="h"><a name="346"></a>346</td><td></td><td></td><td></td><td></td><td class="s"> my $table_type_list;</td></tr> |
| 549 | <tr><td class="h"><a name="347"></a>347</td><td></td><td></td><td></td><td></td><td class="s"> $typ_val =~ s/^\s+//;</td></tr> |
| 550 | <tr><td class="h"><a name="348"></a>348</td><td></td><td></td><td></td><td></td><td class="s"> $typ_val =~ s/\s+$//;</td></tr> |
| 551 | <tr><td class="h"><a name="349"></a>349</td><td></td><td></td><td></td><td></td><td class="s"> my @ttype_list = split (/\s*,\s*/, $typ_val);</td></tr> |
| 552 | <tr><td class="h"><a name="350"></a>350</td><td></td><td></td><td></td><td></td><td class="s"> foreach my $table_type (@ttype_list) {</td></tr> |
| 553 | <tr><td class="h"><a name="351"></a>351</td><td></td><td></td><td></td><td></td><td class="s"> if ($table_type !~ /^'.*'$/) {</td></tr> |
| 554 | <tr><td class="h"><a name="352"></a>352</td><td></td><td></td><td></td><td></td><td class="s"> $table_type = "'" . $table_type . "'";</td></tr> |
| 555 | <tr><td class="h"><a name="353"></a>353</td><td></td><td></td><td></td><td></td><td class="s"> }</td></tr> |
| 556 | <tr><td class="h"><a name="354"></a>354</td><td></td><td></td><td></td><td></td><td class="s"> }</td></tr> |
| 557 | <tr><td class="h"><a name="355"></a>355</td><td></td><td></td><td></td><td></td><td class="s"> $table_type_list = join(', ', @ttype_list);</td></tr> |
| 558 | <tr><td class="h"><a name="356"></a>356</td><td></td><td></td><td></td><td></td><td class="s"> push @where, "TABLE_TYPE IN (\U$table_type_list)" if $table_type_list;</td></tr> |
| 559 | <tr><td class="h"><a name="357"></a>357</td><td></td><td></td><td></td><td></td><td class="s"> }</td></tr> |
| 560 | <tr><td class="h"><a name="358"></a>358</td><td></td><td></td><td></td><td></td><td class="s"> $sql .= ' WHERE ' . join("\n AND ", @where ) . "\n" if @where;</td></tr> |
| 561 | <tr><td class="h"><a name="359"></a>359</td><td></td><td></td><td></td><td></td><td class="s"> $sql .= " ORDER BY TABLE_TYPE, TABLE_SCHEM, TABLE_NAME\n";</td></tr> |
| 562 | <tr><td class="h"><a name="360"></a>360</td><td></td><td></td><td></td><td></td><td class="s"> }</td></tr> |
| 563 | <tr><td class="h"><a name="361"></a>361</td><td></td><td></td><td></td><td></td><td class="s"> my $sth = $dbh->prepare($sql) or return undef;</td></tr> |
| 564 | <tr><td class="h"><a name="362"></a>362</td><td></td><td></td><td></td><td></td><td class="s"> $sth->execute or return undef;</td></tr> |
| 565 | <tr><td class="h"><a name="363"></a>363</td><td></td><td></td><td></td><td></td><td class="s"> $sth;</td></tr> |
| 566 | <tr><td class="h"><a name="364"></a>364</td><td></td><td></td><td></td><td></td><td class="s">}</td></tr> |
| 567 | <tr><td class="h"><a name="365"></a>365</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 568 | <tr><td class="h"><a name="366"></a>366</td><td></td><td></td><td></td><td></td><td class="s">sub primary_key_info {</td></tr> |
| 569 | <tr><td class="h"><a name="367"></a>367</td><td></td><td></td><td></td><td></td><td class="s"> my ($dbh, $catalog, $schema, $table, $attr) = @_;</td></tr> |
| 570 | <tr><td class="h"><a name="368"></a>368</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 571 | <tr><td class="h"><a name="369"></a>369</td><td></td><td></td><td></td><td></td><td class="s"> # Escape the schema and table name</td></tr> |
| 572 | <tr><td class="h"><a name="370"></a>370</td><td></td><td></td><td></td><td></td><td class="s"> $schema =~ s/([\\_%])/\\$1/g if defined $schema;</td></tr> |
| 573 | <tr><td class="h"><a name="371"></a>371</td><td></td><td></td><td></td><td></td><td class="s"> my $escaped = $table;</td></tr> |
| 574 | <tr><td class="h"><a name="372"></a>372</td><td></td><td></td><td></td><td></td><td class="s"> $escaped =~ s/([\\_%])/\\$1/g;</td></tr> |
| 575 | <tr><td class="h"><a name="373"></a>373</td><td></td><td></td><td></td><td></td><td class="s"> $attr ||= {};</td></tr> |
| 576 | <tr><td class="h"><a name="374"></a>374</td><td></td><td></td><td></td><td></td><td class="s"> $attr->{Escape} = '\\';</td></tr> |
| 577 | <tr><td class="h"><a name="375"></a>375</td><td></td><td></td><td></td><td></td><td class="s"> my $sth_tables = $dbh->table_info($catalog, $schema, $escaped, undef, $attr);</td></tr> |
| 578 | <tr><td class="h"><a name="376"></a>376</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 579 | <tr><td class="h"><a name="377"></a>377</td><td></td><td></td><td></td><td></td><td class="s"> # This is a hack but much simpler than using pragma index_list etc</td></tr> |
| 580 | <tr><td class="h"><a name="378"></a>378</td><td></td><td></td><td></td><td></td><td class="s"> # also the pragma doesn't list 'INTEGER PRIMARY KEY' autoinc PKs!</td></tr> |
| 581 | <tr><td class="h"><a name="379"></a>379</td><td></td><td></td><td></td><td></td><td class="s"> my @pk_info;</td></tr> |
| 582 | <tr><td class="h"><a name="380"></a>380</td><td></td><td></td><td></td><td></td><td class="s"> while ( my $row = $sth_tables->fetchrow_hashref ) {</td></tr> |
| 583 | <tr><td class="h"><a name="381"></a>381</td><td></td><td></td><td></td><td></td><td class="s"> my $sql = $row->{sqlite_sql} or next;</td></tr> |
| 584 | <tr><td class="h"><a name="382"></a>382</td><td></td><td></td><td></td><td></td><td class="s"> next unless $sql =~ /(.*?)\s*PRIMARY\s+KEY\s*(?:\(\s*(.*?)\s*\))?/si;</td></tr> |
| 585 | <tr><td class="h"><a name="383"></a>383</td><td></td><td></td><td></td><td></td><td class="s"> my @pk = split /\s*,\s*/, $2 || '';</td></tr> |
| 586 | <tr><td class="h"><a name="384"></a>384</td><td></td><td></td><td></td><td></td><td class="s"> unless ( @pk ) {</td></tr> |
| 587 | <tr><td class="h"><a name="385"></a>385</td><td></td><td></td><td></td><td></td><td class="s"> my $prefix = $1;</td></tr> |
| 588 | <tr><td class="h"><a name="386"></a>386</td><td></td><td></td><td></td><td></td><td class="s"> $prefix =~ s/.*create\s+table\s+.*?\(\s*//si;</td></tr> |
| 589 | <tr><td class="h"><a name="387"></a>387</td><td></td><td></td><td></td><td></td><td class="s"> $prefix = (split /\s*,\s*/, $prefix)[-1];</td></tr> |
| 590 | <tr><td class="h"><a name="388"></a>388</td><td></td><td></td><td></td><td></td><td class="s"> @pk = (split /\s+/, $prefix)[0]; # take first word as name</td></tr> |
| 591 | <tr><td class="h"><a name="389"></a>389</td><td></td><td></td><td></td><td></td><td class="s"> }</td></tr> |
| 592 | <tr><td class="h"><a name="390"></a>390</td><td></td><td></td><td></td><td></td><td class="s"> my $key_seq = 0;</td></tr> |
| 593 | <tr><td class="h"><a name="391"></a>391</td><td></td><td></td><td></td><td></td><td class="s"> foreach my $pk_field (@pk) {</td></tr> |
| 594 | <tr><td class="h"><a name="392"></a>392</td><td></td><td></td><td></td><td></td><td class="s"> $pk_field =~ s/(["'`])(.+)\1/$2/; # dequote</td></tr> |
| 595 | <tr><td class="h"><a name="393"></a>393</td><td></td><td></td><td></td><td></td><td class="s"> $pk_field =~ s/\[(.+)\]/$1/; # dequote</td></tr> |
| 596 | <tr><td class="h"><a name="394"></a>394</td><td></td><td></td><td></td><td></td><td class="s"> push @pk_info, {</td></tr> |
| 597 | <tr><td class="h"><a name="395"></a>395</td><td></td><td></td><td></td><td></td><td class="s"> TABLE_SCHEM => $row->{TABLE_SCHEM},</td></tr> |
| 598 | <tr><td class="h"><a name="396"></a>396</td><td></td><td></td><td></td><td></td><td class="s"> TABLE_NAME => $row->{TABLE_NAME},</td></tr> |
| 599 | <tr><td class="h"><a name="397"></a>397</td><td></td><td></td><td></td><td></td><td class="s"> COLUMN_NAME => $pk_field,</td></tr> |
| 600 | <tr><td class="h"><a name="398"></a>398</td><td></td><td></td><td></td><td></td><td class="s"> KEY_SEQ => ++$key_seq,</td></tr> |
| 601 | <tr><td class="h"><a name="399"></a>399</td><td></td><td></td><td></td><td></td><td class="s"> PK_NAME => 'PRIMARY KEY',</td></tr> |
| 602 | <tr><td class="h"><a name="400"></a>400</td><td></td><td></td><td></td><td></td><td class="s"> };</td></tr> |
| 603 | <tr><td class="h"><a name="401"></a>401</td><td></td><td></td><td></td><td></td><td class="s"> }</td></tr> |
| 604 | <tr><td class="h"><a name="402"></a>402</td><td></td><td></td><td></td><td></td><td class="s"> }</td></tr> |
| 605 | <tr><td class="h"><a name="403"></a>403</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 606 | <tr><td class="h"><a name="404"></a>404</td><td></td><td></td><td></td><td></td><td class="s"> my $sponge = DBI->connect("DBI:Sponge:", '','')</td></tr> |
| 607 | <tr><td class="h"><a name="405"></a>405</td><td></td><td></td><td></td><td></td><td class="s"> or return $dbh->DBI::set_err($DBI::err, "DBI::Sponge: $DBI::errstr");</td></tr> |
| 608 | <tr><td class="h"><a name="406"></a>406</td><td></td><td></td><td></td><td></td><td class="s"> my @names = qw(TABLE_CAT TABLE_SCHEM TABLE_NAME COLUMN_NAME KEY_SEQ PK_NAME);</td></tr> |
| 609 | <tr><td class="h"><a name="407"></a>407</td><td></td><td></td><td></td><td></td><td class="s"> my $sth = $sponge->prepare( "primary_key_info $table", {</td></tr> |
| 610 | <tr><td class="h"><a name="408"></a>408</td><td></td><td></td><td></td><td></td><td class="s"> rows => [ map { [ @{$_}{@names} ] } @pk_info ],</td></tr> |
| 611 | <tr><td class="h"><a name="409"></a>409</td><td></td><td></td><td></td><td></td><td class="s"> NUM_OF_FIELDS => scalar @names,</td></tr> |
| 612 | <tr><td class="h"><a name="410"></a>410</td><td></td><td></td><td></td><td></td><td class="s"> NAME => \@names,</td></tr> |
| 613 | <tr><td class="h"><a name="411"></a>411</td><td></td><td></td><td></td><td></td><td class="s"> }) or return $dbh->DBI::set_err(</td></tr> |
| 614 | <tr><td class="h"><a name="412"></a>412</td><td></td><td></td><td></td><td></td><td class="s"> $sponge->err,</td></tr> |
| 615 | <tr><td class="h"><a name="413"></a>413</td><td></td><td></td><td></td><td></td><td class="s"> $sponge->errstr,</td></tr> |
| 616 | <tr><td class="h"><a name="414"></a>414</td><td></td><td></td><td></td><td></td><td class="s"> );</td></tr> |
| 617 | <tr><td class="h"><a name="415"></a>415</td><td></td><td></td><td></td><td></td><td class="s"> return $sth;</td></tr> |
| 618 | <tr><td class="h"><a name="416"></a>416</td><td></td><td></td><td></td><td></td><td class="s">}</td></tr> |
| 619 | <tr><td class="h"><a name="417"></a>417</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 620 | <tr><td class="h"><a name="418"></a>418</td><td></td><td></td><td></td><td></td><td class="s">sub type_info_all {</td></tr> |
| 621 | <tr><td class="h"><a name="419"></a>419</td><td></td><td></td><td></td><td></td><td class="s"> return; # XXX code just copied from DBD::Oracle, not yet thought about</td></tr> |
| 622 | <tr><td class="h"><a name="420"></a>420</td><td></td><td></td><td></td><td></td><td class="s"># return [</td></tr> |
| 623 | <tr><td class="h"><a name="421"></a>421</td><td></td><td></td><td></td><td></td><td class="s"># {</td></tr> |
| 624 | <tr><td class="h"><a name="422"></a>422</td><td></td><td></td><td></td><td></td><td class="s"># TYPE_NAME => 0,</td></tr> |
| 625 | <tr><td class="h"><a name="423"></a>423</td><td></td><td></td><td></td><td></td><td class="s"># DATA_TYPE => 1,</td></tr> |
| 626 | <tr><td class="h"><a name="424"></a>424</td><td></td><td></td><td></td><td></td><td class="s"># COLUMN_SIZE => 2,</td></tr> |
| 627 | <tr><td class="h"><a name="425"></a>425</td><td></td><td></td><td></td><td></td><td class="s"># LITERAL_PREFIX => 3,</td></tr> |
| 628 | <tr><td class="h"><a name="426"></a>426</td><td></td><td></td><td></td><td></td><td class="s"># LITERAL_SUFFIX => 4,</td></tr> |
| 629 | <tr><td class="h"><a name="427"></a>427</td><td></td><td></td><td></td><td></td><td class="s"># CREATE_PARAMS => 5,</td></tr> |
| 630 | <tr><td class="h"><a name="428"></a>428</td><td></td><td></td><td></td><td></td><td class="s"># NULLABLE => 6,</td></tr> |
| 631 | <tr><td class="h"><a name="429"></a>429</td><td></td><td></td><td></td><td></td><td class="s"># CASE_SENSITIVE => 7,</td></tr> |
| 632 | <tr><td class="h"><a name="430"></a>430</td><td></td><td></td><td></td><td></td><td class="s"># SEARCHABLE => 8,</td></tr> |
| 633 | <tr><td class="h"><a name="431"></a>431</td><td></td><td></td><td></td><td></td><td class="s"># UNSIGNED_ATTRIBUTE => 9,</td></tr> |
| 634 | <tr><td class="h"><a name="432"></a>432</td><td></td><td></td><td></td><td></td><td class="s"># FIXED_PREC_SCALE => 10,</td></tr> |
| 635 | <tr><td class="h"><a name="433"></a>433</td><td></td><td></td><td></td><td></td><td class="s"># AUTO_UNIQUE_VALUE => 11,</td></tr> |
| 636 | <tr><td class="h"><a name="434"></a>434</td><td></td><td></td><td></td><td></td><td class="s"># LOCAL_TYPE_NAME => 12,</td></tr> |
| 637 | <tr><td class="h"><a name="435"></a>435</td><td></td><td></td><td></td><td></td><td class="s"># MINIMUM_SCALE => 13,</td></tr> |
| 638 | <tr><td class="h"><a name="436"></a>436</td><td></td><td></td><td></td><td></td><td class="s"># MAXIMUM_SCALE => 14,</td></tr> |
| 639 | <tr><td class="h"><a name="437"></a>437</td><td></td><td></td><td></td><td></td><td class="s"># SQL_DATA_TYPE => 15,</td></tr> |
| 640 | <tr><td class="h"><a name="438"></a>438</td><td></td><td></td><td></td><td></td><td class="s"># SQL_DATETIME_SUB => 16,</td></tr> |
| 641 | <tr><td class="h"><a name="439"></a>439</td><td></td><td></td><td></td><td></td><td class="s"># NUM_PREC_RADIX => 17,</td></tr> |
| 642 | <tr><td class="h"><a name="440"></a>440</td><td></td><td></td><td></td><td></td><td class="s"># },</td></tr> |
| 643 | <tr><td class="h"><a name="441"></a>441</td><td></td><td></td><td></td><td></td><td class="s"># [ 'CHAR', 1, 255, '\'', '\'', 'max length', 1, 1, 3,</td></tr> |
| 644 | <tr><td class="h"><a name="442"></a>442</td><td></td><td></td><td></td><td></td><td class="s"># undef, '0', '0', undef, undef, undef, 1, undef, undef</td></tr> |
| 645 | <tr><td class="h"><a name="443"></a>443</td><td></td><td></td><td></td><td></td><td class="s"># ],</td></tr> |
| 646 | <tr><td class="h"><a name="444"></a>444</td><td></td><td></td><td></td><td></td><td class="s"># [ 'NUMBER', 3, 38, undef, undef, 'precision,scale', 1, '0', 3,</td></tr> |
| 647 | <tr><td class="h"><a name="445"></a>445</td><td></td><td></td><td></td><td></td><td class="s"># '0', '0', '0', undef, '0', 38, 3, undef, 10</td></tr> |
| 648 | <tr><td class="h"><a name="446"></a>446</td><td></td><td></td><td></td><td></td><td class="s"># ],</td></tr> |
| 649 | <tr><td class="h"><a name="447"></a>447</td><td></td><td></td><td></td><td></td><td class="s"># [ 'DOUBLE', 8, 15, undef, undef, undef, 1, '0', 3,</td></tr> |
| 650 | <tr><td class="h"><a name="448"></a>448</td><td></td><td></td><td></td><td></td><td class="s"># '0', '0', '0', undef, undef, undef, 8, undef, 10</td></tr> |
| 651 | <tr><td class="h"><a name="449"></a>449</td><td></td><td></td><td></td><td></td><td class="s"># ],</td></tr> |
| 652 | <tr><td class="h"><a name="450"></a>450</td><td></td><td></td><td></td><td></td><td class="s"># [ 'DATE', 9, 19, '\'', '\'', undef, 1, '0', 3,</td></tr> |
| 653 | <tr><td class="h"><a name="451"></a>451</td><td></td><td></td><td></td><td></td><td class="s"># undef, '0', '0', undef, '0', '0', 11, undef, undef</td></tr> |
| 654 | <tr><td class="h"><a name="452"></a>452</td><td></td><td></td><td></td><td></td><td class="s"># ],</td></tr> |
| 655 | <tr><td class="h"><a name="453"></a>453</td><td></td><td></td><td></td><td></td><td class="s"># [ 'VARCHAR', 12, 1024*1024, '\'', '\'', 'max length', 1, 1, 3,</td></tr> |
| 656 | <tr><td class="h"><a name="454"></a>454</td><td></td><td></td><td></td><td></td><td class="s"># undef, '0', '0', undef, undef, undef, 12, undef, undef</td></tr> |
| 657 | <tr><td class="h"><a name="455"></a>455</td><td></td><td></td><td></td><td></td><td class="s"># ]</td></tr> |
| 658 | <tr><td class="h"><a name="456"></a>456</td><td></td><td></td><td></td><td></td><td class="s"># ];</td></tr> |
| 659 | <tr><td class="h"><a name="457"></a>457</td><td></td><td></td><td></td><td></td><td class="s">}</td></tr> |
| 660 | <tr><td class="h"><a name="458"></a>458</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 661 | <tr><td class="h"><a name="459"></a>459</td><td class="c3">1</td><td class="c3"><span title="Avg 5µs">5µs</span></td><td></td><td></td><td class="s">my @COLUMN_INFO = qw(</td></tr> |
| 662 | <tr><td class="h"><a name="460"></a>460</td><td></td><td></td><td></td><td></td><td class="s"> TABLE_CAT</td></tr> |
| 663 | <tr><td class="h"><a name="461"></a>461</td><td></td><td></td><td></td><td></td><td class="s"> TABLE_SCHEM</td></tr> |
| 664 | <tr><td class="h"><a name="462"></a>462</td><td></td><td></td><td></td><td></td><td class="s"> TABLE_NAME</td></tr> |
| 665 | <tr><td class="h"><a name="463"></a>463</td><td></td><td></td><td></td><td></td><td class="s"> COLUMN_NAME</td></tr> |
| 666 | <tr><td class="h"><a name="464"></a>464</td><td></td><td></td><td></td><td></td><td class="s"> DATA_TYPE</td></tr> |
| 667 | <tr><td class="h"><a name="465"></a>465</td><td></td><td></td><td></td><td></td><td class="s"> TYPE_NAME</td></tr> |
| 668 | <tr><td class="h"><a name="466"></a>466</td><td></td><td></td><td></td><td></td><td class="s"> COLUMN_SIZE</td></tr> |
| 669 | <tr><td class="h"><a name="467"></a>467</td><td></td><td></td><td></td><td></td><td class="s"> BUFFER_LENGTH</td></tr> |
| 670 | <tr><td class="h"><a name="468"></a>468</td><td></td><td></td><td></td><td></td><td class="s"> DECIMAL_DIGITS</td></tr> |
| 671 | <tr><td class="h"><a name="469"></a>469</td><td></td><td></td><td></td><td></td><td class="s"> NUM_PREC_RADIX</td></tr> |
| 672 | <tr><td class="h"><a name="470"></a>470</td><td></td><td></td><td></td><td></td><td class="s"> NULLABLE</td></tr> |
| 673 | <tr><td class="h"><a name="471"></a>471</td><td></td><td></td><td></td><td></td><td class="s"> REMARKS</td></tr> |
| 674 | <tr><td class="h"><a name="472"></a>472</td><td></td><td></td><td></td><td></td><td class="s"> COLUMN_DEF</td></tr> |
| 675 | <tr><td class="h"><a name="473"></a>473</td><td></td><td></td><td></td><td></td><td class="s"> SQL_DATA_TYPE</td></tr> |
| 676 | <tr><td class="h"><a name="474"></a>474</td><td></td><td></td><td></td><td></td><td class="s"> SQL_DATETIME_SUB</td></tr> |
| 677 | <tr><td class="h"><a name="475"></a>475</td><td></td><td></td><td></td><td></td><td class="s"> CHAR_OCTET_LENGTH</td></tr> |
| 678 | <tr><td class="h"><a name="476"></a>476</td><td></td><td></td><td></td><td></td><td class="s"> ORDINAL_POSITION</td></tr> |
| 679 | <tr><td class="h"><a name="477"></a>477</td><td></td><td></td><td></td><td></td><td class="s"> IS_NULLABLE</td></tr> |
| 680 | <tr><td class="h"><a name="478"></a>478</td><td></td><td></td><td></td><td></td><td class="s">);</td></tr> |
| 681 | <tr><td class="h"><a name="479"></a>479</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 682 | <tr><td class="h"><a name="480"></a>480</td><td></td><td></td><td></td><td></td><td class="s">sub column_info {</td></tr> |
| 683 | <tr><td class="h"><a name="481"></a>481</td><td></td><td></td><td></td><td></td><td class="s"> my ($dbh, $cat_val, $sch_val, $tbl_val, $col_val) = @_;</td></tr> |
| 684 | <tr><td class="h"><a name="482"></a>482</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 685 | <tr><td class="h"><a name="483"></a>483</td><td></td><td></td><td></td><td></td><td class="s"> if ( defined $col_val and $col_val eq '%' ) {</td></tr> |
| 686 | <tr><td class="h"><a name="484"></a>484</td><td></td><td></td><td></td><td></td><td class="s"> $col_val = undef;</td></tr> |
| 687 | <tr><td class="h"><a name="485"></a>485</td><td></td><td></td><td></td><td></td><td class="s"> }</td></tr> |
| 688 | <tr><td class="h"><a name="486"></a>486</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 689 | <tr><td class="h"><a name="487"></a>487</td><td></td><td></td><td></td><td></td><td class="s"> # Get a list of all tables ordered by TABLE_SCHEM, TABLE_NAME</td></tr> |
| 690 | <tr><td class="h"><a name="488"></a>488</td><td></td><td></td><td></td><td></td><td class="s"> my $sql = <<'END_SQL';</td></tr> |
| 691 | <tr><td class="h"><a name="489"></a>489</td><td></td><td></td><td></td><td></td><td class="s">SELECT TABLE_SCHEM, tbl_name TABLE_NAME</td></tr> |
| 692 | <tr><td class="h"><a name="490"></a>490</td><td></td><td></td><td></td><td></td><td class="s">FROM (</td></tr> |
| 693 | <tr><td class="h"><a name="491"></a>491</td><td></td><td></td><td></td><td></td><td class="s"> SELECT 'main' TABLE_SCHEM, tbl_name</td></tr> |
| 694 | <tr><td class="h"><a name="492"></a>492</td><td></td><td></td><td></td><td></td><td class="s"> FROM sqlite_master</td></tr> |
| 695 | <tr><td class="h"><a name="493"></a>493</td><td></td><td></td><td></td><td></td><td class="s"> WHERE type IN ('table','view')</td></tr> |
| 696 | <tr><td class="h"><a name="494"></a>494</td><td></td><td></td><td></td><td></td><td class="s">UNION ALL</td></tr> |
| 697 | <tr><td class="h"><a name="495"></a>495</td><td></td><td></td><td></td><td></td><td class="s"> SELECT 'temp' TABLE_SCHEM, tbl_name</td></tr> |
| 698 | <tr><td class="h"><a name="496"></a>496</td><td></td><td></td><td></td><td></td><td class="s"> FROM sqlite_temp_master</td></tr> |
| 699 | <tr><td class="h"><a name="497"></a>497</td><td></td><td></td><td></td><td></td><td class="s"> WHERE type IN ('table','view')</td></tr> |
| 700 | <tr><td class="h"><a name="498"></a>498</td><td></td><td></td><td></td><td></td><td class="s">END_SQL</td></tr> |
| 701 | <tr><td class="h"><a name="499"></a>499</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 702 | <tr><td class="h"><a name="500"></a>500</td><td></td><td></td><td></td><td></td><td class="s"> for my $db_name (_attached_database_list($dbh)) {</td></tr> |
| 703 | <tr><td class="h"><a name="501"></a>501</td><td></td><td></td><td></td><td></td><td class="s"> $sql .= <<"END_SQL";</td></tr> |
| 704 | <tr><td class="h"><a name="502"></a>502</td><td></td><td></td><td></td><td></td><td class="s">UNION ALL</td></tr> |
| 705 | <tr><td class="h"><a name="503"></a>503</td><td></td><td></td><td></td><td></td><td class="s"> SELECT '$db_name' TABLE_SCHEM, tbl_name</td></tr> |
| 706 | <tr><td class="h"><a name="504"></a>504</td><td></td><td></td><td></td><td></td><td class="s"> FROM "$db_name".sqlite_master</td></tr> |
| 707 | <tr><td class="h"><a name="505"></a>505</td><td></td><td></td><td></td><td></td><td class="s"> WHERE type IN ('table','view')</td></tr> |
| 708 | <tr><td class="h"><a name="506"></a>506</td><td></td><td></td><td></td><td></td><td class="s">END_SQL</td></tr> |
| 709 | <tr><td class="h"><a name="507"></a>507</td><td></td><td></td><td></td><td></td><td class="s"> }</td></tr> |
| 710 | <tr><td class="h"><a name="508"></a>508</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 711 | <tr><td class="h"><a name="509"></a>509</td><td></td><td></td><td></td><td></td><td class="s"> $sql .= <<'END_SQL';</td></tr> |
| 712 | <tr><td class="h"><a name="510"></a>510</td><td></td><td></td><td></td><td></td><td class="s">UNION ALL</td></tr> |
| 713 | <tr><td class="h"><a name="511"></a>511</td><td></td><td></td><td></td><td></td><td class="s"> SELECT 'main' TABLE_SCHEM, 'sqlite_master' tbl_name</td></tr> |
| 714 | <tr><td class="h"><a name="512"></a>512</td><td></td><td></td><td></td><td></td><td class="s">UNION ALL</td></tr> |
| 715 | <tr><td class="h"><a name="513"></a>513</td><td></td><td></td><td></td><td></td><td class="s"> SELECT 'temp' TABLE_SCHEM, 'sqlite_temp_master' tbl_name</td></tr> |
| 716 | <tr><td class="h"><a name="514"></a>514</td><td></td><td></td><td></td><td></td><td class="s">)</td></tr> |
| 717 | <tr><td class="h"><a name="515"></a>515</td><td></td><td></td><td></td><td></td><td class="s">END_SQL</td></tr> |
| 718 | <tr><td class="h"><a name="516"></a>516</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 719 | <tr><td class="h"><a name="517"></a>517</td><td></td><td></td><td></td><td></td><td class="s"> my @where;</td></tr> |
| 720 | <tr><td class="h"><a name="518"></a>518</td><td></td><td></td><td></td><td></td><td class="s"> if ( defined $sch_val ) {</td></tr> |
| 721 | <tr><td class="h"><a name="519"></a>519</td><td></td><td></td><td></td><td></td><td class="s"> push @where, "TABLE_SCHEM LIKE '$sch_val'";</td></tr> |
| 722 | <tr><td class="h"><a name="520"></a>520</td><td></td><td></td><td></td><td></td><td class="s"> }</td></tr> |
| 723 | <tr><td class="h"><a name="521"></a>521</td><td></td><td></td><td></td><td></td><td class="s"> if ( defined $tbl_val ) {</td></tr> |
| 724 | <tr><td class="h"><a name="522"></a>522</td><td></td><td></td><td></td><td></td><td class="s"> push @where, "TABLE_NAME LIKE '$tbl_val'";</td></tr> |
| 725 | <tr><td class="h"><a name="523"></a>523</td><td></td><td></td><td></td><td></td><td class="s"> }</td></tr> |
| 726 | <tr><td class="h"><a name="524"></a>524</td><td></td><td></td><td></td><td></td><td class="s"> $sql .= ' WHERE ' . join("\n AND ", @where ) . "\n" if @where;</td></tr> |
| 727 | <tr><td class="h"><a name="525"></a>525</td><td></td><td></td><td></td><td></td><td class="s"> $sql .= " ORDER BY TABLE_SCHEM, TABLE_NAME\n";</td></tr> |
| 728 | <tr><td class="h"><a name="526"></a>526</td><td></td><td></td><td></td><td></td><td class="s"> my $sth_tables = $dbh->prepare($sql) or return undef;</td></tr> |
| 729 | <tr><td class="h"><a name="527"></a>527</td><td></td><td></td><td></td><td></td><td class="s"> $sth_tables->execute or return undef;</td></tr> |
| 730 | <tr><td class="h"><a name="528"></a>528</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 731 | <tr><td class="h"><a name="529"></a>529</td><td></td><td></td><td></td><td></td><td class="s"> # Taken from Fey::Loader::SQLite</td></tr> |
| 732 | <tr><td class="h"><a name="530"></a>530</td><td></td><td></td><td></td><td></td><td class="s"> my @cols;</td></tr> |
| 733 | <tr><td class="h"><a name="531"></a>531</td><td></td><td></td><td></td><td></td><td class="s"> while ( my ($schema, $table) = $sth_tables->fetchrow_array ) {</td></tr> |
| 734 | <tr><td class="h"><a name="532"></a>532</td><td></td><td></td><td></td><td></td><td class="s"> my $sth_columns = $dbh->prepare(qq{PRAGMA "$schema".table_info("$table")});</td></tr> |
| 735 | <tr><td class="h"><a name="533"></a>533</td><td></td><td></td><td></td><td></td><td class="s"> $sth_columns->execute;</td></tr> |
| 736 | <tr><td class="h"><a name="534"></a>534</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 737 | <tr><td class="h"><a name="535"></a>535</td><td></td><td></td><td></td><td></td><td class="s"> for ( my $position = 1; my $col_info = $sth_columns->fetchrow_hashref; $position++ ) {</td></tr> |
| 738 | <tr><td class="h"><a name="536"></a>536</td><td></td><td></td><td></td><td></td><td class="s"> if ( defined $col_val ) {</td></tr> |
| 739 | <tr><td class="h"><a name="537"></a>537</td><td></td><td></td><td></td><td></td><td class="s"> # This must do a LIKE comparison</td></tr> |
| 740 | <tr><td class="h"><a name="538"></a>538</td><td></td><td></td><td></td><td></td><td class="s"> my $sth = $dbh->prepare("SELECT '$col_info->{name}' LIKE '$col_val'") or return undef;</td></tr> |
| 741 | <tr><td class="h"><a name="539"></a>539</td><td></td><td></td><td></td><td></td><td class="s"> $sth->execute or return undef;</td></tr> |
| 742 | <tr><td class="h"><a name="540"></a>540</td><td></td><td></td><td></td><td></td><td class="s"> # Skip columns that don't match $col_val</td></tr> |
| 743 | <tr><td class="h"><a name="541"></a>541</td><td></td><td></td><td></td><td></td><td class="s"> next unless ($sth->fetchrow_array)[0];</td></tr> |
| 744 | <tr><td class="h"><a name="542"></a>542</td><td></td><td></td><td></td><td></td><td class="s"> }</td></tr> |
| 745 | <tr><td class="h"><a name="543"></a>543</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 746 | <tr><td class="h"><a name="544"></a>544</td><td></td><td></td><td></td><td></td><td class="s"> my %col = (</td></tr> |
| 747 | <tr><td class="h"><a name="545"></a>545</td><td></td><td></td><td></td><td></td><td class="s"> TABLE_SCHEM => $schema,</td></tr> |
| 748 | <tr><td class="h"><a name="546"></a>546</td><td></td><td></td><td></td><td></td><td class="s"> TABLE_NAME => $table,</td></tr> |
| 749 | <tr><td class="h"><a name="547"></a>547</td><td></td><td></td><td></td><td></td><td class="s"> COLUMN_NAME => $col_info->{name},</td></tr> |
| 750 | <tr><td class="h"><a name="548"></a>548</td><td></td><td></td><td></td><td></td><td class="s"> ORDINAL_POSITION => $position,</td></tr> |
| 751 | <tr><td class="h"><a name="549"></a>549</td><td></td><td></td><td></td><td></td><td class="s"> );</td></tr> |
| 752 | <tr><td class="h"><a name="550"></a>550</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 753 | <tr><td class="h"><a name="551"></a>551</td><td></td><td></td><td></td><td></td><td class="s"> my $type = $col_info->{type};</td></tr> |
| 754 | <tr><td class="h"><a name="552"></a>552</td><td></td><td></td><td></td><td></td><td class="s"> if ( $type =~ s/(\w+) ?\((\d+)(?:,(\d+))?\)/$1/ ) {</td></tr> |
| 755 | <tr><td class="h"><a name="553"></a>553</td><td></td><td></td><td></td><td></td><td class="s"> $col{COLUMN_SIZE} = $2;</td></tr> |
| 756 | <tr><td class="h"><a name="554"></a>554</td><td></td><td></td><td></td><td></td><td class="s"> $col{DECIMAL_DIGITS} = $3;</td></tr> |
| 757 | <tr><td class="h"><a name="555"></a>555</td><td></td><td></td><td></td><td></td><td class="s"> }</td></tr> |
| 758 | <tr><td class="h"><a name="556"></a>556</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 759 | <tr><td class="h"><a name="557"></a>557</td><td></td><td></td><td></td><td></td><td class="s"> $col{TYPE_NAME} = $type;</td></tr> |
| 760 | <tr><td class="h"><a name="558"></a>558</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 761 | <tr><td class="h"><a name="559"></a>559</td><td></td><td></td><td></td><td></td><td class="s"> if ( defined $col_info->{dflt_value} ) {</td></tr> |
| 762 | <tr><td class="h"><a name="560"></a>560</td><td></td><td></td><td></td><td></td><td class="s"> $col{COLUMN_DEF} = $col_info->{dflt_value}</td></tr> |
| 763 | <tr><td class="h"><a name="561"></a>561</td><td></td><td></td><td></td><td></td><td class="s"> }</td></tr> |
| 764 | <tr><td class="h"><a name="562"></a>562</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 765 | <tr><td class="h"><a name="563"></a>563</td><td></td><td></td><td></td><td></td><td class="s"> if ( $col_info->{notnull} ) {</td></tr> |
| 766 | <tr><td class="h"><a name="564"></a>564</td><td></td><td></td><td></td><td></td><td class="s"> $col{NULLABLE} = 0;</td></tr> |
| 767 | <tr><td class="h"><a name="565"></a>565</td><td></td><td></td><td></td><td></td><td class="s"> $col{IS_NULLABLE} = 'NO';</td></tr> |
| 768 | <tr><td class="h"><a name="566"></a>566</td><td></td><td></td><td></td><td></td><td class="s"> } else {</td></tr> |
| 769 | <tr><td class="h"><a name="567"></a>567</td><td></td><td></td><td></td><td></td><td class="s"> $col{NULLABLE} = 1;</td></tr> |
| 770 | <tr><td class="h"><a name="568"></a>568</td><td></td><td></td><td></td><td></td><td class="s"> $col{IS_NULLABLE} = 'YES';</td></tr> |
| 771 | <tr><td class="h"><a name="569"></a>569</td><td></td><td></td><td></td><td></td><td class="s"> }</td></tr> |
| 772 | <tr><td class="h"><a name="570"></a>570</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 773 | <tr><td class="h"><a name="571"></a>571</td><td></td><td></td><td></td><td></td><td class="s"> push @cols, \%col;</td></tr> |
| 774 | <tr><td class="h"><a name="572"></a>572</td><td></td><td></td><td></td><td></td><td class="s"> }</td></tr> |
| 775 | <tr><td class="h"><a name="573"></a>573</td><td></td><td></td><td></td><td></td><td class="s"> $sth_columns->finish;</td></tr> |
| 776 | <tr><td class="h"><a name="574"></a>574</td><td></td><td></td><td></td><td></td><td class="s"> }</td></tr> |
| 777 | <tr><td class="h"><a name="575"></a>575</td><td></td><td></td><td></td><td></td><td class="s"> $sth_tables->finish;</td></tr> |
| 778 | <tr><td class="h"><a name="576"></a>576</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 779 | <tr><td class="h"><a name="577"></a>577</td><td></td><td></td><td></td><td></td><td class="s"> my $sponge = DBI->connect("DBI:Sponge:", '','')</td></tr> |
| 780 | <tr><td class="h"><a name="578"></a>578</td><td></td><td></td><td></td><td></td><td class="s"> or return $dbh->DBI::set_err($DBI::err, "DBI::Sponge: $DBI::errstr");</td></tr> |
| 781 | <tr><td class="h"><a name="579"></a>579</td><td></td><td></td><td></td><td></td><td class="s"> $sponge->prepare( "column_info", {</td></tr> |
| 782 | <tr><td class="h"><a name="580"></a>580</td><td></td><td></td><td></td><td></td><td class="s"> rows => [ map { [ @{$_}{@COLUMN_INFO} ] } @cols ],</td></tr> |
| 783 | <tr><td class="h"><a name="581"></a>581</td><td></td><td></td><td></td><td></td><td class="s"> NUM_OF_FIELDS => scalar @COLUMN_INFO,</td></tr> |
| 784 | <tr><td class="h"><a name="582"></a>582</td><td></td><td></td><td></td><td></td><td class="s"> NAME => [ @COLUMN_INFO ],</td></tr> |
| 785 | <tr><td class="h"><a name="583"></a>583</td><td></td><td></td><td></td><td></td><td class="s"> } ) or return $dbh->DBI::set_err(</td></tr> |
| 786 | <tr><td class="h"><a name="584"></a>584</td><td></td><td></td><td></td><td></td><td class="s"> $sponge->err,</td></tr> |
| 787 | <tr><td class="h"><a name="585"></a>585</td><td></td><td></td><td></td><td></td><td class="s"> $sponge->errstr,</td></tr> |
| 788 | <tr><td class="h"><a name="586"></a>586</td><td></td><td></td><td></td><td></td><td class="s"> );</td></tr> |
| 789 | <tr><td class="h"><a name="587"></a>587</td><td></td><td></td><td></td><td></td><td class="s">}</td></tr> |
| 790 | <tr><td class="h"><a name="588"></a>588</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 791 | <tr><td class="h"><a name="589"></a>589</td><td></td><td></td><td></td><td></td><td class="s">#======================================================================</td></tr> |
| 792 | <tr><td class="h"><a name="590"></a>590</td><td></td><td></td><td></td><td></td><td class="s"># An internal tied hash package used for %DBD::SQLite::COLLATION, to</td></tr> |
| 793 | <tr><td class="h"><a name="591"></a>591</td><td></td><td></td><td></td><td></td><td class="s"># prevent people from unintentionally overriding globally registered collations.</td></tr> |
| 794 | <tr><td class="h"><a name="592"></a>592</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 795 | <tr><td class="h"><a name="593"></a>593</td><td></td><td></td><td></td><td></td><td class="s">package DBD::SQLite::_WriteOnceHash;</td></tr> |
| 796 | <tr><td class="h"><a name="594"></a>594</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 797 | <tr><td class="h"><a name="595"></a>595</td><td class="c3">1</td><td class="c3"><span title="Avg 1µs">1µs</span></td><td></td><td></td><td class="s">require Tie::Hash;</td></tr> |
| 798 | <tr><td class="h"><a name="596"></a>596</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 799 | <tr><td class="h"><a name="597"></a>597</td><td class="c3">1</td><td class="c1"><span title="Avg 8µs">8µs</span></td><td></td><td></td><td class="s">our @ISA = qw(Tie::StdHash);</td></tr> |
| 800 | <tr><td class="h"><a name="598"></a>598</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 801 | <tr><td class="h"><a name="599"></a>599</td><td></td><td></td><td></td><td></td><td class="s"><div class="calls"><div class="calls_in"># spent 10µs within DBD::SQLite::_WriteOnceHash::TIEHASH which was called: |
| 802 | # once (10µs+0s) by DBI::install_driver at <a href="DBD-SQLite-pm-2618-line.html#32">line 32</a></div></div>sub TIEHASH {</td></tr> |
| 803 | <tr><td class="h"><a name="600"></a>600</td><td class="c3">1</td><td class="c0"><span title="Avg 13µs">13µs</span></td><td></td><td></td><td class="s"> bless {}, $_[0];</td></tr> |
| 804 | <tr><td class="h"><a name="601"></a>601</td><td></td><td></td><td></td><td></td><td class="s">}</td></tr> |
| 805 | <tr><td class="h"><a name="602"></a>602</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 806 | <tr><td class="h"><a name="603"></a>603</td><td></td><td></td><td></td><td></td><td class="s"><div class="calls"><div class="calls_in"># spent 6µs within DBD::SQLite::_WriteOnceHash::STORE which was called 2 times, avg 3µs/call: |
| 807 | # once (4µs+0s) by DBI::install_driver at <a href="DBD-SQLite-pm-2618-line.html#33">line 33</a> |
| 808 | # once (2µs+0s) by DBI::install_driver at <a href="DBD-SQLite-pm-2618-line.html#34">line 34</a></div></div>sub STORE {</td></tr> |
| 809 | <tr><td class="h"><a name="604"></a>604</td><td class="c1">2</td><td class="c3"><span title="Avg 750ns">2µs</span></td><td></td><td></td><td class="s"> ! exists $_[0]->{$_[1]} or die "entry $_[1] already registered";</td></tr> |
| 810 | <tr><td class="h"><a name="605"></a>605</td><td class="c1">2</td><td class="c1"><span title="Avg 4µs">8µs</span></td><td></td><td></td><td class="s"> $_[0]->{$_[1]} = $_[2];</td></tr> |
| 811 | <tr><td class="h"><a name="606"></a>606</td><td></td><td></td><td></td><td></td><td class="s">}</td></tr> |
| 812 | <tr><td class="h"><a name="607"></a>607</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 813 | <tr><td class="h"><a name="608"></a>608</td><td></td><td></td><td></td><td></td><td class="s">sub DELETE {</td></tr> |
| 814 | <tr><td class="h"><a name="609"></a>609</td><td></td><td></td><td></td><td></td><td class="s"> die "deletion of entry $_[1] is forbidden";</td></tr> |
| 815 | <tr><td class="h"><a name="610"></a>610</td><td></td><td></td><td></td><td></td><td class="s">}</td></tr> |
| 816 | <tr><td class="h"><a name="611"></a>611</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 817 | <tr><td class="h"><a name="612"></a>612</td><td class="c3">1</td><td class="c0"><span title="Avg 21µs">21µs</span></td><td></td><td></td><td class="s">1;</td></tr> |
| 818 | <tr><td class="h"><a name="613"></a>613</td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 819 | <tr><td class="h"><a name="614"></a>614</td><td></td><td></td><td></td><td></td><td class="s">__END__</td></tr> |
| 820 | <tr><td class="s"><a name=""></a> </td><td></td><td></td><td></td><td></td><td class="s"></td></tr> |
| 821 | <tr><td class="h"><a name="DBD__SQLite__bootstrap"></a></td><td></td><td></td><td></td><td></td><td class="s"><div class="calls"><div class="calls_in"># spent 209µs within DBD::SQLite::bootstrap which was called: |
| 822 | # once (209µs+0s) by DynaLoader::bootstrap at <a href="DynaLoader-pm-71-line.html#217">line 217 of DynaLoader.pm</a></div></div>sub DBD::SQLite::bootstrap; # xsub<br /> </td></tr> |
| 823 | <tr><td class="h"><a name="DBD__SQLite__db___login"></a></td><td></td><td></td><td></td><td></td><td class="s"><div class="calls"><div class="calls_in"># spent 73.7ms within DBD::SQLite::db::_login which was called: |
| 824 | # once (73.7ms+0s) by DBD::SQLite::dr::connect at <a href="DBD-SQLite-pm-2618-line.html#124">line 124</a></div></div>sub DBD::SQLite::db::_login; # xsub<br /> </td></tr> |
| 825 | <tr><td class="h"><a name="DBD__SQLite__dr__CORE_match"></a></td><td></td><td></td><td></td><td></td><td class="s"><div class="calls"><div class="calls_in"># spent 5µs within DBD::SQLite::dr::CORE:match which was called 3 times, avg 2µs/call: |
| 826 | # once (3µs+0s) by DBD::SQLite::dr::connect at <a href="DBD-SQLite-pm-2618-line.html#95">line 95</a> |
| 827 | # once (1µs+0s) by DBD::SQLite::dr::connect at <a href="DBD-SQLite-pm-2618-line.html#92">line 92</a> |
| 828 | # once (800ns+0s) by DBD::SQLite::dr::connect at <a href="DBD-SQLite-pm-2618-line.html#105">line 105</a></div></div>sub DBD::SQLite::dr::CORE:match; # opcode<br /> </td></tr> |
| 829 | </tbody></table></div> |
| 830 | |
| 831 | <script type="text/javascript"> $(document).ready(function() { |
| 832 | |
| 833 | $("#subs_table").tablesorter({ |
| 834 | sortList: [[3,1]], |
| 835 | headers: { |
| 836 | 3: { sorter: 'fmt_time' }, |
| 837 | 4: { sorter: 'fmt_time' } |
| 838 | } |
| 839 | }); |
| 840 | |
| 841 | } ); </script> |
| 842 | |
| 843 | <div class="footer">Report produced by the |
| 844 | <a href="http://search.cpan.org/dist/Devel-NYTProf/">NYTProf 4.06</a> |
| 845 | Perl profiler, developed by |
| 846 | <a href="http://www.linkedin.com/in/timbunce">Tim Bunce</a> and |
| 847 | <a href="http://code.nytimes.com">Adam Kaplan</a>. |
| 848 | </div> |
| 849 | <br /><br /><br /><br /><br /><br /><br /><br /><br /><br /> |
| 850 | </body></html> |
projects / scpubgit/stemmatology.git / blame