SQLSyntax - Feature to complete the sqlcommands

[Razec]

Hi folks,

I'm writing and testing a simple feature for give suggests hints to
complete the sqlcommands. The vocabulary contains a word that starts
with what has been typed.

Today I did commit for Trunk. Check

Implementations:

SwingUtils.java

added send sql commands for analysis of SQLSyntax
sqltext.getDocument().addDocumentListener(new SQLSyntax(sqltext));

added in sqltext a event for closes the open parenthesis.


SQLSyntax.java

This class is used for complete the sql command typed in sqltext
(JTextArea)

Future Implementations:

Add dictionary for sql command.

HowTo

*Connect to the Database
*press the button [ SQL ] (Will open the follow message)
----------------------------------------------------
Write here your query. (Delete this message)
-----------------------------------------------------

Write your sql command:
-----------------------------------------------------------
( <- automatically closes the open parenthesis
se <-(Just Moment auto-complete your command (select)
------------------------------------------------------------

*I added some sql commands for auto-complete

BUGs
*Sometimes don't auto-complete the sql commands.


I will be waiting for your suggestion

Have nice week!!

---
Razec

[Damico]

Hi Miro,

As a first action to FISL 10 version :) can you review, test (junit)
with Razec this SQLSyntax impl. ?
Razec? Can you write on WIKI a SQLSytntax test case?

[]s

Damico

[Mir0]

Hi folks,

Sure!

Razec, I'll available in GTalk every day.


TX

Miro

[Razec]

Hi Miro..

Ok, I'll be in touch..

See you

Thx

---
Razec

[Damico]

Hi Mir0,

Please review Razec's work/code, test it and give to us your opinion.
If you say that is everything ok, I will promote to our new version.
If not, please coordinate the adjusts with Razec.

[]s

Damico


On Mar 8, 3:46 pm, Razec <mra...@gmail.com> wrote:

[Mir0]

Folks,


Still checking.. I will give a feedback ASAP..


[ ]'s


Miro

[Razec]

Hi Mir0, How are you?

Mir0,

I think that auto-complete could be very faster but is very slow..
I tried add sqlDictionary.txt with words, but continued slow and same bug.

I found one bug:
-Auto-complete sometimes works and sometimes doesn't.

Class: SQLSyntax:
 http://code.google.com/p/dbjmin/source/browse/trunk/DB2-JMIN-SWING/src/db2jmin/pojo/util/SQLSyntax.java

Do you have any idea?

Cheers
--
Razec