monologue
Advanced tools
Comparing version 0.7.1 to 0.7.2
@@ -76,2 +76,3 @@ (function(exports) { | ||
this.parts.stmt = ["SELECT", col, "FROM", tbl].join(' '); | ||
// this.parts.stmt = `SELECT ${col} FROM ${tbl}`; | ||
@@ -106,2 +107,3 @@ return this; | ||
fields.push( ii + " = " + stmt[ii] ); | ||
// fields.push( `${ii} = ${stmt[ii]}` ); | ||
} | ||
@@ -113,2 +115,3 @@ | ||
this.parts.join.push( [dir, "JOIN", tbl, "ON", stmt].join(' ') ); | ||
// this.parts.join.push( `${dir} JOIN ${tbl} ON ${stmt}` ); | ||
@@ -155,2 +158,3 @@ return this; | ||
col = "(" + a.shift() + ") VALUES " + a.join(','); | ||
// col = `(${a.shift()}) VALUES ${a.join(',')}`; | ||
} | ||
@@ -163,2 +167,3 @@ | ||
this.parts.stmt = ["INSERT INTO", tbl, col].join(' '); | ||
// this.parts.stmt = `INSERT INTO ${tbl} ${col}`; | ||
@@ -188,3 +193,4 @@ return this; | ||
this.parts.stmt = ["UPDATE", tbl, col].join(' '); | ||
this.parts.stmt = 'UPDATE ' + tbl + ' ' + col; | ||
// this.parts.stmt = `UPDATE ${tbl} ${col}`; | ||
@@ -215,2 +221,3 @@ return this; | ||
this.parts.stmt = "DELETE FROM " + tbl; | ||
// this.parts.stmt = `DELETE FROM ${tbl}`; | ||
return ( wh ? this.where( wh ) : this ); | ||
@@ -255,2 +262,4 @@ }; | ||
cond = '(' + cond.join(' OR ') + ')'; | ||
// cond = cond.join(' OR ') | ||
// cond = `(${cond})`; | ||
} | ||
@@ -300,2 +309,3 @@ | ||
return this.where(" LIKE " + like, ''); | ||
// return this.where(` LIKE ${like}`, ''); | ||
}; | ||
@@ -314,2 +324,3 @@ | ||
return this.where(" BETWEEN " + one + " AND " + two, ''); | ||
// return this.where(` BETWEEN ${one} AND ${two}`, ''); | ||
}; | ||
@@ -332,2 +343,3 @@ | ||
this.parts.group.push( grp + " " + dir ); | ||
// this.parts.group.push( `${grp} ${dir}` ); | ||
@@ -352,2 +364,3 @@ return this; | ||
this.parts.order.push( ord + " " + dir ); | ||
// this.parts.order.push( `${ord} ${dir}` ); | ||
@@ -365,2 +378,3 @@ return this; | ||
: lim + ' OFFSET ' + off ); | ||
// : `${lim} OFFSET ${off}` ); | ||
@@ -386,2 +400,3 @@ return this; | ||
this.parts.stmt = sql += " UNION SELECT " + c + " FROM " + t; | ||
// this.parts.stmt = `${sql} UNION SELECT ${c} FROM ${t}`; | ||
@@ -608,2 +623,3 @@ return this; | ||
+ " IN (" + vs + ")"; | ||
// + ` IN (${vs})`; | ||
@@ -613,22 +629,2 @@ return ret; | ||
// else if( v === Object(v) ) { | ||
// var c = []; | ||
// for( var i in v ) { | ||
// if( s ) { | ||
// c.push(this.format(v[i], i, s)) | ||
// } | ||
// else { | ||
// c.push(this.format(v[i])) | ||
// } | ||
// } | ||
// c = c.join(','); | ||
// if( ! s ) { | ||
// c = "(" + c + ")"; | ||
// } | ||
// return c; | ||
// } | ||
else { | ||
@@ -699,2 +695,3 @@ if( this.opt.escape ) { | ||
return "'" + val + "'"; | ||
// return `'${val}'`; | ||
}; | ||
@@ -736,2 +733,3 @@ | ||
return '`' + pre + col + '`'; | ||
// return `\`${pre}${col}\``; | ||
} | ||
@@ -738,0 +736,0 @@ }; |
{ | ||
"name": "monologue", | ||
"version": "0.7.1", | ||
"version": "0.7.2", | ||
"description": "Streamlined MySQL query building", | ||
@@ -5,0 +5,0 @@ "main": "./monologue.js", |
59076
536