1923
97%

Ran 23 Jan 2018 08:59PM UTC

Jobs 17

Files 55

Run time 14min

Badge

Embed ▾

pending completion

Build # 1923

Build Type

Pull #1926

travis-ci

Committed by

web-flow

Commit Message

Add a string template tag handler for securely composing queries.

This is a rough draft.  It is probably not suitable in its current
form.

https://nodesecroadmap.fyi/chapter-7/query-langs.html describes
this approach as part of a larger discussion about library support
for safe coding practices.

This enables

    connection.query`SELECT * FROM T WHERE x = ${x}, y = ${y}, z = ${z}`(callback)

and similar idioms.

Pull Request Pull Request #1926: Add a string template tag handler for securely composing queries.

Run Details

837 of 1024 branches covered (81.74%)

4937 of 5168 relevant lines covered (95.53%)

4064.48 hits per line

Uncovered Existing Lines

Lines	Coverage	∆	File
2	100.0	0.0%	lib/protocol/packets/LocalDataFilePacket.js
2	83.33	0.0%	lib/protocol/packets/ComStatisticsPacket.js
2	100.0	0.0%	lib/protocol/PacketHeader.js
3	81.82	0.0%	lib/protocol/sequences/Ping.js
3	100.0	0.0%	lib/protocol/packets/ComQuitPacket.js
3	100.0	0.0%	lib/protocol/packets/ComPingPacket.js
4	100.0	0.0%	lib/protocol/packets/UseOldPasswordPacket.js
4	100.0	0.0%	lib/protocol/packets/AuthSwitchResponsePacket.js
4	100.0	0.0%	lib/protocol/ResultSet.js
5	100.0	0.0%	lib/protocol/packets/OldPasswordPacket.js
6	82.35	0.0%	lib/protocol/sequences/Statistics.js
6	100.0	0.0%	lib/protocol/packets/ComQueryPacket.js
7	90.91	0.0%	lib/protocol/packets/StatisticsPacket.js
8	91.67	0.0%	lib/protocol/packets/ResultSetHeaderPacket.js
10	100.0	0.0%	lib/protocol/packets/AuthSwitchRequestPacket.js
10	100.0	0.0%	lib/protocol/BufferList.js
11	100.0	0.0%	lib/protocol/packets/SSLRequestPacket.js
11	84.21	0.0%	lib/protocol/packets/Field.js
11	87.5	0.0%	lib/protocol/packets/EofPacket.js
11	100.0	0.0%	lib/PoolConfig.js
14	91.3	0.0%	lib/protocol/sequences/Quit.js
16	90.48	0.0%	lib/protocol/packets/ErrorPacket.js
16	100.0	0.0%	lib/protocol/packets/ComChangeUserPacket.js
17	100.0	0.0%	lib/protocol/sequences/ChangeUser.js
19	93.55	0.0%	lib/PoolConnection.js
24	93.33	0.0%	lib/protocol/packets/OkPacket.js
25	70.73	0.0%	lib/protocol/packets/ClientAuthenticationPacket.js
42	100.0	0.0%	lib/protocol/packets/RowDataPacket.js
43	88.06	0.0%	lib/protocol/sequences/Sequence.js
46	100.0	0.0%	lib/protocol/sequences/Handshake.js
50	76.81	0.0%	lib/protocol/packets/FieldPacket.js
59	95.59	0.0%	lib/protocol/packets/HandshakeInitializationPacket.js
63	100.0	0.0%	lib/protocol/Auth.js
84	100.0	0.0%	lib/ConnectionConfig.js
90	96.49	0.0%	lib/protocol/sequences/Query.js
102	99.17	0.0%	lib/protocol/PacketWriter.js
197	85.6	-11.11%	lib/Connection.js
208	94.53	0.0%	lib/protocol/Protocol.js
222	94.78	0.0%	lib/protocol/Parser.js

Jobs

