Synnefo

logger = logging.getLogger(__name__)

def create_tables(engine):

    metadata = MetaData()

    columns = []

            candidate = get_random_word(length=l, alphabet=public_url_alphabet)

            if self.public_path(candidate) is None:

                return candidate

    def public_set(self, path, public_security, public_url_alphabet):

        s = select([self.public.c.public_id])

    def public_get(self, path):

        s = select([self.public.c.url])

        s = s.where(and_(self.public.c.path == path,

        r = self.conn.execute(s)

        row = r.fetchone()

        r.close()

        s = select([self.public.c.path, self.public.c.url])

        s = s.where(self.public.c.path.like(

            self.escape_like(prefix) + '%', escape=ESCAPE_CHAR))

        r = self.conn.execute(s)

        rows = r.fetchall()

        r.close()

    def public_path(self, public):

        s = select([self.public.c.path])

        s = s.where(and_(self.public.c.url == public,

        r = self.conn.execute(s)

        row = r.fetchone()

        r.close()