{

Q_OBJECT

MainWindow(QWidget* parent = 0);

~MainWindow();

DBBrowserDB* getDb() { return &db; }

struct PragmaValues

{

int autovacuum;

int automatic_index;

int checkpoint_fullsync;

int foreign_keys;

int fullfsync;

int ignore_check_constraints;

QString journal_mode;

int journal_size_limit;

QString locking_mode;

int max_page_count;

int page_size;

int recursive_triggers;

int secure_delete;

int synchronous;

int temp_store;

int user_version;

int wal_autocheckpoint;

} pragmaValues;

enum PlotColumns

{

PlotColumnField = 0,

PlotColumnX = 1,

PlotColumnY = 2,

PlotColumnDummy = 3

};

Ui::MainWindow* ui;

SqliteTableModel* m_browseTableModel;

SqliteTableModel* m_currentPlotModel;

QMenu *popupTableMenu;

QMenu *recentFilesMenu;

QMenu *popupSaveSqlFileMenu;

QLabel* statusEncodingLabel;

QLabel* statusEncryptionLabel;

DbStructureModel* dbStructureModel;

enum { MaxRecentFiles = 5 };

QAction *recentFileActs[MaxRecentFiles];

QAction *recentSeparatorAct;

int curBrowseOrderByIndex;

Qt::SortOrder curBrowseOrderByMode;

QMap<QString, QMap<int, int> > browseTableColumnWidths;

EditDialog* editWin;

QIntValidator* gotoValidator;

DBBrowserDB db;

QNetworkAccessManager* m_NetworkManager;

void init();

void clearCompleterModelsFields();

void updateRecentFileActions();

void setCurrentFile(const QString& fileName);

void addToRecentFilesMenu(const QString& filename);

void activateFields(bool enable = true);

void loadExtensionsFromSettings();

void closeEvent(QCloseEvent *);

void dragEnterEvent(QDragEnterEvent *event);

void dropEvent(QDropEvent *event);

void resizeEvent(QResizeEvent *event);

public slots:

bool fileOpen(const QString& fileName = QString(), bool dontAddToRecentFiles = false);

void logSql(const QString &sql, int msgtype);

void dbState(bool dirty);

void browseRefresh();

void jumpToRow(const QString& table, QString column, const QByteArray& value);

private slots:

void createTreeContextMenu(const QPoint & qPoint);

void changeTreeSelection();

void fileNew();

void populateStructure();

void populateTable(const QString& tablename, bool bKeepFilter = false);

void resetBrowser();

void fileClose();

void addRecord();

void deleteRecord();

void selectTableLine( int lineToSelect );

void navigatePrevious();

void navigateNext();

void navigateBegin();

void navigateEnd();

void navigateGoto();

void setRecordsetLabel();

void createTable();

void createIndex();

void compact();

void deleteObject();

void editTable();

void helpWhatsThis();

void helpAbout();

void updateRecordText(int row, int col, const QByteArray& newtext);

void editWinAway();

void editText(const QModelIndex& index);

void doubleClickTable(const QModelIndex& index);

void executeQuery();

void importTableFromCSV();

void exportTableToCSV();

void fileSave();

void fileRevert();

void exportDatabaseToSQL();

void importDatabaseFromSQL();

void openPreferences();

void openRecentFile();

void loadPragmas();

void updatePragmaUi();

void savePragmas();

void mainTabSelected( int tabindex );

void browseTableHeaderClicked(int logicalindex);

unsigned int openSqlTab(bool resetCounter = false);

void closeSqlTab(int index, bool force = false);

void openSqlFile();

void saveSqlFile();

void saveSqlFileAs();

void loadExtension();

void reloadSettings();

void httpresponse(QNetworkReply* reply);

void updatePlot(SqliteTableModel* model, bool update = true);

void on_treePlotColumns_itemChanged(QTreeWidgetItem *item, int column);

void on_treePlotColumns_itemDoubleClicked(QTreeWidgetItem *item, int column);

void on_butSavePlot_clicked();

void on_actionWiki_triggered();

void on_actionBug_report_triggered();

void on_actionWebsite_triggered();

void updateBrowseDataColumnWidth(int section, int /*old_size*/, int new_size);

bool loadProject(QString filename = QString());

void saveProject();

void fileAttach();

void updateFilter(int column, const QString& value);

void editEncryption();

void switchToBrowseDataTab();

void on_buttonClearFilters_clicked();

void copyCurrentCreateStatement();

void on_comboLineType_currentIndexChanged(int index);

void on_comboPointShape_currentIndexChanged(int index);