""" for t in xrange(len(data2)): start_time3 = time.time() batchInsert = [] batchInsert.append("BEGIN BATCH") # print 'at time: ',t for z in xrange(len(data2[0][0][0])): for y in xrange(len(data2[0][0])): for x in xrange(len(data2[0])): # print 999 # the data for subject is in data[i][x][y][z][time] # print str(x),str(y),str(z),str(t) tempInsert = prepareInsert( "engagement", fileName[:-4] + "total2", [subject, x, y, z, t, data2[t][x][y][z]], tableColumns=" (subject,x,y,z,time,data) ", ) # print tempInsert; batchInsert.append(tempInsert) # dont forget to comment this line out when in actual enviornment # sys.exit(0) """ if(len(batchInsert)>10): batchInsert.append(' APPLY BATCH;') sys.exit(0) """ # session.execute(tempInsert) # print 'inserting: '+ tempInsert batchInsert.append(" APPLY BATCH;")
46 --> X, from left to right. 274 --> time, from lower time to higher time ''' for t in xrange(len(data[0][0][0][0])): start_time3 = time.time(); batchInsert=[] batchInsert.append('BEGIN BATCH') print 'at time: ',t for z in xrange(len(data[0])): for y in xrange(len(data[0][0])): for x in xrange(len(data[0][0][0])): #print 999 #the data for subject is in data[i][x][y][z][time] #print str(x),str(y),str(z),str(t) tempInsert = prepareInsert('engagement',fileName[:-4]+'t'+str(subject),[x,y,z,t,data[subject][z][y][x][t]],tableColumns = ' (x,y,z,time,data) ') #print tempInsert; batchInsert.append(tempInsert) ''' if(len(batchInsert)>10): batchInsert.append(' APPLY BATCH;') sys.exit(0) ''' #session.execute(tempInsert) #print 'inserting: '+ tempInsert batchInsert.append(' APPLY BATCH;') temp = ' '.join(batchInsert) tryInsert(session,temp,1) # session.execute(temp) print("--- run time for t: %s seconds ---" % str(time.time() - start_time3))
22 subjects for hitchcockdatao ''' for t in xrange(len(data2)): start_time3 = time.time(); batchInsert=[] batchInsert.append('BEGIN BATCH') #print 'at time: ',t for z in xrange(len(data2[0][0][0])): for y in xrange(len(data2[0][0])): for x in xrange(len(data2[0])): #print 999 #the data for subject is in data[i][x][y][z][time] #print str(x),str(y),str(z),str(t) tempInsert = prepareInsert('engagement',fileName[:-4]+'total',[subject,x,y,z,t,data2[t][x][y][z]],tableColumns = ' (subject,x,y,z,time,data) ') #print tempInsert; batchInsert.append(tempInsert) #dont forget to comment this line out when in actual enviornment #sys.exit(0) ''' if(len(batchInsert)>10): batchInsert.append(' APPLY BATCH;') sys.exit(0) ''' #session.execute(tempInsert) #print 'inserting: '+ tempInsert batchInsert.append(' APPLY BATCH;') temp = ' '.join(batchInsert) #sys.exit(0)