1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
|
<!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"/>
<title>QDjango: Database configuration</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<link href="doxygen.css" rel="stylesheet" type="text/css" />
<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="search/search.js"></script>
<script type="text/javascript">
$(document).ready(function() { searchBox.OnSelectItem(0); });
</script>
</head>
<body>
<div id="top"><!-- do not remove this div! -->
<div id="titlearea">
<table cellspacing="0" cellpadding="0">
<tbody>
<tr style="height: 56px;">
<td style="padding-left: 0.5em;">
<div id="projectname">QDjango
</div>
</td>
</tr>
</tbody>
</table>
</div>
<!-- Generated by Doxygen 1.7.6.1 -->
<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 class="current"><a href="pages.html"><span>Related Pages</span></a></li>
<li><a href="modules.html"><span>Modules</span></a></li>
<li><a href="annotated.html"><span>Classes</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>
<div class="header">
<div class="headertitle">
<div class="title">Database configuration </div> </div>
</div><!--header-->
<div class="contents">
<div class="textblock"><p><a class="el" href="classQDjango.html" title="The QDjango class provides a set of static functions.">QDjango</a> relies on the <a href="http://doc.qt.nokia.com/latest/qtsql.html">QtSql module</a> for database access, which supports a wide array of database drivers.</p>
<h2><a class="anchor" id="setup"></a>
Setting the database</h2>
<p>The first step is to open the database using <a href="http://doc.qt.nokia.com/latest/qsqldatabase.html#addDatabase">QSqlDatabase::addDatabase()</a>, for instance for an in-memory SQLite database:</p>
<div class="fragment"><pre class="fragment">QSqlDatabase db = QSqlDatabase::addDatabase(<span class="stringliteral">"QSQLITE"</span>);
db.setDatabaseName(<span class="stringliteral">":memory:"</span>);
db.open();
</pre></div><p>You should now tell <a class="el" href="classQDjango.html" title="The QDjango class provides a set of static functions.">QDjango</a> to use the database you just opened:</p>
<div class="fragment"><pre class="fragment"><a class="code" href="classQDjango.html#a9a6962db6d787d8bcadc525a01fa6a2d" title="Sets the database used by QDjango.">QDjango::setDatabase</a>(db);
</pre></div><h2><a class="anchor" id="creating"></a>
Creating or dropping database tables</h2>
<p>Once you have set the database and declared all your models (see <a class="el" href="models.html">Database models</a>), you can ask <a class="el" href="classQDjango.html" title="The QDjango class provides a set of static functions.">QDjango</a> to create the database tables for all models:</p>
<div class="fragment"><pre class="fragment"><a class="code" href="classQDjango.html#a7b2c53fdd96b3d6db199e411bb76f0f4" title="Creates the database tables for all registered models.">QDjango::createTables</a>();
</pre></div><p>Conversely, you can ask <a class="el" href="classQDjango.html" title="The QDjango class provides a set of static functions.">QDjango</a> to drop the database tables for all models:</p>
<div class="fragment"><pre class="fragment"><a class="code" href="classQDjango.html#a048353657fcc85d02d136f0342da42c5" title="Drops the database tables for all registered models.">QDjango::dropTables</a>();
</pre></div><h2><a class="anchor" id="threading"></a>
Threading support</h2>
<p>Internally, <a class="el" href="classQDjango.html" title="The QDjango class provides a set of static functions.">QDjango</a> calls the <a class="el" href="classQDjango.html#a944127defa81b71150ae052fe596720f" title="Returns the database used by QDjango.">QDjango::database()</a> method whenever it needs a handle to the database. This method will clone the database connection as needed if it is invoked from a different thread. </p>
</div></div><!-- contents -->
<!-- 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>Classes</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>Typedefs</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(4)"><span class="SelectionMark"> </span>Enumerations</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(5)"><span class="SelectionMark"> </span>Enumerator</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(6)"><span class="SelectionMark"> </span>Properties</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>
<hr class="footer"/><address class="footer"><small>
Generated on Wed May 16 2012 18:11:23 for QDjango by  <a href="http://www.doxygen.org/index.html">
<img class="footer" src="doxygen.png" alt="doxygen"/>
</a> 1.7.6.1
</small></address>
</body>
</html>
|
