替换SQL文件中的表结构

#!/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", "BAR", row);
  return row
}

No related posts.

以上关联文章由 Yet Another Related Posts Plugin 提供支持。

Win32上安装MagentoWindows下的Nginx+PHP+MySQL环境