Drivers and Sample Code - Practical Cassandra - page 152

current_change_percent FLOAT,
PRIMARY KEY(portfolio_id, ticker)
);
CQL
@cluster.execute(create_keyspace)
@cluster.execute(create_portfolio)
end
Writing Data
Once our schema has been created, we can load in some data. In this example, we
will add a couple of rows to our table. Listing 9.26 shows example insert state-
ments.
Listing 9.26 Writing Data in Ruby
Click here to view code image
def load_data
row_one = <<-CQL
INSERT INTO portfolio_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);
CQL
row_two = <<-CQL
INSERT INTO portfolio_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);
CQL
@cluster.execute(row_one)