def setup_db(username, password, url):
dbname = "spark_data"
client = Cloudant(username, password, url=url)
client.connect()
# Perform client tasks...
session = client.session()
print 'Username: {0}'.format(session['userCtx']['name'])
databases = client.all_dbs()
db = client.create_database(dbname)
print 'Databases: {0}'.format(client.all_dbs())
return db
from cloudant.account import Cloudant
client = Cloudant('eurisko', 'nox721!carpe', account='eurisko')
# or using url
# client = Cloudant(USERNAME, PASSWORD, url='https://acct.cloudant.com')
# Connect to the account
client.connect()
# Perform client tasks...
session = client.session()
print session['userCtx']['name']
print client.all_dbs()
db = client['eurisko']
inserted_counter = 0
# now connec to local sqlite3
def parse_results(results):
"""
"""
for result in results:
print 'parsing result'
data = {}
data['customer_id'] = 0
data['tags'] = []
data['title'] = result[0]
data['content'] = result[1]
data['timestamp'] = result[2]
insert_to_cloudant(data)
if 'credentials' not in TONE:
raise RuntimeError("Cannot connect to Watson. Credentials not found for personality insights.")
else:
tone_analyzer = ToneAnalyzerV3Beta(username=TONE['credentials']['username'], password=TONE['credentials']['password'], version='2016-02-11')
CLOUDANT = json.loads(os.environ['VCAP_SERVICES'])['cloudantNoSQLDB'][0]
if 'credentials' not in CLOUDANT:
raise RuntimeError("Cannot connect to database, Cloudant credentials not found.")
else:
client = Cloudant(CLOUDANT['credentials']['username'], CLOUDANT['credentials']['password'], url=CLOUDANT['credentials']['url'])
client.connect()
databases = ['personas', 'albums', 'songs']
for db in databases:
if db not in client.all_dbs():
raise RuntimeError("Database " + db + " not found, please ensure you have the needed data.")
cached_tone = {}
for persona in client['personas']:
cached_tone[persona['_id']] = None
cached_persona_insights = {}
for persona in client['personas']:
cached_persona_insights[persona['_id']] = None
def assemble_persona_text(persona):
text = ''
for album in client['personas'][persona]['albums']:
for song in client['albums'][album['title']]['songs']:
try:
password=TONE['credentials']['password'],
version='2016-02-11')
CLOUDANT = json.loads(os.environ['VCAP_SERVICES'])['cloudantNoSQLDB'][0]
if 'credentials' not in CLOUDANT:
raise RuntimeError(
"Cannot connect to database, Cloudant credentials not found.")
else:
client = Cloudant(CLOUDANT['credentials']['username'],
CLOUDANT['credentials']['password'],
url=CLOUDANT['credentials']['url'])
client.connect()
databases = ['personas', 'albums', 'songs']
for db in databases:
if db not in client.all_dbs():
raise RuntimeError(
"Database " + db +
" not found, please ensure you have the needed data.")
cached_tone = {}
for persona in client['personas']:
cached_tone[persona['_id']] = None
cached_persona_insights = {}
for persona in client['personas']:
cached_persona_insights[persona['_id']] = None
def assemble_persona_text(persona):
text = ''
