Develop Python Apps

AttentionThis page documents an earlier version. Go to the latest (v2.1)version.

Installation

Install the python driver using the following command.

  1. $ pip install cassandra-driver

Working Example

Pre-requisites

This tutorial assumes that you have:

  • installed YugabyteDB, created a universe and are able to interact with it using the CQL shell. If not, please follow these steps in the quick start guide.

Writing the python code

Create a file yb-cql-helloworld.py and add the following content to it.

  1. from cassandra.cluster import Cluster
  3. # Create the cluster connection.
  4. cluster = Cluster(['127.0.0.1'])
  5. session = cluster.connect()
  7. # Create the keyspace.
  8. session.execute('CREATE KEYSPACE IF NOT EXISTS ybdemo;')
  9. print "Created keyspace ybdemo"
  11. # Create the table.
  12. session.execute(
  13.   """
  14.   CREATE TABLE IF NOT EXISTS ybdemo.employee (id int PRIMARY KEY,
  15.                                               name varchar,
  16.                                               age int,
  17.                                               language varchar);
  18.   """)
  19. print "Created table employee"
  21. # Insert a row.
  22. session.execute(
  23.   """
  24.   INSERT INTO ybdemo.employee (id, name, age, language)
  25.   VALUES (1, 'John', 35, 'NodeJS');
  26.   """)
  27. print "Inserted (id, name, age, language) = (1, 'John', 35, 'Python')"
  29. # Query the row.
  30. rows = session.execute('SELECT name, age, language FROM ybdemo.employee WHERE id = 1;')
  31. for row in rows:
  32.   print row.name, row.age, row.language
  34. # Close the connection.
  35. cluster.shutdown()

Running the application

To run the application, type the following:

  1. $ python yb-cql-helloworld.py

You should see the following output.

  1. Created keyspace ybdemo
  2. Created table employee
  3. Inserted (id, name, age, language) = (1, 'John', 35, 'Python')
  4. John 35 Python

Installation

Install the python driver using the following command.

  1. $ sudo pip install redis

Working Example

Pre-requisites

This tutorial assumes that you have:

  • installed YugabyteDB, created a universe and are able to interact with it using the Redis shell. If not, please follow these steps in the quick start guide.

Writing the python code

Create a file yb-redis-helloworld.py and add the following content to it.

  1. import redis
  3. # Create the cluster connection.
  4. r = redis.Redis(host='localhost', port=6379)
  6. # Insert the user profile.
  7. userid = 1
  8. user_profile = {"name": "John", "age": "35", "language": "Python"}
  9. r.hmset(userid, user_profile)
  10. print "Inserted userid=1, profile=%s" % user_profile
  12. # Query the user profile.
  13. print r.hgetall(userid)

Running the application

To run the application, type the following:

  1. $ python yb-redis-helloworld.py

You should see the following output.

  1. Inserted userid=1, profile={'age': '35', 'name': 'John', 'language': 'Python'}
  2. {'age': '35', 'name': 'John', 'language': 'Python'}