<html><head><title>/home/phd/current/SQLObject/SQLObject/sqlobject/index.py</title> <script type="text/javascript"><!-- function show_line_range() { var href = document.location.href; if (href.indexOf('?') == -1) { return; } var qs = href.substring(href.indexOf('?')+1); if (qs.indexOf('#') >= 0) { qs = qs.substring(0, qs.indexOf('#')); } var first = qs.match(/f=(\d+)/)[1]; var last = qs.match(/l=(\d+)/)[1]; if (! first || ! last) { return; } var anchors = document.getElementsByTagName('A'); var container = document.createElement('DIV'); container.className = 'highlighted'; var children = []; var start = null; var parent = null; var highlight = false; for (var i = 0; i < anchors.length; i++) { var el = anchors[i]; if (el.getAttribute('name') == first) { start = el.previousSibling; parent = el.parentNode; highlight = true; } if (el.getAttribute('name') == last) { break; } if (highlight) { children[children.length] = el; el = el.nextSibling; while (el && el.tagName != 'A') { children[children.length] = el; el = el.nextSibling; } } } for (i=0; i<children.length; i++) { container.appendChild(children[i]); } if (start) { start.parentNode.insertBefore(container, start.nextSibling); } else { parent.insertBefore(container, parent.childNodes[0]); } } // --></script> <style> div.python { color: #333 } div.python a.lnum { color: #555; background-color: #eee; border-right: 1px solid #999; padding-right: 2px; margin-right: 4px; } div.python span.comment { color: #933 } div.python span.keyword { color: #a3e; font-weight: bold } div.python span.op { color: #c96 } div.python span.string { color: #6a6 } div.python span.name { } div.python span.text { color: #333 } div.highlighted { background-color: #ff9; border: 1px solid #009 } </style></head><body onload="show_line_range()"><div class="python"><code><a class="lnum" href="#1" name="1">0001</a><span class="keyword">from</span> <span class="name">itertools</span> <span class="keyword">import</span> <span class="name">count</span><br /> <a class="lnum" href="#2" name="2">0002</a><span class="keyword">from</span> <span class="name">types</span> <span class="keyword">import</span> <span class="op">*</span><br /> <a class="lnum" href="#3" name="3">0003</a><span class="keyword">from</span> <span class="name">converters</span> <span class="keyword">import</span> <span class="name">sqlrepr</span><br /> <a class="lnum" href="#4" name="4">0004</a><br /> <a class="lnum" href="#5" name="5">0005</a><span class="name">creationOrder</span> <span class="op">=</span> <span class="name">count</span><span class="op">(</span><span class="op">)</span><br /> <a class="lnum" href="#6" name="6">0006</a><br /> <a class="lnum" href="#7" name="7">0007</a><span class="keyword">class</span> <span class="name">SODatabaseIndex</span><span class="op">(</span><span class="name">object</span><span class="op">)</span><span class="op">:</span><br /> <a class="lnum" href="#8" name="8">0008</a><br /> <a class="lnum" href="#9" name="9">0009</a>    <span class="keyword">def</span> <span class="name">__init__</span><span class="op">(</span><span class="name">self</span><span class="op">,</span><br /> <a class="lnum" href="#10" name="10">0010</a>                 <span class="name">soClass</span><span class="op">,</span><br /> <a class="lnum" href="#11" name="11">0011</a>                 <span class="name">name</span><span class="op">,</span><br /> <a class="lnum" href="#12" name="12">0012</a>                 <span class="name">columns</span><span class="op">,</span><br /> <a class="lnum" href="#13" name="13">0013</a>                 <span class="name">creationOrder</span><span class="op">,</span><br /> <a class="lnum" href="#14" name="14">0014</a>                 <span class="name">unique</span><span class="op">=</span><span class="name">False</span><span class="op">)</span><span class="op">:</span><br /> <a class="lnum" href="#15" name="15">0015</a>        <span class="name">self</span><span class="op">.</span><span class="name">soClass</span> <span class="op">=</span> <span class="name">soClass</span><br /> <a class="lnum" href="#16" name="16">0016</a>        <span class="name">self</span><span class="op">.</span><span class="name">name</span> <span class="op">=</span> <span class="name">name</span><br /> <a class="lnum" href="#17" name="17">0017</a>        <span class="name">self</span><span class="op">.</span><span class="name">descriptions</span> <span class="op">=</span> <span class="name">self</span><span class="op">.</span><span class="name">convertColumns</span><span class="op">(</span><span class="name">columns</span><span class="op">)</span><br /> <a class="lnum" href="#18" name="18">0018</a>        <span class="name">self</span><span class="op">.</span><span class="name">creationOrder</span> <span class="op">=</span> <span class="name">creationOrder</span><br /> <a class="lnum" href="#19" name="19">0019</a>        <span class="name">self</span><span class="op">.</span><span class="name">unique</span> <span class="op">=</span> <span class="name">unique</span><br /> <a class="lnum" href="#20" name="20">0020</a><br /> <a class="lnum" href="#21" name="21">0021</a>    <span class="keyword">def</span> <span class="name">get</span><span class="op">(</span><span class="name">self</span><span class="op">,</span> <span class="op">*</span><span class="name">args</span><span class="op">,</span> <span class="op">**</span><span class="name">kw</span><span class="op">)</span><span class="op">:</span><br /> <a class="lnum" href="#22" name="22">0022</a>        <span class="keyword">if</span> <span class="keyword">not</span> <span class="name">self</span><span class="op">.</span><span class="name">unique</span><span class="op">:</span><br /> <a class="lnum" href="#23" name="23">0023</a>            <span class="keyword">raise</span> <span class="name">AttributeError</span><span class="op">,</span> <span class="op">(</span><br /> <a class="lnum" href="#24" name="24">0024</a>                <span class="string">"'%s' object has no attribute 'get' (index is not unique)"</span> <span class="op">%</span> <span class="name">self</span><span class="op">.</span><span class="name">name</span><span class="op">)</span><br /> <a class="lnum" href="#25" name="25">0025</a>        <span class="name">connection</span> <span class="op">=</span> <span class="name">kw</span><span class="op">.</span><span class="name">pop</span><span class="op">(</span><span class="string">'connection'</span><span class="op">,</span> <span class="name">None</span><span class="op">)</span><br /> <a class="lnum" href="#26" name="26">0026</a>        <span class="keyword">if</span> <span class="name">args</span> <span class="keyword">and</span> <span class="name">kw</span><span class="op">:</span><br /> <a class="lnum" href="#27" name="27">0027</a>            <span class="keyword">raise</span> <span class="name">TypeError</span><span class="op">,</span> <span class="string">"You cannot mix named and unnamed arguments"</span><br /> <a class="lnum" href="#28" name="28">0028</a>        <span class="name">columns</span> <span class="op">=</span> <span class="op">[</span><span class="name">d</span><span class="op">[</span><span class="string">'column'</span><span class="op">]</span> <span class="keyword">for</span> <span class="name">d</span> <span class="keyword">in</span> <span class="name">self</span><span class="op">.</span><span class="name">descriptions</span><br /> <a class="lnum" href="#29" name="29">0029</a>            <span class="keyword">if</span> <span class="string">'column'</span> <span class="keyword">in</span> <span class="name">d</span><span class="op">]</span><br /> <a class="lnum" href="#30" name="30">0030</a>        <span class="keyword">if</span> <span class="name">kw</span> <span class="keyword">and</span> <span class="name">len</span><span class="op">(</span><span class="name">kw</span><span class="op">)</span> <span class="op">!=</span> <span class="name">len</span><span class="op">(</span><span class="name">columns</span><span class="op">)</span> <span class="keyword">or</span> <span class="name">args</span> <span class="keyword">and</span> <span class="name">len</span><span class="op">(</span><span class="name">args</span><span class="op">)</span> <span class="op">!=</span> <span class="name">len</span><span class="op">(</span><span class="name">columns</span><span class="op">)</span><span class="op">:</span><br /> <a class="lnum" href="#31" name="31">0031</a>            <span class="keyword">raise</span> <span class="name">TypeError</span><span class="op">,</span> <span class="op">(</span><span class="string">"get() takes exactly %d argument and an optional "</span><br /> <a class="lnum" href="#32" name="32">0032</a>                <span class="string">"named argument 'connection' (%d given)"</span> <span class="op">%</span> <span class="op">(</span><br /> <a class="lnum" href="#33" name="33">0033</a>                <span class="name">len</span><span class="op">(</span><span class="name">columns</span><span class="op">)</span><span class="op">,</span> <span class="name">len</span><span class="op">(</span><span class="name">args</span><span class="op">)</span><span class="op">+</span><span class="name">len</span><span class="op">(</span><span class="name">kw</span><span class="op">)</span><span class="op">)</span><span class="op">)</span><br /> <a class="lnum" href="#34" name="34">0034</a>        <span class="keyword">if</span> <span class="name">args</span><span class="op">:</span><br /> <a class="lnum" href="#35" name="35">0035</a>            <span class="name">kw</span> <span class="op">=</span> <span class="op">{</span><span class="op">}</span><br /> <a class="lnum" href="#36" name="36">0036</a>            <span class="keyword">for</span> <span class="name">i</span> <span class="keyword">in</span> <span class="name">range</span><span class="op">(</span><span class="name">len</span><span class="op">(</span><span class="name">args</span><span class="op">)</span><span class="op">)</span><span class="op">:</span><br /> <a class="lnum" href="#37" name="37">0037</a>                <span class="keyword">if</span> <span class="name">columns</span><span class="op">[</span><span class="name">i</span><span class="op">]</span><span class="op">.</span><span class="name">foreignName</span> <span class="keyword">is</span> <span class="keyword">not</span> <span class="name">None</span><span class="op">:</span><br /> <a class="lnum" href="#38" name="38">0038</a>                    <span class="name">kw</span><span class="op">[</span><span class="name">columns</span><span class="op">[</span><span class="name">i</span><span class="op">]</span><span class="op">.</span><span class="name">foreignName</span><span class="op">]</span> <span class="op">=</span> <span class="name">args</span><span class="op">[</span><span class="name">i</span><span class="op">]</span><br /> <a class="lnum" href="#39" name="39">0039</a>                <span class="keyword">else</span><span class="op">:</span><br /> <a class="lnum" href="#40" name="40">0040</a>                    <span class="name">kw</span><span class="op">[</span><span class="name">columns</span><span class="op">[</span><span class="name">i</span><span class="op">]</span><span class="op">.</span><span class="name">name</span><span class="op">]</span> <span class="op">=</span> <span class="name">args</span><span class="op">[</span><span class="name">i</span><span class="op">]</span><br /> <a class="lnum" href="#41" name="41">0041</a>        <span class="keyword">return</span> <span class="name">self</span><span class="op">.</span><span class="name">soClass</span><span class="op">.</span><span class="name">selectBy</span><span class="op">(</span><span class="name">connection</span><span class="op">=</span><span class="name">connection</span><span class="op">,</span> <span class="op">**</span><span class="name">kw</span><span class="op">)</span><span class="op">.</span><span class="name">getOne</span><span class="op">(</span><span class="op">)</span><br /> <a class="lnum" href="#42" name="42">0042</a><br /> <a class="lnum" href="#43" name="43">0043</a>    <span class="keyword">def</span> <span class="name">convertColumns</span><span class="op">(</span><span class="name">self</span><span class="op">,</span> <span class="name">columns</span><span class="op">)</span><span class="op">:</span><br /> <a class="lnum" href="#44" name="44">0044</a>        <span class="string">"""</span><br /> <a class="lnum" href="#45" name="45">0045</a><span class="string">        Converts all the columns to dictionary descriptors;</span><br /> <a class="lnum" href="#46" name="46">0046</a><span class="string">        dereferences string column names.</span><br /> <a class="lnum" href="#47" name="47">0047</a><span class="string">        """</span><br /> <a class="lnum" href="#48" name="48">0048</a>        <span class="name">new</span> <span class="op">=</span> <span class="op">[</span><span class="op">]</span><br /> <a class="lnum" href="#49" name="49">0049</a>        <span class="keyword">for</span> <span class="name">desc</span> <span class="keyword">in</span> <span class="name">columns</span><span class="op">:</span><br /> <a class="lnum" href="#50" name="50">0050</a>            <span class="keyword">if</span> <span class="keyword">not</span> <span class="name">isinstance</span><span class="op">(</span><span class="name">desc</span><span class="op">,</span> <span class="name">dict</span><span class="op">)</span><span class="op">:</span><br /> <a class="lnum" href="#51" name="51">0051</a>                <span class="name">desc</span> <span class="op">=</span> <span class="op">{</span><span class="string">'column'</span><span class="op">:</span> <span class="name">desc</span><span class="op">}</span><br /> <a class="lnum" href="#52" name="52">0052</a>            <span class="keyword">if</span> <span class="string">'expression'</span> <span class="keyword">in</span> <span class="name">desc</span><span class="op">:</span><br /> <a class="lnum" href="#53" name="53">0053</a>                <span class="keyword">assert</span> <span class="string">'column'</span> <span class="keyword">not</span> <span class="keyword">in</span> <span class="name">desc</span><span class="op">,</span> <span class="op">(</span><br /> <a class="lnum" href="#54" name="54">0054</a>                    <span class="string">'You cannot provide both an expression and a column '</span><br /> <a class="lnum" href="#55" name="55">0055</a>                    <span class="string">'(for %s in index %s in %s)'</span> <span class="op">%</span><br /> <a class="lnum" href="#56" name="56">0056</a>                    <span class="op">(</span><span class="name">desc</span><span class="op">,</span> <span class="name">self</span><span class="op">.</span><span class="name">name</span><span class="op">,</span> <span class="name">self</span><span class="op">.</span><span class="name">soClass</span><span class="op">)</span><span class="op">)</span><br /> <a class="lnum" href="#57" name="57">0057</a>                <span class="keyword">assert</span> <span class="string">'length'</span> <span class="keyword">not</span> <span class="keyword">in</span> <span class="name">desc</span><span class="op">,</span> <span class="op">(</span><br /> <a class="lnum" href="#58" name="58">0058</a>                    <span class="string">'length does not apply to expressions (for %s in '</span><br /> <a class="lnum" href="#59" name="59">0059</a>                    <span class="string">'index %s in %s)'</span> <span class="op">%</span><br /> <a class="lnum" href="#60" name="60">0060</a>                    <span class="op">(</span><span class="name">desc</span><span class="op">,</span> <span class="name">self</span><span class="op">.</span><span class="name">name</span><span class="op">,</span> <span class="name">self</span><span class="op">.</span><span class="name">soClass</span><span class="op">)</span><span class="op">)</span><br /> <a class="lnum" href="#61" name="61">0061</a>                <span class="name">new</span><span class="op">.</span><span class="name">append</span><span class="op">(</span><span class="name">desc</span><span class="op">)</span><br /> <a class="lnum" href="#62" name="62">0062</a>                <span class="keyword">continue</span><br /> <a class="lnum" href="#63" name="63">0063</a>            <span class="name">columnName</span> <span class="op">=</span> <span class="name">desc</span><span class="op">[</span><span class="string">'column'</span><span class="op">]</span><br /> <a class="lnum" href="#64" name="64">0064</a>            <span class="keyword">if</span> <span class="keyword">not</span> <span class="name">isinstance</span><span class="op">(</span><span class="name">columnName</span><span class="op">,</span> <span class="name">str</span><span class="op">)</span><span class="op">:</span><br /> <a class="lnum" href="#65" name="65">0065</a>                <span class="name">columnName</span> <span class="op">=</span> <span class="name">columnName</span><span class="op">.</span><span class="name">name</span><br /> <a class="lnum" href="#66" name="66">0066</a>            <span class="name">colDict</span> <span class="op">=</span> <span class="name">self</span><span class="op">.</span><span class="name">soClass</span><span class="op">.</span><span class="name">sqlmeta</span><span class="op">.</span><span class="name">columns</span><br /> <a class="lnum" href="#67" name="67">0067</a>            <span class="keyword">if</span> <span class="name">columnName</span> <span class="keyword">not</span> <span class="keyword">in</span> <span class="name">colDict</span><span class="op">:</span><br /> <a class="lnum" href="#68" name="68">0068</a>                <span class="keyword">for</span> <span class="name">possible</span> <span class="keyword">in</span> <span class="name">colDict</span><span class="op">.</span><span class="name">values</span><span class="op">(</span><span class="op">)</span><span class="op">:</span><br /> <a class="lnum" href="#69" name="69">0069</a>                    <span class="keyword">if</span> <span class="name">possible</span><span class="op">.</span><span class="name">origName</span> <span class="op">==</span> <span class="name">columnName</span><span class="op">:</span><br /> <a class="lnum" href="#70" name="70">0070</a>                        <span class="name">column</span> <span class="op">=</span> <span class="name">possible</span><br /> <a class="lnum" href="#71" name="71">0071</a>                        <span class="keyword">break</span><br /> <a class="lnum" href="#72" name="72">0072</a>                <span class="keyword">else</span><span class="op">:</span><br /> <a class="lnum" href="#73" name="73">0073</a>                    <span class="comment"># None found</span><br /> <a class="lnum" href="#74" name="74">0074</a>                    <span class="keyword">raise</span> <span class="name">ValueError</span><span class="op">,</span> <span class="string">"The column by the name %r was not found in the class %r"</span> <span class="op">%</span> <span class="op">(</span><span class="name">columnName</span><span class="op">,</span> <span class="name">self</span><span class="op">.</span><span class="name">soClass</span><span class="op">)</span><br /> <a class="lnum" href="#75" name="75">0075</a>            <span class="keyword">else</span><span class="op">:</span><br /> <a class="lnum" href="#76" name="76">0076</a>                <span class="name">column</span> <span class="op">=</span> <span class="name">colDict</span><span class="op">[</span><span class="name">columnName</span><span class="op">]</span><br /> <a class="lnum" href="#77" name="77">0077</a>            <span class="name">desc</span><span class="op">[</span><span class="string">'column'</span><span class="op">]</span> <span class="op">=</span> <span class="name">column</span><br /> <a class="lnum" href="#78" name="78">0078</a>            <span class="name">new</span><span class="op">.</span><span class="name">append</span><span class="op">(</span><span class="name">desc</span><span class="op">)</span><br /> <a class="lnum" href="#79" name="79">0079</a>        <span class="keyword">return</span> <span class="name">new</span><br /> <a class="lnum" href="#80" name="80">0080</a><br /> <a class="lnum" href="#81" name="81">0081</a>    <span class="keyword">def</span> <span class="name">getExpression</span><span class="op">(</span><span class="name">self</span><span class="op">,</span> <span class="name">desc</span><span class="op">,</span> <span class="name">db</span><span class="op">)</span><span class="op">:</span><br /> <a class="lnum" href="#82" name="82">0082</a>        <span class="keyword">if</span> <span class="name">isinstance</span><span class="op">(</span><span class="name">desc</span><span class="op">[</span><span class="string">'expression'</span><span class="op">]</span><span class="op">,</span> <span class="name">str</span><span class="op">)</span><span class="op">:</span><br /> <a class="lnum" href="#83" name="83">0083</a>            <span class="keyword">return</span> <span class="name">desc</span><span class="op">[</span><span class="string">'expression'</span><span class="op">]</span><br /> <a class="lnum" href="#84" name="84">0084</a>        <span class="keyword">else</span><span class="op">:</span><br /> <a class="lnum" href="#85" name="85">0085</a>            <span class="keyword">return</span> <span class="name">sqlrepr</span><span class="op">(</span><span class="name">desc</span><span class="op">[</span><span class="string">'expression'</span><span class="op">]</span><span class="op">,</span> <span class="name">db</span><span class="op">)</span><br /> <a class="lnum" href="#86" name="86">0086</a><br /> <a class="lnum" href="#87" name="87">0087</a>    <span class="keyword">def</span> <span class="name">sqliteCreateIndexSQL</span><span class="op">(</span><span class="name">self</span><span class="op">,</span> <span class="name">soClass</span><span class="op">)</span><span class="op">:</span><br /> <a class="lnum" href="#88" name="88">0088</a>        <span class="keyword">if</span> <span class="name">self</span><span class="op">.</span><span class="name">unique</span><span class="op">:</span><br /> <a class="lnum" href="#89" name="89">0089</a>            <span class="name">uniqueOrIndex</span> <span class="op">=</span> <span class="string">'UNIQUE INDEX'</span><br /> <a class="lnum" href="#90" name="90">0090</a>        <span class="keyword">else</span><span class="op">:</span><br /> <a class="lnum" href="#91" name="91">0091</a>            <span class="name">uniqueOrIndex</span> <span class="op">=</span> <span class="string">'INDEX'</span><br /> <a class="lnum" href="#92" name="92">0092</a>        <span class="name">spec</span> <span class="op">=</span> <span class="op">[</span><span class="op">]</span><br /> <a class="lnum" href="#93" name="93">0093</a>        <span class="keyword">for</span> <span class="name">desc</span> <span class="keyword">in</span> <span class="name">self</span><span class="op">.</span><span class="name">descriptions</span><span class="op">:</span><br /> <a class="lnum" href="#94" name="94">0094</a>            <span class="keyword">if</span> <span class="string">'expression'</span> <span class="keyword">in</span> <span class="name">desc</span><span class="op">:</span><br /> <a class="lnum" href="#95" name="95">0095</a>                <span class="name">spec</span><span class="op">.</span><span class="name">append</span><span class="op">(</span><span class="name">self</span><span class="op">.</span><span class="name">getExpression</span><span class="op">(</span><span class="name">desc</span><span class="op">,</span> <span class="string">'sqlite'</span><span class="op">)</span><span class="op">)</span><br /> <a class="lnum" href="#96" name="96">0096</a>            <span class="keyword">else</span><span class="op">:</span><br /> <a class="lnum" href="#97" name="97">0097</a>                <span class="name">spec</span><span class="op">.</span><span class="name">append</span><span class="op">(</span><span class="name">desc</span><span class="op">[</span><span class="string">'column'</span><span class="op">]</span><span class="op">.</span><span class="name">dbName</span><span class="op">)</span><br /> <a class="lnum" href="#98" name="98">0098</a>        <span class="name">ret</span> <span class="op">=</span> <span class="string">'CREATE %s %s_%s ON %s (%s)'</span> <span class="op">%</span>                 <span class="op">(</span><span class="name">uniqueOrIndex</span><span class="op">,</span><br /> <a class="lnum" href="#100" name="100">0100</a>               <span class="name">self</span><span class="op">.</span><span class="name">soClass</span><span class="op">.</span><span class="name">sqlmeta</span><span class="op">.</span><span class="name">table</span><span class="op">,</span><br /> <a class="lnum" href="#101" name="101">0101</a>               <span class="name">self</span><span class="op">.</span><span class="name">name</span><span class="op">,</span><br /> <a class="lnum" href="#102" name="102">0102</a>               <span class="name">self</span><span class="op">.</span><span class="name">soClass</span><span class="op">.</span><span class="name">sqlmeta</span><span class="op">.</span><span class="name">table</span><span class="op">,</span><br /> <a class="lnum" href="#103" name="103">0103</a>               <span class="string">', '</span><span class="op">.</span><span class="name">join</span><span class="op">(</span><span class="name">spec</span><span class="op">)</span><span class="op">)</span><br /> <a class="lnum" href="#104" name="104">0104</a>        <span class="keyword">return</span> <span class="name">ret</span><br /> <a class="lnum" href="#105" name="105">0105</a><br /> <a class="lnum" href="#106" name="106">0106</a>    <span class="name">postgresCreateIndexSQL</span> <span class="op">=</span> <span class="name">maxdbCreateIndexSQL</span> <span class="op">=</span> <span class="name">mssqlCreateIndexSQL</span> <span class="op">=</span> <span class="name">sybaseCreateIndexSQL</span> <span class="op">=</span> <span class="name">firebirdCreateIndexSQL</span> <span class="op">=</span> <span class="name">sqliteCreateIndexSQL</span><br /> <a class="lnum" href="#107" name="107">0107</a>    <span class="keyword">def</span> <span class="name">mysqlCreateIndexSQL</span><span class="op">(</span><span class="name">self</span><span class="op">,</span> <span class="name">soClass</span><span class="op">)</span><span class="op">:</span><br /> <a class="lnum" href="#108" name="108">0108</a>        <span class="keyword">if</span> <span class="name">self</span><span class="op">.</span><span class="name">unique</span><span class="op">:</span><br /> <a class="lnum" href="#109" name="109">0109</a>            <span class="name">uniqueOrIndex</span> <span class="op">=</span> <span class="string">'UNIQUE'</span><br /> <a class="lnum" href="#110" name="110">0110</a>        <span class="keyword">else</span><span class="op">:</span><br /> <a class="lnum" href="#111" name="111">0111</a>            <span class="name">uniqueOrIndex</span> <span class="op">=</span> <span class="string">'INDEX'</span><br /> <a class="lnum" href="#112" name="112">0112</a>        <span class="name">spec</span> <span class="op">=</span> <span class="op">[</span><span class="op">]</span><br /> <a class="lnum" href="#113" name="113">0113</a>        <span class="keyword">for</span> <span class="name">desc</span> <span class="keyword">in</span> <span class="name">self</span><span class="op">.</span><span class="name">descriptions</span><span class="op">:</span><br /> <a class="lnum" href="#114" name="114">0114</a>            <span class="keyword">if</span> <span class="string">'expression'</span> <span class="keyword">in</span> <span class="name">desc</span><span class="op">:</span><br /> <a class="lnum" href="#115" name="115">0115</a>                <span class="name">spec</span><span class="op">.</span><span class="name">append</span><span class="op">(</span><span class="name">self</span><span class="op">.</span><span class="name">getExpression</span><span class="op">(</span><span class="name">desc</span><span class="op">,</span> <span class="string">'mysql'</span><span class="op">)</span><span class="op">)</span><br /> <a class="lnum" href="#116" name="116">0116</a>            <span class="keyword">elif</span> <span class="string">'length'</span> <span class="keyword">in</span> <span class="name">desc</span><span class="op">:</span><br /> <a class="lnum" href="#117" name="117">0117</a>                <span class="name">spec</span><span class="op">.</span><span class="name">append</span><span class="op">(</span><span class="string">'%s(%d)'</span> <span class="op">%</span> <span class="op">(</span><span class="name">desc</span><span class="op">[</span><span class="string">'column'</span><span class="op">]</span><span class="op">.</span><span class="name">dbName</span><span class="op">,</span> <span class="name">desc</span><span class="op">[</span><span class="string">'length'</span><span class="op">]</span><span class="op">)</span><span class="op">)</span><br /> <a class="lnum" href="#118" name="118">0118</a>            <span class="keyword">else</span><span class="op">:</span><br /> <a class="lnum" href="#119" name="119">0119</a>                <span class="name">spec</span><span class="op">.</span><span class="name">append</span><span class="op">(</span><span class="name">desc</span><span class="op">[</span><span class="string">'column'</span><span class="op">]</span><span class="op">.</span><span class="name">dbName</span><span class="op">)</span><br /> <a class="lnum" href="#120" name="120">0120</a><br /> <a class="lnum" href="#121" name="121">0121</a>        <span class="keyword">return</span> <span class="string">'ALTER TABLE %s ADD %s %s (%s)'</span> <span class="op">%</span>                  <span class="op">(</span><span class="name">soClass</span><span class="op">.</span><span class="name">sqlmeta</span><span class="op">.</span><span class="name">table</span><span class="op">,</span> <span class="name">uniqueOrIndex</span><span class="op">,</span><br /> <a class="lnum" href="#123" name="123">0123</a>                <span class="name">self</span><span class="op">.</span><span class="name">name</span><span class="op">,</span><br /> <a class="lnum" href="#124" name="124">0124</a>                <span class="string">', '</span><span class="op">.</span><span class="name">join</span><span class="op">(</span><span class="name">spec</span><span class="op">)</span><span class="op">)</span><br /> <a class="lnum" href="#125" name="125">0125</a><br /> <a class="lnum" href="#126" name="126">0126</a><br /> <a class="lnum" href="#127" name="127">0127</a><span class="keyword">class</span> <span class="name">DatabaseIndex</span><span class="op">(</span><span class="name">object</span><span class="op">)</span><span class="op">:</span><br /> <a class="lnum" href="#128" name="128">0128</a>    <span class="string">"""</span><br /> <a class="lnum" href="#129" name="129">0129</a><span class="string">    This takes a variable number of parameters, each of which is a</span><br /> <a class="lnum" href="#130" name="130">0130</a><span class="string">    column for indexing.  Each column may be a column object or the</span><br /> <a class="lnum" href="#131" name="131">0131</a><span class="string">    string name of the column (*not* the database name).  You may also</span><br /> <a class="lnum" href="#132" name="132">0132</a><span class="string">    use dictionaries, to further customize the indexing of the column.</span><br /> <a class="lnum" href="#133" name="133">0133</a><span class="string">    The dictionary may have certain keys:</span><br /> <a class="lnum" href="#134" name="134">0134</a><span class="string"></span><br /> <a class="lnum" href="#135" name="135">0135</a><span class="string">    'column':</span><br /> <a class="lnum" href="#136" name="136">0136</a><span class="string">        The column object or string identifier.</span><br /> <a class="lnum" href="#137" name="137">0137</a><span class="string">    'length':</span><br /> <a class="lnum" href="#138" name="138">0138</a><span class="string">        MySQL will only index the first N characters if this is</span><br /> <a class="lnum" href="#139" name="139">0139</a><span class="string">        given.  For other databases this is ignored.</span><br /> <a class="lnum" href="#140" name="140">0140</a><span class="string">    'expression':</span><br /> <a class="lnum" href="#141" name="141">0141</a><span class="string">        You can create an index based on an expression, e.g.,</span><br /> <a class="lnum" href="#142" name="142">0142</a><span class="string">        'lower(column)'.  This can either be a string or a sqlbuilder</span><br /> <a class="lnum" href="#143" name="143">0143</a><span class="string">        expression.</span><br /> <a class="lnum" href="#144" name="144">0144</a><span class="string"></span><br /> <a class="lnum" href="#145" name="145">0145</a><span class="string">    Further keys may be added to the column specs in the future.</span><br /> <a class="lnum" href="#146" name="146">0146</a><span class="string"></span><br /> <a class="lnum" href="#147" name="147">0147</a><span class="string">    The class also take the keyword argument `unique`; if true then</span><br /> <a class="lnum" href="#148" name="148">0148</a><span class="string">    a UNIQUE index is created.</span><br /> <a class="lnum" href="#149" name="149">0149</a><span class="string">    """</span><br /> <a class="lnum" href="#150" name="150">0150</a><br /> <a class="lnum" href="#151" name="151">0151</a>    <span class="name">baseClass</span> <span class="op">=</span> <span class="name">SODatabaseIndex</span><br /> <a class="lnum" href="#152" name="152">0152</a><br /> <a class="lnum" href="#153" name="153">0153</a>    <span class="keyword">def</span> <span class="name">__init__</span><span class="op">(</span><span class="name">self</span><span class="op">,</span> <span class="op">*</span><span class="name">columns</span><span class="op">,</span> <span class="op">**</span><span class="name">kw</span><span class="op">)</span><span class="op">:</span><br /> <a class="lnum" href="#154" name="154">0154</a>        <span class="name">kw</span><span class="op">[</span><span class="string">'columns'</span><span class="op">]</span> <span class="op">=</span> <span class="name">columns</span><br /> <a class="lnum" href="#155" name="155">0155</a>        <span class="name">self</span><span class="op">.</span><span class="name">kw</span> <span class="op">=</span> <span class="name">kw</span><br /> <a class="lnum" href="#156" name="156">0156</a>        <span class="name">self</span><span class="op">.</span><span class="name">creationOrder</span> <span class="op">=</span> <span class="name">creationOrder</span><span class="op">.</span><span class="name">next</span><span class="op">(</span><span class="op">)</span><br /> <a class="lnum" href="#157" name="157">0157</a><br /> <a class="lnum" href="#158" name="158">0158</a>    <span class="keyword">def</span> <span class="name">setName</span><span class="op">(</span><span class="name">self</span><span class="op">,</span> <span class="name">value</span><span class="op">)</span><span class="op">:</span><br /> <a class="lnum" href="#159" name="159">0159</a>        <span class="keyword">assert</span> <span class="name">self</span><span class="op">.</span><span class="name">kw</span><span class="op">.</span><span class="name">get</span><span class="op">(</span><span class="string">'name'</span><span class="op">)</span> <span class="keyword">is</span> <span class="name">None</span><span class="op">,</span> <span class="string">"You cannot change a name after it has already been set (from %s to %s)"</span> <span class="op">%</span> <span class="op">(</span><span class="name">self</span><span class="op">.</span><span class="name">kw</span><span class="op">[</span><span class="string">'name'</span><span class="op">]</span><span class="op">,</span> <span class="name">value</span><span class="op">)</span><br /> <a class="lnum" href="#160" name="160">0160</a>        <span class="name">self</span><span class="op">.</span><span class="name">kw</span><span class="op">[</span><span class="string">'name'</span><span class="op">]</span> <span class="op">=</span> <span class="name">value</span><br /> <a class="lnum" href="#161" name="161">0161</a><br /> <a class="lnum" href="#162" name="162">0162</a>    <span class="keyword">def</span> <span class="name">_get_name</span><span class="op">(</span><span class="name">self</span><span class="op">)</span><span class="op">:</span><br /> <a class="lnum" href="#163" name="163">0163</a>        <span class="keyword">return</span> <span class="name">self</span><span class="op">.</span><span class="name">kw</span><span class="op">[</span><span class="string">'name'</span><span class="op">]</span><br /> <a class="lnum" href="#164" name="164">0164</a><br /> <a class="lnum" href="#165" name="165">0165</a>    <span class="keyword">def</span> <span class="name">_set_name</span><span class="op">(</span><span class="name">self</span><span class="op">,</span> <span class="name">value</span><span class="op">)</span><span class="op">:</span><br /> <a class="lnum" href="#166" name="166">0166</a>        <span class="name">self</span><span class="op">.</span><span class="name">setName</span><span class="op">(</span><span class="name">value</span><span class="op">)</span><br /> <a class="lnum" href="#167" name="167">0167</a><br /> <a class="lnum" href="#168" name="168">0168</a>    <span class="name">name</span> <span class="op">=</span> <span class="name">property</span><span class="op">(</span><span class="name">_get_name</span><span class="op">,</span> <span class="name">_set_name</span><span class="op">)</span><br /> <a class="lnum" href="#169" name="169">0169</a><br /> <a class="lnum" href="#170" name="170">0170</a>    <span class="keyword">def</span> <span class="name">withClass</span><span class="op">(</span><span class="name">self</span><span class="op">,</span> <span class="name">soClass</span><span class="op">)</span><span class="op">:</span><br /> <a class="lnum" href="#171" name="171">0171</a>        <span class="keyword">return</span> <span class="name">self</span><span class="op">.</span><span class="name">baseClass</span><span class="op">(</span><span class="name">soClass</span><span class="op">=</span><span class="name">soClass</span><span class="op">,</span><br /> <a class="lnum" href="#172" name="172">0172</a>            <span class="name">creationOrder</span><span class="op">=</span><span class="name">self</span><span class="op">.</span><span class="name">creationOrder</span><span class="op">,</span> <span class="op">**</span><span class="name">self</span><span class="op">.</span><span class="name">kw</span><span class="op">)</span><br /> <a class="lnum" href="#173" name="173">0173</a><br /> <a class="lnum" href="#174" name="174">0174</a>    <span class="keyword">def</span> <span class="name">__repr__</span><span class="op">(</span><span class="name">self</span><span class="op">)</span><span class="op">:</span><br /> <a class="lnum" href="#175" name="175">0175</a>        <span class="keyword">return</span> <span class="string">'<%s %s %s>'</span> <span class="op">%</span> <span class="op">(</span><br /> <a class="lnum" href="#176" name="176">0176</a>            <span class="name">self</span><span class="op">.</span><span class="name">__class__</span><span class="op">.</span><span class="name">__name__</span><span class="op">,</span><br /> <a class="lnum" href="#177" name="177">0177</a>            <span class="name">hex</span><span class="op">(</span><span class="name">abs</span><span class="op">(</span><span class="name">id</span><span class="op">(</span><span class="name">self</span><span class="op">)</span><span class="op">)</span><span class="op">)</span><span class="op">[</span><span class="number">2</span><span class="op">:</span><span class="op">]</span><span class="op">,</span><br /> <a class="lnum" href="#178" name="178">0178</a>            <span class="name">self</span><span class="op">.</span><span class="name">kw</span><span class="op">)</span><br /> <a class="lnum" href="#179" name="179">0179</a><br /> <a class="lnum" href="#180" name="180">0180</a><span class="name">__all__</span> <span class="op">=</span> <span class="op">[</span><span class="string">'DatabaseIndex'</span><span class="op">]</span></code></div></body></html>