ecms-api 0.2.2

A python integration to allow for quickly sending queries directly to the as400

ECMS-API

ECMS-API is a query wrapper that allows for querying the AS400 directly

Authors

Johnny Whitworth (@Poseidon-dev)

How to use Examples

Select

table = SQLQuery(HRTEMP)
query = table.select()

query.filters(employeeno=12345, companyno=50, divisionno=2)
query.columns(['CompanyNo', 'DivisionNo', 'EmployeeNo', 'City'])
query.order(by='City')
query.head()

response = query.query()

Returns the command and corresponding values:

SELECT
COMPANYNO, DIVISIONNO, EMPLOYEENO, CITY FROM CMSFIL.HRTEMP
WHERE EMPLOYEENO = '12345' AND COMPANYNO = '50' AND DIVISIONNO = '2' ORDER BY City ASC LIMIT 10

The select method also allows for queried data to be saved as an excel doc using .to_excel() rather than .query()

Update

table = SQLQuery(HRTEMP)
query = table.update()

query.sets(City='SomeCity', companyno=50)
query.filters(employeeno=12345)
query.query()

Will execute the following:

UPDATE
CMSFIL.HRTEMP
SET CITY = 'SomeCity' , COMPANYNO = '50' WHERE EMPLOYEENO = '12345'

Support

If you need some help for something, please reach out to me directly or submit an issue and I'll get to it as soon as I can

Site

https://poseidon-dev.github.io/ecms-api/