def checkEbay(sendNum):
mySendList = []
ebaySend = False
database.init()
d = database.dictfetchone("SELECT * FROM bulk.sends WHERE id = %s", sendNum)
if not d:
print "FATAL ERROR: Send %s does not exist\n" % sendNum
sys.exit(1)
if d['cancelled']:
print "Send %s has already been cancelled\n" % sendNum
sys.exit(1)
if not(d['future']) and not(args.FORCE):
print "Send %s is already done or is currently sending, use -F to override this check\n" % sendNum
sys.exit(1)
else:
i = "%(cmd)s" % d
mySendList = i.split(' ')
for item in mySendList:
if item == "ebay":
ebaySend = True
break;
if ebaySend:
return True
else:
return False
def getSendTime(sendNum):
database.init()
sendTime = ""
d = database.dictfetchone("SELECT * FROM bulk.sends WHERE id = %s", sendNum)
sendTime = datetime.fromtimestamp(d['when'])
compareTime = int(sendTime.strftime('%s'))
currentTime = int(datetime.now().strftime('%s'))
if compareTime < currentTime:
print "Error: sendTime %s is in the past. Scheduling for 15minutes in the future.\n" % datetime.fromtimestamp(compareTime).strftime('%H:%M %m/%d/%Y')
sendTime = currentTime + 900
else:
sendTime = compareTime
print "Your send time is: %s\n" % datetime.fromtimestamp(sendTime).strftime('%H:%M %m/%d/%Y')
return datetime.fromtimestamp(sendTime).strftime('%H:%M %m/%d/%Y')
def main():
parser = argparse.ArgumentParser()
parser.add_argument(
'-l',
"--list",
metavar="COUNT",
help="List all versioned [file]s; default list last 10",
default="10")
parser.add_argument('-d',
"--diff",
help="Run versioned [file] through diff",
action="store_true")
parser.add_argument('-c',
"--diffc",
help="Run versioned [file] through diffc",
action="store_true")
parser.add_argument('-v',
"--vimdiff",
help="Run versioned [file] through vimdiff",
action="store_true")
parser.add_argument('-s',
"--search",
metavar="REGEX",
help="Search for pattern in versioned [file]")
parser.add_argument('path', help="Path")
parser.add_argument(
'file',
help=
'Versioned file; input \'list\' to see full list of versioned files')
parser.add_argument(
'get',
help=
'Get versioned file from 1=last to N edit; 0=current also strips id\'s. N:N will compare any two versions',
nargs='?')
if not sys.argv[1:]:
parser.print_help()
sys.exit(1)
parsed = parser.parse_args(sys.argv[1:])
survey_path = misc.expandSurveyPath(parsed.path, log=False)
#os.chdir(hstub.previousDirectory)
vc_file = parsed.file
vc_get = []
if parsed.get:
for x in parsed.get.split(":")[:2]:
if x.isdigit():
vc_get.append(int(x))
if len(vc_get) == 1:
vc_get.append(vc_get[0] + 1)
vc_list = 10 if not parsed.list.isdigit() else int(parsed.list)
vc_diff = parsed.diff
vc_diffc = parsed.diffc
vc_vimdiff = parsed.vimdiff
vc_search = parsed.search
basedir = survey_path.split('/')[0]
if vc_file != 'list':
vc_path = "%s/%s/%s.%s" % (VC_DIR, basedir,
survey_path.replace('/', '.'), vc_file)
else:
vc_path = "%s/%s/%s" % (VC_DIR, basedir, survey_path.replace('/', '.'))
files = []
for x in glob.glob("%s*" % vc_path):
if os.listdir(x):
temp = os.path.basename(x)
file = temp.replace('.', '/', 1)
while not os.path.isfile(file) and file != temp:
temp = file[:]
file = temp.replace('.', '/', 1)
if os.path.isfile(file):
files.append(file)
if files:
print "\n".join(files)
else:
print >> sys.stderr, "There are no versioned files in path '%s'" % survey_path
sys.exit(1)
vc_files = sorted(
[os.path.basename(x) for x in glob.glob("%s/*" % vc_path)],
reverse=True)
daFile = "%s/%s" % (survey_path, vc_file)
if not vc_files:
print >> sys.stderr, "There are no versioned '%s' of path '%s'" % (
vc_file, survey_path)
elif vc_get:
from tempfile import NamedTemporaryFile
namedFiles = []
namedFix = {0: ["vc_", "_PostEdit"], 1: ["vc_", "_PreEdit"]}
for i, x in enumerate(vc_get):
fileread = None
if x == 0:
tstamp = time.strftime(
"%b %d %I:%M%p %Y",
time.localtime(os.path.getmtime(daFile)))
fileread = open(daFile).read()
fileread = re.sub("\r", '', re.sub(VC.RemoveIdRx, '',
fileread))
elif x <= len(vc_files):
tstamp = time.strftime("%b %d %I:%M%p %Y",
time.localtime(int(vc_files[x - 1])))
fileread = re.sub("\r", '',
VC.vcread(daFile, int(vc_files[x - 1])))
if fileread:
if vc_diff or vc_diffc or vc_vimdiff:
editFile = NamedTemporaryFile(prefix=namedFix[i][0],
suffix="%s.xml" %
namedFix[i][1])
editFile.write(fileread)
editFile.flush()
namedFiles.insert(0, [editFile, tstamp])
else:
print >> sys.stderr, "%s) %s" % (x, tstamp)
print fileread
break
if len(namedFiles) > 1:
pre, post = namedFiles
tstampPre = pre[1]
tstampPost = post[1]
preEditFile = pre[0]
postEditFile = post[0]
print >> sys.stderr, "Showing differences for file %s modifications between %s and %s:" % (
daFile, tstampPre, tstampPost)
if vc_diff:
os.system('diff %s %s' % (preEditFile.name, postEditFile.name))
elif vc_diffc:
os.system('~v2/temp/gwicks/scr/diffc %s %s' %
(preEditFile.name, postEditFile.name))
elif vc_vimdiff:
os.system('vimdiff -R -c \'windo set wrap\' %s %s' %
(preEditFile.name, postEditFile.name))
else:
database.init()
#previousEditor, previousEdit = VC.getLastEdit(daFile)
#if previousEdit is not None:
# previousEdit = misc.transformDate(previousEdit)
#print "Last Edited: %s, %s" % (previousEditor, previousEdit)
if daFile and daFile.endswith('survey.xml'):
query = """
SELECT * FROM (SELECT filename, tstamp as "when", del, add, who AS who, '' AS type FROM vc.changes
WHERE filename = %s
UNION ALL
SELECT survey || '/survey.xml' as filename, tstamp as "when", 0 as del, 0 as add, SPLIT_PART(who, ' ', 1), type
FROM audit.approval
WHERE survey = %s) AS X
ORDER BY "when" DESC"""
l = database.dictfetchall(query, daFile, os.path.dirname(daFile))
else:
l = database.dictfetchall(
"""
SELECT filename, tstamp as "when", del, add, who, '' as type FROM vc.changes
WHERE filename = %s
ORDER BY tstamp DESC""", daFile)
vcdict = {}
for x in l:
x['add'] = 0 if x['add'] is None else x['add']
x['del'] = 0 if x['del'] is None else x['del']
vcdict[str(x['when'])] = x
print "Showing last %d edit(s) of %d total:" % (
vc_list if len(vc_files) > vc_list else len(vc_files),
len(vc_files))
vc_files = vc_files[:vc_list]
for i, x in enumerate(vc_files):
tstamp = time.strftime("%a, %b %d %I:%M%p %Y",
time.localtime(int(x)))
vnumber = (i + 1)
vcx = vcdict[x]
numlen = len(str(len(vc_files)))
format = "%%%dd) %%s [+%%d -%%d] %%s" % numlen
if vc_search:
fileread = VC.vcread(daFile, int(x))
if re.search(vc_search, fileread):
format = format + " +SEARCH FOUND"
print format % (vnumber, tstamp, vcx['add'], vcx['del'],
vcx['who'])
