brianc/gist:1663864

Created January 23, 2012 15:40

Star 1 You must be signed in to star a gist
Fork 0 You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/brianc/1663864.js"></script>
Save brianc/1663864 to your computer and use it in GitHub Desktop.

Download ZIP

monkey-patch node-postgres to log queries

Raw

gistfile1.txt

	var Query = require('pg').Query;

	var actualSubmit = Query.prototype.submit;

	Query.prototype.submit = function() {
	console.log(this.text);
	actualSubmit.apply(this, arguments);
	}

tugorez commented May 28, 2018 •

edited

How about this ? This actually logs the final query.

const Query = require('pg').Query;
const submit = Query.prototype.submit;
Query.prototype.submit = function() {
  const text = this.text;
  const values = this.values;
  const query = values.reduce((q, v, i) => q.replace(`$${i + 1}`, v), text);
  console.log(query);
  submit.apply(this, arguments);
};

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment