Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I did this with a custom QPlainTextEdit and custom QLineEdit. I also had an indicator label that would display ">>>" on the terminal to show user input. It needs more work. The best way would be to create your own custom widget based off of a QTextEdit and your own io handler. Below is an example of my execute method with self.input being the QLineEdit and self.view being the QTextEdit. It should get you the general idea.</p> <pre><code>import io, subprocess, shlex, code, rlcompleter, platform def execute(self, currentText=None): """Execute runs the command given based on the console type. If the console type is "both" then execute will run python commands unless the user give the input ::os::command or ("::(platform.syste())::command"). Otherwise the console type will determine the what the input will execute with. Args: currentText(str): Text to execute. None will run the text from the QLineEdit self.input. """ # Check for given text if currentText is None: currentText = self.input.text() self.input.clear() self.view.display(currentText, "input") else: cmd = re.search("^&gt;&gt;&gt;", currentText) # search for start only if cmd is None: currentText = "&gt;&gt;&gt;" + currentText else: self.view.display(currentText, "input") # end # Variables self.completer.clear() cmdString = re.sub("^&gt;&gt;&gt;", "", currentText) result = None displayType = "output" run, cmdString = self.getRunType(cmdString) try: # Check where the output is going sys.stdout = self.out = io.StringIO() sys.stderr = sys.stdout if run == "python": # Run python command result = self._runInterpreter(cmdString) displayType = "python" elif run == "os": # Run os command result = self._runSubprocess(cmdString) displayType = "os" except Exception as err: result = str(err) displayType = "Error" notFoundPython = "NameError:" in result and "is not defined" in result notFoundWindows = "returned non-zero exit status" in result if notFoundPython or notFoundWindows: result = "Command not found" finally: sys.stdout = self.old_stdout sys.stderr = self.old_stdout self.display(result, displayType) # end execute def getRunType(self, cmdString): run = self._consoleType # Check the run type if self._consoleType == "both": if re.search("^::python::", cmdString) is not None: cmdString = re.sub("^::[a-z]*::", "", cmdString) run = "python" elif re.search("^(::os::|::"+platform.system()+"::)", cmdString) is not None: cmdString = re.sub("^::[a-z]*::", "", cmdString) run = "os" else: run = "python" # end return run, cmdString # end getRunType def _runInterpreter(self, cmdString, outIO=None, run=None): # Check for a proper console type if(self._consoleType != "both" and self._consoleType != "python"): return # Get the IO if outIO is None: outIO = sys.stdout # Run python command self.interpreter.push(cmdString) # Check outIO result = "Unreadable buffer: Check python's sys.stdout" if isinstance(outIO, io.StringIO): result = outIO.getvalue() else: if outIO.readable(): result = str(outIO.readlines()) # Check for error if re.search("^Traceback", result) or re.search("[a-zA-z]*Error:", result): raise ValueError(result) return result # end _runInterpreter def _runSubprocess(self, cmdString, run=None): # Check for a proper console type if(self._consoleType != "both" and self._consoleType != "os"): return # Run OS command cmd = shlex.split(cmdString) result = subprocess.check_output(cmd, shell=True, stderr=subprocess.STDOUT).decode("utf-8") # Check for error if re.search("^Traceback", result) or re.search("[a-zA-z]*Error:", result): raise ValueError(result) return result # end _runSubprocess </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POTerminal like app in PySide
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USjustengel
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload