pyetldb 0.1

Python module that allows an easy interconnection between Microsoft Access and a support server for SQL with data sync

PyETL: --. Version: 0.1

---

Table of Contents

• Getting Started
  • Illustrative Usage
  • Application Programming Interface
  • Usage
  • Examples
• Application Backlog
• 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.