def turn_want(want): local_db = db.get_dev_blue_db('blue') cursor = local_db.cursor() want_arr = str(want).split("+") want_str = '' for w in want_arr: want_str += "'" + w + "'," want_str = want_str[0:len(want_str) - 1] want_sql = '''select code from common_config where name in (%s) ''' % want_str cursor.execute(want_sql) codes = cursor.fetchall() return codes
def create(): blue_db = db.get_dev_blue_db("blue_tag") cursor = blue_db.cursor() start = 1 end = 99 while start <= end: try: rsql = sql % start cursor.execute(rsql) except Exception, e: print " Exception:", e start += 1