OSDN Git Service

(root) / ring-lang-081 / ring.git / blobdiff
? search:
summary | shortlog | log | commit | commitdiff | tree
raw | inline | side by side
タグを打ち忘れていたついでに、html版ドキュメントを追加しました。
[ring-lang-081/ring.git] / docs / build / html / sqlite.html
diff --git a/docs/build/html/sqlite.html b/docs/build/html/sqlite.html
new file mode 100644 (file)
index 0000000..07c9b3d
--- /dev/null
+++ b/docs/build/html/sqlite.html
@@ -0,0 +1,251 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
+  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+
+
+<html xmlns="http://www.w3.org/1999/xhtml">
+  <head>
+    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
+    
+    <title>SQLite 関数 &mdash; プログラミング言語 Ring 1.12 取扱説明書</title>
+    
+    <link rel="stylesheet" href="_static/bootstrap-astropy.css" type="text/css" />
+    <link rel="stylesheet" href="_static/pygments.css" type="text/css" />
+    
+    <script type="text/javascript">
+      var DOCUMENTATION_OPTIONS = {
+        URL_ROOT:    './',
+        VERSION:     '1.12',
+        COLLAPSE_INDEX: false,
+        FILE_SUFFIX: '.html',
+        HAS_SOURCE:  true
+      };
+    </script>
+    <script type="text/javascript" src="_static/jquery.js"></script>
+    <script type="text/javascript" src="_static/underscore.js"></script>
+    <script type="text/javascript" src="_static/doctools.js"></script>
+    <script type="text/javascript" src="_static/translations.js"></script>
+    <link rel="top" title="プログラミング言語 Ring 1.12 取扱説明書" href="index.html" />
+    <link rel="next" title="PostgreSQL 関数" href="postgresql.html" />
+    <link rel="prev" title="MySQL 関数" href="mysql.html" />
+    <link href='https://fonts.googleapis.com/css?family=Source+Sans+Pro:200,600' rel='stylesheet' type='text/css'/>
+
+  </head>
+  <body role="document">
+<div class="topbar">
+  <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>
+  <ul>
+    
+    <li><a href="http://ring-lang.sourceforge.net/news.html">News</a></li>
+    <li><a href="http://ring-lang.sourceforge.net/download.html">Download</a></li>
+    <li><a href="https://groups.google.com/forum/#!forum/ring-lang">Get Help</a></li>
+    <li><a href="https://github.com/ring-lang/ring">Contribute</a></li>
+    <li><a href="http://ring-lang.sourceforge.net/resources.html">Resources</a></li>
+    <li><a href="http://ring-lang.sourceforge.net/team.html">Team</a></li>
+    
+    <li><a title="Ring Homepage" href="http://ring-lang.net/">Website</a></li>
+    <li><a title="総合索引" href="genindex.html">Index</a></li>
+    <li>
+      
+      
+<form action="search.html" method="get">
+  <input type="text" name="q" placeholder="Search" />
+  <input type="hidden" name="check_keywords" value="yes" />
+  <input type="hidden" name="area" value="default" />
+</form>
+      
+    </li>
+  </ul>
+</div>
+
+<div class="related">
+    <h3>ナビゲーション</h3>
+    <ul>
+      <li class="right">
+       <a href="postgresql.html" title="PostgreSQL 関数">
+         next &raquo;
+       </a>
+      </li>
+      <li class="right">
+       <a href="mysql.html" title="MySQL 関数">
+         &laquo; previous
+       </a>
+        |
+      </li>
+      <li>
+       <a href="index.html">プログラミング言語 Ring 1.12 取扱説明書</a>
+        &raquo;
+      </li>
+      
+      <li>SQLite 関数</li> 
+    </ul>
+</div>
+  
+
+    <div class="document">
+      <div class="documentwrapper">
+        <div class="bodywrapper">
+          <div class="body" role="main">
+            
+  <div class="section" id="sqlite">
+<span id="index-0"></span><h1>SQLite 関数<a class="headerlink" href="#sqlite" title="このヘッドラインへのパーマリンク">¶</a></h1>
+<p>SQL データベースの用法を学びます。</p>
+<p>この関数の使用前に sqlitelib.ring ライブラリを読み込みます。</p>
+<div class="highlight-ring"><div class="highlight"><pre><span class="k">load</span> <span class="s">&quot;sqlitelib.ring&quot;</span>
+<span class="c"># SQLite 関数の使用</span>
+</pre></div>
+</div>
+<div class="section" id="sqlite-init">
+<span id="index-1"></span><h2>sqlite_init() 関数<a class="headerlink" href="#sqlite-init" title="このヘッドラインへのパーマリンク">¶</a></h2>
+<p>文法:</p>
+<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>
+</pre></div>
+</div>
+</div>
+<div class="section" id="sqlite-open">
+<span id="index-2"></span><h2>sqlite_open() 関数<a class="headerlink" href="#sqlite-open" title="このヘッドラインへのパーマリンク">¶</a></h2>
+<p>文法:</p>
+<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>
+</pre></div>
+</div>
+</div>
+<div class="section" id="sqlite-execute">
+<span id="index-3"></span><h2>sqlite_execute() 関数<a class="headerlink" href="#sqlite-execute" title="このヘッドラインへのパーマリンク">¶</a></h2>
+<p>文法:</p>
+<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>
+</pre></div>
+</div>
+</div>
+<div class="section" id="sqlite-close">
+<span id="index-4"></span><h2>sqlite_close() 関数<a class="headerlink" href="#sqlite-close" title="このヘッドラインへのパーマリンク">¶</a></h2>
+<p>文法:</p>
+<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>
+</pre></div>
+</div>
+</div>
+<div class="section" id="id1">
+<h2>用例<a class="headerlink" href="#id1" title="このヘッドラインへのパーマリンク">¶</a></h2>
+<p>このコードは SQL データベースの作成を行い、新しいデータを追加した後にデータを表示します。</p>
+<div class="highlight-ring"><div class="highlight"><pre><span class="k">load</span> <span class="s">&quot;sqlitelib.ring&quot;</span>
+
+<span class="n">oSQLite</span> <span class="o">=</span> <span class="n">sqlite_init</span><span class="p">()</span>
+
+<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>
+
+<span class="n">sql</span> <span class="o">=</span> <span class="s">&quot;</span>
+         <span class="n">CREATE</span> <span class="n">TABLE</span> <span class="n">COMPANY</span> <span class="p">(</span>
+         <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>
+         <span class="n">NAME</span>           <span class="n">TEXT</span>    <span class="ow">NOT</span> <span class="kp">NULL</span><span class="p">,</span>
+         <span class="n">AGE</span>            <span class="n">INT</span>     <span class="ow">NOT</span> <span class="kp">NULL</span><span class="p">,</span>
+         <span class="n">ADDRESS</span>        <span class="n">CHAR</span><span class="p">(</span><span class="mi">50</span><span class="p">),</span>
+         <span class="n">SALARY</span>         <span class="n">REAL</span> <span class="p">);</span>
+<span class="s">&quot;</span>
+<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>
+
+<span class="n">sql</span> <span class="o">=</span> <span class="s">&quot;</span>
+        <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>
+        <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>
+                <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>
+                <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>
+                <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>
+<span class="s">&quot;</span>
+
+<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>
+
+<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>
+<span class="k">for</span> <span class="n">x</span> <span class="k">in</span> <span class="n">aResult</span>
+        <span class="k">for</span> <span class="n">t</span> <span class="k">in</span> <span class="n">x</span>
+                <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>
+        <span class="k">next</span>
+<span class="k">next</span>
+<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>
+<span class="k">for</span> <span class="n">x</span> <span class="k">in</span> <span class="n">aResult</span>
+        <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>
+<span class="k">next</span>
+<span class="n">sqlite_close</span><span class="p">(</span><span class="n">oSQLite</span><span class="p">)</span>
+</pre></div>
+</div>
+<p>実行結果:</p>
+<div class="highlight-ring"><div class="highlight"><pre><span class="mi">1</span>
+<span class="n">Mahmoud</span>
+<span class="mi">29</span>
+<span class="n">Jeddah</span>
+<span class="mf">20000.0</span>
+<span class="mi">2</span>
+<span class="n">Ahmed</span>
+<span class="mi">27</span>
+<span class="n">Jeddah</span>
+<span class="mf">15000.0</span>
+<span class="mi">3</span>
+<span class="n">Mohammed</span>
+<span class="mi">31</span>
+<span class="n">Egypt</span>
+<span class="mf">20000.0</span>
+<span class="mi">4</span>
+<span class="n">Ibrahim</span>
+<span class="mi">24</span>
+<span class="n">Egypt</span>
+<span class="mf">65000.0</span>
+<span class="o">**************************************************</span>
+<span class="n">Mahmoud</span>
+<span class="n">Ahmed</span>
+<span class="n">Mohammed</span>
+<span class="n">Ibrahim</span>
+</pre></div>
+</div>
+</div>
+</div>
+
+
+          </div>
+        </div>
+      </div>
+      <div class="sphinxsidebar" role="navigation" aria-label="main navigation">
+        <div class="sphinxsidebarwrapper"><h3>ページの内容</h3>
+<ul>
+<li><a class="reference internal" href="#">SQLite 関数</a><ul>
+<li><a class="reference internal" href="#sqlite-init">sqlite_init() 関数</a></li>
+<li><a class="reference internal" href="#sqlite-open">sqlite_open() 関数</a></li>
+<li><a class="reference internal" href="#sqlite-execute">sqlite_execute() 関数</a></li>
+<li><a class="reference internal" href="#sqlite-close">sqlite_close() 関数</a></li>
+<li><a class="reference internal" href="#id1">用例</a></li>
+</ul>
+</li>
+</ul>
+
+
+  <h4>前のトピックへ</h4>
+  <p class="topless"><a href="mysql.html"
+                        title="前の章へ">MySQL 関数</a></p>
+  <h4>次のトピックへ</h4>
+  <p class="topless"><a href="postgresql.html"
+                        title="次の章へ">PostgreSQL 関数</a></p>
+  <div role="note" aria-label="source link">
+    <h3>このページ</h3>
+    <ul class="this-page-menu">
+      <li><a href="_sources/sqlite.txt"
+            rel="nofollow">ソースコードを表示</a></li>
+    </ul>
+   </div>
+      
+<form action="search.html" method="get">
+  <input type="text" name="q" placeholder="Search" />
+  <input type="hidden" name="check_keywords" value="yes" />
+  <input type="hidden" name="area" value="default" />
+</form>
+      
+        </div>
+      </div>
+      <div class="clearer"></div>
+    </div>
+<footer class="footer">
+  <p class="pull-right">
+    <a href="_sources/sqlite.txt"
+       rel="nofollow">Page Source</a> &nbsp;
+    <a href="#">Back to Top</a></p>
+  <p>
+    &copy; Copyright 2016-2020, Ring Team.<br/>
+    Created using <a href="http://www.sphinx-doc.org/en/stable/">Sphinx</a> 1.3.6. / astropy-sphinx-theme 1.1 (isVowel)
+  </p>
+</footer>
+  </body>
+</html>
\ No newline at end of file
プログラミング言語 Ring 付属説明書の日本語訳＋日本語化キット(インストーラ)の開発
About OSDN
Find Software
Develop Software
Help