basic.lua
local cassandra = require "cassandra"
local session = cassandra:new()
session:set_timeout(1000)
local connected, err = session:connect("127.0.0.1", 9042)
assert(connected)
session:set_keyspace("demo")
local table_created, err = session:execute [[
CREATE TABLE users(
id uuid PRIMARY KEY,
name varchar,
age int
)
]]
local ok, err = session:execute("INSERT INTO users(name, age, user_id) VALUES(?, ?, ?)"
, {"John O'Reilly", 42, cassandra.uuid("1144bada-852c-11e3-89fb-e0b9a54a6d11")})
local users, err = session:execute("SELECT name, age, user_id FROM users")
assert(1 == #users)
local user = users[1]
print(user.name) print(user.user_id) print(user.age)