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_ADOCreatorDialogForm.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::ADOCreatorDialogForm)
56 m_ui->m_providerComboBox->addItem(
"Microsoft.Jet.OLEDB.4.0");
58 m_ui->m_providerComboBox->addItem(
"Microsoft.ACE.OLEDB.12.0");
66 m_ui->m_helpPushButton->setNameSpace(
"dpi.inpe.br.plugins");
67 m_ui->m_helpPushButton->setPageReference(
"plugins/ado/ado_creator.html");
90 throw te::qt::widgets::Exception(
TE_TR(
"Sorry! No data access driver loaded for ADO data sources!"));
93 std::map<std::string, std::string> dsInfo = getConnectionInfo(
true);
100 std::map<std::string, std::string> connInfo;
101 connInfo[
"DB_NAME"] = dsInfo[
"DB_NAME"];
102 connInfo[
"PROVIDER"] = dsInfo[
"PROVIDER"];
103 if(!dsInfo[
"PASSWORD"].empty())
104 connInfo[
"PASSWORD"] = dsInfo[
"PASSWORD"];
107 ds->setConnectionInfo(connInfo);
110 m_driver.reset(ds.release());
113 if(m_driver.get() == 0)
114 throw te::qt::widgets::Exception(
TE_TR(
"Could not open ADO data source due to an unknown error!"));
116 QString title = m_ui->m_fileLineEdit->text().trimmed();
119 std::map<std::string, std::string> connInfo;
120 connInfo[
"DB_NAME"] = dsInfo[
"DB_NAME"];
121 connInfo[
"PROVIDER"] = dsInfo[
"PROVIDER"];
122 if(!dsInfo[
"PASSWORD"].empty() && m_ui->m_savePasswordCheckBox->isChecked())
123 connInfo[
"PASSWORD"] = dsInfo[
"PASSWORD"];
125 if(m_datasource.get() == 0)
130 m_datasource->setConnInfo(connInfo);
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(
"");
140 m_datasource->setAccessDriver(
"ADO");
141 m_datasource->setType(
"ADO");
145 m_driver->setId(m_datasource->getId());
146 m_datasource->setConnInfo(connInfo);
147 m_datasource->setTitle(title.toUtf8().data());
148 m_datasource->setDescription(
"");
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!"));
171 QMessageBox::warning(
this,
172 tr(
"TerraLib Qt Components"),
173 tr(
"Not implemented yet!\nWe will provide it soon!"));
178 QString fileName = QFileDialog::getSaveFileName(
this, tr(
"Save ADO Database"),
te::qt::widgets::GetFilePathFromSettings(
"vector"), tr(
"Database files (*.accdb *.mdb);; All Files (*.*)"), 0, QFileDialog::ReadOnly);
180 if(fileName.isEmpty())
183 m_ui->m_fileLineEdit->setText(fileName);
185 QFileInfo info(fileName);
192 std::map<std::string, std::string> connInfo;
194 QString qstr = m_ui->m_fileLineEdit->text().trimmed();
197 connInfo[
"DB_NAME"] = qstr.toStdString();
201 qstr = m_ui->m_passwordLineEdit->text().trimmed();
204 connInfo[
"PASSWORD"] = qstr.toStdString();
207 qstr = m_ui->m_providerComboBox->currentText().trimmed();
210 connInfo[
"PROVIDER"] = qstr.toStdString();
212 if(m_ui->m_createOGCTablesCheckBox->isChecked())
213 connInfo[
"CREATE_OGC_METADATA_TABLES"] =
"TRUE";
static bool find(const std::string &dsType)
boost::shared_ptr< DataSource > DataSourcePtr
std::map< std::string, std::string > getConnectionInfo(bool getPrivateKeys) const
void searchDatabaseToolButtonPressed()
const te::da::DataSourcePtr & getDriver() const
#define TE_TR(message)
It marks a string in order to get translated.
static std::auto_ptr< DataSource > make(const std::string &dsType)
const te::da::DataSourceInfoPtr & getDataSource() const
ADOCreatorDialog(QWidget *parent=0, Qt::WindowFlags f=0)
void applyPushButtonPressed()
void helpPushButtonPressed()
std::auto_ptr< Ui::ADOCreatorDialogForm > m_ui
static std::auto_ptr< DataSource > create(const std::string &dsType, const std::map< std::string, std::string > &dsInfo)
It creates a new repository for a data source.
A class that represents a data source component.
boost::shared_ptr< DataSourceInfo > DataSourceInfoPtr