import MySQLdb

def addClum(sql):
	try:
		print "execute qury %s" %sql
		with MySQLdb.connect(host='localhost', user='root', passwd='root', db="test") as cu:
			print "Conncected"
			cu.execute('set session innodb_strict_mode=OFF')
			cu.execute(sql)
			print 'done'
	except Exception, e:
		print e

SQL_SCHEMA='test'
DB_HOST='localhost'
from sqlalchemy.engine import create_engine
from sqlalchemy.pool import NullPool
from sqlalchemy.engine.url import URL

def function(sql):
	try:
		print "execute qury %s" %sql
		engine = create_engine(URL('mysql', host='localhost', database='test', username='root', password='root'), pool_size=5, max_overflow=5, echo=False, pool_recycle=1800)
		with engine.connect() as cu:
			print "Conncected"
			cu.execute('set session innodb_strict_mode=OFF')
			cu.execute(sql)
			print 'done'
	except Exception, e:
		print "Yes"
		print e

for x in xrange(195,196):
	print x
	sql = 'alter table test2 add test{i} varchar(255);'.format(i=x)
	function(sql)