Instructor: Hi guys and welcome back.
In this video we're going to look at an overview
of the project we'll be building in this first section.
The project is a programming journal
that uses SQLite as a database.
In this journal we're going to be able to add new entries
or view existing entries to keep track
of our programming learning.
When users first run our app they're going to see
any prompt like this one.
A quick welcome at the top and then the three options
that they've got in the menu.
One to add new entries, two to view entries,
or three to exit.
And finally they can enter their selection at the bottom.
To add new entries, the user is first gonna press one
to enter that option in the menu.
And then we'll ask them for the date and contents
of the entry.
These are gonna be two separate prompts.
So the contents are gonna go in one prompt,
one input call, and the date is gonna go
in another prompt.
Something like this.
So the what you have learned today is a prompt.
The user will type behind that and will tell
us what they've learned today.
And then we'll ask them for the date.
And we're going to store both of those things
in our database.
If the user presses two in the menu
instead of one, then we're gonna show them their entries.
And for each entry we'll show the date
and the content of the entry.
Something like this.
So here you can see that on the first of January
the user learned how to start coding with Python and SQL.
And then on the second of January
they worked with some more SQL, and so on.
Of course notice that the dates here
could mean different things in the United Kingdom
and the United States, for example.
But we're not going to worry about dates
and date formatting and things like that
in this application.
We'll look at that later on
when we learn more about working with dates in SQL.
Finally after the user makes a selection
we preform the appropriate action,
be that to add an entry or to view the entries.
They can choose another.
And we will continually ask them to choose
another option until they decide to exit the application
by entering three.
So here's the complete flow of our application.
Let's say that the user starts by adding a new entry.
They enter one down there at the bottom.
Then we ask them what they've learned today
and they enter the date.
And then we ask them again to select another option
and this time they enter two.
We will then print out the date and the contents
and then we'll ask them again for another option
in the menu and this time they decide to enter three
and the application terminates.
All right, let's get coding.
Let's implement this project throughout this section.
I'll see you in the next video.