gistfile1.txt

from flask import abort, jsonify

app = Blueprint('app', __name__)

@app.route("/save/name/:name", methods['POST'])
def save_file(name):
  service = create_service()
  result = service.save_name(name)
  if result:
    return jsonify(result=result)
  abort(500, "could not save name") 

service.py

class Service:
  def __init__(self, provider, logger):
    self.provider = provider
    
  def save_name(name):
    try:
      return self.provider.save_name(name)
    except Exception as e:
      self.logger.error(e)
      return False
   

sqlite_provider.py

class SqliteProvider:
  def __init__(self, db, logger):
    self.db = db
    
  def save_name(name):
    try:
      c = self.db.cursor()
      r = c.execute("INSERT INTO files VALUES (?)", (name, ))
      self.db.commit()
    except self.db.IntegrityError as err:
      raise Exception("duplicate found")
    except Exception as e:
      raise Exception("unknown error: {}".format(e))