Skip to content

Instantly share code, notes, and snippets.

View cecemel's full-sized avatar

cecemel

15 followers · 3 following
View GitHub Profile
@cecemel
cecemel / lblod-start-for-dev.md
Last active January 18, 2023 08:16
Starting @ LBLOD

LBLOD

The context

The vision is (in Dutch, unfortunately) well summarised in https://lokaalbestuur.vlaanderen.be/gelinkt-publiceren-en-melden, the video. Also some information here: https://www.vlaanderen.be/agentschap-binnenlands-bestuur/blikvangers/lokale-besluiten-als-gelinkte-open-data These were the initial seeds; the project has grown in scope. Even though some of the initial goals still need realisation.

data models

Development here is heavily data-driven. Data sharing between applications only work if data model is shared Hence the importance of data models.

@cecemel
cecemel / IPDC-LDES-test-app.md
Last active August 25, 2022 07:23

general info

  • the database should be accessible on http://ipdc-test-ldes-sparql.abb-croco.s.redhost.be:8890/sparql -> mind http:// here
  • the application should be accessible on https://ipdc-test-ldes.abb-croco.s.redhost.be/mock-login (choose a gemeente)
    • it would be a nice user test if you could navigate to the correct module etc. :-), I am sure you will manage.
    • note: currently, only one ConceptualPublicService is available, created by us. Since the data is not correctly parsed yet, nothing will show up in the frontend. Once issues are fixed, it should start populating
    • LDES-consumer polls every minute
    • LDES-consumer only keeps the latest snapshot
  • In the database, you can already find what we have so far; see queries.
@cecemel
cecemel / LPDC-brain-dump.md
Last active June 20, 2022 07:36
@cecemel
cecemel / test_deleted_to_detached_zope.py
Created August 21, 2017 08:56
listen to deleted_to_detached event trough zope
# from sqlalchemy import Integer, ForeignKey, String, Column, create_engine
# from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import relationship, Session
from sqlalchemy import event
from sqlalchemy import *
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import scoped_session, sessionmaker, relation
from zope.sqlalchemy import ZopeTransactionExtension, register
import transaction
@cecemel
cecemel / test_deleted_to_detached_sqlalchemy.py
Created August 21, 2017 08:53
listen to deleted_to_detached event with sql alchemy
from sqlalchemy import Integer, ForeignKey, String, Column, create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import relationship, Session
from sqlalchemy import event
Base = declarative_base()
class User(Base):
__tablename__ = 'user'