php - What's the best way to implement a "soft" save or modification workflow? -


I'm working on an MVC based web app on LAMP, which records only a "better" user (normal user Changes can be made but they apply only after this approval)

There is only one table in which this must be, say "Events":

Events - ID - Name VARCHAR - start_date DATETIME - Guest INTEGER

Each time one of the features of an event is modified by the "normal" user It is, these changes are not made official until a modification (and is not possible) from this "super" user. First of all I have one of the following options:

  • In addition to the ID, duplicate each column, the name "name" is called name_temp for pending approval modification to catch.
  • Create a separate table with duplicate structure and keep all pending approval modifications.

Have you applied it before? What is the best way to do you? Even more: Is there a pattern of such a problem?

thanks !!!

PD: I need to keep the "old" record as long as the new is approved, it was ..

Let me add my vote to another table" approach - as both other respondents said, "proposed changes" in the master table (which means its schema, every query on it, etc. , Etc.) above all the heads and shoulders.

All the desired circumstances in the assistant table Typing and processing them (if they look at certain conditions, apply them to the master table) is actually a common pattern later, when you need a master table, then only to change in some time, the proposed change Any time can come, and in other situations, eg when written on master table, it is very expensive (lock dispute or whatever), but write an change Is not more expensive than food, or the proposed change is valid, it takes a lot of time (you can classify your use case as an extreme case, the latter category, because in your case the person will see the proposed change Required - computer is very slow with standards - -).


Comments

Post a Comment

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

I'm having trouble overriding a ModelForm save method. I get this error I'm: Exception type: TypeErier Exception Value: Save () found an unexpected keyword argument 'committed' My intentions include a form 3 fields Submit several values ​​for, then create an object for each combination of those areas, and to save each object file models.py class collarsult type (models.Model): id = model. AutoField (db_column = 'icontact_result_code_type_id', primary_key = true) callResult = models.ForeignKey ( 'CallResult', db_column = 'icontact_result_code_id') campaign = models.ForeignKey ( 'campaign', db_column = 'icampaign_id') CALLTYPE = models.ForeignKey ( 'CALLTYPE', db_column = 'icall_type_id') agent = models.BooleanField (db_column = 'bagent', default = true) teamLeader = models.BooleanField (db_column = 'bTeamLeader', default = true) active = models.BooleanField (db_column = Django.form...
Read more

html - CSS autoheight, but fit content to height of div -

I have a div in which there are three children- div in the left and middle div: float: left while true: float: true because it is my layout Actually will spoil, I've used ClearFix Hack: .cf {zoom: 1; }. Cf: First,. Cf: {content: ""; Display: Table; }. Cf: After {clear: both; } It still works, but I want to be the right div an indicator. So it should fill 100% of the parent unit of height. How can I complete this? PS is the full code: & Lt; / Div & gt; & Lt; Div class = "mobile_content" & gt; & Lt; H5 & gt; {{Data.titel}} & lt; / H5> & Lt; Table & gt; & Lt; TR & gt; & Lt; Th & gt; Komponist: & lt; / Th & gt; & Lt; TD & gt; {{Data.komponist}} & lt; / TD & gt; & Lt; / TR & gt; & Lt; TR & gt; & Lt; Th & gt; Instrument: & lt; / Th & gt; & Lt; TD & gt; {{Data.instrumente}} & lt; / TD & gt; & Lt; / TR & gt;...
Read more

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -

I have been trying to use Qt5 multimedia to record audio with QAudioInput, however, when I see If QAudioInput is started, it increases the master volume of my sound device to 100%. How can I prevent QAudioInput from changing the master volume? My current development platform is Linux with PalsAdio (with flat audio disabled). How can I use QAudioInput : QAudioDeviceInfo device_info = QAudioDeviceInfo :: defaultInputDevice (); QAudio format format; Format.setSampleRate (44100); Format.setChannelCount (1); Format.setSampleSize (16); Format.setCodec ("Audio / PCM"); Format.setSampleType (QAudioFormat :: SignedInt); Format.setByteOrder (QAudioFormat :: LittleEndian); Std :: cout & lt; & Lt; Device_info.deviceName (). ToUtf8 (). ConstData () & lt; & Lt; Std :: endl; QAudioInput * default_device = new QAudioInput (device_info, format); QIODevice * default_io_device = default_device-> Start (); a QAudioInput.setVolume () method is not you I ...
Read more