<!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/xhtml;charset=UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=9"/>
<meta name="generator" content="Doxygen 1.8.6"/>
<title>createrepo_c library: SQLite metadata API.</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="dynsections.js"></script>
<link href="navtree.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="resize.js"></script>
<script type="text/javascript" src="navtree.js"></script>
<script type="text/javascript">
$(document).ready(initResizable);
$(window).load(resizeHeight);
</script>
<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="search/search.js"></script>
<script type="text/javascript">
$(document).ready(function() { searchBox.OnSelectItem(0); });
</script>
<link href="doxygen.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="top"><!-- do not remove this div, it is closed by doxygen! -->
<div id="titlearea">
<table cellspacing="0" cellpadding="0">
<tbody>
<tr style="height: 56px;">
<td style="padding-left: 0.5em;">
<div id="projectname">createrepo_c library
 <span id="projectnumber">0.7.4</span>
</div>
<div id="projectbrief">C library for metadata manipulation</div>
</td>
</tr>
</tbody>
</table>
</div>
<!-- end header part -->
<!-- Generated by Doxygen 1.8.6 -->
<script type="text/javascript">
var searchBox = new SearchBox("searchBox", "search",false,'Search');
</script>
<div id="navrow1" class="tabs">
<ul class="tablist">
<li><a href="index.html"><span>Main Page</span></a></li>
<li><a href="modules.html"><span>Modules</span></a></li>
<li><a href="annotated.html"><span>Data Structures</span></a></li>
<li><a href="files.html"><span>Files</span></a></li>
<li>
<div id="MSearchBox" class="MSearchBoxInactive">
<span class="left">
<img id="MSearchSelect" src="search/mag_sel.png"
onmouseover="return searchBox.OnSearchSelectShow()"
onmouseout="return searchBox.OnSearchSelectHide()"
alt=""/>
<input type="text" id="MSearchField" value="Search" accesskey="S"
onfocus="searchBox.OnSearchFieldFocus(true)"
onblur="searchBox.OnSearchFieldFocus(false)"
onkeyup="searchBox.OnSearchFieldChange(event)"/>
</span><span class="right">
<a id="MSearchClose" href="javascript:searchBox.CloseResultsWindow()"><img id="MSearchCloseImg" border="0" src="search/close.png" alt=""/></a>
</span>
</div>
</li>
</ul>
</div>
</div><!-- top -->
<div id="side-nav" class="ui-resizable side-nav-resizable">
<div id="nav-tree">
<div id="nav-tree-contents">
<div id="nav-sync" class="sync"></div>
</div>
</div>
<div id="splitbar" style="-moz-user-select:none;"
class="ui-resizable-handle">
</div>
</div>
<script type="text/javascript">
$(document).ready(function(){initNavTree('group__sqlite.html','');});
</script>
<div id="doc-content">
<!-- window showing the filter options -->
<div id="MSearchSelectWindow"
onmouseover="return searchBox.OnSearchSelectShow()"
onmouseout="return searchBox.OnSearchSelectHide()"
onkeydown="return searchBox.OnSearchSelectKey(event)">
<a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(0)"><span class="SelectionMark"> </span>All</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(1)"><span class="SelectionMark"> </span>Data Structures</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(2)"><span class="SelectionMark"> </span>Functions</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(3)"><span class="SelectionMark"> </span>Variables</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(4)"><span class="SelectionMark"> </span>Typedefs</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(5)"><span class="SelectionMark"> </span>Enumerations</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(6)"><span class="SelectionMark"> </span>Enumerator</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(7)"><span class="SelectionMark"> </span>Groups</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(8)"><span class="SelectionMark"> </span>Pages</a></div>
<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="javascript:void(0)" frameborder="0"
name="MSearchResults" id="MSearchResults">
</iframe>
</div>
<div class="header">
<div class="summary">
<a href="#nested-classes">Data Structures</a> |
<a href="#define-members">Macros</a> |
<a href="#typedef-members">Typedefs</a> |
<a href="#enum-members">Enumerations</a> |
<a href="#func-members">Functions</a> </div>
<div class="headertitle">
<div class="title">SQLite metadata API.</div> </div>
</div><!--header-->
<div class="contents">
<table class="memberdecls">
<tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="nested-classes"></a>
Data Structures</h2></td></tr>
<tr class="memitem:"><td class="memItemLeft" align="right" valign="top">union  </td><td class="memItemRight" valign="bottom"><a class="el" href="unioncr___statements.html">cr_Statements</a></td></tr>
<tr class="separator:"><td class="memSeparator" colspan="2"> </td></tr>
<tr class="memitem:"><td class="memItemLeft" align="right" valign="top">struct  </td><td class="memItemRight" valign="bottom"><a class="el" href="structcr___sqlite_db.html">cr_SqliteDb</a></td></tr>
<tr class="separator:"><td class="memSeparator" colspan="2"> </td></tr>
</table><table class="memberdecls">
<tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="define-members"></a>
Macros</h2></td></tr>
<tr class="memitem:ga7e7a0ebecff2cc416b0a19f6df75ae41"><td class="memItemLeft" align="right" valign="top">#define </td><td class="memItemRight" valign="bottom"><a class="el" href="group__sqlite.html#ga7e7a0ebecff2cc416b0a19f6df75ae41">CR_DB_CACHE_DBVERSION</a>   10</td></tr>
<tr class="separator:ga7e7a0ebecff2cc416b0a19f6df75ae41"><td class="memSeparator" colspan="2"> </td></tr>
<tr class="memitem:gab374c452288b3c16c19d72ec9566743d"><td class="memItemLeft" align="right" valign="top">#define </td><td class="memItemRight" valign="bottom"><a class="el" href="group__sqlite.html#gab374c452288b3c16c19d72ec9566743d">cr_db_open_primary</a>(PATH, ERR)   <a class="el" href="group__sqlite.html#ga3d3f04a2ff8c8348557950a11bbd405a">cr_db_open</a>(PATH, <a class="el" href="group__sqlite.html#gga4cd796b21a4888d5c0664199ba2c2fada440addcdfb3c6a8a8889bc8064ad483e">CR_DB_PRIMARY</a>, ERR)</td></tr>
<tr class="separator:gab374c452288b3c16c19d72ec9566743d"><td class="memSeparator" colspan="2"> </td></tr>
<tr class="memitem:ga4891f5cd3b7ec7cde48cff098603781f"><td class="memItemLeft" align="right" valign="top">#define </td><td class="memItemRight" valign="bottom"><a class="el" href="group__sqlite.html#ga4891f5cd3b7ec7cde48cff098603781f">cr_db_open_filelists</a>(PATH, ERR)   <a class="el" href="group__sqlite.html#ga3d3f04a2ff8c8348557950a11bbd405a">cr_db_open</a>(PATH, <a class="el" href="group__sqlite.html#gga4cd796b21a4888d5c0664199ba2c2fada0c476b657984128fb97b2e904b5c8519">CR_DB_FILELISTS</a>, ERR)</td></tr>
<tr class="separator:ga4891f5cd3b7ec7cde48cff098603781f"><td class="memSeparator" colspan="2"> </td></tr>
<tr class="memitem:ga8e7a10434563af9cd9ffc7df4d5474ee"><td class="memItemLeft" align="right" valign="top">#define </td><td class="memItemRight" valign="bottom"><a class="el" href="group__sqlite.html#ga8e7a10434563af9cd9ffc7df4d5474ee">cr_db_open_other</a>(PATH, ERR)   <a class="el" href="group__sqlite.html#ga3d3f04a2ff8c8348557950a11bbd405a">cr_db_open</a>(PATH, <a class="el" href="group__sqlite.html#gga4cd796b21a4888d5c0664199ba2c2fadae0823004415df25eead88fe96abd81ac">CR_DB_OTHER</a>, ERR)</td></tr>
<tr class="separator:ga8e7a10434563af9cd9ffc7df4d5474ee"><td class="memSeparator" colspan="2"> </td></tr>
</table><table class="memberdecls">
<tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="typedef-members"></a>
Typedefs</h2></td></tr>
<tr class="memitem:gac1492edbb2065026e0441f9fec543dcd"><td class="memItemLeft" align="right" valign="top">typedef struct <br class="typebreak"/>
_DbPrimaryStatements * </td><td class="memItemRight" valign="bottom"><a class="el" href="group__sqlite.html#gac1492edbb2065026e0441f9fec543dcd">cr_DbPrimaryStatements</a></td></tr>
<tr class="separator:gac1492edbb2065026e0441f9fec543dcd"><td class="memSeparator" colspan="2"> </td></tr>
<tr class="memitem:ga81dd3a36429c7b689c6c6f50d5f7e988"><td class="memItemLeft" align="right" valign="top">typedef struct <br class="typebreak"/>
_DbFilelistsStatements * </td><td class="memItemRight" valign="bottom"><a class="el" href="group__sqlite.html#ga81dd3a36429c7b689c6c6f50d5f7e988">cr_DbFilelistsStatements</a></td></tr>
<tr class="separator:ga81dd3a36429c7b689c6c6f50d5f7e988"><td class="memSeparator" colspan="2"> </td></tr>
<tr class="memitem:gadd2068c09b19d8caedc9abfecf96097e"><td class="memItemLeft" align="right" valign="top">typedef struct _DbOtherStatements * </td><td class="memItemRight" valign="bottom"><a class="el" href="group__sqlite.html#gadd2068c09b19d8caedc9abfecf96097e">cr_DbOtherStatements</a></td></tr>
<tr class="separator:gadd2068c09b19d8caedc9abfecf96097e"><td class="memSeparator" colspan="2"> </td></tr>
</table><table class="memberdecls">
<tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="enum-members"></a>
Enumerations</h2></td></tr>
<tr class="memitem:ga4cd796b21a4888d5c0664199ba2c2fad"><td class="memItemLeft" align="right" valign="top">enum  </td><td class="memItemRight" valign="bottom"><a class="el" href="group__sqlite.html#ga4cd796b21a4888d5c0664199ba2c2fad">cr_DatabaseType</a> { <a class="el" href="group__sqlite.html#gga4cd796b21a4888d5c0664199ba2c2fada440addcdfb3c6a8a8889bc8064ad483e">CR_DB_PRIMARY</a>,
<a class="el" href="group__sqlite.html#gga4cd796b21a4888d5c0664199ba2c2fada0c476b657984128fb97b2e904b5c8519">CR_DB_FILELISTS</a>,
<a class="el" href="group__sqlite.html#gga4cd796b21a4888d5c0664199ba2c2fadae0823004415df25eead88fe96abd81ac">CR_DB_OTHER</a>,
<a class="el" href="group__sqlite.html#gga4cd796b21a4888d5c0664199ba2c2fada67f689837e023dd5e7e80160aea28547">CR_DB_SENTINEL</a>
}</td></tr>
<tr class="separator:ga4cd796b21a4888d5c0664199ba2c2fad"><td class="memSeparator" colspan="2"> </td></tr>
</table><table class="memberdecls">
<tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="func-members"></a>
Functions</h2></td></tr>
<tr class="memitem:ga3d3f04a2ff8c8348557950a11bbd405a"><td class="memItemLeft" align="right" valign="top"><a class="el" href="structcr___sqlite_db.html">cr_SqliteDb</a> * </td><td class="memItemRight" valign="bottom"><a class="el" href="group__sqlite.html#ga3d3f04a2ff8c8348557950a11bbd405a">cr_db_open</a> (const char *path, <a class="el" href="group__sqlite.html#ga4cd796b21a4888d5c0664199ba2c2fad">cr_DatabaseType</a> db_type, GError **err)</td></tr>
<tr class="separator:ga3d3f04a2ff8c8348557950a11bbd405a"><td class="memSeparator" colspan="2"> </td></tr>
<tr class="memitem:ga6504bd5ecdf51fb72dac4de2c9d434bf"><td class="memItemLeft" align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="group__sqlite.html#ga6504bd5ecdf51fb72dac4de2c9d434bf">cr_db_add_pkg</a> (<a class="el" href="structcr___sqlite_db.html">cr_SqliteDb</a> *sqlitedb, <a class="el" href="structcr___package.html">cr_Package</a> *pkg, GError **err)</td></tr>
<tr class="separator:ga6504bd5ecdf51fb72dac4de2c9d434bf"><td class="memSeparator" colspan="2"> </td></tr>
<tr class="memitem:ga455cdc9d6a5c8ad64e25af5b9782b8f3"><td class="memItemLeft" align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="group__sqlite.html#ga455cdc9d6a5c8ad64e25af5b9782b8f3">cr_db_dbinfo_update</a> (<a class="el" href="structcr___sqlite_db.html">cr_SqliteDb</a> *sqlitedb, const char *checksum, GError **err)</td></tr>
<tr class="separator:ga455cdc9d6a5c8ad64e25af5b9782b8f3"><td class="memSeparator" colspan="2"> </td></tr>
<tr class="memitem:ga35d76a3a69c99c6e75878812264b6d94"><td class="memItemLeft" align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="group__sqlite.html#ga35d76a3a69c99c6e75878812264b6d94">cr_db_close</a> (<a class="el" href="structcr___sqlite_db.html">cr_SqliteDb</a> *sqlitedb, GError **err)</td></tr>
<tr class="separator:ga35d76a3a69c99c6e75878812264b6d94"><td class="memSeparator" colspan="2"> </td></tr>
</table>
<a name="details" id="details"></a><h2 class="groupheader">Detailed Description</h2>
<p>Module for writing sqlite metadata databases.</p>
<p>Example: </p>
<div class="fragment"><div class="line"><a class="code" href="structcr___package.html">cr_Package</a> *pkg;</div>
<div class="line"><a class="code" href="structcr___sqlite_db.html">cr_SqliteDb</a> *primary_db;</div>
<div class="line"></div>
<div class="line"><span class="comment">// Load pkg (See parsepkg or parsehdr module)</span></div>
<div class="line"></div>
<div class="line"><span class="comment">// Create primary sqlite database</span></div>
<div class="line">primary_db = <a class="code" href="group__sqlite.html#gab374c452288b3c16c19d72ec9566743d">cr_db_open_primary</a>(<span class="stringliteral">"/foo/bar/repodata/primary.sqlite"</span>, NULL);</div>
<div class="line"></div>
<div class="line"><span class="comment">// Add all packages here</span></div>
<div class="line"><a class="code" href="group__sqlite.html#ga6504bd5ecdf51fb72dac4de2c9d434bf">cr_db_add_pkg</a>(primary_db, pkg, NULL);</div>
<div class="line"></div>
<div class="line"><span class="comment">// Add checksum of XML version of file (primary in this case)</span></div>
<div class="line"><a class="code" href="group__sqlite.html#ga455cdc9d6a5c8ad64e25af5b9782b8f3">cr_db_dbinfo_update</a>(primary_db, <span class="stringliteral">"foochecksum"</span>, NULL);</div>
<div class="line"></div>
<div class="line"><span class="comment">// Cleanup</span></div>
<div class="line"><a class="code" href="group__sqlite.html#ga35d76a3a69c99c6e75878812264b6d94">cr_db_close</a>(primary_db, NULL);</div>
</div><!-- fragment --> <h2 class="groupheader">Macro Definition Documentation</h2>
<a class="anchor" id="ga7e7a0ebecff2cc416b0a19f6df75ae41"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">#define CR_DB_CACHE_DBVERSION   10</td>
</tr>
</table>
</div><div class="memdoc">
<p>Version of DB api </p>
<p>Definition at line <a class="el" href="sqlite_8h_source.html#l00059">59</a> of file <a class="el" href="sqlite_8h_source.html">sqlite.h</a>.</p>
</div>
</div>
<a class="anchor" id="ga4891f5cd3b7ec7cde48cff098603781f"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">#define cr_db_open_filelists</td>
<td>(</td>
<td class="paramtype"> </td>
<td class="paramname">PATH, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype"> </td>
<td class="paramname">ERR </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td>   <a class="el" href="group__sqlite.html#ga3d3f04a2ff8c8348557950a11bbd405a">cr_db_open</a>(PATH, <a class="el" href="group__sqlite.html#gga4cd796b21a4888d5c0664199ba2c2fada0c476b657984128fb97b2e904b5c8519">CR_DB_FILELISTS</a>, ERR)</td>
</tr>
</table>
</div><div class="memdoc">
<p>Macro over cr_db_open function. Open (create new) filelists sqlite sqlite db.</p>
<ul>
<li>creates db file</li>
<li>creates filelists tables</li>
<li>creates info table</li>
<li>tweak some db params <dl class="params"><dt>Parameters</dt><dd>
<table class="params">
<tr><td class="paramname">PATH</td><td>Path to the db file. </td></tr>
<tr><td class="paramname">ERR</td><td>**GError </td></tr>
</table>
</dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>Opened db or NULL on error </dd></dl>
</li>
</ul>
<p>Definition at line <a class="el" href="sqlite_8h_source.html#l00116">116</a> of file <a class="el" href="sqlite_8h_source.html">sqlite.h</a>.</p>
</div>
</div>
<a class="anchor" id="ga8e7a10434563af9cd9ffc7df4d5474ee"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">#define cr_db_open_other</td>
<td>(</td>
<td class="paramtype"> </td>
<td class="paramname">PATH, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype"> </td>
<td class="paramname">ERR </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td>   <a class="el" href="group__sqlite.html#ga3d3f04a2ff8c8348557950a11bbd405a">cr_db_open</a>(PATH, <a class="el" href="group__sqlite.html#gga4cd796b21a4888d5c0664199ba2c2fadae0823004415df25eead88fe96abd81ac">CR_DB_OTHER</a>, ERR)</td>
</tr>
</table>
</div><div class="memdoc">
<p>Macro over cr_db_open function. Open (create new) other sqlite sqlite db.</p>
<ul>
<li>creates db file</li>
<li>opens transaction</li>
<li>creates other tables</li>
<li>creates info table</li>
<li>tweak some db params <dl class="params"><dt>Parameters</dt><dd>
<table class="params">
<tr><td class="paramname">PATH</td><td>Path to the db file. </td></tr>
<tr><td class="paramname">ERR</td><td>**GError </td></tr>
</table>
</dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>Opened db or NULL on error </dd></dl>
</li>
</ul>
<p>Definition at line <a class="el" href="sqlite_8h_source.html#l00128">128</a> of file <a class="el" href="sqlite_8h_source.html">sqlite.h</a>.</p>
</div>
</div>
<a class="anchor" id="gab374c452288b3c16c19d72ec9566743d"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">#define cr_db_open_primary</td>
<td>(</td>
<td class="paramtype"> </td>
<td class="paramname">PATH, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype"> </td>
<td class="paramname">ERR </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td>   <a class="el" href="group__sqlite.html#ga3d3f04a2ff8c8348557950a11bbd405a">cr_db_open</a>(PATH, <a class="el" href="group__sqlite.html#gga4cd796b21a4888d5c0664199ba2c2fada440addcdfb3c6a8a8889bc8064ad483e">CR_DB_PRIMARY</a>, ERR)</td>
</tr>
</table>
</div><div class="memdoc">
<p>Macro over cr_db_open function. Open (create new) primary sqlite sqlite db.</p>
<ul>
<li>creates db file</li>
<li>creates primary tables</li>
<li>creates info table</li>
<li>tweak some db params <dl class="params"><dt>Parameters</dt><dd>
<table class="params">
<tr><td class="paramname">PATH</td><td>Path to the db file. </td></tr>
<tr><td class="paramname">ERR</td><td>**GError </td></tr>
</table>
</dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>Opened db or NULL on error </dd></dl>
</li>
</ul>
<p>Definition at line <a class="el" href="sqlite_8h_source.html#l00105">105</a> of file <a class="el" href="sqlite_8h_source.html">sqlite.h</a>.</p>
</div>
</div>
<h2 class="groupheader">Typedef Documentation</h2>
<a class="anchor" id="ga81dd3a36429c7b689c6c6f50d5f7e988"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">typedef struct _DbFilelistsStatements* <a class="el" href="group__sqlite.html#ga81dd3a36429c7b689c6c6f50d5f7e988">cr_DbFilelistsStatements</a></td>
</tr>
</table>
</div><div class="memdoc">
<p>Compiled filelists database statements </p>
<p>Definition at line <a class="el" href="sqlite_8h_source.html#l00072">72</a> of file <a class="el" href="sqlite_8h_source.html">sqlite.h</a>.</p>
</div>
</div>
<a class="anchor" id="gadd2068c09b19d8caedc9abfecf96097e"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">typedef struct _DbOtherStatements* <a class="el" href="group__sqlite.html#gadd2068c09b19d8caedc9abfecf96097e">cr_DbOtherStatements</a></td>
</tr>
</table>
</div><div class="memdoc">
<p>Compiled other database statements </p>
<p>Definition at line <a class="el" href="sqlite_8h_source.html#l00074">74</a> of file <a class="el" href="sqlite_8h_source.html">sqlite.h</a>.</p>
</div>
</div>
<a class="anchor" id="gac1492edbb2065026e0441f9fec543dcd"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">typedef struct _DbPrimaryStatements* <a class="el" href="group__sqlite.html#gac1492edbb2065026e0441f9fec543dcd">cr_DbPrimaryStatements</a></td>
</tr>
</table>
</div><div class="memdoc">
<p>Compiled primary database statements </p>
<p>Definition at line <a class="el" href="sqlite_8h_source.html#l00070">70</a> of file <a class="el" href="sqlite_8h_source.html">sqlite.h</a>.</p>
</div>
</div>
<h2 class="groupheader">Enumeration Type Documentation</h2>
<a class="anchor" id="ga4cd796b21a4888d5c0664199ba2c2fad"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">enum <a class="el" href="group__sqlite.html#ga4cd796b21a4888d5c0664199ba2c2fad">cr_DatabaseType</a></td>
</tr>
</table>
</div><div class="memdoc">
<p>Database type. </p>
<table class="fieldtable">
<tr><th colspan="2">Enumerator</th></tr><tr><td class="fieldname"><em><a class="anchor" id="gga4cd796b21a4888d5c0664199ba2c2fada440addcdfb3c6a8a8889bc8064ad483e"></a>CR_DB_PRIMARY</em> </td><td class="fielddoc">
<p>primary </p>
</td></tr>
<tr><td class="fieldname"><em><a class="anchor" id="gga4cd796b21a4888d5c0664199ba2c2fada0c476b657984128fb97b2e904b5c8519"></a>CR_DB_FILELISTS</em> </td><td class="fielddoc">
<p>filelists </p>
</td></tr>
<tr><td class="fieldname"><em><a class="anchor" id="gga4cd796b21a4888d5c0664199ba2c2fadae0823004415df25eead88fe96abd81ac"></a>CR_DB_OTHER</em> </td><td class="fielddoc">
<p>other </p>
</td></tr>
<tr><td class="fieldname"><em><a class="anchor" id="gga4cd796b21a4888d5c0664199ba2c2fada67f689837e023dd5e7e80160aea28547"></a>CR_DB_SENTINEL</em> </td><td class="fielddoc">
<p>sentinel of the list </p>
</td></tr>
</table>
<p>Definition at line <a class="el" href="sqlite_8h_source.html#l00063">63</a> of file <a class="el" href="sqlite_8h_source.html">sqlite.h</a>.</p>
</div>
</div>
<h2 class="groupheader">Function Documentation</h2>
<a class="anchor" id="ga6504bd5ecdf51fb72dac4de2c9d434bf"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">int cr_db_add_pkg </td>
<td>(</td>
<td class="paramtype"><a class="el" href="structcr___sqlite_db.html">cr_SqliteDb</a> * </td>
<td class="paramname"><em>sqlitedb</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype"><a class="el" href="structcr___package.html">cr_Package</a> * </td>
<td class="paramname"><em>pkg</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">GError ** </td>
<td class="paramname"><em>err</em> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
<p>Add package into the database. </p>
<dl class="params"><dt>Parameters</dt><dd>
<table class="params">
<tr><td class="paramname">sqlitedb</td><td>open db connection </td></tr>
<tr><td class="paramname">pkg</td><td>package object </td></tr>
<tr><td class="paramname">err</td><td>**GError </td></tr>
</table>
</dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>cr_Error code </dd></dl>
</div>
</div>
<a class="anchor" id="ga35d76a3a69c99c6e75878812264b6d94"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">int cr_db_close </td>
<td>(</td>
<td class="paramtype"><a class="el" href="structcr___sqlite_db.html">cr_SqliteDb</a> * </td>
<td class="paramname"><em>sqlitedb</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">GError ** </td>
<td class="paramname"><em>err</em> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
<p>Close db.</p>
<ul>
<li>creates indexes on tables</li>
<li>commits transaction</li>
<li>closes db <dl class="params"><dt>Parameters</dt><dd>
<table class="params">
<tr><td class="paramname">sqlitedb</td><td>open db connection </td></tr>
<tr><td class="paramname">err</td><td>**GError </td></tr>
</table>
</dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>cr_Error code </dd></dl>
</li>
</ul>
</div>
</div>
<a class="anchor" id="ga455cdc9d6a5c8ad64e25af5b9782b8f3"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">int cr_db_dbinfo_update </td>
<td>(</td>
<td class="paramtype"><a class="el" href="structcr___sqlite_db.html">cr_SqliteDb</a> * </td>
<td class="paramname"><em>sqlitedb</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">const char * </td>
<td class="paramname"><em>checksum</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">GError ** </td>
<td class="paramname"><em>err</em> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
<p>Insert record into the updateinfo table </p>
<dl class="params"><dt>Parameters</dt><dd>
<table class="params">
<tr><td class="paramname">sqlitedb</td><td>open db connection </td></tr>
<tr><td class="paramname">checksum</td><td>compressed xml file checksum </td></tr>
<tr><td class="paramname">err</td><td>**GError </td></tr>
</table>
</dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>cr_Error code </dd></dl>
</div>
</div>
<a class="anchor" id="ga3d3f04a2ff8c8348557950a11bbd405a"></a>
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname"><a class="el" href="structcr___sqlite_db.html">cr_SqliteDb</a>* cr_db_open </td>
<td>(</td>
<td class="paramtype">const char * </td>
<td class="paramname"><em>path</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype"><a class="el" href="group__sqlite.html#ga4cd796b21a4888d5c0664199ba2c2fad">cr_DatabaseType</a> </td>
<td class="paramname"><em>db_type</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">GError ** </td>
<td class="paramname"><em>err</em> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div><div class="memdoc">
<p>Open (create new) other sqlite sqlite db.</p>
<ul>
<li>creates db file</li>
<li>opens transaction</li>
<li>creates other tables</li>
<li>creates info table</li>
<li>tweak some db params <dl class="params"><dt>Parameters</dt><dd>
<table class="params">
<tr><td class="paramname">path</td><td>Path to the db file. </td></tr>
<tr><td class="paramname">db_type</td><td>Type of database (primary, filelists, other) </td></tr>
<tr><td class="paramname">err</td><td>**GError </td></tr>
</table>
</dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>Opened db or NULL on error </dd></dl>
</li>
</ul>
</div>
</div>
</div><!-- contents -->
</div><!-- doc-content -->
<!-- start footer part -->
<div id="nav-path" class="navpath"><!-- id is needed for treeview function! -->
<ul>
<li class="footer">Generated on Tue Nov 11 2014 15:15:01 for createrepo_c library by
<a href="http://www.doxygen.org/index.html">
<img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.8.6 </li>
</ul>
</div>
</body>
</html>
