SQL data extraction for Scienti and UdeA Oracle databases
Project description
KayPacha
SQL data extraction for Scienti and Colav parners Oracle databases
Description
Package extract the data from SQL databases from Oracle Databases from Scienti or Colav parners Models are defined here, filters etc..
Installation
Package
pip install kaypacha
Usage
Oracle DB Colav docker database for scienti have to be already loaded, take a look here
Remember you only can use max 2 threads due a Oracle XE version limitation more information here
Saving the model product for scienti on MongoDB
kaypacha_scienti --model_year 2018 --model product --max_threads 2 --checkpoint
Saving all models for scienti on MongoDB
kaypacha_scienti --model_year 2018 --max_threads 2 --checkpoint
Getting a JSon file sample for the model product for scienti (WARNING: getting the full DB in a file require a huge amount of RAM, use it with careful.)
kaypacha_scienti --model_year 2018 --model product --json prod.json --max_threads 2 --sample
Entities models supported fo Scienti
- product (EN_PRODCUTO)
- netowrk (EN_RED)
- project (EN_PROYECTO)
TODO
- implement all the main tables for Scienti.
- event "EN_EVENT"
- resgiter "EN_REGISTRO"
- industrial_secret "EN_SECRETO_INDUSTRIAL"
- recognition "EN_RECONOCIMIENTO"
- event "EN_EVENTO"
- patent "EN_PATENTE"
- art_product "EN_PROD_ARTISTICA_DETALLE"
License
BSD-3-Clause License
Links
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 Distribution
Built Distribution
Hashes for KayPacha-0.0.1a0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e2ef97efe29100aa51a7e5b7789a28e7613ba6ce925fdc240fe601191916bcb0 |
|
MD5 | 81787145f4e92ff0761a2c7ebf4ecf45 |
|
BLAKE2b-256 | b90a14f75422dbbaf57d4cf5a57dcda6b0c282921b48e53257f0d3ffd8e3b202 |