Login | Register
My pages Projects Community openCollabNet

Discussions > users [DISABLED] > RE: Pre-commit hook

subversion
Discussion topic

There will be a brief maintenance window every Friday at 17:00 Pacific.
For further details, see CollabNet's maintenance and upgrade policy.

Back to topic list

RE: Pre-commit hook

Author Scott Vickery <svickery at cavucorp dot com>
Full name Scott Vickery <svickery at cavucorp dot com>
Date 2009-07-10 11:11:36 PDT
Message We are using CruiseControl for a similar thing.

What I am trying to do it to prevent faulty scripts get getting into source control in the first place. Developers test against a single database, but, we have 100's of databases. Right now, there is a process that is done on the side outside of version control to test the scripts against all databases. I am trying to integrate that process into version control to make check-ins part of our process instead of an afterthought.

Basically, I trying to reduce overhead on the developer. But, as has been pointed out, this is either a pre checkin activity OR a build issue.

Thanks,
Scott

____________________​____________
From: Stephen Connolly [mailto:stephen.alan​.connolly at gmail dot com]​
Sent: Friday, July 10, 2009 2:02 PM
To: Scott Vickery
Cc: users at subversion dot tigris dot org
Subject: Re: Pre-commit hook

I would prefer a CI system such as Hudson that polls svn and checks out the scripts and runs them against your database.

using a pre-commit or post-commit hook is tight coupling your CI with your source control aka a bad thing

what happens when the database is down and you've left on holidays for two weeks? nobody can commit

Sent from my [rhymes with myPod] ;-)

On 10 Jul 2009, at 18:15, Scott Vickery <svickery@cavucor​p.com<mailto:svic​kery at cavucorp dot com​>> wrote:

I have a process in place that sanity checks SQL scripts. The user can take a list set of scripts which are then run against a series of databases to see if they run. The user is given feedback as they run. If the scripts fail, the user is told which database the script failed against.

I want to put that process in place as pre-commit hook. So far so good. But, I would like to provide real time progress to the user that did the commit.

Any ideas on how I could pull this off? AFAIK, the pre commit hook is only run on the server, and, there is no way for the user to see it. Correct?

Thanks,
Scott
Attachments
attachment-2709614

« Previous message in topic | 9 of 15 | Next message in topic »

Messages

Show all messages in topic

Subject
Author
Full name
Date posted
+
Pre-commit hook Scott Vickery <svickery at cavucorp dot com> Scott Vickery <svickery at cavucorp dot com> 2009-07-10 10:15:54 PDT
     RE: Pre-commit hook pilotbob Bob Archer 2009-07-10 10:39:52 PDT
         RE: Pre-commit hook Scott Vickery <svickery at cavucorp dot com> Scott Vickery <svickery at cavucorp dot com> 2009-07-10 10:43:42 PDT
             RE: Pre-commit hook pilotbob Bob Archer 2009-07-10 10:56:45 PDT
     Re: Pre-commit hook levyam Andy Levy 2009-07-10 10:48:18 PDT
         RE: Pre-commit hook Scott Vickery <svickery at cavucorp dot com> Scott Vickery <svickery at cavucorp dot com> 2009-07-10 10:52:25 PDT
     Re: Pre-commit hook Nicolai Scheer <scope at planetavent dot de> Nicolai Scheer <scope at planetavent dot de> 2009-07-10 10:50:19 PDT
     Re: Pre-commit hook Stephen Connolly <stephen dot alan dot connolly at gmail dot com> Stephen Connolly <stephen dot alan dot connolly at gmail dot com> 2009-07-10 11:02:20 PDT
         RE: Pre-commit hook Scott Vickery <svickery at cavucorp dot com> Scott Vickery <svickery at cavucorp dot com> 2009-07-10 11:11:36 PDT
             Re: Pre-commit hook levyam Andy Levy 2009-07-10 11:28:00 PDT
             RE: Pre-commit hook pilotbob Bob Archer 2009-07-10 11:28:53 PDT
     Re: Pre-commit hook ryandesign Ryan Schmidt 2009-07-10 11:55:25 PDT
         RE: Pre-commit hook pilotbob Bob Archer 2009-07-10 11:58:14 PDT
             Re: Pre-commit hook ryandesign Ryan Schmidt 2009-07-10 12:05:51 PDT
                 RE: Pre-commit hook Scott Vickery <svickery at cavucorp dot com> Scott Vickery <svickery at cavucorp dot com> 2009-07-10 13:15:47 PDT
Messages per page: