Paul Wadsworth toriaezunama

'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

NSTimer is a great example of an over-verbose, outdated Objective-C API. To run a simple line of code after a delay, you need to write a lot of boilerplate crap.

How about this:

NSTimer.schedule(5.seconds) {
  println("Hello world!")
}

PROCESS STATE CODES

Here are the different values that the s, stat and state output specifiers (header "STAT" or "S") will display to describe the state of a process.

CODE	Meaning
D	Uninterruptible sleep (usually IO)
R	Running or runnable (on run queue)
S	Interruptible sleep (waiting for an event to complete)
T	Stopped, either by a job control signal or because it is being traced.
W	paging (not valid since the 2.6.xx kernel)

OS X Screencast to animated GIF

This gist shows how to create a GIF screencast using only free OS X tools: QuickTime, ffmpeg, and gifsicle.

Instructions

To capture the video (filesize: 19MB), using the free "QuickTime Player" application:

Step 0:

Get Homebrew installed on your mac if you don't already have it

Step 1:

Install highlight. "brew install highlight". (This brings down Lua and Boost as well)

	private rule Macho
	{
	meta:
	description = "private rule to match Mach-O binaries (copied from Apple's XProtect)"
	condition:
	uint32(0) == 0xfeedface or uint32(0) == 0xcefaedfe or uint32(0) == 0xfeedfacf or uint32(0) == 0xcffaedfe or uint32(0) == 0xcafebabe or uint32(0) == 0xbebafeca
	}

	rule ZoomDaemon
	{

	/// An object that has some tear-down logic
	public protocol Disposable {
	func dispose()
	}


	/// An event provides a mechanism for raising notifications, together with some
	/// associated data. Multiple function handlers can be added, with each being invoked,
	/// with the event data, when the event is raised.
	public class Event<T> {

	#!/bin/bash
	#
	# Generates client and server certificates used to enable HTTPS
	# remote authentication to a Docker daemon.
	#
	# See http://docs.docker.com/articles/https/
	#
	# To start the Docker Daemon:
	#
	# sudo docker -d \

	CGFloat ScaleToAspectFitRectInRect(CGRect rfit, CGRect rtarget)
	{
	// first try to match width
	CGFloat s = CGRectGetWidth(rtarget) / CGRectGetWidth(rfit);
	// if we scale the height to make the widths equal, does it still fit?
	if (CGRectGetHeight(rfit) * s <= CGRectGetHeight(rtarget)) {
	return s;
	}
	// no, match height instead
	return CGRectGetHeight(rtarget) / CGRectGetHeight(rfit);