Skip to content

Commit 4718817

Browse files
bmomjianbmomjian
committed
Add new files.
1 parent 20a97d8 commit 4718817

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

55 files changed

+10214
-0
lines changed

‎src/bin/pgaccess/README

Lines changed: 82 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,82 @@
1+
---------------------------------------------------------------------------
2+
3+
Copyright (c) 1994-7 Regents of the University of California
4+
5+
Permission to use, copy, modify, and distribute this software and its
6+
documentation for any purpose, without fee, and without a written agreement
7+
is hereby granted, provided that the above copyright notice and this
8+
paragraph and the following two paragraphs appear in all copies.
9+
10+
IN NO EVENT SHALL THE UNIVERSITY OF CALIFORNIA BE LIABLE TO ANY PARTY FOR
11+
DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING
12+
LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS
13+
DOCUMENTATION, EVEN IF THE UNIVERSITY OF CALIFORNIA HAS BEEN ADVISED OF THE
14+
POSSIBILITY OF SUCH DAMAGE.
15+
16+
THE UNIVERSITY OF CALIFORNIA SPECIFICALLY DISCLAIMS ANY WARRANTIES,
17+
INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY
18+
AND FITNESS FOR A PARTICULAR PURPOSE. THE SOFTWARE PROVIDED HEREUNDER IS
19+
ON AN "AS IS" BASIS, AND THE UNIVERSITY OF CALIFORNIA HAS NO OBLIGATIONS TO
20+
PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.
21+
22+
---------------------------------------------------------------------------
23+
24+
25+
PGACCESS 0.98 29 August 1999
26+
================================
27+
I dedicate this program to my little daughters Ana-Maria and Emilia and to my
28+
wife for their understanding. I hope they will forgive me for spending so many
29+
time far from them.
30+
31+
32+
33+
1. How to INSTALL ?
34+
35+
You will need a Tcl/Tk package, at least Tcl 7.6 and Tk 4.2, recommended
36+
Tcl/Tk 8.x
37+
38+
For Unix users, unpack the pgaccess-xxx.tar.gz archieve in you preferred
39+
directory (usually /usr/local).
40+
41+
Check where your "wish" program is and modify (if needed) the file
42+
/usr/local/pgaccess/pgaccess and set variables PGACCESS_HOME and
43+
PATH_TO_WISH to the appropriate directories.
44+
45+
Include the /usr/local/pgaccess directory into your PATH or make a
46+
symbolic link to it wherever you want (in PATH directories).
47+
Example:
48+
49+
$ ln -s /usr/local/pgaccess/pgaccess /usr/bin/pgaccess
50+
51+
You will find also some documentation and FAQ in the doc directory.
52+
53+
54+
55+
2. Usage
56+
57+
You run it with the command:
58+
59+
pgaccess [database]
60+
61+
[database] is optional.
62+
63+
64+
65+
3. Bug reporting
66+
67+
First of all : operating system, PostgreSQL version,Tcl/Tk version.
68+
A more detailed story of what have you done when error occurred.
69+
Tcl/Tk stops usually with a error message and there is a button there
70+
"Stack Trace" and if you press it, you will see a detailed information
71+
about the procedure containing the error. Please send it to me.
72+
Some information about table structure, no. of fields, records would
73+
be also good.
74+
75+
===========================================================================
76+
You would find always the latest version at http://www.flex.ro/pgaccess
77+
78+
Please feel free to e-mail me with any suggestion or bug description
79+
that will help to improve it.
80+
81+
Constantin Teodorescu <teo@flex.ro>
82+

‎src/bin/pgaccess/copyright.html

