Skip to content
GitLab
Projects Groups Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in
  • M memopol
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 32
    • Issues 32
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 6
    • Merge requests 6
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Monitor
    • Monitor
    • Incidents
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • Political MemoryPolitical Memory
  • memopol
  • Merge requests
  • !80

[WIP] Add import scripts for old data, fixes #58

  • Review changes

  • Download
  • Email patches
  • Plain diff
Closed njoyard requested to merge import-old-data-24e97fe5 into master May 30, 2016
  • Overview 1
  • Commits 9
  • Pipelines 0
  • Changes 10

Created by: njoyard

This PR adds two import scripts for old memopol data.

Links to exported data:

  • recommendations.csv
  • positions.csv

Recommendations

Export old recommendation data to a |-separated CSV file with the following query:

SELECT CONCAT(r.description, '|', r.weight, '|', r.recommendation, '|',
    r.part, '|', p.title, '|', p.ponderation)
FROM votes_recommendation r
    LEFT JOIN votes_proposal p ON r.proposal_id = p.id
WHERE p.institution = 'EU'

Then run the import script using :

cat recommendations.csv | memopol_import_recommendations

Positions

Export old position data to a |-separated CSV file with the following query:

SELECT CONCAT(o.content, '|', o.url, '|', o.title, '|', ro.date, '|',
    r.first_name, '|', r.last_name)
FROM reps_opinion o
INNER JOIN reps_opinionrep ro ON ro.opinion_id = o.id
INNER JOIN reps_representative r ON r.id = ro.representative_id
WHERE o.institution='EU'

Then run the import script using :

cat positions.csv | memopol_import_positions
Assignee
Assign to
Reviewers
Request review from
Time tracking
Source branch: import-old-data-24e97fe5