xenial (1) sqledit.1.gz

Provided by: python-sqlkit_0.9.6.1-2_all bug

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)