#!/usr/bin/python3.4
-# -*- coding: iso-8859-15 -*-
-import types
from sqlalchemy import schema
from sqlalchemy.engine import create_engine
from sqlalchemy.sql import select
def connect():
engine = create_engine('mysql://philipp@localhost:3306/philipp_winterrodeln_wiki?charset=utf8&use_unicode=1')
- # engine = create_engine('mysql://philipp@localhost:3306/philipp_winterrodeln_wiki?charset=utf8&use_unicode=0')
connection = engine.connect()
- transaction = connection.begin()
+ connection.begin()
return connection
categorylinks = connect().execute(select([tcategorylinks], tcategorylinks.c.cl_from == 609)).first()
assert type(categorylinks.cl_to) == str
assert type(categorylinks.cl_sortkey) == str
- assert categorylinks.cl_sortkey == 'ALT BÄRNBAD'
-
+ assert categorylinks.cl_sortkey == 'ALT BÄRNBAD'