Create GUI dialogs in one line of code

SQL Data in List Dialogs

SQL command-line utilities can output SQL queries to a Zenity list dialog. Like the earlier CSV examples, the SQL output needs to reformatted to a sequential list. The SQL output from the command-line tools will vary by database; for example, MySQL uses tabs between the fields, whereas SQLite uses a vertical bar (|).

For my testing, I used an SQLite3 database (someuser.db) with a table (users) of fields containing first and last names, age, and job. To output a SELECT query, I entered:

$ sqlite3 someuser.db "select fname,lname,age,job from users"
Brooke|Metcalfe|18|Student
Leah|Metcalfe|18|Co-op
Pete|Metcalfe|100|Old dude
...
Willy|Coyote|99|Evil genius

The SQLite query output can be modified with the tr command and shown in a Zenity list dialog (Figure 8):

$ sqlite3 someuser.db "select fname,lname,age,job from users" | tr '|' '\n' | zenity --list --title="My Database" --column="first name" --column="last name" --column=age --column=job
Figure 8: List dialog showing SQL query.

The Zenity list dialog supports a number of useful options, such as radio buttons and checkboxes. The lists are editable, and the selected fields or rows can be used in further scripting.

Insert SQL Data in a Zenity Form

Zenity forms allows for the creation of basic data entry dialogs. In about eight lines of Bash code (Listing 3), I created a Zenity form (Figure 9) I can use to insert data into my SQLite users table.

Listing 3

SQL Input Form

01 #!/bin/bash
02 row=$(zenity --forms --title="Create user" --text="Add new user" --add-entry="First Name" --add-entry="Last Name" --add-entry="Age" --add-entry="Job" --separator="','")
03 if [[ -n $row ]] # Some data found
04 then
05   cmd="sqlite3 someuser.db  \"INSERT INTO users (Fname,Lname,Age,Job) VALUES ('$row')\""
06   eval $cmd
07   echo "Added data: '$row'"
08 fi
Figure 9: SQL input form.

The OK button will pass the user-entered data as a string, whereas the Cancel button will not pass any data. An if statement checks to see whether any data has been entered.

The SQL INSERT statement needs VALUES to be in the format

("value1","value2,"value3,"value4")

The formatting can be done by setting the Zenity --separator option to a comma, defined with single quotes within double quotes (line 2).

This example is quite basic, so the next step would be to add data validation.

Final Comments

For simple dialogs, Zenity works amazingly well. I found that as the requirements started to get more complicated, a Python solution appeared to be cleaner and simpler. I was able to control a Raspberry Pi rover in about 20 lines of Bash and Zenity code, but it only took 15 lines of Python and Tkinter code.

There is a Python library (Zenity 2.0) that emulates Zenity, so if you're feeling comfortable with the Zenity dialogs and you don't need complex dialogs, this might be something to consider.

If you are looking for a more complete command-line GUI tool, try YAD [3].

The Author

You can investigate more neat projects by Pete Metcalfe and his daughters at https://funprojects.blog.

Buy this article as PDF

Express-Checkout as PDF
Price $2.95
(incl. VAT)

Buy Linux Magazine

SINGLE ISSUES
 
SUBSCRIPTIONS
 
TABLET & SMARTPHONE APPS
Get it on Google Play

US / Canada

Get it on Google Play

UK / Australia

Related content

  • Zenity and KDialog

    Zenity and KDialog let you integrate your scripts with the native KDE or Gnome environment.

  • Xonsh

    Create lightweight Raspberry Pi scripts with Xonsh, a Python shell that lets you write scripts in Python with Bash commands mixed in.

  • Script Dialogs

    Starting a script on a Linux server with just a few mouse clicks sounds more complicated than it really is. If you want to create attractive and interactive dialogs for your desktop users, all you need is a small utility called SSH and a little Bash know-how.

  • Elixer

    The Elixir programming language on a Raspberry Pi lets you create distributed projects in just a few lines of code.

  • Tutorials – Shell Scripts

    Letting your scripts ask complex questions and give user feedback makes them more effective.

comments powered by Disqus
Subscribe to our Linux Newsletters
Find Linux and Open Source Jobs
Subscribe to our ADMIN Newsletters

Support Our Work

Linux Magazine content is made possible with support from readers like you. Please consider contributing when you’ve found an article to be beneficial.

Learn More

News