Build a Python application
Install the Yugabyte Python Driver for YCQL
To install the Yugabyte Python Driver for YCQL, run the following command:
$ pip3 install yb-cassandra-driver --install-option="--no-cython"
Note
The flag--no-cython is necessary on MacOS Catalina and further MacOS releases to avoid a failure while building the yb-cassandra-driver.
Create a sample Python application
Prerequisites
This tutorial assumes that you have:
- installed YugabyteDB, created a universe, and are able to interact with it using the YCQL shell. If not, follow the steps in Quick start YCQL.
Write the sample Python application
Create a file yb-cql-helloworld.py and copy the following content into it.
from cassandra.cluster import Cluster
# Create the cluster connection.
cluster = Cluster(['127.0.0.1'])
session = cluster.connect()
# Create the keyspace.
session.execute('CREATE KEYSPACE IF NOT EXISTS ybdemo;')
print("Created keyspace ybdemo")
# Create the table.
session.execute(
"""
CREATE TABLE IF NOT EXISTS ybdemo.employee (id int PRIMARY KEY,
name varchar,
age int,
language varchar);
""")
print("Created table employee")
# Insert a row.
session.execute(
"""
INSERT INTO ybdemo.employee (id, name, age, language)
VALUES (1, 'John', 35, 'Python');
""")
print("Inserted (id, name, age, language) = (1, 'John', 35, 'Python')")
# Query the row.
rows = session.execute('SELECT name, age, language FROM ybdemo.employee WHERE id = 1;')
for row in rows:
print(row.name, row.age, row.language)
# Close the connection.
cluster.shutdown()
Run the application
To run the application, type the following:
$ python3 yb-cql-helloworld.py
You should see the following output.
Created keyspace ybdemo
Created table employee
Inserted (id, name, age, language) = (1, 'John', 35, 'Python')
John 35 Python