This is an attempt to convert the OEC into a relative SQL DATABASE.

The main repository: https://github.com/ziphead/Exoscanner

Stable versions will be pushed here.

Everyone is welcomed to help me with the development.

Exoscanner is a python program, which creates mysql tables in your database and fills them with data from the Open Exoplanet Catalogue. https://github.com/OpenExoplanetCatalogue/open_exoplanet_catalogue. It preserves relations between bodies in systems by separating system, star , binary, planet data into 4 tables related with foreign keys. Exoscanner is not a replacement for The OEC. Maybe another instance or a tool to make your own exoplanet SQL database. File "models.py" contains all the tags for each model and you can freely remove some of them or add yours then built your own database with data you need for specific calculations or for a personal web page.

Used python modules:

• lxml
• peewee

0.1.0 (Alpha)

• separation tag value overwrites in database (in progress)

Tested with Ubuntu 14.4

Before launching this program please make sure you have done the following preparations:

1. Working mysql server on your localhost or on a distant server.

2. Exoscanner cooks tables only. You'll need to create a new database or use an existing one. Give mysql user the priviliges to insert, delete and alter table.

3. Exoscanner is a python 2.7 code. It uses two libraries which are not icluded in the standart python package. You have to install them manualy with pip.

$ sudo apt-get install python-pip 

$ pip install peewee
$ pip install lxml

4. Download Exoscanner folder then download and extract open exoplanet catalogue (https://github.com/OpenExoplanetCatalogue/oec_gzip/raw/master/systems.xml.gz)

5. Open models.py and type your mysql database name, username and password

6. launch exo.py

$ python exo.py

7. Check out

$ python control.py

• Control module (in progress)
• Update pattern to keep db up-to-date.

Contacts

• [Yury Milto] [email protected]