yyscamper

CREATE OR REPLACE FUNCTION create_city_partition(schema_name text, parent_table_name text, city_id int)
  RETURNS text AS
$func$
DECLARE
	partition_table_name text;
BEGIN
	partition_table_name := parent_table_name || '_' || city_id::text;
EXECUTE format('
   CREATE TABLE %I.%I PARTITION OF %I FOR VALUES IN (%L)
   ', schema_name, partition_table_name, parent_table_name, city_id);

yyscamper

#!/usr/bin/env bash
#   Use this script to test if a given TCP host/port are available

# This is script is download from
# https://github.com/vishnubob/wait-for-it/blob/9995b721327eac7a88f0dce314ea074d5169634f/wait-for-it.sh

# Modify by on 2019-1-7, with support for MACOS
# solution is found from:
# - https://github.com/vishnubob/wait-for-it/issues/13
# - https://stackoverflow.com/questions/3504945/timeout-command-on-mac-os-x

yyscamper

from sqlalchemy import create_engine

engine = create_engine('postgresql://user:passwd@127.0.0.1:5432/dbname')
engine.dialect.identifier_preparer.quote('table')
engine.dialect.identifier_preparer.quote_identifier('table')

yyscamper

#!/usr/bin/env python
import base64
import codecs
import json
import logging
import os
import sys
import uuid
from datetime import datetime