I added a working database, because the current database was completely different from the ERD. #42
I made following commands work wit hthe database:
/register, /pay, /where_am_i
Modified data.py to store guild_names, instead of guild objects.
Additions[^3]
Added database.py with useful functions to access the database.
Added sql/setup_database.sql that (re)creates the database following the documentation. This also inserts default rows, namely guilds and planets.
Added sql/setup_ethb.sql that creates an user to use with the database.
Added sql/README.org where the installation is documented.
Additional remarks[^4]
database.py uses the config.json, so update your config accordingly to what is in setup_ethb.sql.
[^1]: Description of the pull request.
[^2]: Modifications, commands modified and explanation.
[^3]: Files added, commands added and explanation.
[^4]: Additional remarks (e. a. documentation needs to be updated)
Description[^1]
issue: #27
Modifications[^2]
I added a working database, because the current database was completely different from the ERD. #42 I made following commands work wit hthe database:
/register,/pay,/where_am_iModifieddata.pyto store guild_names, instead of guild objects.Additions[^3]
Added
database.pywith useful functions to access the database. Addedsql/setup_database.sqlthat (re)creates the database following the documentation. This also inserts default rows, namely guilds and planets. Addedsql/setup_ethb.sqlthat creates an user to use with the database. Addedsql/README.orgwhere the installation is documented.Additional remarks[^4]
database.pyuses the config.json, so update your config accordingly to what is insetup_ethb.sql.[^1]: Description of the pull request. [^2]: Modifications, commands modified and explanation. [^3]: Files added, commands added and explanation. [^4]: Additional remarks (e. a. documentation needs to be updated)