projects / scpubgit/stemmatology.git / blame
? search:
summary | shortlog | log | commit | commitdiff | tree
blob | history | HEAD
nytprof run results of /variantgraph/<ID> and /relation/<ID>/relationships
[scpubgit/stemmatology.git] / stemmaweb / nytprof-runs / variantgraph-uuid / DBIx-Class-Storage-DBI-SQLite-pm-2615-line.html
CommitLineData
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<!--
4This 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 DBIx/Class/Storage/DBI/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 &micro; ? */
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">&larr; Index</a>
48 </div>
49<div class="headerForeground" style="float: left">
50 <span class="siteTitle">NYTProf Performance Profile</span>
51 <span class="siteSubtitle">&emsp;&emsp;<span>&laquo;&emsp;<span class="mode_btn"><a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-block.html">block view</a></span>&emsp;&bull;&emsp;<span class="mode_btn mode_btn_selected">line view</span>&emsp;&bull;&emsp;<span class="mode_btn"><a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-sub.html">sub view</a></span>&emsp;&raquo;</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">&nbsp;</span>
57 <span class="siteSubtitle">Run on Thu May 31 16:29:39 2012<br />Reported on Thu May 31 16:41:14 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/DBIx/Class/Storage/DBI/SQLite.pm">/Users/edenc/perl5/lib/perl5/DBIx/Class/Storage/DBI/SQLite.pm</a></td></tr>
114<tr><td class="h">Statements</td><td align="left">Executed 43 statements in 1.21ms</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="c0">24</td><td class="c3">1</td><td class="c3">1</td><td class="c0"><span title="0.0%">96&micro;s</span></td><td class="c0"><span title="0.0%">154&micro;s</span></td><td class="sub_name"><span style="display: none;">DBIx::Class::Storage::DBI::SQLite::::bind_attribute_by_data_type</span>DBIx::Class::Storage::DBI::SQLite::<a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-line.html#93">bind_attribute_by_data_type</a></span></td></tr>
130<tr><td class="c0">24</td><td class="c3">1</td><td class="c3">1</td><td class="c0"><span title="0.0%">58&micro;s</span></td><td class="c0"><span title="0.0%">58&micro;s</span></td><td class="sub_name"><span style="display: none;">DBIx::Class::Storage::DBI::SQLite::::CORE:match</span>DBIx::Class::Storage::DBI::SQLite::<a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-line.html#DBIx__Class__Storage__DBI__SQLite__CORE_match">CORE:match</a>&nbsp;(opcode)</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%">19&micro;s</span></td><td class="c3"><span title="0.0%">24&micro;s</span></td><td class="sub_name"><span style="display: none;">DBIx::Class::Storage::DBI::SQLite::::BEGIN@3</span>DBIx::Class::Storage::DBI::SQLite::<a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-line.html#3">BEGIN@3</a></span></td></tr>
132<tr><td class="c0">6</td><td class="c0">5</td><td class="c1">2</td><td class="c2"><span title="0.0%">13&micro;s</span></td><td class="c3"><span title="0.0%">14&micro;s</span></td><td class="sub_name"><span style="display: none;">DBIx::Class::Storage::DBI::SQLite::::_dbh_autocommit</span>DBIx::Class::Storage::DBI::SQLite::<a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-line.html#DBIx__Class__Storage__DBI__SQLite___dbh_autocommit">_dbh_autocommit</a>&nbsp;(xsub)</span></td></tr>
133<tr><td class="c3">1</td><td class="c3">1</td><td class="c3">1</td><td class="c3"><span title="0.0%">12&micro;s</span></td><td class="c0"><span title="0.0%">134&micro;s</span></td><td class="sub_name"><span style="display: none;">DBIx::Class::Storage::DBI::SQLite::::BEGIN@6</span>DBIx::Class::Storage::DBI::SQLite::<a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-line.html#6">BEGIN@6</a></span></td></tr>
134<tr><td class="c3">1</td><td class="c3">1</td><td class="c3">1</td><td class="c3"><span title="0.0%">11&micro;s</span></td><td class="c0"><span title="0.0%">91&micro;s</span></td><td class="sub_name"><span style="display: none;">DBIx::Class::Storage::DBI::SQLite::::BEGIN@9</span>DBIx::Class::Storage::DBI::SQLite::<a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-line.html#9">BEGIN@9</a></span></td></tr>
135<tr><td class="c3">1</td><td class="c3">1</td><td class="c3">1</td><td class="c3"><span title="0.0%">10&micro;s</span></td><td class="c3"><span title="0.0%">19&micro;s</span></td><td class="sub_name"><span style="display: none;">DBIx::Class::Storage::DBI::SQLite::::BEGIN@7</span>DBIx::Class::Storage::DBI::SQLite::<a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-line.html#7">BEGIN@7</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%">10&micro;s</span></td><td class="c1"><span title="0.0%">46&micro;s</span></td><td class="sub_name"><span style="display: none;">DBIx::Class::Storage::DBI::SQLite::::BEGIN@10</span>DBIx::Class::Storage::DBI::SQLite::<a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-line.html#10">BEGIN@10</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%">9&micro;s</span></td><td class="c3"><span title="0.0%">18&micro;s</span></td><td class="sub_name"><span style="display: none;">DBIx::Class::Storage::DBI::SQLite::::BEGIN@4</span>DBIx::Class::Storage::DBI::SQLite::<a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-line.html#4">BEGIN@4</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%">8&micro;s</span></td><td class="c0"><span title="0.0%">178&micro;s</span></td><td class="sub_name"><span style="display: none;">DBIx::Class::Storage::DBI::SQLite::::BEGIN@11</span>DBIx::Class::Storage::DBI::SQLite::<a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-line.html#11">BEGIN@11</a></span></td></tr>
139<tr><td class="c0">3</td><td class="c0">3</td><td class="c1">2</td><td class="c3"><span title="0.0%">8&micro;s</span></td><td class="c3"><span title="0.0%">8&micro;s</span></td><td class="sub_name"><span style="display: none;">DBIx::Class::Storage::DBI::SQLite::::debug</span>DBIx::Class::Storage::DBI::SQLite::<a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-line.html#DBIx__Class__Storage__DBI__SQLite__debug">debug</a>&nbsp;(xsub)</span></td></tr>
140<tr><td class="c0">6</td><td class="c0">5</td><td class="c0">3</td><td class="c3"><span title="0.0%">5&micro;s</span></td><td class="c3"><span title="0.0%">5&micro;s</span></td><td class="sub_name"><span style="display: none;">DBIx::Class::Storage::DBI::SQLite::::transaction_depth</span>DBIx::Class::Storage::DBI::SQLite::<a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-line.html#DBIx__Class__Storage__DBI__SQLite__transaction_depth">transaction_depth</a>&nbsp;(xsub)</span></td></tr>
141<tr><td class="c0">3</td><td class="c0">3</td><td class="c1">2</td><td class="c3"><span title="0.0%">4&micro;s</span></td><td class="c3"><span title="0.0%">4&micro;s</span></td><td class="sub_name"><span style="display: none;">DBIx::Class::Storage::DBI::SQLite::::auto_savepoint</span>DBIx::Class::Storage::DBI::SQLite::<a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-line.html#DBIx__Class__Storage__DBI__SQLite__auto_savepoint">auto_savepoint</a>&nbsp;(xsub)</span></td></tr>
142<tr><td class="c0">3</td><td class="c0">3</td><td class="c1">2</td><td class="c3"><span title="0.0%">4&micro;s</span></td><td class="c3"><span title="0.0%">4&micro;s</span></td><td class="sub_name"><span style="display: none;">DBIx::Class::Storage::DBI::SQLite::::_conn_pid</span>DBIx::Class::Storage::DBI::SQLite::<a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-line.html#DBIx__Class__Storage__DBI__SQLite___conn_pid">_conn_pid</a>&nbsp;(xsub)</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%">600ns</span></td><td class="c3"><span title="0.0%">600ns</span></td><td class="sub_name"><span style="display: none;">DBIx::Class::Storage::DBI::SQLite::::unsafe</span>DBIx::Class::Storage::DBI::SQLite::<a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-line.html#DBIx__Class__Storage__DBI__SQLite__unsafe">unsafe</a>&nbsp;(xsub)</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%">500ns</span></td><td class="c3"><span title="0.0%">500ns</span></td><td class="sub_name"><span style="display: none;">DBIx::Class::Storage::DBI::SQLite::::on_connect_do</span>DBIx::Class::Storage::DBI::SQLite::<a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-line.html#DBIx__Class__Storage__DBI__SQLite__on_connect_do">on_connect_do</a>&nbsp;(xsub)</span></td></tr>
145<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;">DBIx::Class::Storage::DBI::SQLite::::_dbi_attrs_for_bind</span>DBIx::Class::Storage::DBI::SQLite::<a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-line.html#109">_dbi_attrs_for_bind</a></span></td></tr>
146<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;">DBIx::Class::Storage::DBI::SQLite::::_exec_svp_begin</span>DBIx::Class::Storage::DBI::SQLite::<a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-line.html#54">_exec_svp_begin</a></span></td></tr>
147<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;">DBIx::Class::Storage::DBI::SQLite::::_exec_svp_release</span>DBIx::Class::Storage::DBI::SQLite::<a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-line.html#60">_exec_svp_release</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;">DBIx::Class::Storage::DBI::SQLite::::_exec_svp_rollback</span>DBIx::Class::Storage::DBI::SQLite::<a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-line.html#66">_exec_svp_rollback</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;">DBIx::Class::Storage::DBI::SQLite::::backup</span>DBIx::Class::Storage::DBI::SQLite::<a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-line.html#18">backup</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;">DBIx::Class::Storage::DBI::SQLite::::connect_call_use_foreign_keys</span>DBIx::Class::Storage::DBI::SQLite::<a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-line.html#151">connect_call_use_foreign_keys</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;">DBIx::Class::Storage::DBI::SQLite::::deployment_statements</span>DBIx::Class::Storage::DBI::SQLite::<a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-line.html#76">deployment_statements</a></span></td></tr>
152</tbody></table>
153 Call graph for these subroutines as a
154 <a href="http://en.wikipedia.org/wiki/Graphviz">Graphviz</a>
155 <a href="Users-edenc-perl5-lib-perl5-DBIx-Class-Storage-DBI-SQLite-pm.dot">dot language file</a>.
156
157 <table border="1" cellpadding="0">
158 <thead>
159 <tr><th>Line</th>
160 <th><span title="Number of statements executed">State<br />ments</span></th>
161 <th><span title="Time spend executing statements on the line,
162 excluding time spent executing statements in any called subroutines">Time<br />on line</span></th>
163 <th><span title="Number of subroutines calls">Calls</span></th>
164 <th><span title="Time spent in subroutines called (inclusive)">Time<br />in subs</span></th>
165 <th class="left_indent_header">Code</th>
166 </tr>
167
168 </thead>
169 <tbody>
170 <tr><td class="h"><a name="1"></a>1</td><td></td><td></td><td></td><td></td><td class="s">package DBIx::Class::Storage::DBI::SQLite;</td></tr>
171<tr><td class="h"><a name="2"></a>2</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
172<tr><td class="h"><a name="3"></a>3</td><td class="c3">2</td><td class="c3"><span title="Avg 14&micro;s">28&micro;s</span></td><td class="c3">2</td><td class="c3">28&micro;s</td><td class="s"><div class="calls"><div class="calls_in"># spent 24&micro;s (19+4) within DBIx::Class::Storage::DBI::SQLite::BEGIN@3 which was called:
173# once (19&micro;s+4&micro;s) by Class::C3::Componentised::ensure_class_loaded at <a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-line.html#3">line 3</a></div></div>use strict;<div class="calls"><div class="calls_out"># spent 24&micro;s making 1 call to <a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-line.html#3">DBIx::Class::Storage::DBI::SQLite::BEGIN@3</a>
174# spent 4&micro;s making 1 call to <a href="strict-pm-3-line.html#34">strict::import</a></div></div></td></tr>
175<tr><td class="h"><a name="4"></a>4</td><td class="c3">2</td><td class="c3"><span title="Avg 15&micro;s">30&micro;s</span></td><td class="c3">2</td><td class="c3">27&micro;s</td><td class="s"><div class="calls"><div class="calls_in"># spent 18&micro;s (9+9) within DBIx::Class::Storage::DBI::SQLite::BEGIN@4 which was called:
176# once (9&micro;s+9&micro;s) by Class::C3::Componentised::ensure_class_loaded at <a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-line.html#4">line 4</a></div></div>use warnings;<div class="calls"><div class="calls_out"># spent 18&micro;s making 1 call to <a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-line.html#4">DBIx::Class::Storage::DBI::SQLite::BEGIN@4</a>
177# spent 9&micro;s making 1 call to <a href="warnings-pm-2-line.html#386">warnings::import</a></div></div></td></tr>
178<tr><td class="h"><a name="5"></a>5</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
179<tr><td class="h"><a name="6"></a>6</td><td class="c3">2</td><td class="c3"><span title="Avg 17&micro;s">34&micro;s</span></td><td class="c3">2</td><td class="c0">256&micro;s</td><td class="s"><div class="calls"><div class="calls_in"># spent 134&micro;s (12+122) within DBIx::Class::Storage::DBI::SQLite::BEGIN@6 which was called:
180# once (12&micro;s+122&micro;s) by Class::C3::Componentised::ensure_class_loaded at <a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-line.html#6">line 6</a></div></div>use base qw/DBIx::Class::Storage::DBI/;<div class="calls"><div class="calls_out"># spent 134&micro;s making 1 call to <a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-line.html#6">DBIx::Class::Storage::DBI::SQLite::BEGIN@6</a>
181# spent 122&micro;s making 1 call to <a href="base-pm-22-line.html#58">base::import</a></div></div></td></tr>
182<tr><td class="h"><a name="7"></a>7</td><td class="c3">2</td><td class="c3"><span title="Avg 14&micro;s">28&micro;s</span></td><td class="c3">2</td><td class="c3">28&micro;s</td><td class="s"><div class="calls"><div class="calls_in"># spent 19&micro;s (10+9) within DBIx::Class::Storage::DBI::SQLite::BEGIN@7 which was called:
183# once (10&micro;s+9&micro;s) by Class::C3::Componentised::ensure_class_loaded at <a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-line.html#7">line 7</a></div></div>use mro 'c3';<div class="calls"><div class="calls_out"># spent 19&micro;s making 1 call to <a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-line.html#7">DBIx::Class::Storage::DBI::SQLite::BEGIN@7</a>
184# spent 9&micro;s making 1 call to <a href="mro-pm-85-line.html#17">mro::import</a></div></div></td></tr>
185<tr><td class="h"><a name="8"></a>8</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
186<tr><td class="h"><a name="9"></a>9</td><td class="c3">2</td><td class="c3"><span title="Avg 14&micro;s">28&micro;s</span></td><td class="c3">2</td><td class="c0">171&micro;s</td><td class="s"><div class="calls"><div class="calls_in"># spent 91&micro;s (11+80) within DBIx::Class::Storage::DBI::SQLite::BEGIN@9 which was called:
187# once (11&micro;s+80&micro;s) by Class::C3::Componentised::ensure_class_loaded at <a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-line.html#9">line 9</a></div></div>use DBIx::Class::Carp;<div class="calls"><div class="calls_out"># spent 91&micro;s making 1 call to <a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-line.html#9">DBIx::Class::Storage::DBI::SQLite::BEGIN@9</a>
188# spent 80&micro;s making 1 call to <a href="DBIx-Class-Carp-pm-2169-line.html#66">DBIx::Class::Carp::import</a></div></div></td></tr>
189<tr><td class="h"><a name="10"></a>10</td><td class="c3">2</td><td class="c3"><span title="Avg 13&micro;s">25&micro;s</span></td><td class="c3">2</td><td class="c1">83&micro;s</td><td class="s"><div class="calls"><div class="calls_in"># spent 46&micro;s (10+37) within DBIx::Class::Storage::DBI::SQLite::BEGIN@10 which was called:
190# once (10&micro;s+37&micro;s) by Class::C3::Componentised::ensure_class_loaded at <a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-line.html#10">line 10</a></div></div>use Scalar::Util 'looks_like_number';<div class="calls"><div class="calls_out"># spent 46&micro;s making 1 call to <a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-line.html#10">DBIx::Class::Storage::DBI::SQLite::BEGIN@10</a>
191# spent 37&micro;s making 1 call to <a href="Exporter-pm-8-line.html#28">Exporter::import</a></div></div></td></tr>
192<tr><td class="h"><a name="11"></a>11</td><td class="c3">2</td><td class="c0"><span title="Avg 407&micro;s">815&micro;s</span></td><td class="c3">2</td><td class="c0">347&micro;s</td><td class="s"><div class="calls"><div class="calls_in"># spent 178&micro;s (8+170) within DBIx::Class::Storage::DBI::SQLite::BEGIN@11 which was called:
193# once (8&micro;s+170&micro;s) by Class::C3::Componentised::ensure_class_loaded at <a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-line.html#11">line 11</a></div></div>use namespace::clean;<div class="calls"><div class="calls_out"># spent 178&micro;s making 1 call to <a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-line.html#11">DBIx::Class::Storage::DBI::SQLite::BEGIN@11</a>
194# spent 170&micro;s making 1 call to <a href="namespace-clean-pm-379-line.html#288">namespace::clean::import</a></div></div></td></tr>
195<tr><td class="h"><a name="12"></a>12</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
196<tr><td class="h"><a name="13"></a>13</td><td class="c3">1</td><td class="c3"><span title="Avg 13&micro;s">13&micro;s</span></td><td class="c3">1</td><td class="c3">51&micro;s</td><td class="s">__PACKAGE__-&gt;sql_maker_class('DBIx::Class::SQLMaker::SQLite');<div class="calls"><div class="calls_out"># spent 51&micro;s making 1 call to <a href="script-nytprof-pl-1-line.html#DBIx__Class__Storage__DBI__sql_maker_class">DBIx::Class::Storage::DBI::sql_maker_class</a></div></div></td></tr>
197<tr><td class="h"><a name="14"></a>14</td><td class="c3">1</td><td class="c3"><span title="Avg 6&micro;s">6&micro;s</span></td><td class="c3">1</td><td class="c3">19&micro;s</td><td class="s">__PACKAGE__-&gt;sql_limit_dialect ('LimitOffset');<div class="calls"><div class="calls_out"># spent 19&micro;s making 1 call to <a href="script-nytprof-pl-1-line.html#DBIx__Class__Storage__DBI__sql_limit_dialect">DBIx::Class::Storage::DBI::sql_limit_dialect</a></div></div></td></tr>
198<tr><td class="h"><a name="15"></a>15</td><td class="c3">1</td><td class="c3"><span title="Avg 5&micro;s">5&micro;s</span></td><td class="c3">1</td><td class="c3">19&micro;s</td><td class="s">__PACKAGE__-&gt;sql_quote_char ('&quot;');<div class="calls"><div class="calls_out"># spent 19&micro;s making 1 call to <a href="script-nytprof-pl-1-line.html#DBIx__Class__Storage__DBI__sql_quote_char">DBIx::Class::Storage::DBI::sql_quote_char</a></div></div></td></tr>
199<tr><td class="h"><a name="16"></a>16</td><td class="c3">1</td><td class="c3"><span title="Avg 5&micro;s">5&micro;s</span></td><td class="c3">1</td><td class="c3">4&micro;s</td><td class="s">__PACKAGE__-&gt;datetime_parser_type ('DateTime::Format::SQLite');<div class="calls"><div class="calls_out"># spent 4&micro;s making 1 call to <a href="script-nytprof-pl-1-line.html#DBIx__Class__Storage__DBI__datetime_parser_type">DBIx::Class::Storage::DBI::datetime_parser_type</a></div></div></td></tr>
200<tr><td class="h"><a name="17"></a>17</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
201<tr><td class="h"><a name="18"></a>18</td><td></td><td></td><td></td><td></td><td class="s">sub backup {</td></tr>
202<tr><td class="h"><a name="19"></a>19</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
203<tr><td class="h"><a name="20"></a>20</td><td></td><td></td><td></td><td></td><td class="s"> require File::Spec;</td></tr>
204<tr><td class="h"><a name="21"></a>21</td><td></td><td></td><td></td><td></td><td class="s"> require File::Copy;</td></tr>
205<tr><td class="h"><a name="22"></a>22</td><td></td><td></td><td></td><td></td><td class="s"> require POSIX;</td></tr>
206<tr><td class="h"><a name="23"></a>23</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
207<tr><td class="h"><a name="24"></a>24</td><td></td><td></td><td></td><td></td><td class="s"> my ($self, $dir) = @_;</td></tr>
208<tr><td class="h"><a name="25"></a>25</td><td></td><td></td><td></td><td></td><td class="s"> $dir ||= './';</td></tr>
209<tr><td class="h"><a name="26"></a>26</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
210<tr><td class="h"><a name="27"></a>27</td><td></td><td></td><td></td><td></td><td class="s"> ## Where is the db file?</td></tr>
211<tr><td class="h"><a name="28"></a>28</td><td></td><td></td><td></td><td></td><td class="s"> my $dsn = $self-&gt;_dbi_connect_info()-&gt;[0];</td></tr>
212<tr><td class="h"><a name="29"></a>29</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
213<tr><td class="h"><a name="30"></a>30</td><td></td><td></td><td></td><td></td><td class="s"> my $dbname = $1 if($dsn =~ /dbname=([^;]+)/);</td></tr>
214<tr><td class="h"><a name="31"></a>31</td><td></td><td></td><td></td><td></td><td class="s"> if(!$dbname)</td></tr>
215<tr><td class="h"><a name="32"></a>32</td><td></td><td></td><td></td><td></td><td class="s"> {</td></tr>
216<tr><td class="h"><a name="33"></a>33</td><td></td><td></td><td></td><td></td><td class="s"> $dbname = $1 if($dsn =~ /^dbi:SQLite:(.+)$/i);</td></tr>
217<tr><td class="h"><a name="34"></a>34</td><td></td><td></td><td></td><td></td><td class="s"> }</td></tr>
218<tr><td class="h"><a name="35"></a>35</td><td></td><td></td><td></td><td></td><td class="s"> $self-&gt;throw_exception(&quot;Cannot determine name of SQLite db file&quot;)</td></tr>
219<tr><td class="h"><a name="36"></a>36</td><td></td><td></td><td></td><td></td><td class="s"> if(!$dbname || !-f $dbname);</td></tr>
220<tr><td class="h"><a name="37"></a>37</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
221<tr><td class="h"><a name="38"></a>38</td><td></td><td></td><td></td><td></td><td class="s"># print &quot;Found database: $dbname\n&quot;;</td></tr>
222<tr><td class="h"><a name="39"></a>39</td><td></td><td></td><td></td><td></td><td class="s"># my $dbfile = file($dbname);</td></tr>
223<tr><td class="h"><a name="40"></a>40</td><td></td><td></td><td></td><td></td><td class="s"> my ($vol, $dbdir, $file) = File::Spec-&gt;splitpath($dbname);</td></tr>
224<tr><td class="h"><a name="41"></a>41</td><td></td><td></td><td></td><td></td><td class="s"># my $file = $dbfile-&gt;basename();</td></tr>
225<tr><td class="h"><a name="42"></a>42</td><td></td><td></td><td></td><td></td><td class="s"> $file = POSIX::strftime(&quot;%Y-%m-%d-%H_%M_%S&quot;, localtime()) . $file;</td></tr>
226<tr><td class="h"><a name="43"></a>43</td><td></td><td></td><td></td><td></td><td class="s"> $file = &quot;B$file&quot; while(-f $file);</td></tr>
227<tr><td class="h"><a name="44"></a>44</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
228<tr><td class="h"><a name="45"></a>45</td><td></td><td></td><td></td><td></td><td class="s"> mkdir($dir) unless -f $dir;</td></tr>
229<tr><td class="h"><a name="46"></a>46</td><td></td><td></td><td></td><td></td><td class="s"> my $backupfile = File::Spec-&gt;catfile($dir, $file);</td></tr>
230<tr><td class="h"><a name="47"></a>47</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
231<tr><td class="h"><a name="48"></a>48</td><td></td><td></td><td></td><td></td><td class="s"> my $res = File::Copy::copy($dbname, $backupfile);</td></tr>
232<tr><td class="h"><a name="49"></a>49</td><td></td><td></td><td></td><td></td><td class="s"> $self-&gt;throw_exception(&quot;Backup failed! ($!)&quot;) if(!$res);</td></tr>
233<tr><td class="h"><a name="50"></a>50</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
234<tr><td class="h"><a name="51"></a>51</td><td></td><td></td><td></td><td></td><td class="s"> return $backupfile;</td></tr>
235<tr><td class="h"><a name="52"></a>52</td><td></td><td></td><td></td><td></td><td class="s">}</td></tr>
236<tr><td class="h"><a name="53"></a>53</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
237<tr><td class="h"><a name="54"></a>54</td><td></td><td></td><td></td><td></td><td class="s">sub _exec_svp_begin {</td></tr>
238<tr><td class="h"><a name="55"></a>55</td><td></td><td></td><td></td><td></td><td class="s"> my ($self, $name) = @_;</td></tr>
239<tr><td class="h"><a name="56"></a>56</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
240<tr><td class="h"><a name="57"></a>57</td><td></td><td></td><td></td><td></td><td class="s"> $self-&gt;_dbh-&gt;do(&quot;SAVEPOINT $name&quot;);</td></tr>
241<tr><td class="h"><a name="58"></a>58</td><td></td><td></td><td></td><td></td><td class="s">}</td></tr>
242<tr><td class="h"><a name="59"></a>59</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
243<tr><td class="h"><a name="60"></a>60</td><td></td><td></td><td></td><td></td><td class="s">sub _exec_svp_release {</td></tr>
244<tr><td class="h"><a name="61"></a>61</td><td></td><td></td><td></td><td></td><td class="s"> my ($self, $name) = @_;</td></tr>
245<tr><td class="h"><a name="62"></a>62</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
246<tr><td class="h"><a name="63"></a>63</td><td></td><td></td><td></td><td></td><td class="s"> $self-&gt;_dbh-&gt;do(&quot;RELEASE SAVEPOINT $name&quot;);</td></tr>
247<tr><td class="h"><a name="64"></a>64</td><td></td><td></td><td></td><td></td><td class="s">}</td></tr>
248<tr><td class="h"><a name="65"></a>65</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
249<tr><td class="h"><a name="66"></a>66</td><td></td><td></td><td></td><td></td><td class="s">sub _exec_svp_rollback {</td></tr>
250<tr><td class="h"><a name="67"></a>67</td><td></td><td></td><td></td><td></td><td class="s"> my ($self, $name) = @_;</td></tr>
251<tr><td class="h"><a name="68"></a>68</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
252<tr><td class="h"><a name="69"></a>69</td><td></td><td></td><td></td><td></td><td class="s"> # For some reason this statement changes the value of $dbh-&gt;{AutoCommit}, so</td></tr>
253<tr><td class="h"><a name="70"></a>70</td><td></td><td></td><td></td><td></td><td class="s"> # we localize it here to preserve the original value.</td></tr>
254<tr><td class="h"><a name="71"></a>71</td><td></td><td></td><td></td><td></td><td class="s"> local $self-&gt;_dbh-&gt;{AutoCommit} = $self-&gt;_dbh-&gt;{AutoCommit};</td></tr>
255<tr><td class="h"><a name="72"></a>72</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
256<tr><td class="h"><a name="73"></a>73</td><td></td><td></td><td></td><td></td><td class="s"> $self-&gt;_dbh-&gt;do(&quot;ROLLBACK TRANSACTION TO SAVEPOINT $name&quot;);</td></tr>
257<tr><td class="h"><a name="74"></a>74</td><td></td><td></td><td></td><td></td><td class="s">}</td></tr>
258<tr><td class="h"><a name="75"></a>75</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
259<tr><td class="h"><a name="76"></a>76</td><td></td><td></td><td></td><td></td><td class="s">sub deployment_statements {</td></tr>
260<tr><td class="h"><a name="77"></a>77</td><td></td><td></td><td></td><td></td><td class="s"> my $self = shift;</td></tr>
261<tr><td class="h"><a name="78"></a>78</td><td></td><td></td><td></td><td></td><td class="s"> my ($schema, $type, $version, $dir, $sqltargs, @rest) = @_;</td></tr>
262<tr><td class="h"><a name="79"></a>79</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
263<tr><td class="h"><a name="80"></a>80</td><td></td><td></td><td></td><td></td><td class="s"> $sqltargs ||= {};</td></tr>
264<tr><td class="h"><a name="81"></a>81</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
265<tr><td class="h"><a name="82"></a>82</td><td></td><td></td><td></td><td></td><td class="s"> if (</td></tr>
266<tr><td class="h"><a name="83"></a>83</td><td></td><td></td><td></td><td></td><td class="s"> ! exists $sqltargs-&gt;{producer_args}{sqlite_version}</td></tr>
267<tr><td class="h"><a name="84"></a>84</td><td></td><td></td><td></td><td></td><td class="s"> and</td></tr>
268<tr><td class="h"><a name="85"></a>85</td><td></td><td></td><td></td><td></td><td class="s"> my $dver = $self-&gt;_server_info-&gt;{normalized_dbms_version}</td></tr>
269<tr><td class="h"><a name="86"></a>86</td><td></td><td></td><td></td><td></td><td class="s"> ) {</td></tr>
270<tr><td class="h"><a name="87"></a>87</td><td></td><td></td><td></td><td></td><td class="s"> $sqltargs-&gt;{producer_args}{sqlite_version} = $dver;</td></tr>
271<tr><td class="h"><a name="88"></a>88</td><td></td><td></td><td></td><td></td><td class="s"> }</td></tr>
272<tr><td class="h"><a name="89"></a>89</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
273<tr><td class="h"><a name="90"></a>90</td><td></td><td></td><td></td><td></td><td class="s"> $self-&gt;next::method($schema, $type, $version, $dir, $sqltargs, @rest);</td></tr>
274<tr><td class="h"><a name="91"></a>91</td><td></td><td></td><td></td><td></td><td class="s">}</td></tr>
275<tr><td class="h"><a name="92"></a>92</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
276<tr><td class="h"><a name="93"></a>93</td><td></td><td></td><td></td><td></td><td class="s"><div class="calls"><div class="calls_in"># spent 154&micro;s (96+58) within DBIx::Class::Storage::DBI::SQLite::bind_attribute_by_data_type which was called 24 times, avg 6&micro;s/call:
277# 24 times (96&micro;s+58&micro;s) by KiokuDB::Backend::DBI::__ANON__[/Users/edenc/perl5/lib/perl5/KiokuDB/Backend/DBI.pm:492] at <a href="KiokuDB-Backend-DBI-pm-2149-line.html#478">line 478 of KiokuDB/Backend/DBI.pm</a>, avg 6&micro;s/call</div></div>sub bind_attribute_by_data_type {</td></tr>
278<tr><td class="h"><a name="94"></a>94</td><td></td><td></td><td></td><td></td><td class="s"> $_[1] =~ /^ (?: int(?:eger)? | (?:tiny|small|medium)int ) $/ix</td></tr>
279<tr><td class="h"><a name="95"></a>95</td><td class="c0">24</td><td class="c0"><span title="Avg 7&micro;s">164&micro;s</span></td><td class="c0">24</td><td class="c3">58&micro;s</td><td class="s"> ? do { require DBI; DBI::SQL_INTEGER() }<div class="calls"><div class="calls_out"> # spent 58&micro;s making 24 calls to <a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-line.html#DBIx__Class__Storage__DBI__SQLite__CORE_match">DBIx::Class::Storage::DBI::SQLite::CORE:match</a>, avg 2&micro;s/call</div></div></td></tr>
280<tr><td class="h"><a name="96"></a>96</td><td></td><td></td><td></td><td></td><td class="s"> : undef</td></tr>
281<tr><td class="h"><a name="97"></a>97</td><td></td><td></td><td></td><td></td><td class="s"> ;</td></tr>
282<tr><td class="h"><a name="98"></a>98</td><td></td><td></td><td></td><td></td><td class="s">}</td></tr>
283<tr><td class="h"><a name="99"></a>99</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
284<tr><td class="h"><a name="100"></a>100</td><td></td><td></td><td></td><td></td><td class="s"># DBD::SQLite (at least up to version 1.31 has a bug where it will</td></tr>
285<tr><td class="h"><a name="101"></a>101</td><td></td><td></td><td></td><td></td><td class="s"># non-fatally nummify a string value bound as an integer, resulting</td></tr>
286<tr><td class="h"><a name="102"></a>102</td><td></td><td></td><td></td><td></td><td class="s"># in insertions of '0' into supposed-to-be-numeric fields</td></tr>
287<tr><td class="h"><a name="103"></a>103</td><td></td><td></td><td></td><td></td><td class="s"># Since this can result in severe data inconsistency, remove the</td></tr>
288<tr><td class="h"><a name="104"></a>104</td><td></td><td></td><td></td><td></td><td class="s"># bind attr if such a sitation is detected</td></tr>
289<tr><td class="h"><a name="105"></a>105</td><td></td><td></td><td></td><td></td><td class="s">#</td></tr>
290<tr><td class="h"><a name="106"></a>106</td><td></td><td></td><td></td><td></td><td class="s"># FIXME - when a DBD::SQLite version is released that eventually fixes</td></tr>
291<tr><td class="h"><a name="107"></a>107</td><td></td><td></td><td></td><td></td><td class="s"># this sutiation (somehow) - no-op this override once a proper DBD</td></tr>
292<tr><td class="h"><a name="108"></a>108</td><td></td><td></td><td></td><td></td><td class="s"># version is detected</td></tr>
293<tr><td class="h"><a name="109"></a>109</td><td></td><td></td><td></td><td></td><td class="s">sub _dbi_attrs_for_bind {</td></tr>
294<tr><td class="h"><a name="110"></a>110</td><td></td><td></td><td></td><td></td><td class="s"> my ($self, $ident, $bind) = @_;</td></tr>
295<tr><td class="h"><a name="111"></a>111</td><td></td><td></td><td></td><td></td><td class="s"> my $bindattrs = $self-&gt;next::method($ident, $bind);</td></tr>
296<tr><td class="h"><a name="112"></a>112</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
297<tr><td class="h"><a name="113"></a>113</td><td></td><td></td><td></td><td></td><td class="s"> for (0.. $#$bindattrs) {</td></tr>
298<tr><td class="h"><a name="114"></a>114</td><td></td><td></td><td></td><td></td><td class="s"> if (</td></tr>
299<tr><td class="h"><a name="115"></a>115</td><td></td><td></td><td></td><td></td><td class="s"> defined $bindattrs-&gt;[$_]</td></tr>
300<tr><td class="h"><a name="116"></a>116</td><td></td><td></td><td></td><td></td><td class="s"> and</td></tr>
301<tr><td class="h"><a name="117"></a>117</td><td></td><td></td><td></td><td></td><td class="s"> defined $bind-&gt;[$_][1]</td></tr>
302<tr><td class="h"><a name="118"></a>118</td><td></td><td></td><td></td><td></td><td class="s"> and</td></tr>
303<tr><td class="h"><a name="119"></a>119</td><td></td><td></td><td></td><td></td><td class="s"> $bindattrs-&gt;[$_] eq DBI::SQL_INTEGER()</td></tr>
304<tr><td class="h"><a name="120"></a>120</td><td></td><td></td><td></td><td></td><td class="s"> and</td></tr>
305<tr><td class="h"><a name="121"></a>121</td><td></td><td></td><td></td><td></td><td class="s"> ! looks_like_number ($bind-&gt;[$_][1])</td></tr>
306<tr><td class="h"><a name="122"></a>122</td><td></td><td></td><td></td><td></td><td class="s"> ) {</td></tr>
307<tr><td class="h"><a name="123"></a>123</td><td></td><td></td><td></td><td></td><td class="s"> carp_unique( sprintf (</td></tr>
308<tr><td class="h"><a name="124"></a>124</td><td></td><td></td><td></td><td></td><td class="s"> &quot;Non-numeric value supplied for column '%s' despite the numeric datatype&quot;,</td></tr>
309<tr><td class="h"><a name="125"></a>125</td><td></td><td></td><td></td><td></td><td class="s"> $bind-&gt;[$_][0]{dbic_colname} || &quot;# $_&quot;</td></tr>
310<tr><td class="h"><a name="126"></a>126</td><td></td><td></td><td></td><td></td><td class="s"> ) );</td></tr>
311<tr><td class="h"><a name="127"></a>127</td><td></td><td></td><td></td><td></td><td class="s"> undef $bindattrs-&gt;[$_];</td></tr>
312<tr><td class="h"><a name="128"></a>128</td><td></td><td></td><td></td><td></td><td class="s"> }</td></tr>
313<tr><td class="h"><a name="129"></a>129</td><td></td><td></td><td></td><td></td><td class="s"> }</td></tr>
314<tr><td class="h"><a name="130"></a>130</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
315<tr><td class="h"><a name="131"></a>131</td><td></td><td></td><td></td><td></td><td class="s"> return $bindattrs;</td></tr>
316<tr><td class="h"><a name="132"></a>132</td><td></td><td></td><td></td><td></td><td class="s">}</td></tr>
317<tr><td class="h"><a name="133"></a>133</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
318<tr><td class="h"><a name="134"></a>134</td><td></td><td></td><td></td><td></td><td class="s">=head2 connect_call_use_foreign_keys</td></tr>
319<tr><td class="h"><a name="135"></a>135</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
320<tr><td class="h"><a name="136"></a>136</td><td></td><td></td><td></td><td></td><td class="s">Used as:</td></tr>
321<tr><td class="h"><a name="137"></a>137</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
322<tr><td class="h"><a name="138"></a>138</td><td></td><td></td><td></td><td></td><td class="s"> on_connect_call =&gt; 'use_foreign_keys'</td></tr>
323<tr><td class="h"><a name="139"></a>139</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
324<tr><td class="h"><a name="140"></a>140</td><td></td><td></td><td></td><td></td><td class="s">In L&lt;connect_info|DBIx::Class::Storage::DBI/connect_info&gt; to turn on foreign key</td></tr>
325<tr><td class="h"><a name="141"></a>141</td><td></td><td></td><td></td><td></td><td class="s">(including cascading) support for recent versions of SQLite and L&lt;DBD::SQLite&gt;.</td></tr>
326<tr><td class="h"><a name="142"></a>142</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
327<tr><td class="h"><a name="143"></a>143</td><td></td><td></td><td></td><td></td><td class="s">Executes:</td></tr>
328<tr><td class="h"><a name="144"></a>144</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
329<tr><td class="h"><a name="145"></a>145</td><td></td><td></td><td></td><td></td><td class="s"> PRAGMA foreign_keys = ON </td></tr>
330<tr><td class="h"><a name="146"></a>146</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
331<tr><td class="h"><a name="147"></a>147</td><td></td><td></td><td></td><td></td><td class="s">See L&lt;http://www.sqlite.org/foreignkeys.html&gt; for more information.</td></tr>
332<tr><td class="h"><a name="148"></a>148</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
333<tr><td class="h"><a name="149"></a>149</td><td></td><td></td><td></td><td></td><td class="s">=cut</td></tr>
334<tr><td class="h"><a name="150"></a>150</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
335<tr><td class="h"><a name="151"></a>151</td><td></td><td></td><td></td><td></td><td class="s">sub connect_call_use_foreign_keys {</td></tr>
336<tr><td class="h"><a name="152"></a>152</td><td></td><td></td><td></td><td></td><td class="s"> my $self = shift;</td></tr>
337<tr><td class="h"><a name="153"></a>153</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
338<tr><td class="h"><a name="154"></a>154</td><td></td><td></td><td></td><td></td><td class="s"> $self-&gt;_do_query(</td></tr>
339<tr><td class="h"><a name="155"></a>155</td><td></td><td></td><td></td><td></td><td class="s"> 'PRAGMA foreign_keys = ON'</td></tr>
340<tr><td class="h"><a name="156"></a>156</td><td></td><td></td><td></td><td></td><td class="s"> );</td></tr>
341<tr><td class="h"><a name="157"></a>157</td><td></td><td></td><td></td><td></td><td class="s">}</td></tr>
342<tr><td class="h"><a name="158"></a>158</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
343<tr><td class="h"><a name="159"></a>159</td><td class="c3">1</td><td class="c3"><span title="Avg 12&micro;s">12&micro;s</span></td><td></td><td></td><td class="s">1;</td></tr>
344<tr><td class="h"><a name="160"></a>160</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
345<tr><td class="h"><a name="161"></a>161</td><td></td><td></td><td></td><td></td><td class="s">=head1 NAME</td></tr>
346<tr><td class="h"><a name="162"></a>162</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
347<tr><td class="h"><a name="163"></a>163</td><td></td><td></td><td></td><td></td><td class="s">DBIx::Class::Storage::DBI::SQLite - Automatic primary key class for SQLite</td></tr>
348<tr><td class="h"><a name="164"></a>164</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
349<tr><td class="h"><a name="165"></a>165</td><td></td><td></td><td></td><td></td><td class="s">=head1 SYNOPSIS</td></tr>
350<tr><td class="h"><a name="166"></a>166</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
351<tr><td class="h"><a name="167"></a>167</td><td></td><td></td><td></td><td></td><td class="s"> # In your table classes</td></tr>
352<tr><td class="h"><a name="168"></a>168</td><td></td><td></td><td></td><td></td><td class="s"> use base 'DBIx::Class::Core';</td></tr>
353<tr><td class="h"><a name="169"></a>169</td><td></td><td></td><td></td><td></td><td class="s"> __PACKAGE__-&gt;set_primary_key('id');</td></tr>
354<tr><td class="h"><a name="170"></a>170</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
355<tr><td class="h"><a name="171"></a>171</td><td></td><td></td><td></td><td></td><td class="s">=head1 DESCRIPTION</td></tr>
356<tr><td class="h"><a name="172"></a>172</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
357<tr><td class="h"><a name="173"></a>173</td><td></td><td></td><td></td><td></td><td class="s">This class implements autoincrements for SQLite.</td></tr>
358<tr><td class="h"><a name="174"></a>174</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
359<tr><td class="h"><a name="175"></a>175</td><td></td><td></td><td></td><td></td><td class="s">=head1 AUTHORS</td></tr>
360<tr><td class="h"><a name="176"></a>176</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
361<tr><td class="h"><a name="177"></a>177</td><td></td><td></td><td></td><td></td><td class="s">Matt S. Trout &lt;mst@shadowcatsystems.co.uk&gt;</td></tr>
362<tr><td class="h"><a name="178"></a>178</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
363<tr><td class="h"><a name="179"></a>179</td><td></td><td></td><td></td><td></td><td class="s">=head1 LICENSE</td></tr>
364<tr><td class="h"><a name="180"></a>180</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
365<tr><td class="h"><a name="181"></a>181</td><td></td><td></td><td></td><td></td><td class="s">You may distribute this code under the same terms as Perl itself.</td></tr>
366<tr><td class="h"><a name="182"></a>182</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
367<tr><td class="h"><a name="183"></a>183</td><td class="c3">1</td><td class="c3"><span title="Avg 20&micro;s">20&micro;s</span></td><td class="c3">1</td><td class="c0">451&micro;s</td><td class="s">=cut<div class="calls"><div class="calls_out"># spent 451&micro;s making 1 call to <a href="B-Hooks-EndOfScope-pm-376-line.html#26">B::Hooks::EndOfScope::__ANON__[B/Hooks/EndOfScope.pm:26]</a></div></div></td></tr>
368<tr><td class="s"><a name=""></a>&nbsp;</td><td></td><td></td><td></td><td></td><td class="s"></td></tr>
369<tr><td class="h"><a name="DBIx__Class__Storage__DBI__SQLite__CORE_match"></a></td><td></td><td></td><td></td><td></td><td class="s"><div class="calls"><div class="calls_in"># spent 58&micro;s within DBIx::Class::Storage::DBI::SQLite::CORE:match which was called 24 times, avg 2&micro;s/call:
370# 24 times (58&micro;s+0s) by DBIx::Class::Storage::DBI::SQLite::bind_attribute_by_data_type at <a href="DBIx-Class-Storage-DBI-SQLite-pm-2615-line.html#95">line 95</a>, avg 2&micro;s/call</div></div>sub DBIx::Class::Storage::DBI::SQLite::CORE:match; # opcode<br /> </td></tr>
371<tr><td class="h"><a name="DBIx__Class__Storage__DBI__SQLite___conn_pid"></a></td><td></td><td></td><td></td><td></td><td class="s"><div class="calls"><div class="calls_in"># spent 4&micro;s within DBIx::Class::Storage::DBI::SQLite::_conn_pid which was called 3 times, avg 1&micro;s/call:
372# once (2&micro;s+0s) by DBIx::Class::Storage::DBI::_populate_dbh at <a href="DBIx-Class-Storage-DBI-pm-2457-line.html#1010">line 1010 of DBIx/Class/Storage/DBI.pm</a>
373# once (600ns+0s) by DBIx::Class::Storage::DBI::_verify_pid at <a href="DBIx-Class-Storage-DBI-pm-2457-line.html#242">line 242 of DBIx/Class/Storage/DBI.pm</a>
374# once (500ns+0s) by DBIx::Class::Storage::DBI::_verify_pid at <a href="Class-Accessor-Grouped-pm-2180-line.html#781">line 781 of Class/Accessor/Grouped.pm</a></div></div>sub DBIx::Class::Storage::DBI::SQLite::_conn_pid; # xsub<br /> </td></tr>
375<tr><td class="h"><a name="DBIx__Class__Storage__DBI__SQLite___dbh_autocommit"></a></td><td></td><td></td><td></td><td></td><td class="s"><div class="calls"><div class="calls_in"># spent 14&micro;s (13+2) within DBIx::Class::Storage::DBI::SQLite::_dbh_autocommit which was called 6 times, avg 2&micro;s/call:
376# 2 times (4&micro;s+0s) by DBIx::Class::Storage::DBI::txn_commit at <a href="DBIx-Class-Storage-DBI-pm-2457-line.html#1361">line 1361 of DBIx/Class/Storage/DBI.pm</a>, avg 2&micro;s/call
377# once (6&micro;s+2&micro;s) by DBIx::Class::Storage::DBI::_connect at <a href="DBIx-Class-Storage-DBI-pm-2457-line.html#1308">line 1308 of DBIx/Class/Storage/DBI.pm</a>
378# once (2&micro;s+0s) by DBIx::Class::Storage::DBI::txn_begin at <a href="DBIx-Class-Storage-DBI-pm-2457-line.html#1317">line 1317 of DBIx/Class/Storage/DBI.pm</a>
379# once (700ns+0s) by DBIx::Class::Storage::DBI::_populate_dbh at <a href="DBIx-Class-Storage-DBI-pm-2457-line.html#1016">line 1016 of DBIx/Class/Storage/DBI.pm</a>
380# once (500ns+0s) by DBIx::Class::Storage::DBI::txn_begin at <a href="Class-Accessor-Grouped-pm-2180-line.html#781">line 781 of Class/Accessor/Grouped.pm</a></div></div>sub DBIx::Class::Storage::DBI::SQLite::_dbh_autocommit; # xsub<br /> </td></tr>
381<tr><td class="h"><a name="DBIx__Class__Storage__DBI__SQLite__auto_savepoint"></a></td><td></td><td></td><td></td><td></td><td class="s"><div class="calls"><div class="calls_in"># spent 4&micro;s within DBIx::Class::Storage::DBI::SQLite::auto_savepoint which was called 3 times, avg 1&micro;s/call:
382# once (2&micro;s+0s) by DBIx::Class::Storage::txn_begin at <a href="DBIx-Class-Storage-pm-2461-line.html#273">line 273 of DBIx/Class/Storage.pm</a>
383# once (1&micro;s+0s) by DBIx::Class::Storage::txn_commit at <a href="DBIx-Class-Storage-pm-2461-line.html#304">line 304 of DBIx/Class/Storage.pm</a>
384# once (600ns+0s) by DBIx::Class::Storage::txn_begin at <a href="Class-Accessor-Grouped-pm-2180-line.html#781">line 781 of Class/Accessor/Grouped.pm</a></div></div>sub DBIx::Class::Storage::DBI::SQLite::auto_savepoint; # xsub<br /> </td></tr>
385<tr><td class="h"><a name="DBIx__Class__Storage__DBI__SQLite__debug"></a></td><td></td><td></td><td></td><td></td><td class="s"><div class="calls"><div class="calls_in"># spent 8&micro;s within DBIx::Class::Storage::DBI::SQLite::debug which was called 3 times, avg 3&micro;s/call:
386# once (4&micro;s+0s) by DBIx::Class::Storage::txn_begin at <a href="DBIx-Class-Storage-pm-2461-line.html#274">line 274 of DBIx/Class/Storage.pm</a>
387# once (4&micro;s+0s) by DBIx::Class::Storage::txn_commit at <a href="DBIx-Class-Storage-pm-2461-line.html#298">line 298 of DBIx/Class/Storage.pm</a>
388# once (500ns+0s) by DBIx::Class::Storage::txn_begin at <a href="Class-Accessor-Grouped-pm-2180-line.html#781">line 781 of Class/Accessor/Grouped.pm</a></div></div>sub DBIx::Class::Storage::DBI::SQLite::debug; # xsub<br /> </td></tr>
389<tr><td class="h"><a name="DBIx__Class__Storage__DBI__SQLite__on_connect_do"></a></td><td></td><td></td><td></td><td></td><td class="s"><div class="calls"><div class="calls_in"># spent 500ns within DBIx::Class::Storage::DBI::SQLite::on_connect_do which was called:
390# once (500ns+0s) by DBIx::Class::Storage::DBI::_parse_connect_do at <a href="Class-Accessor-Grouped-pm-2180-line.html#781">line 781 of Class/Accessor/Grouped.pm</a></div></div>sub DBIx::Class::Storage::DBI::SQLite::on_connect_do; # xsub<br /> </td></tr>
391<tr><td class="h"><a name="DBIx__Class__Storage__DBI__SQLite__transaction_depth"></a></td><td></td><td></td><td></td><td></td><td class="s"><div class="calls"><div class="calls_in"># spent 5&micro;s within DBIx::Class::Storage::DBI::SQLite::transaction_depth which was called 6 times, avg 783ns/call:
392# 2 times (1&micro;s+0s) by DBIx::Class::Storage::txn_commit at <a href="DBIx-Class-Storage-pm-2461-line.html#297">line 297 of DBIx/Class/Storage.pm</a>, avg 600ns/call
393# once (1&micro;s+0s) by DBIx::Class::Storage::txn_begin at <a href="DBIx-Class-Storage-pm-2461-line.html#273">line 273 of DBIx/Class/Storage.pm</a>
394# once (1&micro;s+0s) by DBIx::Class::Storage::DBI::txn_commit at <a href="DBIx-Class-Storage-DBI-pm-2457-line.html#1351">line 1351 of DBIx/Class/Storage/DBI.pm</a>
395# once (600ns+0s) by DBIx::Class::Storage::DBI::txn_commit at <a href="DBIx-Class-Storage-DBI-pm-2457-line.html#1361">line 1361 of DBIx/Class/Storage/DBI.pm</a>
396# once (500ns+0s) by DBIx::Class::Storage::txn_begin at <a href="Class-Accessor-Grouped-pm-2180-line.html#781">line 781 of Class/Accessor/Grouped.pm</a></div></div>sub DBIx::Class::Storage::DBI::SQLite::transaction_depth; # xsub<br /> </td></tr>
397<tr><td class="h"><a name="DBIx__Class__Storage__DBI__SQLite__unsafe"></a></td><td></td><td></td><td></td><td></td><td class="s"><div class="calls"><div class="calls_in"># spent 600ns within DBIx::Class::Storage::DBI::SQLite::unsafe which was called:
398# once (600ns+0s) by DBIx::Class::Storage::DBI::__ANON__[/Users/edenc/perl5/lib/perl5/DBIx/Class/Storage/DBI.pm:1300] at <a href="Class-Accessor-Grouped-pm-2180-line.html#781">line 781 of Class/Accessor/Grouped.pm</a></div></div>sub DBIx::Class::Storage::DBI::SQLite::unsafe; # xsub<br /> </td></tr>
399</tbody></table></div>
400
401 <script type="text/javascript"> $(document).ready(function() {
402
403 $("#subs_table").tablesorter({
404 sortList: [[3,1]],
405 headers: {
406 3: { sorter: 'fmt_time' },
407 4: { sorter: 'fmt_time' }
408 }
409 });
410
411 } ); </script>
412
413 <div class="footer">Report produced by the
414 <a href="http://search.cpan.org/dist/Devel-NYTProf/">NYTProf 4.06</a>
415 Perl profiler, developed by
416 <a href="http://www.linkedin.com/in/timbunce">Tim Bunce</a> and
417 <a href="http://code.nytimes.com">Adam Kaplan</a>.
418 </div>
419 <br /><br /><br /><br /><br /><br /><br /><br /><br /><br />
420 </body></html>
Unnamed repository; edit this file 'description' to name the repository.