Python keeps inserting NULL values into table

[ndc85430]

Really? Named parameters are written as %(name)s and there are examples here (see the paragraph starting "Named arguments").

[card51shor]

db.execute("INSERT INTO users (username, password) VALUES (%s, %s)", ("username", "password",))

I tried this and i'm getting this error:

AttributeError: 'tuple' object has no attribute 'keys'

[ndc85430]

Urgh, I've just realised you're using SQLAlchemy - you might need to check their docs too. I don't know if it does something different to the query parameters over what Psycopg2 does. Is there a reason you're using both SQLAlchemy and Psycopg? I'd think you just want to use one or the other; using both is just going to cause you and others confusion I imagine.

[card51shor]

I've changed my code so much i don't know what I"m doing anymore. I've been seeking help for over a month now. No one can help me get it to work - i don't get it.

It should be as simple as "this is wrong - this is how u fix it".

no one can explain it to me yet.

doesn't matter what I use - I just need it to work. I'd like to use SQLAlchemy

[buran]

Make sure that what you get from request.form.get('username') is indeed the user input. You were printing username and password. What you get printed? That will show that the problem is in the DB part. Given it insert NULL, I guess for whatever reason request.form.get('username') might be returning None, in which case it's not DB related issue at all

[card51shor]

yes it is printing out "none". That's the issue. I can't figure out why..

[buran]

So, forget about the DB - it's not DB related, but Flask/form handling
What you get if you print(request.form) when request.method is POST?

[card51shor]

https://www.picpasteplus.com/v.php?i=786e902f35

This is what is shows. Why does it say t_password?

---

i figured it out i was using the wrong html!

[buran]

i figured it out i was using the wrong html!

yeah, that's it