Ifthakhar Riyad ifthakharriyad

MongoDB Cheat Sheet

Show All Databases

show dbs

Show Current Database

'Include' in Sequelize: The One Confusing Query That You Should Memorize

When querying your database in Sequelize, you'll often want data associated with a particular model which isn't in the model's table directly. This data is usually typically associated through join tables (e.g. a 'hasMany' or 'belongsToMany' association), or a foreign key (e.g. a 'hasOne' or 'belongsTo' association).

When you query, you'll receive just the rows you've looked for. With eager loading, you'll also get any associated data. For some reason, I can never remember the proper way to do eager loading when writing my Sequelize queries. I've seen others struggle with the same thing.

Eager loading is confusing because the 'include' that is uses has unfamiliar fields is set in an array rather than just an object.

So let's go through the one query that's worth memorizing to handle your eager loading.

The Basic Query

Test credit card numbers to use when developing with Stripe

4242424242424242 Visa

4012888888881881 Visa

4000056655665556 Visa (debit)

This can reduce files to ~15% of their size (2.3M to 345K, in one case) with no obvious degradation of quality.

ghostscript -sDEVICE=pdfwrite -dCompatibilityLevel=1.4 -dPDFSETTINGS=/printer -dNOPAUSE -dQUIET -dBATCH -sOutputFile=output.pdf input.pdf

Other options for PDFSETTINGS:

/screen selects low-resolution output similar to the Acrobat Distiller "Screen Optimized" setting.
/ebook selects medium-resolution output similar to the Acrobat Distiller "eBook" setting.
/printer selects output similar to the Acrobat Distiller "Print Optimized" setting.
/prepress selects output similar to Acrobat Distiller "Prepress Optimized" setting.

	// per https://docs.npmjs.com/misc/scripts, npm exposes a bunch of variables to
	// the environment prefixed with npm_config_, npm_package_ and npm_lifecycle_*.
	// Here's a list of all variables exposed in my setup.

	npm_config_access=
	npm_config_allow_same_version=
	npm_config_also=
	npm_config_always_auth=
	npm_config_argv='{"remain":[],"cooked":["run","foo"],"original":["run","foo"]}'
	npm_config_auth_type=legacy

	# Secure adminer setup
	# Author Taras Kozlov

	# download adminer to separate directory
	mkdir -p /var/www/admin
	cd /var/www/admin
	wget http://www.adminer.org/latest.php -O adminer.php
	echo '<?php phpinfo(); >' > info.php

	sudo -i