Grocery Store Application - 3. Products Backend

Grocery Store Application - 3. Products Backend | Python project tutorial

Рет қаралды 81,797

3 жыл бұрын

In this python project tutorial for building grocery store application we will,
1) Build a backend code for products management
2) Write code to run SQL queries in python using mysql connector
Code: github.com/codebasics/python_...
Do you want to learn technology from me? Check codebasics.io/ for my affordable video courses.
Link for english playlist: • Python Project: Grocer...
Link for hindi playlist: • Python Projects Hindi:...
Prerequisites links:
python english tutorial: • Python 3 Programming T...
python hindi tutorial: • Hindi Python Programmi...
www.khanacademy.org/computing...
www.khanacademy.org/computing...
Discord: / discord
Instagram: / codebasicshub
Website: codebasics.io/
Facebook: / codebasicshub
Twitter: / codebasicshub
Linkedin: / codebasics
DISCLAIMER: All opinions expressed in this video are of my own and not that of my employers'.

Пікірлер: 94

@codebasics 2 жыл бұрын

Do you want to learn technology from me? Check codebasics.io/ for my affordable video courses.

@siddharthnahata757 3 жыл бұрын

Sir please a full project on Python Django along with deployment. Much needed sir

@CompSciCentral 3 жыл бұрын

Very good series! Thank you so much!

@codebasics 3 жыл бұрын

I am glad you liked it.

@nipunivithana7638 2 ай бұрын

Thank you so much..the way you teaching is easy to grab❤

@marcosoliveira1538 3 жыл бұрын

Learning a lot here. Thanks!

@codebasics 3 жыл бұрын

Glad it was helpful!

@lapisdecor 3 жыл бұрын

Should you also do cursor.close() and connection.close() ?

@bibin4049 2 жыл бұрын

Thank you very much sir.

@codebasics 2 жыл бұрын

Glad you enjoyed it

@swL1941 Жыл бұрын

Hey, I used the delete method to remove my added product. BUT if I add another product it will give the product_id one number ahead. Like if I deleted 12th product and if I add a new one, it wont be saved as 12th product. Instead, the 13th. Kindly help

@hemangipatel1695 3 жыл бұрын

Sir How do you run flask? Please help!

@adedipakdagadu6174 2 ай бұрын

Sir which software you are using for development

@muruganbala9217 3 жыл бұрын

Sir please make video tuto on FastAPI ....more companies are moving FastAPi instead of FLASK/Django

@codebasics 3 жыл бұрын

Thanks for the suggestion. I will try to cover this in my next project.

@deeptimishra1051 2 жыл бұрын

please tell are you using visual studio for writing python code in this video???

@user-px4hm4bf3r 5 ай бұрын

its pyCharm i think

@akshathnadig34 3 жыл бұрын

Well explained bro👏👏👏

@shreyasdeshpande7519 3 жыл бұрын

Sir plz share the data base as i want to learn it as a beginner.. I ain't finding it on github source code

@renukas7995 Жыл бұрын

cant i use any other IDE for python?

@FaizanKhan-yx3we 7 ай бұрын

Sir mysql is not connect plz help

@sharifimroz6231 3 жыл бұрын

would you like to upload or send the database please ?

@JonBraydenCodes 2 жыл бұрын

Can I have the comlete source code of this also the exercises mentioned should have the answer as well.

@tanvirv.0 8 ай бұрын

sir my inner join is not working

@vamsinadh100 3 жыл бұрын

we are close to 200k!

@praphulseth3393 3 жыл бұрын

6:39 can anyone explain , how do we do that??

@anishmathew7108 3 жыл бұрын

Sir Please add Django tutorial

@msampathvinaykumarreddy1399 3 жыл бұрын

Sir please try to use the White Theme for coding ...so that we can clearly see what is going ...

@vladivostok853 6 күн бұрын

musalodivi entra nuvvu

@vinodvyash3866 2 ай бұрын

7:47 uom_name will not be showing (kg/each) please help

@komalchanni4692 6 ай бұрын

Hello Sir, if i need a help in python assignment, where to contact u.

@arnabdeb1486 8 ай бұрын

The cabbage function isn't working please help

@pradeepreddy1363 3 жыл бұрын

Sir do projects on django

@saurabh.kulkarni336 3 жыл бұрын

Sir, I am mechanical engineer..10 yrs experience in mech field..can I still change my career to data science or is it late now? I am 33

@WeakCoder 3 жыл бұрын

it's never too late bro!

@saurabh.kulkarni336 3 жыл бұрын

@@WeakCoder thanks..

@anuragjain5921 2 жыл бұрын

Which IDE is used?

@ChizkiyahuOhayon Жыл бұрын

pycharm (community version is ok)

@g.b.vsowjanya3598 4 ай бұрын

Error 1064 Can any solve this error

@yashpawar4336 Жыл бұрын

Which code editor is used ?

@ChizkiyahuOhayon Жыл бұрын

pycharm (community version is ok)

@anu5936 5 ай бұрын

In community version I can't install SQL connector, pls help

@rebeld7229 3 жыл бұрын

