wcs-olap: build a start schema from data exported by w.c.s. API
Given such an .INI file:
[https://demarches.triffouilly.fr/]
orig = bi.triffouilly.fr
key = 452b8964
pg_dsn = dbname=publik-bi
email = bi@entrouvert.com
schema = triffouilly
# slugs = recette-technique-ajout-d-un-enfant
It builds a schema named 'triffouilly' in the pre-existing database named 'publik-bi', the schema will contains tables named:
channel (label varchar)
role (label varchar)
category (label varchar)
form (category, label)
formdata : parent table of all formdata tables)
(form, receipt_time, year, month, dow, hour, channel, backoffice, generic_status)
status (generic statuses: new, in progress & closed
label
for each formdef tables named:
formdata_{formdef.slug}
status_{formdef.slug}
for each anonymisable
2016-05-10 16:53:17 +02:00
|
|
|
#! /usr/bin/env python
|
|
|
|
|
|
|
|
import subprocess
|
|
|
|
import os
|
|
|
|
|
|
|
|
from setuptools import setup, find_packages
|
|
|
|
from setuptools.command.sdist import sdist
|
|
|
|
|
|
|
|
|
|
|
|
class eo_sdist(sdist):
|
|
|
|
def run(self):
|
|
|
|
if os.path.exists('VERSION'):
|
|
|
|
os.remove('VERSION')
|
|
|
|
version = get_version()
|
2020-01-30 21:03:06 +01:00
|
|
|
with open('VERSION', 'w') as fd:
|
|
|
|
fd.write(version)
|
wcs-olap: build a start schema from data exported by w.c.s. API
Given such an .INI file:
[https://demarches.triffouilly.fr/]
orig = bi.triffouilly.fr
key = 452b8964
pg_dsn = dbname=publik-bi
email = bi@entrouvert.com
schema = triffouilly
# slugs = recette-technique-ajout-d-un-enfant
It builds a schema named 'triffouilly' in the pre-existing database named 'publik-bi', the schema will contains tables named:
channel (label varchar)
role (label varchar)
category (label varchar)
form (category, label)
formdata : parent table of all formdata tables)
(form, receipt_time, year, month, dow, hour, channel, backoffice, generic_status)
status (generic statuses: new, in progress & closed
label
for each formdef tables named:
formdata_{formdef.slug}
status_{formdef.slug}
for each anonymisable
2016-05-10 16:53:17 +02:00
|
|
|
sdist.run(self)
|
|
|
|
if os.path.exists('VERSION'):
|
|
|
|
os.remove('VERSION')
|
|
|
|
|
|
|
|
|
|
|
|
def get_version():
|
|
|
|
'''Use the VERSION, if absent generates a version with git describe, if not
|
2020-01-30 21:03:06 +01:00
|
|
|
tag exists, take 0.0- and add the length of the commit log.
|
wcs-olap: build a start schema from data exported by w.c.s. API
Given such an .INI file:
[https://demarches.triffouilly.fr/]
orig = bi.triffouilly.fr
key = 452b8964
pg_dsn = dbname=publik-bi
email = bi@entrouvert.com
schema = triffouilly
# slugs = recette-technique-ajout-d-un-enfant
It builds a schema named 'triffouilly' in the pre-existing database named 'publik-bi', the schema will contains tables named:
channel (label varchar)
role (label varchar)
category (label varchar)
form (category, label)
formdata : parent table of all formdata tables)
(form, receipt_time, year, month, dow, hour, channel, backoffice, generic_status)
status (generic statuses: new, in progress & closed
label
for each formdef tables named:
formdata_{formdef.slug}
status_{formdef.slug}
for each anonymisable
2016-05-10 16:53:17 +02:00
|
|
|
'''
|
|
|
|
if os.path.exists('VERSION'):
|
|
|
|
with open('VERSION', 'r') as v:
|
|
|
|
return v.read()
|
|
|
|
if os.path.exists('.git'):
|
2020-01-30 21:03:06 +01:00
|
|
|
p = subprocess.Popen(
|
|
|
|
['git', 'describe', '--dirty=.dirty', '--match=v*'],
|
|
|
|
stdout=subprocess.PIPE, stderr=subprocess.PIPE)
|
wcs-olap: build a start schema from data exported by w.c.s. API
Given such an .INI file:
[https://demarches.triffouilly.fr/]
orig = bi.triffouilly.fr
key = 452b8964
pg_dsn = dbname=publik-bi
email = bi@entrouvert.com
schema = triffouilly
# slugs = recette-technique-ajout-d-un-enfant
It builds a schema named 'triffouilly' in the pre-existing database named 'publik-bi', the schema will contains tables named:
channel (label varchar)
role (label varchar)
category (label varchar)
form (category, label)
formdata : parent table of all formdata tables)
(form, receipt_time, year, month, dow, hour, channel, backoffice, generic_status)
status (generic statuses: new, in progress & closed
label
for each formdef tables named:
formdata_{formdef.slug}
status_{formdef.slug}
for each anonymisable
2016-05-10 16:53:17 +02:00
|
|
|
result = p.communicate()[0]
|
|
|
|
if p.returncode == 0:
|
2020-01-30 21:03:06 +01:00
|
|
|
result = result.decode('ascii').strip()[1:] # strip spaces/newlines and initial v
|
|
|
|
if '-' in result: # not a tagged version
|
|
|
|
real_number, commit_count, commit_hash = result.split('-', 2)
|
|
|
|
version = '%s.post%s+%s' % (real_number, commit_count, commit_hash)
|
|
|
|
else:
|
|
|
|
version = result
|
|
|
|
return version
|
wcs-olap: build a start schema from data exported by w.c.s. API
Given such an .INI file:
[https://demarches.triffouilly.fr/]
orig = bi.triffouilly.fr
key = 452b8964
pg_dsn = dbname=publik-bi
email = bi@entrouvert.com
schema = triffouilly
# slugs = recette-technique-ajout-d-un-enfant
It builds a schema named 'triffouilly' in the pre-existing database named 'publik-bi', the schema will contains tables named:
channel (label varchar)
role (label varchar)
category (label varchar)
form (category, label)
formdata : parent table of all formdata tables)
(form, receipt_time, year, month, dow, hour, channel, backoffice, generic_status)
status (generic statuses: new, in progress & closed
label
for each formdef tables named:
formdata_{formdef.slug}
status_{formdef.slug}
for each anonymisable
2016-05-10 16:53:17 +02:00
|
|
|
else:
|
2020-01-30 21:03:06 +01:00
|
|
|
return '0.0.post%s' % len(subprocess.check_output(['git', 'rev-list', 'HEAD']).splitlines())
|
|
|
|
return '0.0'
|
wcs-olap: build a start schema from data exported by w.c.s. API
Given such an .INI file:
[https://demarches.triffouilly.fr/]
orig = bi.triffouilly.fr
key = 452b8964
pg_dsn = dbname=publik-bi
email = bi@entrouvert.com
schema = triffouilly
# slugs = recette-technique-ajout-d-un-enfant
It builds a schema named 'triffouilly' in the pre-existing database named 'publik-bi', the schema will contains tables named:
channel (label varchar)
role (label varchar)
category (label varchar)
form (category, label)
formdata : parent table of all formdata tables)
(form, receipt_time, year, month, dow, hour, channel, backoffice, generic_status)
status (generic statuses: new, in progress & closed
label
for each formdef tables named:
formdata_{formdef.slug}
status_{formdef.slug}
for each anonymisable
2016-05-10 16:53:17 +02:00
|
|
|
|
|
|
|
|
2016-06-24 15:43:55 +02:00
|
|
|
setup(name="wcs-olap",
|
wcs-olap: build a start schema from data exported by w.c.s. API
Given such an .INI file:
[https://demarches.triffouilly.fr/]
orig = bi.triffouilly.fr
key = 452b8964
pg_dsn = dbname=publik-bi
email = bi@entrouvert.com
schema = triffouilly
# slugs = recette-technique-ajout-d-un-enfant
It builds a schema named 'triffouilly' in the pre-existing database named 'publik-bi', the schema will contains tables named:
channel (label varchar)
role (label varchar)
category (label varchar)
form (category, label)
formdata : parent table of all formdata tables)
(form, receipt_time, year, month, dow, hour, channel, backoffice, generic_status)
status (generic statuses: new, in progress & closed
label
for each formdef tables named:
formdata_{formdef.slug}
status_{formdef.slug}
for each anonymisable
2016-05-10 16:53:17 +02:00
|
|
|
version=get_version(),
|
|
|
|
license="AGPLv3+",
|
|
|
|
description="Export w.c.s. data to an OLAP cube",
|
|
|
|
long_description=open('README.rst').read(),
|
|
|
|
url="http://dev.entrouvert.org/projects/publik-bi/",
|
|
|
|
author="Entr'ouvert",
|
|
|
|
author_email="authentic@listes.entrouvert.com",
|
|
|
|
maintainer="Benjamin Dauvergne",
|
|
|
|
maintainer_email="bdauvergne@entrouvert.com",
|
|
|
|
packages=find_packages(),
|
|
|
|
include_package_data=True,
|
2020-01-30 21:03:06 +01:00
|
|
|
install_requires=[
|
|
|
|
'requests',
|
|
|
|
'psycopg2',
|
|
|
|
'isodate',
|
|
|
|
'six',
|
|
|
|
'cached-property'
|
|
|
|
],
|
wcs-olap: build a start schema from data exported by w.c.s. API
Given such an .INI file:
[https://demarches.triffouilly.fr/]
orig = bi.triffouilly.fr
key = 452b8964
pg_dsn = dbname=publik-bi
email = bi@entrouvert.com
schema = triffouilly
# slugs = recette-technique-ajout-d-un-enfant
It builds a schema named 'triffouilly' in the pre-existing database named 'publik-bi', the schema will contains tables named:
channel (label varchar)
role (label varchar)
category (label varchar)
form (category, label)
formdata : parent table of all formdata tables)
(form, receipt_time, year, month, dow, hour, channel, backoffice, generic_status)
status (generic statuses: new, in progress & closed
label
for each formdef tables named:
formdata_{formdef.slug}
status_{formdef.slug}
for each anonymisable
2016-05-10 16:53:17 +02:00
|
|
|
entry_points={
|
|
|
|
'console_scripts': ['wcs-olap=wcs_olap.cmd:main'],
|
|
|
|
},
|
|
|
|
cmdclass={'sdist': eo_sdist})
|