Details
-
Type:
Improvement
-
Status:
Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: CM8.4.1.201208, CQB8.4.1.201208
-
Component/s: CUBRID Manager, CUBRID Query Browser
Description
1.
여러 DB에 동일한 데이터를 입력하기 위해 Navigation tree에 선택한 DB에 대해 동시로 sql을 실행하고 실행이 실패한 sql은 별도의 파일로 출력하여 사용자가 실패한 파일을 다시 확인하고 실행할 수 있도록 수정한다.
2.
대량의 insert가 발생할 때 필요한 commit count를 지정할 수 있도록 한다.
1.
为了在多个DB内输入同样的数据，对在Navigation tree选择的DB同时执行sql后，对执行失败的sql用单独的文件显示出，来让用户对失败的文件可进行查看并重新执行。
2.
在发生大量insert时使其可指定所需要的commit count。
Modify feature
1.Not load whole SQL file before execute SQL now ,load the count of "Process SQL count" SQLs then execute them in database ,and continue load from SQL file until all SQL loaded and executed
2.Because of not load whole SQL ,modify the monitor logic , original logic is count SQL number, now is count string size of the SQL file
3.Add thread count options, user can set how many file be processed simultaneously in one database
4.Use can save error data to excel automaticlly when SQL file is being processed simultaneously(One excel file save one database info,and one sheet match one SQL file. Also can save error date when all processing is finished,but it store only 1000 failed sql on one SQL file.
6.User can select SQL file on different path
Test step
1.Select multiple database on navigator tree then select "Run SQL file"
2.Select SQL file and check "Auto save error detail to excel" option ,if want to add other databases , drag database from navigator tree ,right click SQL file or database table can delete SQL file or database, click "OK" button to start run SQL file
3.Check whether open processing monitor (one database matches one monitor part),and check whether the SQL file is being processing,when all execution is finished,check whether error data excel (if it has failed SQL) had been saved
4.Click "Export failed data" button to export error data