Code for database forms and Drupal module for the Lobbywatch.ch project
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
R
config
css
docker/debian_mysql
docs
drupal
logo
public_html
sql
studies
translation
web_scrapers
ws
.buildpath
.gitignore
.project
LICENSE
README.md
UPG_TODO.php
after_import_DB.sql
afterburner.sh
build.sh
clean.sh
common.sh
compare_local_db_structs.sh
composer.json
composer.lock
data_image_css_converter.sh
db_changes.sql
db_check.sql
db_fail.sql
db_procedures_triggers.sql
db_queries.sql
db_script.sql
db_views.sql
deploy.sh
form_partitions.php
gen_css.sh
gen_js.sh
gen_lobbywatch_edit.sh
import_status.php
lobbywatch.mwb
lobbywatch.sql
lobbywatch_bearbeitung_public.pgtm
lobbywatch_datenmodell.pdf
lobbywatch_datenmodell.png
lobbywatch_datenmodell.svg
lobbywatch_datenmodell_1page.pdf
lobbywatch_datenmodell_simplified.pdf
lobbywatch_datenmodell_simplified.png
lobbywatch_datenmodell_simplified.svg
lobbywatch_log.sql
mail_notification.php
mysql_utf8_normalize_generator.php
phpass_checker.php
phpass_generator.php
prepare_release.sh
require-build-custom.js
rsync-exclude
rsync-fast-exclude
run_db_prod_to_local.sh
run_db_script.sh
run_local_db_copy_to_test.sh
run_local_db_script.sh
run_update_ws_parlament.sh
set_lobbywatch_version.sh
sql_generator.php
startMyPHPGenerator.sh
ws_parlament_fetcher.php
ws_uid_fetcher.php

README.md

Lobbywatch.ch

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.

Requirements

  • PHP 7.2
  • PHP composer
  • MySQL 5.7.22 / MariaDB 10.2.7
  • Drupal 7
  • bash
  • ImageMagick

More info, see https://lobbywatch.ch/de/seite/technik

Edit forms generation

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)

Setup

PHP

composer install

DB

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;

Edit forms

Build

./build.sh

Deploy

./deploy.sh -s -p

See parameters with

./deploy.sh -h

Drupal Theme

The Drupal 7 theme transparent_sky is in a separte git repository: https://github.com/Lobbywatch/transparent_sky

License

Source of Lobbywatch.ch is licensed under GPL, see LICENSE.