FMDatabase+FMDatabaseAdditions.html 38 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455
  1. <!DOCTYPE HTML>
  2. <html>
  3. <head>
  4. <meta http-equiv="Content-Type" content="html/html; charset=utf-8" />
  5. <title>FMDatabase(FMDatabaseAdditions) Category Reference</title>
  6. <meta id="xcode-display" name="xcode-display" content="render"/>
  7. <meta name="viewport" content="width=550" />
  8. <link rel="stylesheet" type="text/css" href="../css/styles.css" media="all" />
  9. <link rel="stylesheet" type="text/css" media="print" href="../css/stylesPrint.css" />
  10. <meta name="generator" content="appledoc 2.1 (build 858)" />
  11. </head>
  12. <body>
  13. <header id="top_header">
  14. <div id="library" class="hideInXcode">
  15. <h1><a id="libraryTitle" href="../index.html">FMDB </a></h1>
  16. <a id="developerHome" href="../index.html">ccgus</a>
  17. </div>
  18. <div id="title" role="banner">
  19. <h1 class="hideInXcode">FMDatabase(FMDatabaseAdditions) Category Reference</h1>
  20. </div>
  21. <ul id="headerButtons" role="toolbar">
  22. <li id="toc_button">
  23. <button aria-label="Show Table of Contents" role="checkbox" class="open" id="table_of_contents"><span class="disclosure"></span>Table of Contents</button>
  24. </li>
  25. <li id="jumpto_button" role="navigation">
  26. <select id="jumpTo">
  27. <option value="top">Jump To&#133;</option>
  28. <option value="overview">Overview</option>
  29. <option value="tasks">Tasks</option>
  30. <option value="instance_methods">Instance Methods</option>
  31. <option value="//api/name/applicationID">&nbsp;&nbsp;&nbsp;&nbsp;- applicationID</option>
  32. <option value="//api/name/applicationIDString">&nbsp;&nbsp;&nbsp;&nbsp;- applicationIDString</option>
  33. <option value="//api/name/boolForQuery:">&nbsp;&nbsp;&nbsp;&nbsp;- boolForQuery:</option>
  34. <option value="//api/name/columnExists:columnName:">&nbsp;&nbsp;&nbsp;&nbsp;- columnExists:columnName:</option>
  35. <option value="//api/name/columnExists:inTableWithName:">&nbsp;&nbsp;&nbsp;&nbsp;- columnExists:inTableWithName:</option>
  36. <option value="//api/name/dataForQuery:">&nbsp;&nbsp;&nbsp;&nbsp;- dataForQuery:</option>
  37. <option value="//api/name/dateForQuery:">&nbsp;&nbsp;&nbsp;&nbsp;- dateForQuery:</option>
  38. <option value="//api/name/doubleForQuery:">&nbsp;&nbsp;&nbsp;&nbsp;- doubleForQuery:</option>
  39. <option value="//api/name/getSchema">&nbsp;&nbsp;&nbsp;&nbsp;- getSchema</option>
  40. <option value="//api/name/getTableSchema:">&nbsp;&nbsp;&nbsp;&nbsp;- getTableSchema:</option>
  41. <option value="//api/name/intForQuery:">&nbsp;&nbsp;&nbsp;&nbsp;- intForQuery:</option>
  42. <option value="//api/name/longForQuery:">&nbsp;&nbsp;&nbsp;&nbsp;- longForQuery:</option>
  43. <option value="//api/name/setApplicationID:">&nbsp;&nbsp;&nbsp;&nbsp;- setApplicationID:</option>
  44. <option value="//api/name/setApplicationIDString:">&nbsp;&nbsp;&nbsp;&nbsp;- setApplicationIDString:</option>
  45. <option value="//api/name/stringForQuery:">&nbsp;&nbsp;&nbsp;&nbsp;- stringForQuery:</option>
  46. <option value="//api/name/tableExists:">&nbsp;&nbsp;&nbsp;&nbsp;- tableExists:</option>
  47. <option value="//api/name/validateSQL:error:">&nbsp;&nbsp;&nbsp;&nbsp;- validateSQL:error:</option>
  48. </select>
  49. </li>
  50. </ul>
  51. </header>
  52. <nav id="tocContainer" class="isShowingTOC">
  53. <ul id="toc" role="tree">
  54. <li role="treeitem"><span class="nodisclosure"></span><span class="sectionName"><a href="#overview">Overview</a></span></li>
  55. <li role="treeitem" id="task_treeitem"><span class="nodisclosure"></span><span class="sectionName"><a href="#tasks">Tasks</a></span><ul>
  56. <li><span class="nodisclosure"></span><span class="sectionName"><a href="#task_Return results of SQL to variable">Return results of SQL to variable</a></span></li>
  57. <li><span class="nodisclosure"></span><span class="sectionName"><a href="#task_Schema related operations">Schema related operations</a></span></li>
  58. <li><span class="nodisclosure"></span><span class="sectionName"><a href="#task_Application identifier tasks">Application identifier tasks</a></span></li>
  59. </ul></li>
  60. <li role="treeitem" class="children"><span class="disclosure"></span><span class="sectionName"><a href="#instance_methods">Instance Methods</a></span><ul>
  61. <li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/applicationID">applicationID</a></span></li>
  62. <li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/applicationIDString">applicationIDString</a></span></li>
  63. <li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/boolForQuery:">boolForQuery:</a></span></li>
  64. <li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/columnExists:columnName:">columnExists:columnName:</a></span></li>
  65. <li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/columnExists:inTableWithName:">columnExists:inTableWithName:</a></span></li>
  66. <li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/dataForQuery:">dataForQuery:</a></span></li>
  67. <li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/dateForQuery:">dateForQuery:</a></span></li>
  68. <li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/doubleForQuery:">doubleForQuery:</a></span></li>
  69. <li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/getSchema">getSchema</a></span></li>
  70. <li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/getTableSchema:">getTableSchema:</a></span></li>
  71. <li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/intForQuery:">intForQuery:</a></span></li>
  72. <li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/longForQuery:">longForQuery:</a></span></li>
  73. <li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/setApplicationID:">setApplicationID:</a></span></li>
  74. <li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/setApplicationIDString:">setApplicationIDString:</a></span></li>
  75. <li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/stringForQuery:">stringForQuery:</a></span></li>
  76. <li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/tableExists:">tableExists:</a></span></li>
  77. <li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/validateSQL:error:">validateSQL:error:</a></span></li>
  78. </ul></li>
  79. </ul>
  80. </nav>
  81. <article>
  82. <div id="contents" class="isShowingTOC" role="main">
  83. <a title="FMDatabase(FMDatabaseAdditions) Category Reference" name="top"></a>
  84. <div class="main-navigation navigation-top">
  85. <ul>
  86. <li><a href="../index.html">Index</a></li>
  87. <li><a href="../hierarchy.html">Hierarchy</a></li>
  88. </ul>
  89. </div>
  90. <div id="header">
  91. <div class="section-header">
  92. <h1 class="title title-header">FMDatabase(FMDatabaseAdditions) Category Reference</h1>
  93. </div>
  94. </div>
  95. <div id="container">
  96. <div class="section section-specification"><table cellspacing="0"><tbody>
  97. <tr>
  98. <td class="specification-title">Declared in</td>
  99. <td class="specification-value">FMDatabaseAdditions.h<br />FMDatabaseAdditions.m</td>
  100. </tr>
  101. </tbody></table></div>
  102. <div class="section section-overview">
  103. <a title="Overview" name="overview"></a>
  104. <h2 class="subtitle subtitle-overview">Overview</h2>
  105. <p>Category of additions for <a href="../Classes/FMDatabase.html"><code>FMDatabase</code></a> class.</p>
  106. <h3>See also</h3>
  107. <ul>
  108. <li><a href="../Classes/FMDatabase.html"><code>FMDatabase</code></a></li>
  109. </ul>
  110. </div>
  111. <div class="section section-tasks">
  112. <a title="Tasks" name="tasks"></a>
  113. <h2 class="subtitle subtitle-tasks">Tasks</h2>
  114. <a title="Return results of SQL to variable" name="task_Return results of SQL to variable"></a>
  115. <h3 class="subsubtitle task-title">Return results of SQL to variable</h3>
  116. <ul class="task-list">
  117. <li>
  118. <span class="tooltip">
  119. <code><a href="#//api/name/intForQuery:">&ndash;&nbsp;intForQuery:</a></code>
  120. <span class="tooltip"><p>Return <code>int</code> value for query</p></span>
  121. </span>
  122. </li><li>
  123. <span class="tooltip">
  124. <code><a href="#//api/name/longForQuery:">&ndash;&nbsp;longForQuery:</a></code>
  125. <span class="tooltip"><p>Return <code>long</code> value for query</p></span>
  126. </span>
  127. </li><li>
  128. <span class="tooltip">
  129. <code><a href="#//api/name/boolForQuery:">&ndash;&nbsp;boolForQuery:</a></code>
  130. <span class="tooltip"><p>Return <code>BOOL</code> value for query</p></span>
  131. </span>
  132. </li><li>
  133. <span class="tooltip">
  134. <code><a href="#//api/name/doubleForQuery:">&ndash;&nbsp;doubleForQuery:</a></code>
  135. <span class="tooltip"><p>Return <code>double</code> value for query</p></span>
  136. </span>
  137. </li><li>
  138. <span class="tooltip">
  139. <code><a href="#//api/name/stringForQuery:">&ndash;&nbsp;stringForQuery:</a></code>
  140. <span class="tooltip"><p>Return <code>NSString</code> value for query</p></span>
  141. </span>
  142. </li><li>
  143. <span class="tooltip">
  144. <code><a href="#//api/name/dataForQuery:">&ndash;&nbsp;dataForQuery:</a></code>
  145. <span class="tooltip"><p>Return <code>NSData</code> value for query</p></span>
  146. </span>
  147. </li><li>
  148. <span class="tooltip">
  149. <code><a href="#//api/name/dateForQuery:">&ndash;&nbsp;dateForQuery:</a></code>
  150. <span class="tooltip"><p>Return <code>NSDate</code> value for query</p></span>
  151. </span>
  152. </li>
  153. </ul>
  154. <a title="Schema related operations" name="task_Schema related operations"></a>
  155. <h3 class="subsubtitle task-title">Schema related operations</h3>
  156. <ul class="task-list">
  157. <li>
  158. <span class="tooltip">
  159. <code><a href="#//api/name/tableExists:">&ndash;&nbsp;tableExists:</a></code>
  160. <span class="tooltip"><p>Does table exist in database?</p></span>
  161. </span>
  162. </li><li>
  163. <span class="tooltip">
  164. <code><a href="#//api/name/getSchema">&ndash;&nbsp;getSchema</a></code>
  165. <span class="tooltip"><p>The schema of the database.</p></span>
  166. </span>
  167. </li><li>
  168. <span class="tooltip">
  169. <code><a href="#//api/name/getTableSchema:">&ndash;&nbsp;getTableSchema:</a></code>
  170. <span class="tooltip"><p>The schema of the database.</p></span>
  171. </span>
  172. </li><li>
  173. <span class="tooltip">
  174. <code><a href="#//api/name/columnExists:inTableWithName:">&ndash;&nbsp;columnExists:inTableWithName:</a></code>
  175. <span class="tooltip"><p>Test to see if particular column exists for particular table in database</p></span>
  176. </span>
  177. </li><li>
  178. <span class="tooltip">
  179. <code><a href="#//api/name/columnExists:columnName:">&ndash;&nbsp;columnExists:columnName:</a></code>
  180. <span class="tooltip"><p>Test to see if particular column exists for particular table in database</p></span>
  181. </span>
  182. </li><li>
  183. <span class="tooltip">
  184. <code><a href="#//api/name/validateSQL:error:">&ndash;&nbsp;validateSQL:error:</a></code>
  185. <span class="tooltip"><p>Validate SQL statement</p></span>
  186. </span>
  187. </li>
  188. </ul>
  189. <a title="Application identifier tasks" name="task_Application identifier tasks"></a>
  190. <h3 class="subsubtitle task-title">Application identifier tasks</h3>
  191. <ul class="task-list">
  192. <li>
  193. <span class="tooltip">
  194. <code><a href="#//api/name/applicationID">&ndash;&nbsp;applicationID</a></code>
  195. <span class="tooltip"><p>Retrieve application ID</p></span>
  196. </span>
  197. </li><li>
  198. <span class="tooltip">
  199. <code><a href="#//api/name/setApplicationID:">&ndash;&nbsp;setApplicationID:</a></code>
  200. <span class="tooltip"><p>Set the application ID</p></span>
  201. </span>
  202. </li><li>
  203. <span class="tooltip">
  204. <code><a href="#//api/name/applicationIDString">&ndash;&nbsp;applicationIDString</a></code>
  205. <span class="tooltip"><p>Retrieve application ID string</p></span>
  206. </span>
  207. </li><li>
  208. <span class="tooltip">
  209. <code><a href="#//api/name/setApplicationIDString:">&ndash;&nbsp;setApplicationIDString:</a></code>
  210. <span class="tooltip"><p>Set the application ID string</p></span>
  211. </span>
  212. </li>
  213. </ul>
  214. </div>
  215. <div class="section section-methods">
  216. <a title="Instance Methods" name="instance_methods"></a>
  217. <h2 class="subtitle subtitle-methods">Instance Methods</h2>
  218. <div class="section-method">
  219. <a name="//api/name/applicationID" title="applicationID"></a>
  220. <h3 class="subsubtitle method-title">applicationID</h3>
  221. <div class="method-subsection brief-description">
  222. <p>Retrieve application ID</p>
  223. </div>
  224. <div class="method-subsection method-declaration"><code>- (uint32_t)applicationID</code></div>
  225. <div class="method-subsection return">
  226. <h4 class="method-subtitle parameter-title">Return Value</h4>
  227. <p>The <code>uint32_t</code> numeric value of the application ID.</p>
  228. </div>
  229. <div class="method-subsection see-also-section">
  230. <h4 class="method-subtitle">See Also</h4>
  231. <ul>
  232. <li><code><p><a href="#//api/name/setApplicationID:">- setApplicationID:</a></p></code></li>
  233. </ul>
  234. </div>
  235. <div class="method-subsection declared-in-section">
  236. <h4 class="method-subtitle">Declared In</h4>
  237. <code class="declared-in-ref">FMDatabaseAdditions.h</code><br />
  238. </div>
  239. </div>
  240. <div class="section-method">
  241. <a name="//api/name/applicationIDString" title="applicationIDString"></a>
  242. <h3 class="subsubtitle method-title">applicationIDString</h3>
  243. <div class="method-subsection brief-description">
  244. <p>Retrieve application ID string</p>
  245. </div>
  246. <div class="method-subsection method-declaration"><code>- (NSString *)applicationIDString</code></div>
  247. <div class="method-subsection return">
  248. <h4 class="method-subtitle parameter-title">Return Value</h4>
  249. <p>The <code>NSString</code> value of the application ID.</p>
  250. </div>
  251. <div class="method-subsection see-also-section">
  252. <h4 class="method-subtitle">See Also</h4>
  253. <ul>
  254. <li><code><p><a href="#//api/name/setApplicationIDString:">- setApplicationIDString:</a></p></code></li>
  255. </ul>
  256. </div>
  257. <div class="method-subsection declared-in-section">
  258. <h4 class="method-subtitle">Declared In</h4>
  259. <code class="declared-in-ref">FMDatabaseAdditions.h</code><br />
  260. </div>
  261. </div>
  262. <div class="section-method">
  263. <a name="//api/name/boolForQuery:" title="boolForQuery:"></a>
  264. <h3 class="subsubtitle method-title">boolForQuery:</h3>
  265. <div class="method-subsection brief-description">
  266. <p>Return <code>BOOL</code> value for query</p>
  267. </div>
  268. <div class="method-subsection method-declaration"><code>- (BOOL)boolForQuery:(NSString *)<em>query</em>, <em>...</em></code></div>
  269. <div class="method-subsection arguments-section parameters">
  270. <h4 class="method-subtitle parameter-title">Parameters</h4>
  271. <dl class="argument-def parameter-def">
  272. <dt><em>query</em></dt>
  273. <dd><p>The SQL query to be performed.</p></dd>
  274. </dl>
  275. <dl class="argument-def parameter-def">
  276. <dt><em>...</em></dt>
  277. <dd><p>A list of parameters that will be bound to the <code>?</code> placeholders in the SQL query.</p></dd>
  278. </dl>
  279. </div>
  280. <div class="method-subsection return">
  281. <h4 class="method-subtitle parameter-title">Return Value</h4>
  282. <p><code>BOOL</code> value.</p>
  283. </div>
  284. <div class="method-subsection declared-in-section">
  285. <h4 class="method-subtitle">Declared In</h4>
  286. <code class="declared-in-ref">FMDatabaseAdditions.h</code><br />
  287. </div>
  288. </div>
  289. <div class="section-method">
  290. <a name="//api/name/columnExists:columnName:" title="columnExists:columnName:"></a>
  291. <h3 class="subsubtitle method-title">columnExists:columnName:</h3>
  292. <div class="method-subsection brief-description">
  293. <p>Test to see if particular column exists for particular table in database</p>
  294. </div>
  295. <div class="method-subsection method-declaration"><code>- (BOOL)columnExists:(NSString *)<em>tableName</em> columnName:(NSString *)<em>columnName</em></code></div>
  296. <div class="method-subsection arguments-section parameters">
  297. <h4 class="method-subtitle parameter-title">Parameters</h4>
  298. <dl class="argument-def parameter-def">
  299. <dt><em>tableName</em></dt>
  300. <dd><p>The name of the table.</p></dd>
  301. </dl>
  302. <dl class="argument-def parameter-def">
  303. <dt><em>columnName</em></dt>
  304. <dd><p>The name of the column.</p></dd>
  305. </dl>
  306. </div>
  307. <div class="method-subsection return">
  308. <h4 class="method-subtitle parameter-title">Return Value</h4>
  309. <p><code>YES</code> if column exists in table in question; <code>NO</code> otherwise.</p>
  310. </div>
  311. <div class="method-subsection discussion-section">
  312. <h4 class="method-subtitle">Discussion</h4>
  313. <div class="warning"><p><strong>Warning:</strong> Deprecated - use <a href="#//api/name/columnExists:inTableWithName:"><code>columnExists:inTableWithName:</code></a> instead.</p></div>
  314. </div>
  315. <div class="method-subsection see-also-section">
  316. <h4 class="method-subtitle">See Also</h4>
  317. <ul>
  318. <li><code><p><a href="#//api/name/columnExists:inTableWithName:">- columnExists:inTableWithName:</a></p></code></li>
  319. </ul>
  320. </div>
  321. <div class="method-subsection declared-in-section">
  322. <h4 class="method-subtitle">Declared In</h4>
  323. <code class="declared-in-ref">FMDatabaseAdditions.h</code><br />
  324. </div>
  325. </div>
  326. <div class="section-method">
  327. <a name="//api/name/columnExists:inTableWithName:" title="columnExists:inTableWithName:"></a>
  328. <h3 class="subsubtitle method-title">columnExists:inTableWithName:</h3>
  329. <div class="method-subsection brief-description">
  330. <p>Test to see if particular column exists for particular table in database</p>
  331. </div>
  332. <div class="method-subsection method-declaration"><code>- (BOOL)columnExists:(NSString *)<em>columnName</em> inTableWithName:(NSString *)<em>tableName</em></code></div>
  333. <div class="method-subsection arguments-section parameters">
  334. <h4 class="method-subtitle parameter-title">Parameters</h4>
  335. <dl class="argument-def parameter-def">
  336. <dt><em>columnName</em></dt>
  337. <dd><p>The name of the column.</p></dd>
  338. </dl>
  339. <dl class="argument-def parameter-def">
  340. <dt><em>tableName</em></dt>
  341. <dd><p>The name of the table.</p></dd>
  342. </dl>
  343. </div>
  344. <div class="method-subsection return">
  345. <h4 class="method-subtitle parameter-title">Return Value</h4>
  346. <p><code>YES</code> if column exists in table in question; <code>NO</code> otherwise.</p>
  347. </div>
  348. <div class="method-subsection declared-in-section">
  349. <h4 class="method-subtitle">Declared In</h4>
  350. <code class="declared-in-ref">FMDatabaseAdditions.h</code><br />
  351. </div>
  352. </div>
  353. <div class="section-method">
  354. <a name="//api/name/dataForQuery:" title="dataForQuery:"></a>
  355. <h3 class="subsubtitle method-title">dataForQuery:</h3>
  356. <div class="method-subsection brief-description">
  357. <p>Return <code>NSData</code> value for query</p>
  358. </div>
  359. <div class="method-subsection method-declaration"><code>- (NSData *)dataForQuery:(NSString *)<em>query</em>, <em>...</em></code></div>
  360. <div class="method-subsection arguments-section parameters">
  361. <h4 class="method-subtitle parameter-title">Parameters</h4>
  362. <dl class="argument-def parameter-def">
  363. <dt><em>query</em></dt>
  364. <dd><p>The SQL query to be performed.</p></dd>
  365. </dl>
  366. <dl class="argument-def parameter-def">
  367. <dt><em>...</em></dt>
  368. <dd><p>A list of parameters that will be bound to the <code>?</code> placeholders in the SQL query.</p></dd>
  369. </dl>
  370. </div>
  371. <div class="method-subsection return">
  372. <h4 class="method-subtitle parameter-title">Return Value</h4>
  373. <p><code>NSData</code> value.</p>
  374. </div>
  375. <div class="method-subsection declared-in-section">
  376. <h4 class="method-subtitle">Declared In</h4>
  377. <code class="declared-in-ref">FMDatabaseAdditions.h</code><br />
  378. </div>
  379. </div>
  380. <div class="section-method">
  381. <a name="//api/name/dateForQuery:" title="dateForQuery:"></a>
  382. <h3 class="subsubtitle method-title">dateForQuery:</h3>
  383. <div class="method-subsection brief-description">
  384. <p>Return <code>NSDate</code> value for query</p>
  385. </div>
  386. <div class="method-subsection method-declaration"><code>- (NSDate *)dateForQuery:(NSString *)<em>query</em>, <em>...</em></code></div>
  387. <div class="method-subsection arguments-section parameters">
  388. <h4 class="method-subtitle parameter-title">Parameters</h4>
  389. <dl class="argument-def parameter-def">
  390. <dt><em>query</em></dt>
  391. <dd><p>The SQL query to be performed.</p></dd>
  392. </dl>
  393. <dl class="argument-def parameter-def">
  394. <dt><em>...</em></dt>
  395. <dd><p>A list of parameters that will be bound to the <code>?</code> placeholders in the SQL query.</p></dd>
  396. </dl>
  397. </div>
  398. <div class="method-subsection return">
  399. <h4 class="method-subtitle parameter-title">Return Value</h4>
  400. <p><code>NSDate</code> value.</p>
  401. </div>
  402. <div class="method-subsection declared-in-section">
  403. <h4 class="method-subtitle">Declared In</h4>
  404. <code class="declared-in-ref">FMDatabaseAdditions.h</code><br />
  405. </div>
  406. </div>
  407. <div class="section-method">
  408. <a name="//api/name/doubleForQuery:" title="doubleForQuery:"></a>
  409. <h3 class="subsubtitle method-title">doubleForQuery:</h3>
  410. <div class="method-subsection brief-description">
  411. <p>Return <code>double</code> value for query</p>
  412. </div>
  413. <div class="method-subsection method-declaration"><code>- (double)doubleForQuery:(NSString *)<em>query</em>, <em>...</em></code></div>
  414. <div class="method-subsection arguments-section parameters">
  415. <h4 class="method-subtitle parameter-title">Parameters</h4>
  416. <dl class="argument-def parameter-def">
  417. <dt><em>query</em></dt>
  418. <dd><p>The SQL query to be performed.</p></dd>
  419. </dl>
  420. <dl class="argument-def parameter-def">
  421. <dt><em>...</em></dt>
  422. <dd><p>A list of parameters that will be bound to the <code>?</code> placeholders in the SQL query.</p></dd>
  423. </dl>
  424. </div>
  425. <div class="method-subsection return">
  426. <h4 class="method-subtitle parameter-title">Return Value</h4>
  427. <p><code>double</code> value.</p>
  428. </div>
  429. <div class="method-subsection declared-in-section">
  430. <h4 class="method-subtitle">Declared In</h4>
  431. <code class="declared-in-ref">FMDatabaseAdditions.h</code><br />
  432. </div>
  433. </div>
  434. <div class="section-method">
  435. <a name="//api/name/getSchema" title="getSchema"></a>
  436. <h3 class="subsubtitle method-title">getSchema</h3>
  437. <div class="method-subsection brief-description">
  438. <p>The schema of the database.</p>
  439. </div>
  440. <div class="method-subsection method-declaration"><code>- (FMResultSet *)getSchema</code></div>
  441. <div class="method-subsection return">
  442. <h4 class="method-subtitle parameter-title">Return Value</h4>
  443. <p><code>FMResultSet</code> of schema; <code>nil</code> on error.</p>
  444. </div>
  445. <div class="method-subsection discussion-section">
  446. <h4 class="method-subtitle">Discussion</h4>
  447. <p>This will be the schema for the entire database. For each entity, each row of the result set will include the following fields:</p>
  448. <ul>
  449. <li><code>type</code> - The type of entity (e.g. table, index, view, or trigger)</li>
  450. <li><code>name</code> - The name of the object</li>
  451. <li><code>tbl_name</code> - The name of the table to which the object references</li>
  452. <li><code>rootpage</code> - The page number of the root b-tree page for tables and indices</li>
  453. <li><code>sql</code> - The SQL that created the entity</li>
  454. </ul>
  455. </div>
  456. <div class="method-subsection see-also-section">
  457. <h4 class="method-subtitle">See Also</h4>
  458. <ul>
  459. <li><code><p><a href="http://www.sqlite.org/fileformat.html">SQLite File Format</a></p></code></li>
  460. </ul>
  461. </div>
  462. <div class="method-subsection declared-in-section">
  463. <h4 class="method-subtitle">Declared In</h4>
  464. <code class="declared-in-ref">FMDatabaseAdditions.h</code><br />
  465. </div>
  466. </div>
  467. <div class="section-method">
  468. <a name="//api/name/getTableSchema:" title="getTableSchema:"></a>
  469. <h3 class="subsubtitle method-title">getTableSchema:</h3>
  470. <div class="method-subsection brief-description">
  471. <p>The schema of the database.</p>
  472. </div>
  473. <div class="method-subsection method-declaration"><code>- (FMResultSet *)getTableSchema:(NSString *)<em>tableName</em></code></div>
  474. <div class="method-subsection arguments-section parameters">
  475. <h4 class="method-subtitle parameter-title">Parameters</h4>
  476. <dl class="argument-def parameter-def">
  477. <dt><em>tableName</em></dt>
  478. <dd><p>The name of the table for whom the schema will be returned.</p></dd>
  479. </dl>
  480. </div>
  481. <div class="method-subsection return">
  482. <h4 class="method-subtitle parameter-title">Return Value</h4>
  483. <p><code>FMResultSet</code> of schema; <code>nil</code> on error.</p>
  484. </div>
  485. <div class="method-subsection discussion-section">
  486. <h4 class="method-subtitle">Discussion</h4>
  487. <p>This will be the schema for a particular table as report by SQLite <code>PRAGMA</code>, for example:</p>
  488. <pre><code>PRAGMA table_info('employees')
  489. </code></pre>
  490. <p>This will report:</p>
  491. <ul>
  492. <li><code>cid</code> - The column ID number</li>
  493. <li><code>name</code> - The name of the column</li>
  494. <li><code>type</code> - The data type specified for the column</li>
  495. <li><code>notnull</code> - whether the field is defined as NOT NULL (i.e. values required)</li>
  496. <li><code>dflt_value</code> - The default value for the column</li>
  497. <li><code>pk</code> - Whether the field is part of the primary key of the table</li>
  498. </ul>
  499. </div>
  500. <div class="method-subsection see-also-section">
  501. <h4 class="method-subtitle">See Also</h4>
  502. <ul>
  503. <li><code><p><a href="http://www.sqlite.org/pragma.html#pragma_table_info">table_info</a></p></code></li>
  504. </ul>
  505. </div>
  506. <div class="method-subsection declared-in-section">
  507. <h4 class="method-subtitle">Declared In</h4>
  508. <code class="declared-in-ref">FMDatabaseAdditions.h</code><br />
  509. </div>
  510. </div>
  511. <div class="section-method">
  512. <a name="//api/name/intForQuery:" title="intForQuery:"></a>
  513. <h3 class="subsubtitle method-title">intForQuery:</h3>
  514. <div class="method-subsection brief-description">
  515. <p>Return <code>int</code> value for query</p>
  516. </div>
  517. <div class="method-subsection method-declaration"><code>- (int)intForQuery:(NSString *)<em>query</em>, <em>...</em></code></div>
  518. <div class="method-subsection arguments-section parameters">
  519. <h4 class="method-subtitle parameter-title">Parameters</h4>
  520. <dl class="argument-def parameter-def">
  521. <dt><em>query</em></dt>
  522. <dd><p>The SQL query to be performed.</p></dd>
  523. </dl>
  524. <dl class="argument-def parameter-def">
  525. <dt><em>...</em></dt>
  526. <dd><p>A list of parameters that will be bound to the <code>?</code> placeholders in the SQL query.</p></dd>
  527. </dl>
  528. </div>
  529. <div class="method-subsection return">
  530. <h4 class="method-subtitle parameter-title">Return Value</h4>
  531. <p><code>int</code> value.</p>
  532. </div>
  533. <div class="method-subsection declared-in-section">
  534. <h4 class="method-subtitle">Declared In</h4>
  535. <code class="declared-in-ref">FMDatabaseAdditions.h</code><br />
  536. </div>
  537. </div>
  538. <div class="section-method">
  539. <a name="//api/name/longForQuery:" title="longForQuery:"></a>
  540. <h3 class="subsubtitle method-title">longForQuery:</h3>
  541. <div class="method-subsection brief-description">
  542. <p>Return <code>long</code> value for query</p>
  543. </div>
  544. <div class="method-subsection method-declaration"><code>- (long)longForQuery:(NSString *)<em>query</em>, <em>...</em></code></div>
  545. <div class="method-subsection arguments-section parameters">
  546. <h4 class="method-subtitle parameter-title">Parameters</h4>
  547. <dl class="argument-def parameter-def">
  548. <dt><em>query</em></dt>
  549. <dd><p>The SQL query to be performed.</p></dd>
  550. </dl>
  551. <dl class="argument-def parameter-def">
  552. <dt><em>...</em></dt>
  553. <dd><p>A list of parameters that will be bound to the <code>?</code> placeholders in the SQL query.</p></dd>
  554. </dl>
  555. </div>
  556. <div class="method-subsection return">
  557. <h4 class="method-subtitle parameter-title">Return Value</h4>
  558. <p><code>long</code> value.</p>
  559. </div>
  560. <div class="method-subsection declared-in-section">
  561. <h4 class="method-subtitle">Declared In</h4>
  562. <code class="declared-in-ref">FMDatabaseAdditions.h</code><br />
  563. </div>
  564. </div>
  565. <div class="section-method">
  566. <a name="//api/name/setApplicationID:" title="setApplicationID:"></a>
  567. <h3 class="subsubtitle method-title">setApplicationID:</h3>
  568. <div class="method-subsection brief-description">
  569. <p>Set the application ID</p>
  570. </div>
  571. <div class="method-subsection method-declaration"><code>- (void)setApplicationID:(uint32_t)<em>appID</em></code></div>
  572. <div class="method-subsection arguments-section parameters">
  573. <h4 class="method-subtitle parameter-title">Parameters</h4>
  574. <dl class="argument-def parameter-def">
  575. <dt><em>appID</em></dt>
  576. <dd><p>The <code>uint32_t</code> numeric value of the application ID.</p></dd>
  577. </dl>
  578. </div>
  579. <div class="method-subsection see-also-section">
  580. <h4 class="method-subtitle">See Also</h4>
  581. <ul>
  582. <li><code><p><a href="#//api/name/applicationID">- applicationID</a></p></code></li>
  583. </ul>
  584. </div>
  585. <div class="method-subsection declared-in-section">
  586. <h4 class="method-subtitle">Declared In</h4>
  587. <code class="declared-in-ref">FMDatabaseAdditions.h</code><br />
  588. </div>
  589. </div>
  590. <div class="section-method">
  591. <a name="//api/name/setApplicationIDString:" title="setApplicationIDString:"></a>
  592. <h3 class="subsubtitle method-title">setApplicationIDString:</h3>
  593. <div class="method-subsection brief-description">
  594. <p>Set the application ID string</p>
  595. </div>
  596. <div class="method-subsection method-declaration"><code>- (void)setApplicationIDString:(NSString *)<em>string</em></code></div>
  597. <div class="method-subsection arguments-section parameters">
  598. <h4 class="method-subtitle parameter-title">Parameters</h4>
  599. <dl class="argument-def parameter-def">
  600. <dt><em>string</em></dt>
  601. <dd><p>The <code>NSString</code> value of the application ID.</p></dd>
  602. </dl>
  603. </div>
  604. <div class="method-subsection see-also-section">
  605. <h4 class="method-subtitle">See Also</h4>
  606. <ul>
  607. <li><code><p><a href="#//api/name/applicationIDString">- applicationIDString</a></p></code></li>
  608. </ul>
  609. </div>
  610. <div class="method-subsection declared-in-section">
  611. <h4 class="method-subtitle">Declared In</h4>
  612. <code class="declared-in-ref">FMDatabaseAdditions.h</code><br />
  613. </div>
  614. </div>
  615. <div class="section-method">
  616. <a name="//api/name/stringForQuery:" title="stringForQuery:"></a>
  617. <h3 class="subsubtitle method-title">stringForQuery:</h3>
  618. <div class="method-subsection brief-description">
  619. <p>Return <code>NSString</code> value for query</p>
  620. </div>
  621. <div class="method-subsection method-declaration"><code>- (NSString *)stringForQuery:(NSString *)<em>query</em>, <em>...</em></code></div>
  622. <div class="method-subsection arguments-section parameters">
  623. <h4 class="method-subtitle parameter-title">Parameters</h4>
  624. <dl class="argument-def parameter-def">
  625. <dt><em>query</em></dt>
  626. <dd><p>The SQL query to be performed.</p></dd>
  627. </dl>
  628. <dl class="argument-def parameter-def">
  629. <dt><em>...</em></dt>
  630. <dd><p>A list of parameters that will be bound to the <code>?</code> placeholders in the SQL query.</p></dd>
  631. </dl>
  632. </div>
  633. <div class="method-subsection return">
  634. <h4 class="method-subtitle parameter-title">Return Value</h4>
  635. <p><code>NSString</code> value.</p>
  636. </div>
  637. <div class="method-subsection declared-in-section">
  638. <h4 class="method-subtitle">Declared In</h4>
  639. <code class="declared-in-ref">FMDatabaseAdditions.h</code><br />
  640. </div>
  641. </div>
  642. <div class="section-method">
  643. <a name="//api/name/tableExists:" title="tableExists:"></a>
  644. <h3 class="subsubtitle method-title">tableExists:</h3>
  645. <div class="method-subsection brief-description">
  646. <p>Does table exist in database?</p>
  647. </div>
  648. <div class="method-subsection method-declaration"><code>- (BOOL)tableExists:(NSString *)<em>tableName</em></code></div>
  649. <div class="method-subsection arguments-section parameters">
  650. <h4 class="method-subtitle parameter-title">Parameters</h4>
  651. <dl class="argument-def parameter-def">
  652. <dt><em>tableName</em></dt>
  653. <dd><p>The name of the table being looked for.</p></dd>
  654. </dl>
  655. </div>
  656. <div class="method-subsection return">
  657. <h4 class="method-subtitle parameter-title">Return Value</h4>
  658. <p><code>YES</code> if table found; <code>NO</code> if not found.</p>
  659. </div>
  660. <div class="method-subsection declared-in-section">
  661. <h4 class="method-subtitle">Declared In</h4>
  662. <code class="declared-in-ref">FMDatabaseAdditions.h</code><br />
  663. </div>
  664. </div>
  665. <div class="section-method">
  666. <a name="//api/name/validateSQL:error:" title="validateSQL:error:"></a>
  667. <h3 class="subsubtitle method-title">validateSQL:error:</h3>
  668. <div class="method-subsection brief-description">
  669. <p>Validate SQL statement</p>
  670. </div>
  671. <div class="method-subsection method-declaration"><code>- (BOOL)validateSQL:(NSString *)<em>sql</em> error:(NSError **)<em>error</em></code></div>
  672. <div class="method-subsection arguments-section parameters">
  673. <h4 class="method-subtitle parameter-title">Parameters</h4>
  674. <dl class="argument-def parameter-def">
  675. <dt><em>sql</em></dt>
  676. <dd><p>The SQL statement being validated.</p></dd>
  677. </dl>
  678. <dl class="argument-def parameter-def">
  679. <dt><em>error</em></dt>
  680. <dd><p>This is a pointer to a <code>NSError</code> object that will receive the autoreleased <code>NSError</code> object if there was any error. If this is <code>nil</code>, no <code>NSError</code> result will be returned.</p></dd>
  681. </dl>
  682. </div>
  683. <div class="method-subsection return">
  684. <h4 class="method-subtitle parameter-title">Return Value</h4>
  685. <p><code>YES</code> if validation succeeded without incident; <code>NO</code> otherwise.</p>
  686. </div>
  687. <div class="method-subsection discussion-section">
  688. <h4 class="method-subtitle">Discussion</h4>
  689. <p>This validates SQL statement by performing <code>sqlite3_prepare_v2</code>, but not returning the results, but instead immediately calling <code>sqlite3_finalize</code>.</p>
  690. </div>
  691. <div class="method-subsection declared-in-section">
  692. <h4 class="method-subtitle">Declared In</h4>
  693. <code class="declared-in-ref">FMDatabaseAdditions.h</code><br />
  694. </div>
  695. </div>
  696. </div>
  697. </div>
  698. <div class="main-navigation navigation-bottom">
  699. <ul>
  700. <li><a href="../index.html">Index</a></li>
  701. <li><a href="../hierarchy.html">Hierarchy</a></li>
  702. </ul>
  703. </div>
  704. <div id="footer">
  705. <hr />
  706. <div class="footer-copyright">
  707. <p><span class="copyright">&copy; 2013 ccgus. All rights reserved. (Last updated: 2013-08-06)</span><br />
  708. <span class="generator">Generated by <a href="http://appledoc.gentlebytes.com">appledoc 2.1 (build 858)</a>.</span></p>
  709. </div>
  710. </div>
  711. </div>
  712. </article>
  713. <script type="text/javascript">
  714. function jumpToChange()
  715. {
  716. window.location.hash = this.options[this.selectedIndex].value;
  717. }
  718. function toggleTOC()
  719. {
  720. var contents = document.getElementById('contents');
  721. var tocContainer = document.getElementById('tocContainer');
  722. if (this.getAttribute('class') == 'open')
  723. {
  724. this.setAttribute('class', '');
  725. contents.setAttribute('class', '');
  726. tocContainer.setAttribute('class', '');
  727. window.name = "hideTOC";
  728. }
  729. else
  730. {
  731. this.setAttribute('class', 'open');
  732. contents.setAttribute('class', 'isShowingTOC');
  733. tocContainer.setAttribute('class', 'isShowingTOC');
  734. window.name = "";
  735. }
  736. return false;
  737. }
  738. function toggleTOCEntryChildren(e)
  739. {
  740. e.stopPropagation();
  741. var currentClass = this.getAttribute('class');
  742. if (currentClass == 'children') {
  743. this.setAttribute('class', 'children open');
  744. }
  745. else if (currentClass == 'children open') {
  746. this.setAttribute('class', 'children');
  747. }
  748. return false;
  749. }
  750. function tocEntryClick(e)
  751. {
  752. e.stopPropagation();
  753. return true;
  754. }
  755. function init()
  756. {
  757. var selectElement = document.getElementById('jumpTo');
  758. selectElement.addEventListener('change', jumpToChange, false);
  759. var tocButton = document.getElementById('table_of_contents');
  760. tocButton.addEventListener('click', toggleTOC, false);
  761. var taskTreeItem = document.getElementById('task_treeitem');
  762. if (taskTreeItem.getElementsByTagName('li').length > 0)
  763. {
  764. taskTreeItem.setAttribute('class', 'children');
  765. taskTreeItem.firstChild.setAttribute('class', 'disclosure');
  766. }
  767. var tocList = document.getElementById('toc');
  768. var tocEntries = tocList.getElementsByTagName('li');
  769. for (var i = 0; i < tocEntries.length; i++) {
  770. tocEntries[i].addEventListener('click', toggleTOCEntryChildren, false);
  771. }
  772. var tocLinks = tocList.getElementsByTagName('a');
  773. for (var i = 0; i < tocLinks.length; i++) {
  774. tocLinks[i].addEventListener('click', tocEntryClick, false);
  775. }
  776. if (window.name == "hideTOC") {
  777. toggleTOC.call(tocButton);
  778. }
  779. }
  780. window.onload = init;
  781. // If showing in Xcode, hide the TOC and Header
  782. if (navigator.userAgent.match(/xcode/i)) {
  783. document.getElementById("contents").className = "hideInXcode"
  784. document.getElementById("tocContainer").className = "hideInXcode"
  785. document.getElementById("top_header").className = "hideInXcode"
  786. }
  787. </script>
  788. </body>
  789. </html>