| <!DOCTYPE html> |
| <html lang="en"> |
| <head> |
| <meta charset="UTF-8"> |
| <title>Code Coverage for D:\work\log4php-trunk\src\main\php/appenders/LoggerAppenderPDO.php</title> |
| <meta name="viewport" content="width=device-width, initial-scale=1.0"> |
| <link href="css/bootstrap.min.css" rel="stylesheet"> |
| <link href="css/bootstrap-responsive.min.css" rel="stylesheet"> |
| <link href="css/style.css" rel="stylesheet"> |
| <!--[if lt IE 9]> |
| <script src="http://html5shim.googlecode.com/svn/trunk/html5.js"></script> |
| <![endif]--> |
| </head> |
| <body> |
| <header> |
| <div class="container"> |
| <div class="row"> |
| <div class="span12"> |
| <ul class="breadcrumb"> |
| <li><a href="index.html">D:\work\log4php-trunk\src\main\php</a> <span class="divider">/</span></li> |
| <li><a href="appenders.html">appenders</a> <span class="divider">/</span></li> |
| <li class="active">LoggerAppenderPDO.php</li> |
| |
| </ul> |
| </div> |
| </div> |
| </div> |
| </header> |
| <div class="container"> |
| <table class="table table-bordered"> |
| <thead> |
| <tr> |
| <td> </td> |
| <td colspan="10"><div align="center"><strong>Code Coverage</strong></div></td> |
| </tr> |
| <tr> |
| <td> </td> |
| <td colspan="3"><div align="center"><strong>Classes and Traits</strong></div></td> |
| <td colspan="4"><div align="center"><strong>Functions and Methods</strong></div></td> |
| <td colspan="3"><div align="center"><strong>Lines</strong></div></td> |
| </tr> |
| </thead> |
| <tbody> |
| <tr> |
| <td class="danger">Total</td> |
| <td class="danger big"> <div class="progress progress-danger" style="width: 100px;"> |
| <div class="bar" style="width: 0.00%;"></div> |
| </div> |
| </td> |
| <td class="danger small"><div align="right">0.00%</div></td> |
| <td class="danger small"><div align="right">0 / 1</div></td> |
| <td class="warning big"> <div class="progress progress-warning" style="width: 100px;"> |
| <div class="bar" style="width: 38.89%;"></div> |
| </div> |
| </td> |
| <td class="warning small"><div align="right">38.89%</div></td> |
| <td class="warning small"><div align="right">7 / 18</div></td> |
| <td class="warning small"><acronym title="Change Risk Anti-Patterns (CRAP) Index">CRAP</acronym></td> |
| <td class="warning big"> <div class="progress progress-warning" style="width: 100px;"> |
| <div class="bar" style="width: 64.06%;"></div> |
| </div> |
| </td> |
| <td class="warning small"><div align="right">64.06%</div></td> |
| <td class="warning small"><div align="right">41 / 64</div></td> |
| </tr> |
| |
| <tr> |
| <td class="danger">LoggerAppenderPDO</td> |
| <td class="danger big"> <div class="progress progress-danger" style="width: 100px;"> |
| <div class="bar" style="width: 0.00%;"></div> |
| </div> |
| </td> |
| <td class="danger small"><div align="right">0.00%</div></td> |
| <td class="danger small"><div align="right">0 / 1</div></td> |
| <td class="warning big"> <div class="progress progress-warning" style="width: 100px;"> |
| <div class="bar" style="width: 38.89%;"></div> |
| </div> |
| </td> |
| <td class="warning small"><div align="right">38.89%</div></td> |
| <td class="warning small"><div align="right">7 / 18</div></td> |
| <td class="warning small">54.01</td> |
| <td class="warning big"> <div class="progress progress-warning" style="width: 100px;"> |
| <div class="bar" style="width: 64.06%;"></div> |
| </div> |
| </td> |
| <td class="warning small"><div align="right">64.06%</div></td> |
| <td class="warning small"><div align="right">41 / 64</div></td> |
| </tr> |
| |
| <tr> |
| <td class="danger" colspan="4"> <a href="#118">activateOptions()</a></td> |
| <td class="danger big"> <div class="progress progress-danger" style="width: 100px;"> |
| <div class="bar" style="width: 0.00%;"></div> |
| </div> |
| </td> |
| <td class="danger small"><div align="right">0.00%</div></td> |
| <td class="danger small"><div align="right">0 / 1</div></td> |
| <td class="danger small">3.03</td> |
| <td class="success big"> <div class="progress progress-success" style="width: 100px;"> |
| <div class="bar" style="width: 84.62%;"></div> |
| </div> |
| </td> |
| <td class="success small"><div align="right">84.62%</div></td> |
| <td class="success small"><div align="right">11 / 13</div></td> |
| </tr> |
| |
| <tr> |
| <td class="success" colspan="4"> <a href="#142">establishConnection()</a></td> |
| <td class="success big"> <div class="progress progress-success" style="width: 100px;"> |
| <div class="bar" style="width: 100.00%;"></div> |
| </div> |
| </td> |
| <td class="success small"><div align="right">100.00%</div></td> |
| <td class="success small"><div align="right">1 / 1</div></td> |
| <td class="success small">1</td> |
| <td class="success big"> <div class="progress progress-success" style="width: 100px;"> |
| <div class="bar" style="width: 100.00%;"></div> |
| </div> |
| </td> |
| <td class="success small"><div align="right">100.00%</div></td> |
| <td class="success small"><div align="right">5 / 5</div></td> |
| </tr> |
| |
| <tr> |
| <td class="danger" colspan="4"> <a href="#159">append(LoggerLoggingEvent $event)</a></td> |
| <td class="danger big"> <div class="progress progress-danger" style="width: 100px;"> |
| <div class="bar" style="width: 0.00%;"></div> |
| </div> |
| </td> |
| <td class="danger small"><div align="right">0.00%</div></td> |
| <td class="danger small"><div align="right">0 / 1</div></td> |
| <td class="danger small">8.25</td> |
| <td class="warning big"> <div class="progress progress-warning" style="width: 100px;"> |
| <div class="bar" style="width: 35.71%;"></div> |
| </div> |
| </td> |
| <td class="warning small"><div align="right">35.71%</div></td> |
| <td class="warning small"><div align="right">5 / 14</div></td> |
| </tr> |
| |
| <tr> |
| <td class="success" colspan="4"> <a href="#187">format(LoggerLoggingEvent $event)</a></td> |
| <td class="success big"> <div class="progress progress-success" style="width: 100px;"> |
| <div class="bar" style="width: 100.00%;"></div> |
| </div> |
| </td> |
| <td class="success small"><div align="right">100.00%</div></td> |
| <td class="success small"><div align="right">1 / 1</div></td> |
| <td class="success small">3</td> |
| <td class="success big"> <div class="progress progress-success" style="width: 100px;"> |
| <div class="bar" style="width: 100.00%;"></div> |
| </div> |
| </td> |
| <td class="success small"><div align="right">100.00%</div></td> |
| <td class="success small"><div align="right">10 / 10</div></td> |
| </tr> |
| |
| <tr> |
| <td class="success" colspan="4"> <a href="#203">close()</a></td> |
| <td class="success big"> <div class="progress progress-success" style="width: 100px;"> |
| <div class="bar" style="width: 100.00%;"></div> |
| </div> |
| </td> |
| <td class="success small"><div align="right">100.00%</div></td> |
| <td class="success small"><div align="right">1 / 1</div></td> |
| <td class="success small">1</td> |
| <td class="success big"> <div class="progress progress-success" style="width: 100px;"> |
| <div class="bar" style="width: 100.00%;"></div> |
| </div> |
| </td> |
| <td class="success small"><div align="right">100.00%</div></td> |
| <td class="success small"><div align="right">3 / 3</div></td> |
| </tr> |
| |
| <tr> |
| <td class="success" colspan="4"> <a href="#219">getDatabaseHandle()</a></td> |
| <td class="success big"> <div class="progress progress-success" style="width: 100px;"> |
| <div class="bar" style="width: 100.00%;"></div> |
| </div> |
| </td> |
| <td class="success small"><div align="right">100.00%</div></td> |
| <td class="success small"><div align="right">1 / 1</div></td> |
| <td class="success small">1</td> |
| <td class="success big"> <div class="progress progress-success" style="width: 100px;"> |
| <div class="bar" style="width: 100.00%;"></div> |
| </div> |
| </td> |
| <td class="success small"><div align="right">100.00%</div></td> |
| <td class="success small"><div align="right">1 / 1</div></td> |
| </tr> |
| |
| <tr> |
| <td class="danger" colspan="4"> <a href="#224">setUser($user)</a></td> |
| <td class="danger big"> <div class="progress progress-danger" style="width: 100px;"> |
| <div class="bar" style="width: 0.00%;"></div> |
| </div> |
| </td> |
| <td class="danger small"><div align="right">0.00%</div></td> |
| <td class="danger small"><div align="right">0 / 1</div></td> |
| <td class="danger small">2</td> |
| <td class="danger big"> <div class="progress progress-danger" style="width: 100px;"> |
| <div class="bar" style="width: 0.00%;"></div> |
| </div> |
| </td> |
| <td class="danger small"><div align="right">0.00%</div></td> |
| <td class="danger small"><div align="right">0 / 2</div></td> |
| </tr> |
| |
| <tr> |
| <td class="danger" colspan="4"> <a href="#229">getUser($user)</a></td> |
| <td class="danger big"> <div class="progress progress-danger" style="width: 100px;"> |
| <div class="bar" style="width: 0.00%;"></div> |
| </div> |
| </td> |
| <td class="danger small"><div align="right">0.00%</div></td> |
| <td class="danger small"><div align="right">0 / 1</div></td> |
| <td class="danger small">2</td> |
| <td class="danger big"> <div class="progress progress-danger" style="width: 100px;"> |
| <div class="bar" style="width: 0.00%;"></div> |
| </div> |
| </td> |
| <td class="danger small"><div align="right">0.00%</div></td> |
| <td class="danger small"><div align="right">0 / 1</div></td> |
| </tr> |
| |
| <tr> |
| <td class="danger" colspan="4"> <a href="#234">setPassword($password)</a></td> |
| <td class="danger big"> <div class="progress progress-danger" style="width: 100px;"> |
| <div class="bar" style="width: 0.00%;"></div> |
| </div> |
| </td> |
| <td class="danger small"><div align="right">0.00%</div></td> |
| <td class="danger small"><div align="right">0 / 1</div></td> |
| <td class="danger small">2</td> |
| <td class="danger big"> <div class="progress progress-danger" style="width: 100px;"> |
| <div class="bar" style="width: 0.00%;"></div> |
| </div> |
| </td> |
| <td class="danger small"><div align="right">0.00%</div></td> |
| <td class="danger small"><div align="right">0 / 2</div></td> |
| </tr> |
| |
| <tr> |
| <td class="danger" colspan="4"> <a href="#239">getPassword($password)</a></td> |
| <td class="danger big"> <div class="progress progress-danger" style="width: 100px;"> |
| <div class="bar" style="width: 0.00%;"></div> |
| </div> |
| </td> |
| <td class="danger small"><div align="right">0.00%</div></td> |
| <td class="danger small"><div align="right">0 / 1</div></td> |
| <td class="danger small">2</td> |
| <td class="danger big"> <div class="progress progress-danger" style="width: 100px;"> |
| <div class="bar" style="width: 0.00%;"></div> |
| </div> |
| </td> |
| <td class="danger small"><div align="right">0.00%</div></td> |
| <td class="danger small"><div align="right">0 / 1</div></td> |
| </tr> |
| |
| <tr> |
| <td class="success" colspan="4"> <a href="#244">setInsertSQL($sql)</a></td> |
| <td class="success big"> <div class="progress progress-success" style="width: 100px;"> |
| <div class="bar" style="width: 100.00%;"></div> |
| </div> |
| </td> |
| <td class="success small"><div align="right">100.00%</div></td> |
| <td class="success small"><div align="right">1 / 1</div></td> |
| <td class="success small">1</td> |
| <td class="success big"> <div class="progress progress-success" style="width: 100px;"> |
| <div class="bar" style="width: 100.00%;"></div> |
| </div> |
| </td> |
| <td class="success small"><div align="right">100.00%</div></td> |
| <td class="success small"><div align="right">2 / 2</div></td> |
| </tr> |
| |
| <tr> |
| <td class="danger" colspan="4"> <a href="#249">getInsertSQL($sql)</a></td> |
| <td class="danger big"> <div class="progress progress-danger" style="width: 100px;"> |
| <div class="bar" style="width: 0.00%;"></div> |
| </div> |
| </td> |
| <td class="danger small"><div align="right">0.00%</div></td> |
| <td class="danger small"><div align="right">0 / 1</div></td> |
| <td class="danger small">2</td> |
| <td class="danger big"> <div class="progress progress-danger" style="width: 100px;"> |
| <div class="bar" style="width: 0.00%;"></div> |
| </div> |
| </td> |
| <td class="danger small"><div align="right">0.00%</div></td> |
| <td class="danger small"><div align="right">0 / 1</div></td> |
| </tr> |
| |
| <tr> |
| <td class="success" colspan="4"> <a href="#254">setInsertPattern($pattern)</a></td> |
| <td class="success big"> <div class="progress progress-success" style="width: 100px;"> |
| <div class="bar" style="width: 100.00%;"></div> |
| </div> |
| </td> |
| <td class="success small"><div align="right">100.00%</div></td> |
| <td class="success small"><div align="right">1 / 1</div></td> |
| <td class="success small">1</td> |
| <td class="success big"> <div class="progress progress-success" style="width: 100px;"> |
| <div class="bar" style="width: 100.00%;"></div> |
| </div> |
| </td> |
| <td class="success small"><div align="right">100.00%</div></td> |
| <td class="success small"><div align="right">2 / 2</div></td> |
| </tr> |
| |
| <tr> |
| <td class="danger" colspan="4"> <a href="#259">getInsertPattern($pattern)</a></td> |
| <td class="danger big"> <div class="progress progress-danger" style="width: 100px;"> |
| <div class="bar" style="width: 0.00%;"></div> |
| </div> |
| </td> |
| <td class="danger small"><div align="right">0.00%</div></td> |
| <td class="danger small"><div align="right">0 / 1</div></td> |
| <td class="danger small">2</td> |
| <td class="danger big"> <div class="progress progress-danger" style="width: 100px;"> |
| <div class="bar" style="width: 0.00%;"></div> |
| </div> |
| </td> |
| <td class="danger small"><div align="right">0.00%</div></td> |
| <td class="danger small"><div align="right">0 / 1</div></td> |
| </tr> |
| |
| <tr> |
| <td class="danger" colspan="4"> <a href="#264">setTable($table)</a></td> |
| <td class="danger big"> <div class="progress progress-danger" style="width: 100px;"> |
| <div class="bar" style="width: 0.00%;"></div> |
| </div> |
| </td> |
| <td class="danger small"><div align="right">0.00%</div></td> |
| <td class="danger small"><div align="right">0 / 1</div></td> |
| <td class="danger small">2</td> |
| <td class="danger big"> <div class="progress progress-danger" style="width: 100px;"> |
| <div class="bar" style="width: 0.00%;"></div> |
| </div> |
| </td> |
| <td class="danger small"><div align="right">0.00%</div></td> |
| <td class="danger small"><div align="right">0 / 2</div></td> |
| </tr> |
| |
| <tr> |
| <td class="danger" colspan="4"> <a href="#269">getTable($table)</a></td> |
| <td class="danger big"> <div class="progress progress-danger" style="width: 100px;"> |
| <div class="bar" style="width: 0.00%;"></div> |
| </div> |
| </td> |
| <td class="danger small"><div align="right">0.00%</div></td> |
| <td class="danger small"><div align="right">0 / 1</div></td> |
| <td class="danger small">2</td> |
| <td class="danger big"> <div class="progress progress-danger" style="width: 100px;"> |
| <div class="bar" style="width: 0.00%;"></div> |
| </div> |
| </td> |
| <td class="danger small"><div align="right">0.00%</div></td> |
| <td class="danger small"><div align="right">0 / 1</div></td> |
| </tr> |
| |
| <tr> |
| <td class="success" colspan="4"> <a href="#274">setDSN($dsn)</a></td> |
| <td class="success big"> <div class="progress progress-success" style="width: 100px;"> |
| <div class="bar" style="width: 100.00%;"></div> |
| </div> |
| </td> |
| <td class="success small"><div align="right">100.00%</div></td> |
| <td class="success small"><div align="right">1 / 1</div></td> |
| <td class="success small">1</td> |
| <td class="success big"> <div class="progress progress-success" style="width: 100px;"> |
| <div class="bar" style="width: 100.00%;"></div> |
| </div> |
| </td> |
| <td class="success small"><div align="right">100.00%</div></td> |
| <td class="success small"><div align="right">2 / 2</div></td> |
| </tr> |
| |
| <tr> |
| <td class="danger" colspan="4"> <a href="#279">getDSN($dsn)</a></td> |
| <td class="danger big"> <div class="progress progress-danger" style="width: 100px;"> |
| <div class="bar" style="width: 0.00%;"></div> |
| </div> |
| </td> |
| <td class="danger small"><div align="right">0.00%</div></td> |
| <td class="danger small"><div align="right">0 / 1</div></td> |
| <td class="danger small">2</td> |
| <td class="danger big"> <div class="progress progress-danger" style="width: 100px;"> |
| <div class="bar" style="width: 0.00%;"></div> |
| </div> |
| </td> |
| <td class="danger small"><div align="right">0.00%</div></td> |
| <td class="danger small"><div align="right">0 / 1</div></td> |
| </tr> |
| |
| |
| </tbody> |
| </table> |
| <table class="table table-borderless table-condensed"> |
| <tbody> |
| <tr><td><div align="right"><a name="1"></a><a href="#1">1</a></div></td><td class="codeLine"><?php</td></tr> |
| <tr><td><div align="right"><a name="2"></a><a href="#2">2</a></div></td><td class="codeLine">/**</td></tr> |
| <tr><td><div align="right"><a name="3"></a><a href="#3">3</a></div></td><td class="codeLine"> * Licensed to the Apache Software Foundation (ASF) under one or more</td></tr> |
| <tr><td><div align="right"><a name="4"></a><a href="#4">4</a></div></td><td class="codeLine"> * contributor license agreements. See the NOTICE file distributed with</td></tr> |
| <tr><td><div align="right"><a name="5"></a><a href="#5">5</a></div></td><td class="codeLine"> * this work for additional information regarding copyright ownership.</td></tr> |
| <tr><td><div align="right"><a name="6"></a><a href="#6">6</a></div></td><td class="codeLine"> * The ASF licenses this file to You under the Apache License, Version 2.0</td></tr> |
| <tr><td><div align="right"><a name="7"></a><a href="#7">7</a></div></td><td class="codeLine"> * (the "License"); you may not use this file except in compliance with</td></tr> |
| <tr><td><div align="right"><a name="8"></a><a href="#8">8</a></div></td><td class="codeLine"> * the License. You may obtain a copy of the License at</td></tr> |
| <tr><td><div align="right"><a name="9"></a><a href="#9">9</a></div></td><td class="codeLine"> *</td></tr> |
| <tr><td><div align="right"><a name="10"></a><a href="#10">10</a></div></td><td class="codeLine"> * http://www.apache.org/licenses/LICENSE-2.0</td></tr> |
| <tr><td><div align="right"><a name="11"></a><a href="#11">11</a></div></td><td class="codeLine"> *</td></tr> |
| <tr><td><div align="right"><a name="12"></a><a href="#12">12</a></div></td><td class="codeLine"> * Unless required by applicable law or agreed to in writing, software</td></tr> |
| <tr><td><div align="right"><a name="13"></a><a href="#13">13</a></div></td><td class="codeLine"> * distributed under the License is distributed on an "AS IS" BASIS,</td></tr> |
| <tr><td><div align="right"><a name="14"></a><a href="#14">14</a></div></td><td class="codeLine"> * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.</td></tr> |
| <tr><td><div align="right"><a name="15"></a><a href="#15">15</a></div></td><td class="codeLine"> * See the License for the specific language governing permissions and</td></tr> |
| <tr><td><div align="right"><a name="16"></a><a href="#16">16</a></div></td><td class="codeLine"> * limitations under the License.</td></tr> |
| <tr><td><div align="right"><a name="17"></a><a href="#17">17</a></div></td><td class="codeLine"> */</td></tr> |
| <tr><td><div align="right"><a name="18"></a><a href="#18">18</a></div></td><td class="codeLine"></td></tr> |
| <tr><td><div align="right"><a name="19"></a><a href="#19">19</a></div></td><td class="codeLine">/**</td></tr> |
| <tr><td><div align="right"><a name="20"></a><a href="#20">20</a></div></td><td class="codeLine"> * LoggerAppenderPDO appender logs to a database using the PHP's PDO extension.</td></tr> |
| <tr><td><div align="right"><a name="21"></a><a href="#21">21</a></div></td><td class="codeLine"> *</td></tr> |
| <tr><td><div align="right"><a name="22"></a><a href="#22">22</a></div></td><td class="codeLine"> * ## Configurable parameters: ##</td></tr> |
| <tr><td><div align="right"><a name="23"></a><a href="#23">23</a></div></td><td class="codeLine"> *</td></tr> |
| <tr><td><div align="right"><a name="24"></a><a href="#24">24</a></div></td><td class="codeLine"> * - dsn - The Data Source Name (DSN) used to connect to the database.</td></tr> |
| <tr><td><div align="right"><a name="25"></a><a href="#25">25</a></div></td><td class="codeLine"> * - user - Username used to connect to the database.</td></tr> |
| <tr><td><div align="right"><a name="26"></a><a href="#26">26</a></div></td><td class="codeLine"> * - password - Password used to connect to the database.</td></tr> |
| <tr><td><div align="right"><a name="27"></a><a href="#27">27</a></div></td><td class="codeLine"> * - table - Name of the table to which log entries are be inserted.</td></tr> |
| <tr><td><div align="right"><a name="28"></a><a href="#28">28</a></div></td><td class="codeLine"> * - insertSQL - Sets the insert statement for a logging event. Defaults</td></tr> |
| <tr><td><div align="right"><a name="29"></a><a href="#29">29</a></div></td><td class="codeLine"> * to the correct one - change only if you are sure what you are doing.</td></tr> |
| <tr><td><div align="right"><a name="30"></a><a href="#30">30</a></div></td><td class="codeLine"> * - insertPattern - The conversion pattern to use in conjuction with insert</td></tr> |
| <tr><td><div align="right"><a name="31"></a><a href="#31">31</a></div></td><td class="codeLine"> * SQL. Must contain the same number of comma separated</td></tr> |
| <tr><td><div align="right"><a name="32"></a><a href="#32">32</a></div></td><td class="codeLine"> * conversion patterns as there are question marks in the</td></tr> |
| <tr><td><div align="right"><a name="33"></a><a href="#33">33</a></div></td><td class="codeLine"> * insertSQL.</td></tr> |
| <tr><td><div align="right"><a name="34"></a><a href="#34">34</a></div></td><td class="codeLine"> *</td></tr> |
| <tr><td><div align="right"><a name="35"></a><a href="#35">35</a></div></td><td class="codeLine"> * @version $Revision: 1374546 $</td></tr> |
| <tr><td><div align="right"><a name="36"></a><a href="#36">36</a></div></td><td class="codeLine"> * @package log4php</td></tr> |
| <tr><td><div align="right"><a name="37"></a><a href="#37">37</a></div></td><td class="codeLine"> * @subpackage appenders</td></tr> |
| <tr><td><div align="right"><a name="38"></a><a href="#38">38</a></div></td><td class="codeLine"> * @since 2.0</td></tr> |
| <tr><td><div align="right"><a name="39"></a><a href="#39">39</a></div></td><td class="codeLine"> * @license http://www.apache.org/licenses/LICENSE-2.0 Apache License, Version 2.0</td></tr> |
| <tr><td><div align="right"><a name="40"></a><a href="#40">40</a></div></td><td class="codeLine"> * @link http://logging.apache.org/log4php/docs/appenders/pdo.html Appender documentation</td></tr> |
| <tr><td><div align="right"><a name="41"></a><a href="#41">41</a></div></td><td class="codeLine"> */</td></tr> |
| <tr><td><div align="right"><a name="42"></a><a href="#42">42</a></div></td><td class="codeLine">class LoggerAppenderPDO extends LoggerAppender {</td></tr> |
| <tr><td><div align="right"><a name="43"></a><a href="#43">43</a></div></td><td class="codeLine"></td></tr> |
| <tr><td><div align="right"><a name="44"></a><a href="#44">44</a></div></td><td class="codeLine"> // ******************************************</td></tr> |
| <tr><td><div align="right"><a name="45"></a><a href="#45">45</a></div></td><td class="codeLine"> // *** Configurable parameters ***</td></tr> |
| <tr><td><div align="right"><a name="46"></a><a href="#46">46</a></div></td><td class="codeLine"> // ******************************************</td></tr> |
| <tr><td><div align="right"><a name="47"></a><a href="#47">47</a></div></td><td class="codeLine"></td></tr> |
| <tr><td><div align="right"><a name="48"></a><a href="#48">48</a></div></td><td class="codeLine"> /**</td></tr> |
| <tr><td><div align="right"><a name="49"></a><a href="#49">49</a></div></td><td class="codeLine"> * DSN string used to connect to the database.</td></tr> |
| <tr><td><div align="right"><a name="50"></a><a href="#50">50</a></div></td><td class="codeLine"> * @see http://www.php.net/manual/en/pdo.construct.php</td></tr> |
| <tr><td><div align="right"><a name="51"></a><a href="#51">51</a></div></td><td class="codeLine"> */</td></tr> |
| <tr><td><div align="right"><a name="52"></a><a href="#52">52</a></div></td><td class="codeLine"> protected $dsn;</td></tr> |
| <tr><td><div align="right"><a name="53"></a><a href="#53">53</a></div></td><td class="codeLine"></td></tr> |
| <tr><td><div align="right"><a name="54"></a><a href="#54">54</a></div></td><td class="codeLine"> /** Database user name. */</td></tr> |
| <tr><td><div align="right"><a name="55"></a><a href="#55">55</a></div></td><td class="codeLine"> protected $user;</td></tr> |
| <tr><td><div align="right"><a name="56"></a><a href="#56">56</a></div></td><td class="codeLine"></td></tr> |
| <tr><td><div align="right"><a name="57"></a><a href="#57">57</a></div></td><td class="codeLine"> /** Database password. */</td></tr> |
| <tr><td><div align="right"><a name="58"></a><a href="#58">58</a></div></td><td class="codeLine"> protected $password;</td></tr> |
| <tr><td><div align="right"><a name="59"></a><a href="#59">59</a></div></td><td class="codeLine"></td></tr> |
| <tr><td><div align="right"><a name="60"></a><a href="#60">60</a></div></td><td class="codeLine"> /**</td></tr> |
| <tr><td><div align="right"><a name="61"></a><a href="#61">61</a></div></td><td class="codeLine"> * The insert query.</td></tr> |
| <tr><td><div align="right"><a name="62"></a><a href="#62">62</a></div></td><td class="codeLine"> *</td></tr> |
| <tr><td><div align="right"><a name="63"></a><a href="#63">63</a></div></td><td class="codeLine"> * The __TABLE__ placeholder will be replaced by the table name from</td></tr> |
| <tr><td><div align="right"><a name="64"></a><a href="#64">64</a></div></td><td class="codeLine"> * {@link $table}.</td></tr> |
| <tr><td><div align="right"><a name="65"></a><a href="#65">65</a></div></td><td class="codeLine"> *</td></tr> |
| <tr><td><div align="right"><a name="66"></a><a href="#66">66</a></div></td><td class="codeLine"> * The questionmarks are part of the prepared statement, and they must</td></tr> |
| <tr><td><div align="right"><a name="67"></a><a href="#67">67</a></div></td><td class="codeLine"> * match the number of conversion specifiers in {@link insertPattern}.</td></tr> |
| <tr><td><div align="right"><a name="68"></a><a href="#68">68</a></div></td><td class="codeLine"> */</td></tr> |
| <tr><td><div align="right"><a name="69"></a><a href="#69">69</a></div></td><td class="codeLine"> protected $insertSQL = "INSERT INTO __TABLE__ (timestamp, logger, level, message, thread, file, line) VALUES (?, ?, ?, ?, ?, ?, ?)";</td></tr> |
| <tr><td><div align="right"><a name="70"></a><a href="#70">70</a></div></td><td class="codeLine"></td></tr> |
| <tr><td><div align="right"><a name="71"></a><a href="#71">71</a></div></td><td class="codeLine"> /**</td></tr> |
| <tr><td><div align="right"><a name="72"></a><a href="#72">72</a></div></td><td class="codeLine"> * A comma separated list of {@link LoggerPatternLayout} format strings</td></tr> |
| <tr><td><div align="right"><a name="73"></a><a href="#73">73</a></div></td><td class="codeLine"> * which replace the "?" in {@link $insertSQL}.</td></tr> |
| <tr><td><div align="right"><a name="74"></a><a href="#74">74</a></div></td><td class="codeLine"> *</td></tr> |
| <tr><td><div align="right"><a name="75"></a><a href="#75">75</a></div></td><td class="codeLine"> * Must contain the same number of comma separated conversion patterns as</td></tr> |
| <tr><td><div align="right"><a name="76"></a><a href="#76">76</a></div></td><td class="codeLine"> * there are question marks in {@link insertSQL}.</td></tr> |
| <tr><td><div align="right"><a name="77"></a><a href="#77">77</a></div></td><td class="codeLine"> *</td></tr> |
| <tr><td><div align="right"><a name="78"></a><a href="#78">78</a></div></td><td class="codeLine"> * @see LoggerPatternLayout For conversion patterns.</td></tr> |
| <tr><td><div align="right"><a name="79"></a><a href="#79">79</a></div></td><td class="codeLine"> */</td></tr> |
| <tr><td><div align="right"><a name="80"></a><a href="#80">80</a></div></td><td class="codeLine"> protected $insertPattern = "%date{Y-m-d H:i:s},%logger,%level,%message,%pid,%file,%line";</td></tr> |
| <tr><td><div align="right"><a name="81"></a><a href="#81">81</a></div></td><td class="codeLine"></td></tr> |
| <tr><td><div align="right"><a name="82"></a><a href="#82">82</a></div></td><td class="codeLine"> /** Name of the table to which to append log events. */</td></tr> |
| <tr><td><div align="right"><a name="83"></a><a href="#83">83</a></div></td><td class="codeLine"> protected $table = 'log4php_log';</td></tr> |
| <tr><td><div align="right"><a name="84"></a><a href="#84">84</a></div></td><td class="codeLine"></td></tr> |
| <tr><td><div align="right"><a name="85"></a><a href="#85">85</a></div></td><td class="codeLine"> /** The number of recconect attempts to make on failed append. */</td></tr> |
| <tr><td><div align="right"><a name="86"></a><a href="#86">86</a></div></td><td class="codeLine"> protected $reconnectAttempts = 3;</td></tr> |
| <tr><td><div align="right"><a name="87"></a><a href="#87">87</a></div></td><td class="codeLine"></td></tr> |
| <tr><td><div align="right"><a name="88"></a><a href="#88">88</a></div></td><td class="codeLine"></td></tr> |
| <tr><td><div align="right"><a name="89"></a><a href="#89">89</a></div></td><td class="codeLine"> // ******************************************</td></tr> |
| <tr><td><div align="right"><a name="90"></a><a href="#90">90</a></div></td><td class="codeLine"> // *** Private memebers ***</td></tr> |
| <tr><td><div align="right"><a name="91"></a><a href="#91">91</a></div></td><td class="codeLine"> // ******************************************</td></tr> |
| <tr><td><div align="right"><a name="92"></a><a href="#92">92</a></div></td><td class="codeLine"></td></tr> |
| <tr><td><div align="right"><a name="93"></a><a href="#93">93</a></div></td><td class="codeLine"> /**</td></tr> |
| <tr><td><div align="right"><a name="94"></a><a href="#94">94</a></div></td><td class="codeLine"> * The PDO instance.</td></tr> |
| <tr><td><div align="right"><a name="95"></a><a href="#95">95</a></div></td><td class="codeLine"> * @var PDO</td></tr> |
| <tr><td><div align="right"><a name="96"></a><a href="#96">96</a></div></td><td class="codeLine"> */</td></tr> |
| <tr><td><div align="right"><a name="97"></a><a href="#97">97</a></div></td><td class="codeLine"> protected $db;</td></tr> |
| <tr><td><div align="right"><a name="98"></a><a href="#98">98</a></div></td><td class="codeLine"></td></tr> |
| <tr><td><div align="right"><a name="99"></a><a href="#99">99</a></div></td><td class="codeLine"> /**</td></tr> |
| <tr><td><div align="right"><a name="100"></a><a href="#100">100</a></div></td><td class="codeLine"> * Prepared statement for the insert query.</td></tr> |
| <tr><td><div align="right"><a name="101"></a><a href="#101">101</a></div></td><td class="codeLine"> * @var PDOStatement</td></tr> |
| <tr><td><div align="right"><a name="102"></a><a href="#102">102</a></div></td><td class="codeLine"> */</td></tr> |
| <tr><td><div align="right"><a name="103"></a><a href="#103">103</a></div></td><td class="codeLine"> protected $preparedInsert;</td></tr> |
| <tr><td><div align="right"><a name="104"></a><a href="#104">104</a></div></td><td class="codeLine"></td></tr> |
| <tr><td><div align="right"><a name="105"></a><a href="#105">105</a></div></td><td class="codeLine"> /** This appender does not require a layout. */</td></tr> |
| <tr><td><div align="right"><a name="106"></a><a href="#106">106</a></div></td><td class="codeLine"> protected $requiresLayout = false;</td></tr> |
| <tr><td><div align="right"><a name="107"></a><a href="#107">107</a></div></td><td class="codeLine"></td></tr> |
| <tr><td><div align="right"><a name="108"></a><a href="#108">108</a></div></td><td class="codeLine"></td></tr> |
| <tr><td><div align="right"><a name="109"></a><a href="#109">109</a></div></td><td class="codeLine"> // ******************************************</td></tr> |
| <tr><td><div align="right"><a name="110"></a><a href="#110">110</a></div></td><td class="codeLine"> // *** Appender methods ***</td></tr> |
| <tr><td><div align="right"><a name="111"></a><a href="#111">111</a></div></td><td class="codeLine"> // ******************************************</td></tr> |
| <tr><td><div align="right"><a name="112"></a><a href="#112">112</a></div></td><td class="codeLine"></td></tr> |
| <tr><td><div align="right"><a name="113"></a><a href="#113">113</a></div></td><td class="codeLine"> /**</td></tr> |
| <tr><td><div align="right"><a name="114"></a><a href="#114">114</a></div></td><td class="codeLine"> * Acquires a database connection based on parameters.</td></tr> |
| <tr><td><div align="right"><a name="115"></a><a href="#115">115</a></div></td><td class="codeLine"> * Parses the insert pattern to create a chain of converters which will be</td></tr> |
| <tr><td><div align="right"><a name="116"></a><a href="#116">116</a></div></td><td class="codeLine"> * used in forming query parameters from logging events.</td></tr> |
| <tr><td><div align="right"><a name="117"></a><a href="#117">117</a></div></td><td class="codeLine"> */</td></tr> |
| <tr><td><div align="right"><a name="118"></a><a href="#118">118</a></div></td><td class="codeLine"> public function activateOptions() {</td></tr> |
| <tr><td><div align="right"><a name="119"></a><a href="#119">119</a></div></td><td class="codeLine"> try {</td></tr> |
| <tr class="success popin" data-title="4 tests cover line 120" data-content="<ul><li class="success">LoggerAppenderPDOTest::testSimpleWithDefaults</li><li class="success">LoggerAppenderPDOTest::testCustomizedSql</li><li class="success">LoggerAppenderPDOTest::testException</li><li class="success">LoggerAppenderPDOTest::testClose</li></ul>" data-placement="bottom"><td><div align="right"><a name="120"></a><a href="#120">120</a></div></td><td class="codeLine"> $this->establishConnection();</td></tr> |
| <tr class="success popin" data-title="4 tests cover line 121" data-content="<ul><li class="success">LoggerAppenderPDOTest::testSimpleWithDefaults</li><li class="success">LoggerAppenderPDOTest::testCustomizedSql</li><li class="success">LoggerAppenderPDOTest::testException</li><li class="success">LoggerAppenderPDOTest::testClose</li></ul>" data-placement="bottom"><td><div align="right"><a name="121"></a><a href="#121">121</a></div></td><td class="codeLine"> } catch (PDOException $e) {</td></tr> |
| <tr class="success popin" data-title="1 test covers line 122" data-content="<ul><li class="success">LoggerAppenderPDOTest::testException</li></ul>" data-placement="bottom"><td><div align="right"><a name="122"></a><a href="#122">122</a></div></td><td class="codeLine"> $this->warn("Failed connecting to database. Closing appender. Error: " . $e->getMessage());</td></tr> |
| <tr class="danger"><td><div align="right"><a name="123"></a><a href="#123">123</a></div></td><td class="codeLine"> $this->close();</td></tr> |
| <tr class="danger"><td><div align="right"><a name="124"></a><a href="#124">124</a></div></td><td class="codeLine"> return;</td></tr> |
| <tr><td><div align="right"><a name="125"></a><a href="#125">125</a></div></td><td class="codeLine"> }</td></tr> |
| <tr><td><div align="right"><a name="126"></a><a href="#126">126</a></div></td><td class="codeLine"></td></tr> |
| <tr><td><div align="right"><a name="127"></a><a href="#127">127</a></div></td><td class="codeLine"> // Parse the insert patterns; pattern parts are comma delimited</td></tr> |
| <tr class="success popin" data-title="3 tests cover line 128" data-content="<ul><li class="success">LoggerAppenderPDOTest::testSimpleWithDefaults</li><li class="success">LoggerAppenderPDOTest::testCustomizedSql</li><li class="success">LoggerAppenderPDOTest::testClose</li></ul>" data-placement="bottom"><td><div align="right"><a name="128"></a><a href="#128">128</a></div></td><td class="codeLine"> $pieces = explode(',', $this->insertPattern);</td></tr> |
| <tr class="success popin" data-title="3 tests cover line 129" data-content="<ul><li class="success">LoggerAppenderPDOTest::testSimpleWithDefaults</li><li class="success">LoggerAppenderPDOTest::testCustomizedSql</li><li class="success">LoggerAppenderPDOTest::testClose</li></ul>" data-placement="bottom"><td><div align="right"><a name="129"></a><a href="#129">129</a></div></td><td class="codeLine"> $converterMap = LoggerLayoutPattern::getDefaultConverterMap();</td></tr> |
| <tr class="success popin" data-title="3 tests cover line 130" data-content="<ul><li class="success">LoggerAppenderPDOTest::testSimpleWithDefaults</li><li class="success">LoggerAppenderPDOTest::testCustomizedSql</li><li class="success">LoggerAppenderPDOTest::testClose</li></ul>" data-placement="bottom"><td><div align="right"><a name="130"></a><a href="#130">130</a></div></td><td class="codeLine"> foreach($pieces as $pattern) {</td></tr> |
| <tr class="success popin" data-title="3 tests cover line 131" data-content="<ul><li class="success">LoggerAppenderPDOTest::testSimpleWithDefaults</li><li class="success">LoggerAppenderPDOTest::testCustomizedSql</li><li class="success">LoggerAppenderPDOTest::testClose</li></ul>" data-placement="bottom"><td><div align="right"><a name="131"></a><a href="#131">131</a></div></td><td class="codeLine"> $parser = new LoggerPatternParser($pattern, $converterMap);</td></tr> |
| <tr class="success popin" data-title="3 tests cover line 132" data-content="<ul><li class="success">LoggerAppenderPDOTest::testSimpleWithDefaults</li><li class="success">LoggerAppenderPDOTest::testCustomizedSql</li><li class="success">LoggerAppenderPDOTest::testClose</li></ul>" data-placement="bottom"><td><div align="right"><a name="132"></a><a href="#132">132</a></div></td><td class="codeLine"> $this->converters[] = $parser->parse();</td></tr> |
| <tr class="success popin" data-title="3 tests cover line 133" data-content="<ul><li class="success">LoggerAppenderPDOTest::testSimpleWithDefaults</li><li class="success">LoggerAppenderPDOTest::testCustomizedSql</li><li class="success">LoggerAppenderPDOTest::testClose</li></ul>" data-placement="bottom"><td><div align="right"><a name="133"></a><a href="#133">133</a></div></td><td class="codeLine"> }</td></tr> |
| <tr><td><div align="right"><a name="134"></a><a href="#134">134</a></div></td><td class="codeLine"></td></tr> |
| <tr class="success popin" data-title="3 tests cover line 135" data-content="<ul><li class="success">LoggerAppenderPDOTest::testSimpleWithDefaults</li><li class="success">LoggerAppenderPDOTest::testCustomizedSql</li><li class="success">LoggerAppenderPDOTest::testClose</li></ul>" data-placement="bottom"><td><div align="right"><a name="135"></a><a href="#135">135</a></div></td><td class="codeLine"> $this->closed = false;</td></tr> |
| <tr class="success popin" data-title="3 tests cover line 136" data-content="<ul><li class="success">LoggerAppenderPDOTest::testSimpleWithDefaults</li><li class="success">LoggerAppenderPDOTest::testCustomizedSql</li><li class="success">LoggerAppenderPDOTest::testClose</li></ul>" data-placement="bottom"><td><div align="right"><a name="136"></a><a href="#136">136</a></div></td><td class="codeLine"> }</td></tr> |
| <tr><td><div align="right"><a name="137"></a><a href="#137">137</a></div></td><td class="codeLine"></td></tr> |
| <tr><td><div align="right"><a name="138"></a><a href="#138">138</a></div></td><td class="codeLine"> /**</td></tr> |
| <tr><td><div align="right"><a name="139"></a><a href="#139">139</a></div></td><td class="codeLine"> * Connects to the database, and prepares the insert query.</td></tr> |
| <tr><td><div align="right"><a name="140"></a><a href="#140">140</a></div></td><td class="codeLine"> * @throws PDOException If connect or prepare fails.</td></tr> |
| <tr><td><div align="right"><a name="141"></a><a href="#141">141</a></div></td><td class="codeLine"> */</td></tr> |
| <tr><td><div align="right"><a name="142"></a><a href="#142">142</a></div></td><td class="codeLine"> protected function establishConnection() {</td></tr> |
| <tr><td><div align="right"><a name="143"></a><a href="#143">143</a></div></td><td class="codeLine"> // Acquire database connection</td></tr> |
| <tr class="success popin" data-title="4 tests cover line 144" data-content="<ul><li class="success">LoggerAppenderPDOTest::testSimpleWithDefaults</li><li class="success">LoggerAppenderPDOTest::testCustomizedSql</li><li class="success">LoggerAppenderPDOTest::testException</li><li class="success">LoggerAppenderPDOTest::testClose</li></ul>" data-placement="bottom"><td><div align="right"><a name="144"></a><a href="#144">144</a></div></td><td class="codeLine"> $this->db = new PDO($this->dsn, $this->user, $this->password);</td></tr> |
| <tr class="success popin" data-title="3 tests cover line 145" data-content="<ul><li class="success">LoggerAppenderPDOTest::testSimpleWithDefaults</li><li class="success">LoggerAppenderPDOTest::testCustomizedSql</li><li class="success">LoggerAppenderPDOTest::testClose</li></ul>" data-placement="bottom"><td><div align="right"><a name="145"></a><a href="#145">145</a></div></td><td class="codeLine"> $this->db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);</td></tr> |
| <tr><td><div align="right"><a name="146"></a><a href="#146">146</a></div></td><td class="codeLine"></td></tr> |
| <tr><td><div align="right"><a name="147"></a><a href="#147">147</a></div></td><td class="codeLine"> // Prepare the insert statement</td></tr> |
| <tr class="success popin" data-title="3 tests cover line 148" data-content="<ul><li class="success">LoggerAppenderPDOTest::testSimpleWithDefaults</li><li class="success">LoggerAppenderPDOTest::testCustomizedSql</li><li class="success">LoggerAppenderPDOTest::testClose</li></ul>" data-placement="bottom"><td><div align="right"><a name="148"></a><a href="#148">148</a></div></td><td class="codeLine"> $insertSQL = str_replace('__TABLE__', $this->table, $this->insertSQL);</td></tr> |
| <tr class="success popin" data-title="3 tests cover line 149" data-content="<ul><li class="success">LoggerAppenderPDOTest::testSimpleWithDefaults</li><li class="success">LoggerAppenderPDOTest::testCustomizedSql</li><li class="success">LoggerAppenderPDOTest::testClose</li></ul>" data-placement="bottom"><td><div align="right"><a name="149"></a><a href="#149">149</a></div></td><td class="codeLine"> $this->preparedInsert = $this->db->prepare($insertSQL);</td></tr> |
| <tr class="success popin" data-title="3 tests cover line 150" data-content="<ul><li class="success">LoggerAppenderPDOTest::testSimpleWithDefaults</li><li class="success">LoggerAppenderPDOTest::testCustomizedSql</li><li class="success">LoggerAppenderPDOTest::testClose</li></ul>" data-placement="bottom"><td><div align="right"><a name="150"></a><a href="#150">150</a></div></td><td class="codeLine"> }</td></tr> |
| <tr><td><div align="right"><a name="151"></a><a href="#151">151</a></div></td><td class="codeLine"></td></tr> |
| <tr><td><div align="right"><a name="152"></a><a href="#152">152</a></div></td><td class="codeLine"> /**</td></tr> |
| <tr><td><div align="right"><a name="153"></a><a href="#153">153</a></div></td><td class="codeLine"> * Appends a new event to the database.</td></tr> |
| <tr><td><div align="right"><a name="154"></a><a href="#154">154</a></div></td><td class="codeLine"> *</td></tr> |
| <tr><td><div align="right"><a name="155"></a><a href="#155">155</a></div></td><td class="codeLine"> * If writing to database fails, it will retry by re-establishing the</td></tr> |
| <tr><td><div align="right"><a name="156"></a><a href="#156">156</a></div></td><td class="codeLine"> * connection up to $reconnectAttempts times. If writing still fails,</td></tr> |
| <tr><td><div align="right"><a name="157"></a><a href="#157">157</a></div></td><td class="codeLine"> * the appender will close.</td></tr> |
| <tr><td><div align="right"><a name="158"></a><a href="#158">158</a></div></td><td class="codeLine"> */</td></tr> |
| <tr><td><div align="right"><a name="159"></a><a href="#159">159</a></div></td><td class="codeLine"> public function append(LoggerLoggingEvent $event) {</td></tr> |
| <tr><td><div align="right"><a name="160"></a><a href="#160">160</a></div></td><td class="codeLine"></td></tr> |
| <tr class="success popin" data-title="3 tests cover line 161" data-content="<ul><li class="success">LoggerAppenderPDOTest::testSimpleWithDefaults</li><li class="success">LoggerAppenderPDOTest::testCustomizedSql</li><li class="success">LoggerAppenderPDOTest::testClose</li></ul>" data-placement="bottom"><td><div align="right"><a name="161"></a><a href="#161">161</a></div></td><td class="codeLine"> for ($attempt = 1; $attempt <= $this->reconnectAttempts + 1; $attempt++) {</td></tr> |
| <tr><td><div align="right"><a name="162"></a><a href="#162">162</a></div></td><td class="codeLine"> try {</td></tr> |
| <tr><td><div align="right"><a name="163"></a><a href="#163">163</a></div></td><td class="codeLine"> // Attempt to write to database</td></tr> |
| <tr class="success popin" data-title="3 tests cover line 164" data-content="<ul><li class="success">LoggerAppenderPDOTest::testSimpleWithDefaults</li><li class="success">LoggerAppenderPDOTest::testCustomizedSql</li><li class="success">LoggerAppenderPDOTest::testClose</li></ul>" data-placement="bottom"><td><div align="right"><a name="164"></a><a href="#164">164</a></div></td><td class="codeLine"> $this->preparedInsert->execute($this->format($event));</td></tr> |
| <tr class="success popin" data-title="3 tests cover line 165" data-content="<ul><li class="success">LoggerAppenderPDOTest::testSimpleWithDefaults</li><li class="success">LoggerAppenderPDOTest::testCustomizedSql</li><li class="success">LoggerAppenderPDOTest::testClose</li></ul>" data-placement="bottom"><td><div align="right"><a name="165"></a><a href="#165">165</a></div></td><td class="codeLine"> $this->preparedInsert->closeCursor();</td></tr> |
| <tr class="success popin" data-title="3 tests cover line 166" data-content="<ul><li class="success">LoggerAppenderPDOTest::testSimpleWithDefaults</li><li class="success">LoggerAppenderPDOTest::testCustomizedSql</li><li class="success">LoggerAppenderPDOTest::testClose</li></ul>" data-placement="bottom"><td><div align="right"><a name="166"></a><a href="#166">166</a></div></td><td class="codeLine"> break;</td></tr> |
| <tr class="danger"><td><div align="right"><a name="167"></a><a href="#167">167</a></div></td><td class="codeLine"> } catch (PDOException $e) {</td></tr> |
| <tr class="danger"><td><div align="right"><a name="168"></a><a href="#168">168</a></div></td><td class="codeLine"> $this->warn("Failed writing to database: ". $e->getMessage());</td></tr> |
| <tr><td><div align="right"><a name="169"></a><a href="#169">169</a></div></td><td class="codeLine"></td></tr> |
| <tr><td><div align="right"><a name="170"></a><a href="#170">170</a></div></td><td class="codeLine"> // Close the appender if it's the last attempt</td></tr> |
| <tr class="danger"><td><div align="right"><a name="171"></a><a href="#171">171</a></div></td><td class="codeLine"> if ($attempt > $this->reconnectAttempts) {</td></tr> |
| <tr class="danger"><td><div align="right"><a name="172"></a><a href="#172">172</a></div></td><td class="codeLine"> $this->warn("Failed writing to database after {$this->reconnectAttempts} reconnect attempts. Closing appender.");</td></tr> |
| <tr class="danger"><td><div align="right"><a name="173"></a><a href="#173">173</a></div></td><td class="codeLine"> $this->close();</td></tr> |
| <tr><td><div align="right"><a name="174"></a><a href="#174">174</a></div></td><td class="codeLine"> // Otherwise reconnect and try to write again</td></tr> |
| <tr class="danger"><td><div align="right"><a name="175"></a><a href="#175">175</a></div></td><td class="codeLine"> } else {</td></tr> |
| <tr class="danger"><td><div align="right"><a name="176"></a><a href="#176">176</a></div></td><td class="codeLine"> $this->warn("Attempting a reconnect (attempt $attempt of {$this->reconnectAttempts}).");</td></tr> |
| <tr class="danger"><td><div align="right"><a name="177"></a><a href="#177">177</a></div></td><td class="codeLine"> $this->establishConnection();</td></tr> |
| <tr><td><div align="right"><a name="178"></a><a href="#178">178</a></div></td><td class="codeLine"> }</td></tr> |
| <tr><td><div align="right"><a name="179"></a><a href="#179">179</a></div></td><td class="codeLine"> }</td></tr> |
| <tr class="danger"><td><div align="right"><a name="180"></a><a href="#180">180</a></div></td><td class="codeLine"> }</td></tr> |
| <tr class="success popin" data-title="3 tests cover line 181" data-content="<ul><li class="success">LoggerAppenderPDOTest::testSimpleWithDefaults</li><li class="success">LoggerAppenderPDOTest::testCustomizedSql</li><li class="success">LoggerAppenderPDOTest::testClose</li></ul>" data-placement="bottom"><td><div align="right"><a name="181"></a><a href="#181">181</a></div></td><td class="codeLine"> }</td></tr> |
| <tr><td><div align="right"><a name="182"></a><a href="#182">182</a></div></td><td class="codeLine"></td></tr> |
| <tr><td><div align="right"><a name="183"></a><a href="#183">183</a></div></td><td class="codeLine"> /**</td></tr> |
| <tr><td><div align="right"><a name="184"></a><a href="#184">184</a></div></td><td class="codeLine"> * Converts the logging event to a series of database parameters by using</td></tr> |
| <tr><td><div align="right"><a name="185"></a><a href="#185">185</a></div></td><td class="codeLine"> * the converter chain which was set up on activation.</td></tr> |
| <tr><td><div align="right"><a name="186"></a><a href="#186">186</a></div></td><td class="codeLine"> */</td></tr> |
| <tr><td><div align="right"><a name="187"></a><a href="#187">187</a></div></td><td class="codeLine"> protected function format(LoggerLoggingEvent $event) {</td></tr> |
| <tr class="success popin" data-title="3 tests cover line 188" data-content="<ul><li class="success">LoggerAppenderPDOTest::testSimpleWithDefaults</li><li class="success">LoggerAppenderPDOTest::testCustomizedSql</li><li class="success">LoggerAppenderPDOTest::testClose</li></ul>" data-placement="bottom"><td><div align="right"><a name="188"></a><a href="#188">188</a></div></td><td class="codeLine"> $params = array();</td></tr> |
| <tr class="success popin" data-title="3 tests cover line 189" data-content="<ul><li class="success">LoggerAppenderPDOTest::testSimpleWithDefaults</li><li class="success">LoggerAppenderPDOTest::testCustomizedSql</li><li class="success">LoggerAppenderPDOTest::testClose</li></ul>" data-placement="bottom"><td><div align="right"><a name="189"></a><a href="#189">189</a></div></td><td class="codeLine"> foreach($this->converters as $converter) {</td></tr> |
| <tr class="success popin" data-title="3 tests cover line 190" data-content="<ul><li class="success">LoggerAppenderPDOTest::testSimpleWithDefaults</li><li class="success">LoggerAppenderPDOTest::testCustomizedSql</li><li class="success">LoggerAppenderPDOTest::testClose</li></ul>" data-placement="bottom"><td><div align="right"><a name="190"></a><a href="#190">190</a></div></td><td class="codeLine"> $buffer = '';</td></tr> |
| <tr class="success popin" data-title="3 tests cover line 191" data-content="<ul><li class="success">LoggerAppenderPDOTest::testSimpleWithDefaults</li><li class="success">LoggerAppenderPDOTest::testCustomizedSql</li><li class="success">LoggerAppenderPDOTest::testClose</li></ul>" data-placement="bottom"><td><div align="right"><a name="191"></a><a href="#191">191</a></div></td><td class="codeLine"> while ($converter !== null) {</td></tr> |
| <tr class="success popin" data-title="3 tests cover line 192" data-content="<ul><li class="success">LoggerAppenderPDOTest::testSimpleWithDefaults</li><li class="success">LoggerAppenderPDOTest::testCustomizedSql</li><li class="success">LoggerAppenderPDOTest::testClose</li></ul>" data-placement="bottom"><td><div align="right"><a name="192"></a><a href="#192">192</a></div></td><td class="codeLine"> $converter->format($buffer, $event);</td></tr> |
| <tr class="success popin" data-title="3 tests cover line 193" data-content="<ul><li class="success">LoggerAppenderPDOTest::testSimpleWithDefaults</li><li class="success">LoggerAppenderPDOTest::testCustomizedSql</li><li class="success">LoggerAppenderPDOTest::testClose</li></ul>" data-placement="bottom"><td><div align="right"><a name="193"></a><a href="#193">193</a></div></td><td class="codeLine"> $converter = $converter->next;</td></tr> |
| <tr class="success popin" data-title="3 tests cover line 194" data-content="<ul><li class="success">LoggerAppenderPDOTest::testSimpleWithDefaults</li><li class="success">LoggerAppenderPDOTest::testCustomizedSql</li><li class="success">LoggerAppenderPDOTest::testClose</li></ul>" data-placement="bottom"><td><div align="right"><a name="194"></a><a href="#194">194</a></div></td><td class="codeLine"> }</td></tr> |
| <tr class="success popin" data-title="3 tests cover line 195" data-content="<ul><li class="success">LoggerAppenderPDOTest::testSimpleWithDefaults</li><li class="success">LoggerAppenderPDOTest::testCustomizedSql</li><li class="success">LoggerAppenderPDOTest::testClose</li></ul>" data-placement="bottom"><td><div align="right"><a name="195"></a><a href="#195">195</a></div></td><td class="codeLine"> $params[] = $buffer;</td></tr> |
| <tr class="success popin" data-title="3 tests cover line 196" data-content="<ul><li class="success">LoggerAppenderPDOTest::testSimpleWithDefaults</li><li class="success">LoggerAppenderPDOTest::testCustomizedSql</li><li class="success">LoggerAppenderPDOTest::testClose</li></ul>" data-placement="bottom"><td><div align="right"><a name="196"></a><a href="#196">196</a></div></td><td class="codeLine"> }</td></tr> |
| <tr class="success popin" data-title="3 tests cover line 197" data-content="<ul><li class="success">LoggerAppenderPDOTest::testSimpleWithDefaults</li><li class="success">LoggerAppenderPDOTest::testCustomizedSql</li><li class="success">LoggerAppenderPDOTest::testClose</li></ul>" data-placement="bottom"><td><div align="right"><a name="197"></a><a href="#197">197</a></div></td><td class="codeLine"> return $params;</td></tr> |
| <tr><td><div align="right"><a name="198"></a><a href="#198">198</a></div></td><td class="codeLine"> }</td></tr> |
| <tr><td><div align="right"><a name="199"></a><a href="#199">199</a></div></td><td class="codeLine"></td></tr> |
| <tr><td><div align="right"><a name="200"></a><a href="#200">200</a></div></td><td class="codeLine"> /**</td></tr> |
| <tr><td><div align="right"><a name="201"></a><a href="#201">201</a></div></td><td class="codeLine"> * Closes the connection to the logging database</td></tr> |
| <tr><td><div align="right"><a name="202"></a><a href="#202">202</a></div></td><td class="codeLine"> */</td></tr> |
| <tr><td><div align="right"><a name="203"></a><a href="#203">203</a></div></td><td class="codeLine"> public function close() {</td></tr> |
| <tr><td><div align="right"><a name="204"></a><a href="#204">204</a></div></td><td class="codeLine"> // Close the connection (if any)</td></tr> |
| <tr class="success popin" data-title="5 tests cover line 205" data-content="<ul><li class="success">LoggerAppenderPDOTest::testRequiresLayout</li><li class="success">LoggerAppenderPDOTest::testSimpleWithDefaults</li><li class="success">LoggerAppenderPDOTest::testCustomizedSql</li><li class="success">LoggerAppenderPDOTest::testException</li><li class="success">LoggerAppenderPDOTest::testClose</li></ul>" data-placement="bottom"><td><div align="right"><a name="205"></a><a href="#205">205</a></div></td><td class="codeLine"> $this->db = null;</td></tr> |
| <tr><td><div align="right"><a name="206"></a><a href="#206">206</a></div></td><td class="codeLine"></td></tr> |
| <tr><td><div align="right"><a name="207"></a><a href="#207">207</a></div></td><td class="codeLine"> // Close the appender</td></tr> |
| <tr class="success popin" data-title="5 tests cover line 208" data-content="<ul><li class="success">LoggerAppenderPDOTest::testRequiresLayout</li><li class="success">LoggerAppenderPDOTest::testSimpleWithDefaults</li><li class="success">LoggerAppenderPDOTest::testCustomizedSql</li><li class="success">LoggerAppenderPDOTest::testException</li><li class="success">LoggerAppenderPDOTest::testClose</li></ul>" data-placement="bottom"><td><div align="right"><a name="208"></a><a href="#208">208</a></div></td><td class="codeLine"> $this->closed = true;</td></tr> |
| <tr class="success popin" data-title="5 tests cover line 209" data-content="<ul><li class="success">LoggerAppenderPDOTest::testRequiresLayout</li><li class="success">LoggerAppenderPDOTest::testSimpleWithDefaults</li><li class="success">LoggerAppenderPDOTest::testCustomizedSql</li><li class="success">LoggerAppenderPDOTest::testException</li><li class="success">LoggerAppenderPDOTest::testClose</li></ul>" data-placement="bottom"><td><div align="right"><a name="209"></a><a href="#209">209</a></div></td><td class="codeLine"> }</td></tr> |
| <tr><td><div align="right"><a name="210"></a><a href="#210">210</a></div></td><td class="codeLine"></td></tr> |
| <tr><td><div align="right"><a name="211"></a><a href="#211">211</a></div></td><td class="codeLine"> // ******************************************</td></tr> |
| <tr><td><div align="right"><a name="212"></a><a href="#212">212</a></div></td><td class="codeLine"> // *** Accessor methods ***</td></tr> |
| <tr><td><div align="right"><a name="213"></a><a href="#213">213</a></div></td><td class="codeLine"> // ******************************************</td></tr> |
| <tr><td><div align="right"><a name="214"></a><a href="#214">214</a></div></td><td class="codeLine"></td></tr> |
| <tr><td><div align="right"><a name="215"></a><a href="#215">215</a></div></td><td class="codeLine"> /**</td></tr> |
| <tr><td><div align="right"><a name="216"></a><a href="#216">216</a></div></td><td class="codeLine"> * Returns the active database handle or null if not established.</td></tr> |
| <tr><td><div align="right"><a name="217"></a><a href="#217">217</a></div></td><td class="codeLine"> * @return PDO</td></tr> |
| <tr><td><div align="right"><a name="218"></a><a href="#218">218</a></div></td><td class="codeLine"> */</td></tr> |
| <tr><td><div align="right"><a name="219"></a><a href="#219">219</a></div></td><td class="codeLine"> public function getDatabaseHandle() {</td></tr> |
| <tr class="success popin" data-title="1 test covers line 220" data-content="<ul><li class="success">LoggerAppenderPDOTest::testClose</li></ul>" data-placement="bottom"><td><div align="right"><a name="220"></a><a href="#220">220</a></div></td><td class="codeLine"> return $this->db;</td></tr> |
| <tr><td><div align="right"><a name="221"></a><a href="#221">221</a></div></td><td class="codeLine"> }</td></tr> |
| <tr><td><div align="right"><a name="222"></a><a href="#222">222</a></div></td><td class="codeLine"></td></tr> |
| <tr><td><div align="right"><a name="223"></a><a href="#223">223</a></div></td><td class="codeLine"> /** Sets the username. */</td></tr> |
| <tr><td><div align="right"><a name="224"></a><a href="#224">224</a></div></td><td class="codeLine"> public function setUser($user) {</td></tr> |
| <tr class="danger"><td><div align="right"><a name="225"></a><a href="#225">225</a></div></td><td class="codeLine"> $this->setString('user', $user);</td></tr> |
| <tr class="danger"><td><div align="right"><a name="226"></a><a href="#226">226</a></div></td><td class="codeLine"> }</td></tr> |
| <tr><td><div align="right"><a name="227"></a><a href="#227">227</a></div></td><td class="codeLine"></td></tr> |
| <tr><td><div align="right"><a name="228"></a><a href="#228">228</a></div></td><td class="codeLine"> /** Returns the username. */</td></tr> |
| <tr><td><div align="right"><a name="229"></a><a href="#229">229</a></div></td><td class="codeLine"> public function getUser($user) {</td></tr> |
| <tr class="danger"><td><div align="right"><a name="230"></a><a href="#230">230</a></div></td><td class="codeLine"> return $this->user;</td></tr> |
| <tr><td><div align="right"><a name="231"></a><a href="#231">231</a></div></td><td class="codeLine"> }</td></tr> |
| <tr><td><div align="right"><a name="232"></a><a href="#232">232</a></div></td><td class="codeLine"></td></tr> |
| <tr><td><div align="right"><a name="233"></a><a href="#233">233</a></div></td><td class="codeLine"> /** Sets the password. */</td></tr> |
| <tr><td><div align="right"><a name="234"></a><a href="#234">234</a></div></td><td class="codeLine"> public function setPassword($password) {</td></tr> |
| <tr class="danger"><td><div align="right"><a name="235"></a><a href="#235">235</a></div></td><td class="codeLine"> $this->setString('password', $password);</td></tr> |
| <tr class="danger"><td><div align="right"><a name="236"></a><a href="#236">236</a></div></td><td class="codeLine"> }</td></tr> |
| <tr><td><div align="right"><a name="237"></a><a href="#237">237</a></div></td><td class="codeLine"></td></tr> |
| <tr><td><div align="right"><a name="238"></a><a href="#238">238</a></div></td><td class="codeLine"> /** Returns the password. */</td></tr> |
| <tr><td><div align="right"><a name="239"></a><a href="#239">239</a></div></td><td class="codeLine"> public function getPassword($password) {</td></tr> |
| <tr class="danger"><td><div align="right"><a name="240"></a><a href="#240">240</a></div></td><td class="codeLine"> return $this->password;</td></tr> |
| <tr><td><div align="right"><a name="241"></a><a href="#241">241</a></div></td><td class="codeLine"> }</td></tr> |
| <tr><td><div align="right"><a name="242"></a><a href="#242">242</a></div></td><td class="codeLine"></td></tr> |
| <tr><td><div align="right"><a name="243"></a><a href="#243">243</a></div></td><td class="codeLine"> /** Sets the insert SQL. */</td></tr> |
| <tr><td><div align="right"><a name="244"></a><a href="#244">244</a></div></td><td class="codeLine"> public function setInsertSQL($sql) {</td></tr> |
| <tr class="success popin" data-title="1 test covers line 245" data-content="<ul><li class="success">LoggerAppenderPDOTest::testCustomizedSql</li></ul>" data-placement="bottom"><td><div align="right"><a name="245"></a><a href="#245">245</a></div></td><td class="codeLine"> $this->setString('insertSQL', $sql);</td></tr> |
| <tr class="success popin" data-title="1 test covers line 246" data-content="<ul><li class="success">LoggerAppenderPDOTest::testCustomizedSql</li></ul>" data-placement="bottom"><td><div align="right"><a name="246"></a><a href="#246">246</a></div></td><td class="codeLine"> }</td></tr> |
| <tr><td><div align="right"><a name="247"></a><a href="#247">247</a></div></td><td class="codeLine"></td></tr> |
| <tr><td><div align="right"><a name="248"></a><a href="#248">248</a></div></td><td class="codeLine"> /** Returns the insert SQL. */</td></tr> |
| <tr><td><div align="right"><a name="249"></a><a href="#249">249</a></div></td><td class="codeLine"> public function getInsertSQL($sql) {</td></tr> |
| <tr class="danger"><td><div align="right"><a name="250"></a><a href="#250">250</a></div></td><td class="codeLine"> return $this->insertSQL;</td></tr> |
| <tr><td><div align="right"><a name="251"></a><a href="#251">251</a></div></td><td class="codeLine"> }</td></tr> |
| <tr><td><div align="right"><a name="252"></a><a href="#252">252</a></div></td><td class="codeLine"></td></tr> |
| <tr><td><div align="right"><a name="253"></a><a href="#253">253</a></div></td><td class="codeLine"> /** Sets the insert pattern. */</td></tr> |
| <tr><td><div align="right"><a name="254"></a><a href="#254">254</a></div></td><td class="codeLine"> public function setInsertPattern($pattern) {</td></tr> |
| <tr class="success popin" data-title="1 test covers line 255" data-content="<ul><li class="success">LoggerAppenderPDOTest::testCustomizedSql</li></ul>" data-placement="bottom"><td><div align="right"><a name="255"></a><a href="#255">255</a></div></td><td class="codeLine"> $this->setString('insertPattern', $pattern);</td></tr> |
| <tr class="success popin" data-title="1 test covers line 256" data-content="<ul><li class="success">LoggerAppenderPDOTest::testCustomizedSql</li></ul>" data-placement="bottom"><td><div align="right"><a name="256"></a><a href="#256">256</a></div></td><td class="codeLine"> }</td></tr> |
| <tr><td><div align="right"><a name="257"></a><a href="#257">257</a></div></td><td class="codeLine"></td></tr> |
| <tr><td><div align="right"><a name="258"></a><a href="#258">258</a></div></td><td class="codeLine"> /** Returns the insert pattern. */</td></tr> |
| <tr><td><div align="right"><a name="259"></a><a href="#259">259</a></div></td><td class="codeLine"> public function getInsertPattern($pattern) {</td></tr> |
| <tr class="danger"><td><div align="right"><a name="260"></a><a href="#260">260</a></div></td><td class="codeLine"> return $this->insertPattern;</td></tr> |
| <tr><td><div align="right"><a name="261"></a><a href="#261">261</a></div></td><td class="codeLine"> }</td></tr> |
| <tr><td><div align="right"><a name="262"></a><a href="#262">262</a></div></td><td class="codeLine"></td></tr> |
| <tr><td><div align="right"><a name="263"></a><a href="#263">263</a></div></td><td class="codeLine"> /** Sets the table name. */</td></tr> |
| <tr><td><div align="right"><a name="264"></a><a href="#264">264</a></div></td><td class="codeLine"> public function setTable($table) {</td></tr> |
| <tr class="danger"><td><div align="right"><a name="265"></a><a href="#265">265</a></div></td><td class="codeLine"> $this->setString('table', $table);</td></tr> |
| <tr class="danger"><td><div align="right"><a name="266"></a><a href="#266">266</a></div></td><td class="codeLine"> }</td></tr> |
| <tr><td><div align="right"><a name="267"></a><a href="#267">267</a></div></td><td class="codeLine"></td></tr> |
| <tr><td><div align="right"><a name="268"></a><a href="#268">268</a></div></td><td class="codeLine"> /** Returns the table name. */</td></tr> |
| <tr><td><div align="right"><a name="269"></a><a href="#269">269</a></div></td><td class="codeLine"> public function getTable($table) {</td></tr> |
| <tr class="danger"><td><div align="right"><a name="270"></a><a href="#270">270</a></div></td><td class="codeLine"> return $this->table;</td></tr> |
| <tr><td><div align="right"><a name="271"></a><a href="#271">271</a></div></td><td class="codeLine"> }</td></tr> |
| <tr><td><div align="right"><a name="272"></a><a href="#272">272</a></div></td><td class="codeLine"></td></tr> |
| <tr><td><div align="right"><a name="273"></a><a href="#273">273</a></div></td><td class="codeLine"> /** Sets the DSN string. */</td></tr> |
| <tr><td><div align="right"><a name="274"></a><a href="#274">274</a></div></td><td class="codeLine"> public function setDSN($dsn) {</td></tr> |
| <tr class="success popin" data-title="4 tests cover line 275" data-content="<ul><li class="success">LoggerAppenderPDOTest::testSimpleWithDefaults</li><li class="success">LoggerAppenderPDOTest::testCustomizedSql</li><li class="success">LoggerAppenderPDOTest::testException</li><li class="success">LoggerAppenderPDOTest::testClose</li></ul>" data-placement="bottom"><td><div align="right"><a name="275"></a><a href="#275">275</a></div></td><td class="codeLine"> $this->setString('dsn', $dsn);</td></tr> |
| <tr class="success popin" data-title="4 tests cover line 276" data-content="<ul><li class="success">LoggerAppenderPDOTest::testSimpleWithDefaults</li><li class="success">LoggerAppenderPDOTest::testCustomizedSql</li><li class="success">LoggerAppenderPDOTest::testException</li><li class="success">LoggerAppenderPDOTest::testClose</li></ul>" data-placement="bottom"><td><div align="right"><a name="276"></a><a href="#276">276</a></div></td><td class="codeLine"> }</td></tr> |
| <tr><td><div align="right"><a name="277"></a><a href="#277">277</a></div></td><td class="codeLine"></td></tr> |
| <tr><td><div align="right"><a name="278"></a><a href="#278">278</a></div></td><td class="codeLine"> /** Returns the DSN string. */</td></tr> |
| <tr><td><div align="right"><a name="279"></a><a href="#279">279</a></div></td><td class="codeLine"> public function getDSN($dsn) {</td></tr> |
| <tr class="danger"><td><div align="right"><a name="280"></a><a href="#280">280</a></div></td><td class="codeLine"> return $this->setString('dsn', $dsn);</td></tr> |
| <tr><td><div align="right"><a name="281"></a><a href="#281">281</a></div></td><td class="codeLine"> }</td></tr> |
| <tr><td><div align="right"><a name="282"></a><a href="#282">282</a></div></td><td class="codeLine">}</td></tr> |
| |
| </tbody> |
| </table> |
| <footer> |
| <h4>Legend</h4> |
| <p> |
| <span class="success"><strong>Executed</strong></span> |
| <span class="danger"><strong>Not Executed</strong></span> |
| <span class="warning"><strong>Dead Code</strong></span> |
| </p> |
| <p> |
| <small>Generated by <a href="http://github.com/sebastianbergmann/php-code-coverage" target="_top">PHP_CodeCoverage 1.2.3</a> using <a href="http://www.php.net/" target="_top">PHP 5.3.13</a> and <a href="http://phpunit.de/">PHPUnit 3.7.6</a> at Sat Oct 13 8:58:14 BST 2012.</small> |
| </p> |
| </footer> |
| </div> |
| <script src="js/jquery.min.js" type="text/javascript"></script> |
| <script src="js/bootstrap.min.js" type="text/javascript"></script> |
| <script type="text/javascript">$('.popin').popover({trigger: 'hover'});</script> |
| </body> |
| </html> |
