<!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"/>
<title>libglom-1.14: Glom::DbUtils Namespace Reference</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<link href="doxygen.css" rel="stylesheet" type="text/css"/>
</head>
<body>
<!-- Generated by Doxygen 1.6.1 -->
<div class="navigation" id="top">
<div class="tabs">
<ul>
<li><a href="index.html"><span>Main Page</span></a></li>
<li class="current"><a href="namespaces.html"><span>Namespaces</span></a></li>
<li><a href="annotated.html"><span>Classes</span></a></li>
</ul>
</div>
<div class="tabs">
<ul>
<li><a href="namespaces.html"><span>Namespace List</span></a></li>
<li><a href="namespacemembers.html"><span>Namespace Members</span></a></li>
</ul>
</div>
<div class="navpath"><a class="el" href="namespaceGlom.html">Glom</a>::<a class="el" href="namespaceGlom_1_1DbUtils.html">DbUtils</a>
</div>
</div>
<div class="contents">
<h1>Glom::DbUtils Namespace Reference</h1><table border="0" cellpadding="0" cellspacing="0">
<tr><td colspan="2"><h2>Typedefs</h2></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">typedef <a class="elRef" href="http://gcc.gnu.org/onlinedocs/libstdc++/latest-doxygen/a00716.html">std::vector</a>< <a class="el" href="classGlom_1_1sharedptr.html">sharedptr</a><br class="typebreak"/>
< <a class="el" href="classGlom_1_1Field.html">Field</a> > > </td><td class="memItemRight" valign="bottom"><a class="el" href="namespaceGlom_1_1DbUtils.html#abb42c8203423a937b841974ac822410c">type_vec_fields</a></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">typedef <a class="elRef" href="http://gcc.gnu.org/onlinedocs/libstdc++/latest-doxygen/a00716.html">std::vector</a><br class="typebreak"/>
< <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a> > </td><td class="memItemRight" valign="bottom"><a class="el" href="namespaceGlom_1_1DbUtils.html#ae9bc6d6b4fb5d622d9aaca35a3d5669c">type_vec_strings</a></td></tr>
<tr><td colspan="2"><h2>Functions</h2></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">bool </td><td class="memItemRight" valign="bottom"><a class="el" href="namespaceGlom_1_1DbUtils.html#a74ca3ca573827b629d8505a9a64f56e3">create_database</a> (<a class="el" href="classGlom_1_1Document.html">Document</a>* document, const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>& database_name, const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>& title, const <a class="elRef" href="../../../libsigc++-2.0/reference/html/classsigc_1_1slot.html">sigc::slot</a>< void >& progress)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">bool </td><td class="memItemRight" valign="bottom"><a class="el" href="namespaceGlom_1_1DbUtils.html#ad4ceee76d0b1ed6efcf33840a5ff44e6">recreate_database_from_document</a> (<a class="el" href="classGlom_1_1Document.html">Document</a>* document, const <a class="elRef" href="../../../libsigc++-2.0/reference/html/classsigc_1_1slot.html">sigc::slot</a>< void >& progress)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="el" href="classGlom_1_1SystemPrefs.html">SystemPrefs</a> </td><td class="memItemRight" valign="bottom"><a class="el" href="namespaceGlom_1_1DbUtils.html#a91478a871fc311c36bac24e48a3c1bea">get_database_preferences</a> (<a class="el" href="classGlom_1_1Document.html">Document</a>* document)</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">This creates the standard tables if necessary, filling them with some information from the document. <a href="#a91478a871fc311c36bac24e48a3c1bea"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="namespaceGlom_1_1DbUtils.html#aecf3de9ed6b204dacd7116f2894013e7">set_database_preferences</a> (<a class="el" href="classGlom_1_1Document.html">Document</a>* document, const <a class="el" href="classGlom_1_1SystemPrefs.html">SystemPrefs</a>& prefs)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">bool </td><td class="memItemRight" valign="bottom"><a class="el" href="namespaceGlom_1_1DbUtils.html#a83d04c8f108de2758c3f92d2da39c47b">add_standard_tables</a> (<a class="el" href="classGlom_1_1Document.html">Document</a>* document)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">bool </td><td class="memItemRight" valign="bottom"><a class="el" href="namespaceGlom_1_1DbUtils.html#adbc2d8d8eb196a30e4ac0dd836497351">add_standard_groups</a> (<a class="el" href="classGlom_1_1Document.html">Document</a>* document)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="elRef" href="http://gcc.gnu.org/onlinedocs/libstdc++/latest-doxygen/a00716.html">type_vec_fields</a> </td><td class="memItemRight" valign="bottom"><a class="el" href="namespaceGlom_1_1DbUtils.html#af4de0e165e8f68f08c2c856305e51e48">get_fields_for_table_from_database</a> (const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>& table_name, bool including_system_fields=false)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">bool </td><td class="memItemRight" valign="bottom"><a class="el" href="namespaceGlom_1_1DbUtils.html#a4304740177c37fe5064fe935d75bc100">get_field_exists_in_database</a> (const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>& table_name, const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>& field_name)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="elRef" href="http://gcc.gnu.org/onlinedocs/libstdc++/latest-doxygen/a00716.html">type_vec_strings</a> </td><td class="memItemRight" valign="bottom"><a class="el" href="namespaceGlom_1_1DbUtils.html#a6bac069d6654e675bc739648dbdc8bbf">get_table_names_from_database</a> (bool ignore_system_tables=false)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">bool </td><td class="memItemRight" valign="bottom"><a class="el" href="namespaceGlom_1_1DbUtils.html#a7b1489bc8fdb5c434ad4ee6cba96d8c9">get_table_exists_in_database</a> (const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>& table_name)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">bool </td><td class="memItemRight" valign="bottom"><a class="el" href="namespaceGlom_1_1DbUtils.html#a62551bf0590fd1de03447367afde2f0a">create_table</a> (const <a class="el" href="classGlom_1_1sharedptr.html">sharedptr</a>< const <a class="el" href="classGlom_1_1TableInfo.html">TableInfo</a> >& table_info, const <a class="elRef" href="http://gcc.gnu.org/onlinedocs/libstdc++/latest-doxygen/a00716.html">Document::type_vec_fields</a>& fields)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">bool </td><td class="memItemRight" valign="bottom"><a class="el" href="namespaceGlom_1_1DbUtils.html#a85188d99df945b3aea151693148ad658">create_table_with_default_fields</a> (<a class="el" href="classGlom_1_1Document.html">Document</a>* document, const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>& table_name)</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Also saves the table information in the document:. <a href="#a85188d99df945b3aea151693148ad658"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">bool </td><td class="memItemRight" valign="bottom"><a class="el" href="namespaceGlom_1_1DbUtils.html#a13bb08a30e11285983135abd6d06e7b4">create_table_add_missing_fields</a> (const <a class="el" href="classGlom_1_1sharedptr.html">sharedptr</a>< const <a class="el" href="classGlom_1_1TableInfo.html">TableInfo</a> >& table_info, const <a class="elRef" href="http://gcc.gnu.org/onlinedocs/libstdc++/latest-doxygen/a00716.html">Document::type_vec_fields</a>& fields)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">bool </td><td class="memItemRight" valign="bottom"><a class="el" href="namespaceGlom_1_1DbUtils.html#a7cd3f238eb92dfe05a4a1e90951e9bcc">add_column</a> (const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>& table_name, const <a class="el" href="classGlom_1_1sharedptr.html">sharedptr</a>< const <a class="el" href="classGlom_1_1Field.html">Field</a> >& field, Gtk::Window* parent_window)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">bool </td><td class="memItemRight" valign="bottom"><a class="el" href="namespaceGlom_1_1DbUtils.html#a91dce7a060ca1c249d77e26f34e5ec94">drop_column</a> (const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>& table_name, const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>& field_name)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">bool </td><td class="memItemRight" valign="bottom"><a class="el" href="namespaceGlom_1_1DbUtils.html#a7dbd8b794276e7bade759eb1e3e6faf3">insert_example_data</a> (<a class="el" href="classGlom_1_1Document.html">Document</a>* document, const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>& table_name)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1RefPtr.html">Glib::RefPtr</a><br class="typebreak"/>
< Gnome::Gda::DataModel > </td><td class="memItemRight" valign="bottom"><a class="el" href="namespaceGlom_1_1DbUtils.html#aa7e3c7e44ee803b29de888b4839dd90d">query_execute_select</a> (const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1RefPtr.html">Glib::RefPtr</a>< const Gnome::Gda::SqlBuilder >& builder, bool use_cursor=false)</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Execute a SQL Select command, returning the result. <a href="#aa7e3c7e44ee803b29de888b4839dd90d"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">bool </td><td class="memItemRight" valign="bottom"><a class="el" href="namespaceGlom_1_1DbUtils.html#ab5f26298a395abc3b9b2b503ebd49178">query_execute_string</a> (const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>& strQuery, const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1RefPtr.html">Glib::RefPtr</a>< Gnome::Gda::Set >& params=<a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1RefPtr.html">Glib::RefPtr</a>< Gnome::Gda::Set >(0))</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Execute a SQL non-select command, returning true if it succeeded. <a href="#ab5f26298a395abc3b9b2b503ebd49178"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">bool </td><td class="memItemRight" valign="bottom"><a class="el" href="namespaceGlom_1_1DbUtils.html#a7df091154f81400dfaf04c8b2005d3eb">query_execute</a> (const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1RefPtr.html">Glib::RefPtr</a>< const Gnome::Gda::SqlBuilder >& builder)</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Execute a SQL non-select command, returning true if it succeeded. <a href="#a7df091154f81400dfaf04c8b2005d3eb"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">Gnome::Gda::Value </td><td class="memItemRight" valign="bottom"><a class="el" href="namespaceGlom_1_1DbUtils.html#abd90a12ee756f6eee5bc7b5911aef431">auto_increment_insert_first_if_necessary</a> (const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>& table_name, const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>& field_name)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">Gnome::Gda::Value </td><td class="memItemRight" valign="bottom"><a class="el" href="namespaceGlom_1_1DbUtils.html#ac8dec35caeb1bfd4300a881ef466962b">get_next_auto_increment_value</a> (const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>& table_name, const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>& field_name)</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Get the next auto-increment value for this primary key, from the glom system table. <a href="#ac8dec35caeb1bfd4300a881ef466962b"></a><br/></td></tr>
</table>
<hr/><h2>Typedef Documentation</h2>
<a class="anchor" id="abb42c8203423a937b841974ac822410c"></a><!-- doxytag: member="Glom::DbUtils::type_vec_fields" ref="abb42c8203423a937b841974ac822410c" args="" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">typedef <a class="elRef" href="http://gcc.gnu.org/onlinedocs/libstdc++/latest-doxygen/a00716.html">std::vector</a>< <a class="el" href="classGlom_1_1sharedptr.html">sharedptr</a><<a class="el" href="classGlom_1_1Field.html">Field</a>> > <a class="elRef" href="http://gcc.gnu.org/onlinedocs/libstdc++/latest-doxygen/a00716.html">Glom::DbUtils::type_vec_fields</a></td>
</tr>
</table>
</div>
<div class="memdoc">
</div>
</div>
<a class="anchor" id="ae9bc6d6b4fb5d622d9aaca35a3d5669c"></a><!-- doxytag: member="Glom::DbUtils::type_vec_strings" ref="ae9bc6d6b4fb5d622d9aaca35a3d5669c" args="" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">typedef <a class="elRef" href="http://gcc.gnu.org/onlinedocs/libstdc++/latest-doxygen/a00716.html">std::vector</a><<a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>> <a class="elRef" href="http://gcc.gnu.org/onlinedocs/libstdc++/latest-doxygen/a00716.html">Glom::DbUtils::type_vec_strings</a></td>
</tr>
</table>
</div>
<div class="memdoc">
</div>
</div>
<hr/><h2>Function Documentation</h2>
<a class="anchor" id="a7cd3f238eb92dfe05a4a1e90951e9bcc"></a><!-- doxytag: member="Glom::DbUtils::add_column" ref="a7cd3f238eb92dfe05a4a1e90951e9bcc" args="(const Glib::ustring &table_name, const sharedptr< const Field > &field, Gtk::Window *parent_window)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">bool Glom::DbUtils::add_column </td>
<td>(</td>
<td class="paramtype">const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a> & </td>
<td class="paramname"> <em>table_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">const sharedptr< const Field > & </td>
<td class="paramname"> <em>field</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">Gtk::Window * </td>
<td class="paramname"> <em>parent_window</em></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td></td>
</tr>
</table>
</div>
<div class="memdoc">
</div>
</div>
<a class="anchor" id="adbc2d8d8eb196a30e4ac0dd836497351"></a><!-- doxytag: member="Glom::DbUtils::add_standard_groups" ref="adbc2d8d8eb196a30e4ac0dd836497351" args="(Document *document)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">bool Glom::DbUtils::add_standard_groups </td>
<td>(</td>
<td class="paramtype">Document * </td>
<td class="paramname"> <em>document</em></td>
<td> ) </td>
<td></td>
</tr>
</table>
</div>
<div class="memdoc">
</div>
</div>
<a class="anchor" id="a83d04c8f108de2758c3f92d2da39c47b"></a><!-- doxytag: member="Glom::DbUtils::add_standard_tables" ref="a83d04c8f108de2758c3f92d2da39c47b" args="(Document *document)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">bool Glom::DbUtils::add_standard_tables </td>
<td>(</td>
<td class="paramtype">Document * </td>
<td class="paramname"> <em>document</em></td>
<td> ) </td>
<td></td>
</tr>
</table>
</div>
<div class="memdoc">
</div>
</div>
<a class="anchor" id="abd90a12ee756f6eee5bc7b5911aef431"></a><!-- doxytag: member="Glom::DbUtils::auto_increment_insert_first_if_necessary" ref="abd90a12ee756f6eee5bc7b5911aef431" args="(const Glib::ustring &table_name, const Glib::ustring &field_name)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">Gnome::Gda::Value Glom::DbUtils::auto_increment_insert_first_if_necessary </td>
<td>(</td>
<td class="paramtype">const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a> & </td>
<td class="paramname"> <em>table_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a> & </td>
<td class="paramname"> <em>field_name</em></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td></td>
</tr>
</table>
</div>
<div class="memdoc">
</div>
</div>
<a class="anchor" id="a74ca3ca573827b629d8505a9a64f56e3"></a><!-- doxytag: member="Glom::DbUtils::create_database" ref="a74ca3ca573827b629d8505a9a64f56e3" args="(Document *document, const Glib::ustring &database_name, const Glib::ustring &title, const sigc::slot< void > &progress)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">bool Glom::DbUtils::create_database </td>
<td>(</td>
<td class="paramtype">Document * </td>
<td class="paramname"> <em>document</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a> & </td>
<td class="paramname"> <em>database_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a> & </td>
<td class="paramname"> <em>title</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">const <a class="elRef" href="../../../libsigc++-2.0/reference/html/classsigc_1_1slot.html">sigc::slot</a>< void > & </td>
<td class="paramname"> <em>progress</em></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td></td>
</tr>
</table>
</div>
<div class="memdoc">
</div>
</div>
<a class="anchor" id="a62551bf0590fd1de03447367afde2f0a"></a><!-- doxytag: member="Glom::DbUtils::create_table" ref="a62551bf0590fd1de03447367afde2f0a" args="(const sharedptr< const TableInfo > &table_info, const Document::type_vec_fields &fields)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">bool Glom::DbUtils::create_table </td>
<td>(</td>
<td class="paramtype">const sharedptr< const TableInfo > & </td>
<td class="paramname"> <em>table_info</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">const Document::type_vec_fields & </td>
<td class="paramname"> <em>fields</em></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td></td>
</tr>
</table>
</div>
<div class="memdoc">
</div>
</div>
<a class="anchor" id="a13bb08a30e11285983135abd6d06e7b4"></a><!-- doxytag: member="Glom::DbUtils::create_table_add_missing_fields" ref="a13bb08a30e11285983135abd6d06e7b4" args="(const sharedptr< const TableInfo > &table_info, const Document::type_vec_fields &fields)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">bool Glom::DbUtils::create_table_add_missing_fields </td>
<td>(</td>
<td class="paramtype">const sharedptr< const TableInfo > & </td>
<td class="paramname"> <em>table_info</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">const Document::type_vec_fields & </td>
<td class="paramname"> <em>fields</em></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td></td>
</tr>
</table>
</div>
<div class="memdoc">
</div>
</div>
<a class="anchor" id="a85188d99df945b3aea151693148ad658"></a><!-- doxytag: member="Glom::DbUtils::create_table_with_default_fields" ref="a85188d99df945b3aea151693148ad658" args="(Document *document, const Glib::ustring &table_name)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">bool Glom::DbUtils::create_table_with_default_fields </td>
<td>(</td>
<td class="paramtype">Document * </td>
<td class="paramname"> <em>document</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a> & </td>
<td class="paramname"> <em>table_name</em></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>Also saves the table information in the document:. </p>
</div>
</div>
<a class="anchor" id="a91dce7a060ca1c249d77e26f34e5ec94"></a><!-- doxytag: member="Glom::DbUtils::drop_column" ref="a91dce7a060ca1c249d77e26f34e5ec94" args="(const Glib::ustring &table_name, const Glib::ustring &field_name)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">bool Glom::DbUtils::drop_column </td>
<td>(</td>
<td class="paramtype">const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a> & </td>
<td class="paramname"> <em>table_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a> & </td>
<td class="paramname"> <em>field_name</em></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td></td>
</tr>
</table>
</div>
<div class="memdoc">
</div>
</div>
<a class="anchor" id="a91478a871fc311c36bac24e48a3c1bea"></a><!-- doxytag: member="Glom::DbUtils::get_database_preferences" ref="a91478a871fc311c36bac24e48a3c1bea" args="(Document *document)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname"><a class="el" href="classGlom_1_1SystemPrefs.html">SystemPrefs</a> Glom::DbUtils::get_database_preferences </td>
<td>(</td>
<td class="paramtype">Document * </td>
<td class="paramname"> <em>document</em></td>
<td> ) </td>
<td></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>This creates the standard tables if necessary, filling them with some information from the document. </p>
</div>
</div>
<a class="anchor" id="a4304740177c37fe5064fe935d75bc100"></a><!-- doxytag: member="Glom::DbUtils::get_field_exists_in_database" ref="a4304740177c37fe5064fe935d75bc100" args="(const Glib::ustring &table_name, const Glib::ustring &field_name)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">bool Glom::DbUtils::get_field_exists_in_database </td>
<td>(</td>
<td class="paramtype">const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a> & </td>
<td class="paramname"> <em>table_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a> & </td>
<td class="paramname"> <em>field_name</em></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td></td>
</tr>
</table>
</div>
<div class="memdoc">
</div>
</div>
<a class="anchor" id="af4de0e165e8f68f08c2c856305e51e48"></a><!-- doxytag: member="Glom::DbUtils::get_fields_for_table_from_database" ref="af4de0e165e8f68f08c2c856305e51e48" args="(const Glib::ustring &table_name, bool including_system_fields=false)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname"><a class="elRef" href="http://gcc.gnu.org/onlinedocs/libstdc++/latest-doxygen/a00716.html">type_vec_fields</a> Glom::DbUtils::get_fields_for_table_from_database </td>
<td>(</td>
<td class="paramtype">const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a> & </td>
<td class="paramname"> <em>table_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">bool </td>
<td class="paramname"> <em>including_system_fields</em> = <code>false</code></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td></td>
</tr>
</table>
</div>
<div class="memdoc">
</div>
</div>
<a class="anchor" id="ac8dec35caeb1bfd4300a881ef466962b"></a><!-- doxytag: member="Glom::DbUtils::get_next_auto_increment_value" ref="ac8dec35caeb1bfd4300a881ef466962b" args="(const Glib::ustring &table_name, const Glib::ustring &field_name)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">Gnome::Gda::Value Glom::DbUtils::get_next_auto_increment_value </td>
<td>(</td>
<td class="paramtype">const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a> & </td>
<td class="paramname"> <em>table_name</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a> & </td>
<td class="paramname"> <em>field_name</em></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>Get the next auto-increment value for this primary key, from the glom system table. </p>
<p>Add a row for this field in the system table if it does not exist already. </p>
</div>
</div>
<a class="anchor" id="a7b1489bc8fdb5c434ad4ee6cba96d8c9"></a><!-- doxytag: member="Glom::DbUtils::get_table_exists_in_database" ref="a7b1489bc8fdb5c434ad4ee6cba96d8c9" args="(const Glib::ustring &table_name)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">bool Glom::DbUtils::get_table_exists_in_database </td>
<td>(</td>
<td class="paramtype">const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a> & </td>
<td class="paramname"> <em>table_name</em></td>
<td> ) </td>
<td></td>
</tr>
</table>
</div>
<div class="memdoc">
</div>
</div>
<a class="anchor" id="a6bac069d6654e675bc739648dbdc8bbf"></a><!-- doxytag: member="Glom::DbUtils::get_table_names_from_database" ref="a6bac069d6654e675bc739648dbdc8bbf" args="(bool ignore_system_tables=false)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname"><a class="elRef" href="http://gcc.gnu.org/onlinedocs/libstdc++/latest-doxygen/a00716.html">type_vec_strings</a> Glom::DbUtils::get_table_names_from_database </td>
<td>(</td>
<td class="paramtype">bool </td>
<td class="paramname"> <em>ignore_system_tables</em> = <code>false</code></td>
<td> ) </td>
<td></td>
</tr>
</table>
</div>
<div class="memdoc">
</div>
</div>
<a class="anchor" id="a7dbd8b794276e7bade759eb1e3e6faf3"></a><!-- doxytag: member="Glom::DbUtils::insert_example_data" ref="a7dbd8b794276e7bade759eb1e3e6faf3" args="(Document *document, const Glib::ustring &table_name)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">bool Glom::DbUtils::insert_example_data </td>
<td>(</td>
<td class="paramtype">Document * </td>
<td class="paramname"> <em>document</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a> & </td>
<td class="paramname"> <em>table_name</em></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td></td>
</tr>
</table>
</div>
<div class="memdoc">
</div>
</div>
<a class="anchor" id="a7df091154f81400dfaf04c8b2005d3eb"></a><!-- doxytag: member="Glom::DbUtils::query_execute" ref="a7df091154f81400dfaf04c8b2005d3eb" args="(const Glib::RefPtr< const Gnome::Gda::SqlBuilder > &builder)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">bool Glom::DbUtils::query_execute </td>
<td>(</td>
<td class="paramtype">const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1RefPtr.html">Glib::RefPtr</a>< const Gnome::Gda::SqlBuilder > & </td>
<td class="paramname"> <em>builder</em></td>
<td> ) </td>
<td></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>Execute a SQL non-select command, returning true if it succeeded. </p>
</div>
</div>
<a class="anchor" id="aa7e3c7e44ee803b29de888b4839dd90d"></a><!-- doxytag: member="Glom::DbUtils::query_execute_select" ref="aa7e3c7e44ee803b29de888b4839dd90d" args="(const Glib::RefPtr< const Gnome::Gda::SqlBuilder > &builder, bool use_cursor=false)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname"><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1RefPtr.html">Glib::RefPtr</a><Gnome::Gda::DataModel> Glom::DbUtils::query_execute_select </td>
<td>(</td>
<td class="paramtype">const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1RefPtr.html">Glib::RefPtr</a>< const Gnome::Gda::SqlBuilder > & </td>
<td class="paramname"> <em>builder</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">bool </td>
<td class="paramname"> <em>use_cursor</em> = <code>false</code></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>Execute a SQL Select command, returning the result. </p>
<dl><dt><b>Parameters:</b></dt><dd>
<table border="0" cellspacing="2" cellpadding="0">
<tr><td valign="top"></td><td valign="top"><em>builder</em> </td><td>The finished SqlBuilder object. Whether the data model should be cursor-based (not allowing random access). </td></tr>
</table>
</dd>
</dl>
</div>
</div>
<a class="anchor" id="ab5f26298a395abc3b9b2b503ebd49178"></a><!-- doxytag: member="Glom::DbUtils::query_execute_string" ref="ab5f26298a395abc3b9b2b503ebd49178" args="(const Glib::ustring &strQuery, const Glib::RefPtr< Gnome::Gda::Set > &params=Glib::RefPtr< Gnome::Gda::Set >(0))" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">bool Glom::DbUtils::query_execute_string </td>
<td>(</td>
<td class="paramtype">const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a> & </td>
<td class="paramname"> <em>strQuery</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1RefPtr.html">Glib::RefPtr</a>< Gnome::Gda::Set > & </td>
<td class="paramname"> <em>params</em> = <code><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1RefPtr.html">Glib::RefPtr</a>< Gnome::Gda::Set >(0)</code></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>Execute a SQL non-select command, returning true if it succeeded. </p>
<p>See also <a class="el" href="namespaceGlom_1_1DbUtils.html#a7df091154f81400dfaf04c8b2005d3eb" title="Execute a SQL non-select command, returning true if it succeeded.">query_execute()</a>, which takes a SqlBuilder. This should only be used for SQL commands that are not supported by SqlBuilder, such as ADD GROUP. </p>
</div>
</div>
<a class="anchor" id="ad4ceee76d0b1ed6efcf33840a5ff44e6"></a><!-- doxytag: member="Glom::DbUtils::recreate_database_from_document" ref="ad4ceee76d0b1ed6efcf33840a5ff44e6" args="(Document *document, const sigc::slot< void > &progress)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">bool Glom::DbUtils::recreate_database_from_document </td>
<td>(</td>
<td class="paramtype">Document * </td>
<td class="paramname"> <em>document</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">const <a class="elRef" href="../../../libsigc++-2.0/reference/html/classsigc_1_1slot.html">sigc::slot</a>< void > & </td>
<td class="paramname"> <em>progress</em></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td></td>
</tr>
</table>
</div>
<div class="memdoc">
</div>
</div>
<a class="anchor" id="aecf3de9ed6b204dacd7116f2894013e7"></a><!-- doxytag: member="Glom::DbUtils::set_database_preferences" ref="aecf3de9ed6b204dacd7116f2894013e7" args="(Document *document, const SystemPrefs &prefs)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void Glom::DbUtils::set_database_preferences </td>
<td>(</td>
<td class="paramtype">Document * </td>
<td class="paramname"> <em>document</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">const SystemPrefs & </td>
<td class="paramname"> <em>prefs</em></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td></td>
</tr>
</table>
</div>
<div class="memdoc">
</div>
</div>
</div>
<hr size="1"/><address style="text-align: right;"><small>Generated on Wed May 26 01:04:13 2010 for libglom-1.14 by 
<a href="http://www.doxygen.org/index.html">
<img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.6.1 </small></address>
</body>
</html>
