Permalink
Cannot retrieve contributors at this time
Name already in use
A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?
Local_News/docs/coverage/lcov-report/register.js.html
Go to fileThis commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.
222 lines (222 sloc)
8.71 KB
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <!doctype html> | |
| <html lang="en"> | |
| <head> | |
| <title>Code coverage report for register.js</title> | |
| <meta charset="utf-8" /> | |
| <link rel="stylesheet" href="prettify.css" /> | |
| <link rel="stylesheet" href="base.css" /> | |
| <meta name="viewport" content="width=device-width, initial-scale=1"> | |
| <style type='text/css'> | |
| .coverage-summary .sorter { | |
| background-image: url(sort-arrow-sprite.png); | |
| } | |
| </style> | |
| </head> | |
| <body> | |
| <div class='wrapper'> | |
| <div class='pad1'> | |
| <h1> | |
| <a href="index.html">All files</a> register.js | |
| </h1> | |
| <div class='clearfix'> | |
| <div class='fl pad1y space-right2'> | |
| <span class="strong">64.52% </span> | |
| <span class="quiet">Statements</span> | |
| <span class='fraction'>20/31</span> | |
| </div> | |
| <div class='fl pad1y space-right2'> | |
| <span class="strong">66.67% </span> | |
| <span class="quiet">Branches</span> | |
| <span class='fraction'>6/9</span> | |
| </div> | |
| <div class='fl pad1y space-right2'> | |
| <span class="strong">75% </span> | |
| <span class="quiet">Functions</span> | |
| <span class='fraction'>3/4</span> | |
| </div> | |
| <div class='fl pad1y space-right2'> | |
| <span class="strong">66.67% </span> | |
| <span class="quiet">Lines</span> | |
| <span class='fraction'>18/27</span> | |
| </div> | |
| </div> | |
| <p class="quiet"> | |
| Press <em>n</em> or <em>j</em> to go to the next uncovered block, <em>b</em>, <em>p</em> or <em>k</em> for the previous block. | |
| </p> | |
| </div> | |
| <div class='status-line medium'></div> | |
| <pre><table class="coverage"> | |
| <tr><td class="line-count quiet"><a name='L1'></a><a href='#L1'>1</a> | |
| <a name='L2'></a><a href='#L2'>2</a> | |
| <a name='L3'></a><a href='#L3'>3</a> | |
| <a name='L4'></a><a href='#L4'>4</a> | |
| <a name='L5'></a><a href='#L5'>5</a> | |
| <a name='L6'></a><a href='#L6'>6</a> | |
| <a name='L7'></a><a href='#L7'>7</a> | |
| <a name='L8'></a><a href='#L8'>8</a> | |
| <a name='L9'></a><a href='#L9'>9</a> | |
| <a name='L10'></a><a href='#L10'>10</a> | |
| <a name='L11'></a><a href='#L11'>11</a> | |
| <a name='L12'></a><a href='#L12'>12</a> | |
| <a name='L13'></a><a href='#L13'>13</a> | |
| <a name='L14'></a><a href='#L14'>14</a> | |
| <a name='L15'></a><a href='#L15'>15</a> | |
| <a name='L16'></a><a href='#L16'>16</a> | |
| <a name='L17'></a><a href='#L17'>17</a> | |
| <a name='L18'></a><a href='#L18'>18</a> | |
| <a name='L19'></a><a href='#L19'>19</a> | |
| <a name='L20'></a><a href='#L20'>20</a> | |
| <a name='L21'></a><a href='#L21'>21</a> | |
| <a name='L22'></a><a href='#L22'>22</a> | |
| <a name='L23'></a><a href='#L23'>23</a> | |
| <a name='L24'></a><a href='#L24'>24</a> | |
| <a name='L25'></a><a href='#L25'>25</a> | |
| <a name='L26'></a><a href='#L26'>26</a> | |
| <a name='L27'></a><a href='#L27'>27</a> | |
| <a name='L28'></a><a href='#L28'>28</a> | |
| <a name='L29'></a><a href='#L29'>29</a> | |
| <a name='L30'></a><a href='#L30'>30</a> | |
| <a name='L31'></a><a href='#L31'>31</a> | |
| <a name='L32'></a><a href='#L32'>32</a> | |
| <a name='L33'></a><a href='#L33'>33</a> | |
| <a name='L34'></a><a href='#L34'>34</a> | |
| <a name='L35'></a><a href='#L35'>35</a> | |
| <a name='L36'></a><a href='#L36'>36</a> | |
| <a name='L37'></a><a href='#L37'>37</a> | |
| <a name='L38'></a><a href='#L38'>38</a> | |
| <a name='L39'></a><a href='#L39'>39</a> | |
| <a name='L40'></a><a href='#L40'>40</a> | |
| <a name='L41'></a><a href='#L41'>41</a> | |
| <a name='L42'></a><a href='#L42'>42</a> | |
| <a name='L43'></a><a href='#L43'>43</a> | |
| <a name='L44'></a><a href='#L44'>44</a> | |
| <a name='L45'></a><a href='#L45'>45</a> | |
| <a name='L46'></a><a href='#L46'>46</a> | |
| <a name='L47'></a><a href='#L47'>47</a> | |
| <a name='L48'></a><a href='#L48'>48</a> | |
| <a name='L49'></a><a href='#L49'>49</a> | |
| <a name='L50'></a><a href='#L50'>50</a> | |
| <a name='L51'></a><a href='#L51'>51</a> | |
| <a name='L52'></a><a href='#L52'>52</a></td><td class="line-coverage quiet"><span class="cline-any cline-neutral"> </span> | |
| <span class="cline-any cline-neutral"> </span> | |
| <span class="cline-any cline-yes">1x</span> | |
| <span class="cline-any cline-yes">1x</span> | |
| <span class="cline-any cline-neutral"> </span> | |
| <span class="cline-any cline-neutral"> </span> | |
| <span class="cline-any cline-no"> </span> | |
| <span class="cline-any cline-no"> </span> | |
| <span class="cline-any cline-no"> </span> | |
| <span class="cline-any cline-no"> </span> | |
| <span class="cline-any cline-no"> </span> | |
| <span class="cline-any cline-no"> </span> | |
| <span class="cline-any cline-no"> </span> | |
| <span class="cline-any cline-no"> </span> | |
| <span class="cline-any cline-neutral"> </span> | |
| <span class="cline-any cline-no"> </span> | |
| <span class="cline-any cline-neutral"> </span> | |
| <span class="cline-any cline-neutral"> </span> | |
| <span class="cline-any cline-neutral"> </span> | |
| <span class="cline-any cline-neutral"> </span> | |
| <span class="cline-any cline-yes">1x</span> | |
| <span class="cline-any cline-neutral"> </span> | |
| <span class="cline-any cline-neutral"> </span> | |
| <span class="cline-any cline-yes">3x</span> | |
| <span class="cline-any cline-yes">3x</span> | |
| <span class="cline-any cline-yes">3x</span> | |
| <span class="cline-any cline-yes">3x</span> | |
| <span class="cline-any cline-yes">3x</span> | |
| <span class="cline-any cline-neutral"> </span> | |
| <span class="cline-any cline-neutral"> </span> | |
| <span class="cline-any cline-neutral"> </span> | |
| <span class="cline-any cline-neutral"> </span> | |
| <span class="cline-any cline-neutral"> </span> | |
| <span class="cline-any cline-yes">3x</span> | |
| <span class="cline-any cline-yes">3x</span> | |
| <span class="cline-any cline-yes">2x</span> | |
| <span class="cline-any cline-yes">1x</span> | |
| <span class="cline-any cline-yes">1x</span> | |
| <span class="cline-any cline-yes">1x</span> | |
| <span class="cline-any cline-yes">1x</span> | |
| <span class="cline-any cline-yes">1x</span> | |
| <span class="cline-any cline-yes">1x</span> | |
| <span class="cline-any cline-neutral"> </span> | |
| <span class="cline-any cline-yes">2x</span> | |
| <span class="cline-any cline-neutral"> </span> | |
| <span class="cline-any cline-neutral"> </span> | |
| <span class="cline-any cline-neutral"> </span> | |
| <span class="cline-any cline-neutral"> </span> | |
| <span class="cline-any cline-neutral"> </span> | |
| <span class="cline-any cline-neutral"> </span> | |
| <span class="cline-any cline-neutral"> </span> | |
| <span class="cline-any cline-neutral"> </span></td><td class="text"><pre class="prettyprint lang-js">'use strict' | |
| | |
| const sqlite = require('sqlite-async') | |
| const bcrypt = require('bcrypt-promise') | |
| | |
| async function <span class="fstat-no" title="function not covered" >runSQL(</span>query) { | |
| <span class="cstat-no" title="statement not covered" > try {</span> | |
| <span class="cstat-no" title="statement not covered" > console.log(query)</span> | |
| const DBName = <span class="cstat-no" title="statement not covered" >'./website.db'</span> | |
| const db = <span class="cstat-no" title="statement not covered" >await sqlite.open(DBName)</span> | |
| const data = <span class="cstat-no" title="statement not covered" >await db.all(query)</span> | |
| <span class="cstat-no" title="statement not covered" > await db.close()</span> | |
| <span class="cstat-no" title="statement not covered" > if(data.length === 1) <span class="cstat-no" title="statement not covered" >return data[0]</span></span> | |
| <span class="cstat-no" title="statement not covered" > return data</span> | |
| } catch(err) { | |
| <span class="cstat-no" title="statement not covered" > throw err</span> | |
| } | |
| | |
| } | |
| | |
| module.exports = class register { | |
| | |
| constructor(dbName = ':memory:') { | |
| return (async() => { | |
| this.db = await sqlite.open(dbName) | |
| const sql = 'CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY AUTOINCREMENT, user TEXT, pass TEXT);' | |
| await this.db.run(sql) | |
| return this | |
| })() | |
| } | |
| | |
| | |
| async checkregister(user,pass) { | |
| try { | |
| if(user.length === 0) throw new Error('Field Required') | |
| if(pass.length === 0) throw new Error('Field Required') | |
| let sql = `SELECT COUNT(id) as records FROM users WHERE user="${user}";` | |
| const data = await this.db.get(sql) | |
| <span class="missing-if-branch" title="if path not taken" >I</span>if(data.records !== 0) <span class="cstat-no" title="statement not covered" >throw new Error(`users "${user}" already exists`)</span> | |
| sql = `INSERT INTO users(user,pass) VALUES("${user}","${pass}")` | |
| await this.db.run(sql) | |
| return true | |
| } catch(err) { | |
| throw err | |
| } | |
| } | |
| | |
| | |
| } | |
| | |
| | |
| </pre></td></tr> | |
| </table></pre> | |
| <div class='push'></div><!-- for sticky footer --> | |
| </div><!-- /wrapper --> | |
| <div class='footer quiet pad2 space-top1 center small'> | |
| Code coverage | |
| generated by <a href="https://istanbul.js.org/" target="_blank">istanbul</a> at Thu Dec 05 2019 14:03:10 GMT+0000 (Greenwich Mean Time) | |
| </div> | |
| </div> | |
| <script src="prettify.js"></script> | |
| <script> | |
| window.onload = function () { | |
| if (typeof prettyPrint === 'function') { | |
| prettyPrint(); | |
| } | |
| }; | |
| </script> | |
| <script src="sorter.js"></script> | |
| <script src="block-navigation.js"></script> | |
| </body> | |
| </html> |