session.execute("INSERT INTO foo (bar) VALUES (%s)", "blah") # エラー
session.execute("INSERT INTO foo (bar) VALUES (%s)", ("blah")) # エラー
session.execute("INSERT INTO foo (bar) VALUES (%s)", ("blah", )) # OK
session.execute("INSERT INTO foo (bar) VALUES (%s)", ["blah"]) # OK
CREATE TABLE odordb.test_table (
id int PRIMARY KEY,
exp map<text,double>
);
INSERT INTO odordb.test_table JSON '{"id":1,
"exp": {
"EDIBLE": 10.5,
"BAKERY": 0.0,
"SWEET": 0.0,
from cassandra.cluster import Cluster from cassandra.query import dict_factory import pubchempy as pup import os import time # cluster = Cluster(['127.0.0.1']) # session = cluster.connect() # session.row_factory = dict_factory
import subprocess
import os
# try:
# cmd=["mkdir","inserted"]
# subprocess.run(cmd)
# except:
# print("file has registed.")
SELECT JSON * FROM "user_status_updates_by_datetime" WHERE "usernamne" = 'alice' AND status_date > '2016-11-20';
CREATE TABLE my_status.user_status_updates_by_datetime (
username text,
status_date date,
status_time time,
body text,
PRIMARY KEY (username, status_date, status_time) );
INSERT INTO "user_status_updates_by_datetime"
JSON '{"username": "alice", "status_date": "2016-11-24", "status_time": "13:35:20.123456", "body": "Alice Update 7"}';
#!/bin/bash IFS_BACKUP=$IFS IFS=$'\n' BABEL_DIR=babel.am1 cd $BABEL_DIR if [ ! -d ./output ]; then mkdir output fi
#! /bin/bash for job in $@ do echo "#$ -S /bin/bash" > $job.sh echo "#$ -N $job" >> $job.sh echo "#$ -e /dev/null" >> $job.sh echo "#$ -o /dev/null" >> $job.sh chmod +x $job.sh echo 'export g16root=/usr/local' >> $job.sh echo "export GAUSS_SCRDIR=/tmp" >> $job.sh
import subprocess import os from datetime import datetime,timedelta,timezone import uuid import pickle import random
import pubchempy as pup
import os
import time
element = []
files =os.listdir("./output")
element_z = [f for f in files if os.path.isfile(os.path.join("./output", f))]
for i in element_z: