Skip to content

Code for database forms and Drupal module for the Lobbywatch.ch project

License

Notifications You must be signed in to change notification settings

Philippluca/lobbywatch

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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.26
  • Drupal 7
  • bash 4.4
  • 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.

About

Code for database forms and Drupal module for the Lobbywatch.ch project

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages

  • PHP 65.1%
  • CSS 13.5%
  • HTML 11.6%
  • Jupyter Notebook 4.7%
  • JavaScript 3.1%
  • Less 1.1%
  • Other 0.9%