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">
