Dorin Claudiu Moldoveanu DorinMol

Scrapy commands & code

This goes with the Traversy Media Scrapy tutorial on YouTube

Setup

pip install scrapy

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

VSCode Shortcuts

List of helpful shortcuts for faster coding

If you have any other helpful shortcuts, feel free to add in the comments of this gist :)

Official List of all commands

Windows
Mac

Wordpress & Docker

This file will setup Wordpress, MySQL & PHPMyAdmin with a single command. Add the code below to a file called "docker-compose.yaml" and run the command

$ docker-compose up -d

# To Tear Down
$ docker-compose down --volumes

Pipenv Cheat Sheet

Install pipenv

pip3 install pipenv

Activate

pipenv shell

GENERATORS:

Text Content Generator - http://www.lipsum.com
Favicon Generator - http://tools.dynamicdrive.com/favicon
Data Generator - https://mockaroo.com/
Mobile Mockup Generator - https://mockuphone.com
Logo Generator - https://www.logaster.com
UUID Generator - https://www.uuidgenerator.net/
Hash Generator - https://passwordsgenerator.net/sha256-hash-generator/
Ultimate Code Generator - https://webcode.tools/

SSH Cheat Sheet

This sheet goes along with this SSH YouTube tutorial

Login via SSH with password (LOCAL SERVER)

$ ssh brad@192.168.1.29

Create folder, file, install Apache (Just messing around)

$ mkdir test

$ cd test

	// Construct Single Node
	class Node {
	constructor(data, next = null) {
	this.data = data;
	this.next = next;
	}
	}

	// Create/Get/Remove Nodes From Linked List
	class LinkedList {

	[
	{
	"abbr": "AL",
	"name": "Alabama",
	"capital": "Montgomery",
	"lat": "32.361538",
	"long": "-86.279118"
	},
	{
	"abbr": "AK",

	# GET VERSION
	yarn -v (or --version)

	# GET HELP
	yarn help

	# CREATE PACKAGE.JSON
	yarn init
	yarn init -y // Use defaults