Skip to main content

Python script that generates a SQLite database from TibiaWiki articles

Project description

tibiawiki-sql

Script that generates a sqlite database for the MMO Tibia.

Inspired in Mytherin's Tibiaylzer TibiaWiki parsing script.

This script fetches data from TibiaWiki via its API, compared to relying on database dumps that are not updated as frequently. By using the API, the data obtained is always fresh.

This script is not intended to be running constantly, it is meant to be run once, generate a sqlite database and use it externally.

If you integrate this into your project or use the generated data, make sure to credit TibiaWiki and its contributors.

GitHub (pre-)release PyPI PyPI - Python Version PyPI - License PyPI - Downloads

Requirements

  • Python 3.10 or higher

Installing

To install the latest version on PyPi:

pip install tibiawikisql

or

Install the latest version from GitHub

pip install git+https://github.com/Galarzaa90/tibiawiki-sql.git

Running

python -m tibiawikisql generate

OR

tibiawikisql

The process can be long, taking up to 10 minutes the first time. All images are saved to the images folder. On subsequent runs, images will be read from disk instead of being fetched from TibiaWiki again. If a newer version of the image has been uploaded, it will be updated.

When done, a database file called tibiawiki.db will be found on the folder.

Docker

Docker Pulls Docker Image Size (latest semver)

The database can also be generated without installing the project, it's dependencies, or Python, by using Docker. Make sure to have Docker installed, then simply run:

generateWithDocker.sh

The script will build a Docker image and run the script inside a container. The tibiawiki.db file will end up in the project's root directory as normal.

Database contents

  • Achievements
  • Charms
  • Creatures
  • Creature drop statistics
  • Houses
  • Imbuements
  • Items
  • Mounts
  • NPCs
  • NPC offers
  • Outfits
  • Quests
  • Spells
  • Updates
  • Worlds

Documentation

Check out the documentation page.

Contributing

Improvements and bug fixes are welcome, via pull requests
For questions, suggestions and bug reports, submit an issue.

The best way to contribute to this project is by contributing to TibiaWiki.

image

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

tibiawikisql-7.0.2.tar.gz (60.9 kB view details)

Uploaded Source

Built Distribution

tibiawikisql-7.0.2-py3-none-any.whl (70.2 kB view details)

Uploaded Python 3

File details

Details for the file tibiawikisql-7.0.2.tar.gz.

File metadata

  • Download URL: tibiawikisql-7.0.2.tar.gz
  • Upload date:
  • Size: 60.9 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.1.0 CPython/3.12.9

File hashes

Hashes for tibiawikisql-7.0.2.tar.gz
Algorithm Hash digest
SHA256 0e8e5a4f844750ae6dc480aab9f4fba0f04aaa864c36e58b6ef54d6a31f9b323
MD5 df0139c7a8e35fae9c911c217c947264
BLAKE2b-256 5585377cc8943752a1604837ee6bebfc00a3af499fa23897aea63346d234846e

See more details on using hashes here.

File details

Details for the file tibiawikisql-7.0.2-py3-none-any.whl.

File metadata

  • Download URL: tibiawikisql-7.0.2-py3-none-any.whl
  • Upload date:
  • Size: 70.2 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.1.0 CPython/3.12.9

File hashes

Hashes for tibiawikisql-7.0.2-py3-none-any.whl
Algorithm Hash digest
SHA256 edadcd4a08d6c0fb44683719a1cacb5449da4222478b0313190189ef64ee9fcd
MD5 e340dd10ab1079107daaf8d0f4993f74
BLAKE2b-256 452fdd377d7a0f99950cf1d7e0b33069addf8d400205bd142c589011ab3df8ca

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page