Quantcast

Post data build updating SQL triggers added to InterMine dev branch

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Post data build updating SQL triggers added to InterMine dev branch

Justin Clark-Casey-2
Hi devs.  To let you know, I've just added to the InterMine dev branch Joe Carlson's code by which InterMine can generate trigger SQL.  These triggers can be
optionally added to a mine to allow the data to be updated after the main build in certain circumstances.

Documentation is at [1].  This is a strictly experimental try-at-your-own-risk feature but discussion, feedback and patches very welcome.  And huge thanks to
Joe for writing this and contributing the code to InterMine.

[1] http://intermine.readthedocs.io/en/latest/database/database-building/post-build-updating-with-sql-triggers/

--
Justin Clark-Casey, Synbiomine/InterMine Developer
http://synbiomine.org
http://twitter.com/justincc
_______________________________________________
dev mailing list
[hidden email]
https://lists.intermine.org/mailman/listinfo/dev
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Fwd: Post data build updating SQL triggers added to InterMine dev branch

Justin Clark-Casey-2
Sorry, I should also have said that I did some editing on the documentation and some refactoring of the code so I accept full responsibility for any mistakes
that arose out of this :)

-------- Forwarded Message --------
Subject: [InterMine Dev] Post data build updating SQL triggers added to InterMine dev branch
Date: Wed, 10 May 2017 17:14:10 +0100
From: Justin Clark-Casey <[hidden email]>
To: [hidden email]

Hi devs.  To let you know, I've just added to the InterMine dev branch Joe Carlson's code by which InterMine can generate trigger SQL.  These triggers can be
optionally added to a mine to allow the data to be updated after the main build in certain circumstances.

Documentation is at [1].  This is a strictly experimental try-at-your-own-risk feature but discussion, feedback and patches very welcome.  And huge thanks to
Joe for writing this and contributing the code to InterMine.

[1] http://intermine.readthedocs.io/en/latest/database/database-building/post-build-updating-with-sql-triggers/

--
Justin Clark-Casey, Synbiomine/InterMine Developer
http://synbiomine.org
http://twitter.com/justincc
_______________________________________________
dev mailing list
[hidden email]
https://lists.intermine.org/mailman/listinfo/dev
_______________________________________________
dev mailing list
[hidden email]
https://lists.intermine.org/mailman/listinfo/dev
Loading...