27 #include "../../../../common/Translator.h"
28 #include "../../../../dataaccess/datasource/DataSource.h"
29 #include "../../../../dataaccess/datasource/DataSourceFactory.h"
30 #include "../../../../dataaccess/datasource/DataSourceInfo.h"
31 #include "../../../../dataaccess/datasource/DataSourceManager.h"
32 #include "../../../widgets/Exception.h"
33 #include "../../../widgets/Utils.h"
34 #include "ui_ADOConnectorDialogForm.h"
38 #include <boost/algorithm/string/case_conv.hpp>
39 #include <boost/lexical_cast.hpp>
40 #include <boost/uuid/random_generator.hpp>
41 #include <boost/uuid/uuid_io.hpp>
44 #include <QFileDialog>
45 #include <QMessageBox>
49 m_ui(new
Ui::ADOConnectorDialogForm)
56 m_ui->m_providerComboBox->addItem(
"Microsoft.Jet.OLEDB.4.0");
58 m_ui->m_providerComboBox->addItem(
"Microsoft.ACE.OLEDB.12.0");
67 m_ui->m_helpPushButton->setNameSpace(
"dpi.inpe.br.plugins");
68 m_ui->m_helpPushButton->setPageReference(
"plugins/ado/ado.html");
71 m_ui->m_openPushButton->setText(
TE_TR(
"Update"));
92 if(m_datasource.get() != 0)
94 setConnectionInfo(m_datasource->getConnInfo());
96 m_ui->m_datasourceTitleLineEdit->setText(QString::fromStdString(m_datasource->getTitle()));
98 m_ui->m_datasourceDescriptionTextEdit->setText(QString::fromStdString(m_datasource->getDescription()));
108 throw te::qt::widgets::Exception(
TE_TR(
"Sorry! No data access driver loaded for ADO data sources!"));
113 ds->setConnectionInfo(getConnectionInfo(
true));
115 m_driver.reset(ds.release());
117 if(m_driver.get() == 0)
118 throw te::qt::widgets::Exception(
TE_TR(
"Could not open ADO data source due to an unknown error!"));
120 QString title = m_ui->m_datasourceTitleLineEdit->text().trimmed();
123 title = m_ui->m_fileLineEdit->text().trimmed();
125 if(m_datasource.get() == 0)
130 m_datasource->setConnInfo(getConnectionInfo(m_ui->m_savePasswordCheckBox->isChecked()));
132 boost::uuids::basic_random_generator<boost::mt19937> gen;
133 boost::uuids::uuid u = gen();
134 std::string dsId = boost::uuids::to_string(u);
136 m_datasource->setId(dsId);
137 m_driver->setId(dsId);
138 m_datasource->setTitle(title.toUtf8().data());
139 m_datasource->setDescription(m_ui->m_datasourceDescriptionTextEdit->toPlainText().trimmed().toUtf8().data());
140 m_datasource->setAccessDriver(
"ADO");
141 m_datasource->setType(
"ADO");
145 m_driver->setId(m_datasource->getId());
146 m_datasource->setConnInfo(getConnectionInfo(m_ui->m_savePasswordCheckBox->isChecked()));
147 m_datasource->setTitle(title.toUtf8().data());
148 m_datasource->setDescription(m_ui->m_datasourceDescriptionTextEdit->toPlainText().trimmed().toUtf8().data());
151 catch(
const std::exception& e)
153 QMessageBox::warning(
this,
154 tr(
"TerraLib Qt Components"),
160 QMessageBox::warning(
this,
161 tr(
"TerraLib Qt Components"),
162 tr(
"Unknown error while opening ADO database!"));
175 throw te::qt::widgets::Exception(
TE_TR(
"Sorry! No data access driver loaded for ADO data sources!"));
180 ds->setConnectionInfo(getConnectionInfo(
true));
184 throw te::qt::widgets::Exception(
TE_TR(
"Could not open ADO database!"));
186 QMessageBox::warning(
this,
187 tr(
"TerraLib Qt Components"),
188 tr(
"Data source is ok!"));
190 catch(
const std::exception& e)
192 QMessageBox::warning(
this,
193 tr(
"TerraLib Qt Components"),
198 QMessageBox::warning(
this,
199 tr(
"TerraLib Qt Components"),
200 tr(
"Unknown error while testing ADO data source!"));
206 QMessageBox::warning(
this,
207 tr(
"TerraLib Qt Components"),
208 tr(
"Not implemented yet!\nWe will provide it soon!"));
213 QString fileName = QFileDialog::getOpenFileName(
this, tr(
"Open ADO Database"),
te::qt::widgets::GetFilePathFromSettings(
"vector"), tr(
"Database files (*.accdb *.mdb);; All Files (*.*)"), 0, QFileDialog::ReadOnly);
215 if(fileName.isEmpty())
218 m_ui->m_fileLineEdit->setText(fileName);
220 QFileInfo info(fileName);
227 std::map<std::string, std::string> connInfo;
229 QString qstr = m_ui->m_fileLineEdit->text().trimmed();
232 connInfo[
"DB_NAME"] = qstr.toStdString();
236 qstr = m_ui->m_passwordLineEdit->text().trimmed();
239 connInfo[
"PASSWORD"] = qstr.toStdString();
242 qstr = m_ui->m_providerComboBox->currentText().trimmed();
245 connInfo[
"PROVIDER"] = qstr.toStdString();
252 std::map<std::string, std::string>::const_iterator it = connInfo.find(
"DB_NAME");
253 std::map<std::string, std::string>::const_iterator itend = connInfo.end();
256 m_ui->m_fileLineEdit->setText(it->second.c_str());
258 it = connInfo.find(
"PASSWORD");
261 m_ui->m_passwordLineEdit->setText(it->second.c_str());
static bool find(const std::string &dsType)
boost::shared_ptr< DataSource > DataSourcePtr
void testPushButtonPressed()
void helpPushButtonPressed()
const te::da::DataSourcePtr & getDriver() const
#define TE_TR(message)
It marks a string in order to get translated.
ADOConnectorDialog(QWidget *parent=0, Qt::WindowFlags f=0, Operation op=CONNECTION)
std::auto_ptr< Ui::ADOConnectorDialogForm > m_ui
static std::auto_ptr< DataSource > make(const std::string &dsType)
void set(const te::da::DataSourceInfoPtr &ds)
void searchDatabaseToolButtonPressed()
void openPushButtonPressed()
A class that represents a data source component.
void setConnectionInfo(const std::map< std::string, std::string > &connInfo)
std::map< std::string, std::string > getConnectionInfo(bool getPrivateKeys) const
const te::da::DataSourceInfoPtr & getDataSource() const
boost::shared_ptr< DataSourceInfo > DataSourceInfoPtr