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))