aviau
6aa73d0ecc
dakweb: create /source/by_metadata
|
6 anos atrás | |
|---|---|---|
| .. | ||
| queries | 6 anos atrás | |
| README | 7 anos atrás | |
| __init__.py | 10 anos atrás | |
| dakweb.wsgi | 10 anos atrás | |
| dakwebserver.py | 6 anos atrás | |
| webregister.py | 6 anos atrás | |
README
We are happy to add features to dakweb if you have a need for them.
Here are a few tips to help you get started on creating a dakweb patch:
1. dakweb is implemented in Python, using the bottle web microframework and the
sqlalchemy ORM (object relational mapper).
In a nutshell, bottle allows us to expose Python functions via
HTTP. Parameters are automatically taken from the @bottle.route function
annotation and passed to the function.
For upstream documentation, see:
https://bottlepy.org/docs/dev/
http://www.sqlalchemy.org/
When browsing upstream documentation, keep in mind that we are using the
versions installed on mirror.ftp-master.debian.org, which is usually running
Debian stable. In other words: the latest documentation might not be
applicable yet.
2. The bulk of adding a new query is coming up with the actual database query
(as opposed to the plumbing). To get fast turn-around times while developing,
you can use the ipython REPL:
% ssh mirror.ftp-master.debian.org
mirror % cd /srv/ftp-master.debian.org/dak/
mirror % PYTHONPATH=. ipython
ipython % from daklib.dbconn import *
ipython % s = DBConn().session()
Then, to evaluate a query, construct it and call the all method, e.g.:
ipython % s.query(DBBinary.package, DBSource.source, SourceMetadata.value).join(DBSource).join(SourceMetadata).join(MetadataKey).filter(MetadataKey.key == 'Go-Import-Path').group_by(DBBinary.package, DBSource.source, SourceMetadata.value).all()
Here are a few tips to help you get started on creating a dakweb patch:
1. dakweb is implemented in Python, using the bottle web microframework and the
sqlalchemy ORM (object relational mapper).
In a nutshell, bottle allows us to expose Python functions via
HTTP. Parameters are automatically taken from the @bottle.route function
annotation and passed to the function.
For upstream documentation, see:
https://bottlepy.org/docs/dev/
http://www.sqlalchemy.org/
When browsing upstream documentation, keep in mind that we are using the
versions installed on mirror.ftp-master.debian.org, which is usually running
Debian stable. In other words: the latest documentation might not be
applicable yet.
2. The bulk of adding a new query is coming up with the actual database query
(as opposed to the plumbing). To get fast turn-around times while developing,
you can use the ipython REPL:
% ssh mirror.ftp-master.debian.org
mirror % cd /srv/ftp-master.debian.org/dak/
mirror % PYTHONPATH=. ipython
ipython % from daklib.dbconn import *
ipython % s = DBConn().session()
Then, to evaluate a query, construct it and call the all method, e.g.:
ipython % s.query(DBBinary.package, DBSource.source, SourceMetadata.value).join(DBSource).join(SourceMetadata).join(MetadataKey).filter(MetadataKey.key == 'Go-Import-Path').group_by(DBBinary.package, DBSource.source, SourceMetadata.value).all()