Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#70 Change Topic State from command line

open
nobody
5
2007-10-09
2007-10-09
Anonymous
No

It would be nice to change the topic state from the command line.

For example, here a code review is required prior to code check in. The code review must be in the APPROVED state before the check in can proceed. Once the code has been successfully checked in, the topic state should change from APPROVED to SUBMITTED. Certainly there is no need for the reviewer(s) or an admin to manually change the state from APPROVED to SUBMITTED.

I'm on the cusp of getting a localized customization to version 1.9.2 accomplished here that does that. I'm trying to maintain the same object and model style and making certain that the database remains consistent.

For example, just changing the "state" column of the "topic" table in the "codestrikerdb" database would make the database inconsistent because I had not updated the topicstatehistory table (and others?) along with the topic table.

Since my SQL, DBI, Perl and OO are all rusty, I'm proceeding cautiously here.

Thanks,
Ken Wolcott

Discussion

  • David Sitsky
    David Sitsky
    2007-10-09

    Logged In: YES
    user_id=208928
    Originator: NO

    Hi Ken,

    Have a look at bin/CodestrikerClient.pm. This is used by people to create topics from the command line. You should be able to extend this to do the same thing with changing the state of a topic, so that SubmitEditTopicsState.pm is effectively called.

    Cheers,
    David