123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481 |
- 'use strict';
- const Iconv = require('iconv-lite');
- const QUOTE = 0x27;
- const DBL_QUOTE = 0x22;
- const ZERO_BYTE = 0x00;
- const SLASH = 0x5c;
- const SMALL_BUFFER_SIZE = 1024;
- const MEDIUM_BUFFER_SIZE = 16384; //16k
- const LARGE_BUFFER_SIZE = 131072; //128k
- const BIG_BUFFER_SIZE = 1048576; //1M
- const MAX_BUFFER_SIZE = 16777219; //16M + 4
- const CHARS_GLOBAL_REGEXP = /[\0\"\'\\]/g; // eslint-disable-line no-control-regex
- /**
- * Packet splitter.
- *
- * The servers have a limit max_allowed_packet which limits the size of the data sent, to avoid saturating the server in memory.
- *
- * The following implementation has a workaround that will rewrite the command and separate the send according to this value.
- * This implies that this command can send multiple commands, with some tricks for sequencing packets.
- *
- */
- class ReWritePacket {
- constructor(maxAllowedPacket, out, initString, endString) {
- this.out = out;
- this.buf = Buffer.allocUnsafe(SMALL_BUFFER_SIZE);
- this.pos = 4;
- this.initStr = initString;
- this.endStr = endString;
- this.encoding = out.encoding;
- this.endStrLength = Buffer.byteLength(this.endStr, this.encoding);
- this.waitingResponseNo = 0;
- this.singleQuery = false;
- this.haveErrorResponse = false;
- if (this.encoding === 'utf8') {
- this.writeString = this.writeDefaultBufferString;
- this.writeStringEscapeQuote = this.writeUtf8StringEscapeQuote;
- } else if (Buffer.isEncoding(this.encoding)) {
- this.writeString = this.writeDefaultBufferString;
- this.writeStringEscapeQuote = this.writeDefaultStringEscapeQuote;
- } else {
- this.writeString = this.writeDefaultIconvString;
- this.writeStringEscapeQuote = this.writeDefaultStringEscapeQuote;
- }
- this.maxAllowedPacket = maxAllowedPacket;
- if (maxAllowedPacket) {
- this.maxPacketSize = Math.min(MAX_BUFFER_SIZE, maxAllowedPacket) - this.endStrLength;
- } else this.maxPacketSize = 4194304 - this.endStrLength;
- this.buf[this.pos++] = 0x03;
- this.writeString(this.initStr);
- }
- growBuffer(len) {
- let newCapacity;
- if (len + this.pos < MEDIUM_BUFFER_SIZE) {
- newCapacity = MEDIUM_BUFFER_SIZE;
- } else if (len + this.pos < LARGE_BUFFER_SIZE) {
- newCapacity = LARGE_BUFFER_SIZE;
- } else if (len + this.pos < BIG_BUFFER_SIZE) {
- newCapacity = BIG_BUFFER_SIZE;
- } else newCapacity = MAX_BUFFER_SIZE;
- if (newCapacity > this.maxPacketSize && this.markPos) {
- this.flush(false, len);
- return true;
- }
- let newBuf = Buffer.allocUnsafe(Math.min(newCapacity));
- this.buf.copy(newBuf, 0, 0, this.pos);
- this.buf = newBuf;
- return false;
- }
- writeInt8(value) {
- let flushed = false;
- if (this.pos + 1 + this.endStrLength >= this.buf.length) {
- if (this.buf.length < MAX_BUFFER_SIZE) {
- flushed = this.growBuffer(1);
- } else {
- this.flush(false, 1);
- this.buf[this.pos++] = value;
- return true;
- }
- }
- this.buf[this.pos++] = value;
- return flushed;
- }
- /**
- * Write ascii string to socket (no escaping)
- *
- * @param str string
- */
- writeStringAscii(str) {
- let len = str.length;
- //not enough space remaining
- if (len >= this.buf.length - (this.pos + this.endStrLength)) {
- let strBuf = Buffer.from(str, 'ascii');
- return this.writeBuffer(strBuf, 0, strBuf.length);
- }
- for (let off = 0; off < len; ) {
- this.buf[this.pos++] = str.charCodeAt(off++);
- }
- return false;
- }
- writeUtf8StringEscapeQuote(str) {
- const charsLength = str.length;
- //not enough space remaining
- if (charsLength * 3 + 2 >= this.buf.length - (this.pos + this.endStrLength)) {
- let flushed;
- const arr = Buffer.from(str, 'utf8');
- flushed = this.writeInt8(QUOTE);
- flushed = this.writeBufferEscape(arr) || flushed;
- flushed = this.writeInt8(QUOTE) || flushed;
- return flushed;
- }
- //create UTF-8 byte array
- //since javascript char are internally using UTF-16 using surrogate's pattern, 4 bytes unicode characters will
- //represent 2 characters : example "\uD83C\uDFA4" = 🎤 unicode 8 "no microphones"
- //so max size is 3 * charLength
- //(escape characters are 1 byte encoded, so length might only be 2 when escaped)
- // + 2 for the quotes for text protocol
- let charsOffset = 0;
- let currChar;
- this.buf[this.pos++] = QUOTE;
- //quick loop if only ASCII chars for faster escape
- for (
- ;
- charsOffset < charsLength && (currChar = str.charCodeAt(charsOffset)) < 0x80;
- charsOffset++
- ) {
- if (
- currChar === SLASH ||
- currChar === QUOTE ||
- currChar === ZERO_BYTE ||
- currChar === DBL_QUOTE
- ) {
- this.buf[this.pos++] = SLASH;
- }
- this.buf[this.pos++] = currChar;
- }
- //if quick loop not finished
- while (charsOffset < charsLength) {
- currChar = str.charCodeAt(charsOffset++);
- if (currChar < 0x80) {
- if (
- currChar === SLASH ||
- currChar === QUOTE ||
- currChar === ZERO_BYTE ||
- currChar === DBL_QUOTE
- ) {
- this.buf[this.pos++] = SLASH;
- }
- this.buf[this.pos++] = currChar;
- } else if (currChar < 0x800) {
- this.buf[this.pos++] = 0xc0 | (currChar >> 6);
- this.buf[this.pos++] = 0x80 | (currChar & 0x3f);
- } else if (currChar >= 0xd800 && currChar < 0xe000) {
- //reserved for surrogate - see https://en.wikipedia.org/wiki/UTF-16
- if (currChar < 0xdc00) {
- //is high surrogate
- if (charsOffset + 1 > charsLength) {
- this.buf[this.pos++] = 0x3f;
- } else {
- const nextChar = str.charCodeAt(charsOffset);
- if (nextChar >= 0xdc00 && nextChar < 0xe000) {
- //is low surrogate
- const surrogatePairs =
- (currChar << 10) + nextChar + (0x010000 - (0xd800 << 10) - 0xdc00);
- this.buf[this.pos++] = 0xf0 | (surrogatePairs >> 18);
- this.buf[this.pos++] = 0x80 | ((surrogatePairs >> 12) & 0x3f);
- this.buf[this.pos++] = 0x80 | ((surrogatePairs >> 6) & 0x3f);
- this.buf[this.pos++] = 0x80 | (surrogatePairs & 0x3f);
- charsOffset++;
- } else {
- //must have low surrogate
- this.buf[this.pos++] = 0x3f;
- }
- }
- } else {
- //low surrogate without high surrogate before
- this.buf[this.pos++] = 0x3f;
- }
- } else {
- this.buf[this.pos++] = 0xe0 | (currChar >> 12);
- this.buf[this.pos++] = 0x80 | ((currChar >> 6) & 0x3f);
- this.buf[this.pos++] = 0x80 | (currChar & 0x3f);
- }
- }
- this.buf[this.pos++] = QUOTE;
- return false;
- }
- writeDefaultIconvString(str) {
- let buf = Iconv.encode(str, this.encoding);
- return this.writeBuffer(buf, 0, buf.length);
- }
- writeDefaultBufferString(str) {
- //javascript use UCS-2 or UTF-16 string internal representation
- //that means that string to byte will be a maximum of * 3
- // (4 bytes utf-8 are represented on 2 UTF-16 characters)
- if (str.length * 3 < this.buf.length - (this.pos + this.endStrLength)) {
- this.pos += this.buf.write(str, this.pos, this.encoding);
- return false;
- }
- //checking real length
- let flushed = false;
- let byteLength = Buffer.byteLength(str, this.encoding);
- if (byteLength > this.buf.length - (this.pos + this.endStrLength)) {
- if (this.buf.length < MAX_BUFFER_SIZE) {
- flushed = this.growBuffer(byteLength);
- }
- if (byteLength > this.buf.length - (this.pos + this.endStrLength)) {
- //not enough space in buffer, will stream :
- let strBuf = Buffer.from(str, this.encoding);
- flushed = this.writeBuffer(strBuf, 0, strBuf.length) || flushed;
- return flushed;
- }
- }
- this.pos += this.buf.write(str, this.pos, this.encoding);
- return flushed;
- }
- /**
- * Parameters need to be properly escaped :
- * following characters are to be escaped by "\" :
- * - \0
- * - \\
- * - \'
- * - \"
- * regex split part of string writing part, and escaping special char.
- * Those chars are <= 7f meaning that this will work even with multi-byte encoding
- *
- * @param str string to escape.
- */
- writeDefaultStringEscapeQuote(str) {
- let flushed = this.writeInt8(QUOTE);
- let match;
- let lastIndex = 0;
- while ((match = CHARS_GLOBAL_REGEXP.exec(str)) !== null) {
- flushed = this.writeString(str.slice(lastIndex, match.index)) || flushed;
- flushed = this.writeInt8(SLASH) || flushed;
- flushed = this.writeInt8(match[0].charCodeAt(0)) || flushed;
- lastIndex = CHARS_GLOBAL_REGEXP.lastIndex;
- }
- if (lastIndex === 0) {
- // Nothing was escaped
- flushed = this.writeString(str) || flushed;
- flushed = this.writeInt8(QUOTE) || flushed;
- return flushed;
- }
- if (lastIndex < str.length) {
- flushed = this.writeString(str.slice(lastIndex)) || flushed;
- }
- flushed = this.writeInt8(QUOTE) || flushed;
- return flushed;
- }
- writeBufferEscape(val) {
- let flushed = false;
- let valLen = val.length;
- if (valLen * 2 > this.buf.length - (this.pos + this.endStrLength)) {
- //makes buffer bigger (up to 16M)
- if (this.buf.length < MAX_BUFFER_SIZE) flushed = this.growBuffer(valLen * 2);
- //data may still be bigger than buffer.
- //must flush buffer when full (and reset position to 4)
- if (valLen * 2 > this.buf.length - (this.pos + this.endStrLength)) {
- //not enough space in buffer, will fill buffer
- for (let i = 0; i < valLen; i++) {
- switch (val[i]) {
- case QUOTE:
- case SLASH:
- case DBL_QUOTE:
- case ZERO_BYTE:
- if (this.pos >= this.buf.length) this.flush(false, (valLen - i) * 2);
- this.buf[this.pos++] = SLASH; //add escape slash
- }
- if (this.pos >= this.buf.length) this.flush(false, (valLen - i) * 2);
- this.buf[this.pos++] = val[i];
- }
- return true;
- }
- }
- //sure to have enough place to use buffer directly
- for (let i = 0; i < valLen; i++) {
- switch (val[i]) {
- case QUOTE:
- case SLASH:
- case DBL_QUOTE:
- case ZERO_BYTE:
- this.buf[this.pos++] = SLASH; //add escape slash
- }
- this.buf[this.pos++] = val[i];
- }
- return flushed;
- }
- writeBuffer(arr, off, len) {
- let flushed = false;
- if (len > this.buf.length - (this.pos + this.endStrLength)) {
- if (this.buf.length < MAX_BUFFER_SIZE) flushed = this.growBuffer(len);
- //max buffer size
- if (len > this.buf.length - (this.pos + this.endStrLength)) {
- //not enough space in buffer, will stream :
- // fill buffer and flush until all data are snd
- let remainingLen = len;
- while (true) {
- //filling buffer
- let lenToFillBuffer = Math.min(MAX_BUFFER_SIZE - this.pos, remainingLen);
- arr.copy(this.buf, this.pos, off, off + lenToFillBuffer);
- remainingLen -= lenToFillBuffer;
- off += lenToFillBuffer;
- this.pos += lenToFillBuffer;
- if (remainingLen === 0) return flushed;
- this.flush(false, remainingLen);
- flushed = true;
- }
- }
- }
- arr.copy(this.buf, this.pos, off, off + len);
- this.pos += len;
- return flushed;
- }
- mark(isLast) {
- let flushed = false;
- if (this.singleQuery) {
- //end of big query that is more than 16M
- //write single one
- flushed = this.writeString(this.endStr);
- if (!this.haveErrorResponse) {
- const packetSendSize =
- this.pos +
- (this.singleQuerySequenceNo != undefined
- ? (this.singleQuerySequenceNo + 1) * MAX_BUFFER_SIZE
- : 0);
- if (this.maxAllowedPacket && packetSendSize > this.maxAllowedPacket) {
- console.log(
- "will send a packet to db server with size > connection option 'maxAllowedPacket' (size send is " +
- packetSendSize +
- ') connection might be reset by server'
- );
- }
- this.copyAndFlush(true);
- flushed = true;
- this.markPos = undefined;
- }
- this.singleQuerySequenceNo = undefined;
- this.singleQueryCompressSequenceNo = undefined;
- this.singleQuery = false;
- this.buf[this.pos++] = 0x03;
- this.writeString(this.initStr);
- this.markPos = undefined;
- } else {
- if (this.markPos && this.pos + this.endStrLength > this.maxPacketSize) {
- //not enough room for current query, flush mark.
- this.flushMark();
- flushed = true;
- }
- //just mark ending query
- this.markPos = this.pos;
- if (isLast) {
- this.flushMark();
- flushed = true;
- }
- if (!isLast) flushed = this.writeStringAscii(',') || flushed;
- }
- return flushed;
- }
- flush(end, remainingLen) {
- if (this.markPos && !this.singleQuery) {
- this.flushMark();
- } else {
- //one insert is more than 16M, will continue to mono insert, hoping
- //that max_allowed_packet is sized accordingly to query.
- if (this.buf.length < MAX_BUFFER_SIZE) {
- //in this case, connector has default to 4M packet, and a single query size
- //is > to 4mb. growing buffer to 16M
- let newBuf = Buffer.allocUnsafe(MAX_BUFFER_SIZE);
- this.buf.copy(newBuf, 0, 0, this.pos);
- this.buf = newBuf;
- } else {
- if (!this.haveErrorResponse) {
- if (this.maxAllowedPacket && this.buf.length > this.maxAllowedPacket) {
- console.log(
- "will send a packet to server with size > connection option 'maxAllowedPacket' (size send is " +
- this.pos +
- ') connection might be reset by server'
- );
- }
- this.copyAndFlush(false);
- this.markPos = undefined;
- if (!this.singleQuery) this.waitingResponseNo++;
- this.singleQuery = true;
- this.singleQuerySequenceNo = this.out.cmd.sequenceNo;
- this.singleQueryCompressSequenceNo = this.out.cmd.compressSequenceNo;
- }
- }
- }
- }
- flushMark() {
- let afterMark;
- if (this.pos !== this.markPos) {
- //remove "," character
- afterMark = Buffer.allocUnsafe(this.pos - this.markPos - 1);
- this.buf.copy(afterMark, 0, this.markPos + 1, this.pos);
- }
- this.pos = this.markPos;
- this.writeString(this.endStr);
- if (!this.haveErrorResponse) {
- this.copyAndFlush(true);
- this.waitingResponseNo++;
- }
- this.pos = 4;
- this.buf[this.pos++] = 0x03;
- this.writeString(this.initStr);
- this.markPos = undefined;
- if (afterMark) {
- if (this.buf.length - this.pos < afterMark.length)
- this.growBuffer(afterMark.length - (this.buf.length - this.pos));
- afterMark.copy(this.buf, this.pos, 0, afterMark.length);
- this.pos += afterMark.length;
- }
- this.singleQuery = false;
- this.singleQuerySequenceNo = undefined;
- this.singleQueryCompressSequenceNo = undefined;
- }
- copyAndFlush(ended) {
- this.out.buf = this.buf;
- this.out.pos = this.pos;
- if (this.singleQuerySequenceNo != undefined) {
- this.out.cmd.sequenceNo = this.singleQuerySequenceNo;
- this.out.cmd.compressSequenceNo = this.singleQueryCompressSequenceNo;
- } else {
- this.out.cmd.sequenceNo = -1;
- this.out.cmd.compressSequenceNo = -1;
- }
- this.out.flushBuffer(ended);
- if (this.singleQuerySequenceNo != undefined) {
- this.singleQuerySequenceNo = this.out.cmd.sequenceNo;
- this.singleQueryCompressSequenceNo = this.out.cmd.compressSequenceNo;
- }
- this.pos = 4;
- this.buf = Buffer.allocUnsafe(SMALL_BUFFER_SIZE);
- }
- endedWithError() {
- this.haveErrorResponse = true;
- }
- }
- module.exports = ReWritePacket;
|