Skip to content

Excel to PostgreSQL transmitter written on Python 3.7

Notifications You must be signed in to change notification settings

DocMorg/testworkhse

Repository files navigation

testworkhse

Codacy Badge

Excel to PostgreSQL transmitter written on Python 3.7

for help type in command line:

$ python project.py -h

This is the test work, which purpose is to merge data from Microsoft Excel (.xlsx format) data files to PostgreSQL database. It supports creating table with excel file on input {-c}, updating it {-upd} and adding indexes {-ai}. If there is an type intersection in one row during updating or creating, the whole row will be converted to string format. Names of the rows should be on the first line of the file.

To run the program type in command line:

$ python project.py excel.xlsx [-args]

where excel.xlsx - is the MS Excel file entry and -args - argument you need.

In the 'test.py' file are the tests made for this program.