def testCashRawPosition(self):
inputFile = join(getCurrentDirectory(), 'samples',
'Cash Stt _22102019.xlsx')
dt, positions = (lambda t: (t[0], list(t[1])))(getPositions(inputFile))
self.assertEqual('2019-10-22', dt)
self.assertEqual(1, len(positions))
self.verifyCashRawPosition(positions[0])
def testOutputData3(self):
inputFile = join(getCurrentDirectory(), 'samples',
'Cash Stt _22102019.xlsx')
postfix, data = (lambda t: (t[0], list(t[1])))(toOutputData(inputFile))
self.assertEqual('_nomura_2019-10-22_cash', postfix)
self.assertEqual(2, len(data))
self.assertEqual(getCashHeaders(), data[0])
self.verifyOutputLine3(list(data[1]))
def testRawPosition(self):
inputFile = join(getCurrentDirectory(), 'samples',
'Holding _22102019.xlsx')
dt, positions = (lambda t: (t[0], list(t[1])))(getPositions(inputFile))
self.assertEqual('2019-10-22', dt)
self.assertEqual(48, len(positions))
self.verifyRawPosition(firstOf( lambda p: p['Security Name'] == 'EASY TACTIC LTD 9.125% 28/07/2022'\
, positions))
def testOutputData2(self):
inputFile = join(getCurrentDirectory(), 'samples',
'Holding _24102019.xlsx')
postfix, data = (lambda t: (t[0], list(t[1])))(toOutputData(inputFile))
self.assertEqual('_nomura_2019-10-24_position', postfix)
self.assertEqual(49, len(data))
self.assertEqual(getHoldingHeaders(), data[0])
self.verifyOutputLine2(firstOf( lambda line: line[4] == ''\
, map(list, data)))
( '_nomura_' + date + '_cash'\
, chain( [getCashHeaders()]\
, map( partial(dictToValues, getCashHeaders())\
, map( partial(cashPosition, date)\
, positions)))\
) if isCashFile(inputFile) else \
( '_nomura_' + date + '_position'\
, chain( [getHoldingHeaders()]\
, map( partial(dictToValues, getHoldingHeaders())\
, map( partial(holdingPosition, date)\
, positions)))\
)
)(*getPositions(inputFile))
outputCsv = lambda inputFile, outputDir: \
(lambda postfix, outputData: \
writeCsv( getOutputFileName(inputFile, postfix, outputDir)\
, outputData, delimiter='|')
)(*toOutputData(inputFile))
if __name__ == '__main__':
import logging.config
logging.config.fileConfig('logging.config', disable_existing_loggers=False)
# inputFile = join(getCurrentDirectory(), 'samples', 'Cash Stt _22102019.xlsx')
inputFile = join(getCurrentDirectory(), 'samples',
'Holding _22102019.xlsx')
print(outputCsv(inputFile, ''))
def testOutputData3(self):
inputFile = join(getCurrentDirectory(), 'samples',
'Holding _24102019.xlsx')
postfix, data = (lambda t: (t[0], list(t[1])))(toOutputData(inputFile))
self.assertEqual('_nomura_2019-10-24_position', postfix)
self.assertEqual(49, len(data))