You are a super teacher. I wish we could teach students in the University in such granularity and functionality. There is no point dumping boring theories onto students' brain about www, HTTP, etc. Tutorials like this puts everything into context. Well done and thank you so much for making and sharing these contents.
what a tutorial, started from zero, by the end got almost everything, on my way of building personal projects with obtained skills and knowledge!!
For those facing issue related to the TypeError while appending the row in the result_dict at 2:56:00 can use result_dicts.append(row._mapping), i was also facing this issue wasted around 2 Hrs to figure it out!
For those experiencing some issues around 3:29, this worked for me def load_job_from_db(id): with engine.connect() as conn: result = conn.execute( text(f"SELECT * FROM jobs WHERE id={id}") ) rows = [] for row in result.all(): rows.append(row._mapping) if len(rows) == 0: return None else: return row
Man, I am from Brazil. I have just seen 43 min until now, but I would like to send this text: This is the best, simple Flask I have seen!! Thank you for your time!!
Aakash has been a very big blessing to my career. I had an interview and somehow passing Algorithms through code challenges was difficult. But the moment i lay hold of Aakash tutorial on Data structures and algorithms. After going through the course this time i went into the test and came out successful. Thank you Co-founder of Jovian Aakash
If you're stuck at 2:56:09 this worked fine for me: with engine.connect() as conn: result = conn.execute(text("select * from jobs")) result_dicts = [] for row in result.all(): result_dicts.append(dict(row._mapping)) print(result_dicts)
If you don't get proper dictionary @3:26:50 here is the function that worked for me: def load_job_from_db(id): with engine.connect() as conn: result = conn.execute(text("SELECT * FROM jobs WHERE id = :val"),{'val': id}) row = result.fetchone() return row._asdict()
4:21:16 if anyone's facing issues where the data is not being inserted into the database, even though there's no errors in your code, then write conn.commit() after the conn.execute() command.
I gained more knowledge from you than I did from my entire college web development course. Thank you, sir.
This is gold! The flow was absolutely flawless and understood without having to rewind and watch. Great stuff! ๐
This was absolutely amazing, built a fully packaged website with dynamic data and email linked, basically everything
Wow... I am from Nigeria, and I must say this tutorial is verrrry rich and I am super grateful to the organizers๐๐.
First, I'd like to say this is one of the most fluid and well explained coruses i've ever taken
Thank you Aakash and freeCodeCamp for taking the time to create and share this video it was a great walk through for flask and mysql in the cloud!!
at 2:55:20 if you are stuck with dict( ) conversion, try using ._asdict() method Apparently it will be like first_result_dict = result_all[0]._asdict()
If you had trouble converting to dict at around 2h:54m, apparently Legacy.Row is out of date. This worked for me: with engine.connect() as conn: result = conn.execute(text("select * from jobs")) result_all = result.all() first_result = result_all[0] column_names = result.keys() first_result_dict = dict(zip(column_names, first_result)) print(first_result_dict)
sir, you are the best. Just started with web development and i literally understood everything without any problem. thank you very much
The course is really cool. the best tutorial for flask for beginners
@jovianhq