Ideone.com

fork download

--select * from tms_app_loaninstallmentfundingrequest --
 
with loan_on_day_status as (
    select id as loan_id,
    	(
            select status_id
            from loan_app_loanstatushistroy
            where day <= {'date':'date'} and status_type = 0 and loan_app_loanstatushistroy.loan_id = loan_app_loan.id
            order by loan_id, updated_at desc
            limit 1
        ) as blnk_status,
        (
            select day
            from loan_app_loanstatushistroy
            where day <= {'date':'date'} and status_type = 0 and loan_app_loanstatushistroy.loan_id = loan_app_loan.id
            order by loan_id, updated_at desc
            limit 1
        ) as blnk_status_day,
        (
            select status_id
            from loan_app_loanstatushistroy
            where day <= {'date':'date'} and status_type = 1 and loan_app_loanstatushistroy.loan_id = loan_app_loan.id
            order by loan_id, updated_at desc
            limit 1
        ) as fra_status
        from loan_app_loan
        order by loan_id
),
 
latest_payment_status as (
    select distinct on (nli.installment_extension_id) installment_extension_id as installment_id, status as payment_status, nli.day
    from new_lms_installmentpaymentstatushistory nli
    where day <= {'date':'date'}
    order by nli.installment_extension_id, nli.day desc, nli.id desc
)
,
 
 
-- without bv
off_bal_installments as (
	select lai.id
	from loan_app_installment lai
	inner join tms_app_loanmerchantbatch talmb on talmb.loan_id = lai.loan_id and talmb.bond_id = 16
	union
	select talifr.installment_id  as id
	from tms_app_loaninstallmentfundingrequest talifr
	where talifr.onbalance = false and assignment_day <= {'date':'date'} 
 
),
 
on_bal_installments as (
	select id
	from loan_app_installment
	except
	select id
	from off_bal_installments
)
,
targeted_loans as (
select distinct lai.loan_id as loan_id
from loan_app_installment lai
inner join on_bal_installments obi on obi.id = lai.id
 
)
,
remaining_principal as (
    select lal.id,  	coalesce(sum(lai.principal_expected) filter (where nlie.principal_paid_at is null or cast(principal_paid_at as date) > {'date':'date'}
         or   
         ( cast(principal_paid_at as date) < lai.day and (nlie.payment_status not in (2,3,4,16)  and lds.blnk_status not in (1,6,8,15,16) or 
         (nlie.payment_status = 6  ) ))
               and {'date':'date'} < lai.day
    ), 0)  as enr, 
 
    coalesce( sum(lai.principal_expected) filter ( where  lps.payment_status in (5,6) and nlie.is_long_term=false and  (nlie.status_id <> 7 or (nlie.status_id = 7 and (is_principal_paid=false or (principal_paid_at::date > {'date':'date'}))))  and ((( nlie.status_id=7 or nlie.long_to_short_term_date < {'date':'date'}) and nlie.long_to_short_term_date < {'date':'date'} ) or nlie.long_to_short_term_date is null)
            ),0) as undue_principle,
 
 
    coalesce( sum(lai.principal_expected) filter (
        where 
              lps.payment_status = 0 and {'date':'date'} >= nlie.due_to_overdue_date 
            and (((nlie.status_id=7 or nlie.long_to_short_term_date < {'date':'date'}) and nlie.long_to_short_term_date < {'date':'date'} ) or nlie.long_to_short_term_date is null) and (is_principal_paid=false or (principal_paid_at::date > {'date':'date'}))
    ) ,0) as overdue_principle,
 
    coalesce( sum(lai.principal_expected) filter (
        where 
             (lps.payment_status = 4 and (nlie.is_principal_paid = false or nlie.principal_paid_at > {'date':'date'}) ) or (lps.payment_status = 0 and {'date':'date'} < nlie.due_to_overdue_date )
--    	) 
    	) ,0) as due_principle,
 
    coalesce( 
    	sum(lai.principal_expected) filter ( 
			where 
		       (nlie.is_long_term = true or (nlie.is_long_term = false and nlie.long_to_short_term_date >= {'date':'date'})) 
				and (nlie.is_principal_paid = false or cast(nlie.principal_paid_at as date) > {'date':'date'} )
		),
		0
	) as long_term_principle
 
 
 
    from loan_app_loan lal 
    inner join loan_on_day_status lds on lds.loan_id = lal.id  
    inner join loan_app_installment lai on lai.loan_id = lal.id
    inner join latest_payment_status lps on lps.installment_id = lai.id 
    inner join new_lms_installmentextension nlie on nlie.installment_ptr_id  = lai.id
    inner join on_bal_installments obi on obi.id = lai.id
    where lds.blnk_status not in (12,13)
 
    group by lal.id
 
)
,
provisions as (
 
	select lal.id, 	coalesce(sum(lai.principal_expected) filter (where nlie.principal_paid_at is null or cast(principal_paid_at as date) > {'date':'date'}
         or   
         ( cast(principal_paid_at as date) < lai.day and (nlie.payment_status not in (2,3,4,16)  and lds.blnk_status not in (1,6,8,15,16) or 
         (nlie.payment_status = 6 and lds.blnk_status not in (1,6,8,15,16) ) ))
               and {'date':'date'} < lai.day
    ), 0) as enr
 
    from loan_app_loan lal
	inner join loan_app_installment lai on lai.loan_id = lal.id
	inner join new_lms_installmentextension nlie on nlie.installment_ptr_id = lai.id
	inner join loan_on_day_status lds on lds.loan_id = lal.id
	group by lal.id
 
)
,
 
 
late_fees as (
	select lal.id, sum(nlilf.amount) filter(
	where nlilf.day < {'date':'date'} and lds.blnk_status not in  (7,17)
    and (nlilf.is_cancelled = false or cast(nlilf.cancellation_date as date) > {'date':'date'})      and nlilf.is_disabled = false 
    and (nlilf.is_partially_cancelled = false or nlilf.partially_cancelled_date > {'date':'date'}) 
    and (nlilf.is_paid = false or cast(nlilf.paid_at as date) > {'date':'date'})
    )as total_late_fees, 
 
    sum(nlilf.amount) filter 
        (where lds.blnk_status <> 7 and ((nlilf.day<{'date':'date'} and {'date':'date'}<'2025-09-30' and (select count(*) from loan_app_loanstatushistroy where loan_id=lal.id and 
        status_type=0 and day <={'date':'date'} and status_id =3 and day < '2025-09-30') >0 and (nlilf.is_paid=false or nlilf.paid_at::date>{'date':'date'})) or ((nlilf.is_marginalized = true 
	and cast(nlilf.marginalization_date as date) <= {'date':'date'})  or (
	nlilf.is_marginalized = false 
		and cast(nlilf.marginalization_date as date) is not null
	and cast(nlilf.marginalization_date as date) <= {'date':'date'} 
    and  cast(nlilf.unmarginalization_date as date) > {'date':'date'}) ))and (nlilf.is_cancelled =false or (nlilf.is_cancelled =true and nlilf.cancellation_date> {'date':'date'})) )
     as marginalized
	from new_lms_installmentlatefees nlilf
inner join loan_app_installment lai on lai.id = nlilf .installment_extension_id 
inner join loan_app_loan lal on lal.id = lai.loan_id 
inner join on_bal_installments obi on obi.id = lai.id
inner join loan_on_day_status lds on lds.loan_id = lal.id  
 
group by lal.id
)
,
 
accrued_interest as(
    select lai.loan_id as id, sum((
		case when nlie.payment_status in (0,2) and nlie.partial_accrual_date <= {'date':'date'} then (
			(case when nlie.accrual_date <= {'date':'date'} then nlie.actual_accrued_amount else 0 end) +  nlie.partial_accrual_amount - (case when cast(nlie.interest_paid_at as date) <= {'date':'date'} then nlie.actual_interest_paid else 0 end) + nlie.settlement_accrual_interest_amount + nlie.faulty_accrued_amount
			)
			when nlie.payment_status in (4) and nlie.partial_accrual_date <= {'date':'date'} then 
				 (nlie.partial_accrual_amount  + (case when nlie.accrual_date <= {'date':'date'} then nlie.actual_accrued_amount else 0 end)
				 )
			when nlie.payment_status in (1)then
				 (  
				 (case when nlie.partial_accrual_date <= {'date':'date'} then nlie.partial_accrual_amount else 0 end) 
				 + (case when nlie.accrual_date <= {'date':'date'} then nlie.actual_accrued_amount - nlie.actual_interest_paid + nlie.faulty_accrued_amount else 0 end)
				 )
             when nlie.payment_status in (3,16) then 
             			case when nlie.partial_accrual_date <= {'date':'date'} then nlie.partial_accrual_amount else 0 end 
            + (case when nlie.accrual_date <= {'date':'date'} then nlie.actual_accrued_amount else 0 end)
            + case when cast(nlie.settlement_accrual_interest_date as date) <= {'date':'date'} then nlie.settlement_accrual_interest_amount else 0 end 
            - (case when cast(nlie.interest_paid_at as date) <= {'date':'date'} then nlie.actual_interest_paid else 0 end)
 
		end
		))
         as accrued_interest
        from loan_app_installment lai 
inner join new_lms_installmentextension nlie on nlie.installment_ptr_id = lai.id
inner join loan_app_loan lal on lal.id = lai.loan_id 
group by lai.loan_id
)
,
 
decomposed_interests as(
    select lai.loan_id ,
	sum(case when nlie.due_to_overdue_date <= {'date':'date'}  and (lds.blnk_status <> 7 or ( lds.blnk_status = 7 and nlie.due_to_overdue_date < lds.blnk_status_day))
		and (nlie.is_interest_paid = false or cast(nlie.interest_paid_at as date) > {'date':'date'}) and lds.blnk_status not in (6,8,12,13,15,16)
		then lai.interest_expected + round(case when extra_interest_paid_at<= {'date':'date'} then 0 else nlie.first_installment_interest_adjustment end,2) end) as overdue_interest,
 
 
	sum(case when {'date':'date'} >= nlie.undue_to_due_date and {'date':'date'} <=  nlie.grace_date and (nlie.is_interest_paid = false or cast(nlie.interest_paid_at as date) > {'date':'date'}) and lds.blnk_status not in (6,8,12,13,15,16) then lai.interest_expected + round(nlie.first_installment_interest_adjustment,2)  else 0 end) as due_nonpaid_interest
	from loan_app_installment lai 
	inner join new_lms_installmentextension nlie on nlie.installment_ptr_id = lai.id
	inner join loan_app_loan lal on lal.id = lai.loan_id 
    inner join loan_on_day_status lds on lds.loan_id = lal.id 
    inner join on_bal_installments obi on obi.id = lai.id
 
    where lds.blnk_status not in (7,12,13)
 
	group by lai.loan_id 
-- select lai.loan_id ,
-- 	sum(case when nlie.due_to_overdue_date <= {'date':'date'} 
-- 		and (nlie.is_interest_paid = false or nlie.interest_paid_at::date > {'date':'date'}) and lds.blnk_status not in (6,8,12,13,15)
-- 		then lai.interest_expected end) as overdue_interest,
-- 	sum(
--         case 
--             when 
--                 {'date':'date'}  >= nlie.undue_to_due_date and {'date':'date'} < nlie.due_to_overdue_date
--                 and (nlie.is_interest_paid = false or nlie.interest_paid_at::date > {'date':'date'}) 
--                 and lds.blnk_status not in (6,7,8,12,13,15) 
--             then lai.interest_expected 
--             else 0 
--         end
--     ) as due_nonpaid_interest
-- 	from loan_app_installment lai 
-- 	inner join new_lms_installmentextension nlie on nlie.installment_ptr_id = lai.id
-- 	inner join loan_app_loan lal on lal.id = lai.loan_id 
-- 	inner join on_bal_installments obi on obi.id = lai.id
 
-- 	    inner join loan_on_day_status lds on lds.loan_id = lal.id 
-- 	    where lds.blnk_status not in (12,13)
 
-- 	group by lai.loan_id 
)
,
 
