Team, Anthony, thanks so much for the help.
Anthony, I believe, I've mentioned this before, in previous questions about
the other apps. You've helped me a lot and I appreciate very much. The
current issue is that, I am developing a system of q&a with the aim of
storing the questions for future machine learning purposes. That once a
user inputs a query, the question is stored in post (in storage.sqlite),
but at the same time, that question will be processed by other functions
and a reply send back to the user I want to retrieve that question to the
controller or modules for processing.
This is the controller code:
@mobilize
@auth.requires_login()
def view_searches():
if db(db.post).isempty():
"""If the db is completely deleted then we get an error as the
iteration is over an empty table."""
db.post.insert(message="Well_hest")# well_hest is an internal
keyword/trigger word
dt=request.now
row = db(db.post.author== auth.user.id).select(db.post.ALL,
orderby=~db.post.created_on, limitby=(0,1)).first()
reports = row.message if row else None
return dict(reports=reports)
@mobilize
@auth.requires_login()
def search():
form = SQLFORM(db.post).process()
if form.accepts(request, formname=None):
return DIV("Message posted")
elif form.errors:
return TABLE(*[TR(k, v) for k, v in form.errors.items()])
return dict()
This is the html view:
{{extend "layout.html"}}
<!DOCTYPE html>
<html lang="en">
<head>
<title>convForm - example</title>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1,
maximum-scale=1, minimum-scale=1">
<link href="https://fonts.googleapis.com/css?family=Roboto";
rel="stylesheet">
<link href="{{=URL('static', 'css/jquery.convform.css')}}"
rel="stylesheet" type="text/css" />
<link rel="stylesheet" href="
https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css";
integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u"
crossorigin="anonymous">
<link href="{{=URL('static', 'css/demo.css')}}" rel="stylesheet"
type="text/css" />
</head>
<body>
<section id="demo">
<div id="target"></div>
<div class="vertical-align">
<div class="container">
<div class="row">
<div class="col-sm-6 col-sm-offset-3 col-xs-offset-0">
<div class="card no-border">
<div id="chat" class="conv-form-wrapper">
<form action="#"
enctype="multipart/form-data" method="post" id="myform" class="hidden">
<select data-conv-question="Hello! I'm
a bot created from a HTML form. Can I show you some features? (this
question comes from a select)">
<option value="yes">Yes</option>
<option value="sure">Sure!</option>
</select>
<input type="text" name="message"
id="message" data-conv-question="Alright! First, tell me your full name,
please.|Okay! Please, tell me your name first.">
<input type="text"
data-conv-question="{{=reports}}" data-no-answer="true">
</form>
</div>
</div>
</div>
</div>
</div>
</div>
</section>
<script type="text/javascript" src="jquery-1.12.3.min.js"></script>
<script src="{{=URL('static','js/jquery-1.12.3.min.js')}}"
type="text/javascript"></script>
<script src="{{=URL('static','js/autosize.min.js')}}"
type="text/javascript"></script>
<script src="{{=URL('static','js/jquery.convform.js')}}"
type="text/javascript"></script>
<script>
var rollbackTo = false;
var originalState = false;
function storeState(stateWrapper) {
rollbackTo = stateWrapper.current;
console.log("storeState called: ",rollbackTo);
}
function rollback(stateWrapper) {
console.log("rollback called: ", rollbackTo, originalState);
console.log("answers at the time of user input: ",
stateWrapper.answers);
if(rollbackTo!=false) {
if(originalState==false) {
originalState = stateWrapper.current.next;
console.log('stored original state');
}
stateWrapper.current.next = rollbackTo;
console.log('changed current.next to rollbackTo');
}
}
function restore(stateWrapper) {
if(originalState != false) {
stateWrapper.current.next = originalState;
console.log('changed current.next to originalState');
}
}
jQuery('#myform').submit(function() {
ajax('{{=URL('search')}}', '#myform', 'target');
return false;
});
</script>
</body>
</html>
With the code above, see the images attached.
You'll note that if I post a query like: 'testing 123' it will be posted to
the post table as shown in the image. But retrieving it back to the
controller, just for the purpose of retrieving what is posted, I get
'maurice' which is a previous post instead.
This is my biggest headache. That is why i tried getting a way to refresh
the Db, or using request.now (thinking that it will get the response with
current time)
On Thu, Jul 19, 2018 at 5:30 AM Anthony <abasta...@gmail.com> wrote:
> On Wednesday, July 18, 2018 at 1:08:24 AM UTC-4, Maurice Waka wrote:
>>
>> I have two problems;
>>
>> 1. When I successfully submit a form and try to retrieve the text for
>> processing in the controller, I tend to get the previously submitted text
>> and not the latest.
>>
>> What do you mean by this? What is the exact workflow, and what does your
> code look like? When a form is submitted, the controller action that
> handles the submission has access to the current submission (not the
> previous one).
>
>
>> def retrieve():
>> dt=request.now
>> row = db(db.post.author== auth.user.id).select(db.post.ALL, orderby=~
>> db.post.created_on == dt, limitby=(0,1)).first()
>>
>
> The above is not a valid "orderby" -- it must just be a field, not a
> query. There is no need for matching anything on request.now, and any
> inserts made during the current request would not match request.now
> exactly, as request.now is calculated before any of your app code runs (and
> therefore before any inserts can happen). Just order by created_on
> (descending) and take the first record. Anyway, this may not be what you
> really want -- if you're trying to get a given record right after it was
> inserted, this approach could lead to a race condition, as another record
> could be inserted before you do the read.
>
> Anthony
>
> --
> Resources:
> - http://web2py.com
> - http://web2py.com/book (Documentation)
> - http://github.com/web2py/web2py (Source code)
> - https://code.google.com/p/web2py/issues/list (Report Issues)
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "web2py-users" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/web2py/nvgzq49Z9kA/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
