Skip to content

Instantly share code, notes, and snippets.

@tombohub
tombohub / df_insert_ignore.py
Created May 18, 2021 19:54
How to save pandas dataframe to MySQL with INSERT IGNORE
"""
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 April 18, 2021 13:12
Database migration using pandas and sqlalchemy
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 / python_packages.py
Last active December 30, 2020 19:05
Good python packages to start a project
# environment
pip install pipenv
# development
pipenv install devtool
# better REPL
pipenv install ipython
# reading .env variables
# upgrade pip
pip install -U pip
# django
pip install django
# environment variables
pip install python-decouple
# better shell
## 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)
# 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 October 19, 2020 23:23
Tailwindcss installation and setup script for create-react-app
/**
* 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 October 15, 2020 20:21 — forked from samueljseay/es6-import-cheat-sheet.md
ES6 exports / imports cheat sheet
// 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 October 5, 2020 21:58
Git add commit and push all in one go
#!/bin/bash
git add .
git commit -m "$1"
git push
## usage:
## ./git-push.sh 'your commit comment here'
@tombohub
tombohub / imagewiththumbnails_updateable.py
Created August 7, 2020 04:47 — forked from valberg/imagewiththumbnails_updateable.py
Django create thumbnail form ImageField and save in a different ImageField - now with updating!
# Extension of http://www.yilmazhuseyin.com/blog/dev/create-thumbnails-imagefield-django/
# Note: image_folder and thumbnail_folder are both a callable (ie. a lambda that does a '/'.join())
class Image(Media):
image = models.ImageField(
upload_to=image_folder
)
thumbnail = models.ImageField(