bool wxExSTCFile::DoFileLoad(bool synced)
{
if (
GetContentsChanged() &&
wxExFileDialog(m_STC, this).ShowModalIfChanged() == wxID_CANCEL)
{
return false;
}
// Synchronizing by appending only new data only works for log files.
// Other kind of files might get new data anywhere inside the file,
// we cannot sync that by keeping pos.
// Also only do it for reasonably large files.
const bool isLog = (GetFileName().GetExtension().find("log") == 0);
m_STC->UseModificationMarkers(false);
ReadFromFile(
synced &&
isLog &&
m_STC->GetTextLength() > 1024);
if (!synced)
{
// ReadFromFile might already have set the lexer using a modeline.
if (m_STC->GetLexer().GetScintillaLexer().empty())
{
m_STC->GetLexer().Set(GetFileName().GetLexer(), true);
}
// No edges for log files.
if (isLog)
{
m_STC->SetEdgeMode(wxSTC_EDGE_NONE);
}
wxLogStatus(_("Opened") + ": " + GetFileName().GetFullPath());
}
CheckWellFormed(GetFileName());
m_STC->PropertiesMessage(synced ? STAT_SYNC: STAT_DEFAULT);
m_STC->UseModificationMarkers(true);
return true;
}
Frame::Frame()
: wxExFrameWithHistory(nullptr, wxID_ANY, wxTheApp->GetAppDisplayName())
, m_Results(new wxExGrid(this))
, m_Query(new wxExSTC(this))
, m_Shell(new wxExShell(this, "", ";", true, 50))
{
SetIcon(wxICON(app));
wxExMenu* menuFile = new wxExMenu;
menuFile->Append(wxID_NEW);
menuFile->Append(wxID_OPEN);
GetFileHistory().UseMenu(ID_RECENTFILE_MENU, menuFile);
menuFile->AppendSeparator();
menuFile->Append(wxID_SAVE);
menuFile->Append(wxID_SAVEAS);
menuFile->AppendSeparator();
menuFile->Append(wxID_EXIT);
wxExMenu* menuDatabase = new wxExMenu;
menuDatabase->Append(ID_DATABASE_OPEN, wxExEllipsed(_("&Open")));
menuDatabase->Append(ID_DATABASE_CLOSE, _("&Close"));
wxExMenu* menuQuery = new wxExMenu;
menuQuery->Append(wxID_EXECUTE);
menuQuery->Append(wxID_STOP);
wxMenu* menuOptions = new wxMenu();
menuOptions->Append(wxID_PREFERENCES);
wxExMenu* menuView = new wxExMenu();
AppendPanes(menuView);
menuView->AppendSeparator();
menuView->AppendCheckItem(ID_VIEW_QUERY, _("Query"));
menuView->AppendCheckItem(ID_VIEW_RESULTS, _("Results"));
menuView->AppendCheckItem(ID_VIEW_STATISTICS, _("Statistics"));
wxMenu* menuHelp = new wxMenu();
menuHelp->Append(wxID_ABOUT);
wxMenuBar *menubar = new wxMenuBar;
menubar->Append(menuFile, wxGetStockLabel(wxID_FILE));
menubar->Append(menuView, _("&View"));
menubar->Append(menuDatabase, _("&Connection"));
menubar->Append(menuQuery, _("&Query"));
menubar->Append(menuOptions, _("&Options"));
menubar->Append(menuHelp, wxGetStockLabel(wxID_HELP));
SetMenuBar(menubar);
m_Results->CreateGrid(0, 0);
m_Results->EnableEditing(false); // this is a read-only grid
m_Shell->SetFocus();
#if wxUSE_STATUSBAR
SetupStatusBar(std::vector<wxExStatusBarPane>{
wxExStatusBarPane(),
wxExStatusBarPane("PaneInfo", 100, _("Lines"))});
#endif
GetToolBar()->AddControls(false); // no realize yet
GetToolBar()->AddTool(wxID_EXECUTE,
wxEmptyString,
wxArtProvider::GetBitmap(
wxART_GO_FORWARD, wxART_TOOLBAR, GetToolBar()->GetToolBitmapSize()),
wxGetStockLabel(wxID_EXECUTE, wxSTOCK_NOFLAGS));
GetToolBar()->Realize();
GetManager().AddPane(m_Shell,
wxAuiPaneInfo().
Name("CONSOLE").
CenterPane());
GetManager().AddPane(m_Results,
wxAuiPaneInfo().
Name("RESULTS").
Caption(_("Results")).
CloseButton(true).
Bottom().
MaximizeButton(true));
GetManager().AddPane(m_Query,
wxAuiPaneInfo().
Name("QUERY").
Caption(_("Query")).
CloseButton(true).
MaximizeButton(true));
GetManager().AddPane(m_Statistics.Show(this),
wxAuiPaneInfo().Left().
Hide().
MaximizeButton(true).
Caption(_("Statistics")).
Name("STATISTICS"));
GetManager().LoadPerspective(wxConfigBase::Get()->Read("Perspective"));
GetManager().GetPane("QUERY").Show(false);
GetManager().Update();
Bind(wxEVT_CLOSE_WINDOW, [=](wxCloseEvent& event) {
if (wxExFileDialog(this,
&m_Query->GetFile()).ShowModalIfChanged() != wxID_CANCEL)
{
wxConfigBase::Get()->Write("Perspective", GetManager().SavePerspective());
event.Skip();
}});
Bind(wxEVT_MENU, [=](wxCommandEvent& event) {
wxAboutDialogInfo info;
info.SetIcon(GetIcon());
info.SetDescription(_("This program offers a general ODBC query."));
info.SetVersion(wxExGetVersionInfo().GetVersionOnlyString());
info.SetCopyright(wxExGetVersionInfo().GetCopyright());
info.AddDeveloper(wxExOTL::VersionInfo().GetVersionString());
wxAboutBox(info);
}, wxID_ABOUT);
Bind(wxEVT_MENU, [=](wxCommandEvent& event) {
m_Stopped = false;
if (m_Query->GetText().empty()) return;
if (m_Results->IsShown())
{
m_Results->ClearGrid();
}
// Skip sql comments.
std::regex re("--.*$");
wxString output = std::regex_replace(m_Query->GetText().ToStdString(), re, "", std::regex_constants::format_sed);
// Queries are seperated by ; character.
wxStringTokenizer tkz(output, ";");
int no_queries = 0;
m_Running = true;
const auto start = std::chrono::system_clock::now();
// Run all queries.
while (tkz.HasMoreTokens() && !m_Stopped)
{
wxString query = tkz.GetNextToken();
query.Trim(true);
query.Trim(false);
if (!query.empty())
{
try
{
RunQuery(query, no_queries == 0);
no_queries++;
}
catch (otl_exception& p)
{
m_Statistics.Inc(_("Number of query errors"));
m_Shell->AppendText(
_("\nerror: ") + wxString(wxExQuoted(p.msg)) +
_(" in: ") + wxString(wxExQuoted(query)));
}
}
}
const auto end = std::chrono::system_clock::now();
const auto elapsed = end - start;
const auto milli = std::chrono::duration_cast<std::chrono::milliseconds>(elapsed);
m_Shell->Prompt(wxString::Format(_("\n%d queries (%.3f seconds)"),
no_queries,
(float)milli.count() / (float)1000).ToStdString());
m_Running = false;}, wxID_EXECUTE);
Bind(wxEVT_MENU, [=](wxCommandEvent& event) {
Close(true);}, wxID_EXIT);
Bind(wxEVT_MENU, [=](wxCommandEvent& event) {
m_Query->GetFile().FileNew(wxExFileName());
m_Query->SetFocus();
ShowPane("QUERY");}, wxID_NEW);
Bind(wxEVT_MENU, [=](wxCommandEvent& event) {
wxExOpenFilesDialog(
this,
wxFD_OPEN | wxFD_CHANGE_DIR,
"sql files (*.sql)|*.sql|" +
_("All Files") + wxString::Format(" (%s)|%s",
wxFileSelectorDefaultWildcardStr,
wxFileSelectorDefaultWildcardStr),
true);}, wxID_OPEN);
Bind(wxEVT_MENU, [=](wxCommandEvent& event) {
m_Query->GetFile().FileSave();}, wxID_SAVE);
Bind(wxEVT_MENU, [=](wxCommandEvent& event) {
wxExFileDialog dlg(
this,
&m_Query->GetFile(),
wxGetStockLabel(wxID_SAVEAS),
wxFileSelectorDefaultWildcardStr,
wxFD_SAVE);
if (dlg.ShowModal() == wxID_OK)
{
m_Query->GetFile().FileSave(dlg.GetPath().ToStdString());
}}, wxID_SAVEAS);
Bind(wxEVT_MENU, [=](wxCommandEvent& event) {
m_Running = false;
m_Stopped = true;}, wxID_STOP);
Bind(wxEVT_MENU, [=](wxCommandEvent& event) {
if (m_otl.Logoff())
{
m_Shell->SetPrompt(">");
}}, ID_DATABASE_CLOSE);
Bind(wxEVT_MENU, [=](wxCommandEvent& event) {
if (m_otl.Logon(this))
{
m_Shell->SetPrompt(m_otl.Datasource().ToStdString() + ">");
}}, ID_DATABASE_OPEN);
Bind(wxEVT_MENU, [=](wxCommandEvent& event) {
if (m_otl.IsConnected())
{
try
{
const wxString input(event.GetString());
if (!input.empty())
{
const wxString query = input.substr(
0,
input.length() - 1);
m_Stopped = false;
RunQuery(query, true);
}
}
catch (otl_exception& p)
{
if (m_Results->IsShown())
{
m_Results->EndBatch();
}
m_Shell->AppendText(_("\nerror: ") + wxString(wxExQuoted(p.msg)));
}
}
else
{
m_Shell->AppendText(_("\nnot connected"));
}
m_Shell->Prompt();}, ID_SHELL_COMMAND);
Bind(wxEVT_MENU, [=](wxCommandEvent& event) {
m_Stopped = true;
m_Shell->Prompt("cancelled");}, ID_SHELL_COMMAND_STOP);
Bind(wxEVT_MENU, [=](wxCommandEvent& event) {
TogglePane("QUERY");}, ID_VIEW_QUERY);
Bind(wxEVT_MENU, [=](wxCommandEvent& event) {
TogglePane("RESULTS");}, ID_VIEW_RESULTS);
Bind(wxEVT_MENU, [=](wxCommandEvent& event) {
TogglePane("STATISTICS");}, ID_VIEW_STATISTICS);
Bind(wxEVT_UPDATE_UI, [=](wxUpdateUIEvent& event) {
event.Enable(m_Query->GetModify());}, wxID_SAVE);
Bind(wxEVT_UPDATE_UI, [=](wxUpdateUIEvent& event) {
event.Enable(m_Query->GetLength() > 0);}, wxID_SAVEAS);
Bind(wxEVT_UPDATE_UI, [=](wxUpdateUIEvent& event) {
event.Enable(m_Running);}, wxID_STOP);
Bind(wxEVT_UPDATE_UI, [=](wxUpdateUIEvent& event) {
event.Enable(m_otl.IsConnected());}, ID_DATABASE_CLOSE);
Bind(wxEVT_UPDATE_UI, [=](wxUpdateUIEvent& event) {
event.Enable(!m_otl.IsConnected());}, ID_DATABASE_OPEN);
Bind(wxEVT_UPDATE_UI, [=](wxUpdateUIEvent& event) {
// If we have a query, you can hide it, but still run it.
event.Enable(m_Query->GetLength() > 0 && m_otl.IsConnected());}, wxID_EXECUTE);
Bind(wxEVT_UPDATE_UI, [=](wxUpdateUIEvent& event) {
event.Enable(!GetFileHistory().GetHistoryFile().empty());}, ID_RECENTFILE_MENU);
Bind(wxEVT_UPDATE_UI, [=](wxUpdateUIEvent& event) {
event.Check(GetManager().GetPane("QUERY").IsShown());}, ID_VIEW_QUERY);
Bind(wxEVT_UPDATE_UI, [=](wxUpdateUIEvent& event) {
event.Check(GetManager().GetPane("RESULTS").IsShown());}, ID_VIEW_RESULTS);
Bind(wxEVT_UPDATE_UI, [=](wxUpdateUIEvent& event) {
event.Check(GetManager().GetPane("STATISTICS").IsShown());}, ID_VIEW_STATISTICS);
// Do automatic connect.
if (!m_otl.Datasource().empty() && m_otl.Logon())
{
m_Shell->SetPrompt(m_otl.Datasource().ToStdString() + ">");
}
else
{
m_Shell->SetPrompt(">");
}
}