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 <QtGui/QFileDialog>
45 #include <QtGui/QMessageBox>
49 m_ui(new Ui::ADOConnectorDialogForm)
55 m_ui->m_providerComboBox->addItem(
"Microsoft.Jet.OLEDB.4.0");
63 m_ui->m_helpPushButton->setNameSpace(
"dpi.inpe.br.plugins");
64 m_ui->m_helpPushButton->setPageReference(
"plugins/ado/ado.html");
85 if(m_datasource.get() != 0)
87 setConnectionInfo(m_datasource->getConnInfo());
89 m_ui->m_datasourceTitleLineEdit->setText(QString::fromStdString(m_datasource->getTitle()));
91 m_ui->m_datasourceDescriptionTextEdit->setText(QString::fromStdString(m_datasource->getDescription()));
101 throw te::qt::widgets::Exception(
TR_QT_WIDGETS(
"Sorry! No data access driver loaded for ADO data sources!"));
104 std::map<std::string, std::string> dsInfo;
106 getConnectionInfo(dsInfo);
111 ds->setConnectionInfo(dsInfo);
113 m_driver.reset(ds.release());
115 if(m_driver.get() == 0)
116 throw te::qt::widgets::Exception(
TR_QT_WIDGETS(
"Could not open ADO data source due to an unknown error!"));
118 QString title = m_ui->m_datasourceTitleLineEdit->text().trimmed();
121 title = m_ui->m_fileLineEdit->text().trimmed();
123 if(m_datasource.get() == 0)
128 m_datasource->setConnInfo(dsInfo);
130 boost::uuids::basic_random_generator<boost::mt19937> gen;
131 boost::uuids::uuid u = gen();
132 std::string dsId = boost::uuids::to_string(u);
134 m_datasource->setId(dsId);
135 m_driver->setId(dsId);
136 m_datasource->setTitle(title.toUtf8().data());
137 m_datasource->setDescription(m_ui->m_datasourceDescriptionTextEdit->toPlainText().trimmed().toUtf8().data());
138 m_datasource->setAccessDriver(
"ADO");
139 m_datasource->setType(
"ADO");
143 m_driver->setId(m_datasource->getId());
144 m_datasource->setConnInfo(dsInfo);
145 m_datasource->setTitle(title.toUtf8().data());
146 m_datasource->setDescription(m_ui->m_datasourceDescriptionTextEdit->toPlainText().trimmed().toUtf8().data());
149 catch(
const std::exception& e)
151 QMessageBox::warning(
this,
152 tr(
"TerraLib Qt Components"),
158 QMessageBox::warning(
this,
159 tr(
"TerraLib Qt Components"),
160 tr(
"Unknown error while opening ADO database!"));
173 throw te::qt::widgets::Exception(
TR_QT_WIDGETS(
"Sorry! No data access driver loaded for ADO data sources!"));
176 std::map<std::string, std::string> dsInfo;
178 getConnectionInfo(dsInfo);
183 ds->setConnectionInfo(dsInfo);
187 throw te::qt::widgets::Exception(
TR_QT_WIDGETS(
"Could not open ADO database!"));
189 QMessageBox::warning(
this,
190 tr(
"TerraLib Qt Components"),
191 tr(
"Data source is ok!"));
193 catch(
const std::exception& e)
195 QMessageBox::warning(
this,
196 tr(
"TerraLib Qt Components"),
201 QMessageBox::warning(
this,
202 tr(
"TerraLib Qt Components"),
203 tr(
"Unknown error while testing ADO data source!"));
209 QMessageBox::warning(
this,
210 tr(
"TerraLib Qt Components"),
211 tr(
"Not implemented yet!\nWe will provide it soon!"));
216 QString fileName = QFileDialog::getOpenFileName(
this, tr(
"Open ADO Database"),
te::qt::widgets::GetFilePathFromSettings(
"vector"), tr(
"Database files (*.accdb *.mdb);; All Files (*.*)"), 0, QFileDialog::ReadOnly);
218 if(fileName.isEmpty())
221 m_ui->m_fileLineEdit->setText(fileName);
223 QFileInfo info(fileName);
233 QString qstr = m_ui->m_fileLineEdit->text().trimmed();
236 connInfo[
"DB_NAME"] = qstr.toStdString();
238 qstr = m_ui->m_passwordLineEdit->text().trimmed();
241 connInfo[
"PASSWORD"] = qstr.toStdString();
243 qstr = m_ui->m_providerComboBox->currentText().trimmed();
246 connInfo[
"PROVIDER"] = qstr.toStdString();
251 std::map<std::string, std::string>::const_iterator it = connInfo.find(
"DB_NAME");
252 std::map<std::string, std::string>::const_iterator itend = connInfo.end();
255 m_ui->m_fileLineEdit->setText(it->second.c_str());
257 it = connInfo.find(
"PASSWORD");
259 m_ui->m_passwordLineEdit->setText(it->second.c_str());
ADOConnectorDialog(QWidget *parent=0, Qt::WindowFlags f=0)
TEQTWIDGETSEXPORT QString GetFilePathFromSettings(const QString &typeFile)
Returns the value of the last saved file path for the typeFile required.
void searchDatabaseToolButtonPressed()
A class that represents a data source component.
void openPushButtonPressed()
std::auto_ptr< Ui::ADOConnectorDialogForm > m_ui
TEQTWIDGETSEXPORT void AddFilePathToSettings(const QString &path, const QString &typeFile)
Save last used path in QSettings.
static std::auto_ptr< DataSource > make(const std::string &dsType)
void testPushButtonPressed()
void getConnectionInfo(std::map< std::string, std::string > &connInfo) const
static bool find(const std::string &dsType)
void helpPushButtonPressed()
const te::da::DataSourceInfoPtr & getDataSource() const
boost::shared_ptr< DataSource > DataSourcePtr
#define TR_QT_WIDGETS(message)
It marks a string in order to get translated. This is a special mark used in the TerraLib Qt Widgets ...
const te::da::DataSourcePtr & getDriver() const
void setConnectionInfo(const std::map< std::string, std::string > &connInfo)
boost::shared_ptr< DataSourceInfo > DataSourceInfoPtr
void set(const te::da::DataSourceInfoPtr &ds)