Impact Evaluator implementatiom used for subjective, quantitative evaluations of a list of outcomes or projects. The tool uses quadratic voting as the evaluation mechanism.
Website: impactevaluator.io
Video: bit.ly/ietooldemo Link: impactevaluator.io Codes:
$ yarn dev
$ yarn run codegen:watch
If you update the database, run $ yarn run codegen:fetch to fetch the new type graphql schema.
No system is yet in place for database migrations. My intention is to use
https://github.com/supabase-community/supabase-graphql-example
TODO: document this error Failed to join round { code: 'PGRST202', details: null, hint: 'If a new function was created in the database with this name and parameters, try reloading the schema cache.', message: 'Could not find the public.join_with_code(code, preffered_email, user_id) function or the public.join_with_code function with a single unnamed json or jsonb parameter in the schema cache' }
Get SME status
select
"user".name as user_name,
github_handle,
voice_credits,
exists (select 1 from votes where votes.evaluator_id = evaluator.id) as has_voted,
true as has_logged_in,
evaluation.name as round_title
from evaluator
join "user" on "user".id = evaluator.user_id
join evaluation on evaluator.evaluation_id = evaluation.id
where evaluator.voice_credits = 100 and evaluator.evaluation_id = 'cf866f4d-216c-49aa-8363-3cabd93e80e0'
and "user".role != 'admin';Get number of credits used by each evaluator
select github_handle, coalesce(sum(votes*votes), 0)
from evaluator
left join votes on evaluator.id = votes.evaluator_id
join "user" on "user".id = evaluator.user_id
where evaluator.evaluation_id = 'cf866f4d-216c-49aa-8363-3cabd93e80e0'
group by github_handle
order by github_handle;