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](https://github.com/Mytherin/Tibialyzer) TibiaWiki parsing script.
This script fetches data from TibiaWiki via its API, compared to relying on [database dumps](http://tibia.wikia.com/wiki/Special:Statistics)
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.
[![Build Status](https://travis-ci.org/Galarzaa90/tibiawiki-sql.svg?branch=master)](https://travis-ci.org/Galarzaa90/tibiawiki-sql)
[![GitHub (pre-)release](https://img.shields.io/github/release/Galarzaa90/tibiawiki-sql/all.svg)](https://github.com/Galarzaa90/tibiawiki-sql/releases)
[![PyPI](https://img.shields.io/pypi/v/tibiawikisql.svg)](https://pypi.python.org/pypi/tibiawikisql/)
![PyPI - Python Version](https://img.shields.io/pypi/pyversions/tibiawikisql.svg)
![PyPI - License](https://img.shields.io/pypi/l/tibiawikisql.svg)
## Requirements
* Python 3.6 or higher
* **requests** module
## Running the script
There's two ways to run the script:
The first one is to clone or download this repository, and running the file `run.py.
The second way is to install the module from pypi:
```sh
python -m pip install tibiawikisql
```
Once installed, you can run the command anywhere using:
```sh
python -m tibiawikisql
```
The process can be long, taking up to 20 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.
When done, a database file called `tibia_database.db` will be found on the folder.
## Database contents
* Creatures
* Items
* Creature drop statistics
* NPCs
* NPC offers
* Spells
* Houses
* Achievements
* Quests
## Database schema
See [schema.md](docs/schema.md) in the `docs` folder
## 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](http://tibia.wikia.com).
Script that generates a sqlite database for the MMO Tibia.
Inspired in [Mytherin's Tibiaylzer](https://github.com/Mytherin/Tibialyzer) TibiaWiki parsing script.
This script fetches data from TibiaWiki via its API, compared to relying on [database dumps](http://tibia.wikia.com/wiki/Special:Statistics)
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.
[![Build Status](https://travis-ci.org/Galarzaa90/tibiawiki-sql.svg?branch=master)](https://travis-ci.org/Galarzaa90/tibiawiki-sql)
[![GitHub (pre-)release](https://img.shields.io/github/release/Galarzaa90/tibiawiki-sql/all.svg)](https://github.com/Galarzaa90/tibiawiki-sql/releases)
[![PyPI](https://img.shields.io/pypi/v/tibiawikisql.svg)](https://pypi.python.org/pypi/tibiawikisql/)
![PyPI - Python Version](https://img.shields.io/pypi/pyversions/tibiawikisql.svg)
![PyPI - License](https://img.shields.io/pypi/l/tibiawikisql.svg)
## Requirements
* Python 3.6 or higher
* **requests** module
## Running the script
There's two ways to run the script:
The first one is to clone or download this repository, and running the file `run.py.
The second way is to install the module from pypi:
```sh
python -m pip install tibiawikisql
```
Once installed, you can run the command anywhere using:
```sh
python -m tibiawikisql
```
The process can be long, taking up to 20 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.
When done, a database file called `tibia_database.db` will be found on the folder.
## Database contents
* Creatures
* Items
* Creature drop statistics
* NPCs
* NPC offers
* Spells
* Houses
* Achievements
* Quests
## Database schema
See [schema.md](docs/schema.md) in the `docs` folder
## 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](http://tibia.wikia.com).
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distributions
No source distribution files available for this release.See tutorial on generating distribution archives.
Built Distribution
Close
Hashes for tibiawikisql-1.0.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6b278b274cc6d9e3f3d5c389dafc9715f8e8a1b91be2ecb384cbedf10b63420a |
|
MD5 | e2d3d0a3bf2bbf0feb718de5d17ffd8e |
|
BLAKE2b-256 | 330da85f713059d20e43fb01577c55610f514460ec63a4e0e7c913c0346f047d |