DimitrK

'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

DimitrK

/**
* Copyright 2017 dimitrk
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
*    http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software

DimitrK

function numberOfCarryOperations(x,y) {
    var xs = x.toString();
    var ys = y.toString();
    var cary = 0;
    var operations=0;
    var xCurrent;
    var yCurrent;

    while (xs.substr(xs.length-1) || ys.substr(ys.length-1) ) {
        yCurrent =ys.substr(ys.length-1);

DimitrK

function toBase(number, base) {
    if (base <2) {
        throw new Error("Base has to be greater than 2");
    }
    var basedNumberArray = [];
    var divider = Math.floor(number / base);
    var basedNumber = number % base;
    var basedCode = getAsciiCap(basedNumber);
    
    basedNumberArray.push(basedCode || basedNumber);

DimitrK

UrlSearchParams

Manipulate URL GET parameters and hash.

Similar to URLSearchParams.

In addition:

• Compatible with >IE5

DimitrK

// Transforms a property of object which includes dots to nested property as follows
// object = {};
// object["firstlevelprop.secondlevelprop"] = "something"  =to=> object["firstlevelprop"]["secondlevelprop"] = "something"
(function () {
    var enableExpand = function () {
        //We dont want the method to appear in the object and mess with the rest of our object's properties
        Object.defineProperty(this, "expand", {
            enumerable: false, // Not visible
            configurable: false, // Not configurable
            value: function () {

DimitrK

:: Brackets Extensions Updater
:: Dimitris Kyriazopoulos. jim.feedback at Google mail dot com
:: MIT License. For more info visit http://opensource.org/licenses/MIT
@echo off

call:iterateFolders >> updatelog.xml 
echo.&goto:eof
 
:iterateFolders
set "extensionsDir=%~dp0"