Entry 3084

Update DB

Submitted by Singletone on Jan. 24, 2010 at 2:53 p.m.
Language: Python. Code size: 383 bytes.

h=popen("svnversion")
rev=h.read()

p = re.compile(r"\d+:(?P<REV_NO>\d+)M");
m = p.search(rev)
revNo=m.group( "REV_NO" )

os.system("svn log -v -r " + revNo + " >> log.txt")

p=re.compile(r"\w+/(?P<SCRIPT>scs_\w+\.sql)")

for line in open('log.txt','r').readlines():
	m = p.search(line)
	fileName = m.group("SCRIPT")
	os.system("sqlcmd -E -S localhost -i " + fileName )

This snippet took 0.00 seconds to highlight.

Back to the Entry List or Home.

Delete this entry (admin only).