import sys
from argparse import ArgumentParser
from configparser import ConfigParser
from subprocess import call
import pandas
def run(cmd):
print(' '.join(cmd))
ok = call(cmd)
if ok != 0:
sys.exit()
help_file = 'File Excel'
pars = ArgumentParser()
pars.add_argument('--file', help=help_file)
option = pars.parse_args(sys.argv[1:])
bin_inquiry = '/home/h2h/pbb/env/bin/pbb_inquiry'
conf_files = ['/home/h2h/pbb/query.ini', '/home/h2h/pbb/oracle.ini']
xf = pandas.ExcelFile(option.file)
sheet = xf.sheet_names[0]
d = xf.parse(sheet)
for row in d.values:
invoice_id = row[0]
if isinstance(invoice_id, str):
invoice_id = invoice_id.replace('.', '').replace('-', '').\
replace(' ', '')
for conf_file in conf_files:
cmd = [
bin_inquiry, conf_file, '--invoice-id=' + invoice_id,
'--reversal']
run(cmd)