Alexander Gabriel barbalex
barbalex
/ kapla_writeExport.js
Created
September 27, 2016 09:35
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** | |
| * writes a dataArray to an Excel workbook | |
| * this must happen in child process | |
| * otherwise a blank page results | |
| * get dataArray listening to process.send | |
| */ | |
| const Excel = require('exceljs') | |
| // path is passed as only argument of the process |
barbalex
/ kapla_exportGeschaefte.js
Last active
September 27, 2016 09:38
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** | |
| * gets save path | |
| * pass dataArray using process.send | |
| * kill child process at end? | |
| */ | |
| import electron, { remote } from 'electron' | |
| import pathModule from 'path' | |
| import childProcess from 'child_process' |
barbalex
/ kapla_package.json
Created
September 27, 2016 09:32
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "name": "Kapla", | |
| "productName": "Kapla", | |
| "version": "1.0.0", | |
| "description": "Instrument, mit dem der Rechtsdienst des AWEL Geschäfte erfasst und Fristen kontrolliert", | |
| "main": "main.js", | |
| "scripts": { | |
| "test": "cross-env NODE_ENV=test mocha --compilers js:babel-core/register --recursive --require ./test/setup.js test/**/*.spec.js", | |
| "test-watch": "npm test -- --watch", | |
| "test-e2e": "cross-env NODE_ENV=test mocha --compilers js:babel-core/register --require ./test/setup.js --require co-mocha ./test/e2e.js", |
barbalex
/ res output.json
Last active
February 25, 2016 16:36
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| domain: null, | |
| _events: {}, | |
| _eventsCount: 0, | |
| _maxListeners: undefined, | |
| res: | |
| IncomingMessage { | |
| _readableState: | |
| ReadableState { | |
| objectMode: false, |
barbalex
/ taxonomie_beispiel_lr.json
Created
February 10, 2016 14:06
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "Name": "CH Delarze (2008): Lebensräume", | |
| "Gruppe": "Lebensräume", | |
| "Eigenschaften": { | |
| "Taxonomie": "CH Delarze (2008): Lebensräume", | |
| "Einheit-Nr FNS": "44", | |
| "Label": "2.2.3", | |
| "Einheit": "Kalk-Kleinseggenried", | |
| "Lateinisch": "Caricion davallianae", | |
| "Französisch": "Parvocariçaie neutro-basophile", |
barbalex
/ taxonomie_beispiel.json
Created
February 10, 2016 13:53
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "Name": "CSCF (2009)", | |
| "Beschreibung": "Index der Info Fauna. Eigenschaften von 21542 Tierarten", | |
| "Datenstand": "2009", | |
| "Link": "http://www.cscf.ch/", | |
| "Gruppe": "Fauna", | |
| "Eigenschaften": { | |
| "Taxonomie ID": 21207, | |
| "Klasse": "Insecta", | |
| "Ordnung": "Coleoptera", |
barbalex
/ evab-queries.sql
Last active
December 3, 2015 15:34
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE OR REPLACE VIEW v_exportevab_beob AS | |
| SELECT CONCAT('{', apflora.tpopkontr.ZeitGuid, '}') AS fkZeitpunkt, CONCAT('{', apflora.tpopkontr.TPopKontrGuid, '}') AS idBeobachtung, IF(apflora.adresse.EvabIdPerson Is Not Null, apflora.adresse.EvabIdPerson, '{A1146AE4-4E03-4032-8AA8-BC46BA02F468}') AS fkAutor, apflora.ap.ApArtId AS fkArt, 18 AS fkArtgruppe, 1 AS fkAA1, tpopHerkunft.ZdsfHerkunft AS fkAAINTRODUIT, tpopHerkunft.ZdsfVorhanden AS fkAAPRESENCE, apflora.tpopkontr.TPopKontrGefaehrdung AS MENACES, LEFT(apflora.tpopkontr.TPopKontrVitalitaet, 200) AS VITALITE_PLANTE, LEFT(apflora.tpop.TPopBeschr, 244) AS STATION, LEFT(CONCAT('Anzahlen: ', GROUP_CONCAT(apflora.tpopkontrzaehl.Anzahl SEPARATOR ', '), ', Zaehleinheiten: ', GROUP_CONCAT(apflora.tpopkontrzaehl_einheit_werte.ZaehleinheitTxt SEPARATOR ', '), ', Methoden: ', GROUP_CONCAT(apflora.tpopkontrzaehl_methode_werte.BeurteilTxt SEPARATOR ', ')), 160) AS ABONDANCE | |
| FROM (((((((apflora.ap INNER JOIN apflora.pop ON apflora.ap.ApArtId = apflora.pop.ApArtId) INNE |
barbalex
/ artendb_vorlage_neuen_lebensraum_ohne_kommentare.json
Last active
November 9, 2015 16:47
arteigenschaften.ch: Vorlage für neuen Lebensraum (ohne Kommentare)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "_id": "", | |
| "Gruppe": "Lebensräume", | |
| "Typ": "Objekt", | |
| "Taxonomie": { | |
| "Name": "", | |
| "Eigenschaften": { | |
| "Taxonomie": "", | |
| "Label": "", | |
| "Einheit": "", |
barbalex
/ artendb_vorlage_neuer_lebensraum.js
Last active
November 9, 2015 16:46
arteigenschaften.ch: Vorlage für neuen Lebensraum
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| // Ein Datensatz ist ein JSON-Objekt | |
| // Es enthält auf der obersten Ebene die Felder: | |
| // "_id", "_rev", "Gruppe", "Typ", "Taxonomie", "Datensammlungen" und "Beziehungssammlungen" | |
| // _id: Die von CouchDb vergebene GUID verwenden oder eine eigene, die diesen Kriterien entspricht: | |
| // http://de.wikipedia.org/wiki/Globally_Unique_Identifier | |
| // Sie muss folgendermassen zusammengesetzt sein: | |
| // - 32 Zeichen in 5 Gruppen, | |
| // - diese jeweils 8, 4, 4, 4 und 12 Zeichen lang, |
barbalex
/ artendb_vorlage_neue_pilzaart_ohne_kommentare.json
Created
November 9, 2015 16:12
arteigenschaften.ch: Vorlage für neue Pilz-Art (ohne Kommentare)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "_id": "", | |
| "Gruppe": "Macromycetes", | |
| "Typ": "Objekt", | |
| "Taxonomie": { | |
| "Name": "Swissfunghi (2011)", | |
| "Beschreibung": "WSL, Swissfunghi, Beatrice Senn (Datenzentrum Moose Schweiz)", | |
| "Datenstand": "2011.06", | |
| "Link": "http://www.wsl.ch/dienstleistungen/inventare/pilze_flechten/swissfungi/index_DE", | |
| "Eigenschaften": { |