def build_query_text_edit(self):
# Add layouts
query_edit_layout = QVBoxLayout(self)
query_edit_layout.setContentsMargins(0, 0, 0, 0)
query_control_layout = QHBoxLayout(self)
query_control_layout.setContentsMargins(0, 0, 0, 0)
# Execute query button
self.query_execute_button = QPushButton(
UI.QUERY_CONTROL_EXECUTE_BUTTON_TEXT, self)
self.query_execute_button.clicked.connect(self.on_execute_click)
query_control_layout.addWidget(self.query_execute_button)
# Fetch data button
self.query_fetch_button = QPushButton(
UI.QUERY_CONTROL_FETCH_BUTTON_TEXT, self)
self.query_fetch_button.clicked.connect(self.on_fetch_click)
self.model.fetch_changed.connect(self.on_fetch_changed)
query_control_layout.addWidget(self.query_fetch_button)
# Commit button
self.query_commit_button = QPushButton(
UI.QUERY_CONTROL_COMMIT_BUTTON_TEXT, self)
self.query_commit_button.clicked.connect(self.on_connect_click)
query_control_layout.addWidget(self.query_commit_button)
# Rollback button
self.query_rollback_button = QPushButton(
UI.QUERY_CONTROL_ROLLBACK_BUTTON_TEXT, self)
self.query_rollback_button.clicked.connect(self.on_rollback_click)
query_control_layout.addWidget(self.query_rollback_button)
# Build control strip widget
query_control = QWidget(self)
query_control.setLayout(query_control_layout)
query_edit_layout.addWidget(query_control)
# Initialize query edit document for text editor
# and use SQL Highlighter CSS styles for it.
self.query_text_edit_document = QTextDocument(self)
self.query_text_edit_document.setDefaultStyleSheet(
SQLHighlighter.style())
# Initialize query text editor using previously built
# text edutir document.
self.query_text_edit = QTextEdit(self)
self.query_text_edit.setDocument(self.query_text_edit_document)
self.query_text_edit.textChanged.connect(self.on_query_changed)
self.query_text_edit.setText(UI.QUERY_EDITOR_DEFAULT_TEXT)
query_edit_layout.addWidget(self.query_text_edit)
# Connect model's connected/disconnected signals
self.model.connected.connect(self.on_connected)
self.model.disconnected.connect(self.on_disconnected)
query_edit = QWidget(self)
query_edit.setLayout(query_edit_layout)
query_edit.sizePolicy().setVerticalPolicy(QSizePolicy.Minimum)
return query_edit
def init_query_text_edit(self):
# Add query edit widget
query_edit_layout = QVBoxLayout(self)
query_edit_layout.setContentsMargins(0, 0, 0, 0)
query_control_layout = QHBoxLayout(self)
query_control_layout.setContentsMargins(0, 0, 0, 0)
self.query_execute_button = QPushButton('Execute', self)
self.query_execute_button.clicked.connect(self.on_execute_click)
query_control_layout.addWidget(self.query_execute_button)
self.query_fetch_button = QPushButton('Fetch', self)
self.query_fetch_button.clicked.connect(self.on_fetch_click)
self.model.fetch_changed.connect(self.on_fetch_changed)
query_control_layout.addWidget(self.query_fetch_button)
self.query_commit_button = QPushButton('Commit', self)
self.query_commit_button.clicked.connect(self.on_connect_click)
query_control_layout.addWidget(self.query_commit_button)
self.query_rollback_button = QPushButton('Rollback', self)
self.query_rollback_button.clicked.connect(self.on_rollback_click)
query_control_layout.addWidget(self.query_rollback_button)
query_control = QWidget(self)
query_control.setLayout(query_control_layout)
query_edit_layout.addWidget(query_control)
self.query_text_edit = QTextEdit(self)
self.query_text_edit.setText(
"SELECT name FROM sqlite_master WHERE type='table'")
query_edit_layout.addWidget(self.query_text_edit)
# Connect model's connected/disconnected signals
self.model.connected.connect(self.on_connected)
self.model.disconnected.connect(self.on_disconnected)
query_edit = QWidget(self)
query_edit.setLayout(query_edit_layout)
query_edit.sizePolicy().setVerticalPolicy(QSizePolicy.Minimum)
return query_edit
