替换SQL文件中的表结构
2008-06-12添加评论
#!/bin/gawk -f # 替换SQL文件中的表结构 # RUN: # gawk -f sql.awk some_database.sql BEGIN{ RS = “–” FS = “\n” outf = “some_database.add.sql” print(“\n”) > outf } length($0)>0 || match($0, “foo”) || match($0, “CREATE TABLE”){ print( rep_str($0) “\n”) >> outf } function rep_str(row) { gsub(“fooes”, “bars”, row); gsub(“Fooes”, “Bars”, row); gsub(“foo”, “bar”, row); gsub(“Foo”, “Bar”, row); gsub(“FOO”, [...]
阅读全文:替换SQL文件中的表结构