Sir where is database

@akshayavhad5996 3 жыл бұрын

ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'inner join uom on product.uom_id=uom.uom_id' at line 1 i am getting this error i have try to solve it but i culd'nt be able to solve

@meqdaddev4341 3 жыл бұрын

Just google it, how to write a multiline statement in python. And arrange your query string as that.

@melodylyricskannada 3 жыл бұрын

@@meqdaddev4341 even i tried but couldn't..can you suggest us bit more

@vigneshselvam8597 3 жыл бұрын

Yeah same here bro, what can i do for that now. Do u cleared that error pls tell me what to do for that

@aniketvyas1166 3 жыл бұрын

@@vigneshselvam8597 just add "\" where the line breaks will work

@sanketkhandagale1926 2 жыл бұрын

i have the same error. Did you get its solution?

@suhasdev9279 Жыл бұрын

What is the IDE used? Can anyone reply

@ChizkiyahuOhayon Жыл бұрын

pycharm (community version is ok)

@sharedaccount715 3 жыл бұрын

Thanks for your amazing explanation. When i created modular approach program with SQL connection in separate file.I am getting below error AttributeError: 'NoneType' object has no attribute 'cursor'. Could anyone please help me out to solve this error.

@manishsingh-ch2nm Жыл бұрын

I guess, you forgot to return __cnx in get_sql_connection() function

@halasyamv3190 Жыл бұрын

@@manishsingh-ch2nm i am getting the same error but did pass return

@sumitrawat4103 3 жыл бұрын

AttributeError: 'function' object has no attribute 'cursor' why it is showing this error??

@abhiruphazra4444 3 жыл бұрын

double click on your database then run the queries

@begnazaraxmadjonov4501 2 жыл бұрын

hey did you solve this issuee

@swL1941 Жыл бұрын

@@begnazaraxmadjonov4501 did you get it ?

@amaurysrodriguez1073 2 жыл бұрын

I am not getting any value from this function: def insert_new_product(connection, product): cursor = connection.cursor() query = ( "INSERT INTO Products" "(name, uom_id, price_per_unit)" "VALUES (%s, %s, %s)" ) data = (product['name'], product['uom_id'], product['price_per_unit']) cursor.execute = (query, data) connection.commit() if __name__ == '__main__': connection = get_sql_connection() print(get_all_products(connection)) # this is to see all of your products print(insert_new_product(connection, { 'name': 'Cabbage', 'uom_id': '2', 'price_per_unit': '10' })) the def insert_new_product is returning None for me and I don't know why is this happening.

@coelhohustle 3 жыл бұрын

hello sir this following command did not fetch me the kg/each SELECT products.product_id, products.name, products.uom_id, products.price_per_unit, uom.uom_name FROM products inner join uom on products.uom_id=uom.uom_id; please help

@coelhohustle 3 жыл бұрын

error 1046, no database selected

@dhaneshjadhav9125 3 жыл бұрын

Have you solve this error

@dhaneshjadhav9125 3 жыл бұрын

I also have same problem

@aniketvyas1166 3 жыл бұрын

@@dhaneshjadhav9125 just add "\" where the line breaks will work

@PatilShubhamm 2 жыл бұрын

I also get error

@zaidazim6128 3 жыл бұрын

My products_dao.py file is not printing the data from the products table when I run on visual studio code. Kindly help !!

@NH-gl8do 3 жыл бұрын

use pycharm and install the package mysql-connector, it will work I guess

@zaidazim6128 3 жыл бұрын

@@NH-gl8do I ran it using Pycharm, there is still no output. I do not understand the problem. Tried command prompt, vs code and now Pycharm

@A__KathiravanACSE 2 жыл бұрын

I need to contact you sir... Can you please... Do any possible favour to contact you... Need some clarifications...

@adityasahay2412 9 ай бұрын

not explained that well

@avinashnair5064 3 жыл бұрын

sir github is page is not avalable

@codebasics 3 жыл бұрын

Sorry it was private. I just made it public. Try now.

@avinashnair5064 3 жыл бұрын

@@codebasics thankyou so much sir

@erickjudevillero4115 5 ай бұрын

error 1046 on 6:37

@krunalpadade3465 3 жыл бұрын

can you make this videos every day

@LUKFUNTV 3 жыл бұрын

No he can't That's too much We also have rest/leisure days. Right?? Weekly regular videos will be good

@Swastika_Aryan_114 12 күн бұрын

Bhai tumhara ek bhi project dhang ka nahi ha. Kuch na kuch error aa hii jata hai. Or Tum solve bhi nahi krwate

@pleadianalcyon5392 12 күн бұрын

Too much talking on broken English😢😢

@uncomplicated8293 9 күн бұрын

Please talk properly don't use that slang it's very irritating

@saisuhasvaddeman2503 9 ай бұрын

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'inner join uom on products.uom_id=uom.uom_id' at line 1 I'm using vs code and my syntax is written correctly sir Please look after this.

@srinivasan.s1082 6 ай бұрын

Same

@pallvisalwan4219 Ай бұрын

@@srinivasan.s1082 same here