The study of SQLite on Centos7.2

The study of SQLite on Centos7.2

Going to learn a very simple way to use the database.
Reference http://www.runoob.com/sqlite/sqlite-tutorial.html

First, the preparatory work

You may need to install SQLite on CentOS First, here try ' sudo yum install SQLite ', be prompted to already exist.
Use Python to install a SQLITE-API library pip install sqlite3 . I am prompted not to support my current Python version (2.7.6).

Second, create a database

CD to the directory where you want to store the comment.db, using the following command.

[[Email protected]2-0001Home# sqlite3 Comment.dbSQLite version3.7. -  -- to- - xx: About: AEnter". Help"  forInstructionsenter SQL statements terminated with a";"Sqlite>.quit#退出数据库

The above statement is used to create the success comment.db . sourcecrt 7.0.0 32bit Han version is very difficult to use, has been dropped line did not respond.
Reference 1 Http://www.oschina.net/translate/the-flask-mega-tutorial-part-i-hello-world This translation is very good.
Refer to 2 https://www.linuxhub.org/?p=2473.
Flask-sqlalchemy configuration reference for four databases https://www.cnblogs.com/agmcs/p/4445583.html

Application of Flask manage.py in the third section

(There is a problem: my static files cannot be accessed through the extranet, possibly because I didn't put them in the static/directory.) If not, you may need to consider nginx configuration problems? )

Reference

Webpage htmlhttp://v3.bootcss.com/components/#navbar-brand-image, like this minimalist style.

To-dos

• Familiarize yourself with the git command to clone the code from the remote repository to the server. (server loaded with Git) recently found a very useful with a private warehouse! There is no free private repository compared to GitHub. Ali produced must be a boutique.

• Modify existing HTML, familiar with template inheritance, (FLASK-JINJA2)

• The server installs MySQL and learns to use it.

?

The study of SQLite on Centos7.2