<?xml version="1.0" encoding="ascii"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
          "DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
  <title>web2py.gluon.contrib.pymysql.converters</title>
  <link rel="stylesheet" href="epydoc.css" type="text/css" />
  <script type="text/javascript" src="epydoc.js"></script>
</head>

<body bgcolor="white" text="black" link="blue" vlink="#204080"
      alink="#204080">
<!-- ==================== NAVIGATION BAR ==================== -->
<table class="navbar" border="0" width="100%" cellpadding="0"
       bgcolor="#a0c0ff" cellspacing="0">
  <tr valign="middle">
  <!-- Home link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="web2py.gluon-module.html">Home</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Tree link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="module-tree.html">Trees</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Index link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="identifier-index.html">Indices</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Help link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="help.html">Help</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Project homepage -->
      <th class="navbar" align="right" width="100%">
        <table border="0" cellpadding="0" cellspacing="0">
          <tr><th class="navbar" align="center"
            ><a class="navbar" target="_top" href="http://www.web2py.com">web2py Web Framework</a></th>
          </tr></table></th>
  </tr>
</table>
<table width="100%" cellpadding="0" cellspacing="0">
  <tr valign="top">
    <td width="100%">
      <span class="breadcrumbs">
        Package&nbsp;web2py ::
        <a href="web2py.gluon-module.html">Package&nbsp;gluon</a> ::
        Package&nbsp;contrib ::
        <a href="web2py.gluon.contrib.pymysql-module.html">Package&nbsp;pymysql</a> ::
        Module&nbsp;converters
      </span>
    </td>
    <td>
      <table cellpadding="0" cellspacing="0">
        <!-- hide/show private -->
        <tr><td align="right"><span class="options">[<a href="javascript:void(0);" class="privatelink"
    onclick="toggle_private();">hide&nbsp;private</a>]</span></td></tr>
        <tr><td align="right"><span class="options"
            >[<a href="frames.html" target="_top">frames</a
            >]&nbsp;|&nbsp;<a href="web2py.gluon.contrib.pymysql.converters-pysrc.html"
            target="_top">no&nbsp;frames</a>]</span></td></tr>
      </table>
    </td>
  </tr>
