Metadata-Version: 2.1
Name: pyetldb
Version: 0.1
Summary: Python module that allows an easy interconnection between Microsoft Access and a support server for SQL with data sync
Home-page: https://github.com/natanaelfneto/pyetldb
Author: natanaelfneto
Author-email: natanaelfneto@outlook.com
License: MIT
Platform: UNKNOWN
Classifier: Programming Language :: Python :: 3
Classifier: License :: OSI Approved :: MIT License
Classifier: Operating System :: OS Independent
Description-Content-Type: text/markdown
Requires-Dist: cx-Oracle
Requires-Dist: mysqlclient
Requires-Dist: psycopg2
Requires-Dist: pyodbc
Requires-Dist: pypyodbc

<p align="left">
  <a href="#">
    <img 
      alt="pyeltdb-logo" 
      src="https://raw.githubusercontent.com/natanaelfneto/pyeltdb/pyeltdb-logo.png" 
      width="240"/>
  </a>
</p>

**PyETL**: --.
Version: **0.1**
***
# Table of Contents
* [Getting Started](#getting-started)
    * [Illustrative Usage](#illustrative-usage)
    * [Application Programming Interface](#application-programming-interface)
    * [Usage](#usage)
    * [Examples](#examples)
* [Application Backlog](#application-backlog)
* [License](#license)
***
## Getting Started
### Illustrative Usage
### Application Programming Interface
### Usage
### Examples
## Application Backlog
_Considering: EP as Enhancement Proposal_
-   item:           `EP-001`\
    descrtption:    `connect to a MS Access database using 64 bits ODBC drivers with python 3+ 64 bits`
    status:         [**PENDING**]
-   item:           `EP-002`\
    descrtption:    `connect to a MS Access database using 32 bits ODBC drivers with python 3+ 32 bits`
    status:         [**PENDING**]
-   item:           `EP-003`\
    descrtption:    `retrieve all schemas availavle in MS Access file`
    status:         [**PENDING**]
-   item:           `EP-004`\
    descrtption:    `retrieve all tables availavle in MS Access file schemaa`
    status:         [**PENDING**]
-   item:           `EP-005`\
    descrtption:    `retrieve all columns availavle in MS Access file tablea`
    status:         [**PENDING**]
-   item:           `EP-006`\
    descrtption:    `retrieve all rows availavle in MS Access file tablea`
    status:         [**PENDING**]
-   item:           `EP-007`\
    descrtption:    `map all datatypes available in MS Access as dictionary to enable data conversion`
    status:         [**PENDING**]
-   item:           `EP-008`\
    descrtption:    `create new MS Access file (database) with retrieved data`
    status:         [**PENDING**]
-   item:           `EP-009`\
    descrtption:    `create new MS Access schema in database with retrieved data`
    status:         [**PENDING**]
-   item:           `EP-010`\
    descrtption:    `create new MS Access table in schema with retrieved data`
    status:         [**PENDING**]
-   item:           `EP-011`\
    descrtption:    `create new MS Access column in table with retrieved data`
    status:         [**PENDING**]
-   item:           `EP-012`\
    descrtption:    `create new MS Access row in table with retrieved data`
    status:         [**PENDING**]
-   item:           `EP-013`\
    descrtption:    `update existing MS Access data in table with retrieved data`
    status:         [**PENDING**]
-   item:           `EP-014`\
    descrtption:    `connect to a Postgres 10 database using psycopg2 package with python 3+ 64 bits`
    status:         [**PENDING**]
-   item:           `EP-015`\
    descrtption:    `connect to a Postgres 10 database using psycopg2 package with python 3+ 32 bits`
    status:         [**PENDING**]
-   item:           `EP-016`\
    descrtption:    `retrieve all databases available in Postgres 10 connection`
    status:         [**PENDING**]
-   item:           `EP-017`\
    descrtption:    `retrieve all schemas available in Postgres 10 database`
    status:         [**PENDING**]
-   item:           `EP-018`\
    descrtption:    `retrieve all tables available in Postgres 10 schema`
    status:         [**PENDING**]
-   item:           `EP-019`\
    descrtption:    `retrieva all columns available in Postgres 10 table`
    status:         [**PENDING**]
-   item:           `EP-020`\
    descrtption:    `retrieve all row available in Postgres 10 table`
    status:         [**PENDING**]
-   item:           `EP-021`\
    descrtption:    `map all datatypes available in Postgres 10 as dictionary to enable data conversion`
    status:         [**PENDING**]
-   item:           `EP-022`\
    descrtption:    `create new Postgres 10 database with retrieved data`
    status:         [**PENDING**]
-   item:           `EP-023`\
    descrtption:    `create new Postgres 10 schema in database with retrieved data`
    status:         [**PENDING**]
-   item:           `EP-024`\
    descrtption:    `create new Postgres 10 table in schema with retrieved data`
    status:         [**PENDING**]
-   item:           `EP-025`\
    descrtption:    `create new Postgres 10 column in table with retrieved data`
    status:         [**PENDING**]
-   item:           `EP-026`\
    descrtption:    `create new Postgres 10 row in table with retrieved data`
    status:         [**PENDING**]
-   item:           `EP-027`\
    descrtption:    `update existing Postgres 10 data in table with retrieved data`
    status:         [**PENDING**]
-   item:           `EP-028`\
    descrtption:    `connect to a Oracle 12 database using psycopg2 package with python 3+ 64 bits`
    status:         [**PENDING**]
-   item:           `EP-029`\
    descrtption:    `connect to a Oracle 12 database using psycopg2 package with python 3+ 32 bits`
    status:         [**PENDING**]
-   item:           `EP-030`\
    descrtption:    `retrieve all databases available in Oracle 12 connection`
    status:         [**PENDING**]
-   item:           `EP-031`\
    descrtption:    `retrieve all schemas available in Oracle 12 database`
    status:         [**PENDING**]
-   item:           `EP-032`\
    descrtption:    `retrieve all tables available in Oracle 12 schema`
    status:         [**PENDING**]
-   item:           `EP-033`\
    descrtption:    `retrieva all columns available in Oracle 12 table`
    status:         [**PENDING**]
-   item:           `EP-034`\
    descrtption:    `retrieve all row available in Oracle 12 table`
    status:         [**PENDING**]
-   item:           `EP-035`\
    descrtption:    `map all datatypes available in Oracle 12 as dictionary to enable data conversion`
    status:         [**PENDING**]
-   item:           `EP-036`\
    descrtption:    `create new Oracle 12 database with retrieved data`
    status:         [**PENDING**]
-   item:           `EP-037`\
    descrtption:    `create new Oracle 12 schema in database with retrieved data`
    status:         [**PENDING**]
-   item:           `EP-038`\
    descrtption:    `create new Oracle 12 table in schema with retrieved data`
    status:         [**PENDING**]
-   item:           `EP-039`\
    descrtption:    `create new Oracle 12 column in table with retrieved data`
    status:         [**PENDING**]
-   item:           `EP-040`\
    descrtption:    `create new Oracle 12 row in table with retrieved data`
    status:         [**PENDING**]
-   item:           `EP-041`\
    descrtption:    `update existing Oracle 12 data in table with retrieved data`
    status:         [**PENDING**]
-   item:           `EP-042`\
    descrtption:    `connect to a SQL Server 2019 Express database using psycopg2 package with python 3+ 64 bits`
    status:         [**PENDING**]
-   item:           `EP-043`\
    descrtption:    `connect to a SQL Server 2019 Express database using psycopg2 package with python 3+ 32 bits`
    status:         [**PENDING**]
-   item:           `EP-044`\
    descrtption:    `retrieve all databases available in SQL Server 2019 Express connection`
    status:         [**PENDING**]
-   item:           `EP-045`\
    descrtption:    `retrieve all schemas available in SQL Server 2019 Express database`
    status:         [**PENDING**]
-   item:           `EP-046`\
    descrtption:    `retrieve all tables available in SQL Server 2019 Express schema`
    status:         [**PENDING**]
-   item:           `EP-047`\
    descrtption:    `retrieva all columns available in SQL Server 2019 Express table`
    status:         [**PENDING**]
-   item:           `EP-048`\
    descrtption:    `retrieve all row available in SQL Server 2019 Express table`
    status:         [**PENDING**]
-   item:           `EP-049`\
    descrtption:    `map all datatypes available in SQL Server 2019 Express as dictionary to enable data conversion`
    status:         [**PENDING**]
-   item:           `EP-050`\
    descrtption:    `create new SQL Server 2019 Express database with retrieved data`
    status:         [**PENDING**]
-   item:           `EP-051`\
    descrtption:    `create new SQL Server 2019 Express schema in database with retrieved data`
    status:         [**PENDING**]
-   item:           `EP-052`\
    descrtption:    `create new SQL Server 2019 Expresstable in schema with retrieved data`
    status:         [**PENDING**]
-   item:           `EP-053`\
    descrtption:    `create new SQL Server 2019 Express column in table with retrieved data`
    status:         [**PENDING**]
-   item:           `EP-054`\
    descrtption:    `create new SQL Server 2019 Express row in table with retrieved data`
    status:         [**PENDING**]
-   item:           `EP-055`\
    descrtption:    `update existing SQL Server 2019 Express data in table with retrieved data`
    status:         [**PENDING**]
-   item:           `EP-056`\
    descrtption:    `connect to a MySQL 8 database using psycopg2 package with python 3+ 64 bits`
    status:         [**PENDING**]
-   item:           `EP-057`\
    descrtption:    `connect to a MySQL 8 database using psycopg2 package with python 3+ 32 bits`
    status:         [**PENDING**]
-   item:           `EP-058`\
    descrtption:    `retrieve all databases available in MySQL 8connection`
    status:         [**PENDING**]
-   item:           `EP-059`\
    descrtption:    `retrieve all schemas available in MySQL 8 database`
    status:         [**PENDING**]
-   item:           `EP-060`\
    descrtption:    `retrieve all tables available in MySQL 8 schema`
    status:         [**PENDING**]
-   item:           `EP-061`\
    descrtption:    `retrieva all columns available in MySQL 8 table`
    status:         [**PENDING**]
-   item:           `EP-062`\
    descrtption:    `retrieve all row available in MySQL 8 table`
    status:         [**PENDING**]
-   item:           `EP-063`\
    descrtption:    `map all datatypes available in MySQL 8 as dictionary to enable data conversion`
    status:         [**PENDING**]
-   item:           `EP-064`\
    descrtption:    `create new MySQL 8 database with retrieved data`
    status:         [**PENDING**]
-   item:           `EP-065`\
    descrtption:    `create new MySQL 8 schema in database with retrieved data`
    status:         [**PENDING**]
-   item:           `EP-066`\
    descrtption:    `create new MySQL 8 table in schema with retrieved data`
    status:         [**PENDING**]
-   item:           `EP-067`\
    descrtption:    `create new MySQL 8 column in table with retrieved data`
    status:         [**PENDING**]
-   item:           `EP-068`\
    descrtption:    `create new MySQL 8 row in table with retrieved data`
    status:         [**PENDING**]
-   item:           `EP-069`\
    descrtption:    `update existing MySQL 8 data in table with retrieved data`
    status:         [**PENDING**]
-   item:           `EP-070`\
    descrtption:    `connect to a SQLite database using psycopg2 package with python 3+ 64 bits`
    status:         [**PENDING**]
-   item:           `EP-071`\
    descrtption:    `connect to a SQLite database using psycopg2 package with python 3+ 32 bits`
    status:         [**PENDING**]
-   item:           `EP-072`\
    descrtption:    `retrieve all databases available in SSQLite connection`
    status:         [**PENDING**]
-   item:           `EP-073`\
    descrtption:    `retrieve all schemas available in SQLite database`
    status:         [**PENDING**]
-   item:           `EP-074`\
    descrtption:    `retrieve all tables available in SQLite schema`
    status:         [**PENDING**]
-   item:           `EP-075`\
    descrtption:    `retrieva all columns available in SQLite table`
    status:         [**PENDING**]
-   item:           `EP-076`\
    descrtption:    `retrieve all row available in SQLite table`
    status:         [**PENDING**]
-   item:           `EP-077`\
    descrtption:    `map all datatypes available in SQLiteas dictionary to enable data conversion`
    status:         [**PENDING**]
-   item:           `EP-078`\
    descrtption:    `create new SQLite database with retrieved data`
    status:         [**PENDING**]
-   item:           `EP-079`\
    descrtption:    `create new SQLite schema in database with retrieved data`
    status:         [**PENDING**]
-   item:           `EP-080`\
    descrtption:    `create new SQLite table in schema with retrieved data`
    status:         [**PENDING**]
-   item:           `EP-081`\
    descrtption:    `create new SQLite column in table with retrieved data`
    status:         [**PENDING**]
-   item:           `EP-082`\
    descrtption:    `create new SQLite row in table with retrieved data`
    status:         [**PENDING**]
-   item:           `EP-083`\
    descrtption:    `update existing SQLite data in table with retrieved data`
    status:         [**PENDING**]
-   item:           `EP-084`\
    descrtption:    `consolidade all MS Access interaction with a module API standard`
    status:         [**PENDING**]
-   item:           `EP-085`\
    descrtption:    `consolidade all Postgres 10 interaction with a module API standard`
    status:         [**PENDING**]
-   item:           `EP-086`\
    descrtption:    `consolidade all Oracle 12 interaction with a module API standard`
    status:         [**PENDING**]
-   item:           `EP-087`\
    descrtption:    `consolidade all SQL Server ? interaction with a module API standard`
    status:         [**PENDING**]
-   item:           `EP-084`\
    descrtption:    `consolidade all SQLite interaction with a module API standard`
    status:         [**PENDING**]
-   item:           `EP-085`\
    descrtption:    `consolidade all MySQL 8 interaction with a module API standard`
    status:         [**PENDING**]
-   item:           `EP-086`\
    descrtption:    `consolidade all interactions with a module API standard`
    status:         [**PENDING**]
-   item:           `EP-087`\
    descrtption:    `define module API standard for command line interaction`
    status:         [**PENDING**]
-   item:           `EP-086`\
    descrtption:    `define module API standard for module interaction`
    status:         [**PENDING**]
## License
MIT License

Copyright (c) 2017 Natanael F. Neto (natanaelfneto)

Permission is hereby granted, free of charge, to any person obtaining a copy
of this software and associated documentation files (the "Software"), to deal
in the Software without restriction, including without limitation the rights
to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
copies of the Software, and to permit persons to whom the Software is
furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all
copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
SOFTWARE.

