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)