aboutsummaryrefslogtreecommitdiffstats
path: root/db
Commit message (Collapse)AuthorAgeLines
* fixup! Use translation tables for PublicBodyCategory and PublicBodyHeadingLouise Crow2014-09-26-2/+8
|
* fixup! Use translation tables for PublicBodyCategory and PublicBodyHeadingLouise Crow2014-09-25-1/+7
|
* fixup! Add display order to public body categories and headingsLouise Crow2014-09-24-2/+0
|
* Add display_order field to public_body_headings.Louise Crow2014-09-22-1/+2
| | | | # Please enter the commit message for your changes. Lines starting
* Add display order to public body categories and headingslizconlan2014-09-22-0/+16
|
* Use translation tables for PublicBodyCategory and PublicBodyHeadinglizconlan2014-09-22-0/+151
|
* Replace existing PublicBodyCategories functionality with db models ↵lizconlan2014-09-22-0/+27
| | | | PublicBodyCategory and PublicBodyHeading
* Merge branch 'issues/1709-api-controller-speed' into rails-3-developLouise Crow2014-08-04-0/+5
|\
| * Add an index for event_type on info_request_eventsSteven Day2014-08-01-0/+5
| | | | | | | | | | | | | | Selecting request events for a particular body is slow because we need to filter the events by event_type and don't currently have an index on that field. This should speed that up. Closes #1709
* | Rename XXX comments with TODO:Gareth Rees2014-06-10-6/+6
| | | | | | | | Picks these up in `rake notes` and adds semantic meaning
* | Define track things constraint correctlyGareth Rees2014-05-28-0/+17
|/ | | | | | | | > The constraint fk_track_request_public_body on > track_things_sent_emails is defined incorrectly, referring to user_id > rather than public_body_id. Via Robin Houston
* Add default blank string to PublicBody@short_nameGareth Rees2014-04-09-0/+11
| | | | The validation allows a blank short_name but the schema does not.
* Add SpamAddress modelGareth Rees2014-03-26-0/+9
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | The volume of spam in the holding pen in WDTK has increased. Over a few weeks in January 2014 the pattern was roughly: - 8 were sent "To" the same address, which was a nearly valid old request address - correct hash, but missing the second hyphen. - 1 was sent "To" an invalid request address (nearly correct hash) - 1 was sent "BCC" a valid request address - 1 was sent "BCC" request@whatdotheyknow.com If a spam was sent "To" an old valid request address then it would be rejected. It's not entirely safe to just reject mails to old requests with any hash, because sometimes authorities miss out a digit in the request number, though perhaps simply getting a failure bounce would cause them to check. In any case that wouldn't trivially catch the most frequent case above as it doesn't have an obvious request number. --- We looked at greylisting and configuring the MTA with an RBL. Greylisting was rejected as it would slow down the responsiveness of the application when people email in. This could be revisited if/when emails are parsed through a queue system depending on how we find the performance there. An RBL is already configured, but this ticket refers more to where the email is sent rather than who it came from. --- We elected to: - Create spam_address model - Add code to RequestMailer.receive to check the list of spam addresses and silently discard an incoming mail if it's addressed to one of them - Add page to admin interface for adding/removing spam addresses --- Thanks to Ganesh Sittampalam for the research and Louise Crow for the implementation strategy.
* Merge branch 'feature/batch-requests' into rails-3-developLouise Crow2014-01-29-0/+51
|\ | | | | | | | | | | Conflicts: config/general.yml-example spec/factories.rb
| * Simplify return value, set sent_at in create_batch!Louise Crow2013-12-04-0/+5
| |
| * Add association between batches and public bodies.Louise Crow2013-12-04-0/+8
| |
| * Add check for double submission.Louise Crow2013-12-04-0/+11
| |
| * Add InfoRequestBatch model.Louise Crow2013-12-04-0/+22
| | | | | | | | | | Re-annotate models. Index InfoRequestBatches by user - we'll display the batches for a user when they view their own requests.
| * Add a can_make_batch_requests flag to user modelLouise Crow2013-12-04-0/+5
| | | | | | | | Make it updatable via the user admin page.
* | Form and models for asking for a public body change.Louise Crow2014-01-13-0/+20
|/
* Add a info_requests_visible_classified_count column to PublicBodyMark Longair2013-11-05-0/+15
| | | | | | This counts only those info requests that have prominence 'normal' (i.e. are not hidden) and are not 'awaiting_description' (i.e. that they have had some basic status classification).
* Merge branch 'feature/hide-individual-responses' into rails-3-developLouise Crow2013-09-17-0/+25
|\ | | | | | | | | | | | | | | | | | | | | Conflicts: Gemfile app/views/admin_request/edit_outgoing.html.erb config/packages doc/CHANGES.md doc/INSTALL.md spec/models/info_request_spec.rb spec/models/public_body_spec.rb
| * Add prominence fields to outgoing message.Louise Crow2013-09-16-0/+6
| |
| * Adding prominence_reason to IncomingMessage.Louise Crow2013-09-16-0/+5
| |
| * Add prominence to incoming message.Louise Crow2013-09-16-0/+5
| |
| * Remove prominence.Louise Crow2013-09-16-0/+9
| | | | | | | | | | | | | | Add a migration to remove the unused column 'prominence' from info_request_events, remove validation of prominence, remove unused InfoRequestEvent.user_can_view? method. Remove references to InfoRequestEvent.prominence.
* | Add a page with experimental statistics on public bodiesMark Longair2013-08-20-0/+26
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | The statistics on the status of the requests to a particular public body are too slow to calculate on-the-fly, so this commit adds: * Extra columns on public_bodies to store counts of the successful, not held, and overdue request counts for each public body. * A rake task which should be run periodically to update the overdue request count column. If Javascript is not available, the summary statistics are shown as tables. If Javascript is available, graphs are drawn with Flot.
* | Removing db/development_structure.sql from version control. Because ↵Louise Crow2013-08-08-2095/+0
|/ | | | different versions of postgres are producing minor variations every time this is generated, it's proving more of a hindrance than a help to development. Happy to reinstate it if anyone has suggestions about how to keep it stable across minor postgres version differences.
* Update reference to Configuration to reflect name change to ↵Louise Crow2013-04-30-1/+1
| | | | AlaveteliConfiguration
* bundle update debugger rmagickMatthew Landauer2013-03-18-24/+24
|
* Merge remote-tracking branch 'mysociety/develop' into rails-3-developHenare Degan2013-03-14-1/+2095
|\ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Conflicts: Gemfile Gemfile.lock app/controllers/admin_request_controller.rb app/controllers/admin_track_controller.rb app/controllers/request_controller.rb app/controllers/services_controller.rb app/helpers/link_to_helper.rb app/mailers/request_mailer.rb app/models/application_mailer.rb app/models/info_request.rb app/views/admin_censor_rule/edit.html.erb app/views/admin_censor_rule/new.html.erb app/views/admin_public_body/_form.html.erb app/views/admin_public_body/_locale_selector.html.erb app/views/admin_public_body/_one_list.html.erb app/views/admin_public_body/edit.html.erb app/views/admin_public_body/list.html.erb app/views/admin_public_body/new.html.erb app/views/admin_request/_incoming_message_actions.html.erb app/views/admin_request/edit.html.erb app/views/admin_request/edit_comment.html.erb app/views/admin_request/edit_outgoing.html.erb app/views/admin_request/list.html.erb app/views/admin_request/list_old_unclassified.html.erb app/views/admin_request/show.html.erb app/views/admin_track/_some_tracks.html.erb app/views/admin_track/list.html.erb app/views/admin_user/edit.html.erb app/views/admin_user/list.html.erb app/views/admin_user/show.html.erb app/views/general/_footer.html.erb app/views/general/exception_caught.html.erb app/views/help/contact.html.erb app/views/layouts/default.html.erb app/views/public_body/_alphabet.html.erb app/views/request/_request_listing_single.html.erb app/views/request/_sidebar.html.erb app/views/request/new.html.erb app/views/request/show.html.erb app/views/request_mailer/external_response.rhtml app/views/request_mailer/fake_response.rhtml config/environment.rb config/environments/production.rb config/routes.rb spec/controllers/admin_censor_rule_controller_spec.rb spec/controllers/request_controller_spec.rb spec/controllers/track_controller_spec.rb spec/helpers/link_to_helper_spec.rb spec/mailers/request_mailer_spec.rb spec/models/info_request_spec.rb spec/spec_helper.rb spec/views/public_body/show.html.erb_spec.rb spec/views/request/show.html.erb_spec.rb vendor/plugins/rails_xss/lib/rails_xss/erubis.rb
| * Reignore schema.rbLouise Crow2013-03-08-0/+1
| |
| * Checkin current snapshot of sql as per standard Rails good practise.Matthew Landauer2013-02-26-2/+2095
| | | | | | | | | | | | Also has the advantage that it makes it easier to switch between branches with different schemas as the test db schema will be generated from the checked in file.
* | Update syntax while I'm hereHenare Degan2013-03-05-1/+1
| |
* | Remove debugging output that was causing migration to failHenare Degan2013-03-05-2/+0
| |
* | Merge branch 'develop' into rails-3-spikeHenare Degan2013-02-15-4/+2
|\| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Conflicts: Gemfile Gemfile.lock app/controllers/general_controller.rb app/controllers/track_controller.rb app/models/outgoing_message.rb app/models/public_body.rb app/models/user.rb app/views/general/frontpage.rhtml config/environment.rb config/initializers/inflections.rb config/initializers/mime_types.rb db/migrate/094_remove_old_tags_foreign_key.rb lib/timezone_fixes.rb spec/models/request_mailer_spec.rb spec/views/request/list.rhtml_spec.rb
| * Drop the obsolete indexes explicitly by name - the 'remove_index' calls ↵Louise Crow2013-01-17-4/+2
| | | | | | | | don't work as the table has been renamed, and they automatically generate the index name from the table name. Apply custom index name from a5e90e2b7ea6adedbf80c05bbb84425a02c63da0.
| * Fix up some DB migration issues with Rails 3Henare Degan2013-01-18-3/+4
| | | | | | | | | | * The public_body_tags table had already been removed * The index has_tag_string_tags generated a name longer than the Postgres maximum of 63 characters. It was ignored in earlier Rails versions, see: https://rails.lighthouseapp.com/projects/8994/tickets/6187-postgresql-and-rails-303-migrations-fail-with-index-name-length-64-chars
* | We expect timestamps in a later migration but they're no longer added by the ↵Henare Degan2013-01-22-0/+2
| | | | | | | | newer version of acts_as_versioned we're using since 2ba57e8
* | Fix up some DB migration issues with Rails 3Henare Degan2012-12-11-3/+4
| | | | | | | | | | * The public_body_tags table had already been removed * The index has_tag_string_tags generated a name longer than the Postgres maximum of 63 characters. It was ignored in earlier Rails versions, see: https://rails.lighthouseapp.com/projects/8994/tickets/6187-postgresql-and-rails-303-migrations-fail-with-index-name-length-64-chars
* | Run the Rails 3 generatorHenare Degan2012-12-11-0/+7
|/
* Remove old code.Louise Crow2012-11-20-10/+2
|
* The used sql syntax is not supported by sqlite. Now db:migrate works with ↵Stefan Langenmaier2012-11-19-4/+11
| | | | sqlite.
* Add migration to add disclosure_log fieldMatthew Landauer2012-10-22-0/+13
|
* Rename models and tables exim -> mail_serverMatthew Landauer2012-10-11-0/+13
|
* Merge remote-tracking branch 'openaustralia_github/configuration_refactor' ↵Louise Crow2012-10-01-1/+1
|\ | | | | | | | | | | | | into develop Conflicts: config/general.yml-example
| * Extract configuration with defaults into one moduleMatthew Landauer2012-09-25-1/+1
| |
* | Re-enable migration - it looks like the underlying bug is something to do ↵Louise Crow2012-09-27-56/+56
| | | | | | | | with interlock/memcached.
* | Test commit to try to figure out what's wrong with the travis build - it ↵Louise Crow2012-09-27-56/+56
|/ | | | always fails on this migration.
* Merge remote-tracking branch 'origin/release/0.6.6' into developLouise Crow2012-09-20-4/+3
|\
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-30 06:05:43 +0000