</table>
<h1 class="epydoc">Source Code for <a href="web2py.gluon.contrib.pymysql.converters-module.html">Module web2py.gluon.contrib.pymysql.converters</a></h1>
<pre class="py-src">
<a name="L1"></a><tt class="py-lineno">  1</tt>  <tt class="py-line"><tt class="py-keyword">import</tt> <tt class="py-name">re</tt> </tt>
<a name="L2"></a><tt class="py-lineno">  2</tt>  <tt class="py-line"><tt class="py-keyword">import</tt> <tt id="link-0" class="py-name" targets="Class datetime.datetime=datetime.datetime-class.html"><a title="datetime.datetime" class="py-name" href="#" onclick="return doclink('link-0', 'datetime', 'link-0');">datetime</a></tt> </tt>
<a name="L3"></a><tt class="py-lineno">  3</tt>  <tt class="py-line"><tt class="py-keyword">import</tt> <tt id="link-1" class="py-name" targets="Class datetime.time=datetime.time-class.html"><a title="datetime.time" class="py-name" href="#" onclick="return doclink('link-1', 'time', 'link-1');">time</a></tt> </tt>
<a name="L4"></a><tt class="py-lineno">  4</tt>  <tt class="py-line"> </tt>
<a name="L5"></a><tt class="py-lineno">  5</tt>  <tt class="py-line"><tt class="py-keyword">from</tt> <tt id="link-2" class="py-name" targets="Package web2py.gluon.contrib.pymysql.constants=web2py.gluon.contrib.pymysql.constants-module.html"><a title="web2py.gluon.contrib.pymysql.constants" class="py-name" href="#" onclick="return doclink('link-2', 'constants', 'link-2');">constants</a></tt> <tt class="py-keyword">import</tt> <tt id="link-3" class="py-name" targets="Module web2py.gluon.contrib.pymysql.constants.FIELD_TYPE=web2py.gluon.contrib.pymysql.constants.FIELD_TYPE-module.html"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE" class="py-name" href="#" onclick="return doclink('link-3', 'FIELD_TYPE', 'link-3');">FIELD_TYPE</a></tt><tt class="py-op">,</tt> <tt class="py-name">FLAG</tt> </tt>
<a name="L6"></a><tt class="py-lineno">  6</tt>  <tt class="py-line"><tt class="py-keyword">from</tt> <tt class="py-name">charset</tt> <tt class="py-keyword">import</tt> <tt class="py-name">charset_by_id</tt> </tt>
<a name="L7"></a><tt class="py-lineno">  7</tt>  <tt class="py-line"> </tt>
<a name="L8"></a><tt class="py-lineno">  8</tt>  <tt class="py-line"><tt class="py-keyword">try</tt><tt class="py-op">:</tt> </tt>
<a name="L9"></a><tt class="py-lineno">  9</tt>  <tt class="py-line">    <tt class="py-name">set</tt> </tt>
<a name="L10"></a><tt class="py-lineno"> 10</tt>  <tt class="py-line"><tt class="py-keyword">except</tt> <tt class="py-name">NameError</tt><tt class="py-op">:</tt> </tt>
<a name="L11"></a><tt class="py-lineno"> 11</tt>  <tt class="py-line">    <tt class="py-keyword">try</tt><tt class="py-op">:</tt> </tt>
<a name="L12"></a><tt class="py-lineno"> 12</tt>  <tt class="py-line">        <tt class="py-keyword">from</tt> <tt class="py-name">sets</tt> <tt class="py-keyword">import</tt> <tt class="py-name">BaseSet</tt> <tt class="py-keyword">as</tt> <tt class="py-name">set</tt> </tt>
<a name="L13"></a><tt class="py-lineno"> 13</tt>  <tt class="py-line">    <tt class="py-keyword">except</tt> <tt class="py-name">ImportError</tt><tt class="py-op">:</tt> </tt>
<a name="L14"></a><tt class="py-lineno"> 14</tt>  <tt class="py-line">        <tt class="py-keyword">from</tt> <tt class="py-name">sets</tt> <tt class="py-keyword">import</tt> <tt id="link-4" class="py-name" targets="Class web2py.gluon.dal.Set=web2py.gluon.dal.Set-class.html"><a title="web2py.gluon.dal.Set" class="py-name" href="#" onclick="return doclink('link-4', 'Set', 'link-4');">Set</a></tt> <tt class="py-keyword">as</tt> <tt class="py-name">set</tt> </tt>
<a name="L15"></a><tt class="py-lineno"> 15</tt>  <tt class="py-line"> </tt>
<a name="L16"></a><tt class="py-lineno"> 16</tt>  <tt class="py-line"><tt id="link-5" class="py-name" targets="Variable web2py.gluon.contrib.pymysql.converters.ESCAPE_REGEX=web2py.gluon.contrib.pymysql.converters-module.html#ESCAPE_REGEX"><a title="web2py.gluon.contrib.pymysql.converters.ESCAPE_REGEX" class="py-name" href="#" onclick="return doclink('link-5', 'ESCAPE_REGEX', 'link-5');">ESCAPE_REGEX</a></tt> <tt class="py-op">=</tt> <tt class="py-name">re</tt><tt class="py-op">.</tt><tt class="py-name">compile</tt><tt class="py-op">(</tt><tt class="py-string">r"[\0\n\r\032\'\"\\]"</tt><tt class="py-op">)</tt> </tt>
<a name="L17"></a><tt class="py-lineno"> 17</tt>  <tt class="py-line"><tt id="link-6" class="py-name" targets="Variable web2py.gluon.contrib.pymysql.converters.ESCAPE_MAP=web2py.gluon.contrib.pymysql.converters-module.html#ESCAPE_MAP"><a title="web2py.gluon.contrib.pymysql.converters.ESCAPE_MAP" class="py-name" href="#" onclick="return doclink('link-6', 'ESCAPE_MAP', 'link-6');">ESCAPE_MAP</a></tt> <tt class="py-op">=</tt> <tt class="py-op">{</tt><tt class="py-string">'\0'</tt><tt class="py-op">:</tt> <tt class="py-string">'\\0'</tt><tt class="py-op">,</tt> <tt class="py-string">'\n'</tt><tt class="py-op">:</tt> <tt class="py-string">'\\n'</tt><tt class="py-op">,</tt> <tt class="py-string">'\r'</tt><tt class="py-op">:</tt> <tt class="py-string">'\\r'</tt><tt class="py-op">,</tt> <tt class="py-string">'\032'</tt><tt class="py-op">:</tt> <tt class="py-string">'\\Z'</tt><tt class="py-op">,</tt> </tt>
<a name="L18"></a><tt class="py-lineno"> 18</tt>  <tt class="py-line">              <tt class="py-string">'\''</tt><tt class="py-op">:</tt> <tt class="py-string">'\\\''</tt><tt class="py-op">,</tt> <tt class="py-string">'"'</tt><tt class="py-op">:</tt> <tt class="py-string">'\\"'</tt><tt class="py-op">,</tt> <tt class="py-string">'\\'</tt><tt class="py-op">:</tt> <tt class="py-string">'\\\\'</tt><tt class="py-op">}</tt> </tt>
<a name="L19"></a><tt class="py-lineno"> 19</tt>  <tt class="py-line"> </tt>
<a name="escape_item"></a><div id="escape_item-def"><a name="L20"></a><tt class="py-lineno"> 20</tt> <a class="py-toggle" href="#" id="escape_item-toggle" onclick="return toggle('escape_item');">-</a><tt class="py-line"><tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.contrib.pymysql.converters-module.html#escape_item">escape_item</a><tt class="py-op">(</tt><tt class="py-param">val</tt><tt class="py-op">,</tt> <tt class="py-param">charset</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="escape_item-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="escape_item-expanded"><a name="L21"></a><tt class="py-lineno"> 21</tt>  <tt class="py-line">    <tt class="py-keyword">if</tt> <tt class="py-name">type</tt><tt class="py-op">(</tt><tt class="py-name">val</tt><tt class="py-op">)</tt> <tt class="py-keyword">in</tt> <tt class="py-op">[</tt><tt class="py-name">tuple</tt><tt class="py-op">,</tt> <tt class="py-name">list</tt><tt class="py-op">,</tt> <tt class="py-name">set</tt><tt class="py-op">]</tt><tt class="py-op">:</tt> </tt>
<a name="L22"></a><tt class="py-lineno"> 22</tt>  <tt class="py-line">        <tt class="py-keyword">return</tt> <tt id="link-7" class="py-name" targets="Function web2py.gluon.contrib.pymysql.converters.escape_sequence()=web2py.gluon.contrib.pymysql.converters-module.html#escape_sequence"><a title="web2py.gluon.contrib.pymysql.converters.escape_sequence" class="py-name" href="#" onclick="return doclink('link-7', 'escape_sequence', 'link-7');">escape_sequence</a></tt><tt class="py-op">(</tt><tt class="py-name">val</tt><tt class="py-op">,</tt> <tt class="py-name">charset</tt><tt class="py-op">)</tt> </tt>
<a name="L23"></a><tt class="py-lineno"> 23</tt>  <tt class="py-line">    <tt class="py-keyword">if</tt> <tt class="py-name">type</tt><tt class="py-op">(</tt><tt class="py-name">val</tt><tt class="py-op">)</tt> <tt class="py-keyword">is</tt> <tt class="py-name">dict</tt><tt class="py-op">:</tt> </tt>
<a name="L24"></a><tt class="py-lineno"> 24</tt>  <tt class="py-line">        <tt class="py-keyword">return</tt> <tt id="link-8" class="py-name" targets="Function web2py.gluon.contrib.pymysql.converters.escape_dict()=web2py.gluon.contrib.pymysql.converters-module.html#escape_dict"><a title="web2py.gluon.contrib.pymysql.converters.escape_dict" class="py-name" href="#" onclick="return doclink('link-8', 'escape_dict', 'link-8');">escape_dict</a></tt><tt class="py-op">(</tt><tt class="py-name">val</tt><tt class="py-op">,</tt> <tt class="py-name">charset</tt><tt class="py-op">)</tt> </tt>
<a name="L25"></a><tt class="py-lineno"> 25</tt>  <tt class="py-line">    <tt class="py-keyword">if</tt> <tt class="py-name">hasattr</tt><tt class="py-op">(</tt><tt class="py-name">val</tt><tt class="py-op">,</tt> <tt class="py-string">"decode"</tt><tt class="py-op">)</tt> <tt class="py-keyword">and</tt> <tt class="py-keyword">not</tt> <tt class="py-name">isinstance</tt><tt class="py-op">(</tt><tt class="py-name">val</tt><tt class="py-op">,</tt> <tt class="py-name">unicode</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L26"></a><tt class="py-lineno"> 26</tt>  <tt class="py-line">        <tt class="py-comment"># deal with py3k bytes</tt> </tt>
<a name="L27"></a><tt class="py-lineno"> 27</tt>  <tt class="py-line"><tt class="py-comment"></tt>        <tt class="py-name">val</tt> <tt class="py-op">=</tt> <tt class="py-name">val</tt><tt class="py-op">.</tt><tt id="link-9" class="py-name" targets="Method web2py.gluon.languages.lazyT.decode()=web2py.gluon.languages.lazyT-class.html#decode"><a title="web2py.gluon.languages.lazyT.decode" class="py-name" href="#" onclick="return doclink('link-9', 'decode', 'link-9');">decode</a></tt><tt class="py-op">(</tt><tt class="py-name">charset</tt><tt class="py-op">)</tt> </tt>
<a name="L28"></a><tt class="py-lineno"> 28</tt>  <tt class="py-line">    <tt class="py-name">encoder</tt> <tt class="py-op">=</tt> <tt id="link-10" class="py-name" targets="Variable web2py.gluon.contrib.pymysql.converters.encoders=web2py.gluon.contrib.pymysql.converters-module.html#encoders"><a title="web2py.gluon.contrib.pymysql.converters.encoders" class="py-name" href="#" onclick="return doclink('link-10', 'encoders', 'link-10');">encoders</a></tt><tt class="py-op">[</tt><tt class="py-name">type</tt><tt class="py-op">(</tt><tt class="py-name">val</tt><tt class="py-op">)</tt><tt class="py-op">]</tt> </tt>
<a name="L29"></a><tt class="py-lineno"> 29</tt>  <tt class="py-line">    <tt class="py-name">val</tt> <tt class="py-op">=</tt> <tt class="py-name">encoder</tt><tt class="py-op">(</tt><tt class="py-name">val</tt><tt class="py-op">)</tt> </tt>
<a name="L30"></a><tt class="py-lineno"> 30</tt>  <tt class="py-line">    <tt class="py-keyword">if</tt> <tt class="py-name">type</tt><tt class="py-op">(</tt><tt class="py-name">val</tt><tt class="py-op">)</tt> <tt class="py-keyword">is</tt> <tt class="py-name">str</tt><tt class="py-op">:</tt> </tt>
<a name="L31"></a><tt class="py-lineno"> 31</tt>  <tt class="py-line">        <tt class="py-keyword">return</tt> <tt class="py-name">val</tt> </tt>
<a name="L32"></a><tt class="py-lineno"> 32</tt>  <tt class="py-line">    <tt class="py-name">val</tt> <tt class="py-op">=</tt> <tt class="py-name">val</tt><tt class="py-op">.</tt><tt id="link-11" class="py-name" targets="Method web2py.gluon.languages.lazyT.encode()=web2py.gluon.languages.lazyT-class.html#encode"><a title="web2py.gluon.languages.lazyT.encode" class="py-name" href="#" onclick="return doclink('link-11', 'encode', 'link-11');">encode</a></tt><tt class="py-op">(</tt><tt class="py-name">charset</tt><tt class="py-op">)</tt> </tt>
<a name="L33"></a><tt class="py-lineno"> 33</tt>  <tt class="py-line">    <tt class="py-keyword">return</tt> <tt class="py-name">val</tt> </tt>
</div><a name="L34"></a><tt class="py-lineno"> 34</tt>  <tt class="py-line"> </tt>
<a name="escape_dict"></a><div id="escape_dict-def"><a name="L35"></a><tt class="py-lineno"> 35</tt> <a class="py-toggle" href="#" id="escape_dict-toggle" onclick="return toggle('escape_dict');">-</a><tt class="py-line"><tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.contrib.pymysql.converters-module.html#escape_dict">escape_dict</a><tt class="py-op">(</tt><tt class="py-param">val</tt><tt class="py-op">,</tt> <tt class="py-param">charset</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="escape_dict-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="escape_dict-expanded"><a name="L36"></a><tt class="py-lineno"> 36</tt>  <tt class="py-line">    <tt class="py-name">n</tt> <tt class="py-op">=</tt> <tt class="py-op">{</tt><tt class="py-op">}</tt> </tt>
<a name="L37"></a><tt class="py-lineno"> 37</tt>  <tt class="py-line">    <tt class="py-keyword">for</tt> <tt id="link-12" class="py-name" targets="Variable psycopg2.k=psycopg2-module.html#k"><a title="psycopg2.k" class="py-name" href="#" onclick="return doclink('link-12', 'k', 'link-12');">k</a></tt><tt class="py-op">,</tt> <tt class="py-name">v</tt> <tt class="py-keyword">in</tt> <tt class="py-name">val</tt><tt class="py-op">.</tt><tt id="link-13" class="py-name" targets="Method web2py.gluon.rocket.Headers.items()=web2py.gluon.rocket.Headers-class.html#items"><a title="web2py.gluon.rocket.Headers.items" class="py-name" href="#" onclick="return doclink('link-13', 'items', 'link-13');">items</a></tt><tt class="py-op">(</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L38"></a><tt class="py-lineno"> 38</tt>  <tt class="py-line">        <tt class="py-name">quoted</tt> <tt class="py-op">=</tt> <tt id="link-14" class="py-name" targets="Function web2py.gluon.contrib.pymysql.converters.escape_item()=web2py.gluon.contrib.pymysql.converters-module.html#escape_item"><a title="web2py.gluon.contrib.pymysql.converters.escape_item" class="py-name" href="#" onclick="return doclink('link-14', 'escape_item', 'link-14');">escape_item</a></tt><tt class="py-op">(</tt><tt class="py-name">v</tt><tt class="py-op">,</tt> <tt class="py-name">charset</tt><tt class="py-op">)</tt> </tt>
<a name="L39"></a><tt class="py-lineno"> 39</tt>  <tt class="py-line">        <tt class="py-name">n</tt><tt class="py-op">[</tt><tt id="link-15" class="py-name"><a title="psycopg2.k" class="py-name" href="#" onclick="return doclink('link-15', 'k', 'link-12');">k</a></tt><tt class="py-op">]</tt> <tt class="py-op">=</tt> <tt class="py-name">quoted</tt> </tt>
<a name="L40"></a><tt class="py-lineno"> 40</tt>  <tt class="py-line">    <tt class="py-keyword">return</tt> <tt class="py-name">n</tt> </tt>
</div><a name="L41"></a><tt class="py-lineno"> 41</tt>  <tt class="py-line"> </tt>
<a name="escape_sequence"></a><div id="escape_sequence-def"><a name="L42"></a><tt class="py-lineno"> 42</tt> <a class="py-toggle" href="#" id="escape_sequence-toggle" onclick="return toggle('escape_sequence');">-</a><tt class="py-line"><tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.contrib.pymysql.converters-module.html#escape_sequence">escape_sequence</a><tt class="py-op">(</tt><tt class="py-param">val</tt><tt class="py-op">,</tt> <tt class="py-param">charset</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="escape_sequence-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="escape_sequence-expanded"><a name="L43"></a><tt class="py-lineno"> 43</tt>  <tt class="py-line">    <tt class="py-name">n</tt> <tt class="py-op">=</tt> <tt class="py-op">[</tt><tt class="py-op">]</tt> </tt>
<a name="L44"></a><tt class="py-lineno"> 44</tt>  <tt class="py-line">    <tt class="py-keyword">for</tt> <tt class="py-name">item</tt> <tt class="py-keyword">in</tt> <tt class="py-name">val</tt><tt class="py-op">:</tt> </tt>
<a name="L45"></a><tt class="py-lineno"> 45</tt>  <tt class="py-line">        <tt class="py-name">quoted</tt> <tt class="py-op">=</tt> <tt id="link-16" class="py-name"><a title="web2py.gluon.contrib.pymysql.converters.escape_item" class="py-name" href="#" onclick="return doclink('link-16', 'escape_item', 'link-14');">escape_item</a></tt><tt class="py-op">(</tt><tt class="py-name">item</tt><tt class="py-op">,</tt> <tt class="py-name">charset</tt><tt class="py-op">)</tt> </tt>
<a name="L46"></a><tt class="py-lineno"> 46</tt>  <tt class="py-line">        <tt class="py-name">n</tt><tt class="py-op">.</tt><tt id="link-17" class="py-name" targets="Method web2py.gluon.html.DIV.append()=web2py.gluon.html.DIV-class.html#append,Method web2py.gluon.template.BlockNode.append()=web2py.gluon.template.BlockNode-class.html#append,Method web2py.gluon.template.Content.append()=web2py.gluon.template.Content-class.html#append"><a title="web2py.gluon.html.DIV.append
web2py.gluon.template.BlockNode.append
web2py.gluon.template.Content.append" class="py-name" href="#" onclick="return doclink('link-17', 'append', 'link-17');">append</a></tt><tt class="py-op">(</tt><tt class="py-name">quoted</tt><tt class="py-op">)</tt> </tt>
<a name="L47"></a><tt class="py-lineno"> 47</tt>  <tt class="py-line">    <tt class="py-keyword">return</tt> <tt class="py-name">tuple</tt><tt class="py-op">(</tt><tt class="py-name">n</tt><tt class="py-op">)</tt> </tt>
</div><a name="L48"></a><tt class="py-lineno"> 48</tt>  <tt class="py-line"> </tt>
<a name="escape_set"></a><div id="escape_set-def"><a name="L49"></a><tt class="py-lineno"> 49</tt> <a class="py-toggle" href="#" id="escape_set-toggle" onclick="return toggle('escape_set');">-</a><tt class="py-line"><tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.contrib.pymysql.converters-module.html#escape_set">escape_set</a><tt class="py-op">(</tt><tt class="py-param">val</tt><tt class="py-op">,</tt> <tt class="py-param">charset</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="escape_set-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="escape_set-expanded"><a name="L50"></a><tt class="py-lineno"> 50</tt>  <tt class="py-line">    <tt class="py-name">val</tt> <tt class="py-op">=</tt> <tt class="py-name">map</tt><tt class="py-op">(</tt><tt class="py-keyword">lambda</tt> <tt id="link-18" class="py-name" targets="Variable sqlite3.dbapi2.x=sqlite3.dbapi2-module.html#x"><a title="sqlite3.dbapi2.x" class="py-name" href="#" onclick="return doclink('link-18', 'x', 'link-18');">x</a></tt><tt class="py-op">:</tt> <tt id="link-19" class="py-name"><a title="web2py.gluon.contrib.pymysql.converters.escape_item" class="py-name" href="#" onclick="return doclink('link-19', 'escape_item', 'link-14');">escape_item</a></tt><tt class="py-op">(</tt><tt id="link-20" class="py-name"><a title="sqlite3.dbapi2.x" class="py-name" href="#" onclick="return doclink('link-20', 'x', 'link-18');">x</a></tt><tt class="py-op">,</tt> <tt class="py-name">charset</tt><tt class="py-op">)</tt><tt class="py-op">,</tt> <tt class="py-name">val</tt><tt class="py-op">)</tt> </tt>
<a name="L51"></a><tt class="py-lineno"> 51</tt>  <tt class="py-line">    <tt class="py-keyword">return</tt> <tt class="py-string">','</tt><tt class="py-op">.</tt><tt id="link-21" class="py-name" targets="Function web2py.gluon.html.join()=web2py.gluon.html-module.html#join"><a title="web2py.gluon.html.join" class="py-name" href="#" onclick="return doclink('link-21', 'join', 'link-21');">join</a></tt><tt class="py-op">(</tt><tt class="py-name">val</tt><tt class="py-op">)</tt> </tt>
</div><a name="L52"></a><tt class="py-lineno"> 52</tt>  <tt class="py-line"> </tt>
<a name="escape_bool"></a><div id="escape_bool-def"><a name="L53"></a><tt class="py-lineno"> 53</tt> <a class="py-toggle" href="#" id="escape_bool-toggle" onclick="return toggle('escape_bool');">-</a><tt class="py-line"><tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.contrib.pymysql.converters-module.html#escape_bool">escape_bool</a><tt class="py-op">(</tt><tt class="py-param">value</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="escape_bool-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="escape_bool-expanded"><a name="L54"></a><tt class="py-lineno"> 54</tt>  <tt class="py-line">    <tt class="py-keyword">return</tt> <tt class="py-name">str</tt><tt class="py-op">(</tt><tt class="py-name">int</tt><tt class="py-op">(</tt><tt class="py-name">value</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
</div><a name="L55"></a><tt class="py-lineno"> 55</tt>  <tt class="py-line"> </tt>
<a name="escape_object"></a><div id="escape_object-def"><a name="L56"></a><tt class="py-lineno"> 56</tt> <a class="py-toggle" href="#" id="escape_object-toggle" onclick="return toggle('escape_object');">-</a><tt class="py-line"><tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.contrib.pymysql.converters-module.html#escape_object">escape_object</a><tt class="py-op">(</tt><tt class="py-param">value</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="escape_object-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="escape_object-expanded"><a name="L57"></a><tt class="py-lineno"> 57</tt>  <tt class="py-line">    <tt class="py-keyword">return</tt> <tt class="py-name">str</tt><tt class="py-op">(</tt><tt class="py-name">value</tt><tt class="py-op">)</tt> </tt>
</div><a name="L58"></a><tt class="py-lineno"> 58</tt>  <tt class="py-line"> </tt>
<a name="L59"></a><tt class="py-lineno"> 59</tt>  <tt class="py-line"><tt class="py-name">escape_int</tt> <tt class="py-op">=</tt> <tt class="py-name">escape_long</tt> <tt class="py-op">=</tt> <tt id="link-22" class="py-name" targets="Function web2py.gluon.contrib.pymysql.converters.escape_object()=web2py.gluon.contrib.pymysql.converters-module.html#escape_object"><a title="web2py.gluon.contrib.pymysql.converters.escape_object" class="py-name" href="#" onclick="return doclink('link-22', 'escape_object', 'link-22');">escape_object</a></tt> </tt>
<a name="L60"></a><tt class="py-lineno"> 60</tt>  <tt class="py-line"> </tt>
<a name="escape_float"></a><div id="escape_float-def"><a name="L61"></a><tt class="py-lineno"> 61</tt> <a class="py-toggle" href="#" id="escape_float-toggle" onclick="return toggle('escape_float');">-</a><tt class="py-line"><tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.contrib.pymysql.converters-module.html#escape_float">escape_float</a><tt class="py-op">(</tt><tt class="py-param">value</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="escape_float-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="escape_float-expanded"><a name="L62"></a><tt class="py-lineno"> 62</tt>  <tt class="py-line">    <tt class="py-keyword">return</tt> <tt class="py-op">(</tt><tt class="py-string">'%.15g'</tt> <tt class="py-op">%</tt> <tt class="py-name">value</tt><tt class="py-op">)</tt> </tt>
</div><a name="L63"></a><tt class="py-lineno"> 63</tt>  <tt class="py-line"> </tt>
<a name="escape_string"></a><div id="escape_string-def"><a name="L64"></a><tt class="py-lineno"> 64</tt> <a class="py-toggle" href="#" id="escape_string-toggle" onclick="return toggle('escape_string');">-</a><tt class="py-line"><tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.contrib.pymysql.converters-module.html#escape_string">escape_string</a><tt class="py-op">(</tt><tt class="py-param">value</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="escape_string-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="escape_string-expanded"><a name="L65"></a><tt class="py-lineno"> 65</tt>  <tt class="py-line">    <tt class="py-keyword">return</tt> <tt class="py-op">(</tt><tt class="py-string">"'%s'"</tt> <tt class="py-op">%</tt> <tt id="link-23" class="py-name"><a title="web2py.gluon.contrib.pymysql.converters.ESCAPE_REGEX" class="py-name" href="#" onclick="return doclink('link-23', 'ESCAPE_REGEX', 'link-5');">ESCAPE_REGEX</a></tt><tt class="py-op">.</tt><tt class="py-name">sub</tt><tt class="py-op">(</tt> </tt>
<a name="L66"></a><tt class="py-lineno"> 66</tt>  <tt class="py-line">            <tt class="py-keyword">lambda</tt> <tt class="py-name">match</tt><tt class="py-op">:</tt> <tt id="link-24" class="py-name"><a title="web2py.gluon.contrib.pymysql.converters.ESCAPE_MAP" class="py-name" href="#" onclick="return doclink('link-24', 'ESCAPE_MAP', 'link-6');">ESCAPE_MAP</a></tt><tt class="py-op">.</tt><tt id="link-25" class="py-name" targets="Method web2py.gluon.rocket.Headers.get()=web2py.gluon.rocket.Headers-class.html#get"><a title="web2py.gluon.rocket.Headers.get" class="py-name" href="#" onclick="return doclink('link-25', 'get', 'link-25');">get</a></tt><tt class="py-op">(</tt><tt class="py-name">match</tt><tt class="py-op">.</tt><tt class="py-name">group</tt><tt class="py-op">(</tt><tt class="py-number">0</tt><tt class="py-op">)</tt><tt class="py-op">)</tt><tt class="py-op">,</tt> <tt class="py-name">value</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
</div><a name="L67"></a><tt class="py-lineno"> 67</tt>  <tt class="py-line"> </tt>
<a name="escape_unicode"></a><div id="escape_unicode-def"><a name="L68"></a><tt class="py-lineno"> 68</tt> <a class="py-toggle" href="#" id="escape_unicode-toggle" onclick="return toggle('escape_unicode');">-</a><tt class="py-line"><tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.contrib.pymysql.converters-module.html#escape_unicode">escape_unicode</a><tt class="py-op">(</tt><tt class="py-param">value</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="escape_unicode-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="escape_unicode-expanded"><a name="L69"></a><tt class="py-lineno"> 69</tt>  <tt class="py-line">    <tt class="py-keyword">return</tt> <tt id="link-26" class="py-name" targets="Function web2py.gluon.contrib.pymysql.converters.escape_string()=web2py.gluon.contrib.pymysql.converters-module.html#escape_string"><a title="web2py.gluon.contrib.pymysql.converters.escape_string" class="py-name" href="#" onclick="return doclink('link-26', 'escape_string', 'link-26');">escape_string</a></tt><tt class="py-op">(</tt><tt class="py-name">value</tt><tt class="py-op">)</tt> </tt>
</div><a name="L70"></a><tt class="py-lineno"> 70</tt>  <tt class="py-line"> </tt>
<a name="escape_None"></a><div id="escape_None-def"><a name="L71"></a><tt class="py-lineno"> 71</tt> <a class="py-toggle" href="#" id="escape_None-toggle" onclick="return toggle('escape_None');">-</a><tt class="py-line"><tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.contrib.pymysql.converters-module.html#escape_None">escape_None</a><tt class="py-op">(</tt><tt class="py-param">value</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="escape_None-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="escape_None-expanded"><a name="L72"></a><tt class="py-lineno"> 72</tt>  <tt class="py-line">    <tt class="py-keyword">return</tt> <tt class="py-string">'NULL'</tt> </tt>
</div><a name="L73"></a><tt class="py-lineno"> 73</tt>  <tt class="py-line"> </tt>
<a name="escape_timedelta"></a><div id="escape_timedelta-def"><a name="L74"></a><tt class="py-lineno"> 74</tt> <a class="py-toggle" href="#" id="escape_timedelta-toggle" onclick="return toggle('escape_timedelta');">-</a><tt class="py-line"><tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.contrib.pymysql.converters-module.html#escape_timedelta">escape_timedelta</a><tt class="py-op">(</tt><tt class="py-param">obj</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="escape_timedelta-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="escape_timedelta-expanded"><a name="L75"></a><tt class="py-lineno"> 75</tt>  <tt class="py-line">    <tt id="link-27" class="py-name" targets="Method web2py.gluon.dal.Expression.seconds()=web2py.gluon.dal.Expression-class.html#seconds"><a title="web2py.gluon.dal.Expression.seconds" class="py-name" href="#" onclick="return doclink('link-27', 'seconds', 'link-27');">seconds</a></tt> <tt class="py-op">=</tt> <tt class="py-name">int</tt><tt class="py-op">(</tt><tt class="py-name">obj</tt><tt class="py-op">.</tt><tt id="link-28" class="py-name"><a title="web2py.gluon.dal.Expression.seconds" class="py-name" href="#" onclick="return doclink('link-28', 'seconds', 'link-27');">seconds</a></tt><tt class="py-op">)</tt> <tt class="py-op">%</tt> <tt class="py-number">60</tt> </tt>
<a name="L76"></a><tt class="py-lineno"> 76</tt>  <tt class="py-line">    <tt id="link-29" class="py-name" targets="Method web2py.gluon.dal.Expression.minutes()=web2py.gluon.dal.Expression-class.html#minutes"><a title="web2py.gluon.dal.Expression.minutes" class="py-name" href="#" onclick="return doclink('link-29', 'minutes', 'link-29');">minutes</a></tt> <tt class="py-op">=</tt> <tt class="py-name">int</tt><tt class="py-op">(</tt><tt class="py-name">obj</tt><tt class="py-op">.</tt><tt id="link-30" class="py-name"><a title="web2py.gluon.dal.Expression.seconds" class="py-name" href="#" onclick="return doclink('link-30', 'seconds', 'link-27');">seconds</a></tt> <tt class="py-op">//</tt> <tt class="py-number">60</tt><tt class="py-op">)</tt> <tt class="py-op">%</tt> <tt class="py-number">60</tt> </tt>
<a name="L77"></a><tt class="py-lineno"> 77</tt>  <tt class="py-line">    <tt class="py-name">hours</tt> <tt class="py-op">=</tt> <tt class="py-name">int</tt><tt class="py-op">(</tt><tt class="py-name">obj</tt><tt class="py-op">.</tt><tt id="link-31" class="py-name"><a title="web2py.gluon.dal.Expression.seconds" class="py-name" href="#" onclick="return doclink('link-31', 'seconds', 'link-27');">seconds</a></tt> <tt class="py-op">//</tt> <tt class="py-number">3600</tt><tt class="py-op">)</tt> <tt class="py-op">%</tt> <tt class="py-number">24</tt> <tt class="py-op">+</tt> <tt class="py-name">int</tt><tt class="py-op">(</tt><tt class="py-name">obj</tt><tt class="py-op">.</tt><tt class="py-name">days</tt><tt class="py-op">)</tt> <tt class="py-op">*</tt> <tt class="py-number">24</tt> </tt>
<a name="L78"></a><tt class="py-lineno"> 78</tt>  <tt class="py-line">    <tt class="py-keyword">return</tt> <tt id="link-32" class="py-name"><a title="web2py.gluon.contrib.pymysql.converters.escape_string" class="py-name" href="#" onclick="return doclink('link-32', 'escape_string', 'link-26');">escape_string</a></tt><tt class="py-op">(</tt><tt class="py-string">'%02d:%02d:%02d'</tt> <tt class="py-op">%</tt> <tt class="py-op">(</tt><tt class="py-name">hours</tt><tt class="py-op">,</tt> <tt id="link-33" class="py-name"><a title="web2py.gluon.dal.Expression.minutes" class="py-name" href="#" onclick="return doclink('link-33', 'minutes', 'link-29');">minutes</a></tt><tt class="py-op">,</tt> <tt id="link-34" class="py-name"><a title="web2py.gluon.dal.Expression.seconds" class="py-name" href="#" onclick="return doclink('link-34', 'seconds', 'link-27');">seconds</a></tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
</div><a name="L79"></a><tt class="py-lineno"> 79</tt>  <tt class="py-line"> </tt>
<a name="escape_time"></a><div id="escape_time-def"><a name="L80"></a><tt class="py-lineno"> 80</tt> <a class="py-toggle" href="#" id="escape_time-toggle" onclick="return toggle('escape_time');">-</a><tt class="py-line"><tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.contrib.pymysql.converters-module.html#escape_time">escape_time</a><tt class="py-op">(</tt><tt class="py-param">obj</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="escape_time-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="escape_time-expanded"><a name="L81"></a><tt class="py-lineno"> 81</tt>  <tt class="py-line">    <tt id="link-35" class="py-name" targets="Variable web2py.gluon.languages.lazyT.s=web2py.gluon.languages.lazyT-class.html#s"><a title="web2py.gluon.languages.lazyT.s" class="py-name" href="#" onclick="return doclink('link-35', 's', 'link-35');">s</a></tt> <tt class="py-op">=</tt> <tt class="py-string">"%02d:%02d:%02d"</tt> <tt class="py-op">%</tt> <tt class="py-op">(</tt><tt class="py-name">int</tt><tt class="py-op">(</tt><tt class="py-name">obj</tt><tt class="py-op">.</tt><tt id="link-36" class="py-name" targets="Method web2py.gluon.dal.Expression.hour()=web2py.gluon.dal.Expression-class.html#hour"><a title="web2py.gluon.dal.Expression.hour" class="py-name" href="#" onclick="return doclink('link-36', 'hour', 'link-36');">hour</a></tt><tt class="py-op">)</tt><tt class="py-op">,</tt> <tt class="py-name">int</tt><tt class="py-op">(</tt><tt class="py-name">obj</tt><tt class="py-op">.</tt><tt class="py-name">minute</tt><tt class="py-op">)</tt><tt class="py-op">,</tt> </tt>
<a name="L82"></a><tt class="py-lineno"> 82</tt>  <tt class="py-line">                            <tt class="py-name">int</tt><tt class="py-op">(</tt><tt class="py-name">obj</tt><tt class="py-op">.</tt><tt class="py-name">second</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L83"></a><tt class="py-lineno"> 83</tt>  <tt class="py-line">    <tt class="py-keyword">if</tt> <tt class="py-name">obj</tt><tt class="py-op">.</tt><tt class="py-name">microsecond</tt><tt class="py-op">:</tt> </tt>
<a name="L84"></a><tt class="py-lineno"> 84</tt>  <tt class="py-line">        <tt id="link-37" class="py-name"><a title="web2py.gluon.languages.lazyT.s" class="py-name" href="#" onclick="return doclink('link-37', 's', 'link-35');">s</a></tt> <tt class="py-op">+=</tt> <tt class="py-string">".%f"</tt> <tt class="py-op">%</tt> <tt class="py-name">obj</tt><tt class="py-op">.</tt><tt class="py-name">microsecond</tt> </tt>
<a name="L85"></a><tt class="py-lineno"> 85</tt>  <tt class="py-line"> </tt>
<a name="L86"></a><tt class="py-lineno"> 86</tt>  <tt class="py-line">    <tt class="py-keyword">return</tt> <tt id="link-38" class="py-name"><a title="web2py.gluon.contrib.pymysql.converters.escape_string" class="py-name" href="#" onclick="return doclink('link-38', 'escape_string', 'link-26');">escape_string</a></tt><tt class="py-op">(</tt><tt id="link-39" class="py-name"><a title="web2py.gluon.languages.lazyT.s" class="py-name" href="#" onclick="return doclink('link-39', 's', 'link-35');">s</a></tt><tt class="py-op">)</tt> </tt>
</div><a name="L87"></a><tt class="py-lineno"> 87</tt>  <tt class="py-line"> </tt>
<a name="escape_datetime"></a><div id="escape_datetime-def"><a name="L88"></a><tt class="py-lineno"> 88</tt> <a class="py-toggle" href="#" id="escape_datetime-toggle" onclick="return toggle('escape_datetime');">-</a><tt class="py-line"><tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.contrib.pymysql.converters-module.html#escape_datetime">escape_datetime</a><tt class="py-op">(</tt><tt class="py-param">obj</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="escape_datetime-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="escape_datetime-expanded"><a name="L89"></a><tt class="py-lineno"> 89</tt>  <tt class="py-line">    <tt class="py-keyword">return</tt> <tt id="link-40" class="py-name"><a title="web2py.gluon.contrib.pymysql.converters.escape_string" class="py-name" href="#" onclick="return doclink('link-40', 'escape_string', 'link-26');">escape_string</a></tt><tt class="py-op">(</tt><tt class="py-name">obj</tt><tt class="py-op">.</tt><tt class="py-name">strftime</tt><tt class="py-op">(</tt><tt class="py-string">"%Y-%m-%d %H:%M:%S"</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
</div><a name="L90"></a><tt class="py-lineno"> 90</tt>  <tt class="py-line"> </tt>
<a name="escape_date"></a><div id="escape_date-def"><a name="L91"></a><tt class="py-lineno"> 91</tt> <a class="py-toggle" href="#" id="escape_date-toggle" onclick="return toggle('escape_date');">-</a><tt class="py-line"><tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.contrib.pymysql.converters-module.html#escape_date">escape_date</a><tt class="py-op">(</tt><tt class="py-param">obj</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="escape_date-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="escape_date-expanded"><a name="L92"></a><tt class="py-lineno"> 92</tt>  <tt class="py-line">    <tt class="py-keyword">return</tt> <tt id="link-41" class="py-name"><a title="web2py.gluon.contrib.pymysql.converters.escape_string" class="py-name" href="#" onclick="return doclink('link-41', 'escape_string', 'link-26');">escape_string</a></tt><tt class="py-op">(</tt><tt class="py-name">obj</tt><tt class="py-op">.</tt><tt class="py-name">strftime</tt><tt class="py-op">(</tt><tt class="py-string">"%Y-%m-%d"</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
</div><a name="L93"></a><tt class="py-lineno"> 93</tt>  <tt class="py-line"> </tt>
<a name="escape_struct_time"></a><div id="escape_struct_time-def"><a name="L94"></a><tt class="py-lineno"> 94</tt> <a class="py-toggle" href="#" id="escape_struct_time-toggle" onclick="return toggle('escape_struct_time');">-</a><tt class="py-line"><tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.contrib.pymysql.converters-module.html#escape_struct_time">escape_struct_time</a><tt class="py-op">(</tt><tt class="py-param">obj</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="escape_struct_time-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="escape_struct_time-expanded"><a name="L95"></a><tt class="py-lineno"> 95</tt>  <tt class="py-line">    <tt class="py-keyword">return</tt> <tt id="link-42" class="py-name" targets="Function web2py.gluon.contrib.pymysql.converters.escape_datetime()=web2py.gluon.contrib.pymysql.converters-module.html#escape_datetime"><a title="web2py.gluon.contrib.pymysql.converters.escape_datetime" class="py-name" href="#" onclick="return doclink('link-42', 'escape_datetime', 'link-42');">escape_datetime</a></tt><tt class="py-op">(</tt><tt id="link-43" class="py-name"><a title="datetime.datetime" class="py-name" href="#" onclick="return doclink('link-43', 'datetime', 'link-0');">datetime</a></tt><tt class="py-op">.</tt><tt id="link-44" class="py-name"><a title="datetime.datetime" class="py-name" href="#" onclick="return doclink('link-44', 'datetime', 'link-0');">datetime</a></tt><tt class="py-op">(</tt><tt class="py-op">*</tt><tt class="py-name">obj</tt><tt class="py-op">[</tt><tt class="py-op">:</tt><tt class="py-number">6</tt><tt class="py-op">]</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
</div><a name="L96"></a><tt class="py-lineno"> 96</tt>  <tt class="py-line"> </tt>
<a name="convert_datetime"></a><div id="convert_datetime-def"><a name="L97"></a><tt class="py-lineno"> 97</tt> <a class="py-toggle" href="#" id="convert_datetime-toggle" onclick="return toggle('convert_datetime');">-</a><tt class="py-line"><tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.contrib.pymysql.converters-module.html#convert_datetime">convert_datetime</a><tt class="py-op">(</tt><tt class="py-param">connection</tt><tt class="py-op">,</tt> <tt class="py-param">field</tt><tt class="py-op">,</tt> <tt class="py-param">obj</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="convert_datetime-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="convert_datetime-expanded"><a name="L98"></a><tt class="py-lineno"> 98</tt>  <tt class="py-line">    <tt class="py-docstring">"""Returns a DATETIME or TIMESTAMP column value as a datetime object:</tt> </tt>
<a name="L99"></a><tt class="py-lineno"> 99</tt>  <tt class="py-line"><tt class="py-docstring"></tt> </tt>
<a name="L100"></a><tt class="py-lineno">100</tt>  <tt class="py-line"><tt class="py-docstring">      &gt;&gt;&gt; datetime_or_None('2007-02-25 23:06:20')</tt> </tt>
<a name="L101"></a><tt class="py-lineno">101</tt>  <tt class="py-line"><tt class="py-docstring">      datetime.datetime(2007, 2, 25, 23, 6, 20)</tt> </tt>
<a name="L102"></a><tt class="py-lineno">102</tt>  <tt class="py-line"><tt class="py-docstring">      &gt;&gt;&gt; datetime_or_None('2007-02-25T23:06:20')</tt> </tt>
<a name="L103"></a><tt class="py-lineno">103</tt>  <tt class="py-line"><tt class="py-docstring">      datetime.datetime(2007, 2, 25, 23, 6, 20)</tt> </tt>
<a name="L104"></a><tt class="py-lineno">104</tt>  <tt class="py-line"><tt class="py-docstring"></tt> </tt>
<a name="L105"></a><tt class="py-lineno">105</tt>  <tt class="py-line"><tt class="py-docstring">    Illegal values are returned as None:</tt> </tt>
<a name="L106"></a><tt class="py-lineno">106</tt>  <tt class="py-line"><tt class="py-docstring"></tt> </tt>
<a name="L107"></a><tt class="py-lineno">107</tt>  <tt class="py-line"><tt class="py-docstring">      &gt;&gt;&gt; datetime_or_None('2007-02-31T23:06:20') is None</tt> </tt>
<a name="L108"></a><tt class="py-lineno">108</tt>  <tt class="py-line"><tt class="py-docstring">      True</tt> </tt>
<a name="L109"></a><tt class="py-lineno">109</tt>  <tt class="py-line"><tt class="py-docstring">      &gt;&gt;&gt; datetime_or_None('0000-00-00 00:00:00') is None</tt> </tt>
<a name="L110"></a><tt class="py-lineno">110</tt>  <tt class="py-line"><tt class="py-docstring">      True</tt> </tt>
<a name="L111"></a><tt class="py-lineno">111</tt>  <tt class="py-line"><tt class="py-docstring"></tt> </tt>
<a name="L112"></a><tt class="py-lineno">112</tt>  <tt class="py-line"><tt class="py-docstring">    """</tt> </tt>
<a name="L113"></a><tt class="py-lineno">113</tt>  <tt class="py-line">    <tt class="py-keyword">if</tt> <tt class="py-keyword">not</tt> <tt class="py-name">isinstance</tt><tt class="py-op">(</tt><tt class="py-name">obj</tt><tt class="py-op">,</tt> <tt class="py-name">unicode</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L114"></a><tt class="py-lineno">114</tt>  <tt class="py-line">        <tt class="py-name">obj</tt> <tt class="py-op">=</tt> <tt class="py-name">obj</tt><tt class="py-op">.</tt><tt id="link-45" class="py-name"><a title="web2py.gluon.languages.lazyT.decode" class="py-name" href="#" onclick="return doclink('link-45', 'decode', 'link-9');">decode</a></tt><tt class="py-op">(</tt><tt class="py-name">connection</tt><tt class="py-op">.</tt><tt class="py-name">charset</tt><tt class="py-op">)</tt> </tt>
<a name="L115"></a><tt class="py-lineno">115</tt>  <tt class="py-line">    <tt class="py-keyword">if</tt> <tt class="py-string">' '</tt> <tt class="py-keyword">in</tt> <tt class="py-name">obj</tt><tt class="py-op">:</tt> </tt>
<a name="L116"></a><tt class="py-lineno">116</tt>  <tt class="py-line">        <tt class="py-name">sep</tt> <tt class="py-op">=</tt> <tt class="py-string">' '</tt> </tt>
<a name="L117"></a><tt class="py-lineno">117</tt>  <tt class="py-line">    <tt class="py-keyword">elif</tt> <tt class="py-string">'T'</tt> <tt class="py-keyword">in</tt> <tt class="py-name">obj</tt><tt class="py-op">:</tt> </tt>
<a name="L118"></a><tt class="py-lineno">118</tt>  <tt class="py-line">        <tt class="py-name">sep</tt> <tt class="py-op">=</tt> <tt class="py-string">'T'</tt> </tt>
<a name="L119"></a><tt class="py-lineno">119</tt>  <tt class="py-line">    <tt class="py-keyword">else</tt><tt class="py-op">:</tt> </tt>
<a name="L120"></a><tt class="py-lineno">120</tt>  <tt class="py-line">        <tt class="py-keyword">return</tt> <tt id="link-46" class="py-name" targets="Function web2py.gluon.contrib.pymysql.converters.convert_date()=web2py.gluon.contrib.pymysql.converters-module.html#convert_date"><a title="web2py.gluon.contrib.pymysql.converters.convert_date" class="py-name" href="#" onclick="return doclink('link-46', 'convert_date', 'link-46');">convert_date</a></tt><tt class="py-op">(</tt><tt class="py-name">connection</tt><tt class="py-op">,</tt> <tt class="py-name">field</tt><tt class="py-op">,</tt> <tt class="py-name">obj</tt><tt class="py-op">)</tt> </tt>
<a name="L121"></a><tt class="py-lineno">121</tt>  <tt class="py-line"> </tt>
<a name="L122"></a><tt class="py-lineno">122</tt>  <tt class="py-line">    <tt class="py-keyword">try</tt><tt class="py-op">:</tt> </tt>
<a name="L123"></a><tt class="py-lineno">123</tt>  <tt class="py-line">        <tt class="py-name">ymd</tt><tt class="py-op">,</tt> <tt class="py-name">hms</tt> <tt class="py-op">=</tt> <tt class="py-name">obj</tt><tt class="py-op">.</tt><tt class="py-name">split</tt><tt class="py-op">(</tt><tt class="py-name">sep</tt><tt class="py-op">,</tt> <tt class="py-number">1</tt><tt class="py-op">)</tt> </tt>
<a name="L124"></a><tt class="py-lineno">124</tt>  <tt class="py-line">        <tt class="py-keyword">return</tt> <tt id="link-47" class="py-name"><a title="datetime.datetime" class="py-name" href="#" onclick="return doclink('link-47', 'datetime', 'link-0');">datetime</a></tt><tt class="py-op">.</tt><tt id="link-48" class="py-name"><a title="datetime.datetime" class="py-name" href="#" onclick="return doclink('link-48', 'datetime', 'link-0');">datetime</a></tt><tt class="py-op">(</tt><tt class="py-op">*</tt><tt class="py-op">[</tt> <tt class="py-name">int</tt><tt class="py-op">(</tt><tt id="link-49" class="py-name"><a title="sqlite3.dbapi2.x" class="py-name" href="#" onclick="return doclink('link-49', 'x', 'link-18');">x</a></tt><tt class="py-op">)</tt> <tt class="py-keyword">for</tt> <tt id="link-50" class="py-name"><a title="sqlite3.dbapi2.x" class="py-name" href="#" onclick="return doclink('link-50', 'x', 'link-18');">x</a></tt> <tt class="py-keyword">in</tt> <tt class="py-name">ymd</tt><tt class="py-op">.</tt><tt class="py-name">split</tt><tt class="py-op">(</tt><tt class="py-string">'-'</tt><tt class="py-op">)</tt><tt class="py-op">+</tt><tt class="py-name">hms</tt><tt class="py-op">.</tt><tt class="py-name">split</tt><tt class="py-op">(</tt><tt class="py-string">':'</tt><tt class="py-op">)</tt> <tt class="py-op">]</tt><tt class="py-op">)</tt> </tt>
<a name="L125"></a><tt class="py-lineno">125</tt>  <tt class="py-line">    <tt class="py-keyword">except</tt> <tt class="py-name">ValueError</tt><tt class="py-op">:</tt> </tt>
<a name="L126"></a><tt class="py-lineno">126</tt>  <tt class="py-line">        <tt class="py-keyword">return</tt> <tt id="link-51" class="py-name"><a title="web2py.gluon.contrib.pymysql.converters.convert_date" class="py-name" href="#" onclick="return doclink('link-51', 'convert_date', 'link-46');">convert_date</a></tt><tt class="py-op">(</tt><tt class="py-name">connection</tt><tt class="py-op">,</tt> <tt class="py-name">field</tt><tt class="py-op">,</tt> <tt class="py-name">obj</tt><tt class="py-op">)</tt> </tt>
</div><a name="L127"></a><tt class="py-lineno">127</tt>  <tt class="py-line"> </tt>
<a name="convert_timedelta"></a><div id="convert_timedelta-def"><a name="L128"></a><tt class="py-lineno">128</tt> <a class="py-toggle" href="#" id="convert_timedelta-toggle" onclick="return toggle('convert_timedelta');">-</a><tt class="py-line"><tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.contrib.pymysql.converters-module.html#convert_timedelta">convert_timedelta</a><tt class="py-op">(</tt><tt class="py-param">connection</tt><tt class="py-op">,</tt> <tt class="py-param">field</tt><tt class="py-op">,</tt> <tt class="py-param">obj</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="convert_timedelta-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="convert_timedelta-expanded"><a name="L129"></a><tt class="py-lineno">129</tt>  <tt class="py-line">    <tt class="py-docstring">"""Returns a TIME column as a timedelta object:</tt> </tt>
<a name="L130"></a><tt class="py-lineno">130</tt>  <tt class="py-line"><tt class="py-docstring"></tt> </tt>
<a name="L131"></a><tt class="py-lineno">131</tt>  <tt class="py-line"><tt class="py-docstring">      &gt;&gt;&gt; timedelta_or_None('25:06:17')</tt> </tt>
<a name="L132"></a><tt class="py-lineno">132</tt>  <tt class="py-line"><tt class="py-docstring">      datetime.timedelta(1, 3977)</tt> </tt>
<a name="L133"></a><tt class="py-lineno">133</tt>  <tt class="py-line"><tt class="py-docstring">      &gt;&gt;&gt; timedelta_or_None('-25:06:17')</tt> </tt>
<a name="L134"></a><tt class="py-lineno">134</tt>  <tt class="py-line"><tt class="py-docstring">      datetime.timedelta(-2, 83177)</tt> </tt>
<a name="L135"></a><tt class="py-lineno">135</tt>  <tt class="py-line"><tt class="py-docstring"></tt> </tt>
<a name="L136"></a><tt class="py-lineno">136</tt>  <tt class="py-line"><tt class="py-docstring">    Illegal values are returned as None:</tt> </tt>
<a name="L137"></a><tt class="py-lineno">137</tt>  <tt class="py-line"><tt class="py-docstring"></tt> </tt>
<a name="L138"></a><tt class="py-lineno">138</tt>  <tt class="py-line"><tt class="py-docstring">      &gt;&gt;&gt; timedelta_or_None('random crap') is None</tt> </tt>
<a name="L139"></a><tt class="py-lineno">139</tt>  <tt class="py-line"><tt class="py-docstring">      True</tt> </tt>
<a name="L140"></a><tt class="py-lineno">140</tt>  <tt class="py-line"><tt class="py-docstring"></tt> </tt>
<a name="L141"></a><tt class="py-lineno">141</tt>  <tt class="py-line"><tt class="py-docstring">    Note that MySQL always returns TIME columns as (+|-)HH:MM:SS, but</tt> </tt>
<a name="L142"></a><tt class="py-lineno">142</tt>  <tt class="py-line"><tt class="py-docstring">    can accept values as (+|-)DD HH:MM:SS. The latter format will not</tt> </tt>
<a name="L143"></a><tt class="py-lineno">143</tt>  <tt class="py-line"><tt class="py-docstring">    be parsed correctly by this function.</tt> </tt>
<a name="L144"></a><tt class="py-lineno">144</tt>  <tt class="py-line"><tt class="py-docstring">    """</tt> </tt>
<a name="L145"></a><tt class="py-lineno">145</tt>  <tt class="py-line">    <tt class="py-keyword">from</tt> <tt class="py-name">math</tt> <tt class="py-keyword">import</tt> <tt class="py-name">modf</tt> </tt>
<a name="L146"></a><tt class="py-lineno">146</tt>  <tt class="py-line">    <tt class="py-keyword">try</tt><tt class="py-op">:</tt> </tt>
<a name="L147"></a><tt class="py-lineno">147</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-keyword">not</tt> <tt class="py-name">isinstance</tt><tt class="py-op">(</tt><tt class="py-name">obj</tt><tt class="py-op">,</tt> <tt class="py-name">unicode</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L148"></a><tt class="py-lineno">148</tt>  <tt class="py-line">            <tt class="py-name">obj</tt> <tt class="py-op">=</tt> <tt class="py-name">obj</tt><tt class="py-op">.</tt><tt id="link-52" class="py-name"><a title="web2py.gluon.languages.lazyT.decode" class="py-name" href="#" onclick="return doclink('link-52', 'decode', 'link-9');">decode</a></tt><tt class="py-op">(</tt><tt class="py-name">connection</tt><tt class="py-op">.</tt><tt class="py-name">charset</tt><tt class="py-op">)</tt> </tt>
<a name="L149"></a><tt class="py-lineno">149</tt>  <tt class="py-line">        <tt class="py-name">hours</tt><tt class="py-op">,</tt> <tt id="link-53" class="py-name"><a title="web2py.gluon.dal.Expression.minutes" class="py-name" href="#" onclick="return doclink('link-53', 'minutes', 'link-29');">minutes</a></tt><tt class="py-op">,</tt> <tt id="link-54" class="py-name"><a title="web2py.gluon.dal.Expression.seconds" class="py-name" href="#" onclick="return doclink('link-54', 'seconds', 'link-27');">seconds</a></tt> <tt class="py-op">=</tt> <tt class="py-name">tuple</tt><tt class="py-op">(</tt><tt class="py-op">[</tt><tt class="py-name">int</tt><tt class="py-op">(</tt><tt id="link-55" class="py-name"><a title="sqlite3.dbapi2.x" class="py-name" href="#" onclick="return doclink('link-55', 'x', 'link-18');">x</a></tt><tt class="py-op">)</tt> <tt class="py-keyword">for</tt> <tt id="link-56" class="py-name"><a title="sqlite3.dbapi2.x" class="py-name" href="#" onclick="return doclink('link-56', 'x', 'link-18');">x</a></tt> <tt class="py-keyword">in</tt> <tt class="py-name">obj</tt><tt class="py-op">.</tt><tt class="py-name">split</tt><tt class="py-op">(</tt><tt class="py-string">':'</tt><tt class="py-op">)</tt><tt class="py-op">]</tt><tt class="py-op">)</tt> </tt>
<a name="L150"></a><tt class="py-lineno">150</tt>  <tt class="py-line">        <tt class="py-name">tdelta</tt> <tt class="py-op">=</tt> <tt id="link-57" class="py-name"><a title="datetime.datetime" class="py-name" href="#" onclick="return doclink('link-57', 'datetime', 'link-0');">datetime</a></tt><tt class="py-op">.</tt><tt class="py-name">timedelta</tt><tt class="py-op">(</tt> </tt>
<a name="L151"></a><tt class="py-lineno">151</tt>  <tt class="py-line">            <tt class="py-name">hours</tt> <tt class="py-op">=</tt> <tt class="py-name">int</tt><tt class="py-op">(</tt><tt class="py-name">hours</tt><tt class="py-op">)</tt><tt class="py-op">,</tt> </tt>
<a name="L152"></a><tt class="py-lineno">152</tt>  <tt class="py-line">            <tt id="link-58" class="py-name"><a title="web2py.gluon.dal.Expression.minutes" class="py-name" href="#" onclick="return doclink('link-58', 'minutes', 'link-29');">minutes</a></tt> <tt class="py-op">=</tt> <tt class="py-name">int</tt><tt class="py-op">(</tt><tt id="link-59" class="py-name"><a title="web2py.gluon.dal.Expression.minutes" class="py-name" href="#" onclick="return doclink('link-59', 'minutes', 'link-29');">minutes</a></tt><tt class="py-op">)</tt><tt class="py-op">,</tt> </tt>
<a name="L153"></a><tt class="py-lineno">153</tt>  <tt class="py-line">            <tt id="link-60" class="py-name"><a title="web2py.gluon.dal.Expression.seconds" class="py-name" href="#" onclick="return doclink('link-60', 'seconds', 'link-27');">seconds</a></tt> <tt class="py-op">=</tt> <tt class="py-name">int</tt><tt class="py-op">(</tt><tt id="link-61" class="py-name"><a title="web2py.gluon.dal.Expression.seconds" class="py-name" href="#" onclick="return doclink('link-61', 'seconds', 'link-27');">seconds</a></tt><tt class="py-op">)</tt><tt class="py-op">,</tt> </tt>
<a name="L154"></a><tt class="py-lineno">154</tt>  <tt class="py-line">            <tt class="py-name">microseconds</tt> <tt class="py-op">=</tt> <tt class="py-name">int</tt><tt class="py-op">(</tt><tt class="py-name">modf</tt><tt class="py-op">(</tt><tt class="py-name">float</tt><tt class="py-op">(</tt><tt id="link-62" class="py-name"><a title="web2py.gluon.dal.Expression.seconds" class="py-name" href="#" onclick="return doclink('link-62', 'seconds', 'link-27');">seconds</a></tt><tt class="py-op">)</tt><tt class="py-op">)</tt><tt class="py-op">[</tt><tt class="py-number">0</tt><tt class="py-op">]</tt><tt class="py-op">*</tt><tt class="py-number">1000000</tt><tt class="py-op">)</tt><tt class="py-op">,</tt> </tt>
<a name="L155"></a><tt class="py-lineno">155</tt>  <tt class="py-line">            <tt class="py-op">)</tt> </tt>
<a name="L156"></a><tt class="py-lineno">156</tt>  <tt class="py-line">        <tt class="py-keyword">return</tt> <tt class="py-name">tdelta</tt> </tt>
<a name="L157"></a><tt class="py-lineno">157</tt>  <tt class="py-line">    <tt class="py-keyword">except</tt> <tt class="py-name">ValueError</tt><tt class="py-op">:</tt> </tt>
<a name="L158"></a><tt class="py-lineno">158</tt>  <tt class="py-line">        <tt class="py-keyword">return</tt> <tt class="py-name">None</tt> </tt>
</div><a name="L159"></a><tt class="py-lineno">159</tt>  <tt class="py-line"> </tt>
<a name="convert_time"></a><div id="convert_time-def"><a name="L160"></a><tt class="py-lineno">160</tt> <a class="py-toggle" href="#" id="convert_time-toggle" onclick="return toggle('convert_time');">-</a><tt class="py-line"><tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.contrib.pymysql.converters-module.html#convert_time">convert_time</a><tt class="py-op">(</tt><tt class="py-param">connection</tt><tt class="py-op">,</tt> <tt class="py-param">field</tt><tt class="py-op">,</tt> <tt class="py-param">obj</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="convert_time-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="convert_time-expanded"><a name="L161"></a><tt class="py-lineno">161</tt>  <tt class="py-line">    <tt class="py-docstring">"""Returns a TIME column as a time object:</tt> </tt>
<a name="L162"></a><tt class="py-lineno">162</tt>  <tt class="py-line"><tt class="py-docstring"></tt> </tt>
<a name="L163"></a><tt class="py-lineno">163</tt>  <tt class="py-line"><tt class="py-docstring">      &gt;&gt;&gt; time_or_None('15:06:17')</tt> </tt>
<a name="L164"></a><tt class="py-lineno">164</tt>  <tt class="py-line"><tt class="py-docstring">      datetime.time(15, 6, 17)</tt> </tt>
<a name="L165"></a><tt class="py-lineno">165</tt>  <tt class="py-line"><tt class="py-docstring"></tt> </tt>
<a name="L166"></a><tt class="py-lineno">166</tt>  <tt class="py-line"><tt class="py-docstring">    Illegal values are returned as None:</tt> </tt>
<a name="L167"></a><tt class="py-lineno">167</tt>  <tt class="py-line"><tt class="py-docstring"></tt> </tt>
<a name="L168"></a><tt class="py-lineno">168</tt>  <tt class="py-line"><tt class="py-docstring">      &gt;&gt;&gt; time_or_None('-25:06:17') is None</tt> </tt>
<a name="L169"></a><tt class="py-lineno">169</tt>  <tt class="py-line"><tt class="py-docstring">      True</tt> </tt>
<a name="L170"></a><tt class="py-lineno">170</tt>  <tt class="py-line"><tt class="py-docstring">      &gt;&gt;&gt; time_or_None('random crap') is None</tt> </tt>
<a name="L171"></a><tt class="py-lineno">171</tt>  <tt class="py-line"><tt class="py-docstring">      True</tt> </tt>
<a name="L172"></a><tt class="py-lineno">172</tt>  <tt class="py-line"><tt class="py-docstring"></tt> </tt>
<a name="L173"></a><tt class="py-lineno">173</tt>  <tt class="py-line"><tt class="py-docstring">    Note that MySQL always returns TIME columns as (+|-)HH:MM:SS, but</tt> </tt>
<a name="L174"></a><tt class="py-lineno">174</tt>  <tt class="py-line"><tt class="py-docstring">    can accept values as (+|-)DD HH:MM:SS. The latter format will not</tt> </tt>
<a name="L175"></a><tt class="py-lineno">175</tt>  <tt class="py-line"><tt class="py-docstring">    be parsed correctly by this function.</tt> </tt>
<a name="L176"></a><tt class="py-lineno">176</tt>  <tt class="py-line"><tt class="py-docstring"></tt> </tt>
<a name="L177"></a><tt class="py-lineno">177</tt>  <tt class="py-line"><tt class="py-docstring">    Also note that MySQL's TIME column corresponds more closely to</tt> </tt>
<a name="L178"></a><tt class="py-lineno">178</tt>  <tt class="py-line"><tt class="py-docstring">    Python's timedelta and not time. However if you want TIME columns</tt> </tt>
<a name="L179"></a><tt class="py-lineno">179</tt>  <tt class="py-line"><tt class="py-docstring">    to be treated as time-of-day and not a time offset, then you can</tt> </tt>
<a name="L180"></a><tt class="py-lineno">180</tt>  <tt class="py-line"><tt class="py-docstring">    use set this function as the converter for FIELD_TYPE.TIME.</tt> </tt>
<a name="L181"></a><tt class="py-lineno">181</tt>  <tt class="py-line"><tt class="py-docstring">    """</tt> </tt>
<a name="L182"></a><tt class="py-lineno">182</tt>  <tt class="py-line">    <tt class="py-keyword">from</tt> <tt class="py-name">math</tt> <tt class="py-keyword">import</tt> <tt class="py-name">modf</tt> </tt>
<a name="L183"></a><tt class="py-lineno">183</tt>  <tt class="py-line">    <tt class="py-keyword">try</tt><tt class="py-op">:</tt> </tt>
<a name="L184"></a><tt class="py-lineno">184</tt>  <tt class="py-line">        <tt id="link-63" class="py-name"><a title="web2py.gluon.dal.Expression.hour" class="py-name" href="#" onclick="return doclink('link-63', 'hour', 'link-36');">hour</a></tt><tt class="py-op">,</tt> <tt class="py-name">minute</tt><tt class="py-op">,</tt> <tt class="py-name">second</tt> <tt class="py-op">=</tt> <tt class="py-name">obj</tt><tt class="py-op">.</tt><tt class="py-name">split</tt><tt class="py-op">(</tt><tt class="py-string">':'</tt><tt class="py-op">)</tt> </tt>
<a name="L185"></a><tt class="py-lineno">185</tt>  <tt class="py-line">        <tt class="py-keyword">return</tt> <tt id="link-64" class="py-name"><a title="datetime.datetime" class="py-name" href="#" onclick="return doclink('link-64', 'datetime', 'link-0');">datetime</a></tt><tt class="py-op">.</tt><tt id="link-65" class="py-name"><a title="datetime.time" class="py-name" href="#" onclick="return doclink('link-65', 'time', 'link-1');">time</a></tt><tt class="py-op">(</tt><tt id="link-66" class="py-name"><a title="web2py.gluon.dal.Expression.hour" class="py-name" href="#" onclick="return doclink('link-66', 'hour', 'link-36');">hour</a></tt><tt class="py-op">=</tt><tt class="py-name">int</tt><tt class="py-op">(</tt><tt id="link-67" class="py-name"><a title="web2py.gluon.dal.Expression.hour" class="py-name" href="#" onclick="return doclink('link-67', 'hour', 'link-36');">hour</a></tt><tt class="py-op">)</tt><tt class="py-op">,</tt> <tt class="py-name">minute</tt><tt class="py-op">=</tt><tt class="py-name">int</tt><tt class="py-op">(</tt><tt class="py-name">minute</tt><tt class="py-op">)</tt><tt class="py-op">,</tt> </tt>
<a name="L186"></a><tt class="py-lineno">186</tt>  <tt class="py-line">                             <tt class="py-name">second</tt><tt class="py-op">=</tt><tt class="py-name">int</tt><tt class="py-op">(</tt><tt class="py-name">second</tt><tt class="py-op">)</tt><tt class="py-op">,</tt> </tt>
<a name="L187"></a><tt class="py-lineno">187</tt>  <tt class="py-line">                             <tt class="py-name">microsecond</tt><tt class="py-op">=</tt><tt class="py-name">int</tt><tt class="py-op">(</tt><tt class="py-name">modf</tt><tt class="py-op">(</tt><tt class="py-name">float</tt><tt class="py-op">(</tt><tt class="py-name">second</tt><tt class="py-op">)</tt><tt class="py-op">)</tt><tt class="py-op">[</tt><tt class="py-number">0</tt><tt class="py-op">]</tt><tt class="py-op">*</tt><tt class="py-number">1000000</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L188"></a><tt class="py-lineno">188</tt>  <tt class="py-line">    <tt class="py-keyword">except</tt> <tt class="py-name">ValueError</tt><tt class="py-op">:</tt> </tt>
<a name="L189"></a><tt class="py-lineno">189</tt>  <tt class="py-line">        <tt class="py-keyword">return</tt> <tt class="py-name">None</tt> </tt>
</div><a name="L190"></a><tt class="py-lineno">190</tt>  <tt class="py-line"> </tt>
<a name="convert_date"></a><div id="convert_date-def"><a name="L191"></a><tt class="py-lineno">191</tt> <a class="py-toggle" href="#" id="convert_date-toggle" onclick="return toggle('convert_date');">-</a><tt class="py-line"><tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.contrib.pymysql.converters-module.html#convert_date">convert_date</a><tt class="py-op">(</tt><tt class="py-param">connection</tt><tt class="py-op">,</tt> <tt class="py-param">field</tt><tt class="py-op">,</tt> <tt class="py-param">obj</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="convert_date-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="convert_date-expanded"><a name="L192"></a><tt class="py-lineno">192</tt>  <tt class="py-line">    <tt class="py-docstring">"""Returns a DATE column as a date object:</tt> </tt>
<a name="L193"></a><tt class="py-lineno">193</tt>  <tt class="py-line"><tt class="py-docstring"></tt> </tt>
<a name="L194"></a><tt class="py-lineno">194</tt>  <tt class="py-line"><tt class="py-docstring">      &gt;&gt;&gt; date_or_None('2007-02-26')</tt> </tt>
<a name="L195"></a><tt class="py-lineno">195</tt>  <tt class="py-line"><tt class="py-docstring">      datetime.date(2007, 2, 26)</tt> </tt>
<a name="L196"></a><tt class="py-lineno">196</tt>  <tt class="py-line"><tt class="py-docstring"></tt> </tt>
<a name="L197"></a><tt class="py-lineno">197</tt>  <tt class="py-line"><tt class="py-docstring">    Illegal values are returned as None:</tt> </tt>
<a name="L198"></a><tt class="py-lineno">198</tt>  <tt class="py-line"><tt class="py-docstring"></tt> </tt>
<a name="L199"></a><tt class="py-lineno">199</tt>  <tt class="py-line"><tt class="py-docstring">      &gt;&gt;&gt; date_or_None('2007-02-31') is None</tt> </tt>
<a name="L200"></a><tt class="py-lineno">200</tt>  <tt class="py-line"><tt class="py-docstring">      True</tt> </tt>
<a name="L201"></a><tt class="py-lineno">201</tt>  <tt class="py-line"><tt class="py-docstring">      &gt;&gt;&gt; date_or_None('0000-00-00') is None</tt> </tt>
<a name="L202"></a><tt class="py-lineno">202</tt>  <tt class="py-line"><tt class="py-docstring">      True</tt> </tt>
<a name="L203"></a><tt class="py-lineno">203</tt>  <tt class="py-line"><tt class="py-docstring"></tt> </tt>
<a name="L204"></a><tt class="py-lineno">204</tt>  <tt class="py-line"><tt class="py-docstring">    """</tt> </tt>
<a name="L205"></a><tt class="py-lineno">205</tt>  <tt class="py-line">    <tt class="py-keyword">try</tt><tt class="py-op">:</tt> </tt>
<a name="L206"></a><tt class="py-lineno">206</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-keyword">not</tt> <tt class="py-name">isinstance</tt><tt class="py-op">(</tt><tt class="py-name">obj</tt><tt class="py-op">,</tt> <tt class="py-name">unicode</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L207"></a><tt class="py-lineno">207</tt>  <tt class="py-line">            <tt class="py-name">obj</tt> <tt class="py-op">=</tt> <tt class="py-name">obj</tt><tt class="py-op">.</tt><tt id="link-68" class="py-name"><a title="web2py.gluon.languages.lazyT.decode" class="py-name" href="#" onclick="return doclink('link-68', 'decode', 'link-9');">decode</a></tt><tt class="py-op">(</tt><tt class="py-name">connection</tt><tt class="py-op">.</tt><tt class="py-name">charset</tt><tt class="py-op">)</tt> </tt>
<a name="L208"></a><tt class="py-lineno">208</tt>  <tt class="py-line">        <tt class="py-keyword">return</tt> <tt id="link-69" class="py-name"><a title="datetime.datetime" class="py-name" href="#" onclick="return doclink('link-69', 'datetime', 'link-0');">datetime</a></tt><tt class="py-op">.</tt><tt id="link-70" class="py-name" targets="Class datetime.date=datetime.date-class.html"><a title="datetime.date" class="py-name" href="#" onclick="return doclink('link-70', 'date', 'link-70');">date</a></tt><tt class="py-op">(</tt><tt class="py-op">*</tt><tt class="py-op">[</tt> <tt class="py-name">int</tt><tt class="py-op">(</tt><tt id="link-71" class="py-name"><a title="sqlite3.dbapi2.x" class="py-name" href="#" onclick="return doclink('link-71', 'x', 'link-18');">x</a></tt><tt class="py-op">)</tt> <tt class="py-keyword">for</tt> <tt id="link-72" class="py-name"><a title="sqlite3.dbapi2.x" class="py-name" href="#" onclick="return doclink('link-72', 'x', 'link-18');">x</a></tt> <tt class="py-keyword">in</tt> <tt class="py-name">obj</tt><tt class="py-op">.</tt><tt class="py-name">split</tt><tt class="py-op">(</tt><tt class="py-string">'-'</tt><tt class="py-op">,</tt> <tt class="py-number">2</tt><tt class="py-op">)</tt> <tt class="py-op">]</tt><tt class="py-op">)</tt> </tt>
<a name="L209"></a><tt class="py-lineno">209</tt>  <tt class="py-line">    <tt class="py-keyword">except</tt> <tt class="py-name">ValueError</tt><tt class="py-op">:</tt> </tt>
<a name="L210"></a><tt class="py-lineno">210</tt>  <tt class="py-line">        <tt class="py-keyword">return</tt> <tt class="py-name">None</tt> </tt>
</div><a name="L211"></a><tt class="py-lineno">211</tt>  <tt class="py-line"> </tt>
<a name="convert_mysql_timestamp"></a><div id="convert_mysql_timestamp-def"><a name="L212"></a><tt class="py-lineno">212</tt> <a class="py-toggle" href="#" id="convert_mysql_timestamp-toggle" onclick="return toggle('convert_mysql_timestamp');">-</a><tt class="py-line"><tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.contrib.pymysql.converters-module.html#convert_mysql_timestamp">convert_mysql_timestamp</a><tt class="py-op">(</tt><tt class="py-param">connection</tt><tt class="py-op">,</tt> <tt class="py-param">field</tt><tt class="py-op">,</tt> <tt class="py-param">timestamp</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="convert_mysql_timestamp-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="convert_mysql_timestamp-expanded"><a name="L213"></a><tt class="py-lineno">213</tt>  <tt class="py-line">    <tt class="py-docstring">"""Convert a MySQL TIMESTAMP to a Timestamp object.</tt> </tt>
<a name="L214"></a><tt class="py-lineno">214</tt>  <tt class="py-line"><tt class="py-docstring"></tt> </tt>
<a name="L215"></a><tt class="py-lineno">215</tt>  <tt class="py-line"><tt class="py-docstring">    MySQL &gt;= 4.1 returns TIMESTAMP in the same format as DATETIME:</tt> </tt>
<a name="L216"></a><tt class="py-lineno">216</tt>  <tt class="py-line"><tt class="py-docstring"></tt> </tt>
<a name="L217"></a><tt class="py-lineno">217</tt>  <tt class="py-line"><tt class="py-docstring">      &gt;&gt;&gt; mysql_timestamp_converter('2007-02-25 22:32:17')</tt> </tt>
<a name="L218"></a><tt class="py-lineno">218</tt>  <tt class="py-line"><tt class="py-docstring">      datetime.datetime(2007, 2, 25, 22, 32, 17)</tt> </tt>
<a name="L219"></a><tt class="py-lineno">219</tt>  <tt class="py-line"><tt class="py-docstring"></tt> </tt>
<a name="L220"></a><tt class="py-lineno">220</tt>  <tt class="py-line"><tt class="py-docstring">    MySQL &lt; 4.1 uses a big string of numbers:</tt> </tt>
<a name="L221"></a><tt class="py-lineno">221</tt>  <tt class="py-line"><tt class="py-docstring"></tt> </tt>
<a name="L222"></a><tt class="py-lineno">222</tt>  <tt class="py-line"><tt class="py-docstring">      &gt;&gt;&gt; mysql_timestamp_converter('20070225223217')</tt> </tt>
<a name="L223"></a><tt class="py-lineno">223</tt>  <tt class="py-line"><tt class="py-docstring">      datetime.datetime(2007, 2, 25, 22, 32, 17)</tt> </tt>
<a name="L224"></a><tt class="py-lineno">224</tt>  <tt class="py-line"><tt class="py-docstring"></tt> </tt>
<a name="L225"></a><tt class="py-lineno">225</tt>  <tt class="py-line"><tt class="py-docstring">    Illegal values are returned as None:</tt> </tt>
<a name="L226"></a><tt class="py-lineno">226</tt>  <tt class="py-line"><tt class="py-docstring"></tt> </tt>
<a name="L227"></a><tt class="py-lineno">227</tt>  <tt class="py-line"><tt class="py-docstring">      &gt;&gt;&gt; mysql_timestamp_converter('2007-02-31 22:32:17') is None</tt> </tt>
<a name="L228"></a><tt class="py-lineno">228</tt>  <tt class="py-line"><tt class="py-docstring">      True</tt> </tt>
<a name="L229"></a><tt class="py-lineno">229</tt>  <tt class="py-line"><tt class="py-docstring">      &gt;&gt;&gt; mysql_timestamp_converter('00000000000000') is None</tt> </tt>
<a name="L230"></a><tt class="py-lineno">230</tt>  <tt class="py-line"><tt class="py-docstring">      True</tt> </tt>
<a name="L231"></a><tt class="py-lineno">231</tt>  <tt class="py-line"><tt class="py-docstring"></tt> </tt>
<a name="L232"></a><tt class="py-lineno">232</tt>  <tt class="py-line"><tt class="py-docstring">    """</tt> </tt>
<a name="L233"></a><tt class="py-lineno">233</tt>  <tt class="py-line">    <tt class="py-keyword">if</tt> <tt class="py-keyword">not</tt> <tt class="py-name">isinstance</tt><tt class="py-op">(</tt><tt class="py-name">timestamp</tt><tt class="py-op">,</tt> <tt class="py-name">unicode</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L234"></a><tt class="py-lineno">234</tt>  <tt class="py-line">        <tt class="py-name">timestamp</tt> <tt class="py-op">=</tt> <tt class="py-name">timestamp</tt><tt class="py-op">.</tt><tt id="link-73" class="py-name"><a title="web2py.gluon.languages.lazyT.decode" class="py-name" href="#" onclick="return doclink('link-73', 'decode', 'link-9');">decode</a></tt><tt class="py-op">(</tt><tt class="py-name">connection</tt><tt class="py-op">.</tt><tt class="py-name">charset</tt><tt class="py-op">)</tt> </tt>
<a name="L235"></a><tt class="py-lineno">235</tt>  <tt class="py-line"> </tt>
<a name="L236"></a><tt class="py-lineno">236</tt>  <tt class="py-line">    <tt class="py-keyword">if</tt> <tt class="py-name">timestamp</tt><tt class="py-op">[</tt><tt class="py-number">4</tt><tt class="py-op">]</tt> <tt class="py-op">==</tt> <tt class="py-string">'-'</tt><tt class="py-op">:</tt> </tt>
<a name="L237"></a><tt class="py-lineno">237</tt>  <tt class="py-line">        <tt class="py-keyword">return</tt> <tt id="link-74" class="py-name" targets="Function web2py.gluon.contrib.pymysql.converters.convert_datetime()=web2py.gluon.contrib.pymysql.converters-module.html#convert_datetime"><a title="web2py.gluon.contrib.pymysql.converters.convert_datetime" class="py-name" href="#" onclick="return doclink('link-74', 'convert_datetime', 'link-74');">convert_datetime</a></tt><tt class="py-op">(</tt><tt class="py-name">connection</tt><tt class="py-op">,</tt> <tt class="py-name">field</tt><tt class="py-op">,</tt> <tt class="py-name">timestamp</tt><tt class="py-op">)</tt> </tt>
<a name="L238"></a><tt class="py-lineno">238</tt>  <tt class="py-line">    <tt class="py-name">timestamp</tt> <tt class="py-op">+=</tt> <tt class="py-string">"0"</tt><tt class="py-op">*</tt><tt class="py-op">(</tt><tt class="py-number">14</tt><tt class="py-op">-</tt><tt id="link-75" class="py-name" targets="Method web2py.gluon.dal.Expression.len()=web2py.gluon.dal.Expression-class.html#len"><a title="web2py.gluon.dal.Expression.len" class="py-name" href="#" onclick="return doclink('link-75', 'len', 'link-75');">len</a></tt><tt class="py-op">(</tt><tt class="py-name">timestamp</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> <tt class="py-comment"># padding</tt> </tt>
<a name="L239"></a><tt class="py-lineno">239</tt>  <tt class="py-line">    <tt id="link-76" class="py-name" targets="Method web2py.gluon.dal.Expression.year()=web2py.gluon.dal.Expression-class.html#year"><a title="web2py.gluon.dal.Expression.year" class="py-name" href="#" onclick="return doclink('link-76', 'year', 'link-76');">year</a></tt><tt class="py-op">,</tt> <tt id="link-77" class="py-name" targets="Method web2py.gluon.dal.Expression.month()=web2py.gluon.dal.Expression-class.html#month"><a title="web2py.gluon.dal.Expression.month" class="py-name" href="#" onclick="return doclink('link-77', 'month', 'link-77');">month</a></tt><tt class="py-op">,</tt> <tt id="link-78" class="py-name" targets="Method web2py.gluon.dal.Expression.day()=web2py.gluon.dal.Expression-class.html#day"><a title="web2py.gluon.dal.Expression.day" class="py-name" href="#" onclick="return doclink('link-78', 'day', 'link-78');">day</a></tt><tt class="py-op">,</tt> <tt id="link-79" class="py-name"><a title="web2py.gluon.dal.Expression.hour" class="py-name" href="#" onclick="return doclink('link-79', 'hour', 'link-36');">hour</a></tt><tt class="py-op">,</tt> <tt class="py-name">minute</tt><tt class="py-op">,</tt> <tt class="py-name">second</tt> <tt class="py-op">=</tt> \ </tt>
<a name="L240"></a><tt class="py-lineno">240</tt>  <tt class="py-line">        <tt class="py-name">int</tt><tt class="py-op">(</tt><tt class="py-name">timestamp</tt><tt class="py-op">[</tt><tt class="py-op">:</tt><tt class="py-number">4</tt><tt class="py-op">]</tt><tt class="py-op">)</tt><tt class="py-op">,</tt> <tt class="py-name">int</tt><tt class="py-op">(</tt><tt class="py-name">timestamp</tt><tt class="py-op">[</tt><tt class="py-number">4</tt><tt class="py-op">:</tt><tt class="py-number">6</tt><tt class="py-op">]</tt><tt class="py-op">)</tt><tt class="py-op">,</tt> <tt class="py-name">int</tt><tt class="py-op">(</tt><tt class="py-name">timestamp</tt><tt class="py-op">[</tt><tt class="py-number">6</tt><tt class="py-op">:</tt><tt class="py-number">8</tt><tt class="py-op">]</tt><tt class="py-op">)</tt><tt class="py-op">,</tt> \ </tt>
<a name="L241"></a><tt class="py-lineno">241</tt>  <tt class="py-line">        <tt class="py-name">int</tt><tt class="py-op">(</tt><tt class="py-name">timestamp</tt><tt class="py-op">[</tt><tt class="py-number">8</tt><tt class="py-op">:</tt><tt class="py-number">10</tt><tt class="py-op">]</tt><tt class="py-op">)</tt><tt class="py-op">,</tt> <tt class="py-name">int</tt><tt class="py-op">(</tt><tt class="py-name">timestamp</tt><tt class="py-op">[</tt><tt class="py-number">10</tt><tt class="py-op">:</tt><tt class="py-number">12</tt><tt class="py-op">]</tt><tt class="py-op">)</tt><tt class="py-op">,</tt> <tt class="py-name">int</tt><tt class="py-op">(</tt><tt class="py-name">timestamp</tt><tt class="py-op">[</tt><tt class="py-number">12</tt><tt class="py-op">:</tt><tt class="py-number">14</tt><tt class="py-op">]</tt><tt class="py-op">)</tt> </tt>
<a name="L242"></a><tt class="py-lineno">242</tt>  <tt class="py-line">    <tt class="py-keyword">try</tt><tt class="py-op">:</tt> </tt>
<a name="L243"></a><tt class="py-lineno">243</tt>  <tt class="py-line">        <tt class="py-keyword">return</tt> <tt id="link-80" class="py-name"><a title="datetime.datetime" class="py-name" href="#" onclick="return doclink('link-80', 'datetime', 'link-0');">datetime</a></tt><tt class="py-op">.</tt><tt id="link-81" class="py-name"><a title="datetime.datetime" class="py-name" href="#" onclick="return doclink('link-81', 'datetime', 'link-0');">datetime</a></tt><tt class="py-op">(</tt><tt id="link-82" class="py-name"><a title="web2py.gluon.dal.Expression.year" class="py-name" href="#" onclick="return doclink('link-82', 'year', 'link-76');">year</a></tt><tt class="py-op">,</tt> <tt id="link-83" class="py-name"><a title="web2py.gluon.dal.Expression.month" class="py-name" href="#" onclick="return doclink('link-83', 'month', 'link-77');">month</a></tt><tt class="py-op">,</tt> <tt id="link-84" class="py-name"><a title="web2py.gluon.dal.Expression.day" class="py-name" href="#" onclick="return doclink('link-84', 'day', 'link-78');">day</a></tt><tt class="py-op">,</tt> <tt id="link-85" class="py-name"><a title="web2py.gluon.dal.Expression.hour" class="py-name" href="#" onclick="return doclink('link-85', 'hour', 'link-36');">hour</a></tt><tt class="py-op">,</tt> <tt class="py-name">minute</tt><tt class="py-op">,</tt> <tt class="py-name">second</tt><tt class="py-op">)</tt> </tt>
<a name="L244"></a><tt class="py-lineno">244</tt>  <tt class="py-line">    <tt class="py-keyword">except</tt> <tt class="py-name">ValueError</tt><tt class="py-op">:</tt> </tt>
<a name="L245"></a><tt class="py-lineno">245</tt>  <tt class="py-line">        <tt class="py-keyword">return</tt> <tt class="py-name">None</tt> </tt>
</div><a name="L246"></a><tt class="py-lineno">246</tt>  <tt class="py-line"> </tt>
<a name="convert_set"></a><div id="convert_set-def"><a name="L247"></a><tt class="py-lineno">247</tt> <a class="py-toggle" href="#" id="convert_set-toggle" onclick="return toggle('convert_set');">-</a><tt class="py-line"><tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.contrib.pymysql.converters-module.html#convert_set">convert_set</a><tt class="py-op">(</tt><tt class="py-param">s</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="convert_set-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="convert_set-expanded"><a name="L248"></a><tt class="py-lineno">248</tt>  <tt class="py-line">    <tt class="py-keyword">return</tt> <tt class="py-name">set</tt><tt class="py-op">(</tt><tt id="link-86" class="py-name"><a title="web2py.gluon.languages.lazyT.s" class="py-name" href="#" onclick="return doclink('link-86', 's', 'link-35');">s</a></tt><tt class="py-op">.</tt><tt class="py-name">split</tt><tt class="py-op">(</tt><tt class="py-string">","</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
</div><a name="L249"></a><tt class="py-lineno">249</tt>  <tt class="py-line"> </tt>
<a name="convert_bit"></a><div id="convert_bit-def"><a name="L250"></a><tt class="py-lineno">250</tt> <a class="py-toggle" href="#" id="convert_bit-toggle" onclick="return toggle('convert_bit');">-</a><tt class="py-line"><tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.contrib.pymysql.converters-module.html#convert_bit">convert_bit</a><tt class="py-op">(</tt><tt class="py-param">connection</tt><tt class="py-op">,</tt> <tt class="py-param">field</tt><tt class="py-op">,</tt> <tt class="py-param">b</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="convert_bit-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="convert_bit-expanded"><a name="L251"></a><tt class="py-lineno">251</tt>  <tt class="py-line">    <tt class="py-comment">#b = "\x00" * (8 - len(b)) + b # pad w/ zeroes</tt> </tt>
<a name="L252"></a><tt class="py-lineno">252</tt>  <tt class="py-line"><tt class="py-comment"></tt>    <tt class="py-comment">#return struct.unpack("&gt;Q", b)[0]</tt> </tt>
<a name="L253"></a><tt class="py-lineno">253</tt>  <tt class="py-line"><tt class="py-comment"></tt>    <tt class="py-comment">#</tt> </tt>
<a name="L254"></a><tt class="py-lineno">254</tt>  <tt class="py-line"><tt class="py-comment"></tt>    <tt class="py-comment"># the snippet above is right, but MySQLdb doesn't process bits,</tt> </tt>
<a name="L255"></a><tt class="py-lineno">255</tt>  <tt class="py-line"><tt class="py-comment"></tt>    <tt class="py-comment"># so we shouldn't either</tt> </tt>
<a name="L256"></a><tt class="py-lineno">256</tt>  <tt class="py-line"><tt class="py-comment"></tt>    <tt class="py-keyword">return</tt> <tt id="link-87" class="py-name" targets="Function web2py.gluon.rocket.b()=web2py.gluon.rocket-module.html#b"><a title="web2py.gluon.rocket.b" class="py-name" href="#" onclick="return doclink('link-87', 'b', 'link-87');">b</a></tt> </tt>
</div><a name="L257"></a><tt class="py-lineno">257</tt>  <tt class="py-line"> </tt>
<a name="convert_characters"></a><div id="convert_characters-def"><a name="L258"></a><tt class="py-lineno">258</tt> <a class="py-toggle" href="#" id="convert_characters-toggle" onclick="return toggle('convert_characters');">-</a><tt class="py-line"><tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.contrib.pymysql.converters-module.html#convert_characters">convert_characters</a><tt class="py-op">(</tt><tt class="py-param">connection</tt><tt class="py-op">,</tt> <tt class="py-param">field</tt><tt class="py-op">,</tt> <tt class="py-param">data</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="convert_characters-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="convert_characters-expanded"><a name="L259"></a><tt class="py-lineno">259</tt>  <tt class="py-line">    <tt class="py-name">field_charset</tt> <tt class="py-op">=</tt> <tt class="py-name">charset_by_id</tt><tt class="py-op">(</tt><tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">charsetnr</tt><tt class="py-op">)</tt><tt class="py-op">.</tt><tt id="link-88" class="py-name" targets="Variable web2py.gluon.import_all.name=web2py.gluon.import_all-module.html#name"><a title="web2py.gluon.import_all.name" class="py-name" href="#" onclick="return doclink('link-88', 'name', 'link-88');">name</a></tt> </tt>
<a name="L260"></a><tt class="py-lineno">260</tt>  <tt class="py-line">    <tt class="py-keyword">if</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">flags</tt> <tt class="py-op">&amp;</tt> <tt class="py-name">FLAG</tt><tt class="py-op">.</tt><tt id="link-89" class="py-name" targets="Variable web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.SET=web2py.gluon.contrib.pymysql.constants.FIELD_TYPE-module.html#SET"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.SET" class="py-name" href="#" onclick="return doclink('link-89', 'SET', 'link-89');">SET</a></tt><tt class="py-op">:</tt> </tt>
<a name="L261"></a><tt class="py-lineno">261</tt>  <tt class="py-line">        <tt class="py-keyword">return</tt> <tt id="link-90" class="py-name" targets="Function web2py.gluon.contrib.pymysql.converters.convert_set()=web2py.gluon.contrib.pymysql.converters-module.html#convert_set"><a title="web2py.gluon.contrib.pymysql.converters.convert_set" class="py-name" href="#" onclick="return doclink('link-90', 'convert_set', 'link-90');">convert_set</a></tt><tt class="py-op">(</tt><tt class="py-name">data</tt><tt class="py-op">.</tt><tt id="link-91" class="py-name"><a title="web2py.gluon.languages.lazyT.decode" class="py-name" href="#" onclick="return doclink('link-91', 'decode', 'link-9');">decode</a></tt><tt class="py-op">(</tt><tt class="py-name">field_charset</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L262"></a><tt class="py-lineno">262</tt>  <tt class="py-line">    <tt class="py-keyword">if</tt> <tt class="py-name">field</tt><tt class="py-op">.</tt><tt class="py-name">flags</tt> <tt class="py-op">&amp;</tt> <tt class="py-name">FLAG</tt><tt class="py-op">.</tt><tt id="link-92" class="py-name" targets="Variable psycopg2.BINARY=psycopg2-module.html#BINARY,Variable web2py.gluon.contrib.pymysql.BINARY=web2py.gluon.contrib.pymysql-module.html#BINARY"><a title="psycopg2.BINARY
web2py.gluon.contrib.pymysql.BINARY" class="py-name" href="#" onclick="return doclink('link-92', 'BINARY', 'link-92');">BINARY</a></tt><tt class="py-op">:</tt> </tt>
<a name="L263"></a><tt class="py-lineno">263</tt>  <tt class="py-line">        <tt class="py-keyword">return</tt> <tt class="py-name">data</tt> </tt>
<a name="L264"></a><tt class="py-lineno">264</tt>  <tt class="py-line"> </tt>
<a name="L265"></a><tt class="py-lineno">265</tt>  <tt class="py-line">    <tt class="py-keyword">if</tt> <tt class="py-name">connection</tt><tt class="py-op">.</tt><tt class="py-name">use_unicode</tt><tt class="py-op">:</tt> </tt>
<a name="L266"></a><tt class="py-lineno">266</tt>  <tt class="py-line">        <tt class="py-name">data</tt> <tt class="py-op">=</tt> <tt class="py-name">data</tt><tt class="py-op">.</tt><tt id="link-93" class="py-name"><a title="web2py.gluon.languages.lazyT.decode" class="py-name" href="#" onclick="return doclink('link-93', 'decode', 'link-9');">decode</a></tt><tt class="py-op">(</tt><tt class="py-name">field_charset</tt><tt class="py-op">)</tt> </tt>
<a name="L267"></a><tt class="py-lineno">267</tt>  <tt class="py-line">    <tt class="py-keyword">elif</tt> <tt class="py-name">connection</tt><tt class="py-op">.</tt><tt class="py-name">charset</tt> <tt class="py-op">!=</tt> <tt class="py-name">field_charset</tt><tt class="py-op">:</tt> </tt>
<a name="L268"></a><tt class="py-lineno">268</tt>  <tt class="py-line">        <tt class="py-name">data</tt> <tt class="py-op">=</tt> <tt class="py-name">data</tt><tt class="py-op">.</tt><tt id="link-94" class="py-name"><a title="web2py.gluon.languages.lazyT.decode" class="py-name" href="#" onclick="return doclink('link-94', 'decode', 'link-9');">decode</a></tt><tt class="py-op">(</tt><tt class="py-name">field_charset</tt><tt class="py-op">)</tt> </tt>
<a name="L269"></a><tt class="py-lineno">269</tt>  <tt class="py-line">        <tt class="py-name">data</tt> <tt class="py-op">=</tt> <tt class="py-name">data</tt><tt class="py-op">.</tt><tt id="link-95" class="py-name"><a title="web2py.gluon.languages.lazyT.encode" class="py-name" href="#" onclick="return doclink('link-95', 'encode', 'link-11');">encode</a></tt><tt class="py-op">(</tt><tt class="py-name">connection</tt><tt class="py-op">.</tt><tt class="py-name">charset</tt><tt class="py-op">)</tt> </tt>
<a name="L270"></a><tt class="py-lineno">270</tt>  <tt class="py-line">    <tt class="py-keyword">else</tt><tt class="py-op">:</tt> </tt>
<a name="L271"></a><tt class="py-lineno">271</tt>  <tt class="py-line">        <tt class="py-name">data</tt> <tt class="py-op">=</tt> <tt class="py-name">data</tt><tt class="py-op">.</tt><tt id="link-96" class="py-name"><a title="web2py.gluon.languages.lazyT.decode" class="py-name" href="#" onclick="return doclink('link-96', 'decode', 'link-9');">decode</a></tt><tt class="py-op">(</tt><tt class="py-name">connection</tt><tt class="py-op">.</tt><tt class="py-name">charset</tt><tt class="py-op">)</tt> </tt>
<a name="L272"></a><tt class="py-lineno">272</tt>  <tt class="py-line">    <tt class="py-keyword">return</tt> <tt class="py-name">data</tt> </tt>
</div><a name="L273"></a><tt class="py-lineno">273</tt>  <tt class="py-line"> </tt>
<a name="convert_int"></a><div id="convert_int-def"><a name="L274"></a><tt class="py-lineno">274</tt> <a class="py-toggle" href="#" id="convert_int-toggle" onclick="return toggle('convert_int');">-</a><tt class="py-line"><tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.contrib.pymysql.converters-module.html#convert_int">convert_int</a><tt class="py-op">(</tt><tt class="py-param">connection</tt><tt class="py-op">,</tt> <tt class="py-param">field</tt><tt class="py-op">,</tt> <tt class="py-param">data</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="convert_int-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="convert_int-expanded"><a name="L275"></a><tt class="py-lineno">275</tt>  <tt class="py-line">    <tt class="py-keyword">return</tt> <tt class="py-name">int</tt><tt class="py-op">(</tt><tt class="py-name">data</tt><tt class="py-op">)</tt> </tt>
</div><a name="L276"></a><tt class="py-lineno">276</tt>  <tt class="py-line"> </tt>
<a name="convert_long"></a><div id="convert_long-def"><a name="L277"></a><tt class="py-lineno">277</tt> <a class="py-toggle" href="#" id="convert_long-toggle" onclick="return toggle('convert_long');">-</a><tt class="py-line"><tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.contrib.pymysql.converters-module.html#convert_long">convert_long</a><tt class="py-op">(</tt><tt class="py-param">connection</tt><tt class="py-op">,</tt> <tt class="py-param">field</tt><tt class="py-op">,</tt> <tt class="py-param">data</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="convert_long-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="convert_long-expanded"><a name="L278"></a><tt class="py-lineno">278</tt>  <tt class="py-line">    <tt class="py-keyword">return</tt> <tt class="py-name">long</tt><tt class="py-op">(</tt><tt class="py-name">data</tt><tt class="py-op">)</tt> </tt>
</div><a name="L279"></a><tt class="py-lineno">279</tt>  <tt class="py-line"> </tt>
<a name="convert_float"></a><div id="convert_float-def"><a name="L280"></a><tt class="py-lineno">280</tt> <a class="py-toggle" href="#" id="convert_float-toggle" onclick="return toggle('convert_float');">-</a><tt class="py-line"><tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.contrib.pymysql.converters-module.html#convert_float">convert_float</a><tt class="py-op">(</tt><tt class="py-param">connection</tt><tt class="py-op">,</tt> <tt class="py-param">field</tt><tt class="py-op">,</tt> <tt class="py-param">data</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="convert_float-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="convert_float-expanded"><a name="L281"></a><tt class="py-lineno">281</tt>  <tt class="py-line">    <tt class="py-keyword">return</tt> <tt class="py-name">float</tt><tt class="py-op">(</tt><tt class="py-name">data</tt><tt class="py-op">)</tt> </tt>
</div><a name="L282"></a><tt class="py-lineno">282</tt>  <tt class="py-line"> </tt>
<a name="L283"></a><tt class="py-lineno">283</tt>  <tt class="py-line"><tt id="link-97" class="py-name"><a title="web2py.gluon.contrib.pymysql.converters.encoders" class="py-name" href="#" onclick="return doclink('link-97', 'encoders', 'link-10');">encoders</a></tt> <tt class="py-op">=</tt> <tt class="py-op">{</tt> </tt>
<a name="L284"></a><tt class="py-lineno">284</tt>  <tt class="py-line">        <tt class="py-name">bool</tt><tt class="py-op">:</tt> <tt id="link-98" class="py-name" targets="Function web2py.gluon.contrib.pymysql.converters.escape_bool()=web2py.gluon.contrib.pymysql.converters-module.html#escape_bool"><a title="web2py.gluon.contrib.pymysql.converters.escape_bool" class="py-name" href="#" onclick="return doclink('link-98', 'escape_bool', 'link-98');">escape_bool</a></tt><tt class="py-op">,</tt> </tt>
<a name="L285"></a><tt class="py-lineno">285</tt>  <tt class="py-line">        <tt class="py-name">int</tt><tt class="py-op">:</tt> <tt class="py-name">escape_int</tt><tt class="py-op">,</tt> </tt>
<a name="L286"></a><tt class="py-lineno">286</tt>  <tt class="py-line">        <tt class="py-name">long</tt><tt class="py-op">:</tt> <tt class="py-name">escape_long</tt><tt class="py-op">,</tt> </tt>
<a name="L287"></a><tt class="py-lineno">287</tt>  <tt class="py-line">        <tt class="py-name">float</tt><tt class="py-op">:</tt> <tt id="link-99" class="py-name" targets="Function web2py.gluon.contrib.pymysql.converters.escape_float()=web2py.gluon.contrib.pymysql.converters-module.html#escape_float"><a title="web2py.gluon.contrib.pymysql.converters.escape_float" class="py-name" href="#" onclick="return doclink('link-99', 'escape_float', 'link-99');">escape_float</a></tt><tt class="py-op">,</tt> </tt>
<a name="L288"></a><tt class="py-lineno">288</tt>  <tt class="py-line">        <tt class="py-name">str</tt><tt class="py-op">:</tt> <tt id="link-100" class="py-name"><a title="web2py.gluon.contrib.pymysql.converters.escape_string" class="py-name" href="#" onclick="return doclink('link-100', 'escape_string', 'link-26');">escape_string</a></tt><tt class="py-op">,</tt> </tt>
<a name="L289"></a><tt class="py-lineno">289</tt>  <tt class="py-line">        <tt class="py-name">unicode</tt><tt class="py-op">:</tt> <tt id="link-101" class="py-name" targets="Function web2py.gluon.contrib.pymysql.converters.escape_unicode()=web2py.gluon.contrib.pymysql.converters-module.html#escape_unicode,Function web2py.gluon.validators.escape_unicode()=web2py.gluon.validators-module.html#escape_unicode"><a title="web2py.gluon.contrib.pymysql.converters.escape_unicode
web2py.gluon.validators.escape_unicode" class="py-name" href="#" onclick="return doclink('link-101', 'escape_unicode', 'link-101');">escape_unicode</a></tt><tt class="py-op">,</tt> </tt>
<a name="L290"></a><tt class="py-lineno">290</tt>  <tt class="py-line">        <tt class="py-name">tuple</tt><tt class="py-op">:</tt> <tt id="link-102" class="py-name"><a title="web2py.gluon.contrib.pymysql.converters.escape_sequence" class="py-name" href="#" onclick="return doclink('link-102', 'escape_sequence', 'link-7');">escape_sequence</a></tt><tt class="py-op">,</tt> </tt>
<a name="L291"></a><tt class="py-lineno">291</tt>  <tt class="py-line">        <tt class="py-name">list</tt><tt class="py-op">:</tt><tt id="link-103" class="py-name"><a title="web2py.gluon.contrib.pymysql.converters.escape_sequence" class="py-name" href="#" onclick="return doclink('link-103', 'escape_sequence', 'link-7');">escape_sequence</a></tt><tt class="py-op">,</tt> </tt>
<a name="L292"></a><tt class="py-lineno">292</tt>  <tt class="py-line">        <tt class="py-name">set</tt><tt class="py-op">:</tt><tt id="link-104" class="py-name"><a title="web2py.gluon.contrib.pymysql.converters.escape_sequence" class="py-name" href="#" onclick="return doclink('link-104', 'escape_sequence', 'link-7');">escape_sequence</a></tt><tt class="py-op">,</tt> </tt>
<a name="L293"></a><tt class="py-lineno">293</tt>  <tt class="py-line">        <tt class="py-name">dict</tt><tt class="py-op">:</tt><tt id="link-105" class="py-name"><a title="web2py.gluon.contrib.pymysql.converters.escape_dict" class="py-name" href="#" onclick="return doclink('link-105', 'escape_dict', 'link-8');">escape_dict</a></tt><tt class="py-op">,</tt> </tt>
<a name="L294"></a><tt class="py-lineno">294</tt>  <tt class="py-line">        <tt class="py-name">type</tt><tt class="py-op">(</tt><tt class="py-name">None</tt><tt class="py-op">)</tt><tt class="py-op">:</tt><tt id="link-106" class="py-name" targets="Function web2py.gluon.contrib.pymysql.converters.escape_None()=web2py.gluon.contrib.pymysql.converters-module.html#escape_None"><a title="web2py.gluon.contrib.pymysql.converters.escape_None" class="py-name" href="#" onclick="return doclink('link-106', 'escape_None', 'link-106');">escape_None</a></tt><tt class="py-op">,</tt> </tt>
<a name="L295"></a><tt class="py-lineno">295</tt>  <tt class="py-line">        <tt id="link-107" class="py-name"><a title="datetime.datetime" class="py-name" href="#" onclick="return doclink('link-107', 'datetime', 'link-0');">datetime</a></tt><tt class="py-op">.</tt><tt id="link-108" class="py-name"><a title="datetime.date" class="py-name" href="#" onclick="return doclink('link-108', 'date', 'link-70');">date</a></tt><tt class="py-op">:</tt> <tt id="link-109" class="py-name" targets="Function web2py.gluon.contrib.pymysql.converters.escape_date()=web2py.gluon.contrib.pymysql.converters-module.html#escape_date"><a title="web2py.gluon.contrib.pymysql.converters.escape_date" class="py-name" href="#" onclick="return doclink('link-109', 'escape_date', 'link-109');">escape_date</a></tt><tt class="py-op">,</tt> </tt>
<a name="L296"></a><tt class="py-lineno">296</tt>  <tt class="py-line">        <tt id="link-110" class="py-name"><a title="datetime.datetime" class="py-name" href="#" onclick="return doclink('link-110', 'datetime', 'link-0');">datetime</a></tt><tt class="py-op">.</tt><tt id="link-111" class="py-name"><a title="datetime.datetime" class="py-name" href="#" onclick="return doclink('link-111', 'datetime', 'link-0');">datetime</a></tt> <tt class="py-op">:</tt> <tt id="link-112" class="py-name"><a title="web2py.gluon.contrib.pymysql.converters.escape_datetime" class="py-name" href="#" onclick="return doclink('link-112', 'escape_datetime', 'link-42');">escape_datetime</a></tt><tt class="py-op">,</tt> </tt>
<a name="L297"></a><tt class="py-lineno">297</tt>  <tt class="py-line">        <tt id="link-113" class="py-name"><a title="datetime.datetime" class="py-name" href="#" onclick="return doclink('link-113', 'datetime', 'link-0');">datetime</a></tt><tt class="py-op">.</tt><tt class="py-name">timedelta</tt> <tt class="py-op">:</tt> <tt id="link-114" class="py-name" targets="Function web2py.gluon.contrib.pymysql.converters.escape_timedelta()=web2py.gluon.contrib.pymysql.converters-module.html#escape_timedelta"><a title="web2py.gluon.contrib.pymysql.converters.escape_timedelta" class="py-name" href="#" onclick="return doclink('link-114', 'escape_timedelta', 'link-114');">escape_timedelta</a></tt><tt class="py-op">,</tt> </tt>
<a name="L298"></a><tt class="py-lineno">298</tt>  <tt class="py-line">        <tt id="link-115" class="py-name"><a title="datetime.datetime" class="py-name" href="#" onclick="return doclink('link-115', 'datetime', 'link-0');">datetime</a></tt><tt class="py-op">.</tt><tt id="link-116" class="py-name"><a title="datetime.time" class="py-name" href="#" onclick="return doclink('link-116', 'time', 'link-1');">time</a></tt> <tt class="py-op">:</tt> <tt id="link-117" class="py-name" targets="Function web2py.gluon.contrib.pymysql.converters.escape_time()=web2py.gluon.contrib.pymysql.converters-module.html#escape_time"><a title="web2py.gluon.contrib.pymysql.converters.escape_time" class="py-name" href="#" onclick="return doclink('link-117', 'escape_time', 'link-117');">escape_time</a></tt><tt class="py-op">,</tt> </tt>
<a name="L299"></a><tt class="py-lineno">299</tt>  <tt class="py-line">        <tt id="link-118" class="py-name"><a title="datetime.time" class="py-name" href="#" onclick="return doclink('link-118', 'time', 'link-1');">time</a></tt><tt class="py-op">.</tt><tt class="py-name">struct_time</tt> <tt class="py-op">:</tt> <tt id="link-119" class="py-name" targets="Function web2py.gluon.contrib.pymysql.converters.escape_struct_time()=web2py.gluon.contrib.pymysql.converters-module.html#escape_struct_time"><a title="web2py.gluon.contrib.pymysql.converters.escape_struct_time" class="py-name" href="#" onclick="return doclink('link-119', 'escape_struct_time', 'link-119');">escape_struct_time</a></tt><tt class="py-op">,</tt> </tt>
<a name="L300"></a><tt class="py-lineno">300</tt>  <tt class="py-line">        <tt class="py-op">}</tt> </tt>
<a name="L301"></a><tt class="py-lineno">301</tt>  <tt class="py-line"> </tt>
<a name="L302"></a><tt class="py-lineno">302</tt>  <tt class="py-line"><tt id="link-120" class="py-name" targets="Variable web2py.gluon.contrib.pymysql.converters.decoders=web2py.gluon.contrib.pymysql.converters-module.html#decoders"><a title="web2py.gluon.contrib.pymysql.converters.decoders" class="py-name" href="#" onclick="return doclink('link-120', 'decoders', 'link-120');">decoders</a></tt> <tt class="py-op">=</tt> <tt class="py-op">{</tt> </tt>
<a name="L303"></a><tt class="py-lineno">303</tt>  <tt class="py-line">        <tt id="link-121" class="py-name"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE" class="py-name" href="#" onclick="return doclink('link-121', 'FIELD_TYPE', 'link-3');">FIELD_TYPE</a></tt><tt class="py-op">.</tt><tt id="link-122" class="py-name" targets="Variable web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.BIT=web2py.gluon.contrib.pymysql.constants.FIELD_TYPE-module.html#BIT"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.BIT" class="py-name" href="#" onclick="return doclink('link-122', 'BIT', 'link-122');">BIT</a></tt><tt class="py-op">:</tt> <tt id="link-123" class="py-name" targets="Function web2py.gluon.contrib.pymysql.converters.convert_bit()=web2py.gluon.contrib.pymysql.converters-module.html#convert_bit"><a title="web2py.gluon.contrib.pymysql.converters.convert_bit" class="py-name" href="#" onclick="return doclink('link-123', 'convert_bit', 'link-123');">convert_bit</a></tt><tt class="py-op">,</tt> </tt>
<a name="L304"></a><tt class="py-lineno">304</tt>  <tt class="py-line">        <tt id="link-124" class="py-name"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE" class="py-name" href="#" onclick="return doclink('link-124', 'FIELD_TYPE', 'link-3');">FIELD_TYPE</a></tt><tt class="py-op">.</tt><tt id="link-125" class="py-name" targets="Variable web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.TINY=web2py.gluon.contrib.pymysql.constants.FIELD_TYPE-module.html#TINY"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.TINY" class="py-name" href="#" onclick="return doclink('link-125', 'TINY', 'link-125');">TINY</a></tt><tt class="py-op">:</tt> <tt id="link-126" class="py-name" targets="Function web2py.gluon.contrib.pymysql.converters.convert_int()=web2py.gluon.contrib.pymysql.converters-module.html#convert_int"><a title="web2py.gluon.contrib.pymysql.converters.convert_int" class="py-name" href="#" onclick="return doclink('link-126', 'convert_int', 'link-126');">convert_int</a></tt><tt class="py-op">,</tt> </tt>
<a name="L305"></a><tt class="py-lineno">305</tt>  <tt class="py-line">        <tt id="link-127" class="py-name"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE" class="py-name" href="#" onclick="return doclink('link-127', 'FIELD_TYPE', 'link-3');">FIELD_TYPE</a></tt><tt class="py-op">.</tt><tt id="link-128" class="py-name" targets="Variable web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.SHORT=web2py.gluon.contrib.pymysql.constants.FIELD_TYPE-module.html#SHORT"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.SHORT" class="py-name" href="#" onclick="return doclink('link-128', 'SHORT', 'link-128');">SHORT</a></tt><tt class="py-op">:</tt> <tt id="link-129" class="py-name"><a title="web2py.gluon.contrib.pymysql.converters.convert_int" class="py-name" href="#" onclick="return doclink('link-129', 'convert_int', 'link-126');">convert_int</a></tt><tt class="py-op">,</tt> </tt>
<a name="L306"></a><tt class="py-lineno">306</tt>  <tt class="py-line">        <tt id="link-130" class="py-name"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE" class="py-name" href="#" onclick="return doclink('link-130', 'FIELD_TYPE', 'link-3');">FIELD_TYPE</a></tt><tt class="py-op">.</tt><tt id="link-131" class="py-name" targets="Variable web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.LONG=web2py.gluon.contrib.pymysql.constants.FIELD_TYPE-module.html#LONG"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.LONG" class="py-name" href="#" onclick="return doclink('link-131', 'LONG', 'link-131');">LONG</a></tt><tt class="py-op">:</tt> <tt id="link-132" class="py-name" targets="Function web2py.gluon.contrib.pymysql.converters.convert_long()=web2py.gluon.contrib.pymysql.converters-module.html#convert_long"><a title="web2py.gluon.contrib.pymysql.converters.convert_long" class="py-name" href="#" onclick="return doclink('link-132', 'convert_long', 'link-132');">convert_long</a></tt><tt class="py-op">,</tt> </tt>
<a name="L307"></a><tt class="py-lineno">307</tt>  <tt class="py-line">        <tt id="link-133" class="py-name"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE" class="py-name" href="#" onclick="return doclink('link-133', 'FIELD_TYPE', 'link-3');">FIELD_TYPE</a></tt><tt class="py-op">.</tt><tt id="link-134" class="py-name" targets="Variable web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.FLOAT=web2py.gluon.contrib.pymysql.constants.FIELD_TYPE-module.html#FLOAT"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.FLOAT" class="py-name" href="#" onclick="return doclink('link-134', 'FLOAT', 'link-134');">FLOAT</a></tt><tt class="py-op">:</tt> <tt id="link-135" class="py-name" targets="Function web2py.gluon.contrib.pymysql.converters.convert_float()=web2py.gluon.contrib.pymysql.converters-module.html#convert_float"><a title="web2py.gluon.contrib.pymysql.converters.convert_float" class="py-name" href="#" onclick="return doclink('link-135', 'convert_float', 'link-135');">convert_float</a></tt><tt class="py-op">,</tt> </tt>
<a name="L308"></a><tt class="py-lineno">308</tt>  <tt class="py-line">        <tt id="link-136" class="py-name"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE" class="py-name" href="#" onclick="return doclink('link-136', 'FIELD_TYPE', 'link-3');">FIELD_TYPE</a></tt><tt class="py-op">.</tt><tt id="link-137" class="py-name" targets="Variable web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.DOUBLE=web2py.gluon.contrib.pymysql.constants.FIELD_TYPE-module.html#DOUBLE"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.DOUBLE" class="py-name" href="#" onclick="return doclink('link-137', 'DOUBLE', 'link-137');">DOUBLE</a></tt><tt class="py-op">:</tt> <tt id="link-138" class="py-name"><a title="web2py.gluon.contrib.pymysql.converters.convert_float" class="py-name" href="#" onclick="return doclink('link-138', 'convert_float', 'link-135');">convert_float</a></tt><tt class="py-op">,</tt> </tt>
<a name="L309"></a><tt class="py-lineno">309</tt>  <tt class="py-line">        <tt id="link-139" class="py-name"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE" class="py-name" href="#" onclick="return doclink('link-139', 'FIELD_TYPE', 'link-3');">FIELD_TYPE</a></tt><tt class="py-op">.</tt><tt id="link-140" class="py-name" targets="Variable web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.DECIMAL=web2py.gluon.contrib.pymysql.constants.FIELD_TYPE-module.html#DECIMAL"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.DECIMAL" class="py-name" href="#" onclick="return doclink('link-140', 'DECIMAL', 'link-140');">DECIMAL</a></tt><tt class="py-op">:</tt> <tt id="link-141" class="py-name"><a title="web2py.gluon.contrib.pymysql.converters.convert_float" class="py-name" href="#" onclick="return doclink('link-141', 'convert_float', 'link-135');">convert_float</a></tt><tt class="py-op">,</tt> </tt>
<a name="L310"></a><tt class="py-lineno">310</tt>  <tt class="py-line">        <tt id="link-142" class="py-name"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE" class="py-name" href="#" onclick="return doclink('link-142', 'FIELD_TYPE', 'link-3');">FIELD_TYPE</a></tt><tt class="py-op">.</tt><tt id="link-143" class="py-name" targets="Variable web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.NEWDECIMAL=web2py.gluon.contrib.pymysql.constants.FIELD_TYPE-module.html#NEWDECIMAL"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.NEWDECIMAL" class="py-name" href="#" onclick="return doclink('link-143', 'NEWDECIMAL', 'link-143');">NEWDECIMAL</a></tt><tt class="py-op">:</tt> <tt id="link-144" class="py-name"><a title="web2py.gluon.contrib.pymysql.converters.convert_float" class="py-name" href="#" onclick="return doclink('link-144', 'convert_float', 'link-135');">convert_float</a></tt><tt class="py-op">,</tt> </tt>
<a name="L311"></a><tt class="py-lineno">311</tt>  <tt class="py-line">        <tt id="link-145" class="py-name"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE" class="py-name" href="#" onclick="return doclink('link-145', 'FIELD_TYPE', 'link-3');">FIELD_TYPE</a></tt><tt class="py-op">.</tt><tt id="link-146" class="py-name" targets="Variable web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.LONGLONG=web2py.gluon.contrib.pymysql.constants.FIELD_TYPE-module.html#LONGLONG"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.LONGLONG" class="py-name" href="#" onclick="return doclink('link-146', 'LONGLONG', 'link-146');">LONGLONG</a></tt><tt class="py-op">:</tt> <tt id="link-147" class="py-name"><a title="web2py.gluon.contrib.pymysql.converters.convert_long" class="py-name" href="#" onclick="return doclink('link-147', 'convert_long', 'link-132');">convert_long</a></tt><tt class="py-op">,</tt> </tt>
<a name="L312"></a><tt class="py-lineno">312</tt>  <tt class="py-line">        <tt id="link-148" class="py-name"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE" class="py-name" href="#" onclick="return doclink('link-148', 'FIELD_TYPE', 'link-3');">FIELD_TYPE</a></tt><tt class="py-op">.</tt><tt id="link-149" class="py-name" targets="Variable web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.INT24=web2py.gluon.contrib.pymysql.constants.FIELD_TYPE-module.html#INT24"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.INT24" class="py-name" href="#" onclick="return doclink('link-149', 'INT24', 'link-149');">INT24</a></tt><tt class="py-op">:</tt> <tt id="link-150" class="py-name"><a title="web2py.gluon.contrib.pymysql.converters.convert_int" class="py-name" href="#" onclick="return doclink('link-150', 'convert_int', 'link-126');">convert_int</a></tt><tt class="py-op">,</tt> </tt>
<a name="L313"></a><tt class="py-lineno">313</tt>  <tt class="py-line">        <tt id="link-151" class="py-name"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE" class="py-name" href="#" onclick="return doclink('link-151', 'FIELD_TYPE', 'link-3');">FIELD_TYPE</a></tt><tt class="py-op">.</tt><tt id="link-152" class="py-name" targets="Variable web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.YEAR=web2py.gluon.contrib.pymysql.constants.FIELD_TYPE-module.html#YEAR"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.YEAR" class="py-name" href="#" onclick="return doclink('link-152', 'YEAR', 'link-152');">YEAR</a></tt><tt class="py-op">:</tt> <tt id="link-153" class="py-name"><a title="web2py.gluon.contrib.pymysql.converters.convert_int" class="py-name" href="#" onclick="return doclink('link-153', 'convert_int', 'link-126');">convert_int</a></tt><tt class="py-op">,</tt> </tt>
<a name="L314"></a><tt class="py-lineno">314</tt>  <tt class="py-line">        <tt id="link-154" class="py-name"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE" class="py-name" href="#" onclick="return doclink('link-154', 'FIELD_TYPE', 'link-3');">FIELD_TYPE</a></tt><tt class="py-op">.</tt><tt id="link-155" class="py-name" targets="Variable web2py.gluon.contrib.pymysql.TIMESTAMP=web2py.gluon.contrib.pymysql-module.html#TIMESTAMP,Variable web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.TIMESTAMP=web2py.gluon.contrib.pymysql.constants.FIELD_TYPE-module.html#TIMESTAMP"><a title="web2py.gluon.contrib.pymysql.TIMESTAMP
web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.TIMESTAMP" class="py-name" href="#" onclick="return doclink('link-155', 'TIMESTAMP', 'link-155');">TIMESTAMP</a></tt><tt class="py-op">:</tt> <tt id="link-156" class="py-name" targets="Function web2py.gluon.contrib.pymysql.converters.convert_mysql_timestamp()=web2py.gluon.contrib.pymysql.converters-module.html#convert_mysql_timestamp"><a title="web2py.gluon.contrib.pymysql.converters.convert_mysql_timestamp" class="py-name" href="#" onclick="return doclink('link-156', 'convert_mysql_timestamp', 'link-156');">convert_mysql_timestamp</a></tt><tt class="py-op">,</tt> </tt>
<a name="L315"></a><tt class="py-lineno">315</tt>  <tt class="py-line">        <tt id="link-157" class="py-name"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE" class="py-name" href="#" onclick="return doclink('link-157', 'FIELD_TYPE', 'link-3');">FIELD_TYPE</a></tt><tt class="py-op">.</tt><tt id="link-158" class="py-name" targets="Variable psycopg2.DATETIME=psycopg2-module.html#DATETIME,Variable web2py.gluon.contrib.pymysql.DATETIME=web2py.gluon.contrib.pymysql-module.html#DATETIME,Variable web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.DATETIME=web2py.gluon.contrib.pymysql.constants.FIELD_TYPE-module.html#DATETIME"><a title="psycopg2.DATETIME
web2py.gluon.contrib.pymysql.DATETIME
web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.DATETIME" class="py-name" href="#" onclick="return doclink('link-158', 'DATETIME', 'link-158');">DATETIME</a></tt><tt class="py-op">:</tt> <tt id="link-159" class="py-name"><a title="web2py.gluon.contrib.pymysql.converters.convert_datetime" class="py-name" href="#" onclick="return doclink('link-159', 'convert_datetime', 'link-74');">convert_datetime</a></tt><tt class="py-op">,</tt> </tt>
<a name="L316"></a><tt class="py-lineno">316</tt>  <tt class="py-line">        <tt id="link-160" class="py-name"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE" class="py-name" href="#" onclick="return doclink('link-160', 'FIELD_TYPE', 'link-3');">FIELD_TYPE</a></tt><tt class="py-op">.</tt><tt id="link-161" class="py-name" targets="Variable web2py.gluon.contrib.pymysql.TIME=web2py.gluon.contrib.pymysql-module.html#TIME,Variable web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.TIME=web2py.gluon.contrib.pymysql.constants.FIELD_TYPE-module.html#TIME"><a title="web2py.gluon.contrib.pymysql.TIME
web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.TIME" class="py-name" href="#" onclick="return doclink('link-161', 'TIME', 'link-161');">TIME</a></tt><tt class="py-op">:</tt> <tt id="link-162" class="py-name" targets="Function web2py.gluon.contrib.pymysql.converters.convert_timedelta()=web2py.gluon.contrib.pymysql.converters-module.html#convert_timedelta"><a title="web2py.gluon.contrib.pymysql.converters.convert_timedelta" class="py-name" href="#" onclick="return doclink('link-162', 'convert_timedelta', 'link-162');">convert_timedelta</a></tt><tt class="py-op">,</tt> </tt>
<a name="L317"></a><tt class="py-lineno">317</tt>  <tt class="py-line">        <tt id="link-163" class="py-name"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE" class="py-name" href="#" onclick="return doclink('link-163', 'FIELD_TYPE', 'link-3');">FIELD_TYPE</a></tt><tt class="py-op">.</tt><tt id="link-164" class="py-name" targets="Variable web2py.gluon.contrib.pymysql.DATE=web2py.gluon.contrib.pymysql-module.html#DATE,Variable web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.DATE=web2py.gluon.contrib.pymysql.constants.FIELD_TYPE-module.html#DATE"><a title="web2py.gluon.contrib.pymysql.DATE
web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.DATE" class="py-name" href="#" onclick="return doclink('link-164', 'DATE', 'link-164');">DATE</a></tt><tt class="py-op">:</tt> <tt id="link-165" class="py-name"><a title="web2py.gluon.contrib.pymysql.converters.convert_date" class="py-name" href="#" onclick="return doclink('link-165', 'convert_date', 'link-46');">convert_date</a></tt><tt class="py-op">,</tt> </tt>
<a name="L318"></a><tt class="py-lineno">318</tt>  <tt class="py-line">        <tt id="link-166" class="py-name"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE" class="py-name" href="#" onclick="return doclink('link-166', 'FIELD_TYPE', 'link-3');">FIELD_TYPE</a></tt><tt class="py-op">.</tt><tt id="link-167" class="py-name"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.SET" class="py-name" href="#" onclick="return doclink('link-167', 'SET', 'link-89');">SET</a></tt><tt class="py-op">:</tt> <tt id="link-168" class="py-name"><a title="web2py.gluon.contrib.pymysql.converters.convert_set" class="py-name" href="#" onclick="return doclink('link-168', 'convert_set', 'link-90');">convert_set</a></tt><tt class="py-op">,</tt> </tt>
<a name="L319"></a><tt class="py-lineno">319</tt>  <tt class="py-line">        <tt id="link-169" class="py-name"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE" class="py-name" href="#" onclick="return doclink('link-169', 'FIELD_TYPE', 'link-3');">FIELD_TYPE</a></tt><tt class="py-op">.</tt><tt id="link-170" class="py-name" targets="Variable web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.BLOB=web2py.gluon.contrib.pymysql.constants.FIELD_TYPE-module.html#BLOB"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.BLOB" class="py-name" href="#" onclick="return doclink('link-170', 'BLOB', 'link-170');">BLOB</a></tt><tt class="py-op">:</tt> <tt id="link-171" class="py-name" targets="Function web2py.gluon.contrib.pymysql.converters.convert_characters()=web2py.gluon.contrib.pymysql.converters-module.html#convert_characters"><a title="web2py.gluon.contrib.pymysql.converters.convert_characters" class="py-name" href="#" onclick="return doclink('link-171', 'convert_characters', 'link-171');">convert_characters</a></tt><tt class="py-op">,</tt> </tt>
<a name="L320"></a><tt class="py-lineno">320</tt>  <tt class="py-line">        <tt id="link-172" class="py-name"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE" class="py-name" href="#" onclick="return doclink('link-172', 'FIELD_TYPE', 'link-3');">FIELD_TYPE</a></tt><tt class="py-op">.</tt><tt id="link-173" class="py-name" targets="Variable web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.TINY_BLOB=web2py.gluon.contrib.pymysql.constants.FIELD_TYPE-module.html#TINY_BLOB"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.TINY_BLOB" class="py-name" href="#" onclick="return doclink('link-173', 'TINY_BLOB', 'link-173');">TINY_BLOB</a></tt><tt class="py-op">:</tt> <tt id="link-174" class="py-name"><a title="web2py.gluon.contrib.pymysql.converters.convert_characters" class="py-name" href="#" onclick="return doclink('link-174', 'convert_characters', 'link-171');">convert_characters</a></tt><tt class="py-op">,</tt> </tt>
<a name="L321"></a><tt class="py-lineno">321</tt>  <tt class="py-line">        <tt id="link-175" class="py-name"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE" class="py-name" href="#" onclick="return doclink('link-175', 'FIELD_TYPE', 'link-3');">FIELD_TYPE</a></tt><tt class="py-op">.</tt><tt id="link-176" class="py-name" targets="Variable web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.MEDIUM_BLOB=web2py.gluon.contrib.pymysql.constants.FIELD_TYPE-module.html#MEDIUM_BLOB"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.MEDIUM_BLOB" class="py-name" href="#" onclick="return doclink('link-176', 'MEDIUM_BLOB', 'link-176');">MEDIUM_BLOB</a></tt><tt class="py-op">:</tt> <tt id="link-177" class="py-name"><a title="web2py.gluon.contrib.pymysql.converters.convert_characters" class="py-name" href="#" onclick="return doclink('link-177', 'convert_characters', 'link-171');">convert_characters</a></tt><tt class="py-op">,</tt> </tt>
<a name="L322"></a><tt class="py-lineno">322</tt>  <tt class="py-line">        <tt id="link-178" class="py-name"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE" class="py-name" href="#" onclick="return doclink('link-178', 'FIELD_TYPE', 'link-3');">FIELD_TYPE</a></tt><tt class="py-op">.</tt><tt id="link-179" class="py-name" targets="Variable web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.LONG_BLOB=web2py.gluon.contrib.pymysql.constants.FIELD_TYPE-module.html#LONG_BLOB"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.LONG_BLOB" class="py-name" href="#" onclick="return doclink('link-179', 'LONG_BLOB', 'link-179');">LONG_BLOB</a></tt><tt class="py-op">:</tt> <tt id="link-180" class="py-name"><a title="web2py.gluon.contrib.pymysql.converters.convert_characters" class="py-name" href="#" onclick="return doclink('link-180', 'convert_characters', 'link-171');">convert_characters</a></tt><tt class="py-op">,</tt> </tt>
<a name="L323"></a><tt class="py-lineno">323</tt>  <tt class="py-line">        <tt id="link-181" class="py-name"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE" class="py-name" href="#" onclick="return doclink('link-181', 'FIELD_TYPE', 'link-3');">FIELD_TYPE</a></tt><tt class="py-op">.</tt><tt id="link-182" class="py-name" targets="Variable psycopg2.STRING=psycopg2-module.html#STRING,Variable web2py.gluon.contrib.pymysql.STRING=web2py.gluon.contrib.pymysql-module.html#STRING,Variable web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.STRING=web2py.gluon.contrib.pymysql.constants.FIELD_TYPE-module.html#STRING"><a title="psycopg2.STRING
web2py.gluon.contrib.pymysql.STRING
web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.STRING" class="py-name" href="#" onclick="return doclink('link-182', 'STRING', 'link-182');">STRING</a></tt><tt class="py-op">:</tt> <tt id="link-183" class="py-name"><a title="web2py.gluon.contrib.pymysql.converters.convert_characters" class="py-name" href="#" onclick="return doclink('link-183', 'convert_characters', 'link-171');">convert_characters</a></tt><tt class="py-op">,</tt> </tt>
<a name="L324"></a><tt class="py-lineno">324</tt>  <tt class="py-line">        <tt id="link-184" class="py-name"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE" class="py-name" href="#" onclick="return doclink('link-184', 'FIELD_TYPE', 'link-3');">FIELD_TYPE</a></tt><tt class="py-op">.</tt><tt id="link-185" class="py-name" targets="Variable web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.VAR_STRING=web2py.gluon.contrib.pymysql.constants.FIELD_TYPE-module.html#VAR_STRING"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.VAR_STRING" class="py-name" href="#" onclick="return doclink('link-185', 'VAR_STRING', 'link-185');">VAR_STRING</a></tt><tt class="py-op">:</tt> <tt id="link-186" class="py-name"><a title="web2py.gluon.contrib.pymysql.converters.convert_characters" class="py-name" href="#" onclick="return doclink('link-186', 'convert_characters', 'link-171');">convert_characters</a></tt><tt class="py-op">,</tt> </tt>
<a name="L325"></a><tt class="py-lineno">325</tt>  <tt class="py-line">        <tt id="link-187" class="py-name"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE" class="py-name" href="#" onclick="return doclink('link-187', 'FIELD_TYPE', 'link-3');">FIELD_TYPE</a></tt><tt class="py-op">.</tt><tt id="link-188" class="py-name" targets="Variable web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.VARCHAR=web2py.gluon.contrib.pymysql.constants.FIELD_TYPE-module.html#VARCHAR"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.VARCHAR" class="py-name" href="#" onclick="return doclink('link-188', 'VARCHAR', 'link-188');">VARCHAR</a></tt><tt class="py-op">:</tt> <tt id="link-189" class="py-name"><a title="web2py.gluon.contrib.pymysql.converters.convert_characters" class="py-name" href="#" onclick="return doclink('link-189', 'convert_characters', 'link-171');">convert_characters</a></tt><tt class="py-op">,</tt> </tt>
<a name="L326"></a><tt class="py-lineno">326</tt>  <tt class="py-line">        <tt class="py-comment">#FIELD_TYPE.BLOB: str,</tt> </tt>
<a name="L327"></a><tt class="py-lineno">327</tt>  <tt class="py-line">        <tt class="py-comment">#FIELD_TYPE.STRING: str,</tt> </tt>
<a name="L328"></a><tt class="py-lineno">328</tt>  <tt class="py-line">        <tt class="py-comment">#FIELD_TYPE.VAR_STRING: str,</tt> </tt>
<a name="L329"></a><tt class="py-lineno">329</tt>  <tt class="py-line">        <tt class="py-comment">#FIELD_TYPE.VARCHAR: str</tt> </tt>
<a name="L330"></a><tt class="py-lineno">330</tt>  <tt class="py-line">        <tt class="py-op">}</tt> </tt>
<a name="L331"></a><tt class="py-lineno">331</tt>  <tt class="py-line"><tt id="link-190" class="py-name" targets="Variable web2py.gluon.contrib.pymysql.converters.conversions=web2py.gluon.contrib.pymysql.converters-module.html#conversions"><a title="web2py.gluon.contrib.pymysql.converters.conversions" class="py-name" href="#" onclick="return doclink('link-190', 'conversions', 'link-190');">conversions</a></tt> <tt class="py-op">=</tt> <tt id="link-191" class="py-name"><a title="web2py.gluon.contrib.pymysql.converters.decoders" class="py-name" href="#" onclick="return doclink('link-191', 'decoders', 'link-120');">decoders</a></tt>  <tt class="py-comment"># for MySQLdb compatibility</tt> </tt>
<a name="L332"></a><tt class="py-lineno">332</tt>  <tt class="py-line"> </tt>
<a name="L333"></a><tt class="py-lineno">333</tt>  <tt class="py-line"><tt class="py-keyword">try</tt><tt class="py-op">:</tt> </tt>
<a name="L334"></a><tt class="py-lineno">334</tt>  <tt class="py-line">    <tt class="py-comment"># python version &gt; 2.3</tt> </tt>
<a name="L335"></a><tt class="py-lineno">335</tt>  <tt class="py-line"><tt class="py-comment"></tt>    <tt class="py-keyword">from</tt> <tt class="py-name">decimal</tt> <tt class="py-keyword">import</tt> <tt class="py-name">Decimal</tt> </tt>
<a name="convert_decimal"></a><div id="convert_decimal-def"><a name="L336"></a><tt class="py-lineno">336</tt> <a class="py-toggle" href="#" id="convert_decimal-toggle" onclick="return toggle('convert_decimal');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.contrib.pymysql.converters-module.html#convert_decimal">convert_decimal</a><tt class="py-op">(</tt><tt class="py-param">connection</tt><tt class="py-op">,</tt> <tt class="py-param">field</tt><tt class="py-op">,</tt> <tt class="py-param">data</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="convert_decimal-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="convert_decimal-expanded"><a name="L337"></a><tt class="py-lineno">337</tt>  <tt class="py-line">        <tt class="py-keyword">return</tt> <tt class="py-name">Decimal</tt><tt class="py-op">(</tt><tt class="py-name">data</tt><tt class="py-op">)</tt> </tt>
</div><a name="L338"></a><tt class="py-lineno">338</tt>  <tt class="py-line">    <tt id="link-192" class="py-name"><a title="web2py.gluon.contrib.pymysql.converters.decoders" class="py-name" href="#" onclick="return doclink('link-192', 'decoders', 'link-120');">decoders</a></tt><tt class="py-op">[</tt><tt id="link-193" class="py-name"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE" class="py-name" href="#" onclick="return doclink('link-193', 'FIELD_TYPE', 'link-3');">FIELD_TYPE</a></tt><tt class="py-op">.</tt><tt id="link-194" class="py-name"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.DECIMAL" class="py-name" href="#" onclick="return doclink('link-194', 'DECIMAL', 'link-140');">DECIMAL</a></tt><tt class="py-op">]</tt> <tt class="py-op">=</tt> <tt id="link-195" class="py-name" targets="Function web2py.gluon.contrib.pymysql.converters.convert_decimal()=web2py.gluon.contrib.pymysql.converters-module.html#convert_decimal"><a title="web2py.gluon.contrib.pymysql.converters.convert_decimal" class="py-name" href="#" onclick="return doclink('link-195', 'convert_decimal', 'link-195');">convert_decimal</a></tt> </tt>
<a name="L339"></a><tt class="py-lineno">339</tt>  <tt class="py-line">    <tt id="link-196" class="py-name"><a title="web2py.gluon.contrib.pymysql.converters.decoders" class="py-name" href="#" onclick="return doclink('link-196', 'decoders', 'link-120');">decoders</a></tt><tt class="py-op">[</tt><tt id="link-197" class="py-name"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE" class="py-name" href="#" onclick="return doclink('link-197', 'FIELD_TYPE', 'link-3');">FIELD_TYPE</a></tt><tt class="py-op">.</tt><tt id="link-198" class="py-name"><a title="web2py.gluon.contrib.pymysql.constants.FIELD_TYPE.NEWDECIMAL" class="py-name" href="#" onclick="return doclink('link-198', 'NEWDECIMAL', 'link-143');">NEWDECIMAL</a></tt><tt class="py-op">]</tt> <tt class="py-op">=</tt> <tt id="link-199" class="py-name"><a title="web2py.gluon.contrib.pymysql.converters.convert_decimal" class="py-name" href="#" onclick="return doclink('link-199', 'convert_decimal', 'link-195');">convert_decimal</a></tt> </tt>
<a name="L340"></a><tt class="py-lineno">340</tt>  <tt class="py-line"> </tt>
<a name="escape_decimal"></a><div id="escape_decimal-def"><a name="L341"></a><tt class="py-lineno">341</tt> <a class="py-toggle" href="#" id="escape_decimal-toggle" onclick="return toggle('escape_decimal');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="web2py.gluon.contrib.pymysql.converters-module.html#escape_decimal">escape_decimal</a><tt class="py-op">(</tt><tt class="py-param">obj</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="escape_decimal-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="escape_decimal-expanded"><a name="L342"></a><tt class="py-lineno">342</tt>  <tt class="py-line">        <tt class="py-keyword">return</tt> <tt class="py-name">unicode</tt><tt class="py-op">(</tt><tt class="py-name">obj</tt><tt class="py-op">)</tt> </tt>
</div><a name="L343"></a><tt class="py-lineno">343</tt>  <tt class="py-line">    <tt id="link-200" class="py-name"><a title="web2py.gluon.contrib.pymysql.converters.encoders" class="py-name" href="#" onclick="return doclink('link-200', 'encoders', 'link-10');">encoders</a></tt><tt class="py-op">[</tt><tt class="py-name">Decimal</tt><tt class="py-op">]</tt> <tt class="py-op">=</tt> <tt id="link-201" class="py-name" targets="Function web2py.gluon.contrib.pymysql.converters.escape_decimal()=web2py.gluon.contrib.pymysql.converters-module.html#escape_decimal"><a title="web2py.gluon.contrib.pymysql.converters.escape_decimal" class="py-name" href="#" onclick="return doclink('link-201', 'escape_decimal', 'link-201');">escape_decimal</a></tt> </tt>
<a name="L344"></a><tt class="py-lineno">344</tt>  <tt class="py-line"> </tt>
<a name="L345"></a><tt class="py-lineno">345</tt>  <tt class="py-line"><tt class="py-keyword">except</tt> <tt class="py-name">ImportError</tt><tt class="py-op">:</tt> </tt>
<a name="L346"></a><tt class="py-lineno">346</tt>  <tt class="py-line">    <tt class="py-keyword">pass</tt> </tt>
<a name="L347"></a><tt class="py-lineno">347</tt>  <tt class="py-line"> </tt><script type="text/javascript">
<!--
expandto(location.href);
// -->
</script>
</pre>
<br />
<!-- ==================== NAVIGATION BAR ==================== -->
<table class="navbar" border="0" width="100%" cellpadding="0"
       bgcolor="#a0c0ff" cellspacing="0">
  <tr valign="middle">
  <!-- Home link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="web2py.gluon-module.html">Home</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Tree link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="module-tree.html">Trees</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Index link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="identifier-index.html">Indices</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Help link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="help.html">Help</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Project homepage -->
      <th class="navbar" align="right" width="100%">
        <table border="0" cellpadding="0" cellspacing="0">
          <tr><th class="navbar" align="center"
            ><a class="navbar" target="_top" href="http://www.web2py.com">web2py Web Framework</a></th>
          </tr></table></th>
  </tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" width="100%%">
  <tr>
    <td align="left" class="footer">
    Generated by Epydoc 3.0beta1 on Thu Aug  4 00:47:03 2011
    </td>
    <td align="right" class="footer">
      <a href="http://epydoc.sourceforge.net">http://epydoc.sourceforge.net</a>
    </td>
  </tr>
</table>

<script type="text/javascript">
  <!--
  // Private objects are initially displayed (because if
  // javascript is turned off then we want them to be
  // visible); but by default, we want to hide them.  So hide
  // them unless we have a cookie that says to show them.
  checkCookie()
  // -->
</script>
  
</body>
</html>
