Attached is a snippet of Perl I came up with to set the ReviewRequest as 
"Submitted" using SQL. I know this is probably not a desired way to do 
it, but it worked for us.

If there is any use for this, I can tidy it up a bit and submit it to 
the project.

Hovanes

Augie Fackler wrote:
> On Oct 20, 2008, at 8:04 PM, Christian Hammond wrote:
>
>   
>> Not yet but I have an upcoming change that will introduce this. It  
>> will be
>> part of a larger UI restructuring, but maybe I can pull this out and  
>> make it
>> available sooner.
>>     
>
> When this goes in, I'll see if I can cook up a post-commit-hook that  
> should be able to automatically mark reviews as submitted upon commit.
>
>   
>> Christian
>>
>> -- 
>> Christian Hammond - [EMAIL PROTECTED]
>> VMware, Inc.
>>
>>
>> On Mon, Oct 20, 2008 at 5:58 PM, Hovanes <[EMAIL PROTECTED]> wrote:
>>
>>     
>>> Hello All,
>>>
>>> I was wondering if there is a way to mark a review as Submitted using
>>> the JSON API.
>>>
>>> I have read the API documentation and cannot find any method to do
>>> this.
>>>
>>> Thanks in advance,
>>>
>>> Hovanes
>>>       
>
>
> >
>
>   


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"reviewboard" group.
To post to this group, send email to reviewboard@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/reviewboard?hl=en
-~----------~----~----~----~------~----~------~--~---

sub SetSubmitted($) {
        my $ReviewId = shift;
        # Connect to the database.
        my $dbh = DBI->connect("DBI:mysql:database=".$DBNAME.";host=".$DBHOST, 
$DBUSER, $DBPASS, { RaiseError => 1} );

        # Set status to Submitted
        my $sth = $dbh->prepare( "UPDATE reviews_reviewrequest SET status='S' 
WHERE id=?" ) or do
                {
                        print STDERR "Couldn't prepare statement: " . 
$dbh->errstr, "\n";
                        return 0;
                };

        $sth->execute( $ReviewId ) or do
                {
                        print STDERR "Couldn't execute statement: " . 
$sth->errstr, "\n";
                        return 0;
                };
        return 1;

}

Reply via email to