undue_interest as (
   with installments_details as (
		select 
			lai.id as "installment_id",
			lai.loan_id, 
			lal.status_id, 
			nli.accrual_date, 
			lal.first_accrual_adjustment_date, 
			nli.is_extra_interest_paid, 
			nli.payment_status, 
			nli.first_installment_interest_adjustment,
			nli.actual_interest_paid,
			nli.settlement_accrual_interest_amount,
			nli.settlement_accrual_interest_date,
			nli.expected_partial_accrual_amount,
			lai.interest_expected,
			lai.day,
			nli.interest_paid_at,
			nli.partial_accrual_date,
			lai."period",
			nli.expected_accrual_amount,
			nli.extra_interest_paid_at,
			nli.undue_to_due_date
		from new_lms_installmentextension nli
		inner join loan_app_installment lai on nli.installment_ptr_id = lai.id
		inner join loan_app_loan lal on lal.id = lai.loan_id 
    inner join on_bal_installments obi on obi.id = lai.id
 
	)
    ,
   init_accrual as(
        select installments_details.loan_id lalid1, sum(first_installment_interest_adjustment) first_accrual_adjustment
        from installments_details 
        inner join latest_payment_status lps on lps.installment_id = installments_details."installment_id"
        inner join loan_on_day_status lods on installments_details.loan_id = lods.loan_id
        where 
        (lps.payment_status in (5,6) or(lps.payment_status in (4,7) and lods.blnk_status in (11,14,7,15) and accrual_date > {'date':'date'}) or (lps.payment_status=10 and  extra_interest_paid_at::date > {'date':'date'}) or (lps.payment_status in (3,16) and accrual_date > {'date':'date'} and extra_interest_paid_at::date > {'date':'date'})) and first_installment_interest_adjustment > 0
        and (lods.blnk_status not in (8,15,16) or (lods.blnk_status in (8,15,16) and is_extra_interest_paid = true and extra_interest_paid_at::date > {'date':'date'})) and first_accrual_adjustment_date <= {'date':'date'}
        and (partial_accrual_date > {'date':'date'} or (partial_accrual_date = {'date':'date'} and EXTRACT('DAY' FROM undue_to_due_date) = 1))  and lps.payment_status not in (12,13)
        group by installments_details.loan_id
    )
    ,
    next_inst as(
        select lalid3, insts from (
            select nli.loan_id lalid3, (expected_accrual_amount) insts, lods.blnk_status status_on_day,
            (select status from new_lms_installmentpaymentstatushistory where installment_extension_id=nli.installment_id and day <={'date':'date'} order by id desc limit 1) as last_status,
            undue_to_due_date, interest_paid_at
            from installments_details nli
            inner join loan_on_day_status lods on nli.loan_id = lods.loan_id
            where accrual_date = {'date':'date'} 
            and (lods.blnk_status not in (15,7) 
                or (lods.blnk_status = 15 and (settlement_accrual_interest_amount = 0 or settlement_accrual_interest_amount <> 0 and settlement_accrual_interest_date::date > {'date':'date'}))
                or (lods.blnk_status = 7 and  lods.blnk_status_day > accrual_date )
        ) ) s 
        where last_status not in (1,2,3,7,12) 
        or 
        (last_status = 2 
        	and (interest_paid_at::date < undue_to_due_date or (interest_paid_at is null and status_on_day <>15))
        )
        or (last_status = 7 and (select status_id from loan_app_loan where id = lalid3) <>15)
    )
    ,
    next_partial_only as (
        select lalid4, insts from (
        select nli.loan_id lalid4, expected_partial_accrual_amount + (case when nli.is_extra_interest_paid=true and nli.extra_interest_paid_at::date <={'date':'date'} then 0 else 
        round(first_installment_interest_adjustment,2) end) insts,
        (select status from new_lms_installmentpaymentstatushistory where installment_extension_id=nli.installment_id and day <={'date':'date'} order by id desc limit 1) as last_status,
        undue_to_due_date, interest_paid_at
        from installments_details nli
        inner join loan_on_day_status lods on nli.loan_id = lods.loan_id
        where 
        	(select nlish.status_id from new_lms_installmentstatushistory nlish where nlish.installment_id  = nli.installment_id and day <= {'date':'date'} and status_type = 1 order by id desc limit 1)  <> 7
            and partial_accrual_date <= {'date':'date'}  
            and day > cast({'date':'date'} as date) + interval '1 day'
            and (lods.blnk_status <> 15 or (lods.blnk_status = 15 
            	and (settlement_accrual_interest_amount = 0 or settlement_accrual_interest_amount <> 0 and cast(settlement_accrual_interest_date as date) > {'date':'date'}))
        		) 
            )
            s where last_status not in (1,2,3,7,12) 
            or (last_status = 2 
                and (cast(interest_paid_at as date) < undue_to_due_date or (interest_paid_at is null and (select blnk_status from loan_on_day_status where loan_id = lalid4) <>15)))
            or (last_status = 7 and (select blnk_status from loan_on_day_status where loan_id = lalid4) <>15)
    )
    ,
    old_first_accrual_in_partial as(
     select lalid5, insts from (
        select loan_id lalid5, (expected_partial_accrual_amount) insts,
        (select status from new_lms_installmentpaymentstatushistory where installment_extension_id=nli.installment_id and day <={'date':'date'} order by id desc limit 1) as last_status
        from installments_details nli
        where accrual_date = {'date':'date'} and expected_partial_accrual_amount <> 0 and (status_id not in (8,16) or (status_id in (8,16) and payment_status not in (3,16)))  
    	) s where last_status not in (12,13)
    )
 
 
    SELECT  loan, sum(undue_balance) as undue_balance
    FROM( 
        select lalid1 loan, first_accrual_adjustment undue_balance from init_accrual
        UNION ALL
        select lalid3 loan, insts undue_balance from next_inst
        UNION ALL
        select lalid4 loan, insts undue_balance from next_partial_only
        UNION ALL
        select lalid5 loan, insts undue_balance from old_first_accrual_in_partial
    ) s group by s.loan
 
)
 
 
,     
marginalized_interest as(
     select lai.loan_id , 
     sum(
        case 
            -- the first 2 lines here are to get all the marginalization that was done before applying 90 days marginalization on 30-09-2025
            when lds.blnk_status > 2 and lai.day <={'date':'date'} and {'date':'date'} < '2025-09-30' and (nlie.is_interest_paid=false or nlie.interest_paid_at::date > {'date':'date'}) then lai.interest_expected + round(nlie.first_installment_interest_adjustment,2)
            when nlie.partial_accrual_date<={'date':'date'} and lai.day > {'date':'date'} and lds.blnk_status > 2 and {'date':'date'} < '2025-09-30' and (nlie.is_interest_paid=false or nlie.interest_paid_at::date > {'date':'date'}) then expected_partial_accrual_amount
            when is_marginalized=true and marginalization_date <= {'date':'date'}  then lai.interest_expected + round(nlie.first_installment_interest_adjustment,2)
            when is_partially_marginalized=true and partial_marginalization_date <= {'date':'date'} then expected_partial_accrual_amount 
            when is_marginalized=false and marginalization_date <= {'date':'date'} and unmarginalization_date > {'date':'date'} then lai.interest_expected + round(nlie.first_installment_interest_adjustment,2)
            when is_partially_marginalized=false and partial_marginalization_date <= {'date':'date'} and unmarginalization_date > {'date':'date'} then expected_partial_accrual_amount 
            else 0 
        end
     )as marginalized_interest
--      sum(
-- 	(
--     case when nlie.partial_marginalization_date is not null and (nlie.is_partially_marginalized  = true or nlie.unmarginalization_date::date > {'date':'date'}) and nlie.partial_marginalization_date::date < {'date':'date'}
--     then nlie.partial_accrual_amount else 0 end
--     )
--     +(
--     case when nlie.marginalization_date is not null and (nlie.is_marginalized = true or nlie.unmarginalization_date::date > {'date':'date'}) and nlie.marginalization_date::date < {'date':'date'}
--     then nlie.actual_accrued_amount + (
--         case when (nlie.partial_marginalization_date::date is null or nlie.unmarginalization_date::date < nlie.marginalization_date) and nlie.is_partially_marginalized = False 
--     then nlie.partial_accrual_amount else 0 end
--     ) else 0 end 
--     )
-- ) as marginalized_interest
        from loan_app_installment lai 
        inner join new_lms_installmentextension nlie on nlie.installment_ptr_id = lai.id
        inner join on_bal_installments obi on obi.id = lai.id
        inner join loan_on_day_status lds on lds.loan_id = lai.loan_id 
        where lds.blnk_status <> 7
 
group by lai.loan_id
)
,
 
 
 
