morganthrapp

import os
import datetime

import flask_sqlalchemy

import cocktail_site
import cocktail_site.utilities as utils

cocktail_site.app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///db/drinks.db'
db = flask_sqlalchemy.SQLAlchemy(cocktail_site.app)

morganthrapp

class FooBase:
  def __init__(self, foo)
    self.foo = foo

morganthrapp

CASE 
  WHEN DATEDIFF(d, LienStartDate, GETDATE()) - (DATEDIFF(yyyy, LienStartDate, GETDATE()) * 365) >= 0 
    THEN Amount * (DATEDIFF(m, LienSTartDate, GETDATE()) * 0.01) 
  WHEN DATEDIFF(d, LienStartDate, GETDATE()) - (DATEDIFF(yyyy, LienStartDate, GETDATE()) * 365) < 0 
    THEN Amount * ((DATEDIFF(m, LienStartDate, GETDATE()) - 1) * 0.01) END

morganthrapp

CASE (DATEDIFF(d, LienStartDate, GETDATE()) - (DATEDIFF(yyyy, LienStartDate, GETDATE()) * 365)) 
  WHEN >= 0 THEN Amount * (DATEDIFF(m, LienStartDate, GETDATE()) * 0.01) 
  WHEN < 0 THEN Amount * ((DATEDIFF(m, LienStartDate, GETDATE()) - 1) * 0.01)