def doDatabaseUpdate(configFile): """ Build a database containing info on the events, locations, return period wind speeds and tracks. :param str configFile: Name of the configuration file. """ log.info("Creating hazard database") import database database.run(configFile) log.info("Created and populated database")
output.info("Channel {0} added to {1}".format(channel.name, channel.server.name)) @bot.event async def on_channel_delete(channel): Mysql.remove_channel(channel) output.info("Channel {0} deleted from {1}".format(channel.name, channel.server.name)) @bot.event async def on_command_error(error, ctx): channel = ctx.message.channel if isinstance(error, commands.MissingRequiredArgument): await send_cmd_help(ctx) elif isinstance(error, commands.BadArgument): await send_cmd_help(ctx) elif isinstance(error, commands.CommandInvokeError): output.error("Exception in command '{}', {}".format( ctx.command.qualified_name, error.original)) oneliner = "Error in command '{}' - {}: {}\nIf this issue persists, Please report it in the support server.".format( ctx.command.qualified_name, type(error.original).__name__, str(error.original)) await ctx.bot.send_message(channel, oneliner) database.run() bot.run(config["discord"]["token"]) bot.loop.close()
from database import run from generators import * classes = run() def get_student_from_class(classname, student): for c in classes: if c.classname == classname: for s in c.students: if s.name == student: return s def get_class(classname, pw): for c in classes: if c.classname == classname: if pw == 'confusing': return c
def run_cmd(cmd, milliseconds): global current_run, current_member, current_droid, current_state if request.method == 'GET': if __debug__: print("Current run: %s | Current Driver: %s | Current Droid: %s " % (current_run, current_member.member_uid, current_droid.droid_uid)) if cmd == 'START' and current_member.member_uid != 0 and current_state == 0: current_run = database.run(0, cmd, current_member.member_uid, current_droid.droid_uid, 0) socketio.emit('my_response', {'data': 'Start Run'}, namespace='/comms') socketio.emit('reload_current', {'data': 'reload current'}, namespace='/comms') audio.TriggerSound("air_horn") current_state = 1 if cmd == 'MIDDLE_WAIT' and current_state == 1: database.run(current_run, cmd, current_member.member_uid, current_droid.droid_uid, milliseconds) socketio.emit('my_response', {'data': 'Halfway Rest'}, namespace='/comms') socketio.emit('reload_current', {'data': 'reload current'}, namespace='/comms') current_state = 2 if cmd == 'MIDDLE_START' and current_state == 2: database.run(current_run, cmd, current_member.member_uid, current_droid.droid_uid, 0) socketio.emit('my_response', {'data': 'Continuing Run'}, namespace='/comms') socketio.emit('reload_current', {'data': 'reload current'}, namespace='/comms') current_state = 3 if cmd == 'FINISH' and current_state == 3: database.run(current_run, cmd, current_member.member_uid, current_droid.droid_uid, milliseconds) socketio.emit('my_response', {'data': 'Finish!'}, namespace='/comms') socketio.emit('reload_results', {'data': 'reload results'}, namespace='/comms') socketio.emit('reload_current', {'data': 'reload current'}, namespace='/comms') run_details = database.current_run(current_run) if __debug__: print("**** Run Details: %s" % run_details) if database.is_top(current_run) == "yes": broadcast.broadcast_message(b'rainbow') socketio.emit('special_display', {'data': 'toprun'}, namespace='/comms') socketio.emit('my_response', {'data': '**** TOP RUN ****'}, namespace='/comms') if run_details["final_time"] > 120000: socketio.emit('special_display', {'data': 'slow'}, namespace='/comms') socketio.emit('my_response', {'data': '**** SLOOOOOOOOOOW ****'}, namespace='/comms') if run_details["num_penalties"] > 6: socketio.emit('special_display', {'data': 'pinball'}, namespace='/comms') socketio.emit('my_response', {'data': '**** PINBALL DROID ****'}, namespace='/comms') current_state = 4 if cmd == 'RESET': current_run = 0 current_state = 0 current_droid = Droid(droid_uid=0, member_uid=0, name="none", material="none", weight="none", transmitter_type="none") current_member = Driver(member_uid=0, name="none", email="none") socketio.emit('my_response', {'data': 'Resetting'}, namespace='/comms') socketio.emit('reload_results', {'data': 'reload results'}, namespace='/comms') socketio.emit('reload_contender', {'data': 'reload contender'}, namespace='/comms') socketio.emit('reload_current', {'data': 'reload current'}, namespace='/comms') socketio.emit('reload_gates', {'data': 'reload current'}, namespace='/comms') broadcast.broadcast_message(b'reset') socketio.emit('reload_current', {'data': 'reload current'}, namespace='/comms') return "Ok"
async def configure_the_database(self, ctx): database.run() await self.bot.say("Ok!")
#Uygulama başlayınca veritabanı dosyasından çağrılır ve veritabanı oluşturulur. import database as Db import sqlite3 Db.run() # Veritabanına bağlanılır verilerin çekilmesine başlanır with sqlite3.connect("database.db") as conn: cur = conn.cursor() # Vertabanında hata olması veya kapalı olması durumu için try: cur.execute("SELECT * FROM urunler") # gelen veriyi aldık data = cur.fetchall() cur.execute("SELECT name FROM pragma_table_info('urunler')") __temp__ = cur.fetchall() # Tablo keylerinin islenmesi. keys = [] for i in range(len(__temp__)): # Duzgun bir formata sokmak icin string islemi. keys.append(str(__temp__[i])[2:-3]) except Exception as e: print(e) # Html dökumanı burada oluşturulur html_file = open("html.html", "w") html_file.write(f""" <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8">