Hello guys,
I am learning Flask, I new started sqlalchemy with flask, so very easy is
both.
I am working with wtforms flask extension and sqlalchemy for flask
extension.
My Application and database initalize,
app = Flask(__name__)
# app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:////:memory:'
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:////test.db'
db = SQLAlchemy(app)
And my sqlalchemy User table,
class User(db.Model):
id = db.Column(db.Integer, primary_key=True)
mail = db.Column(db.String(120), unique=True)
psw = db.Column(db.String(26), unique=True)
def __init__(self,mail,psw):
self.mail = mail
self.psw = psw
def __repr__(self):
return '<User %r - %r>'%(self.mail, self.psw)
After I am calling *db.create_all()* func.
For example my simple register page,
@app.route('/reg')
def register():
formUser = userReg(request.form)
if request.method == "POST" and formUser.validate():
session['userEnabled'] = 1 #php style :)/>/>
session['mail'] = formUser.mail.data
session['psw'] = formUser.psw.data
uyeObj = Kullanici("%s"%formUser.mail.data,"%s"%formUser.psw.
data)
db.session.add(uyeObj)
db.session.commit()
return redirect('/profile')
return render_template('register.html', form=formUser)
I must this code checking, and as test, I am calling this function
*User.query.all()*
Here is error result
Traceback (most recent call last):
File "C:\Users\user\Desktop\Flask\test\test.py", line 130, in <module>
xx = User.query.all()
File
"C:\Python27\lib\site-packages\sqlalchemy-0.9.6-py2.7-win32.egg\sqlalchemy\orm\query.py"
, line 2293, in all
return list(self)
File
"C:\Python27\lib\site-packages\sqlalchemy-0.9.6-py2.7-win32.egg\sqlalchemy\orm\query.py"
, line 2405, in __iter__
return self._execute_and_instances(context)
File
"C:\Python27\lib\site-packages\sqlalchemy-0.9.6-py2.7-win32.egg\sqlalchemy\orm\query.py"
, line 2418, in _execute_and_instances
close_with_result=True)
File
"C:\Python27\lib\site-packages\sqlalchemy-0.9.6-py2.7-win32.egg\sqlalchemy\orm\query.py"
, line 2409, in _connection_from_session
**kw)
File
"C:\Python27\lib\site-packages\sqlalchemy-0.9.6-py2.7-win32.egg\sqlalchemy\orm\session.py"
, line 846, in connection
close_with_result=close_with_result)
File
"C:\Python27\lib\site-packages\sqlalchemy-0.9.6-py2.7-win32.egg\sqlalchemy\orm\session.py"
, line 850, in _connection_for_bind
return self.transaction._connection_for_bind(engine)
File
"C:\Python27\lib\site-packages\sqlalchemy-0.9.6-py2.7-win32.egg\sqlalchemy\orm\session.py"
, line 315, in _connection_for_bind
conn = bind.contextual_connect()
File
"C:\Python27\lib\site-packages\sqlalchemy-0.9.6-py2.7-win32.egg\sqlalchemy\engine\base.py"
, line 1737, in contextual_connect
self.pool.connect(),
File
"C:\Python27\lib\site-packages\sqlalchemy-0.9.6-py2.7-win32.egg\sqlalchemy\pool.py"
, line 332, in connect
return _ConnectionFairy._checkout(self)
File
"C:\Python27\lib\site-packages\sqlalchemy-0.9.6-py2.7-win32.egg\sqlalchemy\pool.py"
, line 630, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File
"C:\Python27\lib\site-packages\sqlalchemy-0.9.6-py2.7-win32.egg\sqlalchemy\pool.py"
, line 433, in checkout
rec = pool._do_get()
File
"C:\Python27\lib\site-packages\sqlalchemy-0.9.6-py2.7-win32.egg\sqlalchemy\pool.py"
, line 1042, in _do_get
return self._create_connection()
File
"C:\Python27\lib\site-packages\sqlalchemy-0.9.6-py2.7-win32.egg\sqlalchemy\pool.py"
, line 278, in _create_connection
return _ConnectionRecord(self)
File
"C:\Python27\lib\site-packages\sqlalchemy-0.9.6-py2.7-win32.egg\sqlalchemy\pool.py"
, line 404, in __init__
self.connection = self.__connect()
File
"C:\Python27\lib\site-packages\sqlalchemy-0.9.6-py2.7-win32.egg\sqlalchemy\pool.py"
, line 530, in __connect
connection = self.__pool._creator()
File
"C:\Python27\lib\site-packages\sqlalchemy-0.9.6-py2.7-win32.egg\sqlalchemy\engine\strategies.py"
, line 95, in connect
connection_invalidated=invalidated
File
"C:\Python27\lib\site-packages\sqlalchemy-0.9.6-py2.7-win32.egg\sqlalchemy\util\compat.py"
, line 189, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File
"C:\Python27\lib\site-packages\sqlalchemy-0.9.6-py2.7-win32.egg\sqlalchemy\engine\strategies.py"
, line 89, in connect
return dialect.connect(*cargs, **cparams)
File
"C:\Python27\lib\site-packages\sqlalchemy-0.9.6-py2.7-win32.egg\sqlalchemy\engine\default.py"
, line 376, in connect
return self.dbapi.connect(*cargs, **cparams)
OperationalError: (OperationalError) unable to open database file None None
How we do solve? I am trying two days. Today second day.
Thank you for interest.
Good works my friends.
--
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.
