And I tried just now,
I am trying this is here,
app.config['SQLALCHEMY_DATABASE_URI'] = 'forum.db'
And this,
app.config['SQLALCHEMY_DATABASE_URI'] = '/forum.db'
Two ways' result the same.
Here is error, error is changed
Traceback (most recent call last):
File "C:\Users\user\Desktop\Flask\Forum\forum-sqlalchemy.py", line 130, in
<module>
xx = User.query.all()
File
"C:\Python27\lib\site-packages\flask_sqlalchemy-1.0-py2.7.egg\flask_sqlalchemy\__init__.py"
, line 428, in __get__
return type.query_class(mapper, session=self.sa.session())
File
"C:\Python27\lib\site-packages\sqlalchemy-0.9.6-py2.7-win32.egg\sqlalchemy\orm\scoping.py"
, line 70, in __call__
return self.registry()
File
"C:\Python27\lib\site-packages\sqlalchemy-0.9.6-py2.7-win32.egg\sqlalchemy\util\_collections.py"
, line 903, in __call__
return self.registry.setdefault(key, self.createfunc())
File
"C:\Python27\lib\site-packages\flask_sqlalchemy-1.0-py2.7.egg\flask_sqlalchemy\__init__.py"
, line 139, in __init__
bind=db.engine,
File
"C:\Python27\lib\site-packages\flask_sqlalchemy-1.0-py2.7.egg\flask_sqlalchemy\__init__.py"
, line 780, in engine
return self.get_engine(self.get_app())
File
"C:\Python27\lib\site-packages\flask_sqlalchemy-1.0-py2.7.egg\flask_sqlalchemy\__init__.py"
, line 797, in get_engine
return connector.get_engine()
File
"C:\Python27\lib\site-packages\flask_sqlalchemy-1.0-py2.7.egg\flask_sqlalchemy\__init__.py"
, line 467, in get_engine
info = make_url(uri)
File
"C:\Python27\lib\site-packages\sqlalchemy-0.9.6-py2.7-win32.egg\sqlalchemy\engine\url.py"
, line 163, in make_url
return _parse_rfc1738_args(name_or_url)
File
"C:\Python27\lib\site-packages\sqlalchemy-0.9.6-py2.7-win32.egg\sqlalchemy\engine\url.py"
, line 211, in _parse_rfc1738_args
"Could not parse rfc1738 URL from string '%s'" % name)
ArgumentError: Could not parse rfc1738 URL from string 'forum.db'
21 Temmuz 2014 Pazartesi 22:29:40 UTC+3 tarihinde Michael Bayer yazdı:
>
> how are the permissions on this file path:
>
> /test.db
>
> ?
>
> do you really want your database file in the root directory like that?
>
>
> On Jul 21, 2014, at 2:58 PM, Imk Hacked <ihack...@gmail.com <javascript:>>
> wrote:
>
> 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+...@googlegroups.com <javascript:>.
> To post to this group, send email to sqlal...@googlegroups.com
> <javascript:>.
> Visit this group at http://groups.google.com/group/sqlalchemy.
> For more options, visit https://groups.google.com/d/optout.
>
>
>
--
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.
