Sync project status to the direct projects

[vikasrohit]

Expected behavior

• All project status updates should be reflected in corresponding direct project, if available.
• Direct project should be created in Draft status if possible.

Actual behavior

• None of the project status change is synced back to the direct project as of now
• Direct project is created in Active status by default

Steps to reproduce the problem

• Create a project in Connect
• Update the Connect project status to say Cancelled
• Open the direct project associated with the newly created project
• Observe that direct project is not cancelled yet

Screenshot/screencast

[vikasrohit]

@maxceem let me know your thoughts

[maxceem]

@vikasrohit In general, it looks like straightforward to implement using our new legacy-project-processor which we use to update Direct projects. The only question is if we prefer to use Direct API for new functionality or directly call InformixDB as it's done now for existent functionality.

[vikasrohit]

I am not sure about continuing with the InformixDB calls. Personally, I would prefer the API calls, but I guess, there is some other thinking behind using the SQL instead in first place. I would try to confirm it with the team and come up with a decision.

[vikasrohit]

On the second thoughts, I think we can continue with SQL for implementing this and later on we can remove the usage of the SQL altogether when we do refactoring for this.