simpleml.utils.postgres module

Util module to manage postgres specific functions

simpleml.utils.postgres.create_database(connection_params, database, owner=None)

Creates a new database :return: None

simpleml.utils.postgres.create_user(connection_params, user, password)

Creates a new user :return: None

simpleml.utils.postgres.drop_database(connection_params, database, force=False)

Drop database – Must have sufficient privileges :return: None

simpleml.utils.postgres.drop_user(connection_params, user)

Drop a user – Must have sufficient privileges :return: None

simpleml.utils.postgres.run_sql_command(connection_params, command, autocommit=False)

Execute command directly using psycopg2 cursor

Parameters:

• connection_params – dict of connection details
• command – raw sql to execute
• autocommit – default false; determines if the connection automcommits

commands. Necessary for certain commands (create/drop db)