Details
-
Type:
New Feature
-
Status:
Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: CM8.4.1.201204, CQB8.4.1.201204
-
Component/s: CUBRID Manager, CUBRID Query Browser
-
Labels:
Description
--> Reduce developer's keyboard typing
1) improvement
while query editor is open, clicking a table name(ex: aa) generates/executes "SELECT * FROM aa LIMIT 30"; (currently nothing works)
while query editor is open, clicking a column name, it enters column name in the editor. (currnetly I should copy and paste)
while query editor is open, clicking an index name, it enters index name in the editor. (currently nothing works)
2) adding a new icon
table icon click -> SELECT * button click --> SELECT * FROM 'table_name' WHERE 1 statement is written on the editor.
table icon click -> SELECT button click --> SELECT col_1, col_2, ~~~col_n FROM 'table_name; WHERE 1 statement is generated on the editor.
table icon click -> INSERT button --> INSERT INTO `table_name`(`ipaddress`, `regdate`, `user_agent`, `site_srl`) VALUES ([value-1],[value-2],[value-3],[value-4]); on the editor
table icon click -> UPDATE button -> UPDATE `table_name` SET `ipaddress`=[value-1],`regdate`=[value-2],`user_agent`=[value-3],`site_srl`=[value-4] WHERE 1
table icon click ->DELETE button --> DELETE FROM `xe_counter_log` WHERE 1 is written
developers can easily edit the auto-generated SQLs for their purpose.
"Create PHP code" and "Create Java code" icon on the top
-> when clicking, it generates a code the current sql in the editor
Issue Links
- is duplicated by
-
TOOLS-923
Improvement of editing sql on Query Editor
-