Skip to content

Instantly share code, notes, and snippets.

@roganjoshp
roganjoshp / test_postgres
Created June 5, 2020 13:17
Confirming that tuple can be used in LIKE query for postgres
from flask import Flask, render_template_string
from flask_sqlalchemy import SQLAlchemy
app = Flask('__name__')
app.config['SQLALCHEMY_DATABASE_URI'] = 'postgresql+psycopg2://postgres:######@127.0.0.1/so_test'
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
app.config['SESSION_TYPE'] = 'sqlalchemy'
@roganjoshp
roganjoshp / join_without_loop
Created August 21, 2019 20:15
How to join without loop
from sqlalchemy import (create_engine, and_, Column, Integer, String,
ForeignKey, Float)
from sqlalchemy.orm import relationship, sessionmaker
from sqlalchemy.ext.declarative import declarative_base
import random
import pandas as pd
@roganjoshp
roganjoshp / gist:3929be1840566e88d7c8e13d3dd03c9e
Created August 9, 2019 11:26
Clear Flask-WTF after AJAX submission
# =============================================================================
# routes.py
# =============================================================================
@bp.route('/add_child_product', methods=['POST'])
def add_child_product():
"""
Handle form validation. If form is invalid, re-render form with validation
errors. If the form is valid, update product spec table, close modal and
reset form.
"""