sql_helper module

class sql_helper.sql_helper

Bases: object

This class contains the necessary supporting funtions to perform SQL related operations.

connect_database()

This function connects to the database on AWS, and authenticates the user.

disconnect_database()

This function closes the database connection once done with it.

run_query(query)

Runs the specified query through the database and returns the output.

Parameters

query (string) – [Requires a valid SQL query passed as an argument.]

Returns

[The output of the query being executed on the database is returned in the form of nested tuples.]

Return type

[Tuple(Tuple..)]