In-Portal Issue Tracker - In-Portal CMS
Viewing Issue Advanced Details
ID: Category: Type: Reproducibility: Date Submitted: Last Update:
1208 [In-Portal CMS] Data Management feature request N/A 2012-02-13 14:38 2012-07-25 05:31
Reporter: alex Platform:  
Assigned To: alex OS:  
Priority: normal OS Version:  
Status: closed Product Version: 5.1.3  
Product Build: Resolution: fixed  
 
ETA: none Fixed in Version: 5.2.0-B2  
Reference: https://groups.google.com/d/topic/in-portal-dev/IH4rV_hhTDw/discussion
Change Log Message: Improved output report of automatic deployment script
Estimate Points: 1
Summary: 0001208: Improvements to automatic deployment script
Description: We need to enhance current status report that is displayed during execution of automatic deployment script.

Plan of what needs to be done:
------------------------------
1. don't remove all comments before executing sqls
2. during sql processing if we see, that it's a comment, then display it (whole version) and if sql replace \r\n with spaces and display first 80th symbols and [ok] near that sql - 0.3h
3. if error during sql processing then display sql in same format as normal sqls above but FAILED instead of OK and SQL error listead after failed (in red color) - 0.2h
4. display deploy output on "System Tools" page too (just don't do redirect) - 0.5h
5. show complete revision title (not only number) during it's procecssing - 0.5h
6. show revision title in bold (use escape sequences in command line and <stong> tags when in HTML) - 0.5h
Steps To Reproduce:
Additional Information:
Relationships
parent of 0001278closed  (5.2.0)alex HTML not escaped in Deployment script output 
child of 0001034closed  (5.1.3)alex Improving Project Deployment Processes to DEV or LIVE servers 
Attached Files: patch informative_colorized_deployment_script_report.patch (16,807) 2012-02-16 03:34
http://tracker.in-portal.org/file_download.php?file_id=1512&type=bug
png deployment_script_web_output.png (132,686) 2012-02-16 03:41
http://tracker.in-portal.org/file_download.php?file_id=1513&type=bug
png

patch deployment_script_display_affected_row_count.patch (380) 2012-02-20 13:10
http://tracker.in-portal.org/file_download.php?file_id=1517&type=bug
patch deployment_script_display_affected_row_count_log.patch (1,354) 2012-02-22 02:45
http://tracker.in-portal.org/file_download.php?file_id=1519&type=bug
Issue History
Date Modified Username Field Change
2012-07-25 05:31 alex Note Added: 0004971
2012-07-25 05:31 alex Status resolved => closed
2012-05-16 08:32 alex Relationship added parent of 0001278
2012-02-22 02:45 alex Changeset attached 5.2.x r15120
2012-02-22 02:45 alex Note Added: 0004470
2012-02-22 02:45 alex File Added: deployment_script_display_affected_row_count_log.patch
2012-02-21 16:36 Dmitry Note Added: 0004469
2012-02-20 13:11 alex Note Added: 0004466
2012-02-20 13:10 alex Changeset attached 5.2.x r15117
2012-02-20 13:10 alex File Added: deployment_script_display_affected_row_count.patch
2012-02-16 03:41 alex File Added: deployment_script_web_output.png
2012-02-16 03:41 alex Note Added: 0004461
2012-02-16 03:41 alex Status reviewed and tested => resolved
2012-02-16 03:41 alex Fixed in Version => 5.2.0-B2
2012-02-16 03:41 alex Resolution open => fixed
2012-02-16 03:41 alex Assigned To !COMMUNITY => alex
2012-02-16 03:41 alex Changeset attached 5.2.x r15112
2012-02-16 03:40 alex Note Added: 0004460
2012-02-16 03:40 alex Status needs testing => reviewed and tested
2012-02-16 03:34 alex Time Estimate Removed 2 =>
2012-02-16 03:34 alex Assigned To => !COMMUNITY
2012-02-16 03:34 alex Developer => alex
2012-02-16 03:34 alex Status active => needs testing
2012-02-16 03:34 alex File Added: informative_colorized_deployment_script_report.patch
2012-02-15 13:04 alex Note Added: 0004459
2012-02-13 14:40 alex Relationship added child of 0001034
2012-02-13 14:38 alex New Issue
2012-02-13 14:38 alex Reference => https://groups.google.com/d/topic/in-portal-dev/IH4rV_hhTDw/discussion
2012-02-13 14:38 alex Change Log Message => Improved output report of automatic deployment script
2012-02-13 14:38 alex Estimate Points => 1
2012-02-13 14:38 alex Time Estimate Updated 0 => 2

Notes
(0004459)
alex   
2012-02-15 13:04   
Dmitry also suggested to keep log (in /system/.restricted/ folder) of all output from running deployment scripts.
(0004460)
alex   
2012-02-16 03:40   
Will test all together later.
(0004461)
alex   
2012-02-16 03:41   
Fix committed to 5.2.x branch. Commit Message:

Fixes 0001208: Improvements to automatic deployment script
(0004466)
alex   
2012-02-20 13:11   
Patch "deployment_script_display_affected_row_count.patch" allows to display affected row count after sql execution
(0004469)
Dmitry   
2012-02-21 16:36   
Thanks Alex would you please add "affected row count" to the LOG file - this would be a great to have it save for the future reference.
(0004470)
alex   
2012-02-22 02:45   
Patch "deployment_script_display_affected_row_count_log.patch" displays affected row count in log.
(0004971)
alex   
2012-07-25 05:31   
Since 5.2.0 version was released.