@jovianhq

We hope you enjoy this tutorial, and we look forward to seeing what you'll build! If you'd like to get your project reviewed by our team & earn a certificate, register here for free: https://jovian.com/learn/web-development-with-python-and-flask

If you have any questions or face issues, please post them in the comments and we'll help you out. Do check out our YouTube channel as well, where we're posting new tutorials every week. 

Thanks @freecodecamp and Beau for hosting us! ๐Ÿ™๐Ÿผ

@parrobo

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.

@ggggggg98767

what a tutorial, started from zero, by the end got almost everything, on my way of building personal projects with obtained skills and knowledge!!

@swastiksharma7637

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!

@banabasejiofor7470

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

@angelozandonafreitas6285

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!!

@apstnambativepeterintlmin

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

@jacktoneclarance5792

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)

@pukhrajkumawat7570

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()

@prakharpandey7745

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.

@tekghimire7078

I gained more knowledge from you than I did from my entire college web development course. Thank you, sir.

@SreevathsaBV

This is gold! The flow was absolutely flawless and understood without having to rewind and watch. Great stuff! ๐Ÿ‘Œ

@de-frag0121

This was absolutely amazing, built a fully packaged website with dynamic data and email linked, basically everything

@KingsleyNwosu-ts1mc

Wow...

I am from Nigeria, and I must say this tutorial is verrrry rich and I am super grateful to the organizers๐Ÿ˜๐Ÿ˜.

@johngodoy2929

First, I'd like to say this is one of the most fluid and well explained coruses i've ever taken

@Matty100

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!!

@chillaxbaap

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()

@caiozendron5024

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)

@Pier_Py

sir, you are the best. Just started with web development and i literally understood everything without any problem. thank you very much

@penujahansith2688

The course is really cool. the best tutorial for flask for beginners