Database Reference
In-Depth Information
portfolio_demo " +
"WITH REPLICATION = { 'class': 'Sim-
pleStrategy', " +
"'replication_factor': 1 };");
session.execute("CREATE TABLE IF NOT EXISTS
portfolio_demo.portfolio (" +
"portfolio_id UUID, ticker TEXT, " +
"current_price DECIMAL, current_change
DECIMAL, " +
"current_change_percent FLOAT, " +
"PRIMARY KEY(portfolio_id, ticker));");
}
public void loadData(){
session.execute("INSERT INTO portfo-
lio_demo.portfolio " +
"(portfolio_id, ticker, current_price, " +
" current_change, current_change_percent)
VALUES " +
"(756716f7-2e54-4715-9f00-91dcbea6cf50,
'GOOG', " +
" 889.07, -4.00, -0.45);");
session.execute("INSERT INTO portfo-
lio_demo.portfolio " +
"(portfolio_id, ticker, current_price, " +
" current_change, current_change_percent)
VALUES " +
"(756716f7-2e54-4715-9f00-91dcbea6cf50,
'AMZN', " +
" 297.92, -0.94, -0.31);");
}
public void printResults(){
ResultSet results = session.execute("SELECT *
FROM " +
"portfolio_demo.portfolio WHERE portfo-
lio_id = " +
