def database_feild_varchar_trans(in_feild):
'''
transfer the feild if varchar then 3times lang else no transfer
'''
feild_split = in_feild.split(' ')
is_varchar = feild_split[1].find('VARCHAR')
if is_varchar >= 0 :
num_varchar = feild_split[1].replace('VARCHAR','').replace('(','').replace(')','')
print (num_varchar)
3_num_varchar = num_varchar*3
feild_split[1] = feild_split[1].replace(str(num_varchar),str(3_num_varchar))
return feild_split
else:
print ('The feild type is not varchar')
return feild_split
>>> runfile('E:/procedure/python/projects/others/table_test.py', wdir='E:/procedure/python/projects/others')
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "D:\Python33\lib\site-packages\spyderlib\widgets\externalshell\sitecustomize.py", line 699, in runfile
execfile(filename, namespace)
File "D:\Python33\lib\site-packages\spyderlib\widgets\externalshell\sitecustomize.py", line 88, in execfile
exec(compile(open(filename, 'rb').read(), filename, 'exec'), namespace)
File "E:/procedure/python/projects/others/table_test.py", line 20
3_num_varchar = int(num_varchar)*3
^
SyntaxError: invalid syntax
将变量3_num_varchar改为num_varchar_3,运行成功,程序改为如下:
import os
import sys
str1='aaa varchar(10)'
def database_feild_varchar_trans(in_feild):
'''
transfer the feild if varchar then 3times lang else no transfer
'''
feild_split = in_feild.split(' ')
is_varchar = feild_split[1].find('VARCHAR')
if is_varchar >= 0 :
num_varchar = feild_split[1].replace('VARCHAR','').replace('(','').replace(')','')
print (num_varchar)
num_varchar_3 = num_varchar*3
feild_split[1] = feild_split[1].replace(str(num_varchar),str(num_varchar_3))
return feild_split
else:
print ('The feild type is not varchar')
return feild_split
print (database_feild_varchar_trans(str1))
>>> runfile('E:/procedure/python/projects/others/table_test.py', wdir='E:/procedure/python/projects/others')
The feild type is not varchar
['aaa', 'varchar(10)']
机械节能产品生产企业官网模板...
大气智能家居家具装修装饰类企业通用网站模板...
礼品公司网站模板
宽屏简约大气婚纱摄影影楼模板...
蓝白WAP手机综合医院类整站源码(独立后台)...苏ICP备2024110244号-2 苏公网安备32050702011978号 增值电信业务经营许可证编号:苏B2-20251499 | Copyright 2018 - 2025 源码网商城 (www.ymwmall.com) 版权所有