convert ddl from sqlserver to mysql

convert_ddl_from_sqlserver_to_mysql.rb

def convertLine(line)
	# 可読性のため一次変数に受ける
	result = line.gsub("]","").gsub("[","").gsub("UNIQUEIDENTIFIER","NVARCHAR (38)")
	result = result.gsub("NVARCHAR \(MAX\)","NVARCHAR \(256\)")
	result.gsub("DATETIMEOFFSET (7)","TIMESTAMP").gsub("sys.geography","geometry")
end

def convertDDL(path)
	@inDDL = false
	@isGEO = false
	@isINDEX = false
	File.open(path, 'r:utf-8') do |f|
		f.each_line do |line|
			if line.include?("CREATE")
				@isDDL = true
			end
			if line.include?("INDEX")
				@isINDEX = true
			end
			# 一次変換
			if @isDDL
				line = convertLine(line)
				# GEO情報があるか否か,あればstorage engineをMYISAMで出力する
				if line.include?("geometry")
					@isGEO = true
				end

				if @isINDEX
					line = line.gsub("CLUSTERED","")
				end

				# 末尾か否か
				if line.include?(");") && @isINDEX == false
					if @isGEO
						puts line.gsub(");",") ENGINE = MYISAM;")
					else
						puts line.gsub(");",") ENGINE = INNODB;")
					end
					@isDDL = false
					@isGEO = false
				else
					puts line
				end			
			end
		end
	end
end

convertDDL(ARGV[0])