On Mon, Jun 22, 2015 at 8:44 PM, sudheesh ks <kssudheesh...@gmail.com> wrote:
> I have models:
>
> {
> class Post(db.Model):
> id = db.Column(db.Integer, primary_key = True)
> body = db.Column(db.String(2000))
> user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
> comments = db.relationship('Comment', backref='parent_post',
> lazy='dynamic')
>
>
> class Comment(db.Model):
> id = db.Column(db.Integer, primary_key = True)
> body = db.Column(db.String(140))
> post_id = db.Column(db.Integer, db.ForeignKey('post.id'))
> }
>
> When entering a post to database I do this:
>
> {
> if form.validate_on_submit():
> post = Post(body=form.post.data, author=g.user)
> db.session.add(post)
> db.session.commit()
> } This is working right.
>
> But how can I enter a comment to database if I want to pass the 'post.id'
> value directly
> instead of object 'post'. (Not able to 'pass' object via form in html)
>
> {
> if form.validate_on_submit():
> comment = Comment(body=form.post.data, parent_post=form.p_id.data)
> db.session.add(post)
> db.session.commit()
> }
>
> currenntly p_id holds value post.id and it gives me error:
> AttributeError: 'int' object has no attribute '_sa_instance_state'
> Please help
>
The columns that you set up on your Comment class (including the
post_id foreign key column) can be used directly.
ie.
Comment(body=form.post.data, post_id=form.p_id.data)
Hope that helps,
Simon
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
