Groovy Code To Export Oracle Procedures

iteye_7258

于 2008-05-22 23:24:33 发布

阅读量102

点赞数

本文介绍了一段使用Groovy语言从Oracle数据库中导出存储过程的代码示例。通过Groovy的简洁语法实现了数据库连接及存储过程的批量导出，并将导出文件按日期组织存放。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

It's really a pleasure to code in groovy.

My first try:

import groovy.sql.Sql

sql = Sql.newInstance("jdbc:oracle:thin:@ip:port:db","usr","pwd","oracle.jdbc.driver.OracleDriver")

def base  = "/usr/"
def names = []
def today = new java.text.SimpleDateFormat("yyyyMMddHH").format(new Date())

sql.eachRow("select * from user_procedures",{
 names << it.object_name
 })

def cnt = names.size()
names.eachWithIndex({ prc, i ->
 def d = new File(base, "${today}")
 d.mkdir()

 println "${i+1}/$cnt exporting ${prc}.prc...."
 def f = new File(d, "${prc}.prc")
 f << "CREATE OR REPLACE "
 sql.eachRow("select text from user_source where name=? order by line", [prc], {
  f<< it.text 
  })
 })

println "done"