http://localhost/ticket/2550 <h2 id="Requirements">Requirements</h2> <p> In the data hub plugin we require the ability to differentiate users between those that have paid for a service, and those that haven't. The distinction isn't boolean as there may be levels of service for paid users, so it may be that we need a 'type' of user where there are various grades of 'paid' which are likely to be strings (specific to the data hub). </p> <h2 id="Requiredinterface">Required interface</h2> <p> Once changes have been made to the user schema, for a given user we want to be able to: </p> <ul><li>determine if they have a paid or a free account, and </li><li>get a string name of the type of paid account. </li></ul><p> Care should be taken to ensure that the 'paid' status of the user cannot be set through the API and only by the datahub plugin. </p> <h2 id="UserStories">User Stories</h2> <p> User stories related to the management, setting and changing of a user's payment level, as well as historical information on payments should be done as part of the work that includes actually allowing purchases. For now it is adequate that we can manually control these things through paster commands. </p> <p> Payments types should be linear as I don't believe for this type of service a pick-and-mix modular model would work well. Organizations will inherit the payment level of their owner, so currently there is no requirement for it to affect organizations at all. </p> <ul><li>As a sysadmin I would like to be able to use a paster command to manually set a user's payment level, or remove it entirely. </li></ul><ul><li>As a sysadmin I would like to be able to run a paster command to view a list of users who have a payment plan, grouped by the plan that they have. </li></ul><ul><li>As a sysadmin I would like to be able to use the API to change the payment status of a specific user through user_create and user_update. This shouldn't be available to anybody else. </li></ul><ul><li>As a user, and only if I have one, I'd like to see my current payment level on my user profile page. </li></ul><p> </p> <h2 id="Tasks">Tasks</h2> <p> [ ] Tests </p> <p> [ ] Plugin based migration </p> <p> [ ] Code </p> <blockquote> <p> [ ] Model </p> </blockquote> <blockquote> <p> [ ] API </p> </blockquote> <p> [ ] Documentation </p> <h2 id="Estimates">Estimates</h2> en-us http://assets.okfn.org/p/ckan/img/ckan_logo_shortname.png http://localhost/ticket/2550 Trac 0.12.3 ross Mon, 25 Jun 2012 09:33:45 GMT http://localhost/ticket/2550#comment:1 http://localhost/ticket/2550#comment:1 <ul> <li><strong>milestone</strong> changed from <em>ckan-v1.8</em> to <em>datahub-july</em> </li> </ul> Ticket ross Mon, 25 Jun 2012 12:16:29 GMT http://localhost/ticket/2550#comment:2 http://localhost/ticket/2550#comment:2 <ul> <li><strong>owner</strong> changed from <em>kindly</em> to <em>ross</em> </li> <li><strong>status</strong> changed from <em>new</em> to <em>accepted</em> </li> </ul> <p> Clarify </p> Ticket ross Tue, 26 Jun 2012 08:43:41 GMT http://localhost/ticket/2550#comment:3 http://localhost/ticket/2550#comment:3 <ul> <li><strong>description</strong> modified (<a href="/ticket/2550?action=diff&amp;version=3">diff</a>) </li> </ul> Ticket ross Tue, 26 Jun 2012 08:45:16 GMT http://localhost/ticket/2550#comment:4 http://localhost/ticket/2550#comment:4 <ul> <li><strong>description</strong> modified (<a href="/ticket/2550?action=diff&amp;version=4">diff</a>) </li> </ul> Ticket icmurray Tue, 26 Jun 2012 17:29:33 GMT http://localhost/ticket/2550#comment:5 http://localhost/ticket/2550#comment:5 <ul> <li><strong>owner</strong> changed from <em>ross</em> to <em>icmurray</em> </li> <li><strong>status</strong> changed from <em>accepted</em> to <em>assigned</em> </li> </ul> Ticket icmurray Tue, 26 Jun 2012 17:30:13 GMT http://localhost/ticket/2550#comment:6 http://localhost/ticket/2550#comment:6 <ul> <li><strong>status</strong> changed from <em>assigned</em> to <em>accepted</em> </li> </ul> Ticket icmurray Sun, 08 Jul 2012 17:09:30 GMT http://localhost/ticket/2550#comment:7 http://localhost/ticket/2550#comment:7 <ul> <li><strong>cc</strong> <em>ross</em> added </li> </ul> <p> I've done some initial work on this. I think the best way is to define extra tables in the datahub extension. (Rather than: using groups; or modifying the user table; or defining extras for users (in core)). </p> <p> Initially, I've created a new domain object, <a class="missing wiki">PaidService?</a>, which captures the different levels of account a user may have. And then attached users to this through a secondary table. I think the advantages of this approach are: </p> <ul><li>the <a class="missing wiki">PaidService?</a> table can contain supplementary info about that account type: eg - amount of storage allowed; or cost to sign up etc... </li><li>allows us to use a modular payment system if biz decide that would be favourable. ie - users belong to multiple <a class="missing wiki">PaidServices?</a> which are independant of one another, rather than a linear hierarcy (eg - "sign up for storage, but not for privacy" vs. "sign up for enterprise level rather than basic level") </li></ul><p> The thing that's held me up today is being able to run tests: I'm having a sqlalchemy issue with defining extra mappings on the User table; which then gets dropped when initializing the test setup. I've gotten to the bottom of the problem, and will ask kindly's advice. </p> <p> In the meantime, I could do with some user stories please. I think I have a fairly good idea of what's likely to be needed by this ticket; but to what extent should this be exposed to a sysadmin (adding payment schemes; adding users to payment schemes; users seeing which payemtn services they're paying for (public to other users or not?); user's seeing history of payments? sysadmins seeing list of users for each service level?) - should this be: through a dashboard? through paster commands? through the api? all 3? </p> <p> Do we want modular payments or a linear hierarchy of payment schemes? </p> <p> How does is this suppossed to fit in with organizations? Do organizations purchase on behalf of users as well as individuals being able to make purchases? </p> <p> Do we need to be able to deativate a user's paid service if their payment hasn't come through? </p> Ticket ross Mon, 09 Jul 2012 11:31:00 GMT http://localhost/ticket/2550#comment:8 http://localhost/ticket/2550#comment:8 <ul> <li><strong>description</strong> modified (<a href="/ticket/2550?action=diff&amp;version=8">diff</a>) </li> </ul> <p> I think you've nailed the user stories already, but have added them to Description to be explicit. </p> Ticket rgrp Tue, 17 Jul 2012 14:38:44 GMT http://localhost/ticket/2550#comment:9 http://localhost/ticket/2550#comment:9 <p> Sounds good. BTW all users stories if at all possible go in google docs now for permanence. Here is the template: <a class="ext-link" href="https://docs.google.com/document/d/1U5yahDrvp_PKQMNjzI_8u3xixnALf4eNZWK2BdTXOVw/edit"><span class="icon">​</span>https://docs.google.com/document/d/1U5yahDrvp_PKQMNjzI_8u3xixnALf4eNZWK2BdTXOVw/edit</a> </p> Ticket icmurray Thu, 19 Jul 2012 12:10:56 GMT http://localhost/ticket/2550#comment:10 http://localhost/ticket/2550#comment:10 <ul> <li><strong>owner</strong> changed from <em>icmurray</em> to <em>ross</em> </li> <li><strong>priority</strong> changed from <em>awaiting triage</em> to <em>awaiting merge</em> </li> <li><strong>status</strong> changed from <em>accepted</em> to <em>assigned</em> </li> <li><strong>description</strong> modified (<a href="/ticket/2550?action=diff&amp;version=10">diff</a>) </li> </ul> <p> Awaiting merge: <a class="ext-link" href="https://github.com/okfn/ckanext-datahub/pull/1"><span class="icon">​</span>https://github.com/okfn/ckanext-datahub/pull/1</a> </p> Ticket ross Mon, 03 Sep 2012 10:51:37 GMT http://localhost/ticket/2550#comment:11 http://localhost/ticket/2550#comment:11 <ul> <li><strong>owner</strong> changed from <em>ross</em> to <em>icmurray</em> </li> </ul> <p> Reassigned to icmurray rather than back to backlog. </p> Ticket