step by step help retrieve and shuffle. example..
Hello, I received this help a while back, I'm finally finished with my database and created new database service, its all I have done.. I really need help with step by step in order to figure it out, I realize there's a lot of solutions and choices when programming and that's what make it's a little off. But this topic is all about getting it to work on a page in a custom way that I will explain:
I'm not sure how this will effect each step but I want to ask 8 questions at a time, which makes 1 set.
, then user will be sent home. I'm going to time each question at 23 seconds, then it will go to the next question till they are answered and then return the user to home page. can you help me with this please. It's really hard for me to figure this out.
In the instructions I was given below, I have 1. finished.
I have import the database service but that's it, I do not know if I'm ready to?
my database with questions and answers also has a column, number, 1-184, so there are 184 questions answers like I mentioned. can you help me, being new it's a nightmare, I want you to know I have been and am always trying to figure it out with documentation and videos. I learn and get lost at the same time, please help me resolve this, please, lol...MAYBE IF I CAN JUST FIGURE OUT HOW TO DO 2 THROUGH 3.2 I'LL LEARN A WHOLE LOT, I've learned a little so far, and it makes things easier, but I need to learn more, I'm stuck on this..
Thank You.
So think about it, you hit a component, you try to answer one question at a time, you have 23 seconds, till the next question shows, if you answer it, you go to the next question, if you don't when 23 seconds are up it goes to the next question until all 8 are done then your sent back home, How do I configure the setting required below for this. It may not be necessary to know all this I dont know, I'm just trying to get through this, for starts making sure any settings in 2. is configured correctly, or if 2. is something that okay for now and I can go to 3 and try to get that step done. Please help me with one step at a time..
So, here is more to learn
To store
It's better to store data in database as follows:
one column - question (String)
second column - answers (Array) http://docs.appery.io/documentation/b...The structure of answer cell:
[{"answer": "Answer one", "correct": true}, {"answer": "Answer two", "correct": false}, {"answer": "Answer Tree", "correct": false}]
In case you would like to add additional answers or more than one correct answer, hints, just transfer the cell to:
[{"answer": "Answer one", "correct": true}, {"answer": "Answer two", "correct": false}, {"answer": "Answer Tree", "correct": false}, {"answer": "Answer four", "correct": true}]
How to retrieve and shuffle
To retrieve the column with answers import Database Service http://docs.appery.io/documentation/b... for this Database (for example Read Service).
To modify your service response you need to use Generic security context and use it with your service.
3.1 Create custom Security context service. Here is how to do this http://docs.appery.io/documentation/g...
3.2 Use next code to wrap answer and make custome logic (Shuffling with JavaScript).
Appery.MySecurityGeneric = Appery.createClass(SecurityContext, {
invoke: function(service, settings) {
var oldSuccess = settings.success;
var onSuccess = function(value, other){
//here you need to use JavaScript shuffle function:
//To see what stored in the value variable please use following code:
console.log("value = ");
console.log(value);
oldSuccess.call(this, value, other);
};
settings.success = onSuccess;
Appery.MySecurityGeneric.$super.invoke.call(this, service, settings);
}
});Note: You should replace "MySecurityGeneric" with your Security generic context name.
After you create Generic security context please use this context in your service.