Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Topics - eddiedoey

Pages: [1]
1
Automation Interface, Add-Ins and Tools / SQL Server - Change tracking
« on: September 07, 2005, 05:55:18 am »
With the lack of a real lifecycle model for requirements etc i.e with permissions, i have been looking at ways to enforce auditing. for example, we put our usecases through a lifecycle  as Proposed, Accepted, In Design, In Development, Frozen. i wanted to track the state changes of these, so added a trigger to SQL server. (first one i ever created).

looking to share ideas on this one. perhaps people have done similar stuff. was wondering doing some permission checking stuff in here to. i.e. only project manager can set things into a certain state. who knows.

This is what i implemented

CREATE TABLE [dbo].[MCL_USE_CASE_STATE_AUDIT]
(

[PreviousState] [nvarchar] (50) ,

[NewState] [nvarchar] (50) ,

[UserName] [nvarchar] (50),

[ChangeDate] [datetime],

[ObjectId] [int]  
)

CREATE TRIGGER StateTrigger ON [dbo].[t_object]
FOR  UPDATE
AS
begin
if update(Status)

insert  dbo.MCL_USE_CASE_STATE_AUDIT ( PreviousState, NewState,  UserName, ChangeDate, ObjectId)
select deleted.Status, inserted.Status, user_name(),  getDate(), deleted.Object_Id  from inserted, deleted where deleted.Object_Type = 'UseCase' and deleted.Object_id = inserted.Object_id
end

and as i said, first trigger on SQL server so if you can tidy up the definition then let me know :)


2
We are recent converts to EA and whilst think its great, we don't really have any interfaces with our other tools.

The first one I am looking at is Mercury's TestDirector 7.1. I have started an intergration addin to sync the use cases/requirements with the requirements feature of TestDirector, so that we can monitor test coverage etc etc. through test director

Is there anyone out there with a similar requirement? I would be happy to share my work and ideas.


3
Automation Interface, Add-Ins and Tools / Information on Addin's
« on: October 27, 2003, 10:13:41 am »
I am interested in doing some customisation on EA. Tried the Automation interface, but it always seems to start a new editor. Doesn't seem to register in the running object table.

Would an addin, let me tap into the current session and if so, where is the docs for it?

Pages: [1]