Python Flask CMS App

This is a Content Management System(CMS) App build by Python Flask.

Feature

1. Oauth auth / auth
2. CRUD
3. read/write google spreadsheet
4. word.docx

Usage

1. $ git clone
2. go to venv
3. $ pip install -r requirements.txt
4. $ python manage.py db init
5. $ python manage.py db migrate
6. $ python manage.py db upgrade

Extensions

1. Flask
2. Flask-SQLAlchemy
3. Flask-Migrate
4. Flask-Script
5. Flsk-Oauthlib
6. mysqlclient
7. python-docx-template
8. gspread
9. gunicorn

MySQL Setting

if you use linux/ubuntu, please install

$ sudo apt-get install mysql-server
$ sudo apt-get install libmysqlclient-dev

setup UTF-8, my.cnf file is located at /etc/mysql/

[mysqld]
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8
skip-character-set-client-handshake

[client]
default-character-set   = utf8

[mysql]
default-character-set   = utf8

Restart

$ sudo service mysql restart

1. Enter MySQL

$ mysql -u root

2. select DB

>>> use mysql;

3. Update user data and setup root password

>>> update user set password=PASSWORD("password") where User='root'; 

4. Refresh MySQL

>>> flush privileges;

5. Exit MySQL

>>> quit

DB Migrate

1. Initial

$ python manage.py db init

2. Add Migration

$ python manage.py db migrate

3. Update to DB

$ python manage.py db upgrade

Documents

1. flask-oauthlib
2. Welcome to python-docx-template’s documentation!
3. Mac OS 上安裝 MySQL 以及相關設定筆記
4. Install MySQL on macOS Sierra
5. brew install mysql on mac os el capitan
6. gspread API Reference
7. Inserting a Python datetime.datetime object into MySQL
8. Inserting a unix timestamp into MySQL from Python [duplicate]
9. mysql_config not found when installing mysqldb python interface
10. Change MySQL default character set to UTF-8 in my.cnf?
11. Mysql 插入中文错误：Incorrect string value: '\xE7\xA8\x8B\xE5\xBA\x8F...' for column 'course' at row 1