ID	Job ID	Ran	Files	Coverage
3	1923.3 (DOCKER_MYSQL_TYPE=mysql DOCKER_MYSQL_VERSION=5.7)	23 Jan 2018 08:59PM UTC	48	66.32	Travis Job 1923.3
4	1923.4 (DOCKER_MYSQL_TYPE=mysql DOCKER_MYSQL_VERSION=5.7)	23 Jan 2018 09:00PM UTC	48	66.32	Travis Job 1923.4
5	1923.5 (DOCKER_MYSQL_TYPE=mysql DOCKER_MYSQL_VERSION=5.7)	23 Jan 2018 09:00PM UTC	48	66.32	Travis Job 1923.5
6	1923.6 (DOCKER_MYSQL_TYPE=mysql DOCKER_MYSQL_VERSION=5.7)	23 Jan 2018 09:02PM UTC	48	66.32	Travis Job 1923.6
7	1923.7 (DOCKER_MYSQL_TYPE=mysql DOCKER_MYSQL_VERSION=5.7)	23 Jan 2018 09:04PM UTC	48	66.32	Travis Job 1923.7
8	1923.8 (DOCKER_MYSQL_TYPE=mysql DOCKER_MYSQL_VERSION=5.7)	23 Jan 2018 09:03PM UTC	48	66.32	Travis Job 1923.8
9	1923.9 (DOCKER_MYSQL_TYPE=mysql DOCKER_MYSQL_VERSION=5.7)	23 Jan 2018 09:04PM UTC	48	66.32	Travis Job 1923.9
10	1923.10 (DOCKER_MYSQL_TYPE=mysql DOCKER_MYSQL_VERSION=5.7)	23 Jan 2018 09:04PM UTC	48	66.32	Travis Job 1923.10
11	1923.11 (DOCKER_MYSQL_TYPE=mysql DOCKER_MYSQL_VERSION=5.7)	23 Jan 2018 09:07PM UTC	55	95.51	Travis Job 1923.11
12	1923.12 (DOCKER_MYSQL_TYPE=mysql DOCKER_MYSQL_VERSION=5.7)	23 Jan 2018 09:08PM UTC	55	95.51	Travis Job 1923.12
13	1923.13 (DOCKER_MYSQL_TYPE=mysql DOCKER_MYSQL_VERSION=5.7)	23 Jan 2018 09:09PM UTC	55	95.51	Travis Job 1923.13
14	1923.14 (DOCKER_MYSQL_TYPE=mysql DOCKER_MYSQL_VERSION=5.5)	23 Jan 2018 09:08PM UTC	55	95.51	Travis Job 1923.14
15	1923.15 (DOCKER_MYSQL_TYPE=mysql DOCKER_MYSQL_VERSION=5.6)	23 Jan 2018 09:09PM UTC	55	95.51	Travis Job 1923.15
16	1923.16 (DOCKER_MYSQL_TYPE=mariadb DOCKER_MYSQL_VERSION=5.5)	23 Jan 2018 09:13PM UTC	55	95.51	Travis Job 1923.16
17	1923.17 (DOCKER_MYSQL_TYPE=mariadb DOCKER_MYSQL_VERSION=10.0)	23 Jan 2018 09:12PM UTC	55	95.51	Travis Job 1923.17
18	1923.18 (DOCKER_MYSQL_TYPE=mariadb DOCKER_MYSQL_VERSION=10.1)	23 Jan 2018 09:13PM UTC	55	95.51	Travis Job 1923.18
19	1923.19 (DOCKER_MYSQL_TYPE=mariadb DOCKER_MYSQL_VERSION=10.2)	23 Jan 2018 09:13PM UTC	55	95.51	Travis Job 1923.19

Source Files on build 1923

Coverage	∆	File	Lines	Relevant	Covered	Missed	Hits/Line	Branch Hits	Branch Misses

mysqljs / mysql / 1923
97%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Uncovered Existing Lines

Jobs

Source Files on build 1923

mysqljs / mysql / 1923 97%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Uncovered Existing Lines

Jobs

Source Files on build 1923

mysqljs / mysql / 1923
97%

README BADGES
x