david-mart

SELECT Domain from bill_items group by Domain;

select
  Domain,
  Product_Name,
  sum(Amount) as total,
  DATEPART(Month, Start_Date) as Month,
  DATEPART(Year, Start_Date) as Year
from bill_items
group by

david-mart

[
  {
    "Domain": "trademotion.com"
  },
  {
    "Domain": "tuilifestyle.com"
  },
  {
    "Domain": "selectiveps.com"
  },

david-mart

#!/bin/bash
rm -rf $PWD/$1
mkdir $PWD/$1

var1=$1

name=`echo -n "${var1}" | sed -e 's/-/ /g' -e 's/\b\(.\)/\u\1/g' -e 's/ //g' `

echo "import React from 'react';
import './"$1".scss';

david-mart

#!/bin/bash
rm -rf $PWD/$1
mkdir $PWD/$1

var1=$1

name=`echo -n "${var1}" | sed -e 's/-/ /g' -e 's/\b\(.\)/\u\1/g' -e 's/ //g' `

echo "import React, { Component } from 'react';
import './"$1".scss';

david-mart

await UsersDb.models.user.findOne({
  where: { id: 1 },
  include: {
    model: UsersDb.models.order,
    include: {
      model: ProductsDb.models.product,
      on: {
        order_id: Sequelize.literal("`orders`.`id` = `orders->products`.`order_id`") 
        // you can always refer the generated query to get  
        // the exact column names for the literal string

david-mart

const product = await UsersDb.models.order.findOne({
  where: { id: 1 },
  include: [
    {
      model: ProductsDb.models.product,
      on: {
        // this is where magic happens
        order_id: Sequelize.literal("`order`.`id` = `products`.`products`.`order_id`") 
      }
    }

david-mart

// models/product.js

...
    {
      tableName: "product",
      timestamps: false,
      schema: "products" // add this line
    }
...

david-mart

...
const ProductsDb = new Sequelize(config.productsDatabaseName, config.username, config.password, config.options);
ProductsDb.dialect.supports.schemas = true; // add this line

ProductsDb.import("models/product.js");
...

david-mart

await UsersDb.models.order.findOne({ 
  where: { id: 1 }, 
  include: [ProductsDb.models.product] 
});

// SequelizeDatabaseError: Table 'users_and_orders.product' doesn't exist

david-mart

UsersDb.models.user.hasMany(UsersDb.models.order, { foreignKey: "user_id" });
UsersDb.models.order.hasMany(ProductsDb.models.product, { foreignKey: "order_id" });