SQLite-Discord-Bot
SQLite-Discord-Bot copied to clipboard
YonLiud
Discord Database Bot is a discord bot, able to connect and execute any SQLite Database through simple chat commands
SQLite Discord Bot
SQLite Discord Bot is a discord bot, able to connect and manage any SQLite Database.
- No Premium
- Access to SQLite .db file
- Full SQLite shell access
About
SQLite Discord Bot is a lightweight python based bot that's built by Yon Liud for easier access to SQLite Shell, without the hassle of remote accessing. A simple setup is required for running the bot,
Setup
SQLite Discord Bot uses a small number of python modules to work properly:
- Valid Token - A Valid discord bot
- Python - Python, duh
- Discord.py - Discord Module
- SQLite3 - The Database Library
And of course SQLite Discord Bot itself is open source with a public repository on GitHub.
Installation
SQLite Discord Bot requires Python3 & Discord.py to run.
Install the modules.
$ cd Discord-Database-Bot
$ pip3 install -r requirements.txt
Insert bot's token
How to get a token: https://discordpy.readthedocs.io/en/latest/discord.html
After recieving the token, open the SQLite-Discord-Bot Folder & replace your token into the .env file
Example of token inside the .env:
TOKEN=NzU0NjIzNTQzNTI2MDMxNDgy.X13b8Q.e0V0cwwmc_BYeMHwvJovFQhLBfk
(the token is no longer valid, DO NOT ATTEMPT TO INSERT TOKEN TO PROJECT)
Running Bot
$ python3 app.py
The bot will create a role called 'dmb'
In Server Use
For being able to execute any command by SQLite Discord Bot, you must assign users with the created 'dmb' role,
for help:
sql>help
Basic Commands
| Name | Syntax |
|---|---|
| Create Table | sql>CREATE TABLE IF NOT EXISTS name (parameters) |
| Select a Value from Table | sql>SELECT column-name FROM table-name WHERE type='identifier' |
| Insert a Value to row | sql>NSERT INTO table-name (parameters) VALUES (values of parameters) |
If you require additional help with command, check out this SQLite Cheat Sheet
Help
for help, run the command sql>help,
for support, please contact me at my Discord! y0nliud#1545. Hopefully I will be able to assist you!
License
MIT
Free Software, Hell Yeah!
YonLiud