Hi all, playing around with the db vocabs I ended up writing a little tool for quick db testing and management in an sqlplus style (I called it sqlplus because I work with oracle by day) directly in the listener. A quick example (the output is actually formatted with a tabular-output, sorry for bad indentation):
( scratchpad ) "counter.db" <sqlite-db> sqlplus sqlplus> show Tables Temporary? ASIDES N CONVERSATIONS N PERMITS N SESSIONS N USERS N test N sqlplus> describe users Id Field Type Null? Default Pk 0 USERNAME text Y 1 1 REALNAME text Y 0 2 PASSWORD blob N 0 3 SALT integer N 0 4 EMAIL text Y 0 5 TICKET text Y 0 6 CAPABILITIES blob Y 0 7 PROFILE blob Y 0 8 DELETED integer N 0 sqlplus> insert into test values ( 'zz', 666, 'OMG' ) Ok. sqlplus> select * from test A 0 lol B 0 lol zz 666 OMG sqlplus> bye ( scratchpad ) The output is properly formatted and I added some colors (the 'Ok.' message has actually a green background). Before pushing to github, I'd like to hear some feature requests if you think this would be useful. By now, I added 'show tables' and 'describe table' commands. It is supposed to work in a db independent manner. Bye, Diego ------------------------------------------------------------------------------ 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