Lines changed: 39 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,39 @@
1+
<HTML>
2+
<HEAD>
3+
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
4+
<META NAME="GENERATOR" CONTENT="Mozilla/4.03 [en] (X11; I; Linux 2.0.30 i586) [Netscape]">
5+
<TITLE>PgAccess - Copyright notice</TITLE>
6+
</HEAD>
7+
<BODY BGCOLOR="#FFFFFF">
8+
<TT>---------------------------------------------------------------------------</TT>
9+
<BR><TT></TT>&nbsp;
10+
<BR><TT></TT>&nbsp;<TT></TT>
11+
12+
<P><TT>Copyright (c) 1994-7 Regents of the University of California</TT><TT></TT>
13+
14+
<P><TT>Permission to use, copy, modify, and distribute this software and
15+
its</TT>
16+
<BR><TT>documentation for any purpose, without fee, and without a written
17+
agreement</TT>
18+
<BR><TT>is hereby granted, provided that the above copyright notice and
19+
this</TT>
20+
<BR><TT>paragraph and the following two paragraphs appear in all copies.</TT><TT></TT>
21+
22+
<P><TT>IN NO EVENT SHALL THE UNIVERSITY OF CALIFORNIA BE LIABLE TO ANY
23+
PARTY FOR</TT>
24+
<BR><TT>DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES,
25+
INCLUDING</TT>
26+
<BR><TT>LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS</TT>
27+
<BR><TT>DOCUMENTATION, EVEN IF THE UNIVERSITY OF CALIFORNIA HAS BEEN ADVISED
28+
OF THE</TT>
29+
<BR><TT>POSSIBILITY OF SUCH DAMAGE.</TT><TT></TT>
30+
31+
<P><TT>THE UNIVERSITY OF CALIFORNIA SPECIFICALLY DISCLAIMS ANY WARRANTIES,</TT>
32+
<BR><TT>INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY</TT>
33+
<BR><TT>AND FITNESS FOR A PARTICULAR PURPOSE. THE SOFTWARE PROVIDED HEREUNDER
34+
IS</TT>
35+
<BR><TT>ON AN "AS IS" BASIS, AND THE UNIVERSITY OF CALIFORNIA HAS NO OBLIGATIONS
36+
TO</TT>
37+
<BR><TT>PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.</TT>
38+
</BODY>
39+
</HTML>

‎src/bin/pgaccess/doc/html/a_right.gif

207 Bytes
Loading

‎src/bin/pgaccess/doc/html/addindex.gif

11.1 KB
Loading

‎src/bin/pgaccess/doc/html/api.html

