class UApp(UWindow, UTools): # The main class of the GUI.
def __init__(self, parent=None): # Constructor of the class.
super(UApp, self).__init__(parent) # Initialization of the class.
UTools.__init__(self) # Initialization of the tools
# print(self.us1) # class with functions.
self.apps = QtQuickWidgets.QQuickWidget(self.twid1)
self.apps.setSource(QtCore.QUrl("apps.qml"))
self.properties = self.apps.rootObject()
self.gscene = QtWidgets.QGraphicsScene()
self.gview = UGraphView(self.twid2) # Adding of the graphics view
self.painter = QtGui.QPainter() # to the tab widget, adding
self.gvlay = QtWidgets.QGridLayout() # scene and painter that can
self.gvlay.addWidget(self.gview, 0, 0, 1, 1)
self.gvlay.setContentsMargins(0, 0, 0, 0)
self.twid2.setLayout(self.gvlay) # used, arrange with grid.
self.frame1 = UFrame(self.twid3) # Create the first frame with
self.frame1.setLineWidth(3) # parent as third widget.
self.frame1.setFrameStyle(6) # Styled panel frame style.
self.table = UTabView(self.frame1) # Creation of the table with
self.table.setVisible(False) # parent as frame 1 and gets
model = UTModel() # data from the model.
self.table.setModel(model) # Set model data to the table.
self.text_edit = UTextEd(self.frame1) # Text Edit field with
self.layfr1 = QtWidgets.QGridLayout() # parent - the first frame.
self.layfr1.addWidget(self.table, 0, 0, 1, 1)
self.layfr1.addWidget(self.text_edit, 0, 0, 1, 1)
self.layfr1.setContentsMargins(0, 0, 0, 0)
self.frame1.setLayout(self.layfr1) # Layout for this field.
self.frame2 = UFrame(self.twid3) # Second Frame with parent.
self.frame2.setLineWidth(3) # Sets line width of the frame
self.frame2.setFrameStyle(0) # and 0 - style No frame.
self.frame2.setMaximumWidth(int(self.width() / 3))
self.label1 = ULabel(self.frame2) # Label for the second frame.
self.label1.setText("User Information")
self.label1.setAlignment(QtCore.Qt.AlignCenter)
self.combox1 = UComBox(self.frame2) # Add the combobox with items.
self.combox1.addItems(["Texts", "Table"])
self.combox1.setView(UListV()) # Combo popup list view.
self.line_ed1 = ULineEd(self.frame2) # Line edit with placeholder.
self.line_ed1.setPlaceholderText("Full Name...")
self.line_ed2 = ULineEd(self.frame2) # Second will for user email.
self.line_ed2.setPlaceholderText("Email...")
self.line_ed3 = ULineEd(self.frame2) # Third field for password,
self.line_ed3.setPlaceholderText("Password...")
self.line_ed3.setEchoMode(QtWidgets.QLineEdit.Password)
self.push_but1 = UBut1(self.frame2) # Adding button with text
self.push_but1.setText("Save") # for saving operations.
self.push_but2 = UBut1(self.frame2) # Adding button with text
self.push_but2.setText("Ok") # for other operations.
self.progress1 = UProgress(self.frame2)
self.progress1.setRange(0, 0) # Progress bar with range.
self.layfr2_1 = QtWidgets.QGridLayout()
self.layfr2_1.addWidget(self.push_but1, 0, 0, 1, 1)
self.layfr2_1.addWidget(self.push_but2, 0, 1, 1, 1)
self.layfr2_1.addWidget(self.progress1, 1, 0, 1, 2)
self.layfr2_1.setSpacing(3) # Widgets spacing for layout.
self.layfr2 = QtWidgets.QGridLayout() # Second frame`s layout.
self.layfr2.addWidget(self.combox1, 0, 0, 1, 1)
self.layfr2.addWidget(self.label1, 1, 0, 1, 1)
self.layfr2.addWidget(self.line_ed1, 2, 0, 1, 1)
self.layfr2.addWidget(self.line_ed2, 3, 0, 1, 1)
self.layfr2.addWidget(self.line_ed3, 4, 0, 1, 1)
self.layfr2.addLayout(self.layfr2_1, 5, 0, 1, 1)
self.layfr2.setSpacing(3) # Spacing between widgets.
self.layfr2.setContentsMargins(3, 3, 3, 3)
self.frame2.setLayout(self.layfr2) # Set layout to second frame.
self.lay1 = QtWidgets.QGridLayout() # Layout for the third tabwid.
self.lay1.addWidget(self.frame1, 0, 0, 1, 1)
self.lay1.addWidget(self.frame2, 0, 1, 1, 1)
self.twid3.setLayout(self.lay1) # Adding frames to tab widget.
self.mb1.triggered.connect(self.files)
self.mb2.triggered.connect(self.edit) # Calling files, edit, data,
self.mb2_1.triggered.connect(self.edit_align)
self.mb3.triggered.connect(self.data) # optins, and help function.
self.mb4.triggered.connect(self.options)
self.mb5.triggered.connect(self.on_help)
self.qmlbut1 = self.properties.childItems()[0].childItems()[0]
self.qmlbut1.clicked.connect(self.video_camera)
self.qmlbut2 = self.properties.childItems()[0].childItems()[1]
self.qmlbut2.clicked.connect(self.qml_apps)
self.qmlbut3 = self.properties.childItems()[0].childItems()[2]
self.qmlbut3.clicked.connect(self.jupyter)
self.qmlbut4 = self.properties.childItems()[0].childItems()[3]
self.qmlbut4.clicked.connect(self.web_browse)
self.combox1.activated.connect(self.txt_table)
self.push_but1.clicked.connect(self.save_data)
self.push_but2.clicked.connect(self.vis)
self.print_device = QtPrintSupport.QPrinter()
self.actx = "" # Empty string for actions.
self.qapp1 = 0 # Value for the qml button 1.
self.qapp2 = 0 # Value for the qml button 2.
self.qapp3 = 0 # Value for the qml button 3.
self.qapp4 = 0 # Value for the qml button 4.
self.pool = QtCore.QThreadPool()
def long_loop(self): # Function for starting the
while True: # while instruction.
QtWidgets.qApp.processEvents(QtCore.QEventLoop.AllEvents)
print("HELLO") # Will print string.
def vis(self): # Set the 2d tab widget as
self.tabwid.setCurrentIndex(1) # current, set device window
desktop = QtWidgets.QApplication.desktop()
self.setGeometry(desktop.availableGeometry())
self.visualize() # size, and call the function.
def visualize(self): # Function visualizes data.
self.gscene.clear() # Clear current graphics scene
self.gview.resetCachedContent() # with reset cache content.
self.gview.setScene(self.gscene) # Sets scene to the view with
self.gview.setSceneRect(self.gscene.sceneRect())
self.pen = QtGui.QPen() # scene rectangle. Creates pen
self.scw = float(self.tabwid.currentWidget().width() - 30)
self.sch = float(self.tabwid.currentWidget().height() - 30)
try: # that used to draw lines.
dline = self.draws(w=self.scw, h=self.sch)
def to_line(xy, er): # Will be called when thread
if er == '': # will emit signal with data.
color = QtGui.QColor("#00D9FF")
cmyk = color.toCmyk() # Changing of the color used
c = cmyk.cyanF() # with pen. The particles of
m = cmyk.magentaF() * float(1 / xy[1])
y = cmyk.yellowF() * float(1 / xy[1])
k = cmyk.blackF() * float(1 / xy[1])
a = cmyk.alphaF() # CMYK, alpha-transparency.
color.setCmykF(c, m, y, k, a)
self.pen.setColor(color) # Set new color to pen and
self.gscene.addLine(
QtCore.QLineF(xy[1], self.sch, xy[1], xy[0]), self.pen)
else:
self.stat_bar.showMessage(self.actx + ' ' + er)
dline.sig1.connect(to_line, QtCore.Qt.QueuedConnection)
except Exception as err: # draw line with new position.
self.stat_bar.showMessage(self.actx + ' ' + str(err))
def resizeEvent(self, event): # Resize event handler.
self.properties.setWidth(float(self.tabwid.currentWidget().width()))
self.properties.setHeight(float(self.tabwid.currentWidget().height()))
def video_camera(self): # Function, run video camera.
self.qapp1 += 1 # Will add to this variable 1
if self.qapp1 == 1: # when button will be clicked.
# subprocess.Popen(["python", r"u_media.py"])
self.approc1 = QtCore.QProcess() # Run procces with QProcces
self.approc1.start("python", ["u_media.py"]) #
if self.qapp1 == 2: # startung file with Python.
self.approc1.kill() # If the button clicked at
self.qapp1 = 0 # second, kills process.
def qml_apps(self): # Function to sart QML apps.
self.qapp2 += 1 # Runs the file with starting
if self.qapp2 == 1: # instructions for QML`s.
# subprocess.Popen(["python", r"u_qml.py"])
self.approc2 = QtCore.QProcess() # The QProcess uses the start
self.approc2.start("python", ["u_qml.py"])
if self.qapp2 == 2: # function with command to run
self.approc2.kill() # with Python and file name in
self.qapp2 = 0 # the working directory.
def jupyter(self): # Function to sart Jupyter.
self.qapp3 += 1 # Runs the jupyter available
if self.qapp3 == 1: # in the Anaconda toolset.
# subprocess.Popen(["jupyter", ["notebook", "--browser=firefox"])
self.approc3 = QtCore.QProcess() # The QProcess uses the start
self.approc3.start("jupyter", ["notebook", "--browser=firefox"])
if self.qapp3 == 2: # command to run jupyter
self.approc3.kill() # notebook with specified
self.qapp3 = 0 # browser that can be changed.
def web_browse(self): # Function to sart webbrowser.
self.qapp4 += 1 # Runs the default web browser
if self.qapp4 == 1: # available in the system.
# subprocess.Popen("python", ["-m", "webbrowser", "-n",
# "https://www.python.org"])
self.approc4 = QtCore.QProcess() # The QProcess uses the start
self.approc4.start(
"python", ["-m", "webbrowser", "-n", "https://www.python.org"])
if self.qapp4 == 2: # command to open the URL of
self.approc4.kill() # the page that is specified
self.qapp4 = 0 # in the default browser.
def txt_table(self): # The function that will
if self.combox1.currentText() == "Texts":
self.text_edit.setVisible(True) # visualize the table and text
self.table.setVisible(False) # depends on choice of combo.
if self.combox1.currentText() == "Table":
self.text_edit.setVisible(False) # When the text activated,
self.table.setVisible(True) # elements visible or not.
def files(self, action): # Function open/save files.
fd = QtWidgets.QFileDialog() # File dialog instance.
if action.text() == "Open": # For opening of the files.
fdf = fd.getOpenFileNames(self,
caption="Open Files",
directory=QtCore.QDir.homePath())
if len(fdf[0]) > 0: # Checks if the file dialog
self.text_edit.clear() # has a selected files for
for of in fdf[0]: # open. Each file of the
self.tabwid.setCurrentIndex(2) # selected will be open.
try: # Will try to open file as
openf = open(of, 'r') # simple .txt or .html and,
self.text_edit.append(str(openf.read()))
continue # read content to text field.
except Exception: # If successfull continue.
pass # If unread or error - pass.
try: # Try to open file in the
openf = open(of, 'rb') # binary mode .py or other.
self.text_edit.append(str(openf.read()))
except Exception: # Content to the field, if
pass # error - pass (do nothing).
if action.text() == "Save": # For saving of the files.
fdf = fd.getSaveFileName(self,
caption="Save Files",
directory=QtCore.QDir.homePath())
if fdf[0] != "": # Checks if files selected.
self.tabwid.setCurrentIndex(2) # Open TabWid with Text Field.
try: # Will try to save file as
open(fdf[0], 'w').write(self.text_edit.toPlainText())
success = True # .txt file with plain text of
except Exception: # text field. And success is
pass # True. An error - pass.
if success != True: # If file not saved as .txt
try: # will try to save file in the
open(fdf[0], 'wb').write(self.text_edit.toPlainText())
success = True # binary mode, as plain text.
except Exception: # An exception - will pass.
pass # If success is True will
if success == True: # shown information message.
self.info_message(fpath=fdf[0],
txt="File saved as",
types="info")
else: # If not True, critical.
self.info_message(fpath=fdf[0],
txt="File don`t saved",
types="critical")
if action.text() == "Print":
print_dialog = QtPrintSupport.QPrintDialog(self.print_device)
if print_dialog.exec_() == QtWidgets.QDialog.Accepted:
self.text_edit.print_(print_dialog.printer())
if action.text() == "Print Preview": # Print preview dialog.
print_dialog = QtPrintSupport.QPrintPreviewDialog(
self.print_device)
print_dialog.setWindowTitle("Print Preview")
print_dialog.setWindowIcon(QtGui.QIcon("Icons/python1.png"))
print_dialog.paintRequested.connect(self.text_edit.print_)
print_dialog.exec_() # Executes dialog window.
def edit(self, action): # Function for editing of the
if action.text() == "Undo": # text edit field content.
self.text_edit.undo() # Undoes, Redoes, Cut, Copy,
if action.text() == "Redo": # Paste simple operations.
self.text_edit.redo() # Selected text will be copied
if action.text() == "Cut": # to, or pasted from the
self.text_edit.cut() # buffer if available, the
if action.text() == "Copy": # action indicates which
self.text_edit.copy() # option is selected. The
if action.text() == "Paste": # "Text Color" and "Text Font"
self.text_edit.paste() # will operate with changing
if action.text() == "Text Color": # of the current Font and
self.fd = QtWidgets.QColorDialog() # Color of the selected text.
if self.fd.exec_() == QtWidgets.QDialog.Accepted:
fc = self.fd.selectedColor() # First dialog inherits the
self.text_edit.setTextColor(fc)
if action.text() == "Text Font": # Main Window and have a
self.fd = QtWidgets.QFontDialog() # similar style. Second Font
if self.fd.exec_() == QtWidgets.QDialog.Accepted:
ft = self.fd.selectedFont() # dialog have not a parent
self.text_edit.setFont(ft) # and have default style.
def edit_align(self, action): # Function for submenu option
if action.text() == "center": # text edit field alignment.
self.text_edit.setAlignment(QtCore.Qt.AlignCenter)
if action.text() == "left": # Will align the text by
self.text_edit.setAlignment(QtCore.Qt.AlignLeft)
if action.text() == "right": # center, to left, to right,
self.text_edit.setAlignment(QtCore.Qt.AlignRight)
if action.text() == "justify": # or justified of the field.
self.text_edit.setAlignment(QtCore.Qt.AlignJustify)
def options(self, action): # Function to run tools by
if action.text() == "Settings": # selectection options items.
from u_settings import USets # Importing class for color
self.sets = USets() # settings, class instance.
self.sets.show() # Widget for color settings.
self.sets.bsave.clicked.connect(self.sets_but)
self.sets.breset.clicked.connect(self.to_default)
if action.text() == "Run": # Option will run execution
action.setEnabled(False) # of the script from text
datas = self.text_edit.toPlainText()
try: # edit filed and will append
self.text_edit.append("\n\n\n\n\nRESULT -----------> %s\n" %
time.strftime("%Y.%m.%d %H:%M:%S"))
runs = self.run_code(datas=datas)
def to_field(sto, ste, er): # the result to text filed.
if er == '': # For running the code used
self.text_edit.append(str(sto) + "\n" + str(ste))
else: # thread and class that moved
self.stat_bar.showMessage(er)
runs[1].sig1.connect(to_field, QtCore.Qt.QueuedConnection)
runs[0].quit() # to this thread. Called
def on_stop(): # function returns the tuple
action.setEnabled(True) # with thread and class. Sends
runs[0].finished.connect(on_stop)
except Exception as err: # finished signal from thread.
self.stat_bar.showMessage(str(err))
if action.text() == "Configuration": # Option for check current
def get_info(): # working environment. Checks
if self.uwid1.infocomb.currentIndex() == 0:
try: # Anaconda available packages
condinf = subprocess.Popen(["conda", "list"],
stdout=subprocess.PIPE)
conp = condinf.communicate()
self.uwid1.infotxt.setText(conp[0].decode("utf-8"))
except Exception as err:
self.uwid1.infotxt.setText(str(err))
if self.uwid1.infocomb.currentIndex() == 1:
try: # and Python packages that
condinf = subprocess.Popen(["pip", "list"],
stdout=subprocess.PIPE)
conp = condinf.communicate()
self.uwid1.infotxt.setText(
"""Platform: %s\nPython %s version
\nPython path list: %s\n\nRecursion limit: %s
\nFilesystem encoding: %s\nDefault encoding: %s
\nAvailable installed packages: \n\n%s""" %
(sys.platform, sys.version, sys.path,
sys.getrecursionlimit(),
sys.getfilesystemencoding(),
sys.getdefaultencoding(),
conp[0].decode("utf-8")))
except Exception as err: # installed with pip. Option
self.uwid1.infotxt.setText(str(err))
self.uwid1 = UWidget() # for "pip" use various tools
self.uwid1.setWindowTitle("Configuration")
self.uwid1.infocomb.addItems(["conda", "pip"])
self.uwid1.infotxt.setReadOnly(True)
self.uwid1.infotxt.setVisible(True)
self.uwid1.show() # of the sys module for info.
self.uwid1.infocomb.activated.connect(get_info)
def on_help(self, action): # Function realizes the help
if action.text() == "Online Help": # option of the top panel.
self.uwid2 = UWidget() # Using widget for visualize
self.uwid2.setWindowTitle("Online Help")
self.uwid2.infocomb.setVisible(False)
self.uwid2.infotxt.setReadOnly(True)
self.uwid2.infotxt.setVisible(False)
self.uwid2.wview.setVisible(True) # online documentation and
html = open("help.html", "r").read()
self.uwid2.wview.setHtml(html) # help from remote resources,
self.uwid2.show() # "Online Help" sets existed
if action.text() == "Documentation": # .html file with script.
def get_docs(): # "Documentation" option load
if self.uwid3.infocomb.currentIndex() == 0:
try: # URLs to the Web Engine View
self.uwid3.wview.load( # and visualize documentation
QtCore.QUrl("https://docs.python.org/3/"))
except Exception as err: # from the sources specified.
self.stat_bar.showMessage(str(err))
if self.uwid3.infocomb.currentIndex() == 1:
try: # The base widget is used to
self.uwid3.wview.load( # arrange web view and combo
QtCore.QUrl(
"https://www.riverbankcomputing.com/static/Docs/PyQt5/"
))
except Exception as err: # in the separate window.
self.stat_bar.showMessage(str(err))
if self.uwid3.infocomb.currentIndex() == 2:
try: # The nested functions checks
self.uwid3.wview.load( # which option of the combobox
QtCore.QUrl(
"https://doc.qt.io/qtforpython/index.html"))
except Exception as err: # is selected and load URL.
self.stat_bar.showMessage(str(err))
self.uwid3 = UWidget() # Combobox use activated()
self.uwid3.setWindowTitle("Documentation")
self.uwid3.infocomb.addItems(["Python", "PyQt5", "PySide2"])
self.uwid3.infotxt.setReadOnly(True)
self.uwid3.infotxt.setVisible(False)
self.uwid3.wview.setVisible(True) # signal to connect the nested
self.uwid3.show() # function. Sets Visibility.
self.uwid3.infocomb.activated.connect(get_docs)
def sets_but(self): # Function for "Save" clicks.
colors = "%s %s %s %s" % (self.sets.bgle1.text(), self.sets.bgle2.text(
), self.sets.colle1.text(), self.sets.colle2.text())
save_open = open("settings.txt", "w") # Opens settings.txt file and
save_open.write(colors) # writes the colors from line
save_open.close() # edit field, then closes.
self.new_app() # Call the function for new.
def to_default(self): # Function to restore the
u_defaults.txt_file(state=True) # default colors and calling
self.new_app() # new app in the subprocess.
def new_app(self): # Function to re-open new app.
self.sets.hide() # Hides the widget (optional).
subprocess.Popen(["python", r"u_app.py"])
sys.exit(0) # Run new and exit old app.
def info_message(self, fpath='', txt='', types="info"):
message_box = QtWidgets.QMessageBox(self)
message_box.setStyleSheet("color: #FFFFFF;")
message_box.setFont(QtGui.QFont("Verdana", 12, 77))
message_box.setWindowTitle("Save files")
if types == "info": # Function with message box.
message_box.setIcon(QtWidgets.QMessageBox.Information)
if types == "critical": # Critical message box.
message_box.setIcon(QtWidgets.QMessageBox.Critical)
message_box.addButton(QtWidgets.QMessageBox.Ok)
message_txt = "%s\n%s" % (txt, fpath) # Adding the button. Text that
message_box.setText(message_txt) # will be shown with box.
message_box.exec_() # Shows this message box.
def data(self, action): # Function for the "Data"
self.text_edit.clear() # panel, if an option will
self.actx = action.text() # select, related data will be
if self.actx == "Pickle": # operated with functionality.
try: # Calls the functions that
txtdata = self.pickle_load(filename=r"data/u_data.py")
self.text_edit.append(str(txtdata))
self.stat_bar.showMessage(self.actx + " opened")
except Exception as err: # open/read data from the
self.stat_bar.showMessage(self.actx + ' ' + str(err))
if self.actx == "Shelve": # file/DB and append to
try: # the text edit field.
db = self.shelve_open(filename="data/u_data")
self.text_edit.append(
"%s\n%s\n%s\n%s" %
(db.get("User Name"), db.get("User email"),
db.get("User password"), db.get("User data")))
self.stat_bar.showMessage(self.actx + " opened")
except Exception as err: # "Pickle" option loads file
self.stat_bar.showMessage(self.actx + ' ' + str(err))
if self.actx == "CSV": # as text. The "Shelve" loads
try: # data as dictionary values.
for row in self.csv_read(csvfile="data/tests.csv"):
self.text_edit.append(
"%s %s %s %s" %
(row["User_Name"], row["User_email"],
row["User_password"], row["User_data"]))
self.stat_bar.showMessage(self.actx + " opened")
except Exception as err: # "CSV" reads the table
self.stat_bar.showMessage(self.actx + ' ' + str(err))
if self.actx == "Pandas": # with the python standard
try: # library csv module. "Pandas"
pread = self.pandas_read(filename="data/bigtests.csv",
reader="csv",
sep=',')
def to_field(df, er): # reads CSV using thread and
if er == '': # nested function, "SQLite"
self.text_edit.append("\n" + str(df))
else: # open and select the values
self.stat_bar.showMessage(self.actx + ' ' + er)
pread.sig1.connect(to_field, QtCore.Qt.QueuedConnection)
self.stat_bar.showMessage(self.actx + " opened")
except Exception as err: # from database. "PostgreSQL"
self.stat_bar.showMessage(self.actx + ' ' + str(err))
if self.actx == "SQLite": # "SQLite" opens and selects
try: # the values from database.
dbdata = self.sqlite_select() # "PostgreSQL" opens and
for dtx in dbdata: # selects data from database.
self.text_edit.append(
"%s\n%s\n%s\n%s\n%s" %
(dtx[0], dtx[1], dtx[2], dtx[3], dtx[4]))
self.stat_bar.showMessage(self.actx + " opened")
except Exception as err: # "MySQL" opens and selects
self.stat_bar.showMessage(self.actx + ' ' + str(err))
if self.actx == "PostgreSQL": # all values from the MySQL
try: # database, "QtSQL" module of
dbdata = self.psql_select() # the Python binding used
for dtx in dbdata: # provides the database
self.text_edit.append(
"%s\n%s\n%s\n%s\n%s" %
(dtx[0], dtx[1], dtx[2], dtx[3], dtx[4]))
self.stat_bar.showMessage(self.actx + " opened")
except Exception as err: # operations of the Qt
self.stat_bar.showMessage(self.actx + ' ' + str(err))
if self.actx == "MySQL": # library, "MongoDB" selects
try: # all values from the NoSQL
dbdata = self.mysql_select() # document oriented database
for dtx in dbdata: # MongoDB, and "CouchDB" opens
self.text_edit.append(
"%s\n%s\n%s\n%s\n%s" %
(dtx[0], dtx[1], dtx[2], dtx[3], dtx[4]))
self.stat_bar.showMessage(self.actx + " opened")
except Exception as err: # data from the NoSQL CouchDB
self.stat_bar.showMessage(self.actx + ' ' + str(err))
if self.actx == "QtSQL": # database. The text that
try: # retreived from the files and
dbdata = self.sql_qt_select() # DB`s appends each value of
while dbdata.next(): # the database to the text
self.text_edit.append(
"%s\n%s\n%s\n%s\n%s" %
(dbdata.value(0), dbdata.value(1), dbdata.value(2),
dbdata.value(3), dbdata.value(4)))
self.stat_bar.showMessage(self.actx + " opened")
except Exception as err: # edit field of this app. This
self.stat_bar.showMessage(self.actx + ' ' + str(err))
if self.actx == "MongoDB": # receives the data to the
try: # text edit field, can be
mongo_data = self.mongo_select()
def to_field(dbdata, er): # changed to the setText()
if er == '': # method that will put just
for dtx in dbdata: # last value from the query.
self.text_edit.append(
"%s\n%s\n%s\n%s" %
(dtx["User Name"], dtx["Email"],
dtx["Password"], dtx["Data"]))
else: # All tools realized in
self.stat_bar.showMessage(self.actx + ' ' + er)
mongo_data.sig1.connect(to_field, QtCore.Qt.QueuedConnection)
self.stat_bar.showMessage(self.actx + " opened")
except Exception as err: # statement and handle all
self.stat_bar.showMessage(self.actx + ' ' + str(err))
if self.actx == "CouchDB": # Exception errors. The errors
try: # represented in the status
couch_data = self.couch_select()
def to_field(dbdata, er): # bar and can contain the
if er == '': # standard errors or related
for dtx in dbdata.view("_all_docs", include_docs=True):
self.text_edit.append("%s\n%s\n%s\n%s" %
(dtx["doc"]["User Name"],
dtx["doc"]["User email"],
dtx["doc"]["User password"],
dtx["doc"]["User Data"]))
else: # errors to the used packages
self.stat_bar.showMessage(self.actx + ' ' + er)
couch_data.sig1.connect(to_field, QtCore.Qt.QueuedConnection)
self.stat_bar.showMessage(self.actx + " opened")
except Exception as err: # in the application.
self.stat_bar.showMessage(self.actx + ' ' + str(err))
def save_data(self): # Function will save the data
self.error = '' # in relation to used tools.
uname = self.line_ed1.text() # User name field value.
umail = self.line_ed2.text() # User email field value.
upass = self.line_ed3.text() # User password field value.
udata = self.text_edit.toPlainText() # Text edit field value.
if (uname != '') and (umail != '') and (upass != ''):
if self.actx == "Pickle": # Pickle option and function.
self.user_data1(uname, umail, upass, udata)
elif self.actx == "Shelve": # Shelve option and function.
self.user_data2(uname, umail, upass, udata)
elif self.actx == "CSV": # CSV option and function.
self.user_data3(uname, umail, upass, udata)
elif self.actx == "Pandas": # Pandas option and function.
self.user_data4(uname, umail, upass, udata)
elif self.actx == "SQLite": # SQLite option and function.
self.user_data5(uname, umail, upass, udata)
elif self.actx == "PostgreSQL": # PostgreSQL option and func.
self.user_data6(uname, umail, upass, udata)
elif self.actx == "MySQL": # MySQL option and function.
self.user_data7(uname, umail, upass, udata)
elif self.actx == "QtSQL": # QtSql option and function.
self.user_data8(uname, umail, upass, udata)
elif self.actx == "MongoDB": # MongoDB option and function.
self.user_data9(uname, umail, upass, udata)
elif self.actx == "CouchDB": # Couch option and function.
self.user_data10(uname, umail, upass, udata)
else: # By default Pickle function.
self.user_data1(uname, umail, upass, udata)
if self.error != '': # If some errors occur, shows
self.stat_bar.showMessage(self.actx + ' ' + str(self.error))
else: # error, else shows message.
self.stat_bar.showMessage(self.actx + " saved")
def user_data1(self, uname, umail, upass, udata):
try: # Function for pickle module.
dictd = {
"User Name": uname,
"User email": umail,
"User password": upass,
"User data": udata
}
self.pickle_dump(obj=dictd, filename=r"data/u_data.py")
except Exception as err: # Data as dictionary to file.
self.error = err # If some error - will pass.
def user_data2(self, uname, umail, upass, udata):
try: # Function for shelve module.
db = self.shelve_open(filename="data/u_data")
db["User Name"] = uname # Writes user name to DB.
db["User email"] = umail # Writes user email to DB.
db["User password"] = upass # Writes user password to DB.
db["User data"] = udata # Writes user data to DB.
db.close() # Opens database, saves data
except Exception as err: # of the text fields to file
self.error = err # and closes database.
def user_data3(self, uname, umail, upass, udata):
fnames = ["User_Name", "User_email", "User_password", "User_data"]
rdata = [uname, umail, upass, udata[:140]]
try: # Function to write CSV.
for row in self.csv_read(csvfile="data/tests.csv"):
if (row["User_Name"] == rdata[0]) and (row["User_password"]
== rdata[2]):
rdata = None # Checks CSV file, if True
except Exception: # data will not be added to
pass # csv file, if erorr - pass.
if rdata is not None: # If is not None, data will be
try: # added to the CSV file.
self.csv_write(csvfile="data/tests.csv",
fieldnames=fnames,
rowdata=rdata,
delimiter=' ',
lineterminator='\n')
except Exception as err: # If some error will occur,
self.error = err # the variable will be error.
def user_data4(self, uname, umail, upass, udata): # CSV files with pandas.
try: # Writing CSV with pandas.
ucolumns = [
"User_Name", "User_email", "User_password", "User_data"
]
self.pandas_write(filename="data/bigtests.csv",
writer="csv",
columns=ucolumns)
except Exception as err: # Put numbers to cells, the
self.error = err # number of rows is 999.
def user_data5(self, uname, umail, upass, udata):
try: # SQLite database function.
self.sqlite_insert(username=uname,
email=umail,
passw=upass,
data=udata)
except Exception as err: # Inserts values of the text
self.error = err # edit field to the SQLite DB.
def user_data6(self, uname, umail, upass, udata):
try: # PostgreSQL DB function.
self.psql_insert(username=uname,
email=umail,
passw=upass,
data=udata)
except Exception as err: # Inserts values of the text
self.error = err # edit field to PostgreSQL.
def user_data7(self, uname, umail, upass, udata):
try: # MySQL database function.
self.mysql_insert(username=uname,
email=umail,
passw=upass,
data=udata)
except Exception as err: # Inserts values of the text
self.error = err # edit field to the MySQL DB.
def user_data8(self, uname, umail, upass, udata):
try: # Using QtSql module function.
self.sql_qt_insert(username=uname,
email=umail,
passw=upass,
data=udata)
except Exception as err: # Inserts values of the text
self.error = err # edit field to the SQLite DB.
def user_data9(self, uname, umail, upass, udata):
try: # NoSQL MongoDB function.
self.mongo_insert(username=uname,
email=umail,
passw=upass,
data=udata)
except Exception as err: # Inserts values of the text
self.error = err # edit field to the Mongo DB.
def user_data10(self, uname, umail, upass, udata):
try: # To document of the CouchDB.
self.couch_insert(username=uname,
email=umail,
passw=upass,
data=udata)
except Exception as err: # Inserts values of the text
self.error = err # edit field to the Couch DB.
def closeEvent(self, event):
self.pool.waitForDone()
class UApp(UWindow, UTools): # Create the main class.
def __init__(self, parent=None): # Constructor of the class.
super(UApp, self).__init__(parent) # Initialization of the class.
UTools.__init__(self) # Initialization of the tools
# print(self.us1) # class with functions.
self.frame1 = UFrame(self.twid3) # Create the first frame with
self.frame1.setLineWidth(3) # parent as third widget.
self.frame1.setFrameStyle(6) # Styled panel frame style.
self.table = UTabView(self.frame1) # Creation of the table with
self.table.setVisible(False) # parent as frame 1 and gets
model = UTModel() # data from the model.
self.table.setModel(model) # Set model data to the table.
self.text_edit = UTextEd(self.frame1) # Text Edit field with
self.layfr1 = QtWidgets.QGridLayout() # parent - the first frame.
self.layfr1.addWidget(self.table, 0, 0, 1, 1)
self.layfr1.addWidget(self.text_edit, 0, 0, 1, 1)
self.layfr1.setContentsMargins(0, 0, 0, 0)
self.frame1.setLayout(self.layfr1) # layout for this field.
self.frame2 = UFrame(self.twid3) # Second frame with parent.
self.frame2.setLineWidth(3) # Sets line width of the frame
self.frame2.setFrameStyle(0) # and 0 - style No frame.
self.frame2.setMaximumWidth(int(self.width() / 3))
self.label1 = ULabel(self.frame2) # Label in the second frame.
self.label1.setText("User Information")
self.label1.setAlignment(QtCore.Qt.AlignCenter)
self.combox1 = UComBox(self.frame2) # Adding the combo box.
self.combox1.addItems(["Texts", "Table"])
self.combox1.setView(UListV()) # Combo box popup view.
self.line_ed1 = ULineEd(self.frame2) # First line edit field.
self.line_ed1.setPlaceholderText("Full Name...")
self.line_ed2 = ULineEd(self.frame2) # Second that for user email.
self.line_ed2.setPlaceholderText("Email...")
self.line_ed3 = ULineEd(self.frame2) # Third field for input passw.
self.line_ed3.setPlaceholderText("Password...")
self.line_ed3.setEchoMode(QtWidgets.QLineEdit.Password)
self.push_but1 = UBut1(self.frame2) # Adding the button with text
self.push_but1.setText("Save") # For saving operations.
self.push_but2 = UBut1(self.frame2) # Adding of the second button.
self.push_but2.setText("Ok") # Adding progress bar with
self.progress1 = UProgress(self.frame2)
self.progress1.setRange(0, 0) # range (indeterminate mode).
self.layfr2_1 = QtWidgets.QGridLayout()
self.layfr2_1.addWidget(self.push_but1, 0, 0, 1, 1)
self.layfr2_1.addWidget(self.push_but2, 0, 1, 1, 1)
self.layfr2_1.addWidget(self.progress1, 1, 0, 1, 2)
self.layfr2_1.setSpacing(3) # Spacing for layout - 3 pix.
self.layfr2 = QtWidgets.QGridLayout() # Layout for second frame.
self.layfr2.addWidget(self.combox1, 0, 0, 1, 1)
self.layfr2.addWidget(self.label1, 1, 0, 1, 1)
self.layfr2.addWidget(self.line_ed1, 2, 0, 1, 1)
self.layfr2.addWidget(self.line_ed2, 3, 0, 1, 1)
self.layfr2.addWidget(self.line_ed3, 4, 0, 1, 1)
self.layfr2.addLayout(self.layfr2_1, 5, 0, 1, 1)
self.layfr2.setSpacing(3) # Sets spacing - 3 pixels.
self.layfr2.setContentsMargins(3, 3, 3, 3)
self.frame2.setLayout(self.layfr2) # Layout added to frame.
self.lay1 = QtWidgets.QGridLayout() # Layout for third widget.
self.lay1.addWidget(self.frame1, 0, 0, 1, 1)
self.lay1.addWidget(self.frame2, 0, 1, 1, 1)
self.twid3.setLayout(self.lay1) # Set layout to the widget.
self.mb1.triggered.connect(self.files)
self.mb3.triggered.connect(self.data) # Connects to the data func.
self.mb4.triggered.connect(self.options)
self.combox1.activated.connect(self.txt_table)
self.push_but1.clicked.connect(self.save_data)
self.push_but2.clicked.connect(lambda: self.text_edit.setText("HELLO"),
QtCore.Qt.QueuedConnection)
self.print_device = QtPrintSupport.QPrinter()
self.actx = "" # Empty string for actions.
# self.video_camera() # Run video camera function.
def txt_table(self): # The function that will
if self.combox1.currentText() == "Texts":
self.text_edit.setVisible(True) # visualize the table and text
self.table.setVisible(False) # depends on choice of combo.
if self.combox1.currentText() == "Table":
self.text_edit.setVisible(False) # When the text activated,
self.table.setVisible(True) # elements visible or not.
def video_camera(self): # Function to run videocamera.
subprocess.Popen(["python", r"u_media.py"])
def files(self, action): # Function open/save files.
fd = QtWidgets.QFileDialog() # File dialog instance.
if action.text() == "Open": # For opening of the files.
fdf = fd.getOpenFileNames(self,
caption="Open Files",
directory=QtCore.QDir.homePath())
if len(fdf[0]) > 0: # Checks if the file dialog
self.text_edit.clear() # has a selected files for
for of in fdf[0]: # open. Each file of the
self.tabwid.setCurrentIndex(2) # selected will be open.
try: # Will try to open file as
openf = open(of, 'r') # simple .txt or .html and,
self.text_edit.append(str(openf.read()))
continue # read content to text field.
except Exception: # If successfull continue.
pass # If unread or error - pass.
try: # Try to open file in the
openf = open(of, 'rb') # binary mode .py or other.
self.text_edit.append(str(openf.read()))
except Exception: # Content to the field, if
pass # error - pass (do nothing).
if action.text() == "Save": # For saving of the files.
fdf = fd.getSaveFileName(self,
caption="Save Files",
directory=QtCore.QDir.homePath())
if fdf[0] != "": # Checks if files selected.
self.tabwid.setCurrentIndex(2) # Open TabWid with Text Field.
try: # Will try to save file as
open(fdf[0], 'w').write(self.text_edit.toPlainText())
success = True # .txt file with plain text of
except Exception: # text field. And success is
pass # True. An error - pass.
if success != True: # If file not saved as .txt
try: # will try to save file in the
open(fdf[0], 'wb').write(self.text_edit.toPlainText())
success = True # binary mode, as plain text.
except Exception: # An exception - will pass.
pass # If success is True will
if success == True: # shown information message.
self.info_message(fpath=fdf[0],
txt="File saved as",
types="info")
else: # If not True, critical.
self.info_message(fpath=fdf[0],
txt="File don`t saved",
types="critical")
if action.text() == "Print":
print_dialog = QtPrintSupport.QPrintDialog(self.print_device)
if print_dialog.exec_() == QtWidgets.QDialog.Accepted:
self.text_edit.print_(print_dialog.printer())
if action.text() == "Print Preview": # Print preview dialog.
print_dialog = QtPrintSupport.QPrintPreviewDialog(
self.print_device)
print_dialog.setWindowTitle("Print Preview")
print_dialog.setWindowIcon(QtGui.QIcon("Icons/python1.png"))
print_dialog.paintRequested.connect(self.text_edit.print_)
print_dialog.exec_() # Executes dialog window.
def options(self, action): # Function to run tools by
if action.text() == "Settings": # selectection options items.
from u_settings import USets # Importing class for color
self.sets = USets() # settings, class instance.
self.sets.show() # Shows widget for settings.
self.sets.bsave.clicked.connect(self.sets_but)
self.sets.breset.clicked.connect(self.to_default)
def sets_but(self): # Function for "Save" clicks.
colors = "%s %s %s %s" % (self.sets.bgle1.text(), self.sets.bgle2.text(
), self.sets.colle1.text(), self.sets.colle2.text())
save_open = open("settings.txt", "w") # Opens settings.txt file and
save_open.write(colors) # writes the colors from line
save_open.close() # edit field, then closes.
self.new_app() # Call the function for new.
def to_default(self): # Function to restore the
u_defaults.txt_file(state=True) # default colors and calling
self.new_app() # new app in the subprocess.
def new_app(self): # Function to re-open new app.
self.sets.hide() # Hides the widget (optional).
subprocess.Popen(["python", r"u_app.py"])
sys.exit(0) # Run new and exit old app.
def info_message(self, fpath='', txt='', types="info"):
message_box = QtWidgets.QMessageBox(self)
message_box.setStyleSheet("color: #FFFFFF;")
message_box.setFont(QtGui.QFont("Verdana", 12, 77))
message_box.setWindowTitle("Save files")
if types == "info": # Function with message box.
message_box.setIcon(QtWidgets.QMessageBox.Information)
if types == "critical": # Critical message box.
message_box.setIcon(QtWidgets.QMessageBox.Critical)
message_box.addButton(QtWidgets.QMessageBox.Ok)
message_txt = "%s\n%s" % (txt, fpath) # Adding the button. Text that
message_box.setText(message_txt) # will be shown with box.
message_box.exec_() # Shows this message box.
def data(self, action): # Function for the "Data"
self.text_edit.clear() # panel, if an option will
self.actx = action.text() # select, related data will be
if self.actx == "Pickle": # operated with functionality.
try: # Calls the functions that
txtdata = self.pickle_load(filename=r"data/u_data.py")
self.text_edit.append(str(txtdata))
self.stat_bar.showMessage(self.actx + " opened")
except Exception as err: # open/read data from the
self.stat_bar.showMessage(self.actx + ' ' + str(err))
if self.actx == "Shelve": # file/DB and append to
try: # the text edit field.
db = self.shelve_open(filename="data/u_data")
self.text_edit.append(
"%s\n%s\n%s\n%s" %
(db.get("User Name"), db.get("User email"),
db.get("User password"), db.get("User data")))
self.stat_bar.showMessage(self.actx + " opened")
except Exception as err: # "Pickle" option loads file
self.stat_bar.showMessage(self.actx + ' ' + str(err))
if self.actx == "CSV": # as text. The "Shelve" loads
try: # data as dictionary values.
for row in self.csv_read(csvfile="data/tests.csv"):
self.text_edit.append(
"%s %s %s %s" %
(row["User_Name"], row["User_email"],
row["User_password"], row["User_data"]))
self.stat_bar.showMessage(self.actx + " opened")
except Exception as err: # "CSV" reads the table
self.stat_bar.showMessage(self.actx + ' ' + str(err))
if self.actx == "Pandas": # with the python standard
try: # library csv module. "Pandas"
pread = self.pandas_read(filename="data/bigtests.csv",
reader="csv",
sep=',')
def to_field(df, er): # reads CSV using thread and
if er == '': # nested function, "SQLite"
self.text_edit.append("\n" + str(df))
else: # open and select the values
self.stat_bar.showMessage(self.actx + ' ' + er)
pread.sig1.connect(to_field, QtCore.Qt.QueuedConnection)
self.stat_bar.showMessage(self.actx + " opened")
except Exception as err: # from database. "PostgreSQL"
self.stat_bar.showMessage(self.actx + ' ' + str(err))
if self.actx == "SQLite": # "SQLite" opens and selects
try: # the values from database.
dbdata = self.sqlite_select() # "PostgreSQL" opens and
for dtx in dbdata: # selects data from database.
self.text_edit.append(
"%s\n%s\n%s\n%s\n%s" %
(dtx[0], dtx[1], dtx[2], dtx[3], dtx[4]))
self.stat_bar.showMessage(self.actx + " opened")
except Exception as err: # "MySQL" opens and selects
self.stat_bar.showMessage(self.actx + ' ' + str(err))
if self.actx == "PostgreSQL": # all values from the MySQL
try: # database, "QtSQL" module of
dbdata = self.psql_select() # the Python binding used
for dtx in dbdata: # provides the database
self.text_edit.append(
"%s\n%s\n%s\n%s\n%s" %
(dtx[0], dtx[1], dtx[2], dtx[3], dtx[4]))
self.stat_bar.showMessage(self.actx + " opened")
except Exception as err: # operations of the Qt
self.stat_bar.showMessage(self.actx + ' ' + str(err))
if self.actx == "MySQL": # library, "MongoDB" selects
try: # all values from the NoSQL
dbdata = self.mysql_select() # document oriented database
for dtx in dbdata: # MongoDB, and "CouchDB" opens
self.text_edit.append(
"%s\n%s\n%s\n%s\n%s" %
(dtx[0], dtx[1], dtx[2], dtx[3], dtx[4]))
self.stat_bar.showMessage(self.actx + " opened")
except Exception as err: # data from the NoSQL CouchDB
self.stat_bar.showMessage(self.actx + ' ' + str(err))
if self.actx == "QtSQL": # database. The text that
try: # retreived from the files and
dbdata = self.sql_qt_select() # DB`s appends each value of
while dbdata.next(): # the database to the text
self.text_edit.append(
"%s\n%s\n%s\n%s\n%s" %
(dbdata.value(0), dbdata.value(1), dbdata.value(2),
dbdata.value(3), dbdata.value(4)))
self.stat_bar.showMessage(self.actx + " opened")
except Exception as err: # edit field of this app. This
self.stat_bar.showMessage(self.actx + ' ' + str(err))
if self.actx == "MongoDB": # can be changed to the
try: # setText() method that will
dbdata = self.mongo_select() # put just last value from the
for dtx in dbdata: # query. All tools realized in
self.text_edit.append("%s\n%s\n%s\n%s" %
(dtx["User Name"], dtx["Email"],
dtx["Password"], dtx["Data"]))
self.stat_bar.showMessage(self.actx + " opened")
except Exception as err: # these statements and handle
self.stat_bar.showMessage(self.actx + ' ' + str(err))
if self.actx == "CouchDB": # all Exception errors that
try: # can occur with implementing.
dbdata = self.couch_select() # Is recommended to change
for dtx in dbdata.view("_all_docs", include_docs=True):
self.text_edit.append(
"%s\n%s\n%s\n%s" %
(dtx["doc"]["User Name"], dtx["doc"]["User email"],
dtx["doc"]["User password"], dtx["doc"]["User Data"]))
self.stat_bar.showMessage(self.actx + " opened")
except Exception as err: # pass to print the errors.
self.stat_bar.showMessage(self.actx + ' ' + str(err))
def save_data(self): # Function will save the data
self.error = '' # in relation to used tools.
uname = self.line_ed1.text() # User name field value.
umail = self.line_ed2.text() # User email field value.
upass = self.line_ed3.text() # User password field value.
udata = self.text_edit.toPlainText() # Text edit field value.
if (uname != '') and (umail != '') and (upass != ''):
if self.actx == "Pickle": # Pickle option and function.
self.user_data1(uname, umail, upass, udata)
elif self.actx == "Shelve": # Shelve option and function.
self.user_data2(uname, umail, upass, udata)
elif self.actx == "CSV": # CSV option and function.
self.user_data3(uname, umail, upass, udata)
elif self.actx == "Pandas": # Pandas option and function.
self.user_data4(uname, umail, upass, udata)
elif self.actx == "SQLite": # SQLite option and function.
self.user_data5(uname, umail, upass, udata)
elif self.actx == "PostgreSQL": # PostgreSQL option and func.
self.user_data6(uname, umail, upass, udata)
elif self.actx == "MySQL": # MySQL option and function.
self.user_data7(uname, umail, upass, udata)
elif self.actx == "QtSQL": # QtSql option and function.
self.user_data8(uname, umail, upass, udata)
elif self.actx == "MongoDB": # MongoDB option and function.
self.user_data9(uname, umail, upass, udata)
elif self.actx == "CouchDB": # Couch option and function.
self.user_data10(uname, umail, upass, udata)
else: # By default Pickle function.
self.user_data1(uname, umail, upass, udata)
if self.error != '': # If some errors occur, shows
self.stat_bar.showMessage(self.actx + ' ' + str(self.error))
else: # error, else shows message.
self.stat_bar.showMessage(self.actx + " saved")
def user_data1(self, uname, umail, upass, udata):
try: # Function for pickle module.
dictd = {
"User Name": uname,
"User email": umail,
"User password": upass,
"User data": udata
}
self.pickle_dump(obj=dictd, filename=r"data/u_data.py")
except Exception as err: # Data as dictionary to file.
self.error = err # If some error - will pass.
def user_data2(self, uname, umail, upass, udata):
try: # Function for shelve module.
db = self.shelve_open(filename="data/u_data")
db["User Name"] = uname # Writes user name to DB.
db["User email"] = umail # Writes user email to DB.
db["User password"] = upass # Writes user password to DB.
db["User data"] = udata # Writes user data to DB.
db.close() # Opens database, saves data
except Exception as err: # of the text fields to file
self.error = err # and closes database.
def user_data3(self, uname, umail, upass, udata):
fnames = ["User_Name", "User_email", "User_password", "User_data"]
rdata = [uname, umail, upass, udata[:140]]
try: # Function to write CSV.
for row in self.csv_read(csvfile="data/tests.csv"):
if (row["User_Name"] == rdata[0]) and (row["User_password"]
== rdata[2]):
rdata = None # Checks CSV file, if True
except Exception: # data will not be added to
pass # csv file, if erorr - pass.
if rdata is not None: # If is not None, data will be
try: # added to the CSV file.
self.csv_write(csvfile="data/tests.csv",
fieldnames=fnames,
rowdata=rdata,
delimiter=' ',
lineterminator='\n')
except Exception as err: # If some error will occur,
self.error = err # the variable will be error.
def user_data4(self, uname, umail, upass, udata): # CSV files with pandas.
try: # Writing CSV with pandas.
ucolumns = [
"User_Name", "User_email", "User_password", "User_data"
]
self.pandas_write(filename="data/bigtests.csv",
writer="csv",
columns=ucolumns)
except Exception as err: # Put numbers to cells, the
self.error = err # number of rows is 999.
def user_data5(self, uname, umail, upass, udata):
try: # SQLite database function.
self.sqlite_insert(username=uname,
email=umail,
passw=upass,
data=udata)
except Exception as err: # Inserts values of the text
self.error = err # edit field to the SQLite DB.
def user_data6(self, uname, umail, upass, udata):
try: # PostgreSQL DB function.
self.psql_insert(username=uname,
email=umail,
passw=upass,
data=udata)
except Exception as err: # Inserts values of the text
self.error = err # edit field to PostgreSQL.
def user_data7(self, uname, umail, upass, udata):
try: # MySQL database function.
self.mysql_insert(username=uname,
email=umail,
passw=upass,
data=udata)
except Exception as err: # Inserts values of the text
self.error = err # edit field to the MySQL DB.
def user_data8(self, uname, umail, upass, udata):
try: # Using QtSql module function.
self.sql_qt_insert(username=uname,
email=umail,
passw=upass,
data=udata)
except Exception as err: # Inserts values of the text
self.error = err # edit field to the SQLite DB.
def user_data9(self, uname, umail, upass, udata):
try: # NoSQL MongoDB function.
self.mongo_insert(username=uname,
email=umail,
passw=upass,
data=udata)
except Exception as err: # Inserts values of the text
self.error = err # edit field to the Mongo DB.
def user_data10(self, uname, umail, upass, udata):
try: # To document of the CouchDB.
self.couch_insert(username=uname,
email=umail,
passw=upass,
data=udata)
except Exception as err: # Inserts values of the text
self.error = err # edit field to the Couch DB.