def main():
connect()
proj = project.create_empty_project()
if os.path.exists('state.json'):
with open('state.json') as f:
proj.load(json.loads(f.read()))
screen = sdlcurses.initscr('BeatKit v0.1', 'beatkit.png')
# Pattern Player thread
player = PlayerThread()
player.start()
set_bpm(proj.bpm, project)
# Input sources
keychars = sdlcurses.PyGameThread()
keychars.start()
midi_input = events.MidiInThread(seq)
midi_input.start()
app = ProjectEditor(proj, screen, player)
try:
app.run()
except Exception:
print traceback.format_exc()
with open('state.json', 'w') as f:
f.write(json.dumps(app.project.dump(), indent=2))
player.quit()
keychars.stop()
midi_input.stop()
def rangeconnect(self, inputlist: list, rangelist: list,
session: requests.Session(), guiqueue: Queue):
for i in rangelist:
try:
result = connections.connect(session, inputlist[i],
self.timeout)
guiqueue.put(result)
self.queue.put(result)
except:
pass
def create_tree(self, selected_text, row):
server = opc.servers()
item = QtGui.QTreeWidgetItem(["Servers"])
self.treeWidget.addTopLevelItem(item)
for x in server:
item1 = QtGui.QTreeWidgetItem(item, [x])
if x == selected_text:
self.server_name.setText(selected_text)
self.server_status.setText("Online")
item5 = QtGui.QTreeWidgetItem(item1, ["Add New Group"])
self.treeWidget.insertTopLevelItem(row, item1)
opc.connect(selected_text)
connections.connect()
connected_server = connections.server()
data = connections.read_from_db(connected_server) #Passing server name to conn DB
for con1 in data:
update_rate.append(con1[2])
group.append(con1[0])
temp1 = str(con1[1])
temp2 = con1[1]
temp2 = str(temp2)
temp2 = temp2.replace("'", "")
temp2 = temp2.replace("[", "")
temp2 = temp2.replace("]", "")
temp2 = ''.join(temp2)
temp1 = re.split("; |, |' ", temp2)
tags.append(temp1)
i = 0
for con2 in group:
item2 = QtGui.QTreeWidgetItem(item1, [con2])
tags_list = tags[i]
tags_ = tags[i]
g_name = group[i]
u_rate = update_rate[i]
opc.read(tags_, group=g_name, update=u_rate)
for con3 in tags_list:
item3 = QtGui.QTreeWidgetItem(item2, [con3])
i += 1
self.server_groups.setText(str(len(group)))
self.treeWidget.expandToDepth(row)
def play(self, data):
self.set_data(data)
connections.connect()
self.data.bind()
jack_client.transport_start()
cnt += 1
d = OrderedDict()
# convert data to json so that data can be referred as their key names
for i in range(sz):
d[fields[i]] = data[i]
d['State'] = d['State'].upper()
d['Zip'] = d['Zip'][:5]
dates = ["ActiveStartTime", "ActiveEndTime", "LastModifiedDate"]
for dt in dates:
d[dt] = db_dateformat(d[dt])
d['PhonePrimary'] = d['PhonePrimary'][:10]
db_fields = tuple([None if d[r] is None or d[r] == '' else d[r] for r in reqd_fields])
db_rec.append(db_fields)
log.info('Total Rows to be inserted into DB: %s rows' % cnt)
log.info('Starting MySQL load...')
load_sql = "insert into stg_ss_data VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"
conn = connections.connect("database")
with conn:
cursor = conn.cursor()
log.info('Truncating Staging table: stg_ss_data..')
cursor.execute("TRUNCATE stg_ss_data")
log.info('Table stg_ss_data truncated')
cursor.executemany(load_sql, db_rec)
log.info('Completed MySql load.')
connections.send_mail("SUCCESS: Completed surescripts data download")
d = OrderedDict()
# convert data to json so that data can be referred as their key names
for i in range(sz):
d[fields[i]] = data[i]
d['State'] = d['State'].upper()
d['Zip'] = d['Zip'][:5]
dates = ["ActiveStartTime", "ActiveEndTime", "LastModifiedDate"]
for dt in dates:
d[dt] = db_dateformat(d[dt])
d['PhonePrimary'] = d['PhonePrimary'][:10]
db_fields = tuple(
[None if d[r] is None or d[r] == '' else d[r] for r in reqd_fields])
db_rec.append(db_fields)
log.info('Total Rows to be inserted into DB: %s rows' % cnt)
log.info('Starting MySQL load...')
load_sql = "insert into stg_ss_data VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"
conn = connections.connect("database")
with conn:
cursor = conn.cursor()
log.info('Truncating Staging table: stg_ss_data..')
cursor.execute("TRUNCATE stg_ss_data")
log.info('Table stg_ss_data truncated')
cursor.executemany(load_sql, db_rec)
log.info('Completed MySql load.')
connections.send_mail("SUCCESS: Completed surescripts data download")
def run():
con.connect()
init_sensors()