rodrigoespinozadev

<?php
/*
* Mysql database class - only one connection alowed
*/
<?php

    class DB {
      private $connection;
      private static $_instance;

rodrigoespinozadev

'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

rodrigoespinozadev

{
    "env": {
        "browser": true,
        "commonjs": true,
        "es6": true,
        "node": true
    },
    "parserOptions": {
        "ecmaFeatures": {
            "jsx": true

rodrigoespinozadev

/* This is a small sampling of the various approaches to media queries. The 
   point is: they're all over the board. Part of the "issue" (if you can call
   it that) may be due to the intended audience of each site/framework. Another
   may be that it's really difficult to test for a lot of different devices.
   Regardless, it would be really nice if there was standard baseline that 
   could be used as a starting point for maximum compatibility and coverage. */

/* ==========================================================================
   Frameworks
   ========================================================================== */