1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
<div id="content">
<h1 align="center">Source for file Unique.php</h1>
<p>Documentation is available at <a href="../Doctrine/_Doctrine---Validator---Unique.php.html">Unique.php</a></p>
<div class="src-code"><span class="php">
<ol><li><div class="src-line"><a name="a1"></a><span class="src-php"><?php</span></div></li>
<li><div class="src-line"><a name="a2"></a><span class="src-comm">/*</span></div></li>
<li><div class="src-line"><a name="a3"></a><span class="src-comm"> * $Id: Unique.php 2240 2007-08-14 20:23:54Z Jonathan.Wage $</span></div></li>
<li><div class="src-line"><a name="a4"></a><span class="src-comm"> *</span></div></li>
<li><div class="src-line"><a name="a5"></a><span class="src-comm"> * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS</span></div></li>
<li><div class="src-line"><a name="a6"></a><span class="src-comm"> * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT</span></div></li>
<li><div class="src-line"><a name="a7"></a><span class="src-comm"> * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR</span></div></li>
<li><div class="src-line"><a name="a8"></a><span class="src-comm"> * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT</span></div></li>
<li><div class="src-line"><a name="a9"></a><span class="src-comm"> * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,</span></div></li>
<li><div class="src-line"><a name="a10"></a><span class="src-comm"> * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT</span></div></li>
<li><div class="src-line"><a name="a11"></a><span class="src-comm"> * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,</span></div></li>
<li><div class="src-line"><a name="a12"></a><span class="src-comm"> * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY</span></div></li>
<li><div class="src-line"><a name="a13"></a><span class="src-comm"> * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT</span></div></li>
<li><div class="src-line"><a name="a14"></a><span class="src-comm"> * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE</span></div></li>
<li><div class="src-line"><a name="a15"></a><span class="src-comm"> * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.</span></div></li>
<li><div class="src-line"><a name="a16"></a><span class="src-comm"> *</span></div></li>
<li><div class="src-line"><a name="a17"></a><span class="src-comm"> * This software consists of voluntary contributions made by many individuals</span></div></li>
<li><div class="src-line"><a name="a18"></a><span class="src-comm"> * and is licensed under the LGPL. For more information, see</span></div></li>
<li><div class="src-line"><a name="a19"></a><span class="src-comm"> * <http://www.phpdoctrine.com>.</span></div></li>
<li><div class="src-line"><a name="a20"></a><span class="src-comm"> */</span></div></li>
<li><div class="src-line"><a name="a21"></a> </div></li>
<li><div class="src-line"><a name="a22"></a><span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a23"></a><span class="src-doc"> * Doctrine_Validator_Unique</span></div></li>
<li><div class="src-line"><a name="a24"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a25"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@package</span><span class="src-doc"> Doctrine</span></div></li>
<li><div class="src-line"><a name="a26"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@category</span><span class="src-doc"> Object Relational Mapping</span></div></li>
<li><div class="src-line"><a name="a27"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@license</span><span class="src-doc"> http://www.opensource.org/licenses/lgpl-license.php LGPL</span></div></li>
<li><div class="src-line"><a name="a28"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@link</span><span class="src-doc"> www.phpdoctrine.com</span></div></li>
<li><div class="src-line"><a name="a29"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@since</span><span class="src-doc"> 1.0</span></div></li>
<li><div class="src-line"><a name="a30"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@version</span><span class="src-doc"> $Revision: 2240 $</span></div></li>
<li><div class="src-line"><a name="a31"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@author</span><span class="src-doc"> Konsta Vesterinen <kvesteri@cc.hut.fi></span></div></li>
<li><div class="src-line"><a name="a32"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a33"></a><span class="src-key">class </span><a href="../Doctrine/Doctrine_Validator_Unique.html">Doctrine_Validator_Unique</a></div></li>
<li><div class="src-line"><a name="a34"></a><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a35"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a36"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">Doctrine_Record </span><span class="src-doc-var">$record </span></div></li>
<li><div class="src-line"><a name="a37"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc-var">$key </span></div></li>
<li><div class="src-line"><a name="a38"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">mixed </span><span class="src-doc-var">$value </span></div></li>
<li><div class="src-line"><a name="a39"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc-var">$args </span></div></li>
<li><div class="src-line"><a name="a40"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">boolean </span></div></li>
<li><div class="src-line"><a name="a41"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a42"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Validator_Unique.html#methodvalidate">validate</a><span class="src-sym">(</span><span class="src-id">Doctrine_Record </span><span class="src-var">$record</span><span class="src-sym">, </span><span class="src-var">$key</span><span class="src-sym">, </span><span class="src-var">$value</span><span class="src-sym">, </span><span class="src-var">$args</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a43"></a> <span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a44"></a> <span class="src-var">$table </span>= <span class="src-var">$record</span><span class="src-sym">-></span><span class="src-id">getTable</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a45"></a> <span class="src-var">$pks </span>= <span class="src-var">$table</span><span class="src-sym">-></span><span class="src-id">getIdentifier</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a46"></a> <span class="src-key">if </span><span class="src-sym">( </span><a href="http://www.php.net/is_array">is_array</a><span class="src-sym">(</span><span class="src-var">$pks</span><span class="src-sym">) ) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a47"></a> <span class="src-var">$pks </span>= <a href="http://www.php.net/join">join</a><span class="src-sym">(</span><span class="src-str">','</span><span class="src-sym">,</span><span class="src-var">$pks</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a48"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a49"></a> </div></li>
<li><div class="src-line"><a name="a50"></a> <span class="src-var">$sql </span>= <span class="src-str">'SELECT ' </span>. <span class="src-var">$pks </span>. <span class="src-str">' FROM ' </span>. <span class="src-var">$table</span><span class="src-sym">-></span><span class="src-id">getTableName</span><span class="src-sym">(</span><span class="src-sym">) </span>. <span class="src-str">' WHERE ' </span>. <span class="src-var">$key </span>. <span class="src-str">' = ?'</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a51"></a> </div></li>
<li><div class="src-line"><a name="a52"></a> <span class="src-var">$values </span>= <span class="src-key">array</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a53"></a> <span class="src-var">$values</span><span class="src-sym">[</span><span class="src-sym">] </span>= <span class="src-var">$value</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a54"></a> </div></li>
<li><div class="src-line"><a name="a55"></a> <span class="src-comm">// If the record is not new we need to add primary key checks because its ok if the </span></div></li>
<li><div class="src-line"><a name="a56"></a> <span class="src-comm">// unique value already exists in the database IF the record in the database is the same</span></div></li>
<li><div class="src-line"><a name="a57"></a> <span class="src-comm">// as the one that is validated here.</span></div></li>
<li><div class="src-line"><a name="a58"></a> <span class="src-var">$state </span>= <span class="src-var">$record</span><span class="src-sym">-></span><span class="src-id">state</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a59"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-sym">! </span><span class="src-sym">(</span><span class="src-var">$state </span>== <span class="src-id"><a href="../Doctrine/Doctrine_Record.html">Doctrine_Record</a></span><span class="src-sym">::</span><span class="src-id">STATE_TDIRTY </span>|| <span class="src-var">$state </span>== <span class="src-id"><a href="../Doctrine/Doctrine_Record.html">Doctrine_Record</a></span><span class="src-sym">::</span><span class="src-id">STATE_TCLEAN</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a60"></a> <span class="src-key">foreach </span><span class="src-sym">(</span><span class="src-var">$table</span><span class="src-sym">-></span><span class="src-id">getPrimaryKeys</span><span class="src-sym">(</span><span class="src-sym">) </span><span class="src-key">as </span><span class="src-var">$pk</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a61"></a> <span class="src-var">$sql </span>.= <span class="src-str">"</span><span class="src-str"> <span class="src-id">AND</span> {<span class="src-var">$pk</span><span class="src-sym">}</span> != ?</span><span class="src-str">"</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a62"></a> <span class="src-var">$values</span><span class="src-sym">[</span><span class="src-sym">] </span>= <span class="src-var">$record</span><span class="src-sym">-></span><span class="src-var">$pk</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a63"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a64"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a65"></a> </div></li>
<li><div class="src-line"><a name="a66"></a> <span class="src-var">$stmt </span>= <span class="src-var">$table</span><span class="src-sym">-></span><span class="src-id">getConnection</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">-></span><span class="src-id">getDbh</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">-></span><span class="src-id">prepare</span><span class="src-sym">(</span><span class="src-var">$sql</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a67"></a> <span class="src-var">$stmt</span><span class="src-sym">-></span><span class="src-id">execute</span><span class="src-sym">(</span><span class="src-var">$values</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a68"></a> </div></li>
<li><div class="src-line"><a name="a69"></a> <span class="src-key">return </span><span class="src-sym">( </span><span class="src-sym">! </span><a href="http://www.php.net/is_array">is_array</a><span class="src-sym">(</span><span class="src-var">$stmt</span><span class="src-sym">-></span><span class="src-id">fetch</span><span class="src-sym">(</span><span class="src-sym">)))</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a70"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a71"></a><span class="src-sym">}</span></div></li>
</ol>
</span></div>
</div>