eirnym

GitHub Flavored Asciidoc (GFA)

eirnym

import re

from sqlalchemy.ext.compiler import compiles
from sqlalchemy.schema import CreateTable, DropTable, \
         CreateSequence, DropSequence, CreateIndex, DropIndex
from sqlalchemy.dialects.postgresql import DropEnumType

patches = (
    (CreateTable, 'visit_create_table', "^\s*CREATE TABLE", "CREATE TABLE IF NOT EXISTS"),
    (CreateIndex, 'visit_create_index', "^\s*CREATE INDEX", "CREATE INDEX IF NOT EXISTS"),

eirnym

Asciidoc cheatsheet for GitHub

eirnym

/**
 Generate a random date sometime between now and n days before day.
 
 Also, generate a random time to go with the day while we are at it.

 @param days date range between today and minimum date to generate
 @return random date
 @see http://stackoverflow.com/questions/10092468/how-do-you-generate-a-random-date-in-objective-c
 */

eirnym

from sqlalchemy_dump import dump_sql


def create_all_sql(metadata):
    return dump_sql(metadata.create_all, bind=True)()
    
def drop_all_sql(metadata):
    return dumpsql(metadata.drop_all, bind=True)()

eirnym

# based on: https://gist.github.com/exhuma/5935162#file-representable_base-py

class RepresentableBase(object):
    """ Add automatic __repr__ and __str__ to SQLAlchemy ORM models
    """
    def _repr_worker(self, attribute):
        mapper = object_mapper(self)
        items = [(p.key, getattr(self, p.key))
            for p in (
                mapper.get_property_by_column(c)

eirnym

/*
 * Copyright (c) 2015, Arseny Nasokin
 * All rights reserved.
 *
 * Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met:
 *
 * 1. Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer.
 *
 * 2. Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the
 * documentation and/or other materials provided with the distribution.