Jackie Santana jackie1santana

## mongodb_cheat_sheet.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                jackie1santana
                / mongodb_cheat_sheet.md
            
            
              Created
              April 16, 2020 20:47
                — forked from bradtraversy/mongodb_cheat_sheet.md
            
              
                MongoDB Cheat Sheet
              
          
    MongoDB Cheat Sheet

Show All Databases

show dbs

Show Current Database


## mysql_cheat_sheet.md

      
              1 file
            
          
              0 forks
            
          
              1 comment
            
          
              1 star
            
          
                jackie1santana
                / mysql_cheat_sheet.md
            
            
              Created
              April 20, 2020 16:07
                — forked from bradtraversy/mysql_cheat_sheet.md
            
              
                MySQL Cheat Sheet
              
          
    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


## MySQL_macOS_Sierra.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                jackie1santana
                / MySQL_macOS_Sierra.md
            
            
              Created
              April 20, 2020 23:39
                — forked from nrollr/MySQL_macOS_Sierra.md
            
              
                Install MySQL on Sierra using Homebrew
              
          
    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 :

  
## Express-GraphQL (app.js)
const express = require('express')
const graphqlHTTP = require('express-graphql')
const schema = require('./schema/schema')

 const app = express()

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

## Apollo Client & Server Set up ,js
const resolvers = {
  Query: {
    getCurrentGlobalCases: () => currentGlobalCases(),

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

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

## Add Data from Firebase app.js
db.collection('cafes').add({
    name: 'jack',
    city: 'bronx'
})

## Firebase Hosting Client Set up
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

## django_cheat_sheet.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                jackie1santana
                / django_cheat_sheet.md
            
            
              Created
              June 18, 2020 15:49
                — forked from bradtraversy/django_cheat_sheet.md
            
              
                Django command cheat sheet
              
          
    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


## python_mysql.py
import mysql.connector
from mysql.connector import errorcode

config = {
    'user': 'root',
    'password': '',
    'host': 'localhost',
    'database': 'acme'
}

## python_heroku.MD

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                jackie1santana
                / python_heroku.MD
            
            
              Created
              June 18, 2020 15:52
                — forked from bradtraversy/python_heroku.MD
            
              
                Python & Postgres Heroku Deployment
              
          
    Python Heroku Deployment


Steps to create a postgres database and deply a Python app to Heroku

Install guinicorn locally

pipenv install gunicorn
or
pip install gunicorn
	const express = require('express')
	const graphqlHTTP = require('express-graphql')
	const schema = require('./schema/schema')

	const app = express()

	app.use('/graphql', graphqlHTTP({
	schema,
	graphiql: true
	}))
	const resolvers = {
	Query: {
	getCurrentGlobalCases: () => currentGlobalCases(),

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

	return globalCasesByDate(args.id);
	},
	// id: Cases By Country Name
	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
	import mysql.connector
	from mysql.connector import errorcode

	config = {
	'user': 'root',
	'password': '',
	'host': 'localhost',
	'database': 'acme'
	}