/*
* (non-Javadoc)
*
* @see com.dtcc.awsticker.dao.IDaoTicker#putTickerRow(java.lang.Integer,
* com.dtcc.awsticker.domain.TickerRow)
*/
public void putTickerRow(Integer index, TickerRow tickerRow) {
// LocalTickerTable.put(index, tickerRow);
Map<String, AttributeValue> item = new HashMap<String, AttributeValue>();
item.put("Index", new AttributeValue().withN("" + tickerRow.getIndex()));
// item.put("Date", new AttributeValue(tickerRow.getDate()));
item.put("Name", new AttributeValue(tickerRow.getName()));
item.put("Number", new AttributeValue(tickerRow.getNumber()));
item.put("Price", new AttributeValue(tickerRow.getPrice()));
item.put("Time", new AttributeValue(tickerRow.getDateTime()));
item.put("CreatedTimeMs", new AttributeValue("" + System.currentTimeMillis()));
PutItemRequest putItemRequest = new PutItemRequest(tableName, item);
PutItemResult putItemResult = db.putItem(putItemRequest);
}
@Override
public int insert(String table, String key, HashMap<String, ByteIterator> values) {
logger.debug("insertkey: " + primaryKeyName + "-" + key + " from table: " + table);
Map<String, AttributeValue> attributes = createAttributes(values);
// adding primary key
attributes.put(primaryKeyName, new AttributeValue(key));
PutItemRequest putItemRequest = new PutItemRequest(table, attributes);
PutItemResult res = null;
try {
res = dynamoDB.putItem(putItemRequest);
} catch (AmazonServiceException ex) {
logger.error(ex.getMessage());
return SERVER_ERROR;
} catch (AmazonClientException ex) {
logger.error(ex.getMessage());
return CLIENT_ERROR;
}
return OK;
}
private void run() throws IOException {
InputStream resourceAsStream = getClass().getResourceAsStream("/AwsCredentials.properties");
assert resourceAsStream != null;
AWSCredentials credentials = new PropertiesCredentials(resourceAsStream);
AmazonDynamoDBClient amazonDynamoDBClient = new AmazonDynamoDBClient(credentials);
amazonDynamoDBClient.setEndpoint("https://dynamodb.us-west-1.amazonaws.com");
String tableName = "wellsfargo-checking-01";
// String tableName = "table3";
// describeTable(amazonDynamoDBClient, tableName);
List<String> strings = FileUtils.readLines(new File("data/subset.txt"));
int i = 0;
for (String record : strings) {
// 1 1/2/00 Opening Balance - 3504.65 X - [WF Checking]
String[] ledgerEntry = record.split("\\t");
Map<String, AttributeValue> item = new HashMap<String, AttributeValue>();
AttributeValue txidAttribute = new AttributeValue();
txidAttribute.setN(ledgerEntry[0]);
item.put("txid", txidAttribute);
item.put("date", new AttributeValue(ledgerEntry[1]));
item.put("payee", new AttributeValue(ledgerEntry[2]));
item.put("memo", new AttributeValue(ledgerEntry[3]));
item.put("amount", new AttributeValue(ledgerEntry[4]));
item.put("cleared", new AttributeValue(ledgerEntry[5]));
item.put("checknumber", new AttributeValue(ledgerEntry[6]));
item.put("category", new AttributeValue(ledgerEntry[7]));
PutItemRequest putItemRequest = new PutItemRequest(tableName, item);
PutItemResult putItemResult = amazonDynamoDBClient.putItem(putItemRequest);
if (++i % 10 == 0) {
System.out.println("putItemResult: " + putItemResult);
}
}
}
