Skip to main content
Donate to the Python Software Foundation or Purchase a PyCharm License to Benefit the PSF! Donate Now

Python package for the Dell RPA Team

Project description

Dell Python RPA Package

What is it?

This Python package serves as a toolkit with custom built with functions useful to different teams within Dell.

Getting Started

  1. Install the package while off of the corporate network using:

    pip install dell_python_rpa -U
    
  2. Create a file in the python project directory where you will be importing this package named "configuration.yml" which houses your network credentials in the following format

    Do not store this file in a shared directory

    credentials:
      user_name: 'example_username'
      password: 'example_password'
    

Usage

Examples using these functions

MIDAS API Module

This module is a wrapper for a Dell internal API to get real-time order information from OFS and BOSS. To utilize it, pass a python list of Order Numbers into each function along with a parameter of to get order data returned in the form of a Pandas Dataframe . This includes all 5 web-service APIs currently exposed by MIDAS designed to return all information about the status, attributes, or history of an order.

# Importing Order Status Module
from dell_python_rpa.order_status import * 

orders=['208432234','208435401','208457058']

general_order_info=get_order_info(orders)

ofs=get_ofs_status(orders)

boss_status=get_boss_status(orders)

properties=get_ofs_properties(orders)

boss_status_history=get_boss_status_history(orders)

GPP Functions

This module includes functions which are useful to the Global Production Planning Organization including querying Michael Bishop's DB and getting the latest CSR Data.

# Importing GPP Module
from dell_python_rpa.gpp import * 

# Query Michael Bishops Database, results are a Pandas Dataframe
# By default, the function will query the "BACKLOG" database
# Use the db_name parameter if to specify a different db if necessary

directory_of_sql_file='Queries\gpp_bishop_example.sql'
result=bishops_query(directory_of_sql_file)

# Get current CSR data in Pandas Dataframe
csr=get_csr()

UDM

This module includes the functionality to execute a query on the UDM/FDL Oracle database. The data returned will be in the datatype of a Pandas Dataframe. In order to use this module, you will need access to the database and the 'configuration.yml' file discussed above in the same directory as the python file calling the udm function. The udm_query_2 function is the latest generation version which takes the directory of a SQL file as a parameter and also allows a second parameter which allows you to modify the query at runtime with parameters which can be calculated as part of your program. It does this by replacing the text -- INSERTVALUEHERE in your sql query, so if you are going to use this capability, please include that string in your file.

# Importing UDM Module
from dell_python_rpa.udm import * 

# Execute a query without modifying it
directory_of_sql_file='Queries\example_sql_file.sql'
result=udm_query_2(directory_of_sql_file)

# Modify a query before executing it
directory_of_sql_file='Queries\example_sql_file.sql'

query_modifier='AND SO.SYSTEM_QTY > 10'
result=udm_query_2(directory_of_sql_file, query_modifier)

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Filename, size & hash SHA256 hash help File type Python version Upload date
dell_python_rpa-0.52-py3-none-any.whl (12.2 kB) Copy SHA256 hash SHA256 Wheel py3

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN SignalFx SignalFx Supporter DigiCert DigiCert EV certificate StatusPage StatusPage Status page