Establish a connection to GST

Postgres

import GSTPy

# The name of the GST user used as login
user = "gstpy_user"
# The password of that user
password = "gstpy_user_pw"
# The hostname or ip address of the database instance
host = "localhost"
# The port of the database instance
port = 5432
# The name of the database instance
db = "gstpy"

# Call get_pg_connection with the required parameters
ni = GSTPy.get_pg_connection(user, password, host, port, db)

Oracle

import GSTPy

# The name of the GST user used as login
user = "gstpy_user"
# The password of that user
password = "gstpy_user_pw"
# The hostname or ip address of the database instance
host = "localhost"
# The port of the database instance
port = 1521
# The service name of the database instance
service = "gst"
# The schema of the database instance
schema = "gstpy"

# Call get_ora_connection with the required parameters
ni = GSTPy.get_ora_connection(user, password, host, port, service, schema)

GST3

import GSTPy

# The name of the GST user used as login
user = "gstpy_user"
# The password of that user
password = "gstpy_user_pw"
# The hostname or ip address of the gst3 instance
host = "localhost"
# The port of the gst3 instance
port = 50051
# The file path to the DER encoded client SSL certificate
client_cert = r"C:\GST\cert\gst3.der"

# Call get_gst3_connection with the required parameters
ni = GSTPy.get_gst3_connection(user, password, host, port, client_cert)