Hi !
I have a block of code similar to this I made to test:
def TEST():
teste = Test(descricao=str('wololo'))
try:
db.session.add(wololo)
db.session.commit()
db.session.close()
except IntegrityError, e:
db.session.rollback()
db.session.close()
print e.message
sql = db.session.execute('select * from public.test_id_seq;')
result = sql.fetchall()
print Sequence select:
print result[0][0]
print result[0][1]
TEST()
My model is:
class Test(db.Model):
id = db.Column(db.BigInteger, db.Sequence('test_id_seq',
metadata=db.metadata), primary_key = True)
description = db.Column(db.String(50), unique=True, nullable=False)
def __init__(self, description):
self.description = description
I dont receive any error BUUUTT my sequence increases even in a case
except. My database is PostgreeSQL 9.3.5 and configuration is:
SQLALCHEMY_DATABASE_URI = 'postgresql://' + database_username + ':' + \
database_password + @ + database_address +: + database_port + / + \
database_name
I created the base of my project following the official documentation Flask
Flask-SQLAlchemy on http://flask.pocoo.org/docs/patterns/sqlalchemy/
I read many many many examples on google, but none helped me ... already
tried many things ... can anyone help me?
Thank you!
--
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.