{"id":1767,"date":"2007-03-24T09:54:23","date_gmt":"2007-03-24T09:54:23","guid":{"rendered":"http:\/\/gurkan.wordpress.com\/?p=1767"},"modified":"2017-09-06T00:15:32","modified_gmt":"2017-09-06T00:15:32","slug":"bugtracker-net-and-subversion","status":"publish","type":"post","link":"https:\/\/www.havatopraksu.org\/blog\/2007\/03\/24\/bugtracker-net-and-subversion\/","title":{"rendered":"BugTracker.Net and Subversion"},"content":{"rendered":"

Corey Trager<\/a> of BugTracker.NET<\/a> has sent this vbs script below which can be enhanced to integrate SVN and BugTracker. It grabs entries from SVN when files are committed and posts to the database that BugTracker.Net uses.<\/p>\n

I didn’t want this code to be lost in comments and copied here with formatting.<\/p>\n

Thanks very much Corey.<\/p>\n

\u00a0<\/p>\n

<\/p>\n

option<\/span> explicit\n' HOW TO USE THIS SCRIPT<\/span>\n\n' This script is a Subversion \"post-commit hook\".<\/span>\n' To execute this script first create a file in your repository hooks folder<\/span>\n' called \"post-commit.bat\".<\/span>\n\n' Put just one line in the .bat file which will point to this script.<\/span>\n' c:\\somewhere\\btnet_post_commit.vbs %1 %2<\/span>\n\n' Put this script where the .bat file is pointing to, and then edit the<\/span>\n' lines below.<\/span>\n\n' Change this line so that it's the path to your Subversion\\bin\\svnlook.exe<\/span>\ndim<\/span> svnlook_path\nsvnlook_path = \"\"<\/span>\"c:\\program files\\subversion\\bin\\svnlook\"<\/span>\"\"<\/span>\n\n' Change the database connection string here.<\/span>\n' This is NOT the same as the one in web.config. Web.config is using ADO.NET.<\/span>\n' This one is using plain old ADO.<\/span>\ndim<\/span> connection_string\nconnection_string = \"Provider=SQLOLEDB; Data Source=(local); Initial Catalog=btnet; User ID=sa; Password=;\"<\/span>\n\ndim<\/span> temp_file\ntemp_file = \"C:\\temp\\btnet_svntemp.txt\"<\/span><\/pre>\n
<\/span>\n' END OF THE PARTS YOU HAVE TO CHANGE. THE REST SHOULD BE OK<\/span><\/pre>\n
<\/span>\ndim<\/span> repos\ndim<\/span> rev\nrepos = wscript.arguments(0)\nrev = wscript.arguments(1)\n' repos = \"c:\\cit\\svnrepos\" for testing<\/span>\n' rev = 12 for testing<\/span>\n\ndim<\/span> shell\nset<\/span> shell = WScript.Createobject(\"WScript.Shell\"<\/span>)\n\ndim<\/span> cmd\ndim<\/span> results_object\ndim<\/span> log_string\ndim<\/span> changed_string\n\n' run the svnlook log command<\/span>\ncmd = svnlook_path & \" log -r \"<\/span> & rev & \" \"<\/span> & repos\nset<\/span> results_object = shell.exec(cmd)\nlog_string = results_object.stdout.readall\n\n' run the svnlook changed command<\/span>\ncmd = svnlook_path & \" changed -r \"<\/span> & rev & \" \"<\/span> & repos\nset<\/span> results_object = shell.exec(cmd)\nchanged_string = results_object.stdout.readall\n\n' for debugging<\/span>\n' wscript.echo log_string<\/span>\n' wscript.echo changed_string<\/span>\n\n' look for the bugid as the first digits in the checkin comment<\/span>\ndim<\/span> re\nset<\/span> re = new<\/span> regexp\nre.pattern = \"^[0-9]*\"<\/span>\n\ndim<\/span> matches\nset<\/span> matches = re.execute(log_string)\n\ndim<\/span> bugid\nif<\/span> matches.count > 0 then<\/span>\nset<\/span> bugid = matches(0)\nelse<\/span>\n' no digits, nothing to do<\/span>\nwscript.quit 0\nend<\/span> if<\/span>\n\n' at this point, we have a bugid<\/span>\n\ndim<\/span> conn\nset<\/span> conn = createobject(\"adodb.connection\"<\/span>)\nconn.open(connection_string)\n\n' loop through the files, the output of the \"changed\" command<\/span>\ndim<\/span> lines\nlines = split(changed_string, vbcrlf)\nif<\/span> ubound(lines) > 0 then<\/span>\ndim<\/span> i\nfor<\/span> i = 0 to<\/span> ubound(lines) - 1\ndim<\/span> cols\ncols = split(lines(i), \" \"<\/span>)\nif<\/span> ubound(cols) = 1 then<\/span>\ndim<\/span> action\ndim<\/span> file\naction = cols(0)\nfile = cols(1)\n\ndim<\/span> sql\nsql = \"insert into bug_file_revisions \"<\/span>\nsql = sql & \" (bfr_bug, bfr_revision, bfr_action, bfr_file, bfr_date) \"<\/span>\nsql = sql & \" values ($bug, $rev, N'$act', N'$file', getdate())\"<\/span>\nsql = replace(sql,\"$bug\"<\/span>,bugid)\nsql = replace(sql,\"$rev\"<\/span>,rev)\nsql = replace(sql,\"$act\"<\/span>,action)\nsql = replace(sql,\"$file\"<\/span>,file)\n\nconn.execute(sql)\n\nend<\/span> if<\/span>\nnext<\/span>\nend<\/span> if<\/pre>\n","protected":false},"excerpt":{"rendered":"
Corey Trager of BugTracker.NET has sent this vbs script below which can be enhanced to integrate SVN and BugTracker. It grabs entries from SVN when files are committed and posts to the database that BugTracker.Net uses. I didn’t want this code to be lost in comments and copied here with formatting. Thanks very much Corey. […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[207,213],"tags":[],"class_list":["post-1767","post","type-post","status-publish","format-standard","hentry","category-bilisim","category-english"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p90nFK-sv","jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.havatopraksu.org\/blog\/wp-json\/wp\/v2\/posts\/1767","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.havatopraksu.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.havatopraksu.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.havatopraksu.org\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.havatopraksu.org\/blog\/wp-json\/wp\/v2\/comments?post=1767"}],"version-history":[{"count":1,"href":"https:\/\/www.havatopraksu.org\/blog\/wp-json\/wp\/v2\/posts\/1767\/revisions"}],"predecessor-version":[{"id":3145,"href":"https:\/\/www.havatopraksu.org\/blog\/wp-json\/wp\/v2\/posts\/1767\/revisions\/3145"}],"wp:attachment":[{"href":"https:\/\/www.havatopraksu.org\/blog\/wp-json\/wp\/v2\/media?parent=1767"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.havatopraksu.org\/blog\/wp-json\/wp\/v2\/categories?post=1767"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.havatopraksu.org\/blog\/wp-json\/wp\/v2\/tags?post=1767"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}