<?xml version="1.0" encoding="UTF-8"?>
<!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" lang="en_US" xml:lang="en_US">
<head>
<title>kabc: resourcesql.cpp Source File (kabc)</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Style-Type" content="text/css" />
<meta http-equiv="pics-label" content='(pics-1.1 "http://www.icra.org/ratingsv02.html" comment "ICRAonline DE v2.0" l gen true for "http://www.kde.org" r (nz 1 vz 1 lz 1 oz 1 cb 1) "http://www.rsac.org/ratingsv01.html" l gen true for "http://www.kde.org" r (n 0 s 0 v 0 l 0))' />
<meta name="trademark" content="KDE e.V." />
<meta name="description" content="K Desktop Environment Homepage, KDE.org" />
<meta name="MSSmartTagsPreventParsing" content="true" />
<meta name="robots" content="all" />
<link rel="shortcut icon" href="../../favicon.ico" />
<link rel="stylesheet" media="screen" type="text/css" title="APIDOX" href="doxygen.css" />
</head>
<body>
<div id="nav_header_top" align="right">
<a href="#content" class="doNotDisplay" accesskey="2">Skip to main content ::</a>
<a href="../.."><img id="nav_header_logo" alt="Home" align="left" src="../../kde_gear_64.png" border="0" /></a>
<span class="doNotDisplay">::</span>
<div id="nav_header_title" align="left">KDE API Reference</div>
</div>
<div id="nav_header_bottom" align="right">
<span class="doNotDisplay">:: <a href="#navigation" accesskey="5">Skip to Link Menu</a><br/></span>
<div id="nav_header_bottom_right" style="text-align: left;">
/ <a href="../..">API Reference</a>
/ <a href=".">kabc</a>
</div>
</div>
<table id="main" border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td valign="top" class="menuheader" height="0"></td>
<td id="contentcolumn" valign="top" rowspan="2" >
<div id="content" style="padding-top: 0px;"><div style="width:100%; margin: 0px; padding: 0px;">
<a name="content"></a>
<!-- Generated by Doxygen 1.7.4 -->
<div class="header">
<div class="headertitle">
<div class="title">resourcesql.cpp</div> </div>
</div>
<div class="contents">
<div class="fragment"><pre class="fragment"><a name="l00001"></a>00001 <span class="comment">/*</span>
<a name="l00002"></a>00002 <span class="comment"> This file is part of libkabc.</span>
<a name="l00003"></a>00003 <span class="comment"> Copyright (c) 2002 Tobias Koenig <tokoe@kde.org></span>
<a name="l00004"></a>00004 <span class="comment"></span>
<a name="l00005"></a>00005 <span class="comment"> This library is free software; you can redistribute it and/or</span>
<a name="l00006"></a>00006 <span class="comment"> modify it under the terms of the GNU Library General Public</span>
<a name="l00007"></a>00007 <span class="comment"> License as published by the Free Software Foundation; either</span>
<a name="l00008"></a>00008 <span class="comment"> version 2 of the License, or (at your option) any later version.</span>
<a name="l00009"></a>00009 <span class="comment"></span>
<a name="l00010"></a>00010 <span class="comment"> This library is distributed in the hope that it will be useful,</span>
<a name="l00011"></a>00011 <span class="comment"> but WITHOUT ANY WARRANTY; without even the implied warranty of</span>
<a name="l00012"></a>00012 <span class="comment"> MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU</span>
<a name="l00013"></a>00013 <span class="comment"> Library General Public License for more details.</span>
<a name="l00014"></a>00014 <span class="comment"></span>
<a name="l00015"></a>00015 <span class="comment"> You should have received a copy of the GNU Library General Public License</span>
<a name="l00016"></a>00016 <span class="comment"> along with this library; see the file COPYING.LIB. If not, write to</span>
<a name="l00017"></a>00017 <span class="comment"> the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor,</span>
<a name="l00018"></a>00018 <span class="comment"> Boston, MA 02110-1301, USA.</span>
<a name="l00019"></a>00019 <span class="comment">*/</span>
<a name="l00020"></a>00020
<a name="l00021"></a>00021 <span class="preprocessor">#include <qsqldatabase.h></span>
<a name="l00022"></a>00022 <span class="preprocessor">#include <qsqlcursor.h></span>
<a name="l00023"></a>00023
<a name="l00024"></a>00024 <span class="preprocessor">#include <kdebug.h></span>
<a name="l00025"></a>00025 <span class="preprocessor">#include <kglobal.h></span>
<a name="l00026"></a>00026 <span class="preprocessor">#include <klineedit.h></span>
<a name="l00027"></a>00027 <span class="preprocessor">#include <<a class="codeRef" doxygen="kdecore.tag:../../kdecore/html/" href="../../kdecore/html/klocale_8h.html">klocale.h</a>></span>
<a name="l00028"></a>00028
<a name="l00029"></a>00029 <span class="preprocessor">#include "resourcesql.h"</span>
<a name="l00030"></a>00030 <span class="preprocessor">#include "resourcesqlconfig.h"</span>
<a name="l00031"></a>00031
<a name="l00032"></a>00032 <span class="keyword">using namespace </span>KABC;
<a name="l00033"></a>00033
<a name="l00034"></a>00034 <span class="keyword">extern</span> <span class="stringliteral">"C"</span>
<a name="l00035"></a>00035 {
<a name="l00036"></a>00036 KDE_EXPORT <span class="keywordtype">void</span> *init_kabc_sql()
<a name="l00037"></a>00037 {
<a name="l00038"></a>00038 <span class="keywordflow">return</span> <span class="keyword">new</span> KRES::PluginFactory<ResourceSql,ResourceSqlConfig>();
<a name="l00039"></a>00039 }
<a name="l00040"></a>00040 }
<a name="l00041"></a>00041
<a name="l00042"></a>00042 ResourceSql::ResourceSql( <a class="code" href="classKABC_1_1AddressBook.html" title="Address Book.">AddressBook</a> *ab, <span class="keyword">const</span> <a class="codeRef" doxygen="kdecore.tag:../../kdecore/html/" href="../../kdecore/html/classKConfig.html">KConfig</a> *config )
<a name="l00043"></a>00043 : Resource( ab ), mDb( 0 )
<a name="l00044"></a>00044 {
<a name="l00045"></a>00045 <a class="codeRef" href="qstring.html">QString</a> user, password, db, host;
<a name="l00046"></a>00046
<a name="l00047"></a>00047 user = config-><a class="codeRef" doxygen="kdecore.tag:../../kdecore/html/" href="../../kdecore/html/classKConfigBase.html#a955d1210aeb86d7ec5265557333ab338">readEntry</a>( <span class="stringliteral">"SqlUser"</span> );
<a name="l00048"></a>00048 password = cryptStr( config-><a class="codeRef" doxygen="kdecore.tag:../../kdecore/html/" href="../../kdecore/html/classKConfigBase.html#a955d1210aeb86d7ec5265557333ab338">readEntry</a>( <span class="stringliteral">"SqlPassword "</span> ) );
<a name="l00049"></a>00049 db = config-><a class="codeRef" doxygen="kdecore.tag:../../kdecore/html/" href="../../kdecore/html/classKConfigBase.html#a955d1210aeb86d7ec5265557333ab338">readEntry</a>( <span class="stringliteral">"SqlName"</span> );
<a name="l00050"></a>00050 host = config-><a class="codeRef" doxygen="kdecore.tag:../../kdecore/html/" href="../../kdecore/html/classKConfigBase.html#a955d1210aeb86d7ec5265557333ab338">readEntry</a>( <span class="stringliteral">"SqlHost"</span> );
<a name="l00051"></a>00051
<a name="l00052"></a>00052 init( user, password, db, host );
<a name="l00053"></a>00053 }
<a name="l00054"></a>00054
<a name="l00055"></a>00055 ResourceSql::ResourceSql( <a class="code" href="classKABC_1_1AddressBook.html" title="Address Book.">AddressBook</a> *ab, <span class="keyword">const</span> <a class="codeRef" href="qstring.html">QString</a> &user,
<a name="l00056"></a>00056 <span class="keyword">const</span> <a class="codeRef" href="qstring.html">QString</a> &password, <span class="keyword">const</span> <a class="codeRef" href="qstring.html">QString</a> &db, <span class="keyword">const</span> <a class="codeRef" href="qstring.html">QString</a> &host )
<a name="l00057"></a>00057 : Resource( ab ), mDb( 0 )
<a name="l00058"></a>00058 {
<a name="l00059"></a>00059 init( user, password, db, host );
<a name="l00060"></a>00060 }
<a name="l00061"></a>00061
<a name="l00062"></a>00062 <span class="keywordtype">void</span> ResourceSql::init( <span class="keyword">const</span> <a class="codeRef" href="qstring.html">QString</a> &user, <span class="keyword">const</span> <a class="codeRef" href="qstring.html">QString</a> &password,
<a name="l00063"></a>00063 <span class="keyword">const</span> <a class="codeRef" href="qstring.html">QString</a> &db, <span class="keyword">const</span> <a class="codeRef" href="qstring.html">QString</a> &host )
<a name="l00064"></a>00064 {
<a name="l00065"></a>00065 mUser = user;
<a name="l00066"></a>00066 mPassword = password;
<a name="l00067"></a>00067 mDbName = db;
<a name="l00068"></a>00068 mHost = host;
<a name="l00069"></a>00069 }
<a name="l00070"></a>00070
<a name="l00071"></a>00071 <a class="code" href="classKABC_1_1Ticket.html" title="Helper class for handling coordinated save of address books.">Ticket</a> *ResourceSql::requestSaveTicket()
<a name="l00072"></a>00072 {
<a name="l00073"></a>00073 <span class="keywordflow">if</span> ( !addressBook() ) {
<a name="l00074"></a>00074 <a class="codeRef" doxygen="kdecore.tag:../../kdecore/html/" href="../../kdecore/html/group__kdebug.html#gafbb9aa4a84d6c0563d46550454b9714b">kdDebug</a>(5700) << <span class="stringliteral">"no addressbook"</span> << <a class="codeRef" doxygen="kdecore.tag:../../kdecore/html/" href="../../kdecore/html/group__kdebug.html#ga313d520ed8f8f6b46eeef22cfb3b082a">endl</a>;
<a name="l00075"></a>00075 <span class="keywordflow">return</span> 0;
<a name="l00076"></a>00076 }
<a name="l00077"></a>00077
<a name="l00078"></a>00078 <span class="keywordflow">return</span> createTicket( <span class="keyword">this</span> );
<a name="l00079"></a>00079 }
<a name="l00080"></a>00080
<a name="l00081"></a>00081 <span class="keywordtype">bool</span> ResourceSql::open()
<a name="l00082"></a>00082 {
<a name="l00083"></a>00083 <a class="codeRef" href="qstringlist.html">QStringList</a> drivers = <a class="codeRef" href="qsqldatabase.html#drivers">QSqlDatabase::drivers</a>();
<a name="l00084"></a>00084 <span class="keywordflow">for</span> ( QStringList::Iterator it = drivers.begin(); it != drivers.end(); ++it ) {
<a name="l00085"></a>00085 <a class="codeRef" doxygen="kdecore.tag:../../kdecore/html/" href="../../kdecore/html/group__kdebug.html#gafbb9aa4a84d6c0563d46550454b9714b">kdDebug</a>(5700) << <span class="stringliteral">"Driver: "</span> << (*it) << <a class="codeRef" doxygen="kdecore.tag:../../kdecore/html/" href="../../kdecore/html/group__kdebug.html#ga313d520ed8f8f6b46eeef22cfb3b082a">endl</a>;
<a name="l00086"></a>00086 }
<a name="l00087"></a>00087
<a name="l00088"></a>00088 mDb = <a class="codeRef" href="qsqldatabase.html#addDatabase">QSqlDatabase::addDatabase</a>( <span class="stringliteral">"QMYSQL3"</span> );
<a name="l00089"></a>00089
<a name="l00090"></a>00090 <span class="keywordflow">if</span> ( !mDb ) {
<a name="l00091"></a>00091 <a class="codeRef" doxygen="kdecore.tag:../../kdecore/html/" href="../../kdecore/html/group__kdebug.html#gafbb9aa4a84d6c0563d46550454b9714b">kdDebug</a>(5700) << <span class="stringliteral">"Error. Unable to connect to database."</span> << <a class="codeRef" doxygen="kdecore.tag:../../kdecore/html/" href="../../kdecore/html/group__kdebug.html#ga313d520ed8f8f6b46eeef22cfb3b082a">endl</a>;
<a name="l00092"></a>00092 <span class="keywordflow">return</span> <span class="keyword">false</span>;
<a name="l00093"></a>00093 }
<a name="l00094"></a>00094
<a name="l00095"></a>00095 mDb->setDatabaseName( mDbName );
<a name="l00096"></a>00096 mDb->setUserName( mUser );
<a name="l00097"></a>00097 mDb->setPassword( mPassword );
<a name="l00098"></a>00098 mDb->setHostName( mHost );
<a name="l00099"></a>00099
<a name="l00100"></a>00100 <span class="keywordflow">if</span> ( !mDb->open() ) {
<a name="l00101"></a>00101 <a class="codeRef" doxygen="kdecore.tag:../../kdecore/html/" href="../../kdecore/html/group__kdebug.html#gafbb9aa4a84d6c0563d46550454b9714b">kdDebug</a>(5700) << <span class="stringliteral">"Error. Unable to open database '"</span> << mDbName << <span class="stringliteral">"'."</span> << <a class="codeRef" doxygen="kdecore.tag:../../kdecore/html/" href="../../kdecore/html/group__kdebug.html#ga313d520ed8f8f6b46eeef22cfb3b082a">endl</a>;
<a name="l00102"></a>00102 <span class="keywordflow">return</span> <span class="keyword">false</span>;
<a name="l00103"></a>00103 }
<a name="l00104"></a>00104
<a name="l00105"></a>00105 <span class="keywordflow">return</span> <span class="keyword">true</span>;
<a name="l00106"></a>00106 }
<a name="l00107"></a>00107
<a name="l00108"></a>00108 <span class="keywordtype">void</span> ResourceSql::close()
<a name="l00109"></a>00109 {
<a name="l00110"></a>00110 mDb->close();
<a name="l00111"></a>00111 }
<a name="l00112"></a>00112
<a name="l00113"></a>00113 <span class="keywordtype">bool</span> ResourceSql::load()
<a name="l00114"></a>00114 {
<a name="l00115"></a>00115 <a class="codeRef" href="qsqlquery.html">QSqlQuery</a> query( <span class="stringliteral">"select addressId, name, familyName, givenName, "</span>
<a name="l00116"></a>00116 <span class="stringliteral">"additionalName, prefix, suffix, nickname, birthday, "</span>
<a name="l00117"></a>00117 <span class="stringliteral">"mailer, timezone, geo_latitude, geo_longitude, title, "</span>
<a name="l00118"></a>00118 <span class="stringliteral">"role, organization, note, productId, revision, "</span>
<a name="l00119"></a>00119 <span class="stringliteral">"sortString, url from kaddressbook_main_"</span> + mUser );
<a name="l00120"></a>00120
<a name="l00121"></a>00121 <span class="keywordflow">while</span> ( query.next() ) {
<a name="l00122"></a>00122 <a class="codeRef" href="qstring.html">QString</a> addrId = query.value(0).toString();
<a name="l00123"></a>00123
<a name="l00124"></a>00124 <a class="code" href="classKABC_1_1Addressee.html" title="address book entry">Addressee</a> addr;
<a name="l00125"></a>00125 addr.<a class="code" href="classKABC_1_1Addressee.html#ac67dcf61975851b977f6101c46c043d8" title="Set resource where the addressee is from.">setResource</a>( <span class="keyword">this</span> );
<a name="l00126"></a>00126 addr.<a class="code" href="classKABC_1_1Addressee.html#aeb8deb75da6ace715c53dd86b91c154c" title="Set unique identifier.">setUid</a>( addrId );
<a name="l00127"></a>00127 addr.setName( query.value(1).toString() );
<a name="l00128"></a>00128 addr.setFamilyName( query.value(2).toString() );
<a name="l00129"></a>00129 addr.setGivenName( query.value(3).toString() );
<a name="l00130"></a>00130 addr.setAdditionalName( query.value(4).toString() );
<a name="l00131"></a>00131 addr.setPrefix( query.value(5).toString() );
<a name="l00132"></a>00132 addr.setSuffix( query.value(6).toString() );
<a name="l00133"></a>00133 addr.setNickName( query.value(7).toString() );
<a name="l00134"></a>00134 addr.setBirthday( query.value(8).toDateTime() );
<a name="l00135"></a>00135 addr.setMailer( query.value(9).toString() );
<a name="l00136"></a>00136 addr.setTimeZone( <a class="code" href="classKABC_1_1TimeZone.html" title="Time zone information.">TimeZone</a>( query.value(10).toInt() ) );
<a name="l00137"></a>00137 addr.setGeo( <a class="code" href="classKABC_1_1Geo.html" title="Geographic position.">Geo</a>( query.value(11).toDouble(), query.value(12).toDouble() ) );
<a name="l00138"></a>00138 addr.setTitle( query.value(13).toString() );
<a name="l00139"></a>00139 addr.setRole( query.value(14).toString() );
<a name="l00140"></a>00140 addr.setOrganization( query.value(15).toString() );
<a name="l00141"></a>00141 addr.setNote( query.value(16).toString() );
<a name="l00142"></a>00142 addr.setProductId( query.value(17).toString() );
<a name="l00143"></a>00143 addr.setRevision( query.value(18).toDateTime() );
<a name="l00144"></a>00144 addr.setSortString( query.value(19).toString() );
<a name="l00145"></a>00145 addr.setUrl( query.value(20).toString() );
<a name="l00146"></a>00146
<a name="l00147"></a>00147 <span class="comment">// emails</span>
<a name="l00148"></a>00148 {
<a name="l00149"></a>00149 <a class="codeRef" href="qsqlquery.html">QSqlQuery</a> emailsQuery( <span class="stringliteral">"select email, preferred from kaddressbook_emails "</span>
<a name="l00150"></a>00150 <span class="stringliteral">"where addressId = '"</span> + addrId + <span class="stringliteral">"'"</span> );
<a name="l00151"></a>00151 <span class="keywordflow">while</span> ( emailsQuery.next() )
<a name="l00152"></a>00152 addr.<a class="code" href="classKABC_1_1Addressee.html#a7c60c92b47551cf8628f3fe796d15100" title="Insert an email address.">insertEmail</a>( emailsQuery.value( 0 ).toString(),
<a name="l00153"></a>00153 emailsQuery.value( 1 ).toInt() );
<a name="l00154"></a>00154 }
<a name="l00155"></a>00155
<a name="l00156"></a>00156 <span class="comment">// phones</span>
<a name="l00157"></a>00157 {
<a name="l00158"></a>00158 <a class="codeRef" href="qsqlquery.html">QSqlQuery</a> phonesQuery( <span class="stringliteral">"select number, type from kaddressbook_phones "</span>
<a name="l00159"></a>00159 <span class="stringliteral">"where addressId = '"</span> + addrId + <span class="stringliteral">"'"</span> );
<a name="l00160"></a>00160 <span class="keywordflow">while</span> ( phonesQuery.next() )
<a name="l00161"></a>00161 addr.<a class="code" href="classKABC_1_1Addressee.html#a2880e9be1777eba375dff2fb13766933" title="Insert a phone number.">insertPhoneNumber</a>( <a class="code" href="classKABC_1_1PhoneNumber.html" title="Phonenumber information.">PhoneNumber</a>( phonesQuery.value( 0 ).toString(),
<a name="l00162"></a>00162 phonesQuery.value( 1 ).toInt() ) );
<a name="l00163"></a>00163 }
<a name="l00164"></a>00164
<a name="l00165"></a>00165 <span class="comment">// addresses</span>
<a name="l00166"></a>00166 {
<a name="l00167"></a>00167 <a class="codeRef" href="qsqlquery.html">QSqlQuery</a> addressesQuery( <span class="stringliteral">"select postOfficeBox, extended, street, "</span>
<a name="l00168"></a>00168 <span class="stringliteral">"locality, region, postalCode, country, label, type "</span>
<a name="l00169"></a>00169 <span class="stringliteral">"from kaddressbook_addresses where addressId = '"</span> + addrId + <span class="stringliteral">"'"</span> );
<a name="l00170"></a>00170 <span class="keywordflow">while</span> ( addressesQuery.next() ) {
<a name="l00171"></a>00171 <a class="code" href="classKABC_1_1Address.html" title="Postal address information.">Address</a> a;
<a name="l00172"></a>00172 a.<a class="code" href="classKABC_1_1Address.html#a62b2f4ce195d7f478affdcf3490899c7" title="Sets the post office box.">setPostOfficeBox</a>( addressesQuery.value(0).toString() );
<a name="l00173"></a>00173 a.<a class="code" href="classKABC_1_1Address.html#a0dc8bfc6f68bb7c9266bfb2905c85a05" title="Sets the extended address information.">setExtended</a>( addressesQuery.value(1).toString() );
<a name="l00174"></a>00174 a.<a class="code" href="classKABC_1_1Address.html#a1ba4c7041feb68fc4ad69d02eb8dc4ad" title="Sets the street (including number).">setStreet</a>( addressesQuery.value(2).toString() );
<a name="l00175"></a>00175 a.<a class="code" href="classKABC_1_1Address.html#a873f44dde0c4625990f77fda597ab9ac" title="Sets the locality, e.g.">setLocality</a>( addressesQuery.value(3).toString() );
<a name="l00176"></a>00176 a.<a class="code" href="classKABC_1_1Address.html#ac3eee698bc514bffcb5e134c9be77854" title="Sets the region, e.g.">setRegion</a>( addressesQuery.value(4).toString() );
<a name="l00177"></a>00177 a.<a class="code" href="classKABC_1_1Address.html#a68f9c4194e574ed70b15fe29f251d841" title="Sets the postal code.">setPostalCode</a>( addressesQuery.value(5).toString() );
<a name="l00178"></a>00178 a.<a class="code" href="classKABC_1_1Address.html#a998510d7c6b15a042da5526ec7c29b4a" title="Sets the country.">setCountry</a>( addressesQuery.value(6).toString() );
<a name="l00179"></a>00179 a.<a class="code" href="classKABC_1_1Address.html#aafd36f8d96bc8662be3fcb1d3f436e51" title="Sets the delivery label.">setLabel</a>( addressesQuery.value(7).toString() );
<a name="l00180"></a>00180 a.<a class="code" href="classKABC_1_1Address.html#a4f64c36659bab3b1a00aba5f0302130d" title="Sets the type of address.">setType</a>( addressesQuery.value(8).toInt() );
<a name="l00181"></a>00181
<a name="l00182"></a>00182 addr.<a class="code" href="classKABC_1_1Addressee.html#ab9cabc3c3dc00eecf29c640a4ef7588d" title="Insert an address.">insertAddress</a>( a );
<a name="l00183"></a>00183 }
<a name="l00184"></a>00184 }
<a name="l00185"></a>00185
<a name="l00186"></a>00186 <span class="comment">// categories</span>
<a name="l00187"></a>00187 {
<a name="l00188"></a>00188 <a class="codeRef" href="qsqlquery.html">QSqlQuery</a> categoriesQuery( <span class="stringliteral">"select category from kaddressbook_categories "</span>
<a name="l00189"></a>00189 <span class="stringliteral">"where addressId = '"</span> + addrId + <span class="stringliteral">"'"</span> );
<a name="l00190"></a>00190 <span class="keywordflow">while</span> ( categoriesQuery.next() )
<a name="l00191"></a>00191 addr.<a class="code" href="classKABC_1_1Addressee.html#af56d927077cb2f50df6795bb62f6120e" title="Insert category.">insertCategory</a>( categoriesQuery.value( 0 ).toString() );
<a name="l00192"></a>00192 }
<a name="l00193"></a>00193
<a name="l00194"></a>00194 <span class="comment">// customs</span>
<a name="l00195"></a>00195 {
<a name="l00196"></a>00196 <a class="codeRef" href="qsqlquery.html">QSqlQuery</a> customsQuery( <span class="stringliteral">"select app, name, value from kaddressbook_customs "</span>
<a name="l00197"></a>00197 <span class="stringliteral">"where addressId = '"</span> + addrId + <span class="stringliteral">"'"</span> );
<a name="l00198"></a>00198 <span class="keywordflow">while</span> ( customsQuery.next() )
<a name="l00199"></a>00199 addr.<a class="code" href="classKABC_1_1Addressee.html#a30c1ada1e9905a05368d8e954be75637" title="Insert custom entry.">insertCustom</a>( customsQuery.value( 0 ).toString(),
<a name="l00200"></a>00200 customsQuery.value( 1 ).toString(),
<a name="l00201"></a>00201 customsQuery.value( 2 ).toString());
<a name="l00202"></a>00202 }
<a name="l00203"></a>00203
<a name="l00204"></a>00204 addressBook()->insertAddressee( addr );
<a name="l00205"></a>00205 }
<a name="l00206"></a>00206
<a name="l00207"></a>00207 <span class="keywordflow">return</span> <span class="keyword">true</span>;
<a name="l00208"></a>00208 }
<a name="l00209"></a>00209
<a name="l00210"></a>00210 <span class="keywordtype">bool</span> ResourceSql::save( <a class="code" href="classKABC_1_1Ticket.html" title="Helper class for handling coordinated save of address books.">Ticket</a> * )
<a name="l00211"></a>00211 {
<a name="l00212"></a>00212 <span class="comment">// we have to delete all entries for this user and reinsert them</span>
<a name="l00213"></a>00213 <a class="codeRef" href="qsqlquery.html">QSqlQuery</a> query( <span class="stringliteral">"select addressId from kaddressbook_main_"</span> + mUser );
<a name="l00214"></a>00214
<a name="l00215"></a>00215 <span class="keywordflow">while</span> ( query.next() ) {
<a name="l00216"></a>00216 <a class="codeRef" href="qstring.html">QString</a> addrId = query.value( 0 ).toString();
<a name="l00217"></a>00217 <a class="codeRef" href="qsqlquery.html">QSqlQuery</a> q;
<a name="l00218"></a>00218
<a name="l00219"></a>00219 q.<a class="codeRef" href="qsqlquery.html#exec">exec</a>( <span class="stringliteral">"DELETE FROM kaddressbook_emails WHERE addressId = '"</span> + addrId + <span class="stringliteral">"'"</span> );
<a name="l00220"></a>00220 q.<a class="codeRef" href="qsqlquery.html#exec">exec</a>( <span class="stringliteral">"DELETE FROM kaddressbook_phones WHERE addressId = '"</span> + addrId + <span class="stringliteral">"'"</span> );
<a name="l00221"></a>00221 q.<a class="codeRef" href="qsqlquery.html#exec">exec</a>( <span class="stringliteral">"DELETE FROM kaddressbook_addresses WHERE addressId = '"</span> + addrId + <span class="stringliteral">"'"</span> );
<a name="l00222"></a>00222 q.<a class="codeRef" href="qsqlquery.html#exec">exec</a>( <span class="stringliteral">"DELETE FROM kaddressbook_categories WHERE addressId = '"</span> + addrId + <span class="stringliteral">"'"</span> );
<a name="l00223"></a>00223 q.<a class="codeRef" href="qsqlquery.html#exec">exec</a>( <span class="stringliteral">"DELETE FROM kaddressbook_customs WHERE addressId = '"</span> + addrId + <span class="stringliteral">"'"</span> );
<a name="l00224"></a>00224
<a name="l00225"></a>00225 q.<a class="codeRef" href="qsqlquery.html#exec">exec</a>( <span class="stringliteral">"DELETE FROM kaddressbook_main_"</span> + mUser + <span class="stringliteral">" WHERE addressId = '"</span> + addrId + <span class="stringliteral">"'"</span> );
<a name="l00226"></a>00226 }
<a name="l00227"></a>00227
<a name="l00228"></a>00228 <span class="comment">// let's start...</span>
<a name="l00229"></a>00229 <a class="code" href="classKABC_1_1AddressBook_1_1Iterator.html" title="Address Book Iterator.">AddressBook::Iterator</a> it;
<a name="l00230"></a>00230 <span class="keywordflow">for</span> ( it = addressBook()->begin(); it != addressBook()->end(); ++it ) {
<a name="l00231"></a>00231 <span class="keywordflow">if</span> ( (*it).resource() != <span class="keyword">this</span> && (*it).resource() != 0 ) <span class="comment">// save only my and new entries</span>
<a name="l00232"></a>00232 <span class="keywordflow">continue</span>;
<a name="l00233"></a>00233
<a name="l00234"></a>00234 <a class="codeRef" href="qstring.html">QString</a> uid = (*it).uid();
<a name="l00235"></a>00235
<a name="l00236"></a>00236 query.exec( <span class="stringliteral">"INSERT INTO kaddressbook_main_"</span> + mUser + <span class="stringliteral">" VALUES ('"</span> +
<a name="l00237"></a>00237 (*it).uid() + <span class="stringliteral">"','"</span> +
<a name="l00238"></a>00238 (*it).name() + <span class="stringliteral">"','"</span> +
<a name="l00239"></a>00239 (*it).familyName() + <span class="stringliteral">"','"</span> +
<a name="l00240"></a>00240 (*it).givenName() + <span class="stringliteral">"','"</span> +
<a name="l00241"></a>00241 (*it).additionalName() + <span class="stringliteral">"','"</span> +
<a name="l00242"></a>00242 (*it).prefix() + <span class="stringliteral">"','"</span> +
<a name="l00243"></a>00243 (*it).suffix() + <span class="stringliteral">"','"</span> +
<a name="l00244"></a>00244 (*it).nickName() + <span class="stringliteral">"','"</span> +
<a name="l00245"></a>00245 (*it).birthday().toString( Qt::ISODate ) + <span class="stringliteral">"','"</span> +
<a name="l00246"></a>00246 (*it).mailer() + <span class="stringliteral">"','"</span> +
<a name="l00247"></a>00247 <a class="codeRef" href="qstring.html#number">QString::number</a>( (*it).timeZone().offset() ) + <span class="stringliteral">"','"</span> +
<a name="l00248"></a>00248 <a class="codeRef" href="qstring.html#number">QString::number</a>( (*it).geo().latitude() ) + <span class="stringliteral">"','"</span> +
<a name="l00249"></a>00249 <a class="codeRef" href="qstring.html#number">QString::number</a>( (*it).geo().longitude() ) + <span class="stringliteral">"','"</span> +
<a name="l00250"></a>00250 (*it).title() + <span class="stringliteral">"','"</span> +
<a name="l00251"></a>00251 (*it).role() + <span class="stringliteral">"','"</span> +
<a name="l00252"></a>00252 (*it).organization() + <span class="stringliteral">"','"</span> +
<a name="l00253"></a>00253 (*it).note() + <span class="stringliteral">"','"</span> +
<a name="l00254"></a>00254 (*it).productId() + <span class="stringliteral">"','"</span> +
<a name="l00255"></a>00255 (*it).revision().toString( Qt::ISODate ) + <span class="stringliteral">"','"</span> +
<a name="l00256"></a>00256 (*it).sortString() + <span class="stringliteral">"','"</span> +
<a name="l00257"></a>00257 (*it).url().url() + <span class="stringliteral">"')"</span>
<a name="l00258"></a>00258 );
<a name="l00259"></a>00259
<a name="l00260"></a>00260 <span class="comment">// emails</span>
<a name="l00261"></a>00261 {
<a name="l00262"></a>00262 <a class="codeRef" href="qstringlist.html">QStringList</a> emails = (*it).emails();
<a name="l00263"></a>00263 QStringList::ConstIterator it;
<a name="l00264"></a>00264 <span class="keywordtype">bool</span> preferred = <span class="keyword">true</span>;
<a name="l00265"></a>00265 <span class="keywordflow">for</span>( it = emails.begin(); it != emails.end(); ++it ) {
<a name="l00266"></a>00266 query.exec(<span class="stringliteral">"INSERT INTO kaddressbook_emails VALUES ('"</span> +
<a name="l00267"></a>00267 uid + <span class="stringliteral">"','"</span> +
<a name="l00268"></a>00268 (*it) + <span class="stringliteral">"','"</span> +
<a name="l00269"></a>00269 <a class="codeRef" href="qstring.html#number">QString::number</a>(preferred) + <span class="stringliteral">"')"</span>);
<a name="l00270"></a>00270 preferred = <span class="keyword">false</span>;
<a name="l00271"></a>00271 }
<a name="l00272"></a>00272 }
<a name="l00273"></a>00273
<a name="l00274"></a>00274 <span class="comment">// phonenumbers</span>
<a name="l00275"></a>00275 {
<a name="l00276"></a>00276 <a class="codeRef" href="qvaluelist.html">PhoneNumber::List</a> phoneNumberList = (*it).phoneNumbers();
<a name="l00277"></a>00277 <a class="codeRef" href="qvaluelist.html#ConstIterator">PhoneNumber::List::ConstIterator</a> it;
<a name="l00278"></a>00278 <span class="keywordflow">for</span>( it = phoneNumberList.<a class="codeRef" href="qvaluelist.html#begin">begin</a>(); it != phoneNumberList.<a class="codeRef" href="qvaluelist.html#end">end</a>(); ++it ) {
<a name="l00279"></a>00279 query.exec(<span class="stringliteral">"INSERT INTO kaddressbook_phones VALUES ('"</span> +
<a name="l00280"></a>00280 uid + <span class="stringliteral">"','"</span> +
<a name="l00281"></a>00281 (*it).<a class="codeRef" href="qstring.html#number">number</a>() + <span class="stringliteral">"','"</span> +
<a name="l00282"></a>00282 <a class="codeRef" href="qstring.html#number">QString::number</a>( (*it).type() ) + <span class="stringliteral">"')"</span>);
<a name="l00283"></a>00283 }
<a name="l00284"></a>00284 }
<a name="l00285"></a>00285
<a name="l00286"></a>00286 <span class="comment">// postal addresses</span>
<a name="l00287"></a>00287 {
<a name="l00288"></a>00288 <a class="codeRef" href="qvaluelist.html">Address::List</a> addressList = (*it).addresses();
<a name="l00289"></a>00289 <a class="codeRef" href="qvaluelist.html#ConstIterator">Address::List::ConstIterator</a> it;
<a name="l00290"></a>00290 <span class="keywordflow">for</span>( it = addressList.<a class="codeRef" href="qvaluelist.html#begin">begin</a>(); it != addressList.<a class="codeRef" href="qvaluelist.html#end">end</a>(); ++it ) {
<a name="l00291"></a>00291 query.exec(<span class="stringliteral">"INSERT INTO kaddressbook_addresses VALUES ('"</span> +
<a name="l00292"></a>00292 uid + <span class="stringliteral">"','"</span> +
<a name="l00293"></a>00293 (*it).postOfficeBox() + <span class="stringliteral">"','"</span> +
<a name="l00294"></a>00294 (*it).extended() + <span class="stringliteral">"','"</span> +
<a name="l00295"></a>00295 (*it).street() + <span class="stringliteral">"','"</span> +
<a name="l00296"></a>00296 (*it).locality() + <span class="stringliteral">"','"</span> +
<a name="l00297"></a>00297 (*it).region() + <span class="stringliteral">"','"</span> +
<a name="l00298"></a>00298 (*it).postalCode() + <span class="stringliteral">"','"</span> +
<a name="l00299"></a>00299 (*it).country() + <span class="stringliteral">"','"</span> +
<a name="l00300"></a>00300 (*it).label() + <span class="stringliteral">"','"</span> +
<a name="l00301"></a>00301 <a class="codeRef" href="qstring.html#number">QString::number</a>( (*it).type() ) + <span class="stringliteral">"')"</span>);
<a name="l00302"></a>00302 }
<a name="l00303"></a>00303 }
<a name="l00304"></a>00304
<a name="l00305"></a>00305 <span class="comment">// categories</span>
<a name="l00306"></a>00306 {
<a name="l00307"></a>00307 <a class="codeRef" href="qstringlist.html">QStringList</a> categories = (*it).categories();
<a name="l00308"></a>00308 QStringList::ConstIterator it;
<a name="l00309"></a>00309 <span class="keywordflow">for</span>( it = categories.begin(); it != categories.end(); ++it )
<a name="l00310"></a>00310 query.exec(<span class="stringliteral">"INSERT INTO kaddressbook_categories VALUES ('"</span> +
<a name="l00311"></a>00311 uid + <span class="stringliteral">"','"</span> +
<a name="l00312"></a>00312 (*it) + <span class="stringliteral">"')"</span>);
<a name="l00313"></a>00313 }
<a name="l00314"></a>00314
<a name="l00315"></a>00315 <span class="comment">// customs</span>
<a name="l00316"></a>00316 {
<a name="l00317"></a>00317 <a class="codeRef" href="qstringlist.html">QStringList</a> list = (*it).customs();
<a name="l00318"></a>00318 QStringList::ConstIterator it;
<a name="l00319"></a>00319 <span class="keywordflow">for</span>( it = list.begin(); it != list.end(); ++it ) {
<a name="l00320"></a>00320 <span class="keywordtype">int</span> dashPos = (*it).find( <span class="charliteral">'-'</span> );
<a name="l00321"></a>00321 <span class="keywordtype">int</span> colonPos = (*it).find( <span class="charliteral">':'</span> );
<a name="l00322"></a>00322 <a class="codeRef" href="qstring.html">QString</a> app = (*it).<a class="codeRef" href="qstring.html#left">left</a>( dashPos );
<a name="l00323"></a>00323 <a class="codeRef" href="qstring.html">QString</a> <a class="codeRef" doxygen="kdecore.tag:../../kdecore/html/" href="../../kdecore/html/namespaceKStdAccel.html#a737bc2466b1f000625fe8ebddffbb09d">name</a> = (*it).<a class="codeRef" href="qstring.html#mid">mid</a>( dashPos + 1, colonPos - dashPos - 1 );
<a name="l00324"></a>00324 <a class="codeRef" href="qstring.html">QString</a> value = (*it).<a class="codeRef" href="qstring.html#right">right</a>( (*it).length() - colonPos - 1 );
<a name="l00325"></a>00325
<a name="l00326"></a>00326 query.exec(<span class="stringliteral">"INSERT INTO kaddressbook_categories VALUES ('"</span> +
<a name="l00327"></a>00327 uid + <span class="stringliteral">"','"</span> + app + <span class="stringliteral">"','"</span> + name + <span class="stringliteral">"','"</span> + value + <span class="stringliteral">"')"</span>);
<a name="l00328"></a>00328 }
<a name="l00329"></a>00329 }
<a name="l00330"></a>00330 }
<a name="l00331"></a>00331
<a name="l00332"></a>00332 <span class="keywordflow">return</span> <span class="keyword">true</span>;
<a name="l00333"></a>00333 }
<a name="l00334"></a>00334
<a name="l00335"></a>00335 <a class="codeRef" href="qstring.html">QString</a> ResourceSql::identifier()<span class="keyword"> const</span>
<a name="l00336"></a>00336 <span class="keyword"></span>{
<a name="l00337"></a>00337 <span class="keywordflow">return</span> mHost + <span class="stringliteral">"_"</span> + mDbName;
<a name="l00338"></a>00338 }
</pre></div></div>
</div>
</div></div>
</td>
</tr>
<tr>
<td valign="top" id="leftmenu" width="25%">
<a name="navigation"></a>
<div class="menu_box"><h2>kabc</h2>
<div class="nav_list">
<ul><li><a href="index.html">Main Page</a></li><li><a href="namespaces.html">Namespace List</a></li><li><a href="hierarchy.html">Class Hierarchy</a></li><li><a href="classes.html">Alphabetical List</a></li><li><a href="annotated.html">Class List</a></li><li><a href="files.html">File List</a></li><li><a href="namespacemembers.html">Namespace Members</a></li><li><a href="functions.html">Class Members</a></li><li><a href="pages.html">Related Pages</a></li></ul>
<!--
<h2>Class Picker</h2>
<div style="text-align: center;">
<form name="guideform">
<select name="guidelinks" style="width:100%;" onChange="window.location=document.guideform.guidelinks.options[document.guideform.guidelinks.selectedIndex].value">
<option value="annotated.html">-- Choose --</option>
<option value="classKABC_1_1Address.html">kabc::address</option>, <option value="classKABC_1_1AddressBook.html">kabc::addressbook</option>, <option value="classKABC_1_1AddressBook_1_1ConstIterator.html">kabc::addressbook::constiterator</option>, <option value="classKABC_1_1AddressBook_1_1Iterator.html">kabc::addressbook::iterator</option>, <option value="classKABC_1_1Addressee.html">kabc::addressee</option>, <option value="classKABC_1_1AddresseeDialog.html">kabc::addresseedialog</option>, <option value="classKABC_1_1AddresseeItem.html">kabc::addresseeitem</option>, <option value="classKABC_1_1AddresseeList.html">kabc::addresseelist</option>, <option value="classKABC_1_1AddressLineEdit.html">kabc::addresslineedit</option>, <option value="classKABC_1_1Agent.html">kabc::agent</option>, <option value="classKABC_1_1BinaryFormat.html">kabc::binaryformat</option>, <option value="classKABC_1_1ConsoleErrorHandler.html">kabc::consoleerrorhandler</option>, <option value="classKABC_1_1DistributionList.html">kabc::distributionlist</option>, <option value="classKABC_1_1DistributionListDialog.html">kabc::distributionlistdialog</option>, <option value="classKABC_1_1DistributionListEditor.html">kabc::distributionlisteditor</option>, <option value="classKABC_1_1DistributionListEditorWidget.html">kabc::distributionlisteditorwidget</option>, <option value="classKABC_1_1DistributionListManager.html">kabc::distributionlistmanager</option>, <option value="classKABC_1_1DistributionListWatcher.html">kabc::distributionlistwatcher</option>, <option value="classKABC_1_1EmailSelector.html">kabc::emailselector</option>, <option value="classKABC_1_1ErrorHandler.html">kabc::errorhandler</option>, <option value="classKABC_1_1Format.html">kabc::format</option>, <option value="classKABC_1_1FormatFactory.html">kabc::formatfactory</option>, <option value="classKABC_1_1FormatPlugin.html">kabc::formatplugin</option>, <option value="classKABC_1_1Geo.html">kabc::geo</option>, <option value="classKABC_1_1GUIErrorHandler.html">kabc::guierrorhandler</option>, <option value="classKABC_1_1GuiErrorHandler.html">kabc::guierrorhandler</option>, <option value="classKABC_1_1Key.html">kabc::key</option>, <option value="classKABC_1_1LdapClient.html">kabc::ldapclient</option>, <option value="classKABC_1_1LdapConfigWidget.html">kabc::ldapconfigwidget</option>, <option value="classKABC_1_1LdapObject.html">kabc::ldapobject</option>, <option value="classKABC_1_1LdapSearch.html">kabc::ldapsearch</option>, <option value="classKABC_1_1LDAPUrl.html">kabc::ldapurl</option>, <option value="classKABC_1_1LDIF.html">kabc::ldif</option>, <option value="classKABC_1_1Lock.html">kabc::lock</option>, <option value="classKABC_1_1LockNull.html">kabc::locknull</option>, <option value="classKABC_1_1PhoneNumber.html">kabc::phonenumber</option>, <option value="classKABC_1_1Resource_1_1ConstIterator.html">kabc::resource::constiterator</option>, <option value="classKABC_1_1Resource_1_1Iterator.html">kabc::resource::iterator</option>, <option value="classKABC_1_1ResourceFile.html">kabc::resourcefile</option>, <option value="classKABC_1_1ResourceSelectDialog.html">kabc::resourceselectdialog</option>, <option value="classKABC_1_1SortMode.html">kabc::sortmode</option>, <option value="classKABC_1_1Sound.html">kabc::sound</option>, <option value="classKABC_1_1StdAddressBook.html">kabc::stdaddressbook</option>, <option value="classKABC_1_1Ticket.html">kabc::ticket</option>, <option value="classKABC_1_1TimeZone.html">kabc::timezone</option>, <option value="classKABC_1_1VCard21Parser.html">kabc::vcard21parser</option>, <option value="classKABC_1_1VCardConverter.html">kabc::vcardconverter</option>, <option value="classKABC_1_1VCardFormat.html">kabc::vcardformat</option>, <option value="classKABC_1_1VCardFormatImpl.html">kabc::vcardformatimpl</option>, <option value="classKABC_1_1VCardFormatPlugin.html">kabc::vcardformatplugin</option>, <option value="classVCard21ParserImpl.html">vcard21parserimpl</option>, <option value="classVCardLineX.html">vcardlinex</option>,
</select>
</form>
</div>
-->
</div></div>
<div class="menu_box"><h2>API Dox</h2>
<div class="nav_list">
<ul>
<li><a href="../../arts/html/index.html">arts</a></li><li><a href="../../dcop/html/index.html">dcop</a></li><li><a href="../../dnssd/html/index.html">dnssd</a></li><li><a href="../../interfaces/html/index.html">interfaces</a></li><li> <a href="../../interfaces/kimproxy/interface/html/index.html">interface</a></li><li> <a href="../../interfaces/kimproxy/library/html/index.html">library</a></li><li> <a href="../../interfaces/kspeech/html/index.html">kspeech</a></li><li> <a href="../../interfaces/ktexteditor/html/index.html">ktexteditor</a></li><li><a href="../../kabc/html/index.html">kabc</a></li><li><a href="../../kate/html/index.html">kate</a></li><li><a href="../../kcmshell/html/index.html">kcmshell</a></li><li><a href="../../kdecore/html/index.html">kdecore</a></li><li><a href="../../kded/html/index.html">kded</a></li><li><a href="../../kdefx/html/index.html">kdefx</a></li><li><a href="../../kdeprint/html/index.html">kdeprint</a></li><li><a href="../../kdesu/html/index.html">kdesu</a></li><li><a href="../../kdeui/html/index.html">kdeui</a></li><li><a href="../../kdoctools/html/index.html">kdoctools</a></li><li><a href="../../khtml/html/index.html">khtml</a></li><li><a href="../../kimgio/html/index.html">kimgio</a></li><li><a href="../../kinit/html/index.html">kinit</a></li><li><a href="../../kio/html/index.html">kio</a></li><li> <a href="../../kio/bookmarks/html/index.html">bookmarks</a></li><li> <a href="../../kio/httpfilter/html/index.html">httpfilter</a></li><li> <a href="../../kio/kfile/html/index.html">kfile</a></li><li> <a href="../../kio/kio/html/index.html">kio</a></li><li> <a href="../../kio/kioexec/html/index.html">kioexec</a></li><li> <a href="../../kio/kpasswdserver/html/index.html">kpasswdserver</a></li><li> <a href="../../kio/kssl/html/index.html">kssl</a></li><li><a href="../../kioslave/html/index.html">kioslave</a></li><li> <a href="../../kioslave/http/html/index.html">http</a></li><li><a href="../../kjs/html/index.html">kjs</a></li><li><a href="../../kmdi/html/index.html">kmdi</a></li><li> <a href="../../kmdi/kmdi/html/index.html">kmdi</a></li><li><a href="../../knewstuff/html/index.html">knewstuff</a></li><li><a href="../../kparts/html/index.html">kparts</a></li><li><a href="../../kresources/html/index.html">kresources</a></li><li><a href="../../kspell2/html/index.html">kspell2</a></li><li><a href="../../kunittest/html/index.html">kunittest</a></li><li><a href="../../kutils/html/index.html">kutils</a></li><li><a href="../../kwallet/html/index.html">kwallet</a></li><li><a href="../../libkmid/html/index.html">libkmid</a></li><li><a href="../../libkscreensaver/html/index.html">libkscreensaver</a></li>
</ul></div></div>
</td>
</tr>
</table>
<span class="doNotDisplay">
<a href="http://www.kde.org/" accesskey="8">KDE Home</a> |
<a href="http://accessibility.kde.org/" accesskey="9">KDE Accessibility Home</a> |
<a href="http://www.kde.org/media/accesskeys.php" accesskey="0">Description of Access Keys</a>
</span>
<div style="height: 8px"></div>
<div id="footer">
<div id="footer_left">
Maintained by <a href="mailto:groot@kde.org">Adriaan de Groot</a>
and
<a href="mailto:winter@kde.org">Allen Winter</a>.
<br/>
KDE and K Desktop Environment are trademarks of <a href="http://www.kde.org/areas/kde-ev/" title="Homepage of the KDE non-profit Organization">KDE e.V.</a> |
<a href="http://www.kde.org/contact/impressum.php">Legal</a>
</div>
<div id="footer_right"><img src="/media/images/footer_right.png" style="margin: 0px" alt="" /></div>
</div>
<!--
WARNING: DO NOT SEND MAIL TO THE FOLLOWING EMAIL ADDRESS! YOU WILL
BE BLOCKED INSTANTLY AND PERMANENTLY!
<a href="mailto:aaaatrap-425acc3b5374943f@kde.org">Block me</a>
WARNING END
-->
</body>
</html>
