Lua读取文件

最新推荐文章于 2023-05-31 10:24:43 发布

原创最新推荐文章于 2023-05-31 10:24:43 发布 · 3.8k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#lua #list #file #function #c

Lua 专栏收录该内容

3 篇文章

订阅专栏

本文介绍了一个用于合并多个SQL文件的Lua脚本实现。该脚本通过定义一系列实用函数来读取并写入文件，最终将指定目录下的所有SQL文件内容合并到一个输出文件中。适用于数据库初始化脚本的整合。

--cat sql


--fileName = "./ECNS/CGPV100R006C01SPC300/Init_ch.sql"
destFile = "cat.sql"

BUFFSIZE = 1024

files = {
		  ddl = "Table.sql",
		  cns = "./ECNS/CGPV100R006C01SPC300/Init_ch.sql",
		  cgp = "./EME/V100R001C00B100/Init_ch.sql",
		  nodeb = "./ENODEB/eBBU530V100R001C00IDC00/Init_ch.sql"
		}
fileList = {
		 "Table.sql",
		  "./ECNS/CGPV100R006C01SPC300/Init_ch.sql",
		  "./EME/V100R001C00B100/Init_ch.sql",
		  "./ENODEB/eBBU530V100R001C00IDC00/Init_ch.sql"
		}



dfile = assert(io.open("cat.sql","w"))


------------------------write file-------------------
do
function writeFile(str)

   local dfile = assert(io.open("cat.sql","w"))

			dfile:write(str)

			dfile:close();
end

end

----------read list_--------------------------

do

function list_iter(t)
   local i = 0
   local n = table.getn(t)
   return function ()
     i = i+1
	 if i<= n then return t[i] end
	end
end

end

-------------read file---------------------------

do

function readFile(fileName)


	local file = assert(io.open(fileName,"r"))


	while true do

		local lines, bytes = file:read(BUFFSIZE,"*line")

		if not bytes then break end

		--io.write(string.format(bytes))
		--local str = string.format(string.byte(bytes))

		 --print(lines)

		 dfile:write(lines)


    end
    file:close()
end

end

-------------------- clal function------------


for element in list_iter(fileList) do

	 --print(element)

	 readFile(element)

end
dfile:close()