sql建表脚本转oracle,Oracle表结构转换SqlSERVER表结构 脚本

def getNewLine(self,oldLine):

if oldLine.strip().startswith('create table'):

tablename = oldLine.strip().split('.')[1].strip()

newline = 'create table ' + tablename + oldLine[-1]

else:

if oldLine.strip().startswith('('):

newline = oldLine

elif oldLine.startswith(')'):

newline = 'null' + oldLine[-1] + oldLine + oldLine[-1]

self._start = 'false'

else:

strList = oldLine.split(' ')

newline = ''

for string in strList:

if string == '':

newline += ' '

elif string.strip().upper().startswith('DEFAULT'):

continue

elif (string.upper() == 'NOT') or (string.upper() == 'NULL'):

continue

elif string.upper().startswith('VARCHAR2'):

newline += 'varchar(' + str(int(string[string.find('(')+1:string.find(')')])*3) + ') '

elif (string.upper() == 'NUMBER') or (string.upper() == 'DATE') or (string.upper() == 'DATETIME') or (string.upper() == 'TIMESTAMP(6)') or (string.upper() == 'INTEGER'):

newline += 'varchar(100) '

elif ((string.upper().startswith('NUMBER')) or (string.upper().startswith('DATE')) or (string.upper().startswith('DATETIME')) or (string.upper().startswith('TIMESTAMP(6)')) or (string.upper().startswith('INTEGER'))) and (string[-1] == '\n'):

newline += 'varchar(100) '

elif (string.upper().startswith('NUMBER,')) or (string.upper().startswith('DATE,')) or (string.upper().startswith('DATETIME,')) or (string.upper().startswith('TIMESTAMP(6),')) or ((string.upper().startswith('NUMBER(')) and (',' in string)) or ((string.upper().startswith('NUMBER(')) and (',' in string)) or (string.upper().startswith('INTEGER,')):

newline += 'varchar(100) null'

elif string.upper().startswith('NUMBER('):

newline += 'varchar(100)'

else:

i = 0

while (1 == 1):

if strList[i] == '':

i += 1

else:

filedName=strList[i]

break

if string == filedName:

newline = string + newline

if ',' in string:

newline += ' null'+string[string.rfind(','):]

return newline

def createNewFileFromOldFileList(self):

readFileDir  = self.readInitFile('readFiledir')

writeFileDir = self.readInitFile('writeFiledir')

sysType      = self.readInitFile('sysType')

if sysType == '1':

sepStr = '/'

else:

sepStr = '\\'

listfile=os.listdir(readFileDir)

for file in listfile:

start = 'false'

writeFile = open(writeFileDir+sepStr+file, 'w')

readData = open(readFileDir+sepStr+file,'r')

for line in readData:

if line.lower().startswith('create table'):

self._start = 'true'

if self._start=='true':

newLine = self.getNewLine(line)

writeFile.write(newLine)

readData.close()

writeFile.close()

app = Application()

app.createNewFileFromOldFileList()

[root@db01 ~]#

[root@yoon ~]#/usr/bin/pythonsql.py