Insert issue directly in the MySQL database

Added by tupak golqm about 12 years ago

Hello,

I was wondering if someone has already tried to insert issues directly into a redmine database(into the issues table) without actually using Redmine. If yes, please share what is needed to be done in order to have a valid issue.

Thanks in advance.

Replies (3)

RE: Insert issue directly in the MySQL database - Added by Felix Schäfer about 12 years ago

tupak golqm wrote:

I was wondering if someone has already tried to insert issues directly into a redmine database(into the issues table) without actually using Redmine. If yes, please share what is needed to be done in order to have a valid issue.

I strongly advise against this, as Rails and ActiveRecord assume they are the sole consumers of the Database. You could try using the REST interface to Redmine, if present (not sure how far the RESTing of Redmine has come), or work with Redmine through rake tasks or /path/to/redmine/script/console. You can find documentation to both of those methods in any somewhat complete rails tutorial.

RE: Insert issue directly in the MySQL database - Added by tupak golqm about 12 years ago

I am actually trying to interface Redmine with our production "home brew" bug tracker and the thing is that I've never used ruby before...

I am currently testing if this could disturb the normal operation of Redmine.

RE: Insert issue directly in the MySQL database - Added by Felix Kokocinski about 12 years ago

Yes, it's not the "proper way", but I need to do this as well. I wrote some perl functions and as long as you do sanity checking and get the correct status-id, priority-id and tracker-id, it works fine.

(1-3/3)