<HTML> <HEAD> <!-- Created by texi2html 1.56k + clip patches and <A href="http://www.clip.dia.fi.upm.es/Software">lpdoc</A> from ciao.texi on 28 January 2007 --> <LINK rel="stylesheet" href="ciao.css" type="text/css"> <TITLE>The Ciao Prolog System - Types for the Low-level interface to SQL databases</TITLE> </HEAD> <BODY> Go to the <A HREF="ciao_1.html">first</A>, <A HREF="ciao_153.html">previous</A>, <A HREF="ciao_155.html">next</A>, <A HREF="ciao_241.html">last</A> section, <A HREF="ciao_toc.html">table of contents</A>. <P><HR><P> <H1><A NAME="SEC649" HREF="ciao_toc.html#TOC649">Types for the Low-level interface to SQL databases</A></H1> <P> <A NAME="IDX7314"></A> <P> <STRONG>Author(s):</STRONG> D. Cabeza, M. Carro, I. Caballero, and M. Hermenegildo.. <P> <STRONG>Version:</STRONG> 1.10#7 (2006/4/26, 19:22:13 CEST) <P> <STRONG>Version of last change:</STRONG> 1.9#233 (2003/12/22, 18:8:26 CET) <P> This module implement the types for the low level interface to SQL databases <UL> <LI><A HREF="ciao_154.html#SEC650">Usage and interface (db_client_types)</A> <LI><A HREF="ciao_154.html#SEC651">Documentation on exports (db_client_types)</A> </UL> <H2><A NAME="SEC650" HREF="ciao_toc.html#TOC650">Usage and interface (<CODE>db_client_types</CODE>)</A></H2> <div class="cartouche"> <UL> <LI><STRONG>Library usage:</STRONG> <CODE>:- use_module(library(db_client_types)).</CODE> <LI><STRONG>Exports:</STRONG> <UL> <LI><EM>Regular Types:</EM> <A NAME="IDX7315"></A> <CODE>socketname/1</CODE>, <A NAME="IDX7316"></A> <CODE>dbname/1</CODE>, <A NAME="IDX7317"></A> <CODE>user/1</CODE>, <A NAME="IDX7318"></A> <CODE>passwd/1</CODE>, <A NAME="IDX7319"></A> <CODE>answertableterm/1</CODE>, <A NAME="IDX7320"></A> <CODE>tuple/1</CODE>, <A NAME="IDX7321"></A> <CODE>answertupleterm/1</CODE>, <A NAME="IDX7322"></A> <CODE>sqlstring/1</CODE>. </UL> </UL> </div class="cartouche"> <H2><A NAME="SEC651" HREF="ciao_toc.html#TOC651">Documentation on exports (<CODE>db_client_types</CODE>)</A></H2> <P> <A NAME="IDX7323"></A> <A NAME="IDX7324"></A> <DL> <DT><span class="define">REGTYPE:</span> <B>socketname/1:</B> <DD><A NAME="IDX7325"></A> <PRE> socketname(IPAddress:PortNumber) :- atm(IPAddress), int(PortNumber). </PRE> <P> <STRONG>Usage:</STRONG> <CODE>socketname(IPP)</CODE> <UL> <LI><EM>Description:</EM> <CODE>IPP</CODE> is a structure describing a complete TCP/IP port address. </UL> </DL> <P> <A NAME="IDX7326"></A> <A NAME="IDX7327"></A> <DL> <DT><span class="define">REGTYPE:</span> <B>dbname/1:</B> <DD><A NAME="IDX7328"></A> <PRE> dbname(DBId) :- atm(DBId). </PRE> <P> <STRONG>Usage:</STRONG> <CODE>dbname(DBId)</CODE> <UL> <LI><EM>Description:</EM> <CODE>DBId</CODE> is the identifier of an database. </UL> </DL> <P> <A NAME="IDX7329"></A> <A NAME="IDX7330"></A> <DL> <DT><span class="define">REGTYPE:</span> <B>user/1:</B> <DD><A NAME="IDX7331"></A> <PRE> user(User) :- atm(User). </PRE> <P> <STRONG>Usage:</STRONG> <CODE>user(User)</CODE> <UL> <LI><EM>Description:</EM> <CODE>User</CODE> is a user name in the database. </UL> </DL> <P> <A NAME="IDX7332"></A> <A NAME="IDX7333"></A> <DL> <DT><span class="define">REGTYPE:</span> <B>passwd/1:</B> <DD><A NAME="IDX7334"></A> <PRE> passwd(Passwd) :- atm(Passwd). </PRE> <P> <STRONG>Usage:</STRONG> <CODE>passwd(Passwd)</CODE> <UL> <LI><EM>Description:</EM> <CODE>Passwd</CODE> is the password for the user name in the database. </UL> </DL> <P> <A NAME="IDX7335"></A> <A NAME="IDX7336"></A> <DL> <DT><span class="define">REGTYPE:</span> <B>answertableterm/1:</B> <DD><A NAME="IDX7337"></A> <P> Represents the types of responses that will be returned from the database interface. These can be a set of answer tuples, or the atom <CODE>ok</CODE> in case of a successful addition or deletion. <P> <STRONG>Usage:</STRONG> <CODE>answertableterm(AT)</CODE> <UL> <LI><EM>Description:</EM> <CODE>AT</CODE> is a response from the database interface. </UL> </DL> <P> <A NAME="IDX7338"></A> <A NAME="IDX7339"></A> <DL> <DT><span class="define">REGTYPE:</span> <B>tuple/1:</B> <DD><A NAME="IDX7340"></A> <PRE> tuple(T) :- list(T,atm). </PRE> <P> <STRONG>Usage:</STRONG> <CODE>tuple(T)</CODE> <UL> <LI><EM>Description:</EM> <CODE>T</CODE> is a tuple of values from the database interface. </UL> </DL> <P> <A NAME="IDX7341"></A> <A NAME="IDX7342"></A> <DL> <DT><span class="define">REGTYPE:</span> <B>answertupleterm/1:</B> <DD><A NAME="IDX7343"></A> <PRE> answertupleterm([]). answertupleterm(tup(T)) :- tuple(T). </PRE> <P> <STRONG>Usage:</STRONG> <CODE>answertupleterm(X)</CODE> <UL> <LI><EM>Description:</EM> <CODE>X</CODE> is a predicate containing a tuple. </UL> </DL> <P> <A NAME="IDX7344"></A> <A NAME="IDX7345"></A> <DL> <DT><span class="define">REGTYPE:</span> <B>sqlstring/1:</B> <DD><A NAME="IDX7346"></A> <PRE> sqlstring(S) :- string(S). </PRE> <P> <STRONG>Usage:</STRONG> <CODE>sqlstring(S)</CODE> <UL> <LI><EM>Description:</EM> <CODE>S</CODE> is a string of SQL code. </UL> </DL> <P><HR><P> Go to the <A HREF="ciao_1.html">first</A>, <A HREF="ciao_153.html">previous</A>, <A HREF="ciao_155.html">next</A>, <A HREF="ciao_241.html">last</A> section, <A HREF="ciao_toc.html">table of contents</A>. </BODY> </HTML>