Lobbywatch.ch - the platform for transparent politics.
Lobbywatch.ch maintains a database with links of politicians and lobby groups.
This repository contains the
- edit forms,
- Drupal lobbywatch module for a textual representation,
- DB structure, and
- visualizations.
The data are not stored in this repository.
- PHP 7.2
- PHP composer
- MySQL 5.7.26
- Drupal 7
- bash 4.4
- ImageMagick
More info, see https://lobbywatch.ch/de/seite/technik
The edit forms are built with the PHP Generator for MySQL Professional. Its a commercial tool (about 100$).
PHP Generator for MySQL Professional 18.3.0.2 (08.05.2018)
composer install
mysql -u root
Remove NO_ZERO_IN_DATE,NO_ZERO_DATE, ONLY_FULL_GROUP_BY form sql_mode
show databases;
create database lobbywatch; create database lobbywatchtest;
./deploy.sh -l= -r -s prod_bak/bak/dbdump_struct_lobbywat_lobbywatch_20170714_143332.sql
GRANT SELECT ON . TO 'lw_reader'@'localhost' IDENTIFIED BY 'PASSWORD'; GRANT SELECT ON . TO 'lw_reader'@'127.0.0.1' IDENTIFIED BY 'PASSWORD';
FLUSH PRIVILEGES;
./build.sh
./deploy.sh -s -p
See parameters with
./deploy.sh -h
The Drupal 7 theme transparent_sky is in a separte git repository: https://github.com/Lobbywatch/transparent_sky
Source of Lobbywatch.ch is licensed under GPL, see LICENSE.