Sophie

Sophie

distrib > Mageia > 7 > armv7hl > media > core-release > by-pkgid > f1af5ac4c8d0f3f6ef0bca84cf516f3e > files > 728

python3-sqlobject-3.7.0-1.mga7.noarch.rpm



<!doctype html>

<html xmlns="http://www.w3.org/1999/xhtml" lang="en">
  <head>
    <meta http-equiv="X-UA-Compatible" content="IE=Edge" />
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>sqlobject.tests.test_ForeignKey &#8212; SQLObject 3.7.0 documentation</title>
    <link rel="stylesheet" href="../../../_static/bizstyle.css" type="text/css" />
    <link rel="stylesheet" href="../../../_static/pygments.css" type="text/css" />
    <script type="text/javascript" src="../../../_static/documentation_options.js"></script>
    <script type="text/javascript" src="../../../_static/jquery.js"></script>
    <script type="text/javascript" src="../../../_static/underscore.js"></script>
    <script type="text/javascript" src="../../../_static/doctools.js"></script>
    <script type="text/javascript" src="../../../_static/bizstyle.js"></script>
    <link rel="index" title="Index" href="../../../genindex.html" />
    <link rel="search" title="Search" href="../../../search.html" />
    <meta name="viewport" content="width=device-width,initial-scale=1.0">
    <!--[if lt IE 9]>
    <script type="text/javascript" src="_static/css3-mediaqueries.js"></script>
    <![endif]-->
  </head><body>
    <div class="related" role="navigation" aria-label="related navigation">
      <h3>Navigation</h3>
      <ul>
        <li class="right" style="margin-right: 10px">
          <a href="../../../genindex.html" title="General Index"
             accesskey="I">index</a></li>
        <li class="right" >
          <a href="../../../py-modindex.html" title="Python Module Index"
             >modules</a> |</li>
        <li class="nav-item nav-item-0"><a href="../../../index.html">SQLObject 3.7.0 documentation</a> &#187;</li>
          <li class="nav-item nav-item-1"><a href="../../index.html" accesskey="U">Module code</a> &#187;</li> 
      </ul>
    </div>
      <div class="sphinxsidebar" role="navigation" aria-label="main navigation">
        <div class="sphinxsidebarwrapper">
<div id="searchbox" style="display: none" role="search">
  <h3>Quick search</h3>
    <div class="searchformwrapper">
    <form class="search" action="../../../search.html" method="get">
      <input type="text" name="q" />
      <input type="submit" value="Go" />
      <input type="hidden" name="check_keywords" value="yes" />
      <input type="hidden" name="area" value="default" />
    </form>
    </div>
</div>
<script type="text/javascript">$('#searchbox').show(0);</script>
        </div>
      </div>

    <div class="document">
      <div class="documentwrapper">
        <div class="bodywrapper">
          <div class="body" role="main">
            
  <h1>Source code for sqlobject.tests.test_ForeignKey</h1><div class="highlight"><pre>
<span></span><span class="kn">from</span> <span class="nn">formencode</span> <span class="k">import</span> <span class="n">validators</span>
<span class="kn">from</span> <span class="nn">sqlobject</span> <span class="k">import</span> <span class="n">ForeignKey</span><span class="p">,</span> <span class="n">IntCol</span><span class="p">,</span> <span class="n">SQLObject</span><span class="p">,</span> <span class="n">StringCol</span>
<span class="kn">from</span> <span class="nn">sqlobject.tests.dbtest</span> <span class="k">import</span> <span class="n">getConnection</span><span class="p">,</span> <span class="n">InstalledTestDatabase</span><span class="p">,</span> \
    <span class="n">raises</span><span class="p">,</span> <span class="n">setupClass</span><span class="p">,</span> <span class="n">setupCyclicClasses</span>


