DELETAR_BD.py

"""
/***************************************************************************
 3 CGEO
3th Brazilian Geoinformation Center
                              -------------------
        begin                : 2017-05-12
        copyright            : (C) 2017 by Leandro Franca - Cartographic Engineer @ Brazilian Army
        email                : franca.leandro@eb.mil.br
 ***************************************************************************/

/***************************************************************************
 *                                                                         *
 *   This program is free software; you can redistribute it and/or modify  *
 *   it under the terms of the GNU General Public License as published by  *
 *   the Free Software Foundation.                              *
 *                                                                         *
 ***************************************************************************/
"""
# DELETAR BD
##4. DELETAR BD=name
##LF1) PostGIS=group
##Nome_do_Banco_de_Dados=string
##Host=string localhost
##Versao_do_PostgreSQL=selection 9.5;9.3;9.4;9.6

# Inputs
nome = str(Nome_do_Banco_de_Dados)
host = str(Host)
lista = [9.5,9.3,9.4,9.6]
version = str(lista[Versao_do_PostgreSQL])

import os
from PyQt4.QtCore import *
from qgis.gui import QgsMessageBar
from qgis.utils import iface
from qgis.core import *
import time

local = 'C:/Program Files/PostgreSQL/'+version+'/bin'
os.chdir(local)

arquivo = open('C:/Users/Public/drop.sql','w')
arquivo.write('DROP DATABASE '+nome)
arquivo.close()
comando = 'psql -d postgres -U postgres -h '+host+' -p 5432 -f C:/Users/Public/drop.sql'
progress.setInfo('<b>Deletando o Banco de Dados...</b><br/>')
result = os.system(comando)
os.remove('C:/Users/Public/drop.sql')
if result==0:
    progress.setInfo('<b>Operacao concluida com sucesso!</b><br/><br/>')
    progress.setInfo('<b>Leandro Fran&ccedil;a - Eng Cart</b><br/>')
    time.sleep(4)
    iface.messageBar().pushMessage(u'Situacao', "Operacao Concluida com Sucesso!", level=QgsMessageBar.INFO, duration=5) 
else:
    progress.setInfo('<b>Problema(s) durante a execucao do backup.</b><br/>')
    iface.messageBar().pushMessage(u'Erro', "Problema(s) durante a execucao do backup.", level=QgsMessageBar.CRITICAL, duration=10) 
    progress.setInfo('<b>Verifique se os parametros foram definidos corretamente.</b><br/>')
    time.sleep(8)