Skip to content

Instantly share code, notes, and snippets.

@nickman
Created July 6, 2011 13:52
Show Gist options
  • Save nickman/1067274 to your computer and use it in GitHub Desktop.
Save nickman/1067274 to your computer and use it in GitHub Desktop.
Code Snippet For MarkupBuilder
import groovy.xml.MarkupBuilder;
writer = new StringWriter()
fixml = new MarkupBuilder(writer);
fixml.setDoubleQuotes(true);
driverSql = "select * from .......";
fixml.FIXML {
sqlECS.eachRow(driverSql , { pos ->
rowCnt++;
acctNbr = pos.subscriber_acct_nbr;
reqIdCounter++;
PosMntReq(ReqID:reqIdCounter, TxnTyp:transactionType, AdjTyp:adjType, Actn:actn, BizDt:bizDt, TxnTm:txnTime) {
Pty(ID:party21, R:21){}
Pty(ID:party22, R:22){}
Pty(ID:sub.acct_nbr, R:1){}
Pty(ID:pos.pa_seg_type_code, R:38){}
Instrmt(Exch:pos.exchange_code, SecTyp:pos.genre_type, ID:pos.commodity_code, MMY:pos.period_code){}
Qty(Typ:paType, Long:1, Short:0){}
}
});
}
pcsContent = '<?xml version="1.0" encoding="UTF-8"?>\n' + writer.toString();
filename = "c:/temp/pcs-file-submission/PCS_${sub.acct_nbr}_TD_20110428_${random.nextInt(9999)}_090100.xml.ready";
new File(filename).setText(pcsContent);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment