app.py

import sqlite3
from sqlite3 import Error
import discord

from dotenv import dotenv_values

token = dotenv_values(".env")["TOKEN"]
client = discord.Client()

# ? Database

database_file = r"database.db"

def create_connection(db_file):
    try:
        conn = sqlite3.connect(db_file)
        return conn
    except Error as e:
        print(e)

    return conn

conn = create_connection(database_file)

def create_table(conn, create_table_sql):
    try:
        c = conn.cursor()
        c.execute(create_table_sql)
    except Error as e:
        print(e)


def execute_query(query):
    if conn is not None:
        try:            
            output = ""
            c = conn.cursor()
            try:
                c.execute(query)
            except Exception as e:
                return e
            info = c.fetchall()
            conn.commit()
            for value in info:
                output += str(value) + "\n"
            if output=="":
                return "No Output / Empty"
            return output
        except Exception as e:
            return e
    return "Error! the database connection was not created."
        


# ? Discord Bot

@client.event
async def on_ready():
    print('logged in as {0.user}'.format(client))
    guilds = client.guilds
    for guild in guilds:
        for role in guild.roles:
            if role.name.lower() == "dmb".lower():
                break
        else:
            await guild.create_role(name="dmb")

@client.event
async def on_guild_join(guild):
    for role in guild.roles:
        if role.name.lower() == "dmb".lower():
            break
    else:
           await guild.create_role(name="dmb")
      
    



title = 'SQLite Discord Shell'
arg_missing_message = discord.Embed(title=title, description='Arguments are missing')
blue_color = discord.Color.blue()
gray_color = discord.Color.light_gray()
red_color = discord.Color.red()

@client.event
async def on_message(message):




    if message.author == client.user:
        return

    if message.content.startswith('sql>'):
        for role in message.author.roles:
            if role.name == "dmb":
                break
        else:
            await message.channel.send(embed=(discord.Embed(title=title, description="""You are not allowed to use Database Manager Bot without a role called "dmb" """, color=red_color)))
            return

    if message.content == ('sql>help'):
        await message.channel.send(embed=(discord.Embed(title=title, description=""" For Initialization Help, please read project's readme.md:
         https://github.com/YonLiud/Discord-Database-Bot/blob/master/README.md
         For More Help, visit SQLite's website:
         https://www.sqlite.org/doclist.html
         To check my project's cool Website, visit alTab Developers:
         http://www.altab.dev/
         For More Commands, visit this great cheat sheet:
         https://d17h27t6h515a5.cloudfront.net/topher/2016/September/57ed880e_sql-sqlite-commands-cheat-sheet/sql-sqlite-commands-cheat-sheet.pdf
         """, color=blue_color)))
        return

    if message.content.startswith('sql>'):
        query = ""
        for word in message.content.split():
            query += word + " "
        query = query.replace('sql>', '')
        if(query == " "):
            await message.channel.send(embed=arg_missing_message)
            return
        await message.channel.send(embed=(discord.Embed(title=title + " Query Output:", description=str(execute_query(query)), color=gray_color)))

client.run(token)