main_query as (
select lal.id  
,
-- (case when lds.blnk_status=7 then coalesce(rp.enr,0) else
(coalesce((coalesce(rp.undue_principle,0)+coalesce(rp.overdue_principle,0)+coalesce(rp.due_principle,0)+coalesce(rp.long_term_principle,0)),0))as ENR, 
coalesce(rp.undue_principle,0) as "Loans receivable undue, (gross)",
coalesce(rp.overdue_principle,0) as "Loans receivable overdue, (gross)",
coalesce(rp.due_principle,0) as "Loans receivable due, (gross)",
coalesce(rp.long_term_principle,0) as "Long term loans receivables",
coalesce(di.due_nonpaid_interest,0) as "Accrued interest income receivable, due (gross)",
coalesce(ui.undue_balance,0) as "Accrued interest income receivable, undue (gross)", 
coalesce(mi.marginalized_interest,0) as "Marginalized interest income receivable",
coalesce(lf.total_late_fees,0) as total_late_fees, 
coalesce(lf.marginalized,0) as "Marginalized late repayment fee income receivable",
round(lap.percentage * coalesce((coalesce(rp.undue_principle,0)+coalesce(rp.overdue_principle,0)+coalesce(rp.due_principle,0)+coalesce(rp.long_term_principle,0)),0) / 100,2) as "Impairment provisions, On-balance sheet", 
coalesce(di.overdue_interest,0) as "Accrued interest income receivable, overdue (gross)",
lalsb.name as blnk_status, 
lalsf.name as fra_status, 
lal.principle as loan_amount, 
lal.yearly_interest, 
lal.loan_booking_day,
lal.period_installment, 
lal.num_months,
--case when talmb.bond_id = 15 then 'securitized' when talmb.bond_id = 16 then 'BV' else 'On Balance' end as portfolio,
cac.id as customer, 
case when cac.limit_source = 1 then 'Banked' when cac.limit_source = 2 then 'Unbanked' end as limit_source,
concat(cac.first_name,' ',cac.last_name) as customer_name, 
cac.phone_number, 
nllc.starting_day_of_the_month as cycle_day, 
cacr.name as rank
, cam3.name_ar as product_type 
from loan_app_loan lal
inner join targeted_loans tl on tl.loan_id = lal.id
 
inner join loan_on_day_status lds on lds.loan_id = lal.id 
left join loan_app_loanstatus lalsb on lalsb.id = lds.blnk_status 
left join loan_app_loanstatus lalsf on lalsf.id = lds.fra_status 
inner join crm_app_customer cac on cac.id = lal.customer_id 
inner join new_lms_loancycle nllc on nllc.id = cac.first_loan_cycle_id
inner join crm_app_customerrank cacr on cacr.id = cac.rank_id
inner join loan_app_provision lap on lap.status_id = lds.fra_status
left join crm_app_merchant cam2 on cam2.id = lal.merchant_id
left join crm_app_merchantcategory cam3 on cam3.id = cam2.category_id
left join tms_app_loanmerchantbatch talmb on talmb.loan_id = lal.id
left join remaining_principal rp on rp.id = lal.id
left join late_fees lf on lf.id = lal.id
--left join accrued_interest ai on ai.id = lal.id
left join undue_interest ui on ui.loan = lal.id 
left join marginalized_interest mi on mi.loan_id = lal.id
left join decomposed_interests di on di.loan_id = lal.id
where  lal.loan_booking_day <= {'date':'date'} -- and lal.id = 82651
and lds.blnk_status in (1,2,3,4,5,7,9,10,11,14)
order by lal.id
)
 
select * from main_query
--  where id=70956
 
-- where id=56112
 
-- where id=64241
 
-- where id=94804
-- where id in (84682,85806,99194,100129,102323,102391,102439,104335,124645,93773,94804)
 
 
 
 
 
--where enr <> 0 and total_late_fees <> 0

LS1zZWxlY3QgKiBmcm9tIHRtc19hcHBfbG9hbmluc3RhbGxtZW50ZnVuZGluZ3JlcXVlc3QgLS0KCndpdGggbG9hbl9vbl9kYXlfc3RhdHVzIGFzICgKICAgIHNlbGVjdCBpZCBhcyBsb2FuX2lkLAogICAgCSgKICAgICAgICAgICAgc2VsZWN0IHN0YXR1c19pZAogICAgICAgICAgICBmcm9tIGxvYW5fYXBwX2xvYW5zdGF0dXNoaXN0cm95CiAgICAgICAgICAgIHdoZXJlIGRheSA8PSB7J2RhdGUnOidkYXRlJ30gYW5kIHN0YXR1c190eXBlID0gMCBhbmQgbG9hbl9hcHBfbG9hbnN0YXR1c2hpc3Ryb3kubG9hbl9pZCA9IGxvYW5fYXBwX2xvYW4uaWQKICAgICAgICAgICAgb3JkZXIgYnkgbG9hbl9pZCwgdXBkYXRlZF9hdCBkZXNjCiAgICAgICAgICAgIGxpbWl0IDEKICAgICAgICApIGFzIGJsbmtfc3RhdHVzLAogICAgICAgICgKICAgICAgICAgICAgc2VsZWN0IGRheQogICAgICAgICAgICBmcm9tIGxvYW5fYXBwX2xvYW5zdGF0dXNoaXN0cm95CiAgICAgICAgICAgIHdoZXJlIGRheSA8PSB7J2RhdGUnOidkYXRlJ30gYW5kIHN0YXR1c190eXBlID0gMCBhbmQgbG9hbl9hcHBfbG9hbnN0YXR1c2hpc3Ryb3kubG9hbl9pZCA9IGxvYW5fYXBwX2xvYW4uaWQKICAgICAgICAgICAgb3JkZXIgYnkgbG9hbl9pZCwgdXBkYXRlZF9hdCBkZXNjCiAgICAgICAgICAgIGxpbWl0IDEKICAgICAgICApIGFzIGJsbmtfc3RhdHVzX2RheSwKICAgICAgICAoCiAgICAgICAgICAgIHNlbGVjdCBzdGF0dXNfaWQKICAgICAgICAgICAgZnJvbSBsb2FuX2FwcF9sb2Fuc3RhdHVzaGlzdHJveQogICAgICAgICAgICB3aGVyZSBkYXkgPD0geydkYXRlJzonZGF0ZSd9IGFuZCBzdGF0dXNfdHlwZSA9IDEgYW5kIGxvYW5fYXBwX2xvYW5zdGF0dXNoaXN0cm95LmxvYW5faWQgPSBsb2FuX2FwcF9sb2FuLmlkCiAgICAgICAgICAgIG9yZGVyIGJ5IGxvYW5faWQsIHVwZGF0ZWRfYXQgZGVzYwogICAgICAgICAgICBsaW1pdCAxCiAgICAgICAgKSBhcyBmcmFfc3RhdHVzCiAgICAgICAgZnJvbSBsb2FuX2FwcF9sb2FuCiAgICAgICAgb3JkZXIgYnkgbG9hbl9pZAopLAoKbGF0ZXN0X3BheW1lbnRfc3RhdHVzIGFzICgKICAgIHNlbGVjdCBkaXN0aW5jdCBvbiAobmxpLmluc3RhbGxtZW50X2V4dGVuc2lvbl9pZCkgaW5zdGFsbG1lbnRfZXh0ZW5zaW9uX2lkIGFzIGluc3RhbGxtZW50X2lkLCBzdGF0dXMgYXMgcGF5bWVudF9zdGF0dXMsIG5saS5kYXkKICAgIGZyb20gbmV3X2xtc19pbnN0YWxsbWVudHBheW1lbnRzdGF0dXNoaXN0b3J5IG5saQogICAgd2hlcmUgZGF5IDw9IHsnZGF0ZSc6J2RhdGUnfQogICAgb3JkZXIgYnkgbmxpLmluc3RhbGxtZW50X2V4dGVuc2lvbl9pZCwgbmxpLmRheSBkZXNjLCBubGkuaWQgZGVzYwopCiwKCgotLSB3aXRob3V0IGJ2Cm9mZl9iYWxfaW5zdGFsbG1lbnRzIGFzICgKCXNlbGVjdCBsYWkuaWQKCWZyb20gbG9hbl9hcHBfaW5zdGFsbG1lbnQgbGFpCglpbm5lciBqb2luIHRtc19hcHBfbG9hbm1lcmNoYW50YmF0Y2ggdGFsbWIgb24gdGFsbWIubG9hbl9pZCA9IGxhaS5sb2FuX2lkIGFuZCB0YWxtYi5ib25kX2lkID0gMTYKCXVuaW9uCglzZWxlY3QgdGFsaWZyLmluc3RhbGxtZW50X2lkICBhcyBpZAoJZnJvbSB0bXNfYXBwX2xvYW5pbnN0YWxsbWVudGZ1bmRpbmdyZXF1ZXN0IHRhbGlmcgoJd2hlcmUgdGFsaWZyLm9uYmFsYW5jZSA9IGZhbHNlIGFuZCBhc3NpZ25tZW50X2RheSA8PSB7J2RhdGUnOidkYXRlJ30gCgopLAoKb25fYmFsX2luc3RhbGxtZW50cyBhcyAoCglzZWxlY3QgaWQKCWZyb20gbG9hbl9hcHBfaW5zdGFsbG1lbnQKCWV4Y2VwdAoJc2VsZWN0IGlkCglmcm9tIG9mZl9iYWxfaW5zdGFsbG1lbnRzCikKLAp0YXJnZXRlZF9sb2FucyBhcyAoCnNlbGVjdCBkaXN0aW5jdCBsYWkubG9hbl9pZCBhcyBsb2FuX2lkCmZyb20gbG9hbl9hcHBfaW5zdGFsbG1lbnQgbGFpCmlubmVyIGpvaW4gb25fYmFsX2luc3RhbGxtZW50cyBvYmkgb24gb2JpLmlkID0gbGFpLmlkCgopCiwKcmVtYWluaW5nX3ByaW5jaXBhbCBhcyAoCiAgICBzZWxlY3QgbGFsLmlkLCAgCWNvYWxlc2NlKHN1bShsYWkucHJpbmNpcGFsX2V4cGVjdGVkKSBmaWx0ZXIgKHdoZXJlIG5saWUucHJpbmNpcGFsX3BhaWRfYXQgaXMgbnVsbCBvciBjYXN0KHByaW5jaXBhbF9wYWlkX2F0IGFzIGRhdGUpID4geydkYXRlJzonZGF0ZSd9CiAgICAgICAgIG9yICAgCiAgICAgICAgICggY2FzdChwcmluY2lwYWxfcGFpZF9hdCBhcyBkYXRlKSA8IGxhaS5kYXkgYW5kIChubGllLnBheW1lbnRfc3RhdHVzIG5vdCBpbiAoMiwzLDQsMTYpICBhbmQgbGRzLmJsbmtfc3RhdHVzIG5vdCBpbiAoMSw2LDgsMTUsMTYpIG9yIAogICAgICAgICAobmxpZS5wYXltZW50X3N0YXR1cyA9IDYgICkgKSkKICAgICAgICAgICAgICAgYW5kIHsnZGF0ZSc6J2RhdGUnfSA8IGxhaS5kYXkKICAgICksIDApICBhcyBlbnIsIAogICAgCiAgICBjb2FsZXNjZSggc3VtKGxhaS5wcmluY2lwYWxfZXhwZWN0ZWQpIGZpbHRlciAoIHdoZXJlICBscHMucGF5bWVudF9zdGF0dXMgaW4gKDUsNikgYW5kIG5saWUuaXNfbG9uZ190ZXJtPWZhbHNlIGFuZCAgKG5saWUuc3RhdHVzX2lkIDw+IDcgb3IgKG5saWUuc3RhdHVzX2lkID0gNyBhbmQgKGlzX3ByaW5jaXBhbF9wYWlkPWZhbHNlIG9yIChwcmluY2lwYWxfcGFpZF9hdDo6ZGF0ZSA+IHsnZGF0ZSc6J2RhdGUnfSkpKSkgIGFuZCAoKCggbmxpZS5zdGF0dXNfaWQ9NyBvciBubGllLmxvbmdfdG9fc2hvcnRfdGVybV9kYXRlIDwgeydkYXRlJzonZGF0ZSd9KSBhbmQgbmxpZS5sb25nX3RvX3Nob3J0X3Rlcm1fZGF0ZSA8IHsnZGF0ZSc6J2RhdGUnfSApIG9yIG5saWUubG9uZ190b19zaG9ydF90ZXJtX2RhdGUgaXMgbnVsbCkKICAgICAgICAgICAgKSwwKSBhcyB1bmR1ZV9wcmluY2lwbGUsCiAgICAJCQogICAgCQkKICAgIGNvYWxlc2NlKCBzdW0obGFpLnByaW5jaXBhbF9leHBlY3RlZCkgZmlsdGVyICgKICAgICAgICB3aGVyZSAKICAgICAgICAgICAgICBscHMucGF5bWVudF9zdGF0dXMgPSAwIGFuZCB7J2RhdGUnOidkYXRlJ30gPj0gbmxpZS5kdWVfdG9fb3ZlcmR1ZV9kYXRlIAogICAgICAgICAgICBhbmQgKCgobmxpZS5zdGF0dXNfaWQ9NyBvciBubGllLmxvbmdfdG9fc2hvcnRfdGVybV9kYXRlIDwgeydkYXRlJzonZGF0ZSd9KSBhbmQgbmxpZS5sb25nX3RvX3Nob3J0X3Rlcm1fZGF0ZSA8IHsnZGF0ZSc6J2RhdGUnfSApIG9yIG5saWUubG9uZ190b19zaG9ydF90ZXJtX2RhdGUgaXMgbnVsbCkgYW5kIChpc19wcmluY2lwYWxfcGFpZD1mYWxzZSBvciAocHJpbmNpcGFsX3BhaWRfYXQ6OmRhdGUgPiB7J2RhdGUnOidkYXRlJ30pKQogICAgKSAsMCkgYXMgb3ZlcmR1ZV9wcmluY2lwbGUsCiAgICAKICAgIGNvYWxlc2NlKCBzdW0obGFpLnByaW5jaXBhbF9leHBlY3RlZCkgZmlsdGVyICgKICAgICAgICB3aGVyZSAKICAgICAgICAgICAgIChscHMucGF5bWVudF9zdGF0dXMgPSA0IGFuZCAobmxpZS5pc19wcmluY2lwYWxfcGFpZCA9IGZhbHNlIG9yIG5saWUucHJpbmNpcGFsX3BhaWRfYXQgPiB7J2RhdGUnOidkYXRlJ30pICkgb3IgKGxwcy5wYXltZW50X3N0YXR1cyA9IDAgYW5kIHsnZGF0ZSc6J2RhdGUnfSA8IG5saWUuZHVlX3RvX292ZXJkdWVfZGF0ZSApCi0tICAgIAkpIAogICAgCSkgLDApIGFzIGR1ZV9wcmluY2lwbGUsCiAgICAJCiAgICBjb2FsZXNjZSggCiAgICAJc3VtKGxhaS5wcmluY2lwYWxfZXhwZWN0ZWQpIGZpbHRlciAoIAoJCQl3aGVyZSAKCQkgICAgICAgKG5saWUuaXNfbG9uZ190ZXJtID0gdHJ1ZSBvciAobmxpZS5pc19sb25nX3Rlcm0gPSBmYWxzZSBhbmQgbmxpZS5sb25nX3RvX3Nob3J0X3Rlcm1fZGF0ZSA+PSB7J2RhdGUnOidkYXRlJ30pKSAKCQkJCWFuZCAobmxpZS5pc19wcmluY2lwYWxfcGFpZCA9IGZhbHNlIG9yIGNhc3QobmxpZS5wcmluY2lwYWxfcGFpZF9hdCBhcyBkYXRlKSA+IHsnZGF0ZSc6J2RhdGUnfSApCgkJKSwKCQkwCgkpIGFzIGxvbmdfdGVybV9wcmluY2lwbGUKICAgICAgICAgICAKCgogICAgZnJvbSBsb2FuX2FwcF9sb2FuIGxhbCAKICAgIGlubmVyIGpvaW4gbG9hbl9vbl9kYXlfc3RhdHVzIGxkcyBvbiBsZHMubG9hbl9pZCA9IGxhbC5pZCAgCiAgICBpbm5lciBqb2luIGxvYW5fYXBwX2luc3RhbGxtZW50IGxhaSBvbiBsYWkubG9hbl9pZCA9IGxhbC5pZAogICAgaW5uZXIgam9pbiBsYXRlc3RfcGF5bWVudF9zdGF0dXMgbHBzIG9uIGxwcy5pbnN0YWxsbWVudF9pZCA9IGxhaS5pZCAKICAgIGlubmVyIGpvaW4gbmV3X2xtc19pbnN0YWxsbWVudGV4dGVuc2lvbiBubGllIG9uIG5saWUuaW5zdGFsbG1lbnRfcHRyX2lkICA9IGxhaS5pZAogICAgaW5uZXIgam9pbiBvbl9iYWxfaW5zdGFsbG1lbnRzIG9iaSBvbiBvYmkuaWQgPSBsYWkuaWQKICAgIHdoZXJlIGxkcy5ibG5rX3N0YXR1cyBub3QgaW4gKDEyLDEzKQoKICAgIGdyb3VwIGJ5IGxhbC5pZAoKKQosCnByb3Zpc2lvbnMgYXMgKAoKCXNlbGVjdCBsYWwuaWQsIAljb2FsZXNjZShzdW0obGFpLnByaW5jaXBhbF9leHBlY3RlZCkgZmlsdGVyICh3aGVyZSBubGllLnByaW5jaXBhbF9wYWlkX2F0IGlzIG51bGwgb3IgY2FzdChwcmluY2lwYWxfcGFpZF9hdCBhcyBkYXRlKSA+IHsnZGF0ZSc6J2RhdGUnfQogICAgICAgICBvciAgIAogICAgICAgICAoIGNhc3QocHJpbmNpcGFsX3BhaWRfYXQgYXMgZGF0ZSkgPCBsYWkuZGF5IGFuZCAobmxpZS5wYXltZW50X3N0YXR1cyBub3QgaW4gKDIsMyw0LDE2KSAgYW5kIGxkcy5ibG5rX3N0YXR1cyBub3QgaW4gKDEsNiw4LDE1LDE2KSBvciAKICAgICAgICAgKG5saWUucGF5bWVudF9zdGF0dXMgPSA2IGFuZCBsZHMuYmxua19zdGF0dXMgbm90IGluICgxLDYsOCwxNSwxNikgKSApKQogICAgICAgICAgICAgICBhbmQgeydkYXRlJzonZGF0ZSd9IDwgbGFpLmRheQogICAgKSwgMCkgYXMgZW5yCiAgICAKICAgIGZyb20gbG9hbl9hcHBfbG9hbiBsYWwKCWlubmVyIGpvaW4gbG9hbl9hcHBfaW5zdGFsbG1lbnQgbGFpIG9uIGxhaS5sb2FuX2lkID0gbGFsLmlkCglpbm5lciBqb2luIG5ld19sbXNfaW5zdGFsbG1lbnRleHRlbnNpb24gbmxpZSBvbiBubGllLmluc3RhbGxtZW50X3B0cl9pZCA9IGxhaS5pZAoJaW5uZXIgam9pbiBsb2FuX29uX2RheV9zdGF0dXMgbGRzIG9uIGxkcy5sb2FuX2lkID0gbGFsLmlkCglncm91cCBieSBsYWwuaWQKCikKLAoKCmxhdGVfZmVlcyBhcyAoCglzZWxlY3QgbGFsLmlkLCBzdW0obmxpbGYuYW1vdW50KSBmaWx0ZXIoCgl3aGVyZSBubGlsZi5kYXkgPCB7J2RhdGUnOidkYXRlJ30gYW5kIGxkcy5ibG5rX3N0YXR1cyBub3QgaW4gICg3LDE3KQogICAgYW5kIChubGlsZi5pc19jYW5jZWxsZWQgPSBmYWxzZSBvciBjYXN0KG5saWxmLmNhbmNlbGxhdGlvbl9kYXRlIGFzIGRhdGUpID4geydkYXRlJzonZGF0ZSd9KSAgICAgIGFuZCBubGlsZi5pc19kaXNhYmxlZCA9IGZhbHNlIAogICAgYW5kIChubGlsZi5pc19wYXJ0aWFsbHlfY2FuY2VsbGVkID0gZmFsc2Ugb3IgbmxpbGYucGFydGlhbGx5X2NhbmNlbGxlZF9kYXRlID4geydkYXRlJzonZGF0ZSd9KSAKICAgIGFuZCAobmxpbGYuaXNfcGFpZCA9IGZhbHNlIG9yIGNhc3QobmxpbGYucGFpZF9hdCBhcyBkYXRlKSA+IHsnZGF0ZSc6J2RhdGUnfSkKICAgIClhcyB0b3RhbF9sYXRlX2ZlZXMsIAoKICAgIHN1bShubGlsZi5hbW91bnQpIGZpbHRlciAKICAgICAgICAod2hlcmUgbGRzLmJsbmtfc3RhdHVzIDw+IDcgYW5kICgobmxpbGYuZGF5PHsnZGF0ZSc6J2RhdGUnfSBhbmQgeydkYXRlJzonZGF0ZSd9PCcyMDI1LTA5LTMwJyBhbmQgKHNlbGVjdCBjb3VudCgqKSBmcm9tIGxvYW5fYXBwX2xvYW5zdGF0dXNoaXN0cm95IHdoZXJlIGxvYW5faWQ9bGFsLmlkIGFuZCAKICAgICAgICBzdGF0dXNfdHlwZT0wIGFuZCBkYXkgPD17J2RhdGUnOidkYXRlJ30gYW5kIHN0YXR1c19pZCA9MyBhbmQgZGF5IDwgJzIwMjUtMDktMzAnKSA+MCBhbmQgKG5saWxmLmlzX3BhaWQ9ZmFsc2Ugb3IgbmxpbGYucGFpZF9hdDo6ZGF0ZT57J2RhdGUnOidkYXRlJ30pKSBvciAoKG5saWxmLmlzX21hcmdpbmFsaXplZCA9IHRydWUgCglhbmQgY2FzdChubGlsZi5tYXJnaW5hbGl6YXRpb25fZGF0ZSBhcyBkYXRlKSA8PSB7J2RhdGUnOidkYXRlJ30pICBvciAoCglubGlsZi5pc19tYXJnaW5hbGl6ZWQgPSBmYWxzZSAKCQlhbmQgY2FzdChubGlsZi5tYXJnaW5hbGl6YXRpb25fZGF0ZSBhcyBkYXRlKSBpcyBub3QgbnVsbAoJYW5kIGNhc3QobmxpbGYubWFyZ2luYWxpemF0aW9uX2RhdGUgYXMgZGF0ZSkgPD0geydkYXRlJzonZGF0ZSd9IAogICAgYW5kICBjYXN0KG5saWxmLnVubWFyZ2luYWxpemF0aW9uX2RhdGUgYXMgZGF0ZSkgPiB7J2RhdGUnOidkYXRlJ30pICkpYW5kIChubGlsZi5pc19jYW5jZWxsZWQgPWZhbHNlIG9yIChubGlsZi5pc19jYW5jZWxsZWQgPXRydWUgYW5kIG5saWxmLmNhbmNlbGxhdGlvbl9kYXRlPiB7J2RhdGUnOidkYXRlJ30pKSApCiAgICAgYXMgbWFyZ2luYWxpemVkCglmcm9tIG5ld19sbXNfaW5zdGFsbG1lbnRsYXRlZmVlcyBubGlsZgppbm5lciBqb2luIGxvYW5fYXBwX2luc3RhbGxtZW50IGxhaSBvbiBsYWkuaWQgPSBubGlsZiAuaW5zdGFsbG1lbnRfZXh0ZW5zaW9uX2lkIAppbm5lciBqb2luIGxvYW5fYXBwX2xvYW4gbGFsIG9uIGxhbC5pZCA9IGxhaS5sb2FuX2lkIAppbm5lciBqb2luIG9uX2JhbF9pbnN0YWxsbWVudHMgb2JpIG9uIG9iaS5pZCA9IGxhaS5pZAppbm5lciBqb2luIGxvYW5fb25fZGF5X3N0YXR1cyBsZHMgb24gbGRzLmxvYW5faWQgPSBsYWwuaWQgIAoKZ3JvdXAgYnkgbGFsLmlkCikKLAoKYWNjcnVlZF9pbnRlcmVzdCBhcygKICAgIHNlbGVjdCBsYWkubG9hbl9pZCBhcyBpZCwgc3VtKCgKCQljYXNlIHdoZW4gbmxpZS5wYXltZW50X3N0YXR1cyBpbiAoMCwyKSBhbmQgbmxpZS5wYXJ0aWFsX2FjY3J1YWxfZGF0ZSA8PSB7J2RhdGUnOidkYXRlJ30gdGhlbiAoCgkJCShjYXNlIHdoZW4gbmxpZS5hY2NydWFsX2RhdGUgPD0geydkYXRlJzonZGF0ZSd9IHRoZW4gbmxpZS5hY3R1YWxfYWNjcnVlZF9hbW91bnQgZWxzZSAwIGVuZCkgKyAgbmxpZS5wYXJ0aWFsX2FjY3J1YWxfYW1vdW50IC0gKGNhc2Ugd2hlbiBjYXN0KG5saWUuaW50ZXJlc3RfcGFpZF9hdCBhcyBkYXRlKSA8PSB7J2RhdGUnOidkYXRlJ30gdGhlbiBubGllLmFjdHVhbF9pbnRlcmVzdF9wYWlkIGVsc2UgMCBlbmQpICsgbmxpZS5zZXR0bGVtZW50X2FjY3J1YWxfaW50ZXJlc3RfYW1vdW50ICsgbmxpZS5mYXVsdHlfYWNjcnVlZF9hbW91bnQKCQkJKQoJCQl3aGVuIG5saWUucGF5bWVudF9zdGF0dXMgaW4gKDQpIGFuZCBubGllLnBhcnRpYWxfYWNjcnVhbF9kYXRlIDw9IHsnZGF0ZSc6J2RhdGUnfSB0aGVuIAoJCQkJIChubGllLnBhcnRpYWxfYWNjcnVhbF9hbW91bnQgICsgKGNhc2Ugd2hlbiBubGllLmFjY3J1YWxfZGF0ZSA8PSB7J2RhdGUnOidkYXRlJ30gdGhlbiBubGllLmFjdHVhbF9hY2NydWVkX2Ftb3VudCBlbHNlIDAgZW5kKQoJCQkJICkKCQkJd2hlbiBubGllLnBheW1lbnRfc3RhdHVzIGluICgxKXRoZW4KCQkJCSAoICAKCQkJCSAoY2FzZSB3aGVuIG5saWUucGFydGlhbF9hY2NydWFsX2RhdGUgPD0geydkYXRlJzonZGF0ZSd9IHRoZW4gbmxpZS5wYXJ0aWFsX2FjY3J1YWxfYW1vdW50IGVsc2UgMCBlbmQpIAoJCQkJICsgKGNhc2Ugd2hlbiBubGllLmFjY3J1YWxfZGF0ZSA8PSB7J2RhdGUnOidkYXRlJ30gdGhlbiBubGllLmFjdHVhbF9hY2NydWVkX2Ftb3VudCAtIG5saWUuYWN0dWFsX2ludGVyZXN0X3BhaWQgKyBubGllLmZhdWx0eV9hY2NydWVkX2Ftb3VudCBlbHNlIDAgZW5kKQoJCQkJICkKICAgICAgICAgICAgIHdoZW4gbmxpZS5wYXltZW50X3N0YXR1cyBpbiAoMywxNikgdGhlbiAKICAgICAgICAgICAgIAkJCWNhc2Ugd2hlbiBubGllLnBhcnRpYWxfYWNjcnVhbF9kYXRlIDw9IHsnZGF0ZSc6J2RhdGUnfSB0aGVuIG5saWUucGFydGlhbF9hY2NydWFsX2Ftb3VudCBlbHNlIDAgZW5kIAogICAgICAgICAgICArIChjYXNlIHdoZW4gbmxpZS5hY2NydWFsX2RhdGUgPD0geydkYXRlJzonZGF0ZSd9IHRoZW4gbmxpZS5hY3R1YWxfYWNjcnVlZF9hbW91bnQgZWxzZSAwIGVuZCkKICAgICAgICAgICAgKyBjYXNlIHdoZW4gY2FzdChubGllLnNldHRsZW1lbnRfYWNjcnVhbF9pbnRlcmVzdF9kYXRlIGFzIGRhdGUpIDw9IHsnZGF0ZSc6J2RhdGUnfSB0aGVuIG5saWUuc2V0dGxlbWVudF9hY2NydWFsX2ludGVyZXN0X2Ftb3VudCBlbHNlIDAgZW5kIAogICAgICAgICAgICAtIChjYXNlIHdoZW4gY2FzdChubGllLmludGVyZXN0X3BhaWRfYXQgYXMgZGF0ZSkgPD0geydkYXRlJzonZGF0ZSd9IHRoZW4gbmxpZS5hY3R1YWxfaW50ZXJlc3RfcGFpZCBlbHNlIDAgZW5kKQoKCQllbmQKCQkpKQogICAgICAgICBhcyBhY2NydWVkX2ludGVyZXN0CiAgICAgICAgZnJvbSBsb2FuX2FwcF9pbnN0YWxsbWVudCBsYWkgCmlubmVyIGpvaW4gbmV3X2xtc19pbnN0YWxsbWVudGV4dGVuc2lvbiBubGllIG9uIG5saWUuaW5zdGFsbG1lbnRfcHRyX2lkID0gbGFpLmlkCmlubmVyIGpvaW4gbG9hbl9hcHBfbG9hbiBsYWwgb24gbGFsLmlkID0gbGFpLmxvYW5faWQgCmdyb3VwIGJ5IGxhaS5sb2FuX2lkCikKLAoKZGVjb21wb3NlZF9pbnRlcmVzdHMgYXMoCiAgICBzZWxlY3QgbGFpLmxvYW5faWQgLAoJc3VtKGNhc2Ugd2hlbiBubGllLmR1ZV90b19vdmVyZHVlX2RhdGUgPD0geydkYXRlJzonZGF0ZSd9ICBhbmQgKGxkcy5ibG5rX3N0YXR1cyA8PiA3IG9yICggbGRzLmJsbmtfc3RhdHVzID0gNyBhbmQgbmxpZS5kdWVfdG9fb3ZlcmR1ZV9kYXRlIDwgbGRzLmJsbmtfc3RhdHVzX2RheSkpCgkJYW5kIChubGllLmlzX2ludGVyZXN0X3BhaWQgPSBmYWxzZSBvciBjYXN0KG5saWUuaW50ZXJlc3RfcGFpZF9hdCBhcyBkYXRlKSA+IHsnZGF0ZSc6J2RhdGUnfSkgYW5kIGxkcy5ibG5rX3N0YXR1cyBub3QgaW4gKDYsOCwxMiwxMywxNSwxNikKCQl0aGVuIGxhaS5pbnRlcmVzdF9leHBlY3RlZCArIHJvdW5kKGNhc2Ugd2hlbiBleHRyYV9pbnRlcmVzdF9wYWlkX2F0PD0geydkYXRlJzonZGF0ZSd9IHRoZW4gMCBlbHNlIG5saWUuZmlyc3RfaW5zdGFsbG1lbnRfaW50ZXJlc3RfYWRqdXN0bWVudCBlbmQsMikgZW5kKSBhcyBvdmVyZHVlX2ludGVyZXN0LAoKCglzdW0oY2FzZSB3aGVuIHsnZGF0ZSc6J2RhdGUnfSA+PSBubGllLnVuZHVlX3RvX2R1ZV9kYXRlIGFuZCB7J2RhdGUnOidkYXRlJ30gPD0gIG5saWUuZ3JhY2VfZGF0ZSBhbmQgKG5saWUuaXNfaW50ZXJlc3RfcGFpZCA9IGZhbHNlIG9yIGNhc3QobmxpZS5pbnRlcmVzdF9wYWlkX2F0IGFzIGRhdGUpID4geydkYXRlJzonZGF0ZSd9KSBhbmQgbGRzLmJsbmtfc3RhdHVzIG5vdCBpbiAoNiw4LDEyLDEzLDE1LDE2KSB0aGVuIGxhaS5pbnRlcmVzdF9leHBlY3RlZCArIHJvdW5kKG5saWUuZmlyc3RfaW5zdGFsbG1lbnRfaW50ZXJlc3RfYWRqdXN0bWVudCwyKSAgZWxzZSAwIGVuZCkgYXMgZHVlX25vbnBhaWRfaW50ZXJlc3QKCWZyb20gbG9hbl9hcHBfaW5zdGFsbG1lbnQgbGFpIAoJaW5uZXIgam9pbiBuZXdfbG1zX2luc3RhbGxtZW50ZXh0ZW5zaW9uIG5saWUgb24gbmxpZS5pbnN0YWxsbWVudF9wdHJfaWQgPSBsYWkuaWQKCWlubmVyIGpvaW4gbG9hbl9hcHBfbG9hbiBsYWwgb24gbGFsLmlkID0gbGFpLmxvYW5faWQgCiAgICBpbm5lciBqb2luIGxvYW5fb25fZGF5X3N0YXR1cyBsZHMgb24gbGRzLmxvYW5faWQgPSBsYWwuaWQgCiAgICBpbm5lciBqb2luIG9uX2JhbF9pbnN0YWxsbWVudHMgb2JpIG9uIG9iaS5pZCA9IGxhaS5pZAoKICAgIHdoZXJlIGxkcy5ibG5rX3N0YXR1cyBub3QgaW4gKDcsMTIsMTMpCgoJZ3JvdXAgYnkgbGFpLmxvYW5faWQgCi0tIHNlbGVjdCBsYWkubG9hbl9pZCAsCi0tIAlzdW0oY2FzZSB3aGVuIG5saWUuZHVlX3RvX292ZXJkdWVfZGF0ZSA8PSB7J2RhdGUnOidkYXRlJ30gCi0tIAkJYW5kIChubGllLmlzX2ludGVyZXN0X3BhaWQgPSBmYWxzZSBvciBubGllLmludGVyZXN0X3BhaWRfYXQ6OmRhdGUgPiB7J2RhdGUnOidkYXRlJ30pIGFuZCBsZHMuYmxua19zdGF0dXMgbm90IGluICg2LDgsMTIsMTMsMTUpCi0tIAkJdGhlbiBsYWkuaW50ZXJlc3RfZXhwZWN0ZWQgZW5kKSBhcyBvdmVyZHVlX2ludGVyZXN0LAotLSAJc3VtKAotLSAgICAgICAgIGNhc2UgCi0tICAgICAgICAgICAgIHdoZW4gCi0tICAgICAgICAgICAgICAgICB7J2RhdGUnOidkYXRlJ30gID49IG5saWUudW5kdWVfdG9fZHVlX2RhdGUgYW5kIHsnZGF0ZSc6J2RhdGUnfSA8IG5saWUuZHVlX3RvX292ZXJkdWVfZGF0ZQotLSAgICAgICAgICAgICAgICAgYW5kIChubGllLmlzX2ludGVyZXN0X3BhaWQgPSBmYWxzZSBvciBubGllLmludGVyZXN0X3BhaWRfYXQ6OmRhdGUgPiB7J2RhdGUnOidkYXRlJ30pIAotLSAgICAgICAgICAgICAgICAgYW5kIGxkcy5ibG5rX3N0YXR1cyBub3QgaW4gKDYsNyw4LDEyLDEzLDE1KSAKLS0gICAgICAgICAgICAgdGhlbiBsYWkuaW50ZXJlc3RfZXhwZWN0ZWQgCi0tICAgICAgICAgICAgIGVsc2UgMCAKLS0gICAgICAgICBlbmQKLS0gICAgICkgYXMgZHVlX25vbnBhaWRfaW50ZXJlc3QKLS0gCWZyb20gbG9hbl9hcHBfaW5zdGFsbG1lbnQgbGFpIAotLSAJaW5uZXIgam9pbiBuZXdfbG1zX2luc3RhbGxtZW50ZXh0ZW5zaW9uIG5saWUgb24gbmxpZS5pbnN0YWxsbWVudF9wdHJfaWQgPSBsYWkuaWQKLS0gCWlubmVyIGpvaW4gbG9hbl9hcHBfbG9hbiBsYWwgb24gbGFsLmlkID0gbGFpLmxvYW5faWQgCi0tIAlpbm5lciBqb2luIG9uX2JhbF9pbnN0YWxsbWVudHMgb2JpIG9uIG9iaS5pZCA9IGxhaS5pZAoKLS0gCSAgICBpbm5lciBqb2luIGxvYW5fb25fZGF5X3N0YXR1cyBsZHMgb24gbGRzLmxvYW5faWQgPSBsYWwuaWQgCi0tIAkgICAgd2hlcmUgbGRzLmJsbmtfc3RhdHVzIG5vdCBpbiAoMTIsMTMpCgotLSAJZ3JvdXAgYnkgbGFpLmxvYW5faWQgCikKLAoKdW5kdWVfaW50ZXJlc3QgYXMgKAogICB3aXRoIGluc3RhbGxtZW50c19kZXRhaWxzIGFzICgKCQlzZWxlY3QgCgkJCWxhaS5pZCBhcyAiaW5zdGFsbG1lbnRfaWQiLAoJCQlsYWkubG9hbl9pZCwgCgkJCWxhbC5zdGF0dXNfaWQsIAoJCQlubGkuYWNjcnVhbF9kYXRlLCAKCQkJbGFsLmZpcnN0X2FjY3J1YWxfYWRqdXN0bWVudF9kYXRlLCAKCQkJbmxpLmlzX2V4dHJhX2ludGVyZXN0X3BhaWQsIAoJCQlubGkucGF5bWVudF9zdGF0dXMsIAoJCQlubGkuZmlyc3RfaW5zdGFsbG1lbnRfaW50ZXJlc3RfYWRqdXN0bWVudCwKCQkJbmxpLmFjdHVhbF9pbnRlcmVzdF9wYWlkLAoJCQlubGkuc2V0dGxlbWVudF9hY2NydWFsX2ludGVyZXN0X2Ftb3VudCwKCQkJbmxpLnNldHRsZW1lbnRfYWNjcnVhbF9pbnRlcmVzdF9kYXRlLAoJCQlubGkuZXhwZWN0ZWRfcGFydGlhbF9hY2NydWFsX2Ftb3VudCwKCQkJbGFpLmludGVyZXN0X2V4cGVjdGVkLAoJCQlsYWkuZGF5LAoJCQlubGkuaW50ZXJlc3RfcGFpZF9hdCwKCQkJbmxpLnBhcnRpYWxfYWNjcnVhbF9kYXRlLAoJCQlsYWkuInBlcmlvZCIsCgkJCW5saS5leHBlY3RlZF9hY2NydWFsX2Ftb3VudCwKCQkJbmxpLmV4dHJhX2ludGVyZXN0X3BhaWRfYXQsCgkJCW5saS51bmR1ZV90b19kdWVfZGF0ZQoJCWZyb20gbmV3X2xtc19pbnN0YWxsbWVudGV4dGVuc2lvbiBubGkKCQlpbm5lciBqb2luIGxvYW5fYXBwX2luc3RhbGxtZW50IGxhaSBvbiBubGkuaW5zdGFsbG1lbnRfcHRyX2lkID0gbGFpLmlkCgkJaW5uZXIgam9pbiBsb2FuX2FwcF9sb2FuIGxhbCBvbiBsYWwuaWQgPSBsYWkubG9hbl9pZCAKICAgIGlubmVyIGpvaW4gb25fYmFsX2luc3RhbGxtZW50cyBvYmkgb24gb2JpLmlkID0gbGFpLmlkCgoJKQogICAgLAogICBpbml0X2FjY3J1YWwgYXMoCiAgICAgICAgc2VsZWN0IGluc3RhbGxtZW50c19kZXRhaWxzLmxvYW5faWQgbGFsaWQxLCBzdW0oZmlyc3RfaW5zdGFsbG1lbnRfaW50ZXJlc3RfYWRqdXN0bWVudCkgZmlyc3RfYWNjcnVhbF9hZGp1c3RtZW50CiAgICAgICAgZnJvbSBpbnN0YWxsbWVudHNfZGV0YWlscyAKICAgICAgICBpbm5lciBqb2luIGxhdGVzdF9wYXltZW50X3N0YXR1cyBscHMgb24gbHBzLmluc3RhbGxtZW50X2lkID0gaW5zdGFsbG1lbnRzX2RldGFpbHMuImluc3RhbGxtZW50X2lkIgogICAgICAgIGlubmVyIGpvaW4gbG9hbl9vbl9kYXlfc3RhdHVzIGxvZHMgb24gaW5zdGFsbG1lbnRzX2RldGFpbHMubG9hbl9pZCA9IGxvZHMubG9hbl9pZAogICAgICAgIHdoZXJlIAogICAgICAgIChscHMucGF5bWVudF9zdGF0dXMgaW4gKDUsNikgb3IobHBzLnBheW1lbnRfc3RhdHVzIGluICg0LDcpIGFuZCBsb2RzLmJsbmtfc3RhdHVzIGluICgxMSwxNCw3LDE1KSBhbmQgYWNjcnVhbF9kYXRlID4geydkYXRlJzonZGF0ZSd9KSBvciAobHBzLnBheW1lbnRfc3RhdHVzPTEwIGFuZCAgZXh0cmFfaW50ZXJlc3RfcGFpZF9hdDo6ZGF0ZSA+IHsnZGF0ZSc6J2RhdGUnfSkgb3IgKGxwcy5wYXltZW50X3N0YXR1cyBpbiAoMywxNikgYW5kIGFjY3J1YWxfZGF0ZSA+IHsnZGF0ZSc6J2RhdGUnfSBhbmQgZXh0cmFfaW50ZXJlc3RfcGFpZF9hdDo6ZGF0ZSA+IHsnZGF0ZSc6J2RhdGUnfSkpIGFuZCBmaXJzdF9pbnN0YWxsbWVudF9pbnRlcmVzdF9hZGp1c3RtZW50ID4gMAogICAgICAgIGFuZCAobG9kcy5ibG5rX3N0YXR1cyBub3QgaW4gKDgsMTUsMTYpIG9yIChsb2RzLmJsbmtfc3RhdHVzIGluICg4LDE1LDE2KSBhbmQgaXNfZXh0cmFfaW50ZXJlc3RfcGFpZCA9IHRydWUgYW5kIGV4dHJhX2ludGVyZXN0X3BhaWRfYXQ6OmRhdGUgPiB7J2RhdGUnOidkYXRlJ30pKSBhbmQgZmlyc3RfYWNjcnVhbF9hZGp1c3RtZW50X2RhdGUgPD0geydkYXRlJzonZGF0ZSd9CiAgICAgICAgYW5kIChwYXJ0aWFsX2FjY3J1YWxfZGF0ZSA+IHsnZGF0ZSc6J2RhdGUnfSBvciAocGFydGlhbF9hY2NydWFsX2RhdGUgPSB7J2RhdGUnOidkYXRlJ30gYW5kIEVYVFJBQ1QoJ0RBWScgRlJPTSB1bmR1ZV90b19kdWVfZGF0ZSkgPSAxKSkgIGFuZCBscHMucGF5bWVudF9zdGF0dXMgbm90IGluICgxMiwxMykKICAgICAgICBncm91cCBieSBpbnN0YWxsbWVudHNfZGV0YWlscy5sb2FuX2lkCiAgICApCiAgICAsCiAgICBuZXh0X2luc3QgYXMoCiAgICAgICAgc2VsZWN0IGxhbGlkMywgaW5zdHMgZnJvbSAoCiAgICAgICAgICAgIHNlbGVjdCBubGkubG9hbl9pZCBsYWxpZDMsIChleHBlY3RlZF9hY2NydWFsX2Ftb3VudCkgaW5zdHMsIGxvZHMuYmxua19zdGF0dXMgc3RhdHVzX29uX2RheSwKICAgICAgICAgICAgKHNlbGVjdCBzdGF0dXMgZnJvbSBuZXdfbG1zX2luc3RhbGxtZW50cGF5bWVudHN0YXR1c2hpc3Rvcnkgd2hlcmUgaW5zdGFsbG1lbnRfZXh0ZW5zaW9uX2lkPW5saS5pbnN0YWxsbWVudF9pZCBhbmQgZGF5IDw9eydkYXRlJzonZGF0ZSd9IG9yZGVyIGJ5IGlkIGRlc2MgbGltaXQgMSkgYXMgbGFzdF9zdGF0dXMsCiAgICAgICAgICAgIHVuZHVlX3RvX2R1ZV9kYXRlLCBpbnRlcmVzdF9wYWlkX2F0CiAgICAgICAgICAgIGZyb20gaW5zdGFsbG1lbnRzX2RldGFpbHMgbmxpCiAgICAgICAgICAgIGlubmVyIGpvaW4gbG9hbl9vbl9kYXlfc3RhdHVzIGxvZHMgb24gbmxpLmxvYW5faWQgPSBsb2RzLmxvYW5faWQKICAgICAgICAgICAgd2hlcmUgYWNjcnVhbF9kYXRlID0geydkYXRlJzonZGF0ZSd9IAogICAgICAgICAgICBhbmQgKGxvZHMuYmxua19zdGF0dXMgbm90IGluICgxNSw3KSAKICAgICAgICAgICAgICAgIG9yIChsb2RzLmJsbmtfc3RhdHVzID0gMTUgYW5kIChzZXR0bGVtZW50X2FjY3J1YWxfaW50ZXJlc3RfYW1vdW50ID0gMCBvciBzZXR0bGVtZW50X2FjY3J1YWxfaW50ZXJlc3RfYW1vdW50IDw+IDAgYW5kIHNldHRsZW1lbnRfYWNjcnVhbF9pbnRlcmVzdF9kYXRlOjpkYXRlID4geydkYXRlJzonZGF0ZSd9KSkKICAgICAgICAgICAgICAgIG9yIChsb2RzLmJsbmtfc3RhdHVzID0gNyBhbmQgIGxvZHMuYmxua19zdGF0dXNfZGF5ID4gYWNjcnVhbF9kYXRlICkKICAgICAgICApICkgcyAKICAgICAgICB3aGVyZSBsYXN0X3N0YXR1cyBub3QgaW4gKDEsMiwzLDcsMTIpIAogICAgICAgIG9yIAogICAgICAgIChsYXN0X3N0YXR1cyA9IDIgCiAgICAgICAgCWFuZCAoaW50ZXJlc3RfcGFpZF9hdDo6ZGF0ZSA8IHVuZHVlX3RvX2R1ZV9kYXRlIG9yIChpbnRlcmVzdF9wYWlkX2F0IGlzIG51bGwgYW5kIHN0YXR1c19vbl9kYXkgPD4xNSkpCiAgICAgICAgKQogICAgICAgIG9yIChsYXN0X3N0YXR1cyA9IDcgYW5kIChzZWxlY3Qgc3RhdHVzX2lkIGZyb20gbG9hbl9hcHBfbG9hbiB3aGVyZSBpZCA9IGxhbGlkMykgPD4xNSkKICAgICkKICAgICwKICAgIG5leHRfcGFydGlhbF9vbmx5IGFzICgKICAgICAgICBzZWxlY3QgbGFsaWQ0LCBpbnN0cyBmcm9tICgKICAgICAgICBzZWxlY3QgbmxpLmxvYW5faWQgbGFsaWQ0LCBleHBlY3RlZF9wYXJ0aWFsX2FjY3J1YWxfYW1vdW50ICsgKGNhc2Ugd2hlbiBubGkuaXNfZXh0cmFfaW50ZXJlc3RfcGFpZD10cnVlIGFuZCBubGkuZXh0cmFfaW50ZXJlc3RfcGFpZF9hdDo6ZGF0ZSA8PXsnZGF0ZSc6J2RhdGUnfSB0aGVuIDAgZWxzZSAKICAgICAgICByb3VuZChmaXJzdF9pbnN0YWxsbWVudF9pbnRlcmVzdF9hZGp1c3RtZW50LDIpIGVuZCkgaW5zdHMsCiAgICAgICAgKHNlbGVjdCBzdGF0dXMgZnJvbSBuZXdfbG1zX2luc3RhbGxtZW50cGF5bWVudHN0YXR1c2hpc3Rvcnkgd2hlcmUgaW5zdGFsbG1lbnRfZXh0ZW5zaW9uX2lkPW5saS5pbnN0YWxsbWVudF9pZCBhbmQgZGF5IDw9eydkYXRlJzonZGF0ZSd9IG9yZGVyIGJ5IGlkIGRlc2MgbGltaXQgMSkgYXMgbGFzdF9zdGF0dXMsCiAgICAgICAgdW5kdWVfdG9fZHVlX2RhdGUsIGludGVyZXN0X3BhaWRfYXQKICAgICAgICBmcm9tIGluc3RhbGxtZW50c19kZXRhaWxzIG5saQogICAgICAgIGlubmVyIGpvaW4gbG9hbl9vbl9kYXlfc3RhdHVzIGxvZHMgb24gbmxpLmxvYW5faWQgPSBsb2RzLmxvYW5faWQKICAgICAgICB3aGVyZSAKICAgICAgICAJKHNlbGVjdCBubGlzaC5zdGF0dXNfaWQgZnJvbSBuZXdfbG1zX2luc3RhbGxtZW50c3RhdHVzaGlzdG9yeSBubGlzaCB3aGVyZSBubGlzaC5pbnN0YWxsbWVudF9pZCAgPSBubGkuaW5zdGFsbG1lbnRfaWQgYW5kIGRheSA8PSB7J2RhdGUnOidkYXRlJ30gYW5kIHN0YXR1c190eXBlID0gMSBvcmRlciBieSBpZCBkZXNjIGxpbWl0IDEpICA8PiA3CiAgICAgICAgICAgIGFuZCBwYXJ0aWFsX2FjY3J1YWxfZGF0ZSA8PSB7J2RhdGUnOidkYXRlJ30gIAogICAgICAgICAgICBhbmQgZGF5ID4gY2FzdCh7J2RhdGUnOidkYXRlJ30gYXMgZGF0ZSkgKyBpbnRlcnZhbCAnMSBkYXknCiAgICAgICAgICAgIGFuZCAobG9kcy5ibG5rX3N0YXR1cyA8PiAxNSBvciAobG9kcy5ibG5rX3N0YXR1cyA9IDE1IAogICAgICAgICAgICAJYW5kIChzZXR0bGVtZW50X2FjY3J1YWxfaW50ZXJlc3RfYW1vdW50ID0gMCBvciBzZXR0bGVtZW50X2FjY3J1YWxfaW50ZXJlc3RfYW1vdW50IDw+IDAgYW5kIGNhc3Qoc2V0dGxlbWVudF9hY2NydWFsX2ludGVyZXN0X2RhdGUgYXMgZGF0ZSkgPiB7J2RhdGUnOidkYXRlJ30pKQogICAgICAgIAkJKSAKICAgICAgICAgICAgKQogICAgICAgICAgICBzIHdoZXJlIGxhc3Rfc3RhdHVzIG5vdCBpbiAoMSwyLDMsNywxMikgCiAgICAgICAgICAgIG9yIChsYXN0X3N0YXR1cyA9IDIgCiAgICAgICAgICAgICAgICBhbmQgKGNhc3QoaW50ZXJlc3RfcGFpZF9hdCBhcyBkYXRlKSA8IHVuZHVlX3RvX2R1ZV9kYXRlIG9yIChpbnRlcmVzdF9wYWlkX2F0IGlzIG51bGwgYW5kIChzZWxlY3QgYmxua19zdGF0dXMgZnJvbSBsb2FuX29uX2RheV9zdGF0dXMgd2hlcmUgbG9hbl9pZCA9IGxhbGlkNCkgPD4xNSkpKQogICAgICAgICAgICBvciAobGFzdF9zdGF0dXMgPSA3IGFuZCAoc2VsZWN0IGJsbmtfc3RhdHVzIGZyb20gbG9hbl9vbl9kYXlfc3RhdHVzIHdoZXJlIGxvYW5faWQgPSBsYWxpZDQpIDw+MTUpCiAgICApCiAgICAsCiAgICBvbGRfZmlyc3RfYWNjcnVhbF9pbl9wYXJ0aWFsIGFzKAogICAgIHNlbGVjdCBsYWxpZDUsIGluc3RzIGZyb20gKAogICAgICAgIHNlbGVjdCBsb2FuX2lkIGxhbGlkNSwgKGV4cGVjdGVkX3BhcnRpYWxfYWNjcnVhbF9hbW91bnQpIGluc3RzLAogICAgICAgIChzZWxlY3Qgc3RhdHVzIGZyb20gbmV3X2xtc19pbnN0YWxsbWVudHBheW1lbnRzdGF0dXNoaXN0b3J5IHdoZXJlIGluc3RhbGxtZW50X2V4dGVuc2lvbl9pZD1ubGkuaW5zdGFsbG1lbnRfaWQgYW5kIGRheSA8PXsnZGF0ZSc6J2RhdGUnfSBvcmRlciBieSBpZCBkZXNjIGxpbWl0IDEpIGFzIGxhc3Rfc3RhdHVzCiAgICAgICAgZnJvbSBpbnN0YWxsbWVudHNfZGV0YWlscyBubGkKICAgICAgICB3aGVyZSBhY2NydWFsX2RhdGUgPSB7J2RhdGUnOidkYXRlJ30gYW5kIGV4cGVjdGVkX3BhcnRpYWxfYWNjcnVhbF9hbW91bnQgPD4gMCBhbmQgKHN0YXR1c19pZCBub3QgaW4gKDgsMTYpIG9yIChzdGF0dXNfaWQgaW4gKDgsMTYpIGFuZCBwYXltZW50X3N0YXR1cyBub3QgaW4gKDMsMTYpKSkgIAogICAgCSkgcyB3aGVyZSBsYXN0X3N0YXR1cyBub3QgaW4gKDEyLDEzKQogICAgKQoKICAgIAogICAgU0VMRUNUICBsb2FuLCBzdW0odW5kdWVfYmFsYW5jZSkgYXMgdW5kdWVfYmFsYW5jZQogICAgRlJPTSggCiAgICAgICAgc2VsZWN0IGxhbGlkMSBsb2FuLCBmaXJzdF9hY2NydWFsX2FkanVzdG1lbnQgdW5kdWVfYmFsYW5jZSBmcm9tIGluaXRfYWNjcnVhbAogICAgICAgIFVOSU9OIEFMTAogICAgICAgIHNlbGVjdCBsYWxpZDMgbG9hbiwgaW5zdHMgdW5kdWVfYmFsYW5jZSBmcm9tIG5leHRfaW5zdAogICAgICAgIFVOSU9OIEFMTAogICAgICAgIHNlbGVjdCBsYWxpZDQgbG9hbiwgaW5zdHMgdW5kdWVfYmFsYW5jZSBmcm9tIG5leHRfcGFydGlhbF9vbmx5CiAgICAgICAgVU5JT04gQUxMCiAgICAgICAgc2VsZWN0IGxhbGlkNSBsb2FuLCBpbnN0cyB1bmR1ZV9iYWxhbmNlIGZyb20gb2xkX2ZpcnN0X2FjY3J1YWxfaW5fcGFydGlhbAogICAgKSBzIGdyb3VwIGJ5IHMubG9hbgogICAgICAgIAopCgoKLCAgICAgCm1hcmdpbmFsaXplZF9pbnRlcmVzdCBhcygKICAgICBzZWxlY3QgbGFpLmxvYW5faWQgLCAKICAgICBzdW0oCiAgICAgICAgY2FzZSAKICAgICAgICAgICAgLS0gdGhlIGZpcnN0IDIgbGluZXMgaGVyZSBhcmUgdG8gZ2V0IGFsbCB0aGUgbWFyZ2luYWxpemF0aW9uIHRoYXQgd2FzIGRvbmUgYmVmb3JlIGFwcGx5aW5nIDkwIGRheXMgbWFyZ2luYWxpemF0aW9uIG9uIDMwLTA5LTIwMjUKICAgICAgICAgICAgd2hlbiBsZHMuYmxua19zdGF0dXMgPiAyIGFuZCBsYWkuZGF5IDw9eydkYXRlJzonZGF0ZSd9IGFuZCB7J2RhdGUnOidkYXRlJ30gPCAnMjAyNS0wOS0zMCcgYW5kIChubGllLmlzX2ludGVyZXN0X3BhaWQ9ZmFsc2Ugb3IgbmxpZS5pbnRlcmVzdF9wYWlkX2F0OjpkYXRlID4geydkYXRlJzonZGF0ZSd9KSB0aGVuIGxhaS5pbnRlcmVzdF9leHBlY3RlZCArIHJvdW5kKG5saWUuZmlyc3RfaW5zdGFsbG1lbnRfaW50ZXJlc3RfYWRqdXN0bWVudCwyKQogICAgICAgICAgICB3aGVuIG5saWUucGFydGlhbF9hY2NydWFsX2RhdGU8PXsnZGF0ZSc6J2RhdGUnfSBhbmQgbGFpLmRheSA+IHsnZGF0ZSc6J2RhdGUnfSBhbmQgbGRzLmJsbmtfc3RhdHVzID4gMiBhbmQgeydkYXRlJzonZGF0ZSd9IDwgJzIwMjUtMDktMzAnIGFuZCAobmxpZS5pc19pbnRlcmVzdF9wYWlkPWZhbHNlIG9yIG5saWUuaW50ZXJlc3RfcGFpZF9hdDo6ZGF0ZSA+IHsnZGF0ZSc6J2RhdGUnfSkgdGhlbiBleHBlY3RlZF9wYXJ0aWFsX2FjY3J1YWxfYW1vdW50CiAgICAgICAgICAgIHdoZW4gaXNfbWFyZ2luYWxpemVkPXRydWUgYW5kIG1hcmdpbmFsaXphdGlvbl9kYXRlIDw9IHsnZGF0ZSc6J2RhdGUnfSAgdGhlbiBsYWkuaW50ZXJlc3RfZXhwZWN0ZWQgKyByb3VuZChubGllLmZpcnN0X2luc3RhbGxtZW50X2ludGVyZXN0X2FkanVzdG1lbnQsMikKICAgICAgICAgICAgd2hlbiBpc19wYXJ0aWFsbHlfbWFyZ2luYWxpemVkPXRydWUgYW5kIHBhcnRpYWxfbWFyZ2luYWxpemF0aW9uX2RhdGUgPD0geydkYXRlJzonZGF0ZSd9IHRoZW4gZXhwZWN0ZWRfcGFydGlhbF9hY2NydWFsX2Ftb3VudCAKICAgICAgICAgICAgd2hlbiBpc19tYXJnaW5hbGl6ZWQ9ZmFsc2UgYW5kIG1hcmdpbmFsaXphdGlvbl9kYXRlIDw9IHsnZGF0ZSc6J2RhdGUnfSBhbmQgdW5tYXJnaW5hbGl6YXRpb25fZGF0ZSA+IHsnZGF0ZSc6J2RhdGUnfSB0aGVuIGxhaS5pbnRlcmVzdF9leHBlY3RlZCArIHJvdW5kKG5saWUuZmlyc3RfaW5zdGFsbG1lbnRfaW50ZXJlc3RfYWRqdXN0bWVudCwyKQogICAgICAgICAgICB3aGVuIGlzX3BhcnRpYWxseV9tYXJnaW5hbGl6ZWQ9ZmFsc2UgYW5kIHBhcnRpYWxfbWFyZ2luYWxpemF0aW9uX2RhdGUgPD0geydkYXRlJzonZGF0ZSd9IGFuZCB1bm1hcmdpbmFsaXphdGlvbl9kYXRlID4geydkYXRlJzonZGF0ZSd9IHRoZW4gZXhwZWN0ZWRfcGFydGlhbF9hY2NydWFsX2Ftb3VudCAKICAgICAgICAgICAgZWxzZSAwIAogICAgICAgIGVuZAogICAgIClhcyBtYXJnaW5hbGl6ZWRfaW50ZXJlc3QKLS0gICAgICBzdW0oCi0tIAkoCi0tICAgICBjYXNlIHdoZW4gbmxpZS5wYXJ0aWFsX21hcmdpbmFsaXphdGlvbl9kYXRlIGlzIG5vdCBudWxsIGFuZCAobmxpZS5pc19wYXJ0aWFsbHlfbWFyZ2luYWxpemVkICA9IHRydWUgb3IgbmxpZS51bm1hcmdpbmFsaXphdGlvbl9kYXRlOjpkYXRlID4geydkYXRlJzonZGF0ZSd9KSBhbmQgbmxpZS5wYXJ0aWFsX21hcmdpbmFsaXphdGlvbl9kYXRlOjpkYXRlIDwgeydkYXRlJzonZGF0ZSd9Ci0tICAgICB0aGVuIG5saWUucGFydGlhbF9hY2NydWFsX2Ftb3VudCBlbHNlIDAgZW5kCi0tICAgICApCi0tICAgICArKAotLSAgICAgY2FzZSB3aGVuIG5saWUubWFyZ2luYWxpemF0aW9uX2RhdGUgaXMgbm90IG51bGwgYW5kIChubGllLmlzX21hcmdpbmFsaXplZCA9IHRydWUgb3IgbmxpZS51bm1hcmdpbmFsaXphdGlvbl9kYXRlOjpkYXRlID4geydkYXRlJzonZGF0ZSd9KSBhbmQgbmxpZS5tYXJnaW5hbGl6YXRpb25fZGF0ZTo6ZGF0ZSA8IHsnZGF0ZSc6J2RhdGUnfQotLSAgICAgdGhlbiBubGllLmFjdHVhbF9hY2NydWVkX2Ftb3VudCArICgKLS0gICAgICAgICBjYXNlIHdoZW4gKG5saWUucGFydGlhbF9tYXJnaW5hbGl6YXRpb25fZGF0ZTo6ZGF0ZSBpcyBudWxsIG9yIG5saWUudW5tYXJnaW5hbGl6YXRpb25fZGF0ZTo6ZGF0ZSA8IG5saWUubWFyZ2luYWxpemF0aW9uX2RhdGUpIGFuZCBubGllLmlzX3BhcnRpYWxseV9tYXJnaW5hbGl6ZWQgPSBGYWxzZSAKLS0gICAgIHRoZW4gbmxpZS5wYXJ0aWFsX2FjY3J1YWxfYW1vdW50IGVsc2UgMCBlbmQKLS0gICAgICkgZWxzZSAwIGVuZCAKLS0gICAgICkKLS0gKSBhcyBtYXJnaW5hbGl6ZWRfaW50ZXJlc3QKICAgICAgICBmcm9tIGxvYW5fYXBwX2luc3RhbGxtZW50IGxhaSAKICAgICAgICBpbm5lciBqb2luIG5ld19sbXNfaW5zdGFsbG1lbnRleHRlbnNpb24gbmxpZSBvbiBubGllLmluc3RhbGxtZW50X3B0cl9pZCA9IGxhaS5pZAogICAgICAgIGlubmVyIGpvaW4gb25fYmFsX2luc3RhbGxtZW50cyBvYmkgb24gb2JpLmlkID0gbGFpLmlkCiAgICAgICAgaW5uZXIgam9pbiBsb2FuX29uX2RheV9zdGF0dXMgbGRzIG9uIGxkcy5sb2FuX2lkID0gbGFpLmxvYW5faWQgCiAgICAgICAgd2hlcmUgbGRzLmJsbmtfc3RhdHVzIDw+IDcKCmdyb3VwIGJ5IGxhaS5sb2FuX2lkCikKLAoKCgptYWluX3F1ZXJ5IGFzICgKc2VsZWN0IGxhbC5pZCAgCiwKLS0gKGNhc2Ugd2hlbiBsZHMuYmxua19zdGF0dXM9NyB0aGVuIGNvYWxlc2NlKHJwLmVuciwwKSBlbHNlCihjb2FsZXNjZSgoY29hbGVzY2UocnAudW5kdWVfcHJpbmNpcGxlLDApK2NvYWxlc2NlKHJwLm92ZXJkdWVfcHJpbmNpcGxlLDApK2NvYWxlc2NlKHJwLmR1ZV9wcmluY2lwbGUsMCkrY29hbGVzY2UocnAubG9uZ190ZXJtX3ByaW5jaXBsZSwwKSksMCkpYXMgRU5SLCAKY29hbGVzY2UocnAudW5kdWVfcHJpbmNpcGxlLDApIGFzICJMb2FucyByZWNlaXZhYmxlIHVuZHVlLCAoZ3Jvc3MpIiwKY29hbGVzY2UocnAub3ZlcmR1ZV9wcmluY2lwbGUsMCkgYXMgIkxvYW5zIHJlY2VpdmFibGUgb3ZlcmR1ZSwgKGdyb3NzKSIsCmNvYWxlc2NlKHJwLmR1ZV9wcmluY2lwbGUsMCkgYXMgIkxvYW5zIHJlY2VpdmFibGUgZHVlLCAoZ3Jvc3MpIiwKY29hbGVzY2UocnAubG9uZ190ZXJtX3ByaW5jaXBsZSwwKSBhcyAiTG9uZyB0ZXJtIGxvYW5zIHJlY2VpdmFibGVzIiwKY29hbGVzY2UoZGkuZHVlX25vbnBhaWRfaW50ZXJlc3QsMCkgYXMgIkFjY3J1ZWQgaW50ZXJlc3QgaW5jb21lIHJlY2VpdmFibGUsIGR1ZSAoZ3Jvc3MpIiwKY29hbGVzY2UodWkudW5kdWVfYmFsYW5jZSwwKSBhcyAiQWNjcnVlZCBpbnRlcmVzdCBpbmNvbWUgcmVjZWl2YWJsZSwgdW5kdWUgKGdyb3NzKSIsIApjb2FsZXNjZShtaS5tYXJnaW5hbGl6ZWRfaW50ZXJlc3QsMCkgYXMgIk1hcmdpbmFsaXplZCBpbnRlcmVzdCBpbmNvbWUgcmVjZWl2YWJsZSIsCmNvYWxlc2NlKGxmLnRvdGFsX2xhdGVfZmVlcywwKSBhcyB0b3RhbF9sYXRlX2ZlZXMsIApjb2FsZXNjZShsZi5tYXJnaW5hbGl6ZWQsMCkgYXMgIk1hcmdpbmFsaXplZCBsYXRlIHJlcGF5bWVudCBmZWUgaW5jb21lIHJlY2VpdmFibGUiLApyb3VuZChsYXAucGVyY2VudGFnZSAqIGNvYWxlc2NlKChjb2FsZXNjZShycC51bmR1ZV9wcmluY2lwbGUsMCkrY29hbGVzY2UocnAub3ZlcmR1ZV9wcmluY2lwbGUsMCkrY29hbGVzY2UocnAuZHVlX3ByaW5jaXBsZSwwKStjb2FsZXNjZShycC5sb25nX3Rlcm1fcHJpbmNpcGxlLDApKSwwKSAvIDEwMCwyKSBhcyAiSW1wYWlybWVudCBwcm92aXNpb25zLCBPbi1iYWxhbmNlIHNoZWV0IiwgCmNvYWxlc2NlKGRpLm92ZXJkdWVfaW50ZXJlc3QsMCkgYXMgIkFjY3J1ZWQgaW50ZXJlc3QgaW5jb21lIHJlY2VpdmFibGUsIG92ZXJkdWUgKGdyb3NzKSIsCmxhbHNiLm5hbWUgYXMgYmxua19zdGF0dXMsIApsYWxzZi5uYW1lIGFzIGZyYV9zdGF0dXMsIApsYWwucHJpbmNpcGxlIGFzIGxvYW5fYW1vdW50LCAKbGFsLnllYXJseV9pbnRlcmVzdCwgCmxhbC5sb2FuX2Jvb2tpbmdfZGF5LApsYWwucGVyaW9kX2luc3RhbGxtZW50LCAKbGFsLm51bV9tb250aHMsCi0tY2FzZSB3aGVuIHRhbG1iLmJvbmRfaWQgPSAxNSB0aGVuICdzZWN1cml0aXplZCcgd2hlbiB0YWxtYi5ib25kX2lkID0gMTYgdGhlbiAnQlYnIGVsc2UgJ09uIEJhbGFuY2UnIGVuZCBhcyBwb3J0Zm9saW8sCmNhYy5pZCBhcyBjdXN0b21lciwgCmNhc2Ugd2hlbiBjYWMubGltaXRfc291cmNlID0gMSB0aGVuICdCYW5rZWQnIHdoZW4gY2FjLmxpbWl0X3NvdXJjZSA9IDIgdGhlbiAnVW5iYW5rZWQnIGVuZCBhcyBsaW1pdF9zb3VyY2UsCmNvbmNhdChjYWMuZmlyc3RfbmFtZSwnICcsY2FjLmxhc3RfbmFtZSkgYXMgY3VzdG9tZXJfbmFtZSwgCmNhYy5waG9uZV9udW1iZXIsIApubGxjLnN0YXJ0aW5nX2RheV9vZl90aGVfbW9udGggYXMgY3ljbGVfZGF5LCAKY2Fjci5uYW1lIGFzIHJhbmsKLCBjYW0zLm5hbWVfYXIgYXMgcHJvZHVjdF90eXBlIApmcm9tIGxvYW5fYXBwX2xvYW4gbGFsCmlubmVyIGpvaW4gdGFyZ2V0ZWRfbG9hbnMgdGwgb24gdGwubG9hbl9pZCA9IGxhbC5pZAoKaW5uZXIgam9pbiBsb2FuX29uX2RheV9zdGF0dXMgbGRzIG9uIGxkcy5sb2FuX2lkID0gbGFsLmlkIApsZWZ0IGpvaW4gbG9hbl9hcHBfbG9hbnN0YXR1cyBsYWxzYiBvbiBsYWxzYi5pZCA9IGxkcy5ibG5rX3N0YXR1cyAKbGVmdCBqb2luIGxvYW5fYXBwX2xvYW5zdGF0dXMgbGFsc2Ygb24gbGFsc2YuaWQgPSBsZHMuZnJhX3N0YXR1cyAKaW5uZXIgam9pbiBjcm1fYXBwX2N1c3RvbWVyIGNhYyBvbiBjYWMuaWQgPSBsYWwuY3VzdG9tZXJfaWQgCmlubmVyIGpvaW4gbmV3X2xtc19sb2FuY3ljbGUgbmxsYyBvbiBubGxjLmlkID0gY2FjLmZpcnN0X2xvYW5fY3ljbGVfaWQKaW5uZXIgam9pbiBjcm1fYXBwX2N1c3RvbWVycmFuayBjYWNyIG9uIGNhY3IuaWQgPSBjYWMucmFua19pZAppbm5lciBqb2luIGxvYW5fYXBwX3Byb3Zpc2lvbiBsYXAgb24gbGFwLnN0YXR1c19pZCA9IGxkcy5mcmFfc3RhdHVzCmxlZnQgam9pbiBjcm1fYXBwX21lcmNoYW50IGNhbTIgb24gY2FtMi5pZCA9IGxhbC5tZXJjaGFudF9pZApsZWZ0IGpvaW4gY3JtX2FwcF9tZXJjaGFudGNhdGVnb3J5IGNhbTMgb24gY2FtMy5pZCA9IGNhbTIuY2F0ZWdvcnlfaWQKbGVmdCBqb2luIHRtc19hcHBfbG9hbm1lcmNoYW50YmF0Y2ggdGFsbWIgb24gdGFsbWIubG9hbl9pZCA9IGxhbC5pZApsZWZ0IGpvaW4gcmVtYWluaW5nX3ByaW5jaXBhbCBycCBvbiBycC5pZCA9IGxhbC5pZApsZWZ0IGpvaW4gbGF0ZV9mZWVzIGxmIG9uIGxmLmlkID0gbGFsLmlkCi0tbGVmdCBqb2luIGFjY3J1ZWRfaW50ZXJlc3QgYWkgb24gYWkuaWQgPSBsYWwuaWQKbGVmdCBqb2luIHVuZHVlX2ludGVyZXN0IHVpIG9uIHVpLmxvYW4gPSBsYWwuaWQgCmxlZnQgam9pbiBtYXJnaW5hbGl6ZWRfaW50ZXJlc3QgbWkgb24gbWkubG9hbl9pZCA9IGxhbC5pZApsZWZ0IGpvaW4gZGVjb21wb3NlZF9pbnRlcmVzdHMgZGkgb24gZGkubG9hbl9pZCA9IGxhbC5pZAp3aGVyZSAgbGFsLmxvYW5fYm9va2luZ19kYXkgPD0geydkYXRlJzonZGF0ZSd9IC0tIGFuZCBsYWwuaWQgPSA4MjY1MQphbmQgbGRzLmJsbmtfc3RhdHVzIGluICgxLDIsMyw0LDUsNyw5LDEwLDExLDE0KQpvcmRlciBieSBsYWwuaWQKKQoKc2VsZWN0ICogZnJvbSBtYWluX3F1ZXJ5Ci0tICB3aGVyZSBpZD03MDk1NgoKLS0gd2hlcmUgaWQ9NTYxMTIKCi0tIHdoZXJlIGlkPTY0MjQxCgotLSB3aGVyZSBpZD05NDgwNAotLSB3aGVyZSBpZCBpbiAoODQ2ODIsODU4MDYsOTkxOTQsMTAwMTI5LDEwMjMyMywxMDIzOTEsMTAyNDM5LDEwNDMzNSwxMjQ2NDUsOTM3NzMsOTQ4MDQpCgoKCgoKLS13aGVyZSBlbnIgPD4gMCBhbmQgdG90YWxfbGF0ZV9mZWVzIDw+IDAg

Success #stdin #stdout #stderr 0.01s 5320KB

stdin

Standard input is empty

stdout

Standard output is empty

stderr

Error: near line 3: unrecognized token: "{"

https://ideone.com/z7Zmdz

language:

SQLite (sqlite 3.27.2)

created:

visibility:

public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!

Discover > Sphere Engine API

Discover > IDE Widget

Choose your language