def execute_queries(self, query=''):
""" This function executes queries """
# Hide tooltip if visible
if QToolTip.isVisible():
QToolTip.hideText()
# If text is selected, then this text is the query,
# otherwise the query is all text that has the editor
editor_widget = self.currentWidget().get_editor()
if editor_widget.textCursor().hasSelection():
query = editor_widget.textCursor().selectedText()
else:
query = editor_widget.toPlainText()
relations = self.currentWidget().relations
central = Pireal.get_service("central")
table_widget = central.get_active_db().table_widget
# Restore
relations.clear()
self.currentWidget().clear_results()
# Parse query
sc = scanner.Scanner(query)
lex = lexer.Lexer(sc)
try:
par = parser.Parser(lex)
interpreter = parser.Interpreter(par)
interpreter.clear()
interpreter.to_python()
except Exception as reason:
pireal = Pireal.get_service("pireal")
pireal.show_error_message(self.parse_error(reason.__str__()))
return
relations.update(table_widget.relations)
for relation_name, expression in list(interpreter.SCOPE.items()):
if relation_name in relations:
QMessageBox.critical(self,
self.tr("Query Error"),
self.tr("<b>{}</b> is a duplicate "
"relation name.<br><br> "
"Please choose a unique name "
"and re-execute the "
"queries.".format(
relation_name)))
del interpreter.SCOPE[relation_name]
return
try:
new_relation = eval(expression, {}, relations)
except Exception as reason:
pireal = Pireal.get_service("pireal")
pireal.show_error_message(self.parse_error(reason.__str__()),
syntax_error=False)
return
relations[relation_name] = new_relation
self.__add_table(new_relation, relation_name)
def execute_queries(self):
# Editor instance
query_editor = Pireal.get_service("query-editor").editor
query = query_editor.toPlainText() # Text
# Parse query
expression = parser.convert_to_python(query)
table_widget = Pireal.get_service("db")
rel = eval(expression, table_widget.relations)
def new_query(self, filename=''):
query_widget = Pireal.get_service("query_widget")
self.addWidget(query_widget)
if not query_widget.isVisible():
query_widget.show()
pireal = Pireal.get_service("pireal")
pireal.enable_disable_query_actions()
query_widget.new_query(filename)
self.connect(query_widget,
SIGNAL("currentEditorSaved(QPlainTextEdit)"),
self.save_query)
def add_table(self, rela, rname):
central_widget = Pireal.get_service("central")
lateral_widget = Pireal.get_service("lateral_widget")
db = central_widget.get_active_db()
_view = db.create_table(rela, rname, editable=False)
table_widget = central_widget.get_active_db().table_widget
index = table_widget.stacked_result.addWidget(_view)
table_widget.stacked_result.setCurrentIndex(index)
lateral_widget.result_list.add_item(rname, rela.cardinality(),
rela.degree())
# lateral_widget.result_list.select_last()
table_widget._tabs.setCurrentIndex(1)
def add_table(self, rela, rname):
central_widget = Pireal.get_service("central")
lateral_widget = Pireal.get_service("lateral_widget")
db = central_widget.get_active_db()
_view = db.create_table(rela, rname, editable=False)
table_widget = central_widget.get_active_db().table_widget
index = table_widget.stacked_result.addWidget(_view)
table_widget.stacked_result.setCurrentIndex(index)
lateral_widget.result_list.add_item(
rname, rela.cardinality(), rela.degree())
# lateral_widget.result_list.select_last()
table_widget._tabs.setCurrentIndex(1)
def new_query(self):
from src.gui.query_editor import query_widget
widget = query_widget.QueryWidget()
pireal = Pireal.get_service("pireal")
# Load the instance
Pireal.load_service("query-editor", widget)
# MdiArea
mdi = Pireal.get_service("mdi")
widget.setMinimumSize(mdi.width(), mdi.minimumSizeHint().height())
mdi.addSubWindow(widget)
# Enable querie's QAction
pireal.enable_disable_query_actions()
widget.show()
def clear_results(self):
central_widget = Pireal.get_service("central")
lateral_widget = Pireal.get_service("lateral_widget")
lateral_widget.result_list.clear_items()
table_widget = central_widget.get_active_db().table_widget
i = table_widget.stacked_result.count()
# i = self._stack_tables.count()
while i >= 0:
# widget = self._stack_tables.widget(i)
widget = table_widget.stacked_result.widget(i)
# self._stack_tables.removeWidget(widget)
table_widget.stacked_result.removeWidget(widget)
if widget is not None:
widget.deleteLater()
i -= 1
def clear_results(self):
central_widget = Pireal.get_service("central")
lateral_widget = Pireal.get_service("lateral_widget")
lateral_widget.result_list.clear_items()
table_widget = central_widget.get_active_db().table_widget
i = table_widget.stacked_result.count()
# i = self._stack_tables.count()
while i >= 0:
# widget = self._stack_tables.widget(i)
widget = table_widget.stacked_result.widget(i)
# self._stack_tables.removeWidget(widget)
table_widget.stacked_result.removeWidget(widget)
if widget is not None:
widget.deleteLater()
i -= 1
def create_data_base(self):
mdi = Pireal.get_service("mdi")
db_name, ok = QInputDialog.getText(mdi, self.tr("New DB"),
self.tr("Name:"),
text=getpass.getuser())
if ok:
from src.gui import table_widget
db_widget = table_widget.MdiDB()
db_widget.setWindowTitle(db_name + '.pdb')
db_widget.setMinimumSize(mdi.width(), mdi.height() / 1.7)
mdi.addSubWindow(db_widget)
# Enable QAction's
pireal = Pireal.get_service("pireal")
pireal.enable_disable_db_actions()
db_widget.show()
def __on_wizard_finished(self, data, wizard_widget):
""" This slot execute when wizard to create a database is finished """
pireal = Pireal.get_service("pireal")
if not data:
# If it's canceled, remove wizard widget and return to Start Page
self.remove_last_widget()
else:
# Create a new data base container
db_container = database_container.DatabaseContainer()
# Associate the file name with the PFile object
pfile_object = pfile.File(data['filename'])
# Associate PFile object with data base container
# and add widget to stacked
db_container.pfile = pfile_object
self.add_widget(db_container)
# Remove wizard
self.stacked.removeWidget(wizard_widget)
# Set window title
pireal.change_title(file_manager.get_basename(data['filename']))
# Enable db actions
pireal.set_enabled_db_actions(True)
pireal.set_enabled_relation_actions(True)
self.created = True
DEBUG("Base de datos creada correctamente: '{}'".format(
data['filename']))
# If data or not, show menubar and toolbar again
pireal.show_hide_menubar()
pireal.show_hide_toolbar()
def _check_count(self):
""" Hide dock if count = 0 """
if self.tab.count() == 0:
pireal = Pireal.get_service("pireal")
pireal.enable_disable_query_actions(False)
self.hide()
def __hide(self):
if self.count() == 0:
self.hide()
# Disable query actions
pireal = Pireal.get_service("pireal")
pireal.set_enabled_query_actions(False)
pireal.set_enabled_editor_actions(False)
def add_data_base(self, data):
lateral = Pireal.get_service("lateral")
rel = None
for part in data.split('@'):
for e, line in enumerate(part.splitlines()):
if e == 0:
name = line.split(':')[0]
rel = relation.Relation()
rel.fields = line.split(':')[-1].split(',')
else:
rel.insert(line.split(','))
if rel is not None:
table = Table()
table.setRowCount(1)
table.setColumnCount(0)
self.relations[name] = rel
for _tuple in rel.content:
row = table.rowCount()
table.setColumnCount(len(rel.fields))
for column, text in enumerate(_tuple):
item = Item()
item.setText(text)
table.setItem(row - 1, column, item)
table.insertRow(row)
table.setHorizontalHeaderLabels(rel.fields)
self.stacked.addWidget(table)
table.removeRow(table.rowCount() - 1)
lateral.add_item_list([name])
def execute_queries(self):
import re
# Editor instance
editor = self.tab.currentWidget()
# Text
text = editor.toPlainText()
# Ignore comments
table = Pireal.get_service("container").table_widget
for line in text.splitlines():
if line.startswith('--'):
continue
parts = line.split('=', 1)
parts[0] = parts[0].strip()
if re.match(r'^[_a-zA-Z]+[_a-zA-Z0-9]*$', parts[0]):
relation_name, line = parts
else:
relation_name = 'rel_{}'.format(self.__nrelation)
self.__nrelation += 1
try:
expression = parser.convert_to_python(line.strip())
rel = eval(expression, table.relations)
except Exception as reason:
#try:
#except Exception as reason:
QMessageBox.critical(self, self.tr("Error en consulta"),
reason.__str__())
return
table.add_new_table(rel, relation_name)
table.relations[relation_name] = rel
def add_new_table(self, rel, name):
import itertools
table = QTableWidget()
table.setRowCount(0)
table.setColumnCount(0)
data = itertools.chain([rel.fields], rel.content)
for row_data in data:
row = table.rowCount()
table.setColumnCount(len(row_data))
for col, text in enumerate(row_data):
item = QTableWidgetItem()
item.setText(text)
if row == 0:
table.setHorizontalHeaderItem(col, item)
else:
table.setItem(row - 1, col, item)
table.insertRow(row)
table.removeRow(table.rowCount() - 1)
self.stacked.addWidget(table)
self.stacked.setCurrentIndex(self.stacked.count() - 1)
lateral = Pireal.get_service("lateral")
lateral.add_item_list([name])
def __hide(self):
if self.count() == 0:
self.hide()
# Disable query actions
pireal = Pireal.get_service("pireal")
pireal.set_enabled_query_actions(False)
pireal.set_enabled_editor_actions(False)
def __open_example(self):
central_widget = Pireal.get_service("central")
db_filename = os.path.join(settings.EXAMPLES, 'database.pdb')
central_widget.open_database(filename=db_filename, remember=False)
query_filename = os.path.join(settings.EXAMPLES, 'queries.pqf')
central_widget.open_query(filename=query_filename, remember=False)
# Ejecuto las consultas de ejemplo luego de 1.3 segundos
QTimer.singleShot(1300, central_widget.execute_queries)
def __open_example(self):
central_widget = Pireal.get_service("central")
db_filename = os.path.join(settings.EXAMPLES, 'database.pdb')
central_widget.open_database(filename=db_filename, remember=False)
query_filename = os.path.join(settings.EXAMPLES, 'queries.pqf')
central_widget.open_query(filename=query_filename, remember=False)
# Ejecuto las consultas de ejemplo luego de 1.3 segundos
QTimer.singleShot(1300, central_widget.execute_queries)
def execute_queries(self, query=''):
""" This function executes queries """
# If text is selected, then this text is the query,
# otherwise the query is all text that has the editor
editor_widget = self.currentWidget().get_editor()
if editor_widget.textCursor().hasSelection():
query = "\n".join(
editor_widget.textCursor().selectedText().splitlines())
else:
query = editor_widget.toPlainText()
relations = self.currentWidget().relations
central = Pireal.get_service("central")
table_widget = central.get_active_db().table_widget
# Restore
relations.clear()
self.currentWidget().clear_results()
editor_widget.show_run_cursor()
# Parse query
error = True
try:
result = parser.parse(query)
except MissingQuoteError as reason:
title = self.tr("Error de Sintáxis")
text = self.parse_error(str(reason))
except InvalidSyntaxError as reason:
title = self.tr("Error de Sintáxis")
text = self.parse_error(str(reason) + "\n" + self.tr(
"El error comienza con " + reason.character))
except DuplicateRelationNameError as reason:
title = self.tr("Nombre duplicado")
text = self.tr("Ya existe una relación con el nombre <b>{}</b> :(."
"<br><br>Elige otro por favor ;).".format(
reason.rname))
except ConsumeError as reason:
title = self.tr("Error de Sintáxis")
text = self.parse_error(str(reason))
else:
error = False
if error:
QMessageBox.critical(self, title, text)
return
relations.update(table_widget.relations)
for relation_name, expression in result.items():
try:
new_relation = eval(expression, {}, relations)
except Exception as reason:
QMessageBox.critical(
self,
self.tr("Error de Consulta"),
self.parse_error(str(reason))
)
return
relations[relation_name] = new_relation
self.__add_table(new_relation, relation_name)
def create_relation(relation, relation_name):
db = self.get_active_db()
lateral = Pireal.get_service("lateral_widget")
table = db.create_table(relation, relation_name)
db.table_widget.add_table(relation, relation_name, table)
lateral.relation_list.add_item(relation_name,
relation.cardinality(),
relation.degree())
db.modified = True
def execute_queries(self, query=''):
""" This function executes queries """
# If text is selected, then this text is the query,
# otherwise the query is all text that has the editor
editor_widget = self.currentWidget().get_editor()
if editor_widget.textCursor().hasSelection():
query = "\n".join(
editor_widget.textCursor().selectedText().splitlines())
else:
query = editor_widget.toPlainText()
relations = self.currentWidget().relations
central = Pireal.get_service("central")
table_widget = central.get_active_db().table_widget
# Restore
relations.clear()
self.currentWidget().clear_results()
editor_widget.show_run_cursor()
# Parse query
error = True
try:
result = parser.parse(query)
except MissingQuoteError as reason:
title = self.tr("Error de Sintáxis")
text = self.parse_error(str(reason))
except InvalidSyntaxError as reason:
title = self.tr("Error de Sintáxis")
text = self.parse_error(
str(reason) + "\n" +
self.tr("El error comienza con " + reason.character))
except DuplicateRelationNameError as reason:
title = self.tr("Nombre duplicado")
text = self.tr("Ya existe una relación con el nombre <b>{}</b> :(."
"<br><br>Elige otro por favor ;).".format(
reason.rname))
except ConsumeError as reason:
title = self.tr("Error de Sintáxis")
text = self.parse_error(str(reason))
else:
error = False
if error:
QMessageBox.critical(self, title, text)
return
relations.update(table_widget.relations)
for relation_name, expression in result.items():
try:
new_relation = eval(expression, {}, relations)
except Exception as reason:
QMessageBox.critical(self, self.tr("Error de Consulta"),
self.parse_error(str(reason)))
return
relations[relation_name] = new_relation
self.__add_table(new_relation, relation_name)
def add_tuple(self):
lateral = Pireal.get_service("lateral_widget")
if lateral.relation_list.has_item() == 0:
return
# rname = lateral.relation_list.item_text(lateral.relation_list.row())
rname = lateral.relation_list.current_text()
from src.gui.dialogs.edit_relation_dialog import EditRelationDialog
dialog = EditRelationDialog(rname, self)
tw = self.get_active_db().table_widget
dialog.sendData.connect(tw.insert_rows)
dialog.show()
def _change_font(self, font):
# FIXME: un quilombo esto
central = Pireal.get_service("central")
mcontainer = central.get_active_db()
if mcontainer is not None:
query_widget = mcontainer.query_container.currentWidget()
if query_widget is not None:
weditor = query_widget.get_editor()
if weditor is not None:
qs = QSettings(settings.SETTINGS_PATH, QSettings.IniFormat)
weditor.set_font(font)
qs.setValue("font", font)
def delete_tuple(self):
lateral = Pireal.get_service("lateral_widget")
if lateral.relation_list.has_item() == 0:
return
r = QMessageBox.question(
self, self.tr("Eliminar tupla/s"),
self.tr("Seguro que quiere eliminar las tuplas seleccionadas?"),
QMessageBox.Yes | QMessageBox.Cancel)
if r == QMessageBox.Cancel:
return
tw = self.get_active_db().table_widget
tw.delete_tuple()
def __undock_editor(self):
new_editor = editor.Editor()
actual_doc = self._editor.document()
new_editor.setDocument(actual_doc)
new_editor.resize(900, 400)
# Set text cursor
tc = self._editor.textCursor()
new_editor.setTextCursor(tc)
# Set title
db = Pireal.get_service("central").get_active_db()
qc = db.query_container
new_editor.setWindowTitle(qc.tab_text(qc.current_index()))
new_editor.show()
def save_query(self, weditor=None):
if weditor is None:
query_widget = Pireal.get_service("query_widget")
# Editor instance
weditor = query_widget.get_active_editor()
if weditor.rfile.is_new:
return self.save_query_as(weditor)
content = weditor.toPlainText()
weditor.rfile.write(content)
weditor.document().setModified(False)
self.emit(SIGNAL("currentFileSaved(QString)"),
self.tr("Archivo guardado: {}").format(weditor.filename))
def save_query_as(self, editor=None):
if editor is None:
query_widget = Pireal.get_service("query_widget")
editor = query_widget.get_active_editor()
directory = os.path.expanduser("~")
filename = QFileDialog.getSaveFileName(self,
self.tr("Guardar Archivo"),
directory)
if not filename:
return
content = editor.toPlainText()
editor.rfile.write(content, filename)
editor.document().setModified(False)
def __undock_editor(self):
new_editor = editor.Editor()
actual_doc = self._editor.document()
new_editor.setDocument(actual_doc)
new_editor.resize(900, 400)
# Set text cursor
tc = self._editor.textCursor()
new_editor.setTextCursor(tc)
# Set title
db = Pireal.get_service("central").get_active_db()
qc = db.query_container
new_editor.setWindowTitle(qc.tab_text(qc.current_index()))
new_editor.show()
def _on_finished(self, code, status):
if status == QProcess.NormalExit == code:
QMessageBox.information(
self, self.tr("Completado!"),
self.tr("Todo ha salido muy bien!"))
if self._check_open.isChecked():
central = Pireal.get_service("central")
rdb = os.path.splitext(self._line_location.text())[0]
pdb = rdb + ".pdb"
central.open_database(pdb)
self.close()
else:
QMessageBox.critical(
self, "Error", "El proceso no se ha completado")
def add_table(self, rows, columns, name, data, fields):
table = Table()
table.setRowCount(rows)
table.setColumnCount(columns)
table.setHorizontalHeaderLabels(fields)
for k, v in list(data.items()):
item = QTableWidgetItem()
item.setText(v)
table.setItem(k[0] - 1, k[1], item)
self.stacked.addWidget(table)
self.stacked.setCurrentIndex(self.stacked.count() - 1)
lateral = Pireal.get_service("lateral")
lateral.add_item_list([name])
def close_db(self):
""" Close data base """
widget = self.stacked.currentWidget()
if isinstance(widget, table_widget.TableWidget):
# Clear list of relations
lateral = Pireal.get_service("lateral")
lateral.clear_items()
lateral.hide()
# Close table widget
self.stacked.removeWidget(widget)
# Add start page
self.show_start_page()
self.__created = False
def new_query(self, filename=''):
pireal = Pireal.get_service("pireal")
db_container = self.get_active_db()
db_container.new_query(filename)
# Enable editor actions
# FIXME: refactoring
pireal.set_enabled_query_actions(True)
zoom_in_action = Pireal.get_action("zoom_in")
zoom_in_action.setEnabled(True)
zoom_out_action = Pireal.get_action("zoom_out")
zoom_out_action.setEnabled(True)
paste_action = Pireal.get_action("paste_action")
paste_action.setEnabled(True)
comment_action = Pireal.get_action("comment")
comment_action.setEnabled(True)
uncomment_action = Pireal.get_action("uncomment")
uncomment_action.setEnabled(True)
def __init__(self):
super(TableWidget, self).__init__()
# vbox = QVBoxLayout(self)
# vbox.setContentsMargins(0, 0, 0, 0)
self._tabs = QTabWidget()
self._tabs.setAutoFillBackground(True)
p = self._tabs.palette()
p.setColor(p.Window, QColor("white"))
self._tabs.setPalette(p)
self._other_tab = QTabWidget()
self._other_tab.setAutoFillBackground(True)
self._other_tab.setPalette(p)
self.addWidget(self._tabs)
self.addWidget(self._other_tab)
self.setSizes([1, 1])
self._other_tab.hide()
self.relations = {}
# Stack
self.stacked = QStackedWidget()
self._tabs.addTab(self.stacked, "Workspace")
self.stacked_result = QStackedWidget()
self._tabs.addTab(self.stacked_result, self.tr("Resultados"))
btn_split = QToolButton()
btn_split.setToolTip(self.tr("Click para dividir la pantalla"))
btn_split.setAutoRaise(True)
btn_split.setIcon(QIcon(":img/split"))
self._tabs.setCornerWidget(btn_split)
btn_split.clicked.connect(self._split)
btn_split = QToolButton()
btn_split.setToolTip(self.tr("Click para juntar las pantallas"))
btn_split.setAutoRaise(True)
btn_split.setIcon(QIcon(":img/split"))
btn_split.clicked.connect(self._unsplit)
self._other_tab.setCornerWidget(btn_split)
# self.setContextMenuPolicy(Qt.CustomContextMenu)
# self.customContextMenuRequested.connect(self._show_menu)
lateral_widget = Pireal.get_service("lateral_widget")
lateral_widget.resultClicked.connect(self._on_result_list_clicked)
lateral_widget.resultSelectionChanged.connect(
lambda index: self.stacked_result.setCurrentIndex(index))
def load_relation(self, filenames=[]):
""" Load relation from file """
import csv
from PyQt4.QtGui import QTableWidgetItem, QTableWidget
from src.core import relation
if not filenames:
native_dialog = QFileDialog.DontUseNativeDialog
directory = os.path.expanduser("~")
ffilter = settings.RFILES.split(';;')[-1]
filenames = QFileDialog.getOpenFileNames(self,
self.tr("Abrir Archivo"),
directory, ffilter,
native_dialog)
if not filenames:
return
lateral = Pireal.get_service("lateral")
for filename in filenames:
rel = relation.Relation(filename)
relation_name = os.path.splitext(os.path.basename(filename))[0]
self.table_widget.relations[relation_name] = rel
table = QTableWidget()
with open(filename, newline='') as f:
table.setRowCount(0)
table.setColumnCount(0)
csv_reader = csv.reader(f)
for row_data in csv_reader:
row = table.rowCount()
table.setColumnCount(len(row_data))
for column, data in enumerate(row_data):
item = QTableWidgetItem()
item.setText(data)
if row == 0:
table.setHorizontalHeaderItem(column, item)
else:
table.setItem(row - 1, column, item)
table.insertRow(row)
table.removeRow(table.rowCount() - 1)
self.table_widget.stacked.addWidget(table)
#FIXME: names
names = [os.path.splitext(os.path.basename(i))[0]
for i in filenames]
lateral.add_item_list(names)
lateral.show()
def show_relation(self, item):
central_widget = Pireal.get_service("central")
table_widget = central_widget.get_active_db().table_widget
rela = self.relations[item.name]
dialog = QDialog(self)
dialog.resize(700, 500)
dialog.setWindowTitle(item.name)
box = QVBoxLayout(dialog)
box.setContentsMargins(5, 5, 5, 5)
table = table_widget.create_table(rela, editable=False)
box.addWidget(table)
hbox = QHBoxLayout()
btn = QPushButton(self.tr("Ok"))
btn.clicked.connect(dialog.close)
hbox.addStretch()
hbox.addWidget(btn)
box.addLayout(hbox)
dialog.show()
def show_relation(self, item):
central_widget = Pireal.get_service("central")
table_widget = central_widget.get_active_db().table_widget
rela = self.relations[item.name]
dialog = QDialog(self)
dialog.resize(700, 500)
dialog.setWindowTitle(item.name)
box = QVBoxLayout(dialog)
box.setContentsMargins(5, 5, 5, 5)
table = table_widget.create_table(rela, editable=False)
box.addWidget(table)
hbox = QHBoxLayout()
btn = QPushButton(self.tr("Ok"))
btn.clicked.connect(dialog.close)
hbox.addStretch()
hbox.addWidget(btn)
box.addLayout(hbox)
dialog.show()
def __init__(self, parent=None):
QWidget.__init__(self, parent)
vbox = QVBoxLayout(self)
vbox.setContentsMargins(0, 0, 0, 0)
vbox.setSpacing(0)
self.setStyleSheet("outline: none")
hbox = QHBoxLayout()
# Position
self._column_str = "Col: {}"
self._column_lbl = QLabel(self._column_str.format(0))
# Toolbar
self._toolbar = QToolBar(self)
self._toolbar.setIconSize(QSize(16, 16))
pireal = Pireal.get_service("pireal")
for action in self.TOOLBAR_ITEMS:
qaction = pireal.get_action(action)
if qaction is not None:
self._toolbar.addAction(qaction)
else:
self._toolbar.addSeparator()
# hbox.addWidget(self._toolbar, 1)
# hbox.addWidget(self._column_lbl)
vbox.addLayout(hbox)
# Editor
self._editor = editor.Editor()
vbox.addWidget(self._editor)
# Search widget
self._search_widget = SearchWidget(self)
self._search_widget.hide()
vbox.addWidget(self._search_widget)
# Editor connections
self._editor.customContextMenuRequested.connect(
self.__show_context_menu)
self._editor.modificationChanged[bool].connect(
lambda modified: self.editorModified.emit(modified))
self._editor.undoAvailable[bool].connect(
self.__on_undo_available)
self._editor.redoAvailable[bool].connect(
self.__on_redo_available)
self._editor.copyAvailable[bool].connect(
self.__on_copy_available)
self._editor.cursorPositionChanged.connect(
self._update_column_label)
def new_query(self, filename=''):
pireal = Pireal.get_service("pireal")
db_container = self.get_active_db()
db_container.new_query(filename)
# Enable editor actions
# FIXME: refactoring
pireal.set_enabled_query_actions(True)
zoom_in_action = Pireal.get_action("zoom_in")
zoom_in_action.setEnabled(True)
zoom_out_action = Pireal.get_action("zoom_out")
zoom_out_action.setEnabled(True)
paste_action = Pireal.get_action("paste_action")
paste_action.setEnabled(True)
comment_action = Pireal.get_action("comment")
comment_action.setEnabled(True)
uncomment_action = Pireal.get_action("uncomment")
uncomment_action.setEnabled(True)
search_action = Pireal.get_action("search")
search_action.setEnabled(True)
def remove_relation(self):
lateral = Pireal.get_service("lateral")
rname = lateral.get_relation_name()
if not rname:
QMessageBox.critical(self, self.tr("Error"),
self.tr("No se ha seleccionado ninguna "
"relación."))
return
r = QMessageBox.question(self, self.tr("Confirmación"),
self.tr("Seguro que quieres eliminar la "
"relación <b>{}</b>").format(rname),
QMessageBox.Yes | QMessageBox.No)
if r == QMessageBox.No:
return
index = lateral.current_index()
# Remove table
self.table_widget.remove_table(index)
# Remove item from list widget
lateral.remove_item(index)
def add_table_from_rdb_content(self, content):
lateral = Pireal.get_service("lateral")
lateral.show()
for line in content.splitlines():
if line.startswith('@'):
table = Table()
name = line.split(':')[0][1:]
lateral.add_item_list([name])
fields = line.split(':')[-1].split(',')[:-1]
table.setColumnCount(len(fields))
table.setHorizontalHeaderLabels(fields)
self.stacked.addWidget(table)
else:
row = table.rowCount()
for e, i in enumerate(line.split(',')):
item = QTableWidgetItem()
item.setText(i)
table.setItem(row - 1, e, item)
table.insertRow(row)
def _on_accept(self):
central = Pireal.get_service("central")
table_widget = central.get_active_db().table_widget
relation = table_widget.relations[self._rname]
lines = self._editor.toPlainText().splitlines()
tuples = [tuple(t.split(",")) for t in lines]
for e, t in enumerate(tuples):
if len(t) != relation.degree():
QMessageBox.critical(
self,
"Error",
self.tr("La relación <b>{}</b> es de grado <b>{}</b>.<br> "
"Ingresaste <b>{}</b> datos a la "
"tupla <b>{}</b> :/".format(
self._rname,
relation.degree(), len(t), e + 1)))
return
self.sendData.emit(tuples)
self.close()
def __create_table(self):
# Name of relation
name = self._line_relation_name.text()
if not name.strip():
QMessageBox.critical(self, self.tr("Error"),
self.tr("Nombre de relación no especificado"))
return
rows = self._table.rowCount()
columns = self._table.columnCount()
rel = relation.Relation()
# Header of relation
fields = []
for i in range(columns):
text = self._table.item(0, i).text()
if not text.strip():
QMessageBox.critical(self, self.tr("Error"),
self.tr("Nombre de campo inválido"))
return
fields.append(text)
rel.fields = fields
# Data
data = {}
for row in range(1, rows):
reg = []
for column in range(columns):
item = self._table.item(row, column)
if item is None or not item.text().strip():
QMessageBox.critical(self, self.tr("Campo vacío"),
self.tr("El campo {0}:{1} está "
"vacío").format(row + 1, column + 1))
return
reg.append(self._table.item(row, column).text())
data[row, column] = self._table.item(row, column).text()
rel.insert(reg)
# Add table and relation
table_widget = Pireal.get_service("container").table_widget
table_widget.add_table(rows - 1, columns, name, data, fields)
table_widget.relations[name] = rel
self.close()
def __on_wizard_finished(self, *data):
"""This slot execute when wizard to create a database is finished"""
pireal = Pireal.get_service("pireal")
if data:
db_name, location, fname = data
# Create a new data base container
db_container = database_container.DatabaseContainer()
# Associate the file name with the PFile object
pfile_object = pfile.File(fname)
# Associate PFile object with data base container
# and add widget to stacked
db_container.pfile = pfile_object
self.add_widget(db_container)
# Set window title
pireal.change_title(file_manager.get_basename(fname))
# Enable db actions
pireal.set_enabled_db_actions(True)
pireal.set_enabled_relation_actions(True)
self.created = True
logger.debug("La base de datos ha sido creada con éxito")
def __init__(self, parent=None):
QWidget.__init__(self, parent)
vbox = QVBoxLayout(self)
vbox.setContentsMargins(0, 0, 0, 0)
vbox.setSpacing(0)
self.setStyleSheet("outline: none")
hbox = QHBoxLayout()
# Position
self._column_str = "Col: {}"
self._column_lbl = QLabel(self._column_str.format(0))
# Toolbar
self._toolbar = QToolBar(self)
self._toolbar.setIconSize(QSize(16, 16))
pireal = Pireal.get_service("pireal")
for action in self.TOOLBAR_ITEMS:
qaction = pireal.get_action(action)
if qaction is not None:
self._toolbar.addAction(qaction)
else:
self._toolbar.addSeparator()
# hbox.addWidget(self._toolbar, 1)
# hbox.addWidget(self._column_lbl)
vbox.addLayout(hbox)
# Editor
self._editor = editor.Editor()
vbox.addWidget(self._editor)
# Search widget
self._search_widget = SearchWidget(self)
self._search_widget.hide()
vbox.addWidget(self._search_widget)
# Editor connections
self._editor.customContextMenuRequested.connect(
self.__show_context_menu)
self._editor.modificationChanged[bool].connect(
lambda modified: self.editorModified.emit(modified))
self._editor.undoAvailable[bool].connect(self.__on_undo_available)
self._editor.redoAvailable[bool].connect(self.__on_redo_available)
self._editor.copyAvailable[bool].connect(self.__on_copy_available)
self._editor.cursorPositionChanged.connect(self._update_column_label)
def _create(self):
relation_name = self._line_relation_name.text().strip()
if not relation_name:
QMessageBox.critical(self, "Error",
self.tr("Relation name "
"not specified"))
return
central = Pireal.get_service("central")
if relation_name in central.get_active_db().table_widget.relations:
QMessageBox.information(
self,
"Error",
self.tr("Ya existe una relación con el nombre "
"<b>{}</b>.".format(relation_name))
)
return
# Table model
model = self._view.model()
# Row and column count
nrow = model.rowCount()
ncol = model.columnCount()
# Create new relation object
rela = relation.Relation()
# Header
try:
header = []
for i in range(ncol):
text = model.horizontalHeaderItem(i).text().strip()
header.append(text)
rela.header = header
except Exception as reason:
QMessageBox.critical(self,
self.tr("Header error"),
str(reason))
return
# Load relation
for row in range(nrow):
tuples = []
for column in range(ncol):
item = model.item(row, column)
try:
if not item.text().strip():
raise Exception
except:
QMessageBox.information(
self,
"Algo ha salido mal",
self.tr("Los espacios en blanco son tan aburridos :/."
"<br><br>Por favor ingrese un dato en la "
"fila <b>{}</b>, columna:<b>{}</b>".format(
row + 1, column + 1)))
return
tuples.append(item.text().strip())
rela.insert(tuple(tuples))
# Data
# self.data = rela, relation_name
self.created.emit(rela, relation_name)
self.close()
def __open_preferences(self):
central_widget = Pireal.get_service("central")
central_widget.show_settings()
def __on_redo_available(self, value):
""" Change state of redo action """
pireal = Pireal.get_service("pireal")
action = pireal.get_action("redo_action")
action.setEnabled(value)
def __remove_current(self, path):
central_widget = Pireal.get_service("central")
central_widget.recent_databases.remove(path)
def __open_database(self, path=''):
central_widget = Pireal.get_service("central")
central_widget.open_database(path)
def __new_database(self):
central_widget = Pireal.get_service("central")
central_widget.create_database()
def open_database(self, filename='', remember=True):
""" This function opens a database and set this on the UI """
if self.created:
return self.__say_about_one_db_at_time()
# If not filename provide, then open dialog to select
if not filename:
if self.__last_open_folder is None:
directory = os.path.expanduser("~")
else:
directory = self.__last_open_folder
filter_ = settings.SUPPORTED_FILES.split(';;')[0]
filename, _ = QFileDialog.getOpenFileName(
self, self.tr("Abrir Base de "
"Datos"), directory, filter_)
# If is canceled, return
if not filename:
return
# If filename provide
try:
logger.debug("Intentando abrir el archivo {}".format(filename))
# Read pdb file
pfile_object = pfile.File(filename)
db_data = pfile_object.read()
# Create a dict to manipulate data more easy
db_data = self.__sanitize_data(db_data)
except Exception as reason:
QMessageBox.information(self,
self.tr("El archivo no se puede abrir"),
reason.__str__())
logger.debug("Error al abrir el archivo {0}: '{1}'".format(
filename, reason.__str__()))
return
# Create a database container widget
db_container = database_container.DatabaseContainer()
try:
db_container.create_database(db_data)
except Exception as reason:
QMessageBox.information(self, self.tr("Error"), str(reason))
logger.debug("Error al crear la base de datos: {}".format(
reason.__str__()))
return
# Set the PFile object to the new database
db_container.pfile = pfile_object
# Add data base container to stacked
self.add_widget(db_container)
# Database name
db_name = file_manager.get_basename(filename)
# Update title with the new database name, and enable some actions
pireal = Pireal.get_service("pireal")
self.databaseConected.emit(self.tr("Conectado a: {}".format(db_name)))
pireal.set_enabled_db_actions(True)
pireal.set_enabled_relation_actions(True)
if remember:
# Add to recent databases
self.recent_databases = filename
# Remember the folder
self.__last_open_folder = file_manager.get_path(filename)
self.created = True
def close_database(self):
""" Close the database and return to the main widget """
db = self.get_active_db()
query_container = db.query_container
if db.modified:
msgbox = QMessageBox(self)
msgbox.setIcon(QMessageBox.Question)
msgbox.setWindowTitle(self.tr("Guardar cambios?"))
msgbox.setText(
self.tr("La base de datos <b>{}</b> ha sido "
"modificada.<br>Quiere guardar los "
"cambios?".format(db.dbname())))
cancel_btn = msgbox.addButton(self.tr("Cancelar"),
QMessageBox.RejectRole)
msgbox.addButton(self.tr("No"), QMessageBox.NoRole)
yes_btn = msgbox.addButton(self.tr("Si"), QMessageBox.YesRole)
msgbox.exec_()
r = msgbox.clickedButton()
if r == cancel_btn:
return
if r == yes_btn:
self.save_database()
# Check if editor is modified
query_widget = query_container.currentWidget()
if query_widget is not None:
weditor = query_widget.get_editor()
if weditor is not None:
# TODO: duplicate code, see tab widget
if weditor.modified:
msgbox = QMessageBox(self)
msgbox.setIcon(QMessageBox.Question)
msgbox.setWindowTitle(self.tr("Archivo modificado"))
msgbox.setText(
self.tr("El archivo <b>{}</b> tiene cambios"
" no guardados. Quiere "
"mantenerlos?".format(weditor.name)))
cancel_btn = msgbox.addButton(self.tr("Cancelar"),
QMessageBox.RejectRole)
msgbox.addButton(self.tr("No"), QMessageBox.NoRole)
yes_btn = msgbox.addButton(self.tr("Si"),
QMessageBox.YesRole)
msgbox.exec_()
r = msgbox.clickedButton()
if r == cancel_btn:
return
if r == yes_btn:
self.save_query(weditor)
self.stacked.removeWidget(db)
pireal = Pireal.get_service("pireal")
pireal.set_enabled_db_actions(False)
pireal.set_enabled_relation_actions(False)
pireal.set_enabled_query_actions(False)
pireal.set_enabled_editor_actions(False)
pireal.change_title() # Título en la ventana principal 'Pireal'
self.created = False
del db
def __new_relation(self):
central_service = Pireal.get_service("central")
central_service.create_new_relation()
