sqledit(1) [debian man page]
PYTHON-SQLEDIT(1) General Commands Manual PYTHON-SQLEDIT(1) NAME
sqledit - GUI to edit databases SYNOPSIS
sqledit [options][nick][URI][-ttable][-m][-uURL][-d][-D] [-ffield_list][-l] DESCRIPTION
sqledit is a GUI to edit database *data* (as opposed to database schemas). As sqledit is a GUI it's bettere explained in the html page, please visit http://sqlkit.argolinux.org/sqlkit/sqledit.html. When opened with no options you are presented an entry to fill the database URI or a button to start a demo (if found on your system) OPTIONS
These programs follow the usual GNU command line syntax, with long options starting with two dashes (`-'). A summary of options is included below. For a complete description, see the Info files. -h, --help Show summary of options. -v, --version Show version of program. -l, --load Directly load data in tables when opened. -f, --field_list only show the listed fields (comma separated list). -n, --nick read options from nick definition (read NICKs below) -u, --nick open the URL. Acceptable formats are any format acceptable by sqlalchemy: engine://user:pass@host/dbname Acceptable engines depend on which drivers you have in your systems. Have a look at http://www.sqlalchemy.org/trac/wiki/DatabaseNotes -o, --order_by define the order by column -m, --mask Open the sqltable with a mask (form) view. -T, --sqltable Open the sqltable with a table view (default) NICKs Sqledit allows you to write nicks in file .sqleditdb. A nick looks like the following: [film] URL = sqlite:////home/sandro/src/django/siti/cinemino/cinemino.db [banca] URL = postgres://sandro:vicie@localhost:5432/banca table = conti_banche field_list = data tipo descrizione eu_in eu_out banca edit classe data_val order_by = data If you define a nick you can call sqledit simply as: sqledit film sqledit film -t director At present you need to edit the nick by hand The programs are documented fully in the web site http://sqlkit.argolinux.org/sqlkit/sqledit.html SQLKIT
Sqledit is just an application that shows the power of the python package sqlkit. Programming directly with python you can build much more interesting interfaces. The demo tour show what can be done in very few lines of code. EXAMPLES
sqledit sqledit postgres://localhost/sia sqledit postgres://localhost/sia -m (opens a mask view) TUTORIAL
You can read a tutorial on the main features of sqledit at http://sqlkit.argolinux.org/sqlkit/tutorial.html AUTHOR
python-sqledit was written by Alssandro Dentella This manual page was written by Alessandro Dentella <sandro@e-den.it> October 28, 2008 PYTHON-SQLEDIT(1)
Check Out this Related Man Page
chatwidget(n) Composite widget for chat applications chatwidget(n) __________________________________________________________________________________________________________________________________________________ NAME
chatwidget - Provides a multi-paned view suitable for display of chat room or irc channel information SYNOPSIS
package require Tk 8.5 package require chatwidget ?1.0.0? ::chatwidget::chatwidget path ?options? $widget topic command args $widget name nick args $widget message text args $widget hook command args $widget names args $widget entry args $widget chat args _________________________________________________________________ DESCRIPTION
This is a composite widget designed to simplify the construction of chat applications. The widget contains display areas for chat messages, user names and topic and an entry area. It automatically handles colourization of messages per nick and manages nick completion. A system of hooks permit the application author to adjust display features. The main chat display area may be split for use displaying history or for searching. The widget is made up of a number of text widget and panedwindow widgets so that the size of each part of the display may be adjusted by the user. All the text widgets may be accessed via widget passthrough commands if fine adjustment is required. The topic and names sections can also be hidden if desired. COMMANDS
::chatwidget::chatwidget path ?options? Create a new chatwidget using the Tk window id path. Any options provided are currently passed directly to the main chat text wid- get. WIDGET COMMANDS
$widget topic command args The chat widget can display a topic string, for instance the topic or name given to a multi-user chatroom or irc channel. show Enable display of the topic. hide Disable display of the topic set topic Set the topic text to topic. $widget name nick args Control the names and tags associated with names. list ?-full? Returns a list of all the user names from the names view. If ?-full? is given then the list returned is a list of lists where each sublist is made up of the nick followed by any options that have been set on this nick entry. This may be used to exam- ine any application specific options that may be applied to a nick when using the add command. add nick ?options? delete nick $widget message text args Add messages to the display. options are -nick, -time, -type, -mark -tags $widget hook command args Manage hooks. add (message, post names_group, names_nick, chatstate), remove, run $widget names args Passthrough to the name display text widget. See the text widget manual for all available commands. The chatwidget provides two additional commands show and hide which are used to control the display of this element in the widget. $widget entry args Passthrough to the entry text widget. See the text widget manual for all available commands. $widget chat args Passthrough to the chat text widget. See the text widget manual for all available commands. EXAMPLE
chatwidget::chatwidget .chat proc speak {w msg} {$w message $msg -nick user} pack .chat -side top -fill both -expand 1 A more extensive example is available by examining the code for the picoirc program in the tclapps repository which ties the tcllib picoirc package to this chatwidget package to create a simple irc client. SEE ALSO
text(n) KEYWORDS
chat, chatwidget, composite widget, irc, mega-widget, widget chatwidget 1.0.0 chatwidget(n)