from flask import request, jsonify, redirect
from flask_classful import route
from werkzeug.datastructures import MultiDict

from app.sql.common import db, Session
from app.sql.models.graph import Graph, GraphForm
from app.sql.models.page import Page
from app.sql.models.tile import Tile
from app.controllers.crud_controller import CrudView

class GraphView(CrudView):
  model = Graph
  form = GraphForm

  def on_destroy(self, session, item):
    for item in item.pages:
      session.query(Tile).filter(Tile.page_id == item.id).delete(synchronize_session=False)
    session.query(Page).filter(Page.graph_id == item.id).delete(synchronize_session=False)