Name: データベースの構築 - ディープラーニング、Python、TensorFlowでチャットボットを作る p.5 (Building Database - Creating a Chatbot with Deep Learning, Python, and TensorFlow p.5)
Uploaded: 2021-01-14T12:27:54.000Z
Duration: 18 min 57 s
Description: VoiceTubeの動画で発音を聞きながら英語表現を覚えよう！学べる英語：

to 不定詞

Welcome to part five of our chap, but with python in Tensorflow tutorial, Siri's in this tutorial.

現在進行形

What we're gonna be doing is hopefully actually putting things into our database.

So basically, where we left off was here, and we wrote our final bit of code was finding out whether or not the data was acceptable in the data.

Here, in this case, is going to be the body text.

Basically the text of the comment Should we even consider it?

So, um, initially, I've always actually put this right before all in searches, because that's like the order of operations in my head, but actually score a super cheap, so we might as well do that.

So if the score is greater than two, Sure.

But then what we're gonna do is I say, if acceptable, uh, body, then let's do these other operations.

I think that's a better way to do it rather than go through all of these operations and then ask, uh, toe, look for business.

Go through all of this only to find that the comment isn't acceptable.

Although most comments are probably more than acceptable, so I don't know, not really sure what the best way to go about it is to be honest.

It should be pretty cheap to do it anyway, So that's all right.

And really after business a at after the score is high enough.

We're gonna insert the question is, are we gonna insert this as a new row where we're gonna insert this azan update?

So no matter what we're gonna insert, no matter what that means, we're gonna ask this question.

So I suppose this could save us in theory, a little bit of process and living long.

Um, well, I guess in this case, it would like if this was not true.

So if the score is greater, then the score and the comment itself happens to be acceptable.

Well, if this is all the case, then we're gonna go ahead.

And, um, we would like to do a SQL insert.

And for now, I'm just gonna leave that there.

Um, I'm just gonna put this year so I could quickly find it.

Now, if there isn't an existing comment score, what we're gonna want to do is come down here and we're going to say else.

Um and we've already checked if it's acceptable, so then we're gonna ask if parent data, Um, so if there is a parent that we have data for, then what we want to do is SQL insert, uh, has parent and then and then otherwise else SQL insert no periods.

Okay, so that's what we were basically of these three different functions that we're gonna work with now.

Chances are they're probably better way to do it from, but that's what I'm gonna do.

So, um, so now we're gonna pass the information toothy.

So basically, if we're gonna be replacing something, that means we're gonna take comment.

I d We're probably gonna take the parent, uh, data because we got it the body.

Um, and then subreddit created you TC and then the score.

So that's if we do have, um, we have an existing comment already in place, and we're gonna update it because our new score is higher.

Now, if we do have that parent in our database so we have information on that, we want to go ahead and insert with that that information that we do have.

So in this case, it's gonna be again comment I d.

And in fact, trying to think, if that would be like it should be ever should be the exact same.

Data is here because we have all that information.

It's really only this one here with no parents, that we don't have anything that no parent body information to throw in.

So this one would be comment I d We do have a parent idea because everything has apparent idea.

If it's a top level comment on it has no parent comment.

The actual parent is the threat itself, though the reddit threat.

But we don't have parent data, but we do have body subreddit created you TC and sport.

So why would we insert these if we don't have a parent information to go with them?

Well, because this comment might still be some other comments parent that we want to get the data on.

So that's why we actually still want way still want to store that information?

So now what we have to do is actually build all three of these, um, inserts.

I guess we'll just build them all together.

Yeah, let's just, uh, just throw it down here.

Like I said, there's probably a better way to do this than create them like this, but I'm gonna go this way.

Um, we've got common I d We've got parent I d.

We've got parent comment, subreddit time and score.

And then again, in this case, let's say, um just in case we hit an issue, we'll try except exception as e.

On and then in this case will say print, replace comments, and then whatever e waas look, you know, if you have to string, you're not gonna go and pass that the I don't think we have any other ease just beside the stuff that we commented out I've been playing and go too much recently.

I can't remember if you have to throw a straight or not.

So we want to have that information there.

So now we're gonna say SQL equals and again, we'll just use reports here.

And then we're gonna say update updates a parent reply set.

If I really want to write all this out or if I just want to post it And then I think I'm just gonna copy and paste this.

I'm not sure what gain we're gonna have by writing out all these queries.

Um, I'm gonna copy impatient, so I'll put a link in the description to the text based versions tutorial for Forget someone, remind me.

But if even if I do forget, it'll be live on python programming detonate, so you should be able to find it.

I just don't see any benefit to writing all this out.

So anyway, here we have the three functions.

So basically, what's happening is in this case, uh, first I want to update this.

This should be, uh, yes, I don't know, update.

So basically, what this is gonna do is if, because it has, it's just gonna overwrite.

So what we want to do is we want to overwrite, um, all this information, basically, where the parent i d.

Was whatever that comments parent, I d was cause So basically, any time we've got that parent, I d any reply to that parent comment?

We want to make sure that's the new comment that has a better score on then.

Basically, what this one's doing is just Ah, we're just inserting where there was apparent I d or basically what we're saying.

We're inserting a new row right where we have the paranoid.

But we also happen to have the data for that parent.

So we're inserting information about that parent body basically, and then this one were inserting.

字幕リスト動画再生

データベースの構築 - ディープラーニング、Python、TensorFlowでチャットボットを作る p.5 (Building Database - Creating a Chatbot with Deep Learning, Python, and TensorFlow p.5)

stuff

entire

basically

exact