myFlaskApp

First try python with flask

Project

• Python language
• Flask framework
• MySQL DB

Usage

• install python first
• install pip. pip is package management for python
• editor. in case I used VSCODE
• local server such as: MAMP, XAMPP
• import DB script(down below) to your phpmyadmin
• test run by "python app.py"

MySQL script

-- phpMyAdmin SQL Dump -- version 4.6.5.2 -- https://www.phpmyadmin.net/

-- Host: localhost:3306 -- Generation Time: Feb 15, 2018 at 11:54 AM -- Server version: 5.6.35 -- PHP Version: 7.1.1

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00";

-- -- Database: myflaskapp

---

-- -- Table structure for table articles

CREATE TABLE articles ( id int(11) NOT NULL, title varchar(255) NOT NULL, author varchar(100) NOT NULL, body text NOT NULL, create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

---

-- -- Table structure for table users

CREATE TABLE users ( id int(11) NOT NULL, name varchar(100) NOT NULL, email varchar(100) NOT NULL, username varchar(30) NOT NULL, password varchar(100) NOT NULL, register_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- -- Indexes for dumped tables

-- -- Indexes for table articles

ALTER TABLE articles ADD PRIMARY KEY (id);

-- -- Indexes for table users

ALTER TABLE users ADD PRIMARY KEY (id);

-- -- AUTO_INCREMENT for dumped tables

-- -- AUTO_INCREMENT for table articles

ALTER TABLE articles MODIFY id int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

-- AUTO_INCREMENT for table users

ALTER TABLE users MODIFY id int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;