Lines changed: 232 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,232 @@
1+
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
2+
<html>
3+
<head>
4+
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
5+
<meta name="GENERATOR" content="Mozilla/4.61 [en] (X11; I; Linux 2.2.11 i586) [Netscape]">
6+
</head>
7+
<body bgcolor="#FEFEDF">
8+
9+
<h2>
10+
PgAccess developer API</h2>
11+
12+
<hr>
13+
<br>Starting with PgAccess 0.98 I am planning to make available a complete
14+
API for the PgAccess developers. I plan to make PgAccess not just an administrative
15+
tool, but also a tool for easy build of small applications.
16+
<p>That's why PgAccess 0.98 has been internally restructured, every main
17+
module of PgAccess has became a namespace (see Tcl namespaces) in order&nbsp;
18+
to hide the variables and internal procedures to the user. Also, all the
19+
global variables that have been used before were grouped under a single
20+
big associative array called <b>PgAcVar</b> (PgAccess variables) so they
21+
should not interfere with user defined global variables.
22+
<br>&nbsp;
23+
<br>&nbsp;
24+
<p><b><font size=+1>Global variables available</font></b>
25+
<br>&nbsp;
26+
<center><table BORDER=0 WIDTH="100%" NOSAVE >
27+
<tr NOSAVE>
28+
<td ALIGN=LEFT VALIGN=TOP NOSAVE><b>PgAcVar</b></td>
29+
30+
<td>The main global associative array that hold together various information
31+
needed by PgAccess. User should <b><font color="#FF0000">NOT</font></b>
32+
alter it under any circumstances.</td>
33+
</tr>
34+
35+
<tr NOSAVE>
36+
<td VALIGN=TOP NOSAVE><b>CurrentDB</b></td>
37+
38+
<td>The handler of the current opened database. Can be used for database
39+
operations as selects or command execution.</td>
40+
</tr>
41+
42+
<tr NOSAVE>
43+
<td ALIGN=LEFT VALIGN=TOP NOSAVE><b>Messages</b></td>
44+
45+
<td NOSAVE>The associative array that holds the translation for the current
46+
language. Loaded from the appropriate language file from lib/languages
47+
directory</td>
48+
</tr>
49+
50+
<tr NOSAVE>
51+
<td ALIGN=LEFT VALIGN=TOP NOSAVE><b>PGACCESS_HOME</b></td>
52+
53+
<td>Keep the system directory of PgAccess root installation</td>
54+
</tr>
55+
</table></center>
56+
57+
<br>&nbsp;
58+
<p><b><font size=+1>Window naming convention</font></b>
59+
<p>Every toplevel window defined by PgAccess has the following naming convention.
60+
Every window name starts with <tt>.pgaw</tt> (PgAccess window) followed
61+
by a colon and a name. <i>Example:</i>
62+
<blockquote><tt>.pgaw:User , .pgaw:About , .pgaw:ImportExport</tt></blockquote>
63+
<b><font size=+1>Namespaces available</font></b>
64+
<p>For every tab from the main database window there is a namespace defined
65+
(Tables, Queries, Views, Functions, Sequences, Reports, Forms, Scripts,
66+
Users, Schema). Every namespace has by default the following&nbsp; procedures:
67+
<ul>
68+
<li>
69+
<tt>new</tt>&nbsp; , no parameter needed</li>
70+
71+
<li>
72+
<tt>open</tt> , need a single parameter, the object name</li>
73+
74+
<li>
75+
<tt>design</tt> , need a single parameter, the object name</li>
76+
</ul>
77+
You can use these procedures if you want to produce the same efects as
78+
clicking on the desired tab and then on the "New", "Open" or "Design" buttons
79+
from the main database window.
80+
<br><i>Example:</i>
81+
<blockquote><tt>Tables::open "customers"</tt>
82+
<br><tt>Queries::open "Invoices received"</tt>
83+
<br><tt>Forms::open "Add new invoice"</tt></blockquote>
84+
The <tt>Tables::open</tt> procedure accepts two optional parameters, filter
85+
and order.
86+
<br><i>Example:</i>
87+
<blockquote><tt>Tables::open "phonebook" "name ~* 'joe'" "age desc"</tt></blockquote>
88+
will open a table view window with predefined filter "name ~* 'joe'" and
89+
ordered by descending age.
90+
<p>There is also a special namespace called Database.&nbsp; Here are some
91+
procedures and functions defined for this namespace available to the user:
92+
<br>&nbsp;
93+
<table BORDER NOSAVE >
94+
<tr BGCOLOR="#FFCCFF" NOSAVE>
95+
<td NOSAVE><b>Name</b></td>
96+
97+
<td NOSAVE><b>Parameters</b></td>
98+
99+
<td><b>Type</b></td>
100+
101+
<td><b>Returns</b></td>
102+
103+
<td NOSAVE><b>Description</b></td>
104+
</tr>
105+
106+
<tr>
107+
<td><b>vacuum</b></td>
108+
109+
<td>none</td>
110+
111+
<td>procedure</td>
112+
113+
<td>nothing</td>
114+
115+
<td>vacuums the current database</td>
116+
</tr>
117+
118+
<tr ALIGN=LEFT VALIGN=TOP NOSAVE>
119+
<td><b>getTablesList</b></td>
120+
121+
<td>none</td>
122+
123+
<td>function</td>
124+
125+
<td>list</td>
126+
127+
<td NOSAVE>returns the list of tables from the current database</td>
128+
</tr>
129+
130+
<tr ALIGN=LEFT VALIGN=TOP NOSAVE>
131+
<td><b>executeUpdate</b></td>
132+
133+
<td>sqlcmd</td>
134+
135+
<td>function</td>
136+
137+
<td>integer</td>
138+
139+
<td NOSAVE>execute the sqlcmd command on the current database returning
140+
1 if no errors ocurred or 0 if the command failed</td>
141+
</tr>
142+
</table>
143+
144+
<p><b><font size=+1>Global functions available</font></b>
145+
<br>&nbsp;
146+
<table BORDER NOSAVE >
147+
<tr BGCOLOR="#99FFCC" NOSAVE>
148+
<td><b>Name</b></td>
149+
150+
<td><b>Parameters</b></td>
151+
152+
<td NOSAVE><b>Description</b></td>
153+
</tr>
154+
155+
<tr ALIGN=LEFT VALIGN=TOP NOSAVE>
156+
<td><b>setCursor</b></td>
157+
158+
<td>type</td>
159+
160+
<td NOSAVE>Set the cursor for all PgAccess windows, type of cursor can
161+
be WAIT or CLOCK or WATCH for the hourglass , anything else (or none) to
162+
return to the normal cursor shape</td>
163+
</tr>
164+
165+
<tr ALIGN=LEFT VALIGN=TOP NOSAVE>
166+
<td><b>parameter</b></td>
167+
168+
<td>msg</td>
169+
170+
<td NOSAVE>Shows a modal input dialog with the msg message, wait for user
171+
to enter the data and returns it as a string</td>
172+
</tr>
173+
174+
<tr>
175+
<td><b>showError</b></td>
176+
177+
<td>msg</td>
178+
179+
<td>Shows a modal dialog window with an error message</td>
180+
</tr>
181+
182+
<tr>
183+
<td></td>
184+
185+
<td></td>
186+
187+
<td></td>
188+
</tr>
189+
190+
<tr>
191+
<td></td>
192+
193+
<td></td>
194+
195+
<td></td>
196+
</tr>
197+
198+
<tr>
199+
<td></td>
200+
201+
<td></td>
202+
203+
<td></td>
204+
</tr>
205+
206+
<tr>
207+
<td></td>
208+
209+
<td></td>
210+
211+
<td></td>
212+
</tr>
213+
214+
<tr>
215+
<td></td>
216+
217+
<td></td>
218+
219+
<td></td>
220+
</tr>
221+
222+
<tr>
223+
<td></td>
224+
225+
<td></td>
226+
227+
<td></td>
228+
</tr>
229+
</table>
230+
231+
</body>
232+
</html>

