SaveResults2Database.html 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767
  1. <!DOCTYPE html>
  2. <!--[if IE 8]><html class="no-js lt-ie9" lang="en" > <![endif]-->
  3. <!--[if gt IE 8]><!--> <html class="no-js" lang="en" > <!--<![endif]-->
  4. <head>
  5. <meta charset="utf-8">
  6. <meta name="viewport" content="width=device-width, initial-scale=1.0">
  7. <title>Save Testrun Results to Database &mdash; baangt 1.1.1 documentation</title>
  8. <script type="text/javascript" src="_static/js/modernizr.min.js"></script>
  9. <script type="text/javascript" id="documentation_options" data-url_root="./" src="_static/documentation_options.js"></script>
  10. <script type="text/javascript" src="_static/jquery.js"></script>
  11. <script type="text/javascript" src="_static/underscore.js"></script>
  12. <script type="text/javascript" src="_static/doctools.js"></script>
  13. <script type="text/javascript" src="_static/language_data.js"></script>
  14. <script type="text/javascript" src="_static/js/theme.js"></script>
  15. <link rel="stylesheet" href="_static/css/theme.css" type="text/css" />
  16. <link rel="stylesheet" href="_static/pygments.css" type="text/css" />
  17. <link rel="stylesheet" href="_static/theme_overrides.css" type="text/css" />
  18. <link rel="index" title="Index" href="genindex.html" />
  19. <link rel="search" title="Search" href="search.html" />
  20. <link rel="next" title="Why baangt and why is it open source?" href="HistoryAndReasons.html" />
  21. <link rel="prev" title="Special functions in datafiles" href="DataFile.html" />
  22. </head>
  23. <body class="wy-body-for-nav">
  24. <div class="wy-grid-for-nav">
  25. <nav data-toggle="wy-nav-shift" class="wy-nav-side">
  26. <div class="wy-side-scroll">
  27. <div class="wy-side-nav-search" >
  28. <a href="index.html" class="icon icon-home"> baangt
  29. </a>
  30. <div role="search">
  31. <form id="rtd-search-form" class="wy-form" action="search.html" method="get">
  32. <input type="text" name="q" placeholder="Search docs" />
  33. <input type="hidden" name="check_keywords" value="yes" />
  34. <input type="hidden" name="area" value="default" />
  35. </form>
  36. </div>
  37. </div>
  38. <div class="wy-menu wy-menu-vertical" data-spy="affix" role="navigation" aria-label="main navigation">
  39. <p class="caption"><span class="caption-text">Contents:</span></p>
  40. <ul class="current">
  41. <li class="toctree-l1"><a class="reference internal" href="Installation.html"> Installation</a></li>
  42. <li class="toctree-l1"><a class="reference internal" href="OverviewUsage.html"> Overview</a></li>
  43. <li class="toctree-l1"><a class="reference internal" href="simpleExample.html"> First Steps</a></li>
  44. <li class="toctree-l1"><a class="reference internal" href="Structure.html"> Structure</a></li>
  45. <li class="toctree-l1"><a class="reference internal" href="ParametersConfigFile.html"> Parameters</a></li>
  46. <li class="toctree-l1"><a class="reference internal" href="SimpleAPI.html"> First API Test</a></li>
  47. <li class="toctree-l1"><a class="reference internal" href="TestTypes.html"> Types of Tests</a></li>
  48. <li class="toctree-l1"><a class="reference internal" href="DataFile.html"> Data file</a></li>
  49. <li class="toctree-l1 current"><a class="current reference internal" href="#"> Results in Database</a><ul>
  50. <li class="toctree-l2"><a class="reference internal" href="#tables">Tables</a><ul>
  51. <li class="toctree-l3"><a class="reference internal" href="#table-testruns">Table: <code class="docutils literal notranslate"><span class="pre">testruns</span></code></a></li>
  52. <li class="toctree-l3"><a class="reference internal" href="#table-testcasesequences">Table: <code class="docutils literal notranslate"><span class="pre">testCaseSequences</span></code></a></li>
  53. <li class="toctree-l3"><a class="reference internal" href="#table-testcases">Table: <code class="docutils literal notranslate"><span class="pre">testCases</span></code></a></li>
  54. <li class="toctree-l3"><a class="reference internal" href="#table-globals">Table: <code class="docutils literal notranslate"><span class="pre">globals</span></code></a></li>
  55. <li class="toctree-l3"><a class="reference internal" href="#table-testcasefields">Table: <code class="docutils literal notranslate"><span class="pre">testCaseFields</span></code></a></li>
  56. <li class="toctree-l3"><a class="reference internal" href="#table-networkinfo">Table: <code class="docutils literal notranslate"><span class="pre">networkInfo</span></code></a></li>
  57. </ul>
  58. </li>
  59. <li class="toctree-l2"><a class="reference internal" href="#for-developers-orm-api">For Developers: ORM API</a><ul>
  60. <li class="toctree-l3"><a class="reference internal" href="#testrunlog">TestrunLog</a></li>
  61. <li class="toctree-l3"><a class="reference internal" href="#testcasesequencelog">TestCaseSequenceLog</a></li>
  62. <li class="toctree-l3"><a class="reference internal" href="#testcaselog">TestCaseLog</a></li>
  63. <li class="toctree-l3"><a class="reference internal" href="#globalattribute">GlobalAttribute</a></li>
  64. <li class="toctree-l3"><a class="reference internal" href="#testcasefield">TestCaseField</a></li>
  65. <li class="toctree-l3"><a class="reference internal" href="#testcasenetworkinfo">TestCaseNetworkInfo</a></li>
  66. </ul>
  67. </li>
  68. </ul>
  69. </li>
  70. <li class="toctree-l1"><a class="reference internal" href="HistoryAndReasons.html"> History</a></li>
  71. <li class="toctree-l1"><a class="reference internal" href="contributors.html"> Contributions</a></li>
  72. <li class="toctree-l1"><a class="reference internal" href="changelog.html"> Changelog</a></li>
  73. <li class="toctree-l1"><a class="reference internal" href="PlannedFeatures.html"> Planned Features</a></li>
  74. <li class="toctree-l1"><a class="reference internal" href="BrowserDrivers.html"> Browser Drivers</a></li>
  75. <li class="toctree-l1"><a class="reference internal" href="Variables.html"> Variables</a></li>
  76. <li class="toctree-l1"><a class="reference internal" href="SendStatistics.html"> Results</a></li>
  77. <li class="toctree-l1"><a class="reference internal" href="Datagenerator.html">DataGenerator</a></li>
  78. <li class="toctree-l1"><a class="reference internal" href="Datagenerator.html#input-file">Input File</a></li>
  79. <li class="toctree-l1"><a class="reference internal" href="Datagenerator.html#data-type">Data Type</a></li>
  80. <li class="toctree-l1"><a class="reference internal" href="Datagenerator.html#all-data-types-format">All Data Types Format</a></li>
  81. <li class="toctree-l1"><a class="reference internal" href="Developer.html"> For Developers</a></li>
  82. <li class="toctree-l1"><a class="reference internal" href="baangt-Plugin.html">What is a baangt-plugin</a></li>
  83. <li class="toctree-l1"><a class="reference internal" href="baangt-Plugin.html#how-to-make-a-baangt-plugin">how to make a baangt-plugin</a></li>
  84. <li class="toctree-l1"><a class="reference internal" href="baangt-Plugin.html#how-the-baangt-plugin-work">how the baangt-plugin work</a></li>
  85. <li class="toctree-l1"><a class="reference internal" href="baangt-Plugin.html#how-to-replace-the-existing-plugin-by-your-own-one">how to replace the existing plugin by your own one</a></li>
  86. <li class="toctree-l1"><a class="reference internal" href="articles/Articles.html"> :subheader: Articles</a></li>
  87. <li class="toctree-l1"><a class="reference external" href="http://www.baangt.org"> Web</a></li>
  88. </ul>
  89. <p class="caption"><span class="caption-text">Autodocs:</span></p>
  90. <ul>
  91. <li class="toctree-l1"><a class="reference internal" href="docs/baangt.base.html">Autodocs</a></li>
  92. <li class="toctree-l1"><a class="reference internal" href="docs/modules.html">Modules</a></li>
  93. </ul>
  94. </div>
  95. </div>
  96. </nav>
  97. <section data-toggle="wy-nav-shift" class="wy-nav-content-wrap">
  98. <nav class="wy-nav-top" aria-label="top navigation">
  99. <i data-toggle="wy-nav-top" class="fa fa-bars"></i>
  100. <a href="index.html">baangt</a>
  101. </nav>
  102. <div class="wy-nav-content">
  103. <div class="rst-content">
  104. <div role="navigation" aria-label="breadcrumbs navigation">
  105. <ul class="wy-breadcrumbs">
  106. <li><a href="index.html">Docs</a> &raquo;</li>
  107. <li>Save Testrun Results to Database</li>
  108. <li class="wy-breadcrumbs-aside">
  109. <a href="_sources/SaveResults2Database.rst.txt" rel="nofollow"> View page source</a>
  110. </li>
  111. </ul>
  112. <hr/>
  113. </div>
  114. <div role="main" class="document" itemscope="itemscope" itemtype="http://schema.org/Article">
  115. <div itemprop="articleBody">
  116. <div class="section" id="save-testrun-results-to-database">
  117. <h1>Save Testrun Results to Database<a class="headerlink" href="#save-testrun-results-to-database" title="Permalink to this headline">¶</a></h1>
  118. <p>One of the options that <code class="docutils literal notranslate"><span class="pre">baangt</span></code> provides to save the results of the executed Testruns is using an SQL database.
  119. The identification of the database is implemented via the environmental variable BAANGT_RESULTS_DATABASE_URL.
  120. if <code class="docutils literal notranslate"><span class="pre">baangt</span></code> cannot retrieve BAANGT_RESULTS_DATABASE_URL it uses the default database URL:
  121. <code class="docutils literal notranslate"><span class="pre">sqlite:///testrun.db</span></code></p>
  122. <div class="section" id="tables">
  123. <h2>Tables<a class="headerlink" href="#tables" title="Permalink to this headline">¶</a></h2>
  124. <div class="section" id="table-testruns">
  125. <h3>Table: <code class="docutils literal notranslate"><span class="pre">testruns</span></code><a class="headerlink" href="#table-testruns" title="Permalink to this headline">¶</a></h3>
  126. <p>Table holds results of the executed Testruns: Testrun Logs</p>
  127. <table class="colwidths-given docutils align-default" id="id1">
  128. <caption><span class="caption-text">Testrun Logs</span><a class="headerlink" href="#id1" title="Permalink to this table">¶</a></caption>
  129. <colgroup>
  130. <col style="width: 25%" />
  131. <col style="width: 15%" />
  132. <col style="width: 60%" />
  133. </colgroup>
  134. <thead>
  135. <tr class="row-odd"><th class="head"><p>Column</p></th>
  136. <th class="head"><p>Data Type</p></th>
  137. <th class="head"><p>Description</p></th>
  138. </tr>
  139. </thead>
  140. <tbody>
  141. <tr class="row-even"><td><p>id</p></td>
  142. <td><p>BINARY</p></td>
  143. <td><p>Testrun Log UUID. Primary key for Testrun Log.</p></td>
  144. </tr>
  145. <tr class="row-odd"><td><p>testrunName</p></td>
  146. <td><p>VARCHAR</p></td>
  147. <td><p>A name associated with the Testrun.</p></td>
  148. </tr>
  149. <tr class="row-even"><td><p>logfileName</p></td>
  150. <td><p>VARCHAR</p></td>
  151. <td><p>Path to the logfile of the Testrun.</p></td>
  152. </tr>
  153. <tr class="row-odd"><td><p>startTime</p></td>
  154. <td><p>DATETIME</p></td>
  155. <td><p>Satrt time of the Testrun execution.</p></td>
  156. </tr>
  157. <tr class="row-even"><td><p>endTime</p></td>
  158. <td><p>DATETIME</p></td>
  159. <td><p>End time of the Testrun execurtion.</p></td>
  160. </tr>
  161. <tr class="row-odd"><td><p>dataFile</p></td>
  162. <td><p>VARCHAR</p></td>
  163. <td><p>Path to the Data File of the Testrun.</p></td>
  164. </tr>
  165. <tr class="row-even"><td><p>statusOk</p></td>
  166. <td><p>INTEGER</p></td>
  167. <td><p>Number of the successful test cases within the executed Testrun.</p></td>
  168. </tr>
  169. <tr class="row-odd"><td><p>statusFailed</p></td>
  170. <td><p>INTEGER</p></td>
  171. <td><p>Number of the failed test cases within the executed Testrun.</p></td>
  172. </tr>
  173. <tr class="row-even"><td><p>statusPaused</p></td>
  174. <td><p>INTEGER</p></td>
  175. <td><p>Number of the paused test cases within the executed Testrun.</p></td>
  176. </tr>
  177. </tbody>
  178. </table>
  179. </div>
  180. <div class="section" id="table-testcasesequences">
  181. <h3>Table: <code class="docutils literal notranslate"><span class="pre">testCaseSequences</span></code><a class="headerlink" href="#table-testcasesequences" title="Permalink to this headline">¶</a></h3>
  182. <p>Table holds data on the executed test case sequences: TestCaseSequence Logs</p>
  183. <table class="colwidths-given docutils align-default" id="id2">
  184. <caption><span class="caption-text">TestCaseSequence Logs</span><a class="headerlink" href="#id2" title="Permalink to this table">¶</a></caption>
  185. <colgroup>
  186. <col style="width: 25%" />
  187. <col style="width: 15%" />
  188. <col style="width: 60%" />
  189. </colgroup>
  190. <thead>
  191. <tr class="row-odd"><th class="head"><p>Column</p></th>
  192. <th class="head"><p>Data Type</p></th>
  193. <th class="head"><p>Description</p></th>
  194. </tr>
  195. </thead>
  196. <tbody>
  197. <tr class="row-even"><td><p>id</p></td>
  198. <td><p>BINARY</p></td>
  199. <td><p>TestCaseSequence Log UUID. Primary key for TestCaseSequence Log.</p></td>
  200. </tr>
  201. <tr class="row-odd"><td><p>testrun_id</p></td>
  202. <td><p>INTEGER</p></td>
  203. <td><p>Foreign key to <code class="docutils literal notranslate"><span class="pre">testruns</span></code>
  204. Testrun that contains the test case sequence.</p></td>
  205. </tr>
  206. </tbody>
  207. </table>
  208. </div>
  209. <div class="section" id="table-testcases">
  210. <h3>Table: <code class="docutils literal notranslate"><span class="pre">testCases</span></code><a class="headerlink" href="#table-testcases" title="Permalink to this headline">¶</a></h3>
  211. <p>Table holds data on the executed test cases: TestCase Logs</p>
  212. <table class="colwidths-given docutils align-default" id="id3">
  213. <caption><span class="caption-text">TestCase Logs</span><a class="headerlink" href="#id3" title="Permalink to this table">¶</a></caption>
  214. <colgroup>
  215. <col style="width: 25%" />
  216. <col style="width: 15%" />
  217. <col style="width: 60%" />
  218. </colgroup>
  219. <thead>
  220. <tr class="row-odd"><th class="head"><p>Column</p></th>
  221. <th class="head"><p>Data Type</p></th>
  222. <th class="head"><p>Description</p></th>
  223. </tr>
  224. </thead>
  225. <tbody>
  226. <tr class="row-even"><td><p>id</p></td>
  227. <td><p>BINARY</p></td>
  228. <td><p>TestCase Log UUID. Primary key for TestCase Log.</p></td>
  229. </tr>
  230. <tr class="row-odd"><td><p>testcase_sequence_id</p></td>
  231. <td><p>INTEGER</p></td>
  232. <td><p>Foreign key to <code class="docutils literal notranslate"><span class="pre">testCaseSequences</span></code>
  233. Test case sequence that contains the test case.</p></td>
  234. </tr>
  235. </tbody>
  236. </table>
  237. </div>
  238. <div class="section" id="table-globals">
  239. <h3>Table: <code class="docutils literal notranslate"><span class="pre">globals</span></code><a class="headerlink" href="#table-globals" title="Permalink to this headline">¶</a></h3>
  240. <p>Table holds global variables of the executed Testruns</p>
  241. <table class="colwidths-given docutils align-default" id="id4">
  242. <caption><span class="caption-text">Globals</span><a class="headerlink" href="#id4" title="Permalink to this table">¶</a></caption>
  243. <colgroup>
  244. <col style="width: 25%" />
  245. <col style="width: 15%" />
  246. <col style="width: 60%" />
  247. </colgroup>
  248. <thead>
  249. <tr class="row-odd"><th class="head"><p>Column</p></th>
  250. <th class="head"><p>Data Type</p></th>
  251. <th class="head"><p>Description</p></th>
  252. </tr>
  253. </thead>
  254. <tbody>
  255. <tr class="row-even"><td><p>id</p></td>
  256. <td><p>INTEGER</p></td>
  257. <td><p>Primary key for the global variable.</p></td>
  258. </tr>
  259. <tr class="row-odd"><td><p>name</p></td>
  260. <td><p>VARCHAR</p></td>
  261. <td><p>Name of the global variable.</p></td>
  262. </tr>
  263. <tr class="row-even"><td><p>value</p></td>
  264. <td><p>VARCHAR</p></td>
  265. <td><p>Value of the global variable.</p></td>
  266. </tr>
  267. <tr class="row-odd"><td><p>testrun_id</p></td>
  268. <td><p>INTEGER</p></td>
  269. <td><p>Foreign key to <code class="docutils literal notranslate"><span class="pre">testruns</span></code>
  270. Testrun that contains the global variable.</p></td>
  271. </tr>
  272. </tbody>
  273. </table>
  274. </div>
  275. <div class="section" id="table-testcasefields">
  276. <h3>Table: <code class="docutils literal notranslate"><span class="pre">testCaseFields</span></code><a class="headerlink" href="#table-testcasefields" title="Permalink to this headline">¶</a></h3>
  277. <p>Table holds log fields of the executed test cases</p>
  278. <table class="colwidths-given docutils align-default" id="id5">
  279. <caption><span class="caption-text">Testcase Fields</span><a class="headerlink" href="#id5" title="Permalink to this table">¶</a></caption>
  280. <colgroup>
  281. <col style="width: 25%" />
  282. <col style="width: 15%" />
  283. <col style="width: 60%" />
  284. </colgroup>
  285. <thead>
  286. <tr class="row-odd"><th class="head"><p>Column</p></th>
  287. <th class="head"><p>Data Type</p></th>
  288. <th class="head"><p>Description</p></th>
  289. </tr>
  290. </thead>
  291. <tbody>
  292. <tr class="row-even"><td><p>id</p></td>
  293. <td><p>INTEGER</p></td>
  294. <td><p>Primary key for the field.</p></td>
  295. </tr>
  296. <tr class="row-odd"><td><p>name</p></td>
  297. <td><p>VARCHAR</p></td>
  298. <td><p>Name of the field.</p></td>
  299. </tr>
  300. <tr class="row-even"><td><p>value</p></td>
  301. <td><p>VARCHAR</p></td>
  302. <td><p>Value of the field.</p></td>
  303. </tr>
  304. <tr class="row-odd"><td><p>testcase_id</p></td>
  305. <td><p>INTEGER</p></td>
  306. <td><p>Foreign key to <code class="docutils literal notranslate"><span class="pre">testCases</span></code>
  307. Test case that contains the field.</p></td>
  308. </tr>
  309. </tbody>
  310. </table>
  311. </div>
  312. <div class="section" id="table-networkinfo">
  313. <h3>Table: <code class="docutils literal notranslate"><span class="pre">networkInfo</span></code><a class="headerlink" href="#table-networkinfo" title="Permalink to this headline">¶</a></h3>
  314. <p>Table holds info on requests made while execution of the test cases</p>
  315. <table class="colwidths-given docutils align-default" id="id6">
  316. <caption><span class="caption-text">Network Info</span><a class="headerlink" href="#id6" title="Permalink to this table">¶</a></caption>
  317. <colgroup>
  318. <col style="width: 25%" />
  319. <col style="width: 15%" />
  320. <col style="width: 60%" />
  321. </colgroup>
  322. <thead>
  323. <tr class="row-odd"><th class="head"><p>Column</p></th>
  324. <th class="head"><p>Data Type</p></th>
  325. <th class="head"><p>Description</p></th>
  326. </tr>
  327. </thead>
  328. <tbody>
  329. <tr class="row-even"><td><p>id</p></td>
  330. <td><p>INTEGER</p></td>
  331. <td><p>Primary key for the network info.</p></td>
  332. </tr>
  333. <tr class="row-odd"><td><p>browserName</p></td>
  334. <td><p>VARCHAR</p></td>
  335. <td><p>Browser name that was used to make the request.</p></td>
  336. </tr>
  337. <tr class="row-even"><td><p>status</p></td>
  338. <td><p>INTEGER</p></td>
  339. <td><p>The status code of the HTTP response.</p></td>
  340. </tr>
  341. <tr class="row-odd"><td><p>method</p></td>
  342. <td><p>VARCHAR</p></td>
  343. <td><p>The request method.</p></td>
  344. </tr>
  345. <tr class="row-even"><td><p>url</p></td>
  346. <td><p>VARCHAR</p></td>
  347. <td><p>The request URL.</p></td>
  348. </tr>
  349. <tr class="row-odd"><td><p>contentType</p></td>
  350. <td><p>VARCHAR</p></td>
  351. <td><p>Content-type header of the response.</p></td>
  352. </tr>
  353. <tr class="row-even"><td><p>contentSize</p></td>
  354. <td><p>INTEGER</p></td>
  355. <td><p>The size of the response content.</p></td>
  356. </tr>
  357. <tr class="row-odd"><td><p>headers</p></td>
  358. <td><p>VARCHAR</p></td>
  359. <td><p>A string that represents a list of the response headers in format:
  360. <code class="docutils literal notranslate"><span class="pre">{'name':</span> <span class="pre">HEADER_NAME,</span> <span class="pre">'value':</span> <span class="pre">HEADER_VALUE}</span></code></p></td>
  361. </tr>
  362. <tr class="row-even"><td><p>params</p></td>
  363. <td><p>VARCHAR</p></td>
  364. <td><p>A string that represents a list of the request GET parameters in format:
  365. <code class="docutils literal notranslate"><span class="pre">{'name':</span> <span class="pre">PARAMETER_NAME,</span> <span class="pre">'value':</span> <span class="pre">PARAMETER_VALUE}</span></code></p></td>
  366. </tr>
  367. <tr class="row-odd"><td><p>response</p></td>
  368. <td><p>VARCHAR</p></td>
  369. <td><p>The content of the response.</p></td>
  370. </tr>
  371. <tr class="row-even"><td><p>startDateTime</p></td>
  372. <td><p>DATETIME</p></td>
  373. <td><p>The time when the request was sent.</p></td>
  374. </tr>
  375. <tr class="row-odd"><td><p>duration</p></td>
  376. <td><p>INTEGER</p></td>
  377. <td><p>The time (in <code class="docutils literal notranslate"><span class="pre">ms</span></code>) that it took to receive the response after the request was sent.</p></td>
  378. </tr>
  379. <tr class="row-even"><td><p>testcase_id</p></td>
  380. <td><p>INTEGER</p></td>
  381. <td><p>Foreign key to <code class="docutils literal notranslate"><span class="pre">testCases</span></code>
  382. Test case that contains the network info.</p></td>
  383. </tr>
  384. </tbody>
  385. </table>
  386. </div>
  387. </div>
  388. <div class="section" id="for-developers-orm-api">
  389. <h2>For Developers: ORM API<a class="headerlink" href="#for-developers-orm-api" title="Permalink to this headline">¶</a></h2>
  390. <p><code class="docutils literal notranslate"><span class="pre">baangt</span></code> provides ORM models to facilatate analysis of Testruns results.
  391. The models are located in module <code class="docutils literal notranslate"><span class="pre">baangt.base.DataBaseORM</span></code></p>
  392. <div class="section" id="testrunlog">
  393. <h3>TestrunLog<a class="headerlink" href="#testrunlog" title="Permalink to this headline">¶</a></h3>
  394. <p>Provides interface with table <code class="docutils literal notranslate"><span class="pre">testruns</span></code></p>
  395. <table class="colwidths-given docutils align-default" id="id7">
  396. <caption><span class="caption-text">baangt.base.DataBaseORM.TestrunLog</span><a class="headerlink" href="#id7" title="Permalink to this table">¶</a></caption>
  397. <colgroup>
  398. <col style="width: 30%" />
  399. <col style="width: 70%" />
  400. </colgroup>
  401. <thead>
  402. <tr class="row-odd"><th class="head"><p>Attribute</p></th>
  403. <th class="head"><p>Description</p></th>
  404. </tr>
  405. </thead>
  406. <tbody>
  407. <tr class="row-even"><td><p>id</p></td>
  408. <td><p>Testrun Log UUID as a bianry string.</p></td>
  409. </tr>
  410. <tr class="row-odd"><td><p>testrunName</p></td>
  411. <td><p>Name of the associated TestRun.</p></td>
  412. </tr>
  413. <tr class="row-even"><td><p>logfileName</p></td>
  414. <td><p>Path to the associated log file.</p></td>
  415. </tr>
  416. <tr class="row-odd"><td><p>startTime</p></td>
  417. <td><p>TestRun start time as a <code class="docutils literal notranslate"><span class="pre">datetime.datetime</span></code> object.</p></td>
  418. </tr>
  419. <tr class="row-even"><td><p>endTime</p></td>
  420. <td><p>TestRun start time as a <code class="docutils literal notranslate"><span class="pre">datetime.datetime</span></code> object.</p></td>
  421. </tr>
  422. <tr class="row-odd"><td><p>dataFile</p></td>
  423. <td><p>Path to the associated Data File.</p></td>
  424. </tr>
  425. <tr class="row-even"><td><p>statusOk</p></td>
  426. <td><p>Number of the successful test cases.</p></td>
  427. </tr>
  428. <tr class="row-odd"><td><p>statusFailed</p></td>
  429. <td><p>Number of the failed test cases.</p></td>
  430. </tr>
  431. <tr class="row-even"><td><p>statusPaused</p></td>
  432. <td><p>Number of the paused test cases.</p></td>
  433. </tr>
  434. <tr class="row-odd"><td><p>globalVars</p></td>
  435. <td><p>List of the global attributes (as <code class="docutils literal notranslate"><span class="pre">GlobalAttribute</span></code> instances) of the associated Testrun.</p></td>
  436. </tr>
  437. <tr class="row-even"><td><p>testcase_sequences</p></td>
  438. <td><p>List of the test case sequences (as <code class="docutils literal notranslate"><span class="pre">TestCaseSequenceLog</span></code> instances) within the associated Testrun.</p></td>
  439. </tr>
  440. <tr class="row-odd"><td><p>__str__()</p></td>
  441. <td><p>Method. Returns Testrun Log UUID as a string.</p></td>
  442. </tr>
  443. <tr class="row-even"><td><p>to_json()</p></td>
  444. <td><p>Method. Returns Testrun Log as a dictionary object.</p></td>
  445. </tr>
  446. </tbody>
  447. </table>
  448. </div>
  449. <div class="section" id="testcasesequencelog">
  450. <h3>TestCaseSequenceLog<a class="headerlink" href="#testcasesequencelog" title="Permalink to this headline">¶</a></h3>
  451. <p>Provides interface with table <code class="docutils literal notranslate"><span class="pre">testCaseSequences</span></code></p>
  452. <table class="colwidths-given docutils align-default" id="id8">
  453. <caption><span class="caption-text">baangt.base.DataBaseORM.TestCaseSequenceLog</span><a class="headerlink" href="#id8" title="Permalink to this table">¶</a></caption>
  454. <colgroup>
  455. <col style="width: 30%" />
  456. <col style="width: 70%" />
  457. </colgroup>
  458. <thead>
  459. <tr class="row-odd"><th class="head"><p>Attribute</p></th>
  460. <th class="head"><p>Description</p></th>
  461. </tr>
  462. </thead>
  463. <tbody>
  464. <tr class="row-even"><td><p>id</p></td>
  465. <td><p>TestCase Sequence Log UUID as a bianry string.</p></td>
  466. </tr>
  467. <tr class="row-odd"><td><p>testrun</p></td>
  468. <td><p>The associated Testrun (as a <code class="docutils literal notranslate"><span class="pre">TestrunLog</span></code> instance).</p></td>
  469. </tr>
  470. <tr class="row-even"><td><p>testcases</p></td>
  471. <td><p>List of the test cases (as <code class="docutils literal notranslate"><span class="pre">TestCaseLog</span></code> instances) within the associated Test Case Sequence.</p></td>
  472. </tr>
  473. <tr class="row-odd"><td><p>__str__()</p></td>
  474. <td><p>Method. Returns TestCase Sequence Log UUID as a string.</p></td>
  475. </tr>
  476. <tr class="row-even"><td><p>to_json()</p></td>
  477. <td><p>Method. Returns TestCase Sequence Log as a dictionary object.</p></td>
  478. </tr>
  479. </tbody>
  480. </table>
  481. </div>
  482. <div class="section" id="testcaselog">
  483. <h3>TestCaseLog<a class="headerlink" href="#testcaselog" title="Permalink to this headline">¶</a></h3>
  484. <p>Provides interface with database table <code class="docutils literal notranslate"><span class="pre">testCases</span></code></p>
  485. <table class="colwidths-given docutils align-default" id="id9">
  486. <caption><span class="caption-text">baangt.base.DataBaseORM.TestCaseLog</span><a class="headerlink" href="#id9" title="Permalink to this table">¶</a></caption>
  487. <colgroup>
  488. <col style="width: 30%" />
  489. <col style="width: 70%" />
  490. </colgroup>
  491. <thead>
  492. <tr class="row-odd"><th class="head"><p>Attribute</p></th>
  493. <th class="head"><p>Description</p></th>
  494. </tr>
  495. </thead>
  496. <tbody>
  497. <tr class="row-even"><td><p>id</p></td>
  498. <td><p>TestCase Log UUID as a bianry string.</p></td>
  499. </tr>
  500. <tr class="row-odd"><td><p>testcase_sequence</p></td>
  501. <td><p>The associated Test Case Sequence (as a <code class="docutils literal notranslate"><span class="pre">TestCaseSequenceLog</span></code> instance).</p></td>
  502. </tr>
  503. <tr class="row-even"><td><p>fields</p></td>
  504. <td><p>List of the attributes (as <code class="docutils literal notranslate"><span class="pre">TestCaseField</span></code> instances) of the associated Test Case.</p></td>
  505. </tr>
  506. <tr class="row-odd"><td><p>networkInfo</p></td>
  507. <td><p>List of the network requests (as <code class="docutils literal notranslate"><span class="pre">TestCaseNetworkInfo</span></code> instances) made while executing the associated Test Case.</p></td>
  508. </tr>
  509. <tr class="row-even"><td><p>__str__()</p></td>
  510. <td><p>Method. Returns TestCase Log UUID as a string.</p></td>
  511. </tr>
  512. <tr class="row-odd"><td><p>to_json()</p></td>
  513. <td><p>Method. Returns TestCase Log as a dictionary object.</p></td>
  514. </tr>
  515. </tbody>
  516. </table>
  517. </div>
  518. <div class="section" id="globalattribute">
  519. <h3>GlobalAttribute<a class="headerlink" href="#globalattribute" title="Permalink to this headline">¶</a></h3>
  520. <p>Provides interface with table <code class="docutils literal notranslate"><span class="pre">globals</span></code></p>
  521. <table class="colwidths-given docutils align-default" id="id10">
  522. <caption><span class="caption-text">baangt.base.DataBaseORM.GlobalAttribute</span><a class="headerlink" href="#id10" title="Permalink to this table">¶</a></caption>
  523. <colgroup>
  524. <col style="width: 30%" />
  525. <col style="width: 70%" />
  526. </colgroup>
  527. <thead>
  528. <tr class="row-odd"><th class="head"><p>Attribute</p></th>
  529. <th class="head"><p>Description</p></th>
  530. </tr>
  531. </thead>
  532. <tbody>
  533. <tr class="row-even"><td><p>name</p></td>
  534. <td><p>Name of the global attribute.</p></td>
  535. </tr>
  536. <tr class="row-odd"><td><p>value</p></td>
  537. <td><p>Value of the global attribute as a string.</p></td>
  538. </tr>
  539. <tr class="row-even"><td><p>testrun</p></td>
  540. <td><p>The associated Testrun (as a <code class="docutils literal notranslate"><span class="pre">TestrunLog</span></code> instance).</p></td>
  541. </tr>
  542. </tbody>
  543. </table>
  544. </div>
  545. <div class="section" id="testcasefield">
  546. <h3>TestCaseField<a class="headerlink" href="#testcasefield" title="Permalink to this headline">¶</a></h3>
  547. <p>Provides interface with table <code class="docutils literal notranslate"><span class="pre">testCaseFields</span></code></p>
  548. <table class="colwidths-given docutils align-default" id="id11">
  549. <caption><span class="caption-text">baangt.base.DataBaseORM.TestCaseField</span><a class="headerlink" href="#id11" title="Permalink to this table">¶</a></caption>
  550. <colgroup>
  551. <col style="width: 30%" />
  552. <col style="width: 70%" />
  553. </colgroup>
  554. <thead>
  555. <tr class="row-odd"><th class="head"><p>Attribute</p></th>
  556. <th class="head"><p>Description</p></th>
  557. </tr>
  558. </thead>
  559. <tbody>
  560. <tr class="row-even"><td><p>name</p></td>
  561. <td><p>Name of the Test Case Field.</p></td>
  562. </tr>
  563. <tr class="row-odd"><td><p>value</p></td>
  564. <td><p>Value of the Test Case Field as a string.</p></td>
  565. </tr>
  566. <tr class="row-even"><td><p>testcase</p></td>
  567. <td><p>The associated test case (as a <code class="docutils literal notranslate"><span class="pre">TestCaseLog</span></code> instance).</p></td>
  568. </tr>
  569. </tbody>
  570. </table>
  571. </div>
  572. <div class="section" id="testcasenetworkinfo">
  573. <h3>TestCaseNetworkInfo<a class="headerlink" href="#testcasenetworkinfo" title="Permalink to this headline">¶</a></h3>
  574. <p>Provides interface with table <code class="docutils literal notranslate"><span class="pre">networkInfo</span></code></p>
  575. <table class="colwidths-given docutils align-default" id="id12">
  576. <caption><span class="caption-text">baangt.base.DataBaseORM.TestCaseField</span><a class="headerlink" href="#id12" title="Permalink to this table">¶</a></caption>
  577. <colgroup>
  578. <col style="width: 30%" />
  579. <col style="width: 70%" />
  580. </colgroup>
  581. <thead>
  582. <tr class="row-odd"><th class="head"><p>Attribute</p></th>
  583. <th class="head"><p>Description</p></th>
  584. </tr>
  585. </thead>
  586. <tbody>
  587. <tr class="row-even"><td><p>browserName</p></td>
  588. <td><p>Browser name that mede the request.</p></td>
  589. </tr>
  590. <tr class="row-odd"><td><p>status</p></td>
  591. <td><p>Status code of the request as an integer.</p></td>
  592. </tr>
  593. <tr class="row-even"><td><p>method</p></td>
  594. <td><p>The request method used.</p></td>
  595. </tr>
  596. <tr class="row-odd"><td><p>url</p></td>
  597. <td><p>The request URL.</p></td>
  598. </tr>
  599. <tr class="row-even"><td><p>contentType</p></td>
  600. <td><p>Type of the response content as a string.</p></td>
  601. </tr>
  602. <tr class="row-odd"><td><p>contentSize</p></td>
  603. <td><p>Size of the response content as an integer.</p></td>
  604. </tr>
  605. <tr class="row-even"><td><p>headers</p></td>
  606. <td><p>A lList of the response headers as a string.</p></td>
  607. </tr>
  608. <tr class="row-odd"><td><p>params</p></td>
  609. <td><p>A list of the request GET parameters as a string.</p></td>
  610. </tr>
  611. <tr class="row-even"><td><p>response</p></td>
  612. <td><p>The response content as a string.</p></td>
  613. </tr>
  614. <tr class="row-odd"><td><p>startDateTime</p></td>
  615. <td><p>The request start time as a <code class="docutils literal notranslate"><span class="pre">datetime.datetime</span></code> object.</p></td>
  616. </tr>
  617. <tr class="row-even"><td><p>duration</p></td>
  618. <td><p>The duration of the request in <code class="docutils literal notranslate"><span class="pre">ms</span></code>.</p></td>
  619. </tr>
  620. <tr class="row-odd"><td><p>testcase</p></td>
  621. <td><p>The associated test case (as a <code class="docutils literal notranslate"><span class="pre">TestCaseLog</span></code> instance).</p></td>
  622. </tr>
  623. <tr class="row-even"><td><p>to_json()</p></td>
  624. <td><p>Method. Returns the network info as a dictionary object.</p></td>
  625. </tr>
  626. </tbody>
  627. </table>
  628. </div>
  629. </div>
  630. </div>
  631. </div>
  632. </div>
  633. <footer>
  634. <div class="rst-footer-buttons" role="navigation" aria-label="footer navigation">
  635. <a href="HistoryAndReasons.html" class="btn btn-neutral float-right" title="Why baangt and why is it open source?" accesskey="n" rel="next">Next <span class="fa fa-arrow-circle-right"></span></a>
  636. <a href="DataFile.html" class="btn btn-neutral float-left" title="Special functions in datafiles" accesskey="p" rel="prev"><span class="fa fa-arrow-circle-left"></span> Previous</a>
  637. </div>
  638. <hr/>
  639. <div role="contentinfo">
  640. <p>
  641. &copy; Copyright 2020, Bernhard Buhl
  642. </p>
  643. </div>
  644. Built with <a href="http://sphinx-doc.org/">Sphinx</a> using a <a href="https://github.com/rtfd/sphinx_rtd_theme">theme</a> provided by <a href="https://readthedocs.org">Read the Docs</a>.
  645. </footer>
  646. </div>
  647. </div>
  648. </section>
  649. </div>
  650. <script type="text/javascript">
  651. jQuery(function () {
  652. SphinxRtdTheme.Navigation.enable(true);
  653. });
  654. </script>
  655. </body>
  656. </html>