jackie1santana

Django 2.x Cheat Sheet

Creating a virtual environment

We need to create a virtual env for our app to run in: More Here Run this command in whatever folder you want to create your venv folder

python -m venv ./venv

jackie1santana

1) npm install -g firebase-tools 
2) firebase login
3) firebase init hosting
4) pick folder
5) firebase serve (if u want to see how the site looks in dev)
6) firebase deploy

jackie1santana

db.collection('cafes').add({
    name: 'jack',
    city: 'bronx'
})

jackie1santana

const resolvers = {
  Query: {
    getCurrentGlobalCases: () => currentGlobalCases(),

    getGlobalCasesByDate(parent, args) {
      //id: Cases By Date

      return globalCasesByDate(args.id);
    },
    // id: Cases By Country Name

jackie1santana

const express = require('express')
const graphqlHTTP = require('express-graphql')
const schema = require('./schema/schema')
 
 const app = express()

 app.use('/graphql', graphqlHTTP({
    schema,
    graphiql: true
 }))

jackie1santana

Install MySQL on macOS Sierra

This procedure explains how to install MySQL using Homebrew on macOS Sierra 10.12

Install Homebrew

• Installing Homebrew is effortless, open Terminal and enter :
  $ /usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"
• Note: Homebrew will download and install Command Line Tools for Xcode 8.0 as part of the installation process.

Install MySQL

At this time of writing, Homebrew has MySQL version 5.7.15 as default formulae in its main repository :

jackie1santana

MySQL Cheat Sheet

Help with SQL commands to interact with a MySQL database

MySQL Locations

• Mac /usr/local/mysql/bin
• Windows /Program Files/MySQL/MySQL version/bin
• Xampp /xampp/mysql/bin

Add mysql to your PATH

jackie1santana

MongoDB Cheat Sheet

Show All Databases

show dbs

Show Current Database