‎src/bin/pgaccess/doc/html/ball.gif

176 Bytes
Loading

‎src/bin/pgaccess/doc/html/contents.html

Lines changed: 29 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,29 @@
1+
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
2+
<html>
3+
<head>
4+
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
5+
<meta name="GENERATOR" content="Mozilla/4.61 [en] (X11; I; Linux 2.2.11 i586) [Netscape]">
6+
<base target="right">
7+
</head>
8+
<body bgcolor="#00FFFF">
9+
<img SRC="ball.gif" ><a href="main.html">What is PgAccess?</a>
10+
<br><img SRC="ball.gif" ><a href="whatsnew.html">What's new?</a>
11+
<br><img SRC="ball.gif" ><a href="features.html">Features</a>
12+
<br><img SRC="ball.gif" ><a href="screenshots.html">Screenshots</a>
13+
<br><img SRC="ball.gif" ><a href="faq.html">FAQ</a>
14+
<br><img SRC="ball.gif" ><a href="documentation.html">Documentation</a>
15+
<br><img SRC="ball.gif" ><a href="todo.html">To-Do list</a>
16+
<br><img SRC="ball.gif" ><a href="download.html">Download</a>
17+
<br>&nbsp;
18+
<p><br>
19+
<center>
20+
<p><a href="http://www.linux.org"><img SRC="linux1.gif" BORDER=0 ></a></center>
21+
22+
<p><b>Other links</b>
23+
<br><img SRC="ball.gif" ><a href="http://www.postgresql.org">PostgreSQL</a>
24+
<br><img SRC="ball.gif" ><a href="http://www.neuron.com/stewart/vtcl/index.html">Visual Tcl</a>
25+
<br><img SRC="ball.gif" ><a href="http://www.scriptics.com">Tcl/Tk</a>
26+
<br><img SRC="ball.gif" ><a href="http://www.linux.org">Linux</a>
27+
<br><img SRC="ball.gif" ><a href="http://www.java.ro/vtclava/index.html">vTcLava</a>
28+
</body>
29+
</html>

0 commit comments

Comments
 (0)