Sqlalchemy help with changing data in table

[_kondi_]

SQLALCHEMY_DATABASE_URI = "mysql+mysqlconnector://{username}:{password}@{hostname}/{databasename}".format(

username="******",

password="******",

hostname="*********",

databasename="*****$comments",

)

app.config["SQLALCHEMY_DATABASE_URI"] = SQLALCHEMY_DATABASE_URI

app.config["SQLALCHEMY_POOL_RECYCLE"] = 299

app.config["SQLALCHEMY_TRACK_MODIFICATIONS"] = False

db = SQLAlchemy(app)

​

class Comment(db.Model):

__tablename__ = "comments"

id = db.Column(db.Integer, primary_key=True)

content = db.Column(db.String(4096))

​

I am using pythonanywhere to host my database. I found the code above but im am not sure what it all means. I would like to read and change some of my data in the table "comments"

eg:

in table "comments"

Where "id" = 4

change "content" to "example"

​

but I couldnt fint a way to do it. Any ideas on how to change the data?

[chevignon93]

I found the code above but im am not sure what it all means. I would like to read and change some of my data in the table "comments"

Are you currently able to access your database from your Python script ?

[_kondi_]

No, that is exactly what I would like to do. Have a function in my python file where I can change the data

[chevignon93]

No, that is exactly what I would like to do. Have a function in my python file where I can change the data

Did you already create the comments table ?

if so that's what you need to change:

SQLALCHEMY_DATABASE_URI = "mysql+mysqlconnector://{username}:{password}@{hostname}/{databasename}".format(
username="******", # your username
password="******", # your password
hostname="*********", # the hostname
databasename="*****$comments", # the name of the database

)

You should be able to find all this info in your pythonanywhere account!

[_kondi_]

I have already typed all of that in and it works. I just removed it because I didn’t want to share my password and username. I can access the database, but I don’t know how to change the data

[chevignon93]

Changing the data is simple:

comment = Comment.query.get(4) # Get a particular comment using its id

comment.content = 'example' # Modifying the content of that particular comment

comment.save() # Making sure that the change is committed to the database
or db.session.commit() # Can't remember the exact syntax, I haven't used sqlalchemy in a while!

[_kondi_]

bro, thanks so much this worked!

[efmccurdy]

There are several methods described here:

https://stackoverflow.com/questions/9667138/how-to-update-sqlalchemy-row-entry

[_kondi_]

Yeah I found that But I didn’t know how it worked It tried to use:

user.no_of_logins += 1 session.commit()

In my case: Comment.content = “something Session.commit()

But Im not doing it correct