<div class="viewcode-block" id="SOTestComposerKey"><a class="viewcode-back" href="../../../api/sqlobject.tests.test_ForeignKey.html#sqlobject.tests.test_ForeignKey.SOTestComposerKey">[docs]</a><span class="k">class</span> <span class="nc">SOTestComposerKey</span><span class="p">(</span><span class="n">SQLObject</span><span class="p">):</span>
    <span class="n">name</span> <span class="o">=</span> <span class="n">StringCol</span><span class="p">()</span>
    <span class="n">id2</span> <span class="o">=</span> <span class="n">IntCol</span><span class="p">(</span><span class="n">default</span><span class="o">=</span><span class="kc">None</span><span class="p">,</span> <span class="n">unique</span><span class="o">=</span><span class="kc">True</span><span class="p">)</span>
</div>

<div class="viewcode-block" id="SOTestWorkKey"><a class="viewcode-back" href="../../../api/sqlobject.tests.test_ForeignKey.html#sqlobject.tests.test_ForeignKey.SOTestWorkKey">[docs]</a><span class="k">class</span> <span class="nc">SOTestWorkKey</span><span class="p">(</span><span class="n">SQLObject</span><span class="p">):</span>
    <span class="k">class</span> <span class="nc">sqlmeta</span><span class="p">:</span>
        <span class="n">idName</span> <span class="o">=</span> <span class="s2">&quot;work_id&quot;</span>

    <span class="n">composer</span> <span class="o">=</span> <span class="n">ForeignKey</span><span class="p">(</span><span class="s1">&#39;SOTestComposerKey&#39;</span><span class="p">,</span> <span class="n">cascade</span><span class="o">=</span><span class="kc">True</span><span class="p">)</span>
    <span class="n">title</span> <span class="o">=</span> <span class="n">StringCol</span><span class="p">()</span>
</div>

<div class="viewcode-block" id="SOTestWorkKey2"><a class="viewcode-back" href="../../../api/sqlobject.tests.test_ForeignKey.html#sqlobject.tests.test_ForeignKey.SOTestWorkKey2">[docs]</a><span class="k">class</span> <span class="nc">SOTestWorkKey2</span><span class="p">(</span><span class="n">SQLObject</span><span class="p">):</span>
    <span class="n">title</span> <span class="o">=</span> <span class="n">StringCol</span><span class="p">()</span>
</div>

<div class="viewcode-block" id="SOTestOtherColumn"><a class="viewcode-back" href="../../../api/sqlobject.tests.test_ForeignKey.html#sqlobject.tests.test_ForeignKey.SOTestOtherColumn">[docs]</a><span class="k">class</span> <span class="nc">SOTestOtherColumn</span><span class="p">(</span><span class="n">SQLObject</span><span class="p">):</span>
    <span class="n">key1</span> <span class="o">=</span> <span class="n">ForeignKey</span><span class="p">(</span><span class="s1">&#39;SOTestComposerKey&#39;</span><span class="p">,</span> <span class="n">default</span><span class="o">=</span><span class="kc">None</span><span class="p">)</span>
    <span class="n">key2</span> <span class="o">=</span> <span class="n">ForeignKey</span><span class="p">(</span><span class="s1">&#39;SOTestComposerKey&#39;</span><span class="p">,</span> <span class="n">refColumn</span><span class="o">=</span><span class="s1">&#39;id2&#39;</span><span class="p">,</span> <span class="n">default</span><span class="o">=</span><span class="kc">None</span><span class="p">)</span>
</div>

<div class="viewcode-block" id="test1"><a class="viewcode-back" href="../../../api/sqlobject.tests.test_ForeignKey.html#sqlobject.tests.test_ForeignKey.test1">[docs]</a><span class="k">def</span> <span class="nf">test1</span><span class="p">():</span>
    <span class="n">setupClass</span><span class="p">([</span><span class="n">SOTestComposerKey</span><span class="p">,</span> <span class="n">SOTestWorkKey</span><span class="p">])</span>

    <span class="n">c</span> <span class="o">=</span> <span class="n">SOTestComposerKey</span><span class="p">(</span><span class="n">name</span><span class="o">=</span><span class="s1">&#39;Mahler, Gustav&#39;</span><span class="p">)</span>
    <span class="n">w1</span> <span class="o">=</span> <span class="n">SOTestWorkKey</span><span class="p">(</span><span class="n">composer</span><span class="o">=</span><span class="n">c</span><span class="p">,</span> <span class="n">title</span><span class="o">=</span><span class="s1">&#39;Symphony No. 9&#39;</span><span class="p">)</span>
    <span class="n">w2</span> <span class="o">=</span> <span class="n">SOTestWorkKey</span><span class="p">(</span><span class="n">composer</span><span class="o">=</span><span class="kc">None</span><span class="p">,</span> <span class="n">title</span><span class="o">=</span><span class="kc">None</span><span class="p">)</span>

    <span class="c1"># Select by usual way</span>
    <span class="n">s</span> <span class="o">=</span> <span class="n">SOTestWorkKey</span><span class="o">.</span><span class="n">selectBy</span><span class="p">(</span><span class="n">composerID</span><span class="o">=</span><span class="n">c</span><span class="o">.</span><span class="n">id</span><span class="p">,</span> <span class="n">title</span><span class="o">=</span><span class="s1">&#39;Symphony No. 9&#39;</span><span class="p">)</span>
    <span class="k">assert</span> <span class="n">s</span><span class="o">.</span><span class="n">count</span><span class="p">()</span> <span class="o">==</span> <span class="mi">1</span>
    <span class="k">assert</span> <span class="n">s</span><span class="p">[</span><span class="mi">0</span><span class="p">]</span> <span class="o">==</span> <span class="n">w1</span>
    <span class="c1"># selectBy object.id</span>
    <span class="n">s</span> <span class="o">=</span> <span class="n">SOTestWorkKey</span><span class="o">.</span><span class="n">selectBy</span><span class="p">(</span><span class="n">composer</span><span class="o">=</span><span class="n">c</span><span class="o">.</span><span class="n">id</span><span class="p">,</span> <span class="n">title</span><span class="o">=</span><span class="s1">&#39;Symphony No. 9&#39;</span><span class="p">)</span>
    <span class="k">assert</span> <span class="n">s</span><span class="o">.</span><span class="n">count</span><span class="p">()</span> <span class="o">==</span> <span class="mi">1</span>
    <span class="k">assert</span> <span class="n">s</span><span class="p">[</span><span class="mi">0</span><span class="p">]</span> <span class="o">==</span> <span class="n">w1</span>
    <span class="c1"># selectBy object</span>
    <span class="n">s</span> <span class="o">=</span> <span class="n">SOTestWorkKey</span><span class="o">.</span><span class="n">selectBy</span><span class="p">(</span><span class="n">composer</span><span class="o">=</span><span class="n">c</span><span class="p">,</span> <span class="n">title</span><span class="o">=</span><span class="s1">&#39;Symphony No. 9&#39;</span><span class="p">)</span>
    <span class="k">assert</span> <span class="n">s</span><span class="o">.</span><span class="n">count</span><span class="p">()</span> <span class="o">==</span> <span class="mi">1</span>
    <span class="k">assert</span> <span class="n">s</span><span class="p">[</span><span class="mi">0</span><span class="p">]</span> <span class="o">==</span> <span class="n">w1</span>
    <span class="c1"># selectBy id</span>
    <span class="n">s</span> <span class="o">=</span> <span class="n">SOTestWorkKey</span><span class="o">.</span><span class="n">selectBy</span><span class="p">(</span><span class="nb">id</span><span class="o">=</span><span class="n">w1</span><span class="o">.</span><span class="n">id</span><span class="p">)</span>
    <span class="k">assert</span> <span class="n">s</span><span class="o">.</span><span class="n">count</span><span class="p">()</span> <span class="o">==</span> <span class="mi">1</span>
    <span class="k">assert</span> <span class="n">s</span><span class="p">[</span><span class="mi">0</span><span class="p">]</span> <span class="o">==</span> <span class="n">w1</span>
    <span class="c1"># is None handled correctly?</span>
    <span class="n">s</span> <span class="o">=</span> <span class="n">SOTestWorkKey</span><span class="o">.</span><span class="n">selectBy</span><span class="p">(</span><span class="n">composer</span><span class="o">=</span><span class="kc">None</span><span class="p">,</span> <span class="n">title</span><span class="o">=</span><span class="kc">None</span><span class="p">)</span>
    <span class="k">assert</span> <span class="n">s</span><span class="o">.</span><span class="n">count</span><span class="p">()</span> <span class="o">==</span> <span class="mi">1</span>
    <span class="k">assert</span> <span class="n">s</span><span class="p">[</span><span class="mi">0</span><span class="p">]</span> <span class="o">==</span> <span class="n">w2</span>

    <span class="n">s</span> <span class="o">=</span> <span class="n">SOTestWorkKey</span><span class="o">.</span><span class="n">selectBy</span><span class="p">()</span>
    <span class="k">assert</span> <span class="n">s</span><span class="o">.</span><span class="n">count</span><span class="p">()</span> <span class="o">==</span> <span class="mi">2</span>

    <span class="c1"># select with objects</span>
    <span class="n">s</span> <span class="o">=</span> <span class="n">SOTestWorkKey</span><span class="o">.</span><span class="n">select</span><span class="p">(</span><span class="n">SOTestWorkKey</span><span class="o">.</span><span class="n">q</span><span class="o">.</span><span class="n">composerID</span> <span class="o">==</span> <span class="n">c</span><span class="o">.</span><span class="n">id</span><span class="p">)</span>
    <span class="k">assert</span> <span class="n">s</span><span class="o">.</span><span class="n">count</span><span class="p">()</span> <span class="o">==</span> <span class="mi">1</span>
    <span class="k">assert</span> <span class="n">s</span><span class="p">[</span><span class="mi">0</span><span class="p">]</span> <span class="o">==</span> <span class="n">w1</span>
    <span class="n">s</span> <span class="o">=</span> <span class="n">SOTestWorkKey</span><span class="o">.</span><span class="n">select</span><span class="p">(</span><span class="n">SOTestWorkKey</span><span class="o">.</span><span class="n">q</span><span class="o">.</span><span class="n">composer</span> <span class="o">==</span> <span class="n">c</span><span class="o">.</span><span class="n">id</span><span class="p">)</span>
    <span class="k">assert</span> <span class="n">s</span><span class="o">.</span><span class="n">count</span><span class="p">()</span> <span class="o">==</span> <span class="mi">1</span>
    <span class="k">assert</span> <span class="n">s</span><span class="p">[</span><span class="mi">0</span><span class="p">]</span> <span class="o">==</span> <span class="n">w1</span>
    <span class="n">s</span> <span class="o">=</span> <span class="n">SOTestWorkKey</span><span class="o">.</span><span class="n">select</span><span class="p">(</span><span class="n">SOTestWorkKey</span><span class="o">.</span><span class="n">q</span><span class="o">.</span><span class="n">composerID</span> <span class="o">==</span> <span class="n">c</span><span class="p">)</span>
    <span class="k">assert</span> <span class="n">s</span><span class="o">.</span><span class="n">count</span><span class="p">()</span> <span class="o">==</span> <span class="mi">1</span>
    <span class="k">assert</span> <span class="n">s</span><span class="p">[</span><span class="mi">0</span><span class="p">]</span> <span class="o">==</span> <span class="n">w1</span>
    <span class="n">s</span> <span class="o">=</span> <span class="n">SOTestWorkKey</span><span class="o">.</span><span class="n">select</span><span class="p">(</span><span class="n">SOTestWorkKey</span><span class="o">.</span><span class="n">q</span><span class="o">.</span><span class="n">composer</span> <span class="o">==</span> <span class="n">c</span><span class="p">)</span>
    <span class="k">assert</span> <span class="n">s</span><span class="o">.</span><span class="n">count</span><span class="p">()</span> <span class="o">==</span> <span class="mi">1</span>
    <span class="k">assert</span> <span class="n">s</span><span class="p">[</span><span class="mi">0</span><span class="p">]</span> <span class="o">==</span> <span class="n">w1</span>
    <span class="n">s</span> <span class="o">=</span> <span class="n">SOTestWorkKey</span><span class="o">.</span><span class="n">select</span><span class="p">(</span>
        <span class="p">(</span><span class="n">SOTestWorkKey</span><span class="o">.</span><span class="n">q</span><span class="o">.</span><span class="n">composer</span> <span class="o">==</span> <span class="n">c</span><span class="p">)</span> <span class="o">&amp;</span>
        <span class="p">(</span><span class="n">SOTestWorkKey</span><span class="o">.</span><span class="n">q</span><span class="o">.</span><span class="n">title</span> <span class="o">==</span> <span class="s1">&#39;Symphony No. 9&#39;</span><span class="p">))</span>
    <span class="k">assert</span> <span class="n">s</span><span class="o">.</span><span class="n">count</span><span class="p">()</span> <span class="o">==</span> <span class="mi">1</span>
    <span class="k">assert</span> <span class="n">s</span><span class="p">[</span><span class="mi">0</span><span class="p">]</span> <span class="o">==</span> <span class="n">w1</span>
</div>

<div class="viewcode-block" id="test2"><a class="viewcode-back" href="../../../api/sqlobject.tests.test_ForeignKey.html#sqlobject.tests.test_ForeignKey.test2">[docs]</a><span class="k">def</span> <span class="nf">test2</span><span class="p">():</span>
    <span class="n">SOTestWorkKey</span><span class="o">.</span><span class="n">_connection</span> <span class="o">=</span> <span class="n">getConnection</span><span class="p">()</span>
    <span class="n">InstalledTestDatabase</span><span class="o">.</span><span class="n">drop</span><span class="p">(</span><span class="n">SOTestWorkKey</span><span class="p">)</span>
    <span class="n">setupClass</span><span class="p">([</span><span class="n">SOTestComposerKey</span><span class="p">,</span> <span class="n">SOTestWorkKey2</span><span class="p">],</span> <span class="n">force</span><span class="o">=</span><span class="kc">True</span><span class="p">)</span>
    <span class="n">SOTestWorkKey2</span><span class="o">.</span><span class="n">sqlmeta</span><span class="o">.</span><span class="n">addColumn</span><span class="p">(</span><span class="n">ForeignKey</span><span class="p">(</span><span class="s1">&#39;SOTestComposerKey&#39;</span><span class="p">),</span>
                                     <span class="n">changeSchema</span><span class="o">=</span><span class="kc">True</span><span class="p">)</span>
</div>

<div class="viewcode-block" id="test_otherColumn"><a class="viewcode-back" href="../../../api/sqlobject.tests.test_ForeignKey.html#sqlobject.tests.test_ForeignKey.test_otherColumn">[docs]</a><span class="k">def</span> <span class="nf">test_otherColumn</span><span class="p">():</span>
    <span class="n">setupClass</span><span class="p">([</span><span class="n">SOTestComposerKey</span><span class="p">,</span> <span class="n">SOTestOtherColumn</span><span class="p">])</span>
    <span class="n">test_composer1</span> <span class="o">=</span> <span class="n">SOTestComposerKey</span><span class="p">(</span><span class="n">name</span><span class="o">=</span><span class="s1">&#39;Test1&#39;</span><span class="p">)</span>
    <span class="n">test_composer2</span> <span class="o">=</span> <span class="n">SOTestComposerKey</span><span class="p">(</span><span class="n">name</span><span class="o">=</span><span class="s1">&#39;Test2&#39;</span><span class="p">,</span> <span class="n">id2</span><span class="o">=</span><span class="mi">2</span><span class="p">)</span>
    <span class="n">test_fkey</span> <span class="o">=</span> <span class="n">SOTestOtherColumn</span><span class="p">(</span><span class="n">key1</span><span class="o">=</span><span class="n">test_composer1</span><span class="p">)</span>
    <span class="n">test_other</span> <span class="o">=</span> <span class="n">SOTestOtherColumn</span><span class="p">(</span><span class="n">key2</span><span class="o">=</span><span class="n">test_composer2</span><span class="o">.</span><span class="n">id2</span><span class="p">)</span>
    <span class="n">getConnection</span><span class="p">()</span><span class="o">.</span><span class="n">cache</span><span class="o">.</span><span class="n">clear</span><span class="p">()</span>
    <span class="k">assert</span> <span class="n">test_fkey</span><span class="o">.</span><span class="n">key1</span> <span class="o">==</span> <span class="n">test_composer1</span>
    <span class="k">assert</span> <span class="n">test_other</span><span class="o">.</span><span class="n">key2</span> <span class="o">==</span> <span class="n">test_composer2</span>
</div>

<div class="viewcode-block" id="SOTestFKValidationA"><a class="viewcode-back" href="../../../api/sqlobject.tests.test_ForeignKey.html#sqlobject.tests.test_ForeignKey.SOTestFKValidationA">[docs]</a><span class="k">class</span> <span class="nc">SOTestFKValidationA</span><span class="p">(</span><span class="n">SQLObject</span><span class="p">):</span>
    <span class="n">name</span> <span class="o">=</span> <span class="n">StringCol</span><span class="p">()</span>
    <span class="n">bfk</span> <span class="o">=</span> <span class="n">ForeignKey</span><span class="p">(</span><span class="s2">&quot;SOTestFKValidationB&quot;</span><span class="p">)</span>
    <span class="n">cfk</span> <span class="o">=</span> <span class="n">ForeignKey</span><span class="p">(</span><span class="s2">&quot;SOTestFKValidationC&quot;</span><span class="p">,</span> <span class="n">default</span><span class="o">=</span><span class="kc">None</span><span class="p">)</span>
</div>

<div class="viewcode-block" id="SOTestFKValidationB"><a class="viewcode-back" href="../../../api/sqlobject.tests.test_ForeignKey.html#sqlobject.tests.test_ForeignKey.SOTestFKValidationB">[docs]</a><span class="k">class</span> <span class="nc">SOTestFKValidationB</span><span class="p">(</span><span class="n">SQLObject</span><span class="p">):</span>
    <span class="n">name</span> <span class="o">=</span> <span class="n">StringCol</span><span class="p">()</span>
    <span class="n">afk</span> <span class="o">=</span> <span class="n">ForeignKey</span><span class="p">(</span><span class="s2">&quot;SOTestFKValidationA&quot;</span><span class="p">)</span>
</div>

<div class="viewcode-block" id="SOTestFKValidationC"><a class="viewcode-back" href="../../../api/sqlobject.tests.test_ForeignKey.html#sqlobject.tests.test_ForeignKey.SOTestFKValidationC">[docs]</a><span class="k">class</span> <span class="nc">SOTestFKValidationC</span><span class="p">(</span><span class="n">SQLObject</span><span class="p">):</span>
    <span class="k">class</span> <span class="nc">sqlmeta</span><span class="p">:</span>
        <span class="n">idType</span> <span class="o">=</span> <span class="nb">str</span>
    <span class="n">name</span> <span class="o">=</span> <span class="n">StringCol</span><span class="p">()</span>
</div>

<div class="viewcode-block" id="test_foreignkey_validation"><a class="viewcode-back" href="../../../api/sqlobject.tests.test_ForeignKey.html#sqlobject.tests.test_ForeignKey.test_foreignkey_validation">[docs]</a><span class="k">def</span> <span class="nf">test_foreignkey_validation</span><span class="p">():</span>
    <span class="n">setupCyclicClasses</span><span class="p">(</span><span class="n">SOTestFKValidationA</span><span class="p">,</span> <span class="n">SOTestFKValidationB</span><span class="p">,</span>
                       <span class="n">SOTestFKValidationC</span><span class="p">)</span>
    <span class="n">a</span> <span class="o">=</span> <span class="n">SOTestFKValidationA</span><span class="p">(</span><span class="n">name</span><span class="o">=</span><span class="s2">&quot;testa&quot;</span><span class="p">,</span> <span class="n">bfk</span><span class="o">=</span><span class="kc">None</span><span class="p">)</span>
    <span class="n">b</span> <span class="o">=</span> <span class="n">SOTestFKValidationB</span><span class="p">(</span><span class="n">name</span><span class="o">=</span><span class="s2">&quot;testb&quot;</span><span class="p">,</span> <span class="n">afk</span><span class="o">=</span><span class="n">a</span><span class="p">)</span>
    <span class="n">c</span> <span class="o">=</span> <span class="n">SOTestFKValidationC</span><span class="p">(</span><span class="nb">id</span><span class="o">=</span><span class="s1">&#39;testc&#39;</span><span class="p">,</span> <span class="n">name</span><span class="o">=</span><span class="s2">&quot;testc&quot;</span><span class="p">)</span>
    <span class="n">a</span><span class="o">.</span><span class="n">bfk</span> <span class="o">=</span> <span class="n">b</span>
    <span class="n">a</span><span class="o">.</span><span class="n">cfk</span> <span class="o">=</span> <span class="n">c</span>
    <span class="k">assert</span> <span class="n">a</span><span class="o">.</span><span class="n">bfk</span> <span class="o">==</span> <span class="n">b</span>
    <span class="k">assert</span> <span class="n">a</span><span class="o">.</span><span class="n">cfk</span> <span class="o">==</span> <span class="n">c</span>
    <span class="k">assert</span> <span class="n">b</span><span class="o">.</span><span class="n">afk</span> <span class="o">==</span> <span class="n">a</span>

    <span class="n">raises</span><span class="p">(</span><span class="n">validators</span><span class="o">.</span><span class="n">Invalid</span><span class="p">,</span>
           <span class="n">SOTestFKValidationA</span><span class="p">,</span> <span class="n">name</span><span class="o">=</span><span class="s2">&quot;testa&quot;</span><span class="p">,</span> <span class="n">bfk</span><span class="o">=</span><span class="s1">&#39;testb&#39;</span><span class="p">,</span> <span class="n">cfk</span><span class="o">=</span><span class="s1">&#39;testc&#39;</span><span class="p">)</span>

    <span class="n">a</span> <span class="o">=</span> <span class="n">SOTestFKValidationA</span><span class="p">(</span><span class="n">name</span><span class="o">=</span><span class="s2">&quot;testa&quot;</span><span class="p">,</span> <span class="n">bfk</span><span class="o">=</span><span class="mi">1</span><span class="p">,</span> <span class="n">cfk</span><span class="o">=</span><span class="s1">&#39;testc&#39;</span><span class="p">)</span>
    <span class="k">assert</span> <span class="n">a</span><span class="o">.</span><span class="n">bfkID</span> <span class="o">==</span> <span class="mi">1</span>
    <span class="k">assert</span> <span class="n">a</span><span class="o">.</span><span class="n">cfkID</span> <span class="o">==</span> <span class="s1">&#39;testc&#39;</span>
</pre></div></div>

          </div>
        </div>
      </div>
      <div class="clearer"></div>
    </div>
    <div class="related" role="navigation" aria-label="related navigation">
      <h3>Navigation</h3>
      <ul>
        <li class="right" style="margin-right: 10px">
          <a href="../../../genindex.html" title="General Index"
             >index</a></li>
        <li class="right" >
          <a href="../../../py-modindex.html" title="Python Module Index"
             >modules</a> |</li>
        <li class="nav-item nav-item-0"><a href="../../../index.html">SQLObject 3.7.0 documentation</a> &#187;</li>
          <li class="nav-item nav-item-1"><a href="../../index.html" >Module code</a> &#187;</li> 
      </ul>
    </div>
    <div class="footer" role="contentinfo">
        &#169; Copyright 2004-2018, Ian Bicking and contributors.
      Created using <a href="http://sphinx-doc.org/">Sphinx</a> 1.7.4.
    </div>
  </body>
</html>