Giter Club home page Giter Club logo

ldes_to_pg's Introduction

LDES_TO_PG

replicate CoGhent Linked Data Event Streams into tabular dataframe (postgresql, csv, excel)

Available collections:

code Description
dmg Design Museum Gent
hva Huis van Alijn
industriemuseum Industriemuseum
archiefgent Archief Gent
stam STAM (stadsmuseum Gent)
thesaurus thesaurus (conceptlist)
agents agent list
EXHIBITIONS list of exhibitions (restricted to Design Museum Gent )

installation

python environment

pip install -r requirements.txt

actor-init-ldes-client

This repo makes use of the actor-init-ldes-client library. see https://github.com/CoGhent/api-docs-tooling/wiki/TOOLING for installation.

postgresql environment

In order to insert the data into a postgresql database, you must first install postgresql and create a database. Based on the connection string you can then insert the captured data into the postgresql database.

USAGE

Parameter Description Possible values
--process define collections to process from CoGhent LDES DMG, HVA, STAM, IM, ARCHIEF, THESAURUS, AGENTS
--timestamp datetime to prune relations that have a lower datetime value for example: 2020-01-01T00:00:00, default = "2021-01-01T15:48:12.309Z"
--result define the wished for result (pg=postrgres) pg, csv, xlsx
--download, -d download a collection, boolean to be set to first download and then process a collection
for example if you want to download & process data from Design Museum Gent en Huis Van Alijn starting from 15 november 2021 you use the following line of code in CLI:

python3 ldes-to-pg.py --process DMG --timestamp 2021-10-10T15:48:12.309Z -d

License

This project is released as an open-source project under the MIT License

ldes_to_pg's People

Contributors

oliviervd avatar devriesewouter89 avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.