1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
|
2002-04-03 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell.pm (parse_loop): to catch ^D or other stdin EOF properly we
need to break out of the loop, not return.
2002-02-17 Vivek Dasmohapatra <vivek@etla.org>
* dbishell: bumped version number
* DBIShell/UTIL.pm: added defalt eol (DEOL) constant
* DBIShell.pm: correct EOL handling/history munging fuckups from before
* Makefile:
(perl-readline): cope when we don't get a tty, to comply w. debian
policy.
* DBIShell/Readline.pm:
(_trl_gnu_swap_eol): added new function, swaps EOL sequences around
(_trl_gnu_history_hook): use new func, implement EOL handling
outlined in TODO file.
(_trl_perl_advise): implement dynamic EOL handling properly
2001-12-05 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell/Readline.pm (DESTROY): '=' vs 'eq' typo fixed
2001-11-27 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell/Readline.pm:
(TRL_HISTORY_ADVICE_LIST): list of potential history-fetch functions
that need to be patched up for our dynamic
EOL support
(new): install EOL hooks as appropriate
(DESTROY): remove hooks, clean up circular refs
(advise_history_defuns): call the correct per-class hook installer
(_terminated): does a line already have an EOL sequence?
(_trl_gnu_history_hook): install hooks in Term::ReadLine::Gnu keymap
(_trl_gnu_history_unhook): remove hooks from TRL_GNU keymap
(_TRL_PERL_StuDlyCap): convert from gnu-style to F_GnuStyle names
(_trl_perl_advise): create a wrapper and install into TRL_PERL
(_trl_perl_mapcar): traverse the TRL_PERL keymap, adding hooks
(_trl_perl_history_hook): find the TRL_PERL map, and prepare a table
of the functions we want to wrap. Then
call _trl_perl_mapcar with this data.
(_trl_perl_history_unhook): stubroutine. does nothing yet.
* DBIShell.pm: dynamic EOL sequence for lines from history
(_setv_eol_hook): hook function for when $EOL is changed
(_obj_struct): add storage for per-variable setvar action hooks
(new): install setvar hook for $EOL
(exec_command): don't add EOL character before storing history line
(setvar): code to call hook if one is installed for variable
(parse_loop): local()ise and set the global $CUR_EOL variable
so that it contains the EOL character sequence.
the installed hook should take care of keeping it up
to date, and each separate call to parse_loop()
gets its own local copy, so as long as we are in
parse_loop(), the value is independent for each
instance of a DBIShell object.
2001-11-26 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell.pm: fixes to allow $var=$foo to work where $foo is NULL
(setvar): pass undef() as NULLREP arg to interpolate
(interpolate): make sure a value of NULL does not get accidentally
promoted to '' during interpolation if the chosen NULL
representation is undef()
* DBIShell/Readline.pm (auto_history): note TRL_PERL patch in comment
* DBIShell/Fixup.pm: fixes for doubled history under TRL_PERL
(_trl_perl_minline): replacement candidate for the buggy
Term::Readline::Perl MinLine method
(term_readline_perl): Apply extra patch to TRL_PERL
* Gtk/Icon.pm: comment out some debugging code.
* DBIShell/Readline.pm (new): new readline wrapper, logical home
of all the readline interaction code
* DBIShell/Fixup.pm: rip up and rewrite. When a caller wants a
package fixed up, they request this by
passing the name of the package to be fixed
through the new interface. If Fixup knows
how to patch the module in question, it does so.
(patch): new external interface function
(FIXLIST): mapping of packages to fixer functions.
(term_readline_perl): fixer function for Term::ReadLine::Perl
(getopt_long): fixer function for Getopt::Long
* installer.pl (interpolate_and_copy): unnecessary directive removed
* Makefile (BUNDLED_MODULES): add DBIShell::{Fixup,Readline}
* DBIShell.pm: rip-up and rewrite readline handling in preparation
for attempt to do some intricate history related
hacks. Moved big chunks into DBIShell::Readline
and DBIShell::Fixup, depending on where they belonged.
(new): replace raw Term::ReadLine object with our own wrapper
(to hide some of the quirks and jumping-through-hoops
needed to handle the difference between the two versions
of TRL we support.
(set_add_history_func): gutted and incorporated into...
(init_rl_package): ...this function
(set_signal_handlers): removed to wrapper module
(set_completion_function): removed to wrapper module
(exec_command): removed call to quit_cleanup.
(setvar): use readline wrapper method
(getvar): use readline wrapper method
(quit_cleanup): use readline wrapper method
break extra (closure) circular ref
to self in ADDHISTORY member.
(parse_loop): move call to quit_cleanup to outside loop - this way
we can simply break out of the loop and do a return
and cleanup just after it, rather than catching special
cleanup cases inside the loop, which is messy and prone
to break if we miss a quit-case.
(connect): move readline specific warning to wrapper module.
(may wish to revisit this).
(get_dot_history): use readline wrapper method(s)
(set_dot_history): use readline wrapper method(s)
(variables): use readline wrapper method(s)
2001-11-21 Vivek Dasmohapatra <vivek@etla.org>
* installer.pl: added Gtk directories + modules
added share directory (+subdirs for icons, etc)
NOTE: results in extra question during install
(interpolate_and_copy): added O_EXCL flag to sysopen,
fixed preceding unlink() call.
(sysprnt): new function, syswrite wrapper.
(copy_file): new function.
* DBIShell/Term_CTL.pm:
(get_response): squished termios settings into fewer lines,
import some POSIX symbols directly into
this function, use TCSADRAIN instead of
TCSANOW for the first termios->setattr call.
* Gtk/Symbols.pm: new symbols:
GTK__MAIN_QUIT
GTK__FALSE
GTK__TRUE
altered block-delimiting #:: markers with
#= markers, so as not to collide with the
substitution markes used by the make setup.
* ./: Gtk related additions:
Gtk/Icon.pm
DBIShell/Gtk/main.pm
DBIShell/Gtk/conn.pm
DBIShell/Gtk.pm
dbigtk
* icons/*.xpm: placeholder icons
* DBIShell.pm:
(WINDOWING): changed to test same filehandle as term control stuff
(wouldn't normally be a problem, but what the hell).
(parse_loop): added extra call to quit-cleanup to catch cases
where stdin was closed externally, rather than directly
by us.
* Makefile:
(BUNDLED_MODULES): added Gtk binding modules to list
(test): check syntax of dbigtk
(dependencies): changed sprintf format
2001-08-13 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell.pm: Block script lines from getting into the history -
bug introduced on 2001-08-11 but not yet checked in
[so that's all right then :)]
(exec_command): Damn. Appear to have inadvertently removed the EOL
character from the history entries - will fix up
on next commit - too many pending changes otherwise.
(exec_command): add EOL character back in at history write time.
Wanted to do this at history fetch time, but that
started to look hairy. Will revisit later.
* DBIShell/Fixup.pm: new file, to contain on-the-fly fixes
to packages external to but used by DBIShell
(trl_perl_tie): Add missing handlers to Term::ReadLine::Perl::Tie
* DBIShell/UTIL.pm: changes to default exports,
removed duplicate export
* DBIShell/Term_CTL.pm: typo in documentation
* DBIShell.pm:
(setvar): Added support for GRL attributes
(getvar): ditto
(getvar_ref): ditto
(variables): ditto
2001-08-11 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell.pm:
(exec_script): trim newlines to avoid double-newline effect
that got reintroduced by the introduction of
exec_command
(exec_script): remove code that echoed the query and or error
back to the screen - this is now done in exec_command
(parse_loop): ditto
(exec_command): added code to handle echoing of query + success/error
back to user, since this is where it belongs now
2001-08-11 Vivek Dasmohapatra <vivek@etle>
(set_add_history_func):
new function, used to set up multi-line
query -> one history entry mapping + uniq'ing
of the dbishell history
(new): add call to set_add_history_func, plus data
members to support it
(exec_command): use history filter function if it has been set -
this activates multi-line -> one line conversion
for the dbishell history, as well as uniq'ing
thereof
2001-08-10 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell.pm:
(parse_loop): removed add_command from here
(exec_command): and added it back in here
* DBIShell/UTIL.pm: Added some constants, plus some exports
that had been left out of the export
declarations
* DBIShell.pm:
(exec_command): Concatenation of accumulator amended to use
$/ as separator, rather than ''
2001-07-28 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell/dr/mysql.pm: Added context parameter for (out|err)putf()
* DBIShell/dr/Sybase.pm: ditto
* DBIShell/dr/Pg.pm: ditto
* DBIShell/dr/Oracle.pm: ditto
* DBIShell/dr/MSSQL_A.pm: ditto
* DBIShell/dr/DEFAULT.pm: ditto
* dbishell: ditto
* DBIShell.pm:
(outputf): Added dummy context parameter
(errputf): ditto
2001-07-25 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell/dr/DEFAULT.pm: Removed '*CTFN' typeglobs and replaced
with ordinary code references - they
failed to work for at least one person
and they didn't bring any advantages.
[ Although no-one else could reproduce
the error]
2001-07-12 Daniel Silverstone <dsilvers@digital-scurf.org>
* installer.pl: added support for an installation prefix
2001-06-10 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell/dr/mysql.pm:
(interpret): moved return statement to correct location
* DBIShell.pm:
(exec_command): abstracted out this functionality, as it was
repeated in 3 different places
(exec_script): altered to use exec_command
(parse_loop): altered to use exec_command
2001-04-04 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell/dr/Oracle.pm:
(_desc_tble): moved DESCQ out of function and renamed DESC_TABLE
(_ROW2TYPE): added utility function to translate a DESC_TABLE
row into an oracle sql type declaration.
(_desc_tble): use new _ROW2TYPE function.
(_dump_tble): new method, should allow 'show <TABLE>' to work
w. existing infrastructure.
(dump_def): open up hook to call _dump_tble()
(_dump_tble): fixed brainos in method, vaguely works now
2001-03-13 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell.pm:
(set_dot_history): altered method to use stdio buffering,
should improve performance on NFS mounted dirs.
2001-03-12 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell/dr/DEFAULT.pm:
(complete): brought '!' context tab completion into line with
'read' context completion.
* DBIShell/dr/Pg.pm: Updated Pg completion map
2001-03-08 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell/dr/Oracle.pm: Altered the PMEMBERS_QUERY,
Oracle appears to demote '' to NULL
in some cases, which is annoying.
DESC_EXEC had an ordering error for
overloaded package members.
(load_package_members): fencepost error in substr()
(package_members): method was thoroughly b0rked. Fixed now.
* DBIShell.pm:
(_dump): New method to dump out internal state of objects
for debugging
(pre_interpret): Catch and dispatch _dump() calls
2001-03-08 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell/dr/Oracle.pm:
(package_members): new method, cf packages, tables etc...
(load_package_members): ditto, cf load_tables
(_package_members): ditto, cf _tables
2001-03-07 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell/dr/mysql.pm:
(connect): now parses and caches the dsn so that we can present
sensible host info via the title() method
(_title): return title/prompt strings as <user>@<db_hostname>:<db>
instead of <user>@<client_hostname>:<db> as before.
Although the latter is more strictly correct,
since the client host is an implicit part of the username
in the mysql world, the former is more useful, since we
[ok: I] generally know where we're connecting from, but are
more concerned with which machine we've connected to
[eg, the test database I can mangle at will, or the live one
where I must tread with utmost caution, lest I execute a CLM]
(_title): Tweaked prompt format
* DBIShell/dr/DEFAULT.pm: Update pod docs.
(set_initvars): change default for PRESCAN_ROWS to 1
2001-03-05 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell/dr/Oracle.pm:
(DESC_EXEC): fixed typo in SQL
(_decompose_name): case folding required here for name matching
(describe): bad call to _resolve_object() fixed
(dump_def): _resolve_object()'s signature has changed
(_dump_exec): added more ordering to DESC_EXEC_QUERY SQL
changes to prescan version of output to do w.
SQL changes just mentioned
(_desc_pack): DESC_PACK SQL altered, to restrict it to
just the package declaration
(_desc_pxec): Identification/handling of functions/procedures
was not quite right
(_resolve_object): unused 'sh' parameter removed, mishandling
of the case where we were finding a member
of a package via an alias fixed
Bad default return list fixed
2001-03-05 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell/UTIL.pm:
(IFDEBUG): new debugging util function, exported by default
2001-03-04 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell/dr/Pg.pm:
(_users): new method, fetches a list of known users
(_triggers): new method, fetches a list of known triggers
* DBIShell/dr/Oracle.pm: D_PACK, D_OVRLD, D_POS, D_FNPROC introduced
(describe): Added description dispatch for package members
(only public functions/procedures atm - not
sure how to get at the data for other members
yet)
(_desc_exec): Made alterations to DESC_EXEC query to allow it
to be reused in _desc_pxec().
(_desc_pxec): Cloned + altered _desc_exec to provide describe
functionality for (potentially overloaded)
functions and methods that are inside packages
Largely written from memory, since I don't have a copy
of Oracle running here.
2001-03-03 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell/dr/Oracle.pm: added queries for _decompose_name method
COUNT_SCHEMA_DOT_OBJECT,
COUNT_PACKAGE_DOT_MEMBER
(_decompose_name): new method, to try and resolve ambiguities in
potentially partially qualified names
* DBIShell/dr/Pg.pm:
(describe): describe now works for tables, including default values
2001-03-02 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell/dr/Pg.pm: 285 keywords grabbed from www.postgresql.org
2001-02-27 Vivek Dasmohapatra <vivek@etla.org>
* dbishell: upped version number to 0.0.08
* DBIShell/dr/Pg.pm:
(describe): Ok, rudimentary describe, for tables only,
based on code in postgresql-6.5.3/src/bin/psql.c
is now ready.
2001-02-23 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell/dr/Pg.pm
(_procs): force uppercase field names with NAME_uc
(_views): force uppercase field names with NAME_uc
2001-02-21 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell/dr/DEFAULT.pm:
(grep_fs): tweaked method, now correctly offers non empty directories
as complete-but-not-unique choices. recursion is so elegant
* DBIShell/dr/Oracle.pm: added read, cd => HGREP_FN to completion map
* DBIShell/dr/mysql.pm: added read, cd => HGREP_FN to completion map
* DBIShell/dr/Pg.pm: added read, cd => HGREP_FN to completion map
* DBIShell/dr/Sybase.pm: added read, cd => HGREP_FN to completion map
* DBIShell/dr/DEFAULT.pm: added HGREP_FN
added read, cd to completion map
(grep_fs): added grep_fs method
* DBIShell.pm:
(is_terminated): Added check for new cd command
reordered pattern matches so that more common
patterns are checked for first
(pre_interpret): implemented 'cd' command
2001-02-20 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell.pm:
(exec_script): finally stomped on those extra newlines that
were appearing
* DBIShell/dr/Oracle.pm: tweaked tab completion after 'grant' keyword
2001-02-19 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell/dr/DEFAULT.pm:
(grep_objnames): bad call to 'objects' method removed
[actually called objs, since some databases
have specific things called objects, and others
use it as a gerneric term]
2001-02-18 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell/dr/Oracle.pm:
(new): added data member PACKAGES
(packages): new method loads lookup table PACKAGES, returns list
(load_packages): new method, does the actual loading of PACKAGES
(showables): listed several new types as showable
(describe): added dispatch point for PACKAGE type
(dump_def): added dispatch point for PACKAGE type
(_desc_pack): new, describes package [shows its declaration]
(_resolve_object): excluded PACKAGE BODY type from resolve query,
as they are guaranteed to have a name collision
with the PACKAGE type, and provide no extra info
as far as a _resolve_object call is concerned
(_packages): new method to list packages
(_triggers): new method to list triggers
* DBIShell/dr/DEFAULT.pm:
(_triggers): new stub method to list triggers
(_sequences): new stub method to list sequences
(_users): new stub method to list users
(new): new data member USERS
(users): new method loads lookup table USERS, returns list
(sequences): new method loads lookup table SEQUENCES, returns list
(triggers): new method loads lookup table TRIGGERS, returns list
(load_triggers): new method does the actual loading of TRIGGERS
(load_sequences): new method does the actual loading of SEQUENCES
(load_users): new method does the actual loading of USERS
* DBIShell/dr/Oracle.pm:
(dump_def): added ability to describe/show packages
* DBIShell/dr/DEFAULT.pm:
(show): collapsed multiple if/elsif statement by using
UNIVERSAL::can to grab the method reference for
the appropriate list function, then calling it
using CODEREF->(OBJECT) syntax
2001-02-18 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell/dr/DEFAULT.pm:
(obj_types): added method, returns types of object engine knows of
(objs): added method, returns names of all objects engine can
find
2001-02-17 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell.pm: removed TITLE_FMT macro, don't need it any more
(is_terminated): allowed \ escape of terminator character,
commmented and documented termination rules
* ALL: brought numbering of all modules into line with number of
times I have submitted changes, as I have been lax about
version numbering up to now
* DBIShell.pm:
(parse_loop): now uses new get/set title/ititle functions
(quit_cleanup): now uses new /set title/ititle functions
(new): data members for original window/icon titles
added
(parse_loop): was ignoring all blank lines: this was wrong
should only ignore _leading_ blank lines
(exec_script): as for parse_loop
* DBIShell/Term_CTL.pm:
(set_ititle): function now returns old title value
(set_title): function now returns old title value
2001-02-17 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell/Term_CTL.pm:
(get_title): new function - gets an xterm's window title
(set_title): new function - sets an xterms window title
(get_ititle): as above, but for the icon title
(set_ititle): as before, but for the icon title
(POD): documented above functions.
2001-02-16 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell/Term_CTL.pm: Altered CTL_SET_TITLE 7 bit macro to end in
ST rather than BEL.
(get_response): added new function: does black termios voodoo things
found at excessus.demon.co.uk to thrash the terminal
into submission and read the magic terminal responses
to the sequences that get settings rather than, well,
setting them. It's not pretty
2001-02-09 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell/dr/Oracle.pm (showables): added 'errors' keyword
2001-01-31 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell.pm (exec_script): was dumping extra \n in output,
maybe fixed now?
2001-01-20 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell/dr/mysql.pm: keywords list: added 'limit'
added table, tables, index entries
to completion map
2000-11-18 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell.pm (connect): added call to read_rc_script()
2000-10-30 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell.pm:
(exec_script): Altered file type checking to include the case
when we pass in a filehandle [was unchecked before]
(read_rc_script): Completed initial version of read_rc_script, not
yet tested or verified permision/mode checking
logic
* DBIShell/UTIL.pm: Added STAT_PERM_MASK and STAT_TYPE_MASK
2000-10-29 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell.pm:
(read_rc_script): added new function, not yet complete
* DBIShell/UTIL.pm: Added STAT_ constants and :stat export group
* DBIShell.pm:
(seqno): added monotonic sequence generator
(tmpfile): use seqno instead of $$ in tmpfile name
2000-10-28 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell.pm:
(set_dotdir): Added code to make <dotdir>/draft
directory for tmpfiles
Haven't yet changed 'edit' command to
use this
(tmpfile): added tmpfile method to return path to a tmpfile
(edit): made edit use tmpfile method rather than dotfile as
before
2000-10-26 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell/dr/Sybase.pm (showables): added views to listing.
2000-10-05 Vivek Dasmohapatra <vivek@etla.org>
* dbishell/: Updated/wrote lots of documentation based on
stubs by Michael <michael@etla.org>
2000-10-03 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell.pm:
(exec_script): exec_script function didn't work with configurable
EOL before now. D'oh
2000-10-03 Vivek Dasmohapatra <vivek@etla.org>
* CREDITS: added credits file
2000-10-02 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell/Help.pm: copied across changes from README from
michael <michael@etla.org>
* README: applied patch from michael <michael@etla.org>
* ChangeLog: altered address from vivek@narf to vivek@etla.org
* Makefile (clean): added clean target to zap .cf.cache
* installer.pl: installer caches config answers in .cf.cache
* DBIShell.pm:
(parse_loop): use STDERR rather than STDOUT for xterm/dtterm
title control sequences
2000-10-01 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell.pm:
(new): LAST_TITLE data member added to DBIShell object
(): TITLE_FMT and WINDOWING constants added,
CTL_SET_TITLE imported from ::Term_CTL
(parse_loop): handle setting of xterm/rxvt titles.
(quit_cleanup): attempt to reset title to something sensible
I can't seem to retrieve the data returned by
the 'CSI 2 1 t' sequence in any way, so
just use somethingapproximately sensible.
* DBIShell/Term_CTL.pm: CTL_SET_TITLE sequence added
2000-09-20 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell/dr/DEFAULT.pm:
(COMPLETION_MAP): added entry for 'table'
* DBIShell/dr/Oracle.pm:
(COMPLETION_MAP): added entry for 'table'
* DBIShell/dr/Sybase.pm:
(describe): as below for _desc_tble in dr/Oracle.pm
(COMPLETION_MAP): added entry for 'table'
* DBIShell/dr/Oracle.pm:
(_desc_tble): deal w. types for which prec, scale and size are all 0
[ eg long: depict as 'long' rather than long(0) ]
(_desc_exec): ditto
2000-09-15 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell/dr/Sybase.pm:
(describe): cosmetic changes to output
* DBIShell/dr/MSSQL_A.pm:
(_init): BEGIN blocks not called during a require, apparently
changed BEGIN to _init
(new): added call to _init()
* DBIShell/dr/Oracle.pm:
(_desc_tble): cosmetic change to output format length
(_desc_trig): all_trigger_columns changed to all_trigger_cols
* DBIShell/dr/DEFAULT.pm:
(grep_objnames): added views back in since they are now separate
* DBIShell/dr/Sybase.pm: separated views/tables internally
(_views): added new method
* DBIShell/dr/DEFAULT.pm
(show): method now recognises views as a valid target
* DBIShell/dr/Oracle.pm:
(showables): added 'views' to list of showables
(_views): added method
(_tables): excluded views from this list
* DBIShell/dr/DEFAULT.pm:
(new): added placeholders for views, triggers, sequences
[cf tables and procs]
(grep_tabnames): separated tables and views in some internal
mechanisms, have to explicitly mention views
as well as tables in some places
2000-09-14 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell/dr/Oracle.pm:
(_desc_trig): added extra column info for trigger description
(untested)
* DBIShell/dr/MSSQL_A.pm: stripped out a lot of stuff that
could either safely be inherited
or was unused, simce the methods
that used it were inherited anyway
and therefore would not have seen it.
2000-09-13 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell/dr/MSSQL_A.pm: new driver added [it's just the
Sybase driver with all the placeholder
parameters disabled, since they don't seem
to work when contacting MSSQL via Sybase
OpenClient drivers]
2000-09-12 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell/dr/Oracle.pm:
(dump_def): recognize sequences and call _desc_seqn
(_dump_seqn): method to dump sequences added
(dump_def): replaced old _desc_seqn w. current _dump_seqn,
removed _dump_seqn [it was a describe rather than
a dump] and removed sequence support from show
[for now]
(_desc_trig): added a describe trigger method
(describe): call to _desc_trig added, now that I know what
the data in all_triggers means.
2000-09-11 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell/dr/DEFAULT.pm:
(show): slight changes to paging triger size tolerance
* DBIShell.pm:
(paging): was reading wrong terminal size parameter for paging
* DBIShell/dr/DEFAULT.pm:
(nonschema_grep): added code to respect case (in)sensetivity
* DBIShell.pm:
(is_terminated): recognise various one-line commands [those that
do not require a terminating EOL character]
and report them as such:
[license, help, spool, (dis)connect, edit, read, interpolate,
escape, quit, show, describe]
* DBIShell/dr/DEFAULT.pm:
(prescan_format): removed special handling of format calculation
for numeric felds, it was annoying.
* DBIShell.pm:
(is_terminated): handle case where user sets $EOL to \n
(new): added setvar for FIELD_SEPARATOR
* DBIShell/dr/mysql.pm: removed superfluous calls to $sh->paging()
* DBIShell/dr/Sybase.pm: removed superfluous calls to $sh->paging()
* DBIShell/dr/Oracle.pm: removed superfluous calls to $sh->paging()
* DBIShell/dr/DEFAULT.pm: removed superfluous calls to $sh->paging()
* DBIShell.pm:
(start_pager): added arg to function, incorporated call to ->paging
so separate call now redundant, prevented call
to pager while call already in progress.
2000-09-10 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell/dr/mysql.pm:
(interpret): added pager support
* DBIShell/dr/Sybase.pm:
(describe): added pager support
(dump_def): added pager/prescan support
* DBIShell/dr/Oracle.pm:
(_dump_exec): added pager/prescan support
(_dump_view): added pager support
(_desc_exec): added pager support
(_desc_tble): added pager support.
* DBIShell/dr/DEFAULT.pm:
(set_initvars): changed __PACKAGE__ to ref($engine), as method can
be inherited.
(show): added pager support to 'show' method.
(describe): added pager support to 'describe' method.
* DBIShell.pm:
(add_command): method to put commands onto editor history
(command): method to get commands from editor history
(pre_interpret): catch the 'edit' command
(edit): method to actually fire up an editor and execute
the result.
* DBIShell/Help.pm: updated w. EOL + PAGER info
* DBIShell.pm:
(start_pager): paging now controllable via PAGER, PAGING
and PAGE_SIZE variables.
(is_terminated): made EOL character configurable via EOL variable
(is_terminated): commented is_terminated function.
(parse_loop): strip user specified EOL from commands if EOL is set
2000-09-08 Vivek Dasmohapatra <vivek@etla.org>
* DBIShell.pm: added basic pager support, but not yet controllable
[you can change the pager, but paging is hardwired on]
* dbishell: removed message about email being unavailable
* Added TODO file
* Added Changelog file
|
