Skip to content
Snippets Groups Projects

feat(price): Add price managment

Merged feat(price): Add price managment
feat/US720-add-price-managment into dev
All threads resolved!
Merged Guilhem CARRON requested to merge feat/US720-add-price-managment into dev
All threads resolved!
Compare
and
Show latest version
1 file
+ 84
− 84
Compare changes
  • Side-by-side
  • Inline
dbinit/fluidprices.CSV
+ 84
− 84
fluid_type,price,start_date,end_date
0,0.1256,2012-07-23T00:00:00:00Z,2013-07-31T23:59:59:00Z
0,0.1329,2013-08-01T00:00:00:00Z,2014-10-31T23:59:59:00Z
0,0.1401,2014-01-11T00:00:00:00Z,2015-07-31T23:59:59:00Z
0,0.1437,2015-08-01T00:00:00:00Z,2016-07-31T23:59:59:00Z
0,0.1503,2016-08-01T00:00:00:00Z,2017-07-31T23:59:59:00Z
0,0.1546,2017-08-01T00:00:00:00Z,2018-01-31T23:59:59:00Z
0,0.1555,2018-02-01T00:00:00:00Z,2018-07-31T23:59:59:00Z
0,0.145,2018-08-01T00:00:00:00Z,2019-05-31T23:59:59:00Z
0,0.1531,2019-06-01T00:00:00:00Z,2019-07-31T23:59:59:00Z
0,0.1524,2019-08-01T00:00:00:00Z,2020-01-31T23:59:59:00Z
0,0.1546,2020-02-01T00:00:00:00Z,2020-07-31T23:59:59:00Z
0,0.1557,2020-08-01T00:00:00:00Z,2021-01-31T23:59:59:00Z
0,0.1582,2021-02-01T00:00:00:00Z,2021-07-31T23:59:59:00Z
0,0.1558,2021-08-01T00:00:00:00Z,2022-01-31T23:59:59:00Z
0,0.174,2022-02-01T00:00:00:00Z,,
1,0.0030735,2012-01-01T00:00:00:00Z,2012-12-31T23:59:59:00Z
1,0.0031483,2013-01-01T00:00:00:00Z,2013-12-31T23:59:59:00Z
1,0.0031381,2014-01-01T00:00:00:00Z,2014-12-31T23:59:59:00Z
1,0.00307,2015-01-01T00:00:00:00Z,2015-12-31T23:59:59:00Z
1,0.0031,2016-01-01T00:00:00:00Z,2016-12-31T23:59:59:00Z
1,0.00311,2017-01-01T00:00:00:00Z,2017-12-31T23:59:59:00Z
1,0.00313,2018-01-01T00:00:00:00Z,2018-12-31T23:59:59:00Z
1,0.00313,2019-01-01T00:00:00:00Z,2019-12-31T23:59:59:00Z
1,0.00315,2020-01-01T00:00:00:00Z,2020-12-31T23:59:59:00Z
1,0.00319,2021-01-01T00:00:00:00Z,,
2,0.0919,2017-01-01T00:00:00:00Z,2017-01-31T23:59:59:00Z
2,0.0915,2017-02-01T00:00:00:00Z,2017-02-28T23:59:59:00Z
2,0.0932,2017-03-01T00:00:00:00Z,2017-03-31T23:59:59:00Z
2,0.0927,2017-04-01T00:00:00:00Z,2017-04-30T23:59:59:00Z
2,0.0906,2017-05-01T00:00:00:00Z,2017-05-31T23:59:59:00Z
2,0.0906,2017-06-01T00:00:00:00Z,2017-06-30T23:59:59:00Z
2,0.0788,2017-07-01T00:00:00:00Z,2017-07-31T23:59:59:00Z
2,0.0783,2017-08-01T00:00:00:00Z,2017-08-31T23:59:59:00Z
2,0.0783,2017-09-01T00:00:00:00Z,2017-09-30T23:59:59:00Z
2,0.0791,2017-10-01T00:00:00:00Z,2017-10-31T23:59:59:00Z
2,0.0806,2017-11-01T00:00:00:00Z,2017-11-30T23:59:59:00Z
2,0.0812,2017-12-01T00:00:00:00Z,2017-12-31T23:59:59:00Z
2,0.0857,2018-01-01T00:00:00:00Z,2018-01-31T23:59:59:00Z
2,0.0866,2018-02-01T00:00:00:00Z,2018-02-28T23:59:59:00Z
2,0.0847,2018-03-01T00:00:00:00Z,2018-03-31T23:59:59:00Z
2,0.0839,2018-04-01T00:00:00:00Z,2018-04-30T23:59:59:00Z
2,0.0842,2018-05-01T00:00:00:00Z,2018-05-31T23:59:59:00Z
2,0.0855,2018-06-01T00:00:00:00Z,2018-06-30T23:59:59:00Z
2,0.0959,2018-07-01T00:00:00:00Z,2018-07-31T23:59:59:00Z
2,0.0961,2018-08-01T00:00:00:00Z,2018-08-31T23:59:59:00Z
2,0.0967,2018-09-01T00:00:00:00Z,2018-09-30T23:59:59:00Z
2,0.0989,2018-10-01T00:00:00:00Z,2018-10-31T23:59:59:00Z
2,0.1031,2018-11-01T00:00:00:00Z,2018-11-30T23:59:59:00Z
2,0.1013,2018-12-01T00:00:00:00Z,2018-12-31T23:59:59:00Z
2,0.0999,2019-01-01T00:00:00:00Z,2019-01-31T23:59:59:00Z
2,0.0993,2019-02-01T00:00:00:00Z,2019-02-28T23:59:59:00Z
2,0.0993,2019-03-01T00:00:00:00Z,2019-03-31T23:59:59:00Z
2,0.0977,2019-04-01T00:00:00:00Z,2019-04-30T23:59:59:00Z
2,0.0973,2019-05-01T00:00:00:00Z,2019-05-31T23:59:59:00Z
2,0.0969,2019-06-01T00:00:00:00Z,2019-06-30T23:59:59:00Z
2,0.0795,2019-07-01T00:00:00:00Z,2019-07-31T23:59:59:00Z
2,0.0791,2019-08-01T00:00:00:00Z,2019-08-31T23:59:59:00Z
2,0.0785,2019-09-01T00:00:00:00Z,2019-09-30T23:59:59:00Z
2,0.077,2019-10-01T00:00:00:00Z,2019-10-31T23:59:59:00Z
2,0.0789,2019-11-01T00:00:00:00Z,2019-11-30T23:59:59:00Z
2,0.0793,2019-12-01T00:00:00:00Z,2019-12-31T23:59:59:00Z
2,0.0787,2020-01-01T00:00:00:00Z,2020-01-31T23:59:59:00Z
2,0.0765,2020-02-01T00:00:00:00Z,2020-02-29T23:59:59:00Z
2,0.0736,2020-03-01T00:00:00:00Z,2020-03-31T23:59:59:00Z
2,0.071,2020-04-01T00:00:00:00Z,2020-04-30T23:59:59:00Z
2,0.0703,2020-05-01T00:00:00:00Z,2020-05-31T23:59:59:00Z
2,0.0687,2020-06-01T00:00:00:00Z,2020-06-30T23:59:59:00Z
2,0.0698,2020-07-01T00:00:00:00Z,2020-07-31T23:59:59:00Z
2,0.0705,2020-08-01T00:00:00:00Z,2020-08-31T23:59:59:00Z
2,0.0709,2020-09-01T00:00:00:00Z,2020-09-30T23:59:59:00Z
2,0.0735,2020-10-01T00:00:00:00Z,2020-10-31T23:59:59:00Z
2,0.0745,2020-11-01T00:00:00:00Z,2020-11-30T23:59:59:00Z
2,0.0759,2020-12-01T00:00:00:00Z,2020-12-31T23:59:59:00Z
2,0.076,2021-01-01T00:00:00:00Z,2021-01-31T23:59:59:00Z
2,0.0782,2021-02-01T00:00:00:00Z,2021-02-28T23:59:59:00Z
2,0.0818,2021-03-01T00:00:00:00Z,2021-03-31T23:59:59:00Z
2,0.079,2021-04-01T00:00:00:00Z,2021-04-30T23:59:59:00Z
2,0.0797,2021-05-01T00:00:00:00Z,2021-05-31T23:59:59:00Z
2,0.0826,2021-06-01T00:00:00:00Z,2021-06-30T23:59:59:00Z
2,0.0895,2021-07-01T00:00:00:00Z,2021-07-31T23:59:59:00Z
2,0.0934,2021-08-01T00:00:00:00Z,2021-08-31T23:59:59:00Z
2,0.1002,2021-09-01T00:00:00:00Z,2021-09-30T23:59:59:00Z
2,0.1121,2021-10-01T00:00:00:00Z,,
\ No newline at end of file
fluid_type,price,start_date,end_date,id,created_at,updated_at
0,0.1256,2012-07-23T00:00:00Z,2013-07-31T23:59:59Z,1,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
0,0.1329,2013-08-01T00:00:00Z,2014-10-31T23:59:59Z,2,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
0,0.1401,2014-01-11T00:00:00Z,2015-07-31T23:59:59Z,3,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
0,0.1437,2015-08-01T00:00:00Z,2016-07-31T23:59:59Z,4,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
0,0.1503,2016-08-01T00:00:00Z,2017-07-31T23:59:59Z,5,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
0,0.1546,2017-08-01T00:00:00Z,2018-01-31T23:59:59Z,6,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
0,0.1555,2018-02-01T00:00:00Z,2018-07-31T23:59:59Z,7,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
0,0.145,2018-08-01T00:00:00Z,2019-05-31T23:59:59Z,8,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
0,0.1531,2019-06-01T00:00:00Z,2019-07-31T23:59:59Z,9,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
0,0.1524,2019-08-01T00:00:00Z,2020-01-31T23:59:59Z,10,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
0,0.1546,2020-02-01T00:00:00Z,2020-07-31T23:59:59Z,11,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
0,0.1557,2020-08-01T00:00:00Z,2021-01-31T23:59:59Z,12,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
0,0.1582,2021-02-01T00:00:00Z,2021-07-31T23:59:59Z,13,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
0,0.1558,2021-08-01T00:00:00Z,2022-01-31T23:59:59Z,14,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
0,0.174,2022-02-01T00:00:00Z,,15,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
1,0.0030735,2012-01-01T00:00:00Z,2012-12-31T23:59:59Z,16,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
1,0.0031483,2013-01-01T00:00:00Z,2013-12-31T23:59:59Z,17,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
1,0.0031381,2014-01-01T00:00:00Z,2014-12-31T23:59:59Z,18,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
1,0.00307,2015-01-01T00:00:00Z,2015-12-31T23:59:59Z,19,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
1,0.0031,2016-01-01T00:00:00Z,2016-12-31T23:59:59Z,20,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
1,0.00311,2017-01-01T00:00:00Z,2017-12-31T23:59:59Z,21,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
1,0.00313,2018-01-01T00:00:00Z,2018-12-31T23:59:59Z,22,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
1,0.00313,2019-01-01T00:00:00Z,2019-12-31T23:59:59Z,23,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
1,0.00315,2020-01-01T00:00:00Z,2020-12-31T23:59:59Z,24,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
1,0.00319,2021-01-01T00:00:00Z,,25,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0919,2017-01-01T00:00:00Z,2017-01-31T23:59:59Z,26,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0915,2017-02-01T00:00:00Z,2017-02-28T23:59:59Z,27,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0932,2017-03-01T00:00:00Z,2017-03-31T23:59:59Z,28,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0927,2017-04-01T00:00:00Z,2017-04-30T23:59:59Z,29,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0906,2017-05-01T00:00:00Z,2017-05-31T23:59:59Z,30,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0906,2017-06-01T00:00:00Z,2017-06-30T23:59:59Z,31,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0788,2017-07-01T00:00:00Z,2017-07-31T23:59:59Z,32,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0783,2017-08-01T00:00:00Z,2017-08-31T23:59:59Z,33,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0783,2017-09-01T00:00:00Z,2017-09-30T23:59:59Z,34,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0791,2017-10-01T00:00:00Z,2017-10-31T23:59:59Z,35,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0806,2017-11-01T00:00:00Z,2017-11-30T23:59:59Z,36,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0812,2017-12-01T00:00:00Z,2017-12-31T23:59:59Z,37,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0857,2018-01-01T00:00:00Z,2018-01-31T23:59:59Z,38,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0866,2018-02-01T00:00:00Z,2018-02-28T23:59:59Z,39,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0847,2018-03-01T00:00:00Z,2018-03-31T23:59:59Z,40,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0839,2018-04-01T00:00:00Z,2018-04-30T23:59:59Z,41,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0842,2018-05-01T00:00:00Z,2018-05-31T23:59:59Z,42,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0855,2018-06-01T00:00:00Z,2018-06-30T23:59:59Z,43,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0959,2018-07-01T00:00:00Z,2018-07-31T23:59:59Z,44,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0961,2018-08-01T00:00:00Z,2018-08-31T23:59:59Z,45,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0967,2018-09-01T00:00:00Z,2018-09-30T23:59:59Z,46,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0989,2018-10-01T00:00:00Z,2018-10-31T23:59:59Z,47,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.1031,2018-11-01T00:00:00Z,2018-11-30T23:59:59Z,48,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.1013,2018-12-01T00:00:00Z,2018-12-31T23:59:59Z,49,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0999,2019-01-01T00:00:00Z,2019-01-31T23:59:59Z,50,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0993,2019-02-01T00:00:00Z,2019-02-28T23:59:59Z,51,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0993,2019-03-01T00:00:00Z,2019-03-31T23:59:59Z,52,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0977,2019-04-01T00:00:00Z,2019-04-30T23:59:59Z,53,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0973,2019-05-01T00:00:00Z,2019-05-31T23:59:59Z,54,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0969,2019-06-01T00:00:00Z,2019-06-30T23:59:59Z,55,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0795,2019-07-01T00:00:00Z,2019-07-31T23:59:59Z,56,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0791,2019-08-01T00:00:00Z,2019-08-31T23:59:59Z,57,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0785,2019-09-01T00:00:00Z,2019-09-30T23:59:59Z,58,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.077,2019-10-01T00:00:00Z,2019-10-31T23:59:59Z,59,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0789,2019-11-01T00:00:00Z,2019-11-30T23:59:59Z,60,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0793,2019-12-01T00:00:00Z,2019-12-31T23:59:59Z,61,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0787,2020-01-01T00:00:00Z,2020-01-31T23:59:59Z,62,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0765,2020-02-01T00:00:00Z,2020-02-29T23:59:59Z,70,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0736,2020-03-01T00:00:00Z,2020-03-31T23:59:59Z,71,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.071,2020-04-01T00:00:00Z,2020-04-30T23:59:59Z,72,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0703,2020-05-01T00:00:00Z,2020-05-31T23:59:59Z,73,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0687,2020-06-01T00:00:00Z,2020-06-30T23:59:59Z,74,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0698,2020-07-01T00:00:00Z,2020-07-31T23:59:59Z,75,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0705,2020-08-01T00:00:00Z,2020-08-31T23:59:59Z,76,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0709,2020-09-01T00:00:00Z,2020-09-30T23:59:59Z,77,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0735,2020-10-01T00:00:00Z,2020-10-31T23:59:59Z,78,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0745,2020-11-01T00:00:00Z,2020-11-30T23:59:59Z,79,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0759,2020-12-01T00:00:00Z,2020-12-31T23:59:59Z,80,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.076,2021-01-01T00:00:00Z,2021-01-31T23:59:59Z,81,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0782,2021-02-01T00:00:00Z,2021-02-28T23:59:59Z,82,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0818,2021-03-01T00:00:00Z,2021-03-31T23:59:59Z,83,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.079,2021-04-01T00:00:00Z,2021-04-30T23:59:59Z,84,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0797,2021-05-01T00:00:00Z,2021-05-31T23:59:59Z,85,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0826,2021-06-01T00:00:00Z,2021-06-30T23:59:59Z,86,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0895,2021-07-01T00:00:00Z,2021-07-31T23:59:59Z,87,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.0934,2021-08-01T00:00:00Z,2021-08-31T23:59:59Z,88,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.1002,2021-09-01T00:00:00Z,2021-09-30T23:59:59Z,89,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
2,0.1121,2021-10-01T00:00:00Z,,90,2000-01-01T00:00:00Z,2000-01-01T00:00:00Z
\ No newline at end of file