aboutsummaryrefslogtreecommitdiffstats
path: root/db/migrate
AgeCommit message (Collapse)Author
2018-01-11Add Referential#merged_at and make Referentials archived and merged. Refs #5559Alban Peignier
2018-01-10Use jsonb and default to create vehicle_journeys#custom_field_values. Refs #55055505-custom_fields_with_jsonbAlban Peignier
2018-01-10Fixes: #5505@0.25h; Invesitgating the failure to compute a distinct join on ↵Robert
vehicle_journeys Solution: custom_field_values: json -> jsonb
2018-01-10Fixes: #5505@2h; Migrations, specs and implementationsRobert
- Migration index_resource_type_on_custom_fields - Specing behavior of custom field's resource (VehicleJourney) - Migration create json col custom_field_values for resource (VehicleJourney) - Create accessor methods inside resource (VehicleJourney)
2018-01-10Refs: #5505@1h; Spec discussed, model scaffolded [amend me] [skip-ci]Robert
2018-01-10Fixes: #5499; Added validations and associationsRobert
2018-01-10bup [amend me] [skip-ci]Robert
2018-01-10Refs: #5499@0.5h; fixed migration (ids type of rails generator is not conform)Robert
2018-01-10Refs: #5499@0.5h; Scaffolded WorkgroupRobert
Next: - spec associations and name - spec initialisation - implement
2018-01-08Refs #5455 @6h; Add time and distance between stops in Journey PatternsZog
- Adds a `JSON` attribute in the model - Adds the fields in the editor
2018-01-05Create Merge operation. Refs #5299Alban Peignier
2017-12-27Refs #5407; Fix CIZog
2017-12-27Refs #5407;Zog
:fire: useless code Rename some vars
2017-12-27Refs #5407; Fix CIZog
2017-12-27Refs #5407 @2h; Model implementationZog
- Link PurchaseWindows to VehicleJourneys in the model - Add an autocompletion endpoint
2017-12-21Merge branch 'master' into ↵Luc Donnet
5316-migrate-compliance-control-and-check-attributes-from-hs
2017-12-21Add `down` to 20171218174509 Hstore to JSON migrationTeddy Wing
Copy Cédric's JSON to Hstore migration for the `down` here to give us the ability to roll back. I'm guessing the solution probably comes from here: https://stackoverflow.com/questions/28315948/casting-json-to-hstore-in-postgres-9-3/28319295#28319295 Refs #5316
2017-12-21Change `compliance_{controls,checks}` `control_attributes` to JSONTeddy Wing
Make these columns JSON fields again. Do this because of bugs trying to validate types with `hstore_accessor` (https://github.com/devmynd/hstore_accessor/issues/78). With a JSON field, types are preserved and we don't have to deal with casting back and forth. Previously we had converted to Hstore because the Java IEV application used an older ORM version (maybe Hibernate) that didn't support the Postgres JSON type. Because of the validation problems with Hstore, the Java application has been updated to support JSON fields. Thanks to this Stack Overflow post from 'a_horse_with_no_name' that describes how to convert from Hstore to JSON types in Postgres: https://stackoverflow.com/questions/33732529/postgres-how-to-convert-hstore-to-json-datatypes#comment55234342_33732529 Converting in this direction seems to me to be much safer because we're not losing type information. All the values should be hashes of strings, which should convert without issue into JSON. Refs #5316
2017-12-21Merge pull request #150 from af83/5301-add_business_calendarsLuc Donnet
Refs #5301 First draft for Business Calendars
2017-12-21BusinessCalendar => PurchaseWindowcedricnjanga
belongs_to referential
2017-12-21Fix migrations, locales, view and exclude calendar timetable in concern Refs ↵Luc Donnet
#5301
2017-12-21Refs #5301 First draft for Business Calendarscedricnjanga
2017-12-20Add StopArea#waiting_time with support in stop_areas#index/show. Refs #5351Alban Peignier
2017-12-20Create Organisation#features and FeatureChecker controller concerns. Refs #5339Alban Peignier
2017-12-14Enable unaccent extensionXinhui
Refs #5305
2017-12-05Refs #5127 Add two new endpoints to the APIcedricnjanga
ComplianceCheckSet#notify_parent NetexImport#notify_parent
2017-12-01Fix objectid_format creation in migration with existence test.Luc Donnet
2017-11-30Merge branch 'master' into 5093-fix_import_policyLuc Donnet
2017-11-30Fixes: #5130@0.5h; Added a quickfix for incorrect item_id type in versions5130-del_fk_compliance_ctrl_set_in_compliance_check_setsRobert
2017-11-30Fixes: #5130@0.5h; Spec added, migration addedRobert
2017-11-30Delete foreign_key referential in compliance_check_set Refs #5093Luc Donnet
2017-11-28Refactoring move referentialSupport from chouetteController into childrensXinhui
2017-11-28Remove column creatorXinhui
2017-11-28Remove creator_id columnXinhui
2017-11-28Add gem paper_trailXinhui
2017-11-27Merge branch 'master' of github.com:af83/stif-boivcedricnjanga
2017-11-26Create STIF organisations with custom_view 'stif'. Refs #4735Alban Peignier
2017-11-26Add Organisation#custom_view and associated helper render_custom_view. Refs ↵Alban Peignier
#4735
2017-11-24Take into account code reviewcedricnjanga
2017-11-23Add migration to update all referentials and workbenches objectid format to ↵cedricnjanga
stif_netex
2017-11-22Merge branch 'master' into 4941-refactoring_object_idcedricnjanga
2017-11-22Merge branch 'master' into 4941-refactoring_object_idcedricnjanga
2017-11-17Merge branch '4516_cleanup_rule_parameter_set'Xinhui
2017-11-17Remove migration4516_cleanup_rule_parameter_setXinhui
Refs #4516
2017-11-14Remove rule parameter set routeXinhui
Refs #4516 Removel rule parameter set from migration
2017-11-14Drop table rule_parameter_setsXinhui
Refs #4516
2017-11-13compliance_check_resources: Rename `type` column to `resource_type`Teddy Wing
The Java application needs a `resource_type` column to be able to store the class/object that was validated by the resource's check. Since we don't need or want Single Table Inheritance on this table, rename the existing `type` field to `resource_type`. Refs #4953
2017-11-10Change `compliance_check_set_id` to `bigint`Teddy Wing
I had missed this one in 63d85933ac99453c76df7cda102a4f60d94f5f53. Thanks a lot to Robert for scouring the fields and finding it. Since the v2 migration was irreversible, add a new one to change the type of this foreign key. Refs #4947
2017-11-10Migrate all foreign keys to `bigint` from `integer`Teddy Wing
All our primary keys are supposed to be `bigint`s, and our foreign keys should likewise be `bigint`s. But it's easy to forget this when creating migrations, or some committers might not have been up to speed on the convention. In any case, this changes all existing foreign keys to be `bigint`s. Need to get this out now so that Michel Etienne can use it to correctly test the Java application for compliance check validations. That's why I'm not including any future-looking checks or enforcements here. That will be coming next. Refs #4947
2017-11-10Remove RouteSection from SetUpdatedAt migration. Refs #4944Alban Peignier
generated by cgit v1.2.3 (git 2.25.1) at 2025-12-28 13:34:43 +0000