1
00:00:00,600 --> 00:00:04,570
Hi there, congrats on all the hard
work you've put in so far.

2
00:00:04,570 --> 00:00:08,880
In this unit, you will complete
a grocery inventory project.

3
00:00:08,880 --> 00:00:12,135
You will need to download
the project files and

4
00:00:12,135 --> 00:00:14,563
open them in an IDE of your choice.

5
00:00:14,563 --> 00:00:18,069
Professor T,
can you show us what this looks like?

6
00:00:18,069 --> 00:00:19,242
>> Sure thing, Megan.

7
00:00:19,242 --> 00:00:22,950
I have opened the files
in Visuo Studio code.

8
00:00:22,950 --> 00:00:24,980
You can see there are two CSV files.

9
00:00:26,220 --> 00:00:31,200
One contains a list of brands,
the other a list of items.

10
00:00:31,200 --> 00:00:35,742
You will write a program using Python and
SQLAlchemy to load in this data and

11
00:00:35,742 --> 00:00:37,700
create a relational database.

12
00:00:39,040 --> 00:00:43,740
You will also create a console application
that allows users to view details of

13
00:00:43,740 --> 00:00:48,295
a single product, add products to
the database, view some analytics, and

14
00:00:48,295 --> 00:00:51,360
make a backup file of the database.

15
00:00:51,360 --> 00:00:54,710
My superstar friend Mel
has solved this challenge.

16
00:00:54,710 --> 00:01:00,524
Let's take a look at what a meets
expectations project looks like,

17
00:01:00,524 --> 00:01:08,450
python app.py n, for new product.

18
00:01:08,450 --> 00:01:09,415
Then enter a name.

19
00:01:12,816 --> 00:01:15,094
Make sure you enter a numerical value.

20
00:01:18,593 --> 00:01:24,443
Enter a number for the brand.

21
00:01:24,443 --> 00:01:26,186
v for view a product.

22
00:01:28,471 --> 00:01:30,662
Enter the product ID number.

23
00:01:36,985 --> 00:01:39,121
A, to analyze the database.

24
00:01:42,400 --> 00:01:46,647
Most expensive product,
least expensive product.

25
00:01:48,914 --> 00:01:52,399
Most common brand.

26
00:01:52,399 --> 00:01:54,205
b, to backup the database.

27
00:01:56,720 --> 00:01:58,302
And here's the new item.

28
00:02:16,116 --> 00:02:19,096
Q, to quit the app.

29
00:02:19,096 --> 00:02:24,757
Now let's take a look at
the exceeds project, python app.py.

30
00:02:30,396 --> 00:02:32,689
N, for new product, then enter a name.

31
00:02:36,833 --> 00:02:39,564
Again, make sure you
enter numerical values.

32
00:02:50,522 --> 00:02:53,708
V, for view a product.

33
00:02:53,708 --> 00:02:55,601
Enter the product ID number.

34
00:02:59,705 --> 00:03:02,582
Now, I can edit or delete the product

35
00:03:06,418 --> 00:03:09,332
New price, new quantity for

36
00:03:09,332 --> 00:03:17,435
Chips Let's view the same product
again to see the updates.

37
00:03:27,192 --> 00:03:28,552
View another product.

38
00:03:31,207 --> 00:03:32,790
5 is for Radish.

39
00:03:35,895 --> 00:03:37,920
Let's get rid of those Radishes.

40
00:03:48,162 --> 00:03:50,012
Check for item 5 again.

41
00:03:52,384 --> 00:03:54,087
There is no ID number 5.

42
00:03:55,977 --> 00:03:57,702
Let's get back to the main menu.

43
00:04:00,231 --> 00:04:02,266
A, to analyze the database.

44
00:04:06,179 --> 00:04:08,923
Most expensive product,

45
00:04:08,923 --> 00:04:13,920
least expensive product,
most common brand.

46
00:04:13,920 --> 00:04:16,860
Also, the least common brand.

47
00:04:16,860 --> 00:04:22,093
And finally,
the average price of all products.

48
00:04:22,093 --> 00:04:24,227
b, to backup the database.

49
00:04:42,439 --> 00:04:44,734
Q, to quit.

50
00:04:44,734 --> 00:04:48,576
Thanks again Mel, back to you Megan.

51
00:04:48,576 --> 00:04:53,541
>> Reach out if you have any questions or
need any help throughout this unit.

52
00:04:53,541 --> 00:04:54,800
I know you've got this