################################################################################
# Set parameters
query = """SELECT hollande.chomage - sarkozy.chomage
FROM (SELECT bf.nb_chomeur - af.nb_chomeur AS chomage
FROM (SELECT nb_chomeur FROM chomagePE
WHERE mois = <t> ) AS bf,
(SELECT nb_chomeur FROM chomagePE
WHERE mois = <t> - INTERVAL <w> + 1 MONTH ) AS af ) AS hollande,
(SELECT bf.nb_chomeur - af.nb_chomeur AS chomage
FROM (SELECT nb_chomeur FROM chomagePE
WHERE mois = <t> - INTERVAL <d> MONTH) AS bf,
(SELECT nb_chomeur FROM chomagePE
WHERE mois = <t> - INTERVAL <d> + <w> + 1 MONTH ) AS af ) AS sarkozy;"""
t0, w0, d0, r0, limit_min = "2014-10-01", 30, 30, 310900, "2000-01-01"
obj = qrs( query, t0, w0, d0, r0, "increasing", limit_min )
times = ['2011-01-01', '2015-08-01']
#widths = range(25,36)
widths = [30]
#widths = range(25,36)
durations = range(20,61)
obj.initParameters( times, widths, durations )
#levels = [(1,1), (2.71, 60)]
levels = [(1,1), (2.71, 3), (7.34, 6), (19.9, 12)]
sigma_w, sigma_t, sigma_d = 5, 1, 10
#sigma_w, sigma_t, sigma_d = 2.5, 5, 10
obj.initSP( levels, sigma_w, sigma_t, sigma_d )
WHERE (entity1_vote_type = 'P' OR entity1_vote_type = '+' OR entity1_vote_type = '-')
AND entity1_vote_type = entity2_vote_type) AS c;"""
#This query bases on just common '-' and '+' votes
#Symetric comparison
query = """SELECT c.common/t.total FROM (SELECT count(*) AS total FROM <u>
WHERE vote_created >= <a> AND vote_created < <b>) AS t,
(SELECT count(*) AS common FROM
(SELECT * FROM <u> WHERE vote_created >= <a> AND vote_created < <b>) AS u,
(SELECT * FROM <v> WHERE vote_created >= <a> AND vote_created < <b>) AS v
WHERE u.vote_session = v.vote_session AND u.vote_number = v.vote_number AND u.vote_question = v.vote_question
AND (u.option_key = '+' OR u.option_key = '-') AND u.option_key = v.option_key) AS c;"""
a0, b0, u0, v0, r0, limit_min = "2010-01-01", "2010-10-15", "boehner", "marshall", 0.65, "2007-01-04" # 65% of same vote
obj = qrs( query, a0, b0, u0, v0, r0, limit_min )
period = ['2009-01-01', '2010-12-01']
# Possibilities: bachmann, boehner, clyburn, kaptur, kucinich, oberstar, rangel, rayn, schock, speier
#u = ["boehner", "bachmann", "schock", "ryan"]
u = ["boehner"]
v = ["marshall"]
obj.initParameters( u, v, period )
# e, e, e^(1/2), e^(1/3), e^(1/4), e^(0)
levels_a = [(2.71,'01-01'), (2.71, '01-15'), (1.4, '02-01'), (1.28, '02-15'),\
(1, '03-01'), (1, '03-15'), (1, '04-01'), (1, '04-15'), (1, '05-01'),\
(1, '05-15'), (1, '06-01'), (1, '06-15'), (1, '07-01'), (1, '07-15'),\
(1, '08-01'), (1, '08-15'), (1, '09-01'), (1, '09-15'), (1, '10-01'),\
(1, '10-15'), (1, '11-01'), (1, '11-15'), (1, '12-01'), (1, '12-15')]
