async def showRepeatingEvents(ctx):
"""
shows repeating events by pm.
"""
await ctx.send("repeating events have been send by pm.")
db = databasefunctions.DatabaseFunctions("events.db")
repeating_events_list = db.getRepeatingEvents()
stringRepresentation = ""
weekdays = {
0: "monday",
1: "tuesday",
2: "wednesday",
3: "thursday",
4: "friday",
5: "saturday",
6: "sunday",
None: "every day."
}
for i in repeating_events_list:
if int(client.get_channel(int(i[1])).guild.id) == int(ctx.guild.id):
if len(stringRepresentation) >= 1000:
await ctx.author.send(stringRepresentation)
stringRepresentation = ""
stringRepresentation += "id: " + str(i[6]) + ", name: " + str(
i[0]) + ", channel:" + str(client.get_channel(int(i[1])))
stringRepresentation += ", time: " + str(i[2].hour) + ":" + str(
i[2].minute) + ", minutes before announcement: " + str(
i[4]) + ", weekday:" + weekdays[i[5]] + "\n"
await ctx.author.send(stringRepresentation)
async def deleteRepeatingEvent(ctx, id):
"""
deletes a repeating event.
parameter id.
"""
db = databasefunctions.DatabaseFunctions("events.db")
await ctx.send(db.deleteRepeatingEvent(id, ctx))
async def showAllEvents(ctx):
"""
shows all events for debugging purposes to kevin123456#2069 only.
"""
await ctx.send(
str(
databasefunctions.DatabaseFunctions("events.db").showAllEvents(
ctx.message.author.id)))
async def showEvents(ctx):
"""
shows all events happening on the channel where this command is used.
"""
await ctx.send(
str(
databasefunctions.DatabaseFunctions("events.db").showEvents(
ctx, client)))
async def removeChannel(ctx):
"""
removes a channel from the database.
"""
db = databasefunctions.DatabaseFunctions("events.db")
query = "DELETE FROM repeating_events WHERE channel = "
query += str(ctx.channel.id)
db.executeQuery(query)
query = "DELETE FROM events WHERE channel = "
query += str(ctx.channel.id)
await ctx.send(db.removeChannel(ctx))
async def addRepeatingEvent(ctx,
thetime,
minsbeforeAnnouncement,
weekday=None,
*thename):
"""
adds a repeating event.
parameters:time, minutes before announcement, weekday as string, the name.
"""
name = ""
#converting none as string to None.
if weekday == "none":
weekday = None
for i in thename:
name += " " + str(i)
daystuff = {
"monday": 0,
"tuesday": 1,
"wednesday": 2,
"thursday": 3,
"friday": 4,
"saturday": 5,
"sunday": 6,
None: None
}
if ":" not in thetime:
await ctx.send("must have the form 'hh:mm'")
else:
thetime = thetime.replace("\n", "")
timelist = thetime.split(':')
passed = True
try:
print(daystuff[weekday])
except:
await ctx.send(str(weekday) + " is not a known day.")
passed = False
if passed:
databasefunctions.DatabaseFunctions("events.db").addRepeatingEvent(
name, ctx.channel.id, thetime, minsbeforeAnnouncement,
daystuff[weekday])
something = datetime.datetime(year=2000,
month=5,
day=5,
hour=int(timelist[0]),
minute=int(timelist[1]))
somet = something - datetime.timedelta(
minutes=int(minsbeforeAnnouncement))
await ctx.send("repeating event added and will be announced on " +
str(somet.hour) + ":" + str(somet.minute) +
" every " + str(weekday))
else:
await ctx.send(
"Invalid day. possible days: monday, tuesday, wednesday, thursday, friday, saturday, sunday, none (note this must be the text none)"
)
async def deleteEvent(ctx, eventid):
"""
deletes an event. parameter event id.
"""
try:
eventid = int(eventid)
except:
await ctx.send(
"eventid should be a number. see /showEvents to view the id's of events."
)
await ctx.send(
str(
databasefunctions.DatabaseFunctions("events.db").deleteEvent(
eventid, ctx)))
def __init__(self):
"""
attributes:
db, databasefunctions.DatabaseFunctions object.
events, list of AnnounceObjects
thisday, int date day.
client, discord.Client()
"""
self.db = databasefunctions.DatabaseFunctions("events.db")
dt = datetime.datetime.now(tz=datetime.timezone.utc)
self.events = []
self.thisday = datetime.datetime.now(tz=datetime.timezone.utc).day
self.createDaily()
self.fetchEvents()
self.client = discord.Client()
async def addChannel(ctx, role):
"""
adds a channel.
parameter: role.
"""
role = role.replace("\n", "")
if "@" not in role:
role = "@" + role
try:
databasefunctions.DatabaseFunctions("events.db").addChannel(
ctx.channel.id, ctx.guild.id, role)
await ctx.send(str(ctx.channel) + " added to channels.")
except:
await ctx.send("channel already added.")
async def executeQuery(ctx, *query):
"""
executing a query by discord, for admin only.
"""
if ctx.author.id == 300644437334425601:
stuff = ""
for i in query:
stuff += " " + str(i)
db = databasefunctions.DatabaseFunctions("events.db")
try:
await ctx.send("query succesfull." + str(db.executeQuery(stuff)))
except:
print(stuff)
await ctx.send("query failed.")
else:
await ctx.send("you have no permission to do that.")
async def addEventFromNow(ctx, time, announceminsbefore, *thename):
"""
adds event from now +the given time.
parameters time, minutes before announcement, the name.
"""
allowed = allowedToAdd(ctx)
if allowed[1]:
#since every space in the name is looked at like a new argument the name is stored as a list and will be assembled and made as a string.
name = ""
for i in thename:
name += str(i) + " "
#converting hh:mm to minutes.
toMinutes = int(time.split(":")[0]) * 60 + int(time.split(":")[1])
#making the datetime of the event.
timeEvent = datetime.datetime.now(
datetime.timezone.utc) + datetime.timedelta(minutes=toMinutes)
timeEvent = datetime.datetime(year=timeEvent.year,
month=timeEvent.month,
day=timeEvent.day,
hour=timeEvent.hour,
minute=timeEvent.minute,
second=timeEvent.second,
tzinfo=datetime.timezone.utc)
try: #try writing to the database..
databasefunctions.DatabaseFunctions("events.db").addEvent(
name, allowed[2], timeEvent, int(announceminsbefore))
await ctx.send("event added and will be announced on " +
str(timeEvent - datetime.timedelta(
minutes=int(announceminsbefore))))
except:
print("time:" + str(time) + "minsbeforeevent:" +
str(announceminsbefore) + " name: " + str(thename))
await ctx.send(
"Failed. Please check /help to view what arguments must be used for this command."
)
else:
await ctx.send(allowed[0])
async def addEvent(ctx, date, time, announceminsbefore, *thename):
"""
adds event.
parameters date, time, minutes before announcement, the name.
"""
#since every space in the name is looked at like a new argument the name is stored as a list and will be assembled and made as a string.
allowed = allowedToAdd(ctx)
if allowed[1]:
name = ""
for i in thename:
name += str(i) + " "
#converting string to datetime.datetime object.
temptime = datetime.datetime.strptime(str(date + " " + time),
'%m-%d %H:%M')
now = datetime.datetime.now(tz=datetime.timezone.utc)
#converting to the actual time containing the year as well.
realtime = datetime.datetime(year=now.year,
month=temptime.month,
day=temptime.day,
hour=temptime.hour,
minute=temptime.minute,
second=00,
tzinfo=datetime.timezone.utc)
databasefunctions.DatabaseFunctions("events.db").addEvent(
name, allowed[2], realtime, announceminsbefore)
await ctx.send(allowed[0])
await ctx.send("will be announced on " +
str(realtime - datetime.timedelta(
minutes=int(announceminsbefore))))
#print("date: " + str(date) + " time:" + str(time) + "minsbeforeevent:" + str(announceminsbefore) + " name: " + str(thename))
# await ctx.send("Failed. Please check /help to view what arguments must be used for this command.")
else:
await ctx.send(allowed[0])
def allowedToAdd(ctx):
"""
checks if its possible to add an event on that channel.
returns string of info on first
returns boolean if its possible to add the event on second
returns channel id on where the event is added on if the above boolean is true.
"""
query = "SELECT count(guild) FROM servers WHERE guild = "
query += str(ctx.guild.id)
d = databasefunctions.DatabaseFunctions('events.db')
result = d.executeQuery(query)[0][0]
if result == 1:
query = "SELECT count(guild) FROM servers WHERE guild = " + str(
ctx.guild.id) + " AND id = " + str(ctx.channel.id)
result = d.executeQuery(query)[0][0]
if result == 0:
query = "SELECT id FROM servers WHERE guild = "
query += str(ctx.guild.id)
result = int(d.executeQuery(query)[0][0])
return "the event will be announced on " + str(
client.get_channel(result)
) + ". (do /addServer to register this channel too.)", True, result
else:
return "event added and will be announced on this channel.", True, ctx.channel.id
elif result == 0:
return "register a channel to announce things on this server.", False
elif result >= 2:
result = d.executeQuery("SELECT count(id) FROM servers WHERE id = " +
str(ctx.channel.id))[0][0]
if result == 0:
return "you can only register events on a registered channel (do /addChannel)", False
else:
return "event added.", True, ctx.channel.id
else:
return "what the f**k did you do", False
async def migrate(ctx):
await ctx.send("starting migration to another channel...")
db = databasefunctions.DatabaseFunctions("events.db")
await ctx.send(db.migrate(ctx))
async def showChannels(ctx):
"""
show all the added channels on a server.
"""
db = databasefunctions.DatabaseFunctions("events.db")
await ctx.send(db.showChannels(ctx, client))
def test1():
channels = [737712298315087924, 698615458714222631, 652087685124456452]
db = databasefunctions.DatabaseFunctions("events.db")
for i in range(1000):
db.addEvent(nameGenerator(), random.choice(channels), dateGenerator(),
random.randint(12, 30))
