Skip to content

Instantly share code, notes, and snippets.

@vestel
vestel / gist:9837acc6cff8bf9f761d
Created September 12, 2014 10:47
Header in Flask
from flask import Flask, request, Response
import unittest
app = Flask(__name__)
@app.route('/')
def index():
response = Response("Done", 200)
for k,v in request.headers:
response.headers.add(k,v)
@vestel
vestel / crazyQuery.sql
Last active November 7, 2017 23:36
MySQL specific adventure about table creation
-- RUN ONLY ONCE TO DEPLOY PROCEDURE & FUNCTION INTO DB
DELIMITER $$
-- FUNCTION TAKES STRING, DELIMITER AND POSITION
-- AND RETURNS SUBSTRING OF DEFINED POSITION BY DELIMITERS
-- IF DELIMITER NOT FOUND OR OUT OF RANGE WILL RETURN '' (empty string)
-- Example: SPLIT_STR('ABRA / SCHWABRA / KADABRA',' / ',3) returns 'KADABRA'
--
-- IF DELIMITER NOT FOUND OR OUT OF RANGE WILL RETURN '' (empty string)
-- Example: SPLIT_STR('-/-',',',1) returns ''