|
We setup a sort of versioning table that our migration scripts would run and add to at a previous work place. We had code to run the migrations in order, and only once. So we could easily run the deploy scripts against the database in any state along the way and be safe/confident.
Elephant elephant elephant, sunshine sunshine sunshine
|
|
|
|
|
We do exactly the same thing.
That example was merely an example. I'm looking more towards code that actively changes itself.
cheers
Chris Maunder
|
|
|
|
|
We have views and stored procedures between the data and the applications. If I need to migrate a column to a different name or size, I
1. add the new column,
2. add code to the create and update procedures to update the new column as well as the old,
3. manually copy the old data to the new data,
4. change the views to use the new column (if adding new functionality rather than migrating, use ISNULL() as needed),
5. make new versions of the procedures (I add a number to the name for that purpose) to use the new column,
6. change the application in development and testing to use the new procedures,
7. deploy the new version of the application.
Later, after the data and application have been backed up or updated several times, I can delete the old versions of the procedures.
|
|
|
|
|
Add a "date >= ??? or" or "negation and" statement to your if statement so that it automatically gets or doesn't get called after a certain date.
Another option for enabling is if you can send a cleaner code to remove the if/then statement by converting it to whitespace and leaving the braces as is. Then the code will get called thereafter.
GoTo statement? 
|
|
|
|
|
I'm thinking I'll just ditch if/then/while and for statements altogether and use goto.
cheers
Chris Maunder
|
|
|
|
|
|
|
Chris Maunder wrote: Has anyone ever heard of a system or language or framework that provides the means to have code self-destruct after a certain date?
Haven't heard of it. I wouldn't use it.
I version the database. Each instance has a version number table which includes at least the version number and a timestamp. The application knows what version(s) it will deal with and will refuse to run (exit) if the version is not allowed.
Separate process updates the database, when completed it updates the version table.
Each version consists of one or more updates that are blocked together. That means that every so often one can just delete the oldest blocks (say 6 months ago) so that they no longer run. Presumption is that there are no older databases at that point (if selling a product then the updated product would include the old install and thus the update.) Naturally it is under version control so it is always retrievable.
|
|
|
|
|
How to Ask
Is your question about programming?
We prefer questions that can be answered, not just discussed.
Provide details. Share your research.
If your question is about this website, ask it on meta instead.
visit the help center »
asking help »
|
|
|
|
|
Sounds like you want self morphing code, similar to Self-Morphing C# Binary - bytecode77
As also recommended, I've seen devs load branches of code / assemblies based on version in a database/configuration file.
So
version 1 load mydatabasetier.v1.dll
version 2 load mydatabasetier.v2.dll
Seems like a lot of extra overhead.
Common sense is admitting there is cause and effect and that you can exert some control over what you understand.
|
|
|
|
|
Very cool, but it's changing the compiled code, not the actual source code.
But very cool even so
cheers
Chris Maunder
|
|
|
|
|
(Stolen from twitter)
Interviewer: What would you say is your biggest strength?
Me: I perform under pressure.
Interviewer: Can you give me an example?
Me:
*deep breath*
Mm ba ba de
Um bum ba de
Um bu bu bum da de
PRESSURE, pushing down on me...
|
|
|
|
|
This is the Queen of bad jokes.
* CALL APOGEE, SAY AARDWOLF
* GCS d--- s-/++ a- C++++ U+++ P- L- E-- W++ N++ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t++ 5? X R++ tv-- b+ DI+++ D++ G e++>+++ h--- ++>+++ y+++* Weapons extension: ma- k++ F+2 X
* Never pay more than 20 bucks for a computer game.
* I'm a puny punmaker.
|
|
|
|
|
Lord please have Mercury on me
... such stuff as dreams are made on
|
|
|
|
|
another pointless thread; I want to break free
Installing Signature...
Do not switch off your computer.
|
|
|
|
|
I suggest you go to Barcelona.
... such stuff as dreams are made on
|
|
|
|
|
I had one vision, a flash, and then a breakthru: if you don't stop me now, friends will be friends. After all it's a beautiful day, living on my own... I want it all to be remember fondly, after all those are the days of our lives.
* CALL APOGEE, SAY AARDWOLF
* GCS d--- s-/++ a- C++++ U+++ P- L- E-- W++ N++ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t++ 5? X R++ tv-- b+ DI+++ D++ G e++>+++ h--- ++>+++ y+++* Weapons extension: ma- k++ F+2 X
* Never pay more than 20 bucks for a computer game.
* I'm a puny punmaker.
|
|
|
|
|
Ok, we will do as if we had never read it. After all, the show must go on.
* goes ride his bicycle *
|
|
|
|
|
Oh, don't try so hard. With all these innuendos, I'm going slightly mad!
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Richard Deeming wrote: I'm going slightly mad!
Another one bites the dust. 
Jeremy Falcon
|
|
|
|
|
Is a philosopher leading a funeral procession putting Descartes before the hearse?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
tl;dr i kant bother
... such stuff as dreams are made on
|
|
|
|
|
Your socrates going up while previously it was plato.
|
|
|
|
|
Only if they are Jung at heart!
- I would love to change the world, but they won’t give me the source code.
|
|
|
|
|
It so sad - hopefully, no one Voltaire their hair out in mourning, having read start of the thread. I Marx my words: you just Kant go on like this.
Fortunately, the day is Jung, so we can get over it.
| Ravings en masse^ |
|---|
| "The difference between genius and stupidity is that genius has its limits." - Albert Einstein | | "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
