#!/bin/env python3

import flask

from flask import request, jsonify
from flask_sqlalchemy import SQLAlchemy
from flask_marshmallow import Marshmallow

db = SQLAlchemy()
app = flask.Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql://root@mysql-0.mysql.svc.cluster.local/gopy'
db.init_app(app)


ma = Marshmallow(app)

class Link(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(255))
    target = db.Column(db.String(255))

    def __repr__(self):
        return '<Link id=(id) name=(name) target=(target)>'.format(
            id=self.id, name=self.name, target=self.target
        )

class LinkSchema(ma.Schema):
    class Meta:
        fields = ('id', 'name', 'target')

@app.route('/links', methods=['GET'])
def get_links():
    links = Link.query.all()
    schema = LinkSchema(many=True)
    link_json = schema.dump(links)
    return jsonify(link_json)

#@app.route('/links/<int:id>', methods=['GET'])