A simple function to upsert something atomically into MySQL
def upsert(val1, val2, **kwargs):
"""upsert val1-val2 pair into mysql and return the pk"""
from sqlalchemy.dialects.mysql import insert
from sqlalchemy.sql.expression import func
# this val1-val2 pair should have UNIQUE KEY……