# Copyright 2012 Svenne Krap
#
# this script renumbers files in the format nnnn_XXXXXXX.sql ,
# where nnnn is a series of digits (0-9) and XXXX is any string
#
# first parameter is the first number to renumber
# second paramter is the amount to renumber it (negatives work too)
# third parameter decides between dry-run (0) and actual doing work (1)
#
# License: ASL 2.0

import os
import sys
if len(sys.argv) < 4: 
	print "Renumber.py, Svenne Krap 2012"
	print
	print "renumber.py <first-renumber> <rename-offset> <do-actual-work>"
	sys.exit()

renumber_from = int(sys.argv[1])
renumber_amount = int(sys.argv[2])
doit = int(sys.argv[3])


files = os.listdir('.')
files.sort()
if renumber_amount > 0: files.reverse()

for file in files:
	if not file.endswith(".sql"): continue
	if file.find("_") == -1: continue
	numstr = file.split("_")[0]
	digits = len(numstr)
	numint = int(numstr)
	if numint < renumber_from: continue 
	newname = file.replace(numstr + "_", (("%0" + str(digits) + "i") % (numint + renumber_amount)) + "_" )
	if doit == 1:
		os.rename(file,newname)
	else:
		print file, "=>",  newname