Database Reference
In-Depth Information
"(portfolio_id, ticker,
current_price, "
" current_change, cur-
rent_change_percent) VALUES "
"(756716f7-2e54-4715-9f00-91dcbea6cf50,
'GOOG', "
" 889.07, -4.00, -0.45);")
self.session.execute("INSERT INTO portfo-
lio_demo.portfolio "
"(portfolio_id, ticker,
current_price, "
" current_change, cur-
rent_change_percent) VALUES "
"(756716f7-2e54-4715-9f00-91dcbea6cf50,
'AMZN', "
" 297.92, -0.94, -0.31);")
def print_results(self):
results = self.session.execute("SELECT * FROM
portfolio_demo.portfolio "
"WHERE portfo-
lio_id = "
"756716f7-2e54-4715-9f00-91dcbea6cf50;")
print "%-7s\t%-7s\t%-7s\t%-7s\n%s" % \
("Ticker", "Price", "Change", "PCT",
"........+........+........+........")
for row in results:
print "%-7s\t%0.2f\t%0.2f\t%0.2f" % \
(row.ticker, row.current_price,
row.current_change,
row.current_change_percent)
if __name__ == '__main__':
sample_app = SampleApp()
sample_app.connect("127.0.0.1")
sample_app.create_schema()
