docs/build/html/sqlite.html

   1 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
   2   "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
   3
   4
   5 <html xmlns="http://www.w3.org/1999/xhtml">
   6   <head>
   7     <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
   8
   9     <title>SQLite 関数 &mdash; プログラミング言語 Ring 1.12 取扱説明書</title>
  10
  11     <link rel="stylesheet" href="_static/bootstrap-astropy.css" type="text/css" />
  12     <link rel="stylesheet" href="_static/pygments.css" type="text/css" />
  13
  14     <script type="text/javascript">
  15       var DOCUMENTATION_OPTIONS = {
  16         URL_ROOT:    './',
  17         VERSION:     '1.12',
  18         COLLAPSE_INDEX: false,
  19         FILE_SUFFIX: '.html',
  20         HAS_SOURCE:  true
  21       };
  22     </script>
  23     <script type="text/javascript" src="_static/jquery.js"></script>
  24     <script type="text/javascript" src="_static/underscore.js"></script>
  25     <script type="text/javascript" src="_static/doctools.js"></script>
  26     <script type="text/javascript" src="_static/translations.js"></script>
  27     <link rel="top" title="プログラミング言語 Ring 1.12 取扱説明書" href="index.html" />
  28     <link rel="next" title="PostgreSQL 関数" href="postgresql.html" />
  29     <link rel="prev" title="MySQL 関数" href="mysql.html" />
  30     <link href='https://fonts.googleapis.com/css?family=Source+Sans+Pro:200,600' rel='stylesheet' type='text/css'/>
  31
  32   </head>
  33   <body role="document">
  34 <div class="topbar">
  35   <a class="brand" title="Documentation Home" href="index.html"><span id="logotext1">&#x1f369;Ring</span><span id="logotext2"> 1.12</span><span id="logotext3">:docs</span></a>
  36   <ul>
  37
  38     <li><a href="http://ring-lang.sourceforge.net/news.html">News</a></li>
  39     <li><a href="http://ring-lang.sourceforge.net/download.html">Download</a></li>
  40     <li><a href="https://groups.google.com/forum/#!forum/ring-lang">Get Help</a></li>
  41     <li><a href="https://github.com/ring-lang/ring">Contribute</a></li>
  42     <li><a href="http://ring-lang.sourceforge.net/resources.html">Resources</a></li>
  43     <li><a href="http://ring-lang.sourceforge.net/team.html">Team</a></li>
  44
  45     <li><a title="Ring Homepage" href="http://ring-lang.net/">Website</a></li>
  46     <li><a title="総合索引" href="genindex.html">Index</a></li>
  47     <li>
  48
  49
  50 <form action="search.html" method="get">
  51   <input type="text" name="q" placeholder="Search" />
  52   <input type="hidden" name="check_keywords" value="yes" />
  53   <input type="hidden" name="area" value="default" />
  54 </form>
  55
  56     </li>
  57   </ul>
  58 </div>
  59
  60 <div class="related">
  61     <h3>ナビゲーション</h3>
  62     <ul>
  63       <li class="right">
  64         <a href="postgresql.html" title="PostgreSQL 関数">
  65           next &raquo;
  66         </a>
  67       </li>
  68       <li class="right">
  69         <a href="mysql.html" title="MySQL 関数">
  70           &laquo; previous
  71         </a>
  72          |
  73       </li>
  74       <li>
  75         <a href="index.html">プログラミング言語 Ring 1.12 取扱説明書</a>
  76          &raquo;
  77       </li>
  78
  79       <li>SQLite 関数</li>
  80     </ul>
  81 </div>
  82
  83
  84     <div class="document">
  85       <div class="documentwrapper">
  86         <div class="bodywrapper">
  87           <div class="body" role="main">
  88
  89   <div class="section" id="sqlite">
  90 <span id="index-0"></span><h1>SQLite 関数<a class="headerlink" href="#sqlite" title="このヘッドラインへのパーマリンク">¶</a></h1>
  91 <p>SQL データベースの用法を学びます。</p>
  92 <p>この関数の使用前に sqlitelib.ring ライブラリを読み込みます。</p>
  93 <div class="highlight-ring"><div class="highlight"><pre><span class="k">load</span> <span class="s">&quot;sqlitelib.ring&quot;</span>
  94 <span class="c"># SQLite 関数の使用</span>
  95 </pre></div>
  96 </div>
  97 <div class="section" id="sqlite-init">
  98 <span id="index-1"></span><h2>sqlite_init() 関数<a class="headerlink" href="#sqlite-init" title="このヘッドラインへのパーマリンク">¶</a></h2>
  99 <p>文法:</p>
 100 <div class="highlight-ring"><div class="highlight"><pre><span class="n">sqlite_init</span><span class="p">()</span> <span class="o">---&gt;</span> <span class="n">SQLite</span> <span class="n">オブジェクト</span>
 101 </pre></div>
 102 </div>
 103 </div>
 104 <div class="section" id="sqlite-open">
 105 <span id="index-2"></span><h2>sqlite_open() 関数<a class="headerlink" href="#sqlite-open" title="このヘッドラインへのパーマリンク">¶</a></h2>
 106 <p>文法:</p>
 107 <div class="highlight-ring"><div class="highlight"><pre><span class="n">sqlite_open</span><span class="p">(</span><span class="n">SQLite</span> <span class="n">オブジェクト</span><span class="p">,</span><span class="n">cFileName</span><span class="p">)</span>
 108 </pre></div>
 109 </div>
 110 </div>
 111 <div class="section" id="sqlite-execute">
 112 <span id="index-3"></span><h2>sqlite_execute() 関数<a class="headerlink" href="#sqlite-execute" title="このヘッドラインへのパーマリンク">¶</a></h2>
 113 <p>文法:</p>
 114 <div class="highlight-ring"><div class="highlight"><pre><span class="n">sqlite_execute</span><span class="p">(</span><span class="n">SQLite</span> <span class="n">オブジェクト</span><span class="p">,</span><span class="n">cSQLStatement</span><span class="p">)</span>
 115 </pre></div>
 116 </div>
 117 </div>
 118 <div class="section" id="sqlite-close">
 119 <span id="index-4"></span><h2>sqlite_close() 関数<a class="headerlink" href="#sqlite-close" title="このヘッドラインへのパーマリンク">¶</a></h2>
 120 <p>文法:</p>
 121 <div class="highlight-ring"><div class="highlight"><pre><span class="n">sqlite_close</span><span class="p">(</span><span class="n">SQLite</span> <span class="n">オブジェクト</span><span class="p">)</span>
 122 </pre></div>
 123 </div>
 124 </div>
 125 <div class="section" id="id1">
 126 <h2>用例<a class="headerlink" href="#id1" title="このヘッドラインへのパーマリンク">¶</a></h2>
 127 <p>このコードは SQL データベースの作成を行い、新しいデータを追加した後にデータを表示します。</p>
 128 <div class="highlight-ring"><div class="highlight"><pre><span class="k">load</span> <span class="s">&quot;sqlitelib.ring&quot;</span>
 129
 130 <span class="n">oSQLite</span> <span class="o">=</span> <span class="n">sqlite_init</span><span class="p">()</span>
 131
 132 <span class="n">sqlite_open</span><span class="p">(</span><span class="n">oSQLite</span><span class="p">,</span><span class="s">&quot;mytest.db&quot;</span><span class="p">)</span>
 133
 134 <span class="n">sql</span> <span class="o">=</span> <span class="s">&quot;</span>
 135          <span class="n">CREATE</span> <span class="n">TABLE</span> <span class="n">COMPANY</span> <span class="p">(</span>
 136          <span class="n">ID</span> <span class="n">INT</span> <span class="n">PRIMARY</span> <span class="n">KEY</span>     <span class="ow">NOT</span> <span class="kp">NULL</span><span class="p">,</span>
 137          <span class="n">NAME</span>           <span class="n">TEXT</span>    <span class="ow">NOT</span> <span class="kp">NULL</span><span class="p">,</span>
 138          <span class="n">AGE</span>            <span class="n">INT</span>     <span class="ow">NOT</span> <span class="kp">NULL</span><span class="p">,</span>
 139          <span class="n">ADDRESS</span>        <span class="n">CHAR</span><span class="p">(</span><span class="mi">50</span><span class="p">),</span>
 140          <span class="n">SALARY</span>         <span class="n">REAL</span> <span class="p">);</span>
 141 <span class="s">&quot;</span>
 142 <span class="n">sqlite_execute</span><span class="p">(</span><span class="n">oSQLite</span><span class="p">,</span><span class="n">sql</span><span class="p">)</span>
 143
 144 <span class="n">sql</span> <span class="o">=</span> <span class="s">&quot;</span>
 145         <span class="n">INSERT</span> <span class="n">INTO</span> <span class="n">COMPANY</span> <span class="p">(</span><span class="n">ID</span><span class="p">,</span><span class="n">NAME</span><span class="p">,</span><span class="n">AGE</span><span class="p">,</span><span class="n">ADDRESS</span><span class="p">,</span><span class="n">SALARY</span><span class="p">)</span>
 146         <span class="n">VALUES</span>  <span class="p">(</span><span class="mi">1</span><span class="p">,</span> <span class="sc">&#39;Mahmoud&#39;</span> <span class="p">,</span> <span class="mi">29</span><span class="p">,</span> <span class="sc">&#39;Jeddah&#39;</span><span class="p">,</span> <span class="mf">20000.00</span> <span class="p">),</span>
 147                 <span class="p">(</span><span class="mi">2</span><span class="p">,</span> <span class="sc">&#39;Ahmed&#39;</span>   <span class="p">,</span> <span class="mi">27</span><span class="p">,</span> <span class="sc">&#39;Jeddah&#39;</span><span class="p">,</span> <span class="mf">15000.00</span> <span class="p">),</span>
 148                 <span class="p">(</span><span class="mi">3</span><span class="p">,</span> <span class="sc">&#39;Mohammed&#39;</span><span class="p">,</span> <span class="mi">31</span><span class="p">,</span> <span class="sc">&#39;Egypt&#39;</span> <span class="p">,</span> <span class="mf">20000.00</span> <span class="p">),</span>
 149                 <span class="p">(</span><span class="mi">4</span><span class="p">,</span> <span class="sc">&#39;Ibrahim&#39;</span> <span class="p">,</span> <span class="mi">24</span><span class="p">,</span> <span class="sc">&#39;Egypt &#39;</span><span class="p">,</span> <span class="mf">65000.00</span> <span class="p">);</span>
 150 <span class="s">&quot;</span>
 151
 152 <span class="n">sqlite_execute</span><span class="p">(</span><span class="n">oSQLite</span><span class="p">,</span><span class="n">sql</span><span class="p">)</span>
 153
 154 <span class="n">aResult</span> <span class="o">=</span>  <span class="n">sqlite_execute</span><span class="p">(</span><span class="n">oSQLite</span><span class="p">,</span><span class="s">&quot;select * from COMPANY&quot;</span><span class="p">)</span>
 155 <span class="k">for</span> <span class="n">x</span> <span class="k">in</span> <span class="n">aResult</span>
 156         <span class="k">for</span> <span class="n">t</span> <span class="k">in</span> <span class="n">x</span>
 157                 <span class="o">?</span> <span class="n">t</span><span class="o">[</span><span class="mi">2</span><span class="o">]</span> <span class="o">+</span> <span class="n">nl</span>
 158         <span class="k">next</span>
 159 <span class="k">next</span>
 160 <span class="o">?</span> <span class="n">copy</span><span class="p">(</span><span class="s">&quot;*&quot;</span><span class="p">,</span><span class="mi">50</span><span class="p">)</span>
 161 <span class="k">for</span> <span class="n">x</span> <span class="k">in</span> <span class="n">aResult</span>
 162         <span class="o">?</span> <span class="n">x</span><span class="o">[</span><span class="p">:</span><span class="n">name</span><span class="o">]</span>
 163 <span class="k">next</span>
 164 <span class="n">sqlite_close</span><span class="p">(</span><span class="n">oSQLite</span><span class="p">)</span>
 165 </pre></div>
 166 </div>
 167 <p>実行結果:</p>
 168 <div class="highlight-ring"><div class="highlight"><pre><span class="mi">1</span>
 169 <span class="n">Mahmoud</span>
 170 <span class="mi">29</span>
 171 <span class="n">Jeddah</span>
 172 <span class="mf">20000.0</span>
 173 <span class="mi">2</span>
 174 <span class="n">Ahmed</span>
 175 <span class="mi">27</span>
 176 <span class="n">Jeddah</span>
 177 <span class="mf">15000.0</span>
 178 <span class="mi">3</span>
 179 <span class="n">Mohammed</span>
 180 <span class="mi">31</span>
 181 <span class="n">Egypt</span>
 182 <span class="mf">20000.0</span>
 183 <span class="mi">4</span>
 184 <span class="n">Ibrahim</span>
 185 <span class="mi">24</span>
 186 <span class="n">Egypt</span>
 187 <span class="mf">65000.0</span>
 188 <span class="o">**************************************************</span>
 189 <span class="n">Mahmoud</span>
 190 <span class="n">Ahmed</span>
 191 <span class="n">Mohammed</span>
 192 <span class="n">Ibrahim</span>
 193 </pre></div>
 194 </div>
 195 </div>
 196 </div>
 197
 198
 199           </div>
 200         </div>
 201       </div>
 202       <div class="sphinxsidebar" role="navigation" aria-label="main navigation">
 203         <div class="sphinxsidebarwrapper"><h3>ページの内容</h3>
 204 <ul>
 205 <li><a class="reference internal" href="#">SQLite 関数</a><ul>
 206 <li><a class="reference internal" href="#sqlite-init">sqlite_init() 関数</a></li>
 207 <li><a class="reference internal" href="#sqlite-open">sqlite_open() 関数</a></li>
 208 <li><a class="reference internal" href="#sqlite-execute">sqlite_execute() 関数</a></li>
 209 <li><a class="reference internal" href="#sqlite-close">sqlite_close() 関数</a></li>
 210 <li><a class="reference internal" href="#id1">用例</a></li>
 211 </ul>
 212 </li>
 213 </ul>
 214
 215
 216   <h4>前のトピックへ</h4>
 217   <p class="topless"><a href="mysql.html"
 218                         title="前の章へ">MySQL 関数</a></p>
 219   <h4>次のトピックへ</h4>
 220   <p class="topless"><a href="postgresql.html"
 221                         title="次の章へ">PostgreSQL 関数</a></p>
 222   <div role="note" aria-label="source link">
 223     <h3>このページ</h3>
 224     <ul class="this-page-menu">
 225       <li><a href="_sources/sqlite.txt"
 226             rel="nofollow">ソースコードを表示</a></li>
 227     </ul>
 228    </div>
 229
 230 <form action="search.html" method="get">
 231   <input type="text" name="q" placeholder="Search" />
 232   <input type="hidden" name="check_keywords" value="yes" />
 233   <input type="hidden" name="area" value="default" />
 234 </form>
 235
 236         </div>
 237       </div>
 238       <div class="clearer"></div>
 239     </div>
 240 <footer class="footer">
 241   <p class="pull-right">
 242     <a href="_sources/sqlite.txt"
 243        rel="nofollow">Page Source</a> &nbsp;
 244     <a href="#">Back to Top</a></p>
 245   <p>
 246     &copy; Copyright 2016-2020, Ring Team.<br/>
 247     Created using <a href="http://www.sphinx-doc.org/en/stable/">Sphinx</a> 1.3.6. / astropy-sphinx-theme 1.1 (isVowel)
 248   </p>
 249 </footer>
 250   </body>
 251 </html>