Hi Diego, I have created, in lisp, a similar program that I like to call sql-minus (I also work with oracle by day). I am currently re-implementing it in factor (very slowly, unfortunatelly) so I am looking forward to see your work. I havent done almost anything in the shell part of it as I am refactoring the oracle bindings so I am hoping we can exchange a few ideas and code to :).
As you mentioned the parsing of commands, I dont know how you are implementing them, but I used a configuration file that the user could change and reload to add / change commands. I used this scheme for everything, including the desc command and found it very flexible, I havent solved the problem of database independency, though. As an example with this in the configuration file: (defsql tabs-like (name) "select distinct table_name from all_tab_columns where upper(trim(table_name)) like '%' || upper(trim(:name)) || '%' order by table_name") The user could just type: sql> tabs-like user to see every table with a name that contains the word 'user'. []s, Ricardo Boccato Alves. ------------------------------------------------------------------------------ The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com _______________________________________________ Factor-talk mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/factor-talk
