# Flask SQL 資料庫

下載[MySQL Workbench](https://dev.mysql.com/downloads/workbench/)


`pip install Flask-SQLAlchemy pymysql`

`sudo apt-get install mariadb-server`

`sudo systemctl start mariadb`

`sudo systemctl enable mariadb`

安全性設置
`sudo mysql_secure_installation`

改IP
`sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf`

`sudo systemctl restart mysql`

`sudo mysql -u root -p`

`CREATE DATABASE HAPS;`

GRANT ALL PRIVILEGES ON HAPS.* TO 'HAPS'@'%' IDENTIFIED BY 'HAPS';
FLUSH PRIVILEGES;
EXIT;

`mysql -u HAPS -p -h 192.168.50.229 -P 3306`

設定&模板

app.config['SQLALCHEMY_DATABASE_URI']='mysql+pymysql://HAPS:HAPS@192.168.50.229:3306/HAPS'

app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False

db = SQLAlchemy(app)

class IMUDATABASE(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    roll = db.Column(db.Float)
    pitch = db.Column(db.Float)
    yaw = db.Column(db.Float)
    speed = db.Column(db.Float)
    bearing = db.Column(db.Float)
    timestamp = db.Column(db.DateTime, default=datetime.now)

輸入&提交

imu_entry = IMUDATABASE(
    roll=payload[0],
    pitch=payload[1],
    yaw=payload[2],
    speed=payload[4],
    bearing=payload[5],
    timestamp=datetime.now()
)

db.session.add(imu_entry)
db.session.commit()