Hi,

First of all thanks for your hard work. However I recently updated my docker image and since then it has been really hard to run the bot, (old docker compose below). I just saw there is a new setup command that can be run from discord, so I guess no need to use DATABASE_TOKEN and AUTH_KEY as environment variables anymore. So I removed them from my docker compose and then the annoying stuff happened. Every time I restart my container I have to run the setup command, the prefix does not work I have to use * everywhere instead of !. ( See screen attached below). I would personally prefer the notion's integration app as environment variable that is probably more secure than discord. Maybe in the future it could be prompted only when the user does not provide it as env 🤷‍♂️.

Thanks for your time, and hope you will be able to fix those issues and update the README file.

Regards

---
version: "3.4"

services:
  notiondiscordbot:
    image: servatom/notiondiscordbot
    container_name: notiondiscordbot
    restart: unless-stopped
    environment:
      - PUID=1000 
      - PGID=1000 
      - TZ=Europe/Paris
      - DATABASE_TOKEN=...  # Can be removed
      - AUTH_KEY=...               # Can be removed
      - DISCORD_AUTH=...      # Need to be change to TOKEN
      - GDRIVE_FOLDER=...
      - PREFIX=!
    volumes:
      - /user/docker/notion-data:/Bot/creds
    security_opt:
      - no-new-privileges:true

Hi I just tried to install properly the bot via docker / and in a local env but I'm getting the same error everytime I run the add cmd:

Ignoring exception in command add:
Traceback (most recent call last):
  File "/home/user/.local/lib/python3.7/site-packages/discord/ext/commands/core.py", line 85, in wrapped
    ret = await coro(*args, **kwargs)
  File "bot.py", line 36, in add
    if((doesItExist(url) == False) and (amIThere(url) == False)):
  File "/home/user/notion/Notion-DiscordBot/Bot/duplicateCheck.py", line 31, in amIThere
    with open("./Bot/dataUploaded.txt") as log:
FileNotFoundError: [Errno 2] No such file or directory: './Bot/dataUploaded.txt'

I decided to remove the "Bot/" in line 31 in Bot/duplicateCheck.py
I replaced with open("./Bot/dataUploaded.txt") as log: to with open("./dataUploaded.txt") as log: and now everything is working fine.

Regards

To prevent duplication of pdf links the file tracker dataUploaded.txt was created that keeps of links. But after restarting the container the file becomes clean. To prevent this, the txt file must be in a persistent volume.

In the current setup, we were storing the guild data in the JSON file to reduce the number of database interactions from each cog. But the issue still was there whereafter any change in the database there were still some extra file operations to be done where the JSON file was updated and each cog had to read the data of the JSON file. Now we are going to store the guild data inside an attribute of the bot object. This will reduce the number of I/O interactions and will make the bot much more faster when dealing with multiple requests across multiple servers

A centrally hosted notion discord bot...which can manage multiple notion databases across multiple different discord servers. The previous version required multiple instances of the bot to run on multiple servers/notion databases. This version eliminates the need for personally hosting the bot.

After adding the bot to your server just run the *setup command and follow the instructions For changing the prefix run: *prefix

For more information refer: README.md

Bumps certifi from 2021.10.8 to 2022.12.7.

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

As suggested with @daemon1024.

Idea

/saveurl on

From here on whatever URLs are shared the links are kept in the database. Yeah will need to clean up 
things regularly, but still would be convenient 

Things that can be implemented

• [ ] A switch command to switch on the bot to listen on a particular server/channel every time.
• [ ] Delete command to delete previous messages containing links.

Create simple tests for the bot. Mainly to verify the API calls that are going to Notion. This is to make the Travis-ci integration useful. This will also let us know if something changed in the Notion API