2018-09-02 21:31:37 +02:00
|
|
|
"""
|
|
|
|
Python by Techfossguru
|
|
|
|
Copyright (C) 2017 Satish Prasad
|
|
|
|
|
|
|
|
"""
|
|
|
|
import logging
|
|
|
|
from cassandra.cluster import Cluster, BatchStatement
|
2018-09-03 22:24:50 +02:00
|
|
|
import string
|
|
|
|
import random
|
|
|
|
from random import randint
|
|
|
|
|
|
|
|
primary_key = 1
|
|
|
|
hobbies = []
|
|
|
|
hobbies.append('Golf')
|
|
|
|
hobbies.append('Schwimmen')
|
|
|
|
hobbies.append('Datenbanken')
|
|
|
|
|
|
|
|
|
|
|
|
def randomword(length):
|
|
|
|
return ''.join(random.choice(
|
|
|
|
string.ascii_lowercase) for i in range(length))
|
|
|
|
|
|
|
|
|
|
|
|
def create_batch(insert_sql):
|
|
|
|
global primary_key
|
|
|
|
counter = 1
|
|
|
|
batch = BatchStatement()
|
|
|
|
while 15 > counter:
|
|
|
|
param_counter = 0
|
|
|
|
params = []
|
|
|
|
while 13 > param_counter:
|
|
|
|
name = randomword(6)
|
|
|
|
params.append(name)
|
|
|
|
param_counter += 1
|
|
|
|
|
|
|
|
batch.add(insert_sql, (primary_key, params[0], params[1], params[2],
|
|
|
|
params[3], params[4], params[5], params[6],
|
|
|
|
params[7], hobbies[randint(0, 2)], params[9],
|
|
|
|
params[10], params[11], params[12]))
|
|
|
|
counter += 1
|
|
|
|
primary_key += 1
|
|
|
|
return batch
|
2018-09-02 21:31:37 +02:00
|
|
|
|
|
|
|
|
|
|
|
class PythonCassandraExample:
|
|
|
|
|
|
|
|
def __init__(self):
|
|
|
|
self.cluster = None
|
|
|
|
self.session = None
|
|
|
|
self.keyspace = None
|
|
|
|
self.log = None
|
|
|
|
|
|
|
|
def __del__(self):
|
|
|
|
self.cluster.shutdown()
|
|
|
|
|
|
|
|
def createsession(self):
|
|
|
|
self.cluster = Cluster(['localhost'])
|
|
|
|
self.session = self.cluster.connect(self.keyspace)
|
|
|
|
|
|
|
|
def getsession(self):
|
|
|
|
return self.session
|
|
|
|
|
|
|
|
# How about Adding some log info to see what went wrong
|
|
|
|
def setlogger(self):
|
|
|
|
log = logging.getLogger()
|
|
|
|
log.setLevel('INFO')
|
|
|
|
handler = logging.StreamHandler()
|
|
|
|
handler.setFormatter(logging.Formatter(
|
|
|
|
"%(asctime)s [%(levelname)s] %(name)s: %(message)s"))
|
|
|
|
log.addHandler(handler)
|
|
|
|
self.log = log
|
|
|
|
|
|
|
|
# Create Keyspace based on Given Name
|
|
|
|
def createkeyspace(self, keyspace):
|
|
|
|
"""
|
|
|
|
:param keyspace: The Name of Keyspace to be created
|
|
|
|
:return:
|
|
|
|
"""
|
|
|
|
# Before we create new lets check if exiting keyspace; we will drop
|
|
|
|
# that and create new
|
|
|
|
rows = self.session.execute(
|
|
|
|
"SELECT keyspace_name FROM system_schema.keyspaces")
|
|
|
|
if keyspace in [row[0] for row in rows]:
|
|
|
|
self.log.info("dropping existing keyspace...")
|
|
|
|
self.session.execute("DROP KEYSPACE " + keyspace)
|
|
|
|
|
|
|
|
self.log.info("creating keyspace...")
|
|
|
|
self.session.execute("""
|
|
|
|
CREATE KEYSPACE %s
|
|
|
|
WITH replication = { 'class': 'SimpleStrategy', 'replication_factor': '2' }
|
|
|
|
""" % keyspace)
|
|
|
|
|
|
|
|
self.log.info("setting keyspace...")
|
|
|
|
self.session.set_keyspace(keyspace)
|
|
|
|
|
|
|
|
def create_table(self):
|
|
|
|
c_sql = """
|
2018-09-03 22:24:50 +02:00
|
|
|
CREATE TABLE IF NOT EXISTS user (id int PRIMARY KEY,
|
|
|
|
username varchar,
|
|
|
|
email varchar,
|
|
|
|
first_name varchar,
|
|
|
|
last_name varchar,
|
|
|
|
middle_name varchar,
|
|
|
|
street_name varchar,
|
|
|
|
telephonenumber varchar,
|
|
|
|
mobile_number varchar,
|
|
|
|
hobby varchar,
|
|
|
|
salutation varchar,
|
|
|
|
gender varchar,
|
|
|
|
city varchar,
|
|
|
|
country varchar);
|
2018-09-02 21:31:37 +02:00
|
|
|
"""
|
|
|
|
self.session.execute(c_sql)
|
2018-09-03 22:24:50 +02:00
|
|
|
self.log.info("User Table Created !!!")
|
|
|
|
|
|
|
|
def insert_data(self):
|
|
|
|
insert_sql = self.session.prepare(
|
|
|
|
"""
|
|
|
|
INSERT INTO user (id,
|
|
|
|
username,
|
|
|
|
email,
|
|
|
|
first_name,
|
|
|
|
last_name,
|
|
|
|
middle_name,
|
|
|
|
street_name,
|
|
|
|
telephonenumber,
|
|
|
|
mobile_number,
|
|
|
|
hobby,
|
|
|
|
salutation,
|
|
|
|
gender,
|
|
|
|
city,
|
|
|
|
country) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)
|
|
|
|
"""
|
|
|
|
)
|
|
|
|
counter = 1
|
2018-09-04 06:01:31 +02:00
|
|
|
while 100000 > counter:
|
2018-09-03 22:24:50 +02:00
|
|
|
batch = create_batch(insert_sql)
|
|
|
|
self.session.execute(batch)
|
|
|
|
counter += 1
|
|
|
|
self.log.info('Batch Insert Completed')
|
|
|
|
|
2018-09-02 21:31:37 +02:00
|
|
|
|
2018-09-03 22:24:50 +02:00
|
|
|
# lets do some batch insert
|
2018-09-02 21:31:37 +02:00
|
|
|
if __name__ == '__main__':
|
|
|
|
example1 = PythonCassandraExample()
|
|
|
|
example1.createsession()
|
|
|
|
example1.setlogger()
|
2018-09-03 22:24:50 +02:00
|
|
|
example1.createkeyspace('userdb')
|
2018-09-02 21:31:37 +02:00
|
|
|
example1.create_table()
|
|
|
|
example1.insert_data()
|
2018-09-03 22:24:50 +02:00
|
|
|
#example1.select_data()
|