Skip to content

Instantly share code, notes, and snippets.

@tombohub
tombohub / df_insert_ignore.py
Created May 18, 2021
How to save pandas dataframe to MySQL with INSERT IGNORE
View df_insert_ignore.py
"""
This example is for inside the class.
First establish the connection into `self.conn`
"""
def _table_column_names(self, table: str) -> str:
"""
Get column names from database table
Parameters
@tombohub
tombohub / gist:5653577369b6a22ed7f46fc45a4fe7e2
Created Apr 18, 2021
Database migration using pandas and sqlalchemy
View gist:5653577369b6a22ed7f46fc45a4fe7e2
from sqlalchemy import create_engine
from sqlalchemy.sql.expression import select
db1_uri = 'db_uri_here'
db2_uri = 'db_uri_here'
db1_engine = create_engine(db1_uri)
db2_engine = create_engine(db2_uri)
db1_conn = db1_engine.connect()
@tombohub
tombohub / proven.js
Created Jan 2, 2021
Proven React packages
View proven.js
// axios for http requests
npm install axios
// typescript
npm install typescript @types/node @types/react
@tombohub
tombohub / python_packages.py
Last active Dec 30, 2020
Good python packages to start a project
View python_packages.py
# environment
pip install pipenv
# development
pipenv install devtool
# better REPL
pipenv install ipython
# reading .env variables
View django-install-packages.py
# upgrade pip
pipenv install -U pip
# django
pipenv install django
# environment variables
pipenv install python-decouple
# better shell
View django-rest-deployment.py
## DJANGO REST React Github pages settings
## With Cookies Session authentication
# create Procfile with content:
web: gunicorn server.wsgi
# heroku setup database
pip install dj-database-url
DATABASES['default'] = dj_database_url.config(
conn_max_age=600, ssl_require=True)
View sqlite-postgres-heroku-django.py
# Importing Sqlite to Postgres Heroku Django
python manage.py dumpdata --exclude=contenttypes --exclude=auth.permission > datadump.json
# Change settings.py to your mysql
# Make sure you can connect on your mysql (permissions,etc)
python manage.py migrate
#Exclude contentype data with this snippet in shell
@tombohub
tombohub / tailwind-setup.js
Last active Oct 19, 2020
Tailwindcss installation and setup script for create-react-app
View tailwind-setup.js
/**
* Tailwind installation and setup script
*
* STEPS:
* Installs tailwindcss
* creates src/assets/css folder to hold main.css and tailwind.css
* initializes full tailwind configuration file
* inserts new package.json scripts commands
*
* NOTE: you have to import main.css in src/index.js
@tombohub
tombohub / es6-import-cheat-sheet.md
Created Oct 15, 2020 — forked from samueljseay/es6-import-cheat-sheet.md
ES6 exports / imports cheat sheet
View es6-import-cheat-sheet.md
// default exports
export default 42;
export default {};
export default [];
export default (1 + 2);
export default foo;
export default function () {}
export default class {}
export default function foo () {}
@tombohub
tombohub / git-push.sh
Created Oct 5, 2020
Git add commit and push all in one go
View git-push.sh
#!/bin/bash
git add .
git commit -m "$1"
git push
## usage:
## ./git-push.sh 'your commit comment here'