a tools for ami
Project description
1 how to use
if __name__ == "__main__":
AmimanagerDB = "your manager connection here"
G2CN_str = "your business db"
loader = DbLoader()
dv = loader.load(AmimanagerDB,"1",G2CN_str)
dv.addQueryField("Actual_receive_point","Cat4_name","Cust_ship_to_name")
Order_date = DvFilter("Order_date").GREATER_THAN('2019-01-01')
Cust_no = DvFilter("Cust_no").Equal_to("wu~~~~")
Order_date.AND(Cust_no)
dv.addFilter("Disp_order_date").Equal_to("2019-01-01").AND(Order_date)
print(dv.filter.text)
print(dv.query(top=-1,temp_table_name="-1"))
2.how to load from xml
factory = XMLFactory("./test.xml")
dvm = factory.Build()
3.how to generate a xml from a dvid
# self.AmimanagerDB == connection string
tools = dv2xml.dv2xml(self.AmimanagerDB,1)
tools.run("./test.xml")
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
netsdldv-0.0.8.1.tar.gz
(7.7 kB
view hashes)
Built Distribution
netsdldv-0.0.8.1-py3-none-any.whl
(10.1 kB
view hashes)
Close
Hashes for netsdldv-0.0.8.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0acfc5781ea40b49a212e06844bf798e8dade58267499e92353f537ff35b956a |
|
MD5 | c433a9abf7fb25ba3e245ebb3b3898a1 |
|
BLAKE2b-256 | e3890f6d6ecce02369d94b0c6819d30889ec4a68bd82b583182e7e295caeb348 |