[server] Make connection pooler configurable and set better default values Drop the configuration connections-pool-size and add new configurations options: * connections-pool-min-size. Set to 0 by default so we open connections only when needed. This avoid opening min-size*processes connections at startup, which is, it think, a good default. * connections-pool-max-size. Set to 0 (unlimited) by default, so we move the bottleneck to postgresql. * connections-idle-timeout. Set to 10 minutes. I don't have arguments about this except that this is the default in pgbouncer.

[server] Enhance connections-pooler-enabled documentation

[server] move connection pooler initialization logic to get_cnxset() This avoid complex logic in Repository initialization.

[server] dynamically close idle database connections When pool hasn't been empty for `idle_timeout` time, start closing connections.

[server] implement dynamic database pooler Opening too much database connection has a cost at startup and also PostgreSQL as a maximum number of connection (100 by default). This get worse when starting multiple wsgi processes, since each process has its own database pool. Instead of opening `connections-pool-size` connections to the database at startup, just open one and open more only when needed.

[server] use a LifoQueue in _CnxSetPool In postgresql, some cache is attached to the connection. Using a LifoQueue (last-in, first-out) makes a few connections to get the most load which give best performance.

[server] extract creating a new cnxset in a _new_cnxset() helper So we can move logic specific to _CnxSetPool here.

[server] avoid a possible race condition on _CnxSetPool.close() The pool could become empty between time to check and time to use.

[server] extract "no pooler" CnxSet class to a _BaseCnxSet class So we get rid of "if self._queue is None" in each method of _CnxSetPool Also add helper get_cnxset(source, size) to instantiate the correct pooler class.

[server] prevent returning closed cursor to the database pool In since c8c6ad8 init_repository use repo.internal_cnx() instead of repo.system_source.get_connection() so it use the pool and we should not close cursors from the pool before returning it back. Otherwise we may have "connection already closed" error. This bug only trigger when connection-pool-size = 1. Since we are moving to use a dynamic pooler we need to get this fixed. This does not occur with sqlite since the connection wrapper instantiate new cursor everytime, but this occur with other databases.

[rql] Store selected variables for RQL select queries in ResultSet (#17218476) By storing the name of the selected variables for RQL select queries in the ResultSet (within the "variables" attribute), the information can be passed down to specific protocols, e.g. rqlio that may wish to pass is down further to clients. In turn, clients can then choose to present the results of RQL select queries as symbolic bindings using the names used in the query's projection, instead of ordinal arrays.

[debugtoolbar] Make SQL and RQL tables sortable It's usefull to sort query by duration for instance.

[debugtoolbar] Do not render CW controller panel when no controller got collected This can happen on pure pyramid applications for instance.

[doc] Fix bugs in code examples

[doc] Remove zone cube which causes to crash on install The zone cube is not compatible with python3.

[doc] Precise which component to modify in gallery tutorial

[doc] Fix example about Community view customization

[doc] Add command pip install of new cube

[doc] update cubicweb version

[doc, blog tutorial] Remove cubicweb-dev from pip dependencies This pip package does not exist

[doc] Add requirement for gettext and graphviz When running the tutorial from scratch, I had errors because these two packages were not installed.

Added tag 3.27.3, debian/3.27.3-1 for changeset 85284f028266

[pkg] version 3.27.3

[pkg] require python >= 3.6 in debian packaging

[pkg] merge 3.27 Require python >= 3.6 since recent typing notations require >= 3.6

[pkg] add python3 only pypi specifiers This is only for pypi statistics purposes. Also add 'Programming Language :: Python', looks obvious but seems to be sane to have this as well.

[pkg] the wheel is no longer universal Since we're only py3 compatible. In practice this changes nothing since we don't upload cubicweb wheels to pypi.

[pkg] require python >= 3.4 This avoid pip pulling a version that does not run on python2 when using a python2 environment. Since we already released some 3.27 releases in pypi, I think we should release 3.27.3 and remove releases 3.27.2, 3.27.1 and 3.27.0 from pypi.

merge public heads

[web.views] add Link alternate in HTTP response header in HTML view Team: famarger, schabot, nchauvat, fferry, ethieblin

[pyramid] add routes /{eid} and /{etype}/{eid} to return RDF when rdf mimetype in Accept HTTP headers * simplify pyramid/resources.py by making the classmethod that returns a closure a simple function and removing the EntityResource and ETYpeResource classes that are barely used * replace predicate MatchIsETypePredicate with MatchIsETypeAndEIDPredicate Team: famarger, schabot, nchauvat, fferry, ethieblin

[entities] simplify rdf generation and add a generic rdf adapter Team: famarger, schabot, nchauvat, fferry, ethieblin

Added tag 3.26.17, debian/3.26.17-1 for changeset 5c6d242069b6

[pkg] version 3.26.17

[fix, calendar] Ensure that the buffer is a string 'unicode' is not defined in python3

Added tag 3.26.16, debian/3.26.16-1 for changeset fb6aecd654a3

[pkg] version 3.26.16

[ldapfeed] add option to enable starttls on ldap servers Modern ldap servers connection often use, or even require starttls.

[ldapfeed] re-enable ldap tests for python 3.7 This was disabled because ldap3<2 wasn't compatible with python 3.7 While I'm here, drop unseless newline.

[ldapfeed] make code compatible with ldap3>=2 * Some constants have been renamed. * Directly bind when data-cnx-dn/data-cnx-password are provided, some servers, including ours require this. * Use raise_exceptions=True to avoid ignored ldap errors * raise in case of failed anonymous bind * do not search for "dn" attribute because this raise an "invalid attribute" with new ldap3 versions * Password is now returned as bytes, so no longer need to encode them before crypt. * modification_date is now returned as a datetime object Co-Authored-By: Philippe Pepiot <philippe.pepiot@logilab.fr> Closes #16073071

[ldapfeed] use LDAP_SCOPES to find user-scope We already have LDAP_SCOPES dict defining possible scopes, this avoid possible code injection from config... Thus we can drop global variables already defined in LDAP_SCOPES since they are not used directly anymore.

Merge 3.27

Added tag 3.27.2, debian/3.27.2-1 for changeset e731c31eaed0

[pkg] version 3.27.2

[ldapfeed] add option to enable starttls on ldap servers Modern ldap servers connection often use, or even require starttls.

[ldapfeed] re-enable ldap tests for python 3.7 This was disabled because ldap3<2 wasn't compatible with python 3.7 While I'm here, drop unseless newline.

[ldapfeed] make code compatible with ldap3>=2 * Some constants have been renamed. * Directly bind when data-cnx-dn/data-cnx-password are provided, some servers, including ours require this. * Use raise_exceptions=True to avoid ignored ldap errors * raise in case of failed anonymous bind * do not search for "dn" attribute because this raise an "invalid attribute" with new ldap3 versions * Password is now returned as bytes, so no longer need to encode them before crypt. * modification_date is now returned as a datetime object Co-Authored-By: Philippe Pepiot <philippe.pepiot@logilab.fr> Closes #16073071

[ldapfeed] use LDAP_SCOPES to find user-scope We already have LDAP_SCOPES dict defining possible scopes, this avoid possible code injection from config... Thus we can drop global variables already defined in LDAP_SCOPES since they are not used directly anymore.

[ldapfeed] drop now useless import from __future__

[rdf] Add a basic foaf adapter for CWUser By the way, use RDFLib namespaces

[rdf] add functions and tools to generate rdf graph

[pyramid, predicate] Add a predicate that matches if the pattern is an eid in the DB

[server.querier] construct ExecutionPlan from schema since querier is not needed

[server.querier] remove useless attribute Querier._planner

[server.querier] remove useless indirection Querier.rqlannotator

[server.querier] remove useless indirections ExecutionPlan.{syssource,rqlhelper,schema} Simpler is better.

[server.rqlannotation] rename SQLGenAnnotator to RQLAnnotator This class is in charge of annotating the RQL syntax tree with various bits of information, like (in)variance, use of full-text-index, etc. It is a needed step before the generation of SQL, but does not touch SQL directly. Hence RQLAnnotator seems a better name.

[server] drop system_source_cnx for a simpler internal API system_source_cnx() can be replaced with source_cnx(). If system_source_cnx() is called with dbms_system_base=False, it is strictly equivalent to calling source_cnx() with the same source, privileges and interactivity. If system_source_cnx() is called with dbms_system_base=True, it is equivalent to calling source_cnx() with the system database and the same source, privileges and interactivity. No use of the default value for 'special_privs' was found in the code.

[server/sources/native] refactor to remove useless injection

[cwvreg] rename CWRegistryStore.solutions to compute_var_types solutions() seems an obscure name to me. Since this method computes the types of the variables of the RQL query string, let us rename it to compute_var_types.

[doc] replace python with python3 in shell commands

[adapters] move class EntityAdapter from cubicweb.view to cubicweb.entity The adapter mechanism is not specific to the use of views. Moving the class the cubicweb.entity makes this clearer.

[doc] replace tabs with spaces (and make linter happy)

[setup] add rdflib-jsonld to dependencies for cubicweb[rdf]

Added tag 3.26.15, debian/3.26.15-1 for changeset fe9bd0e937e4

[pkg] version 3.26.15

[web/views] Backport changeset be63e0fd43d0 (it is a fix) in 3.26

[utils] Add the possibility to add elements in the head of an UStringIO list

[doc] replace python with python3 in shell commands

Added tag 3.27.1, debian/3.27.1-1 for changeset 917601bb5b1b

[pkg] version 3.27.1

Backed out changeset 7d3299d6e655 This is not compatible with python 3.5 and we want to support python 3.5 with cubicweb 3.27

Backed out changeset c69421aece24 This is not compatible with python 3.5 and we want to support python 3.5 with cubicweb 3.27

merge

[web/views/rdf] enhance encoding and formats for RDFView

[web/views/cwuser] fix encoding of FoafView to application/rdf+xml

merge 3.27 into default

[doc/dev/CI] initial information about jenkins

[doc/index] fix link to "how to contribute" and add link to dev dashboard

[doc/book/admin] initial version of deploy cubicweb page in documentation

[doc/book/admin/setup] forget about easy_install

[doc/book/admin/setup] fix pip / virtualenv links

[doc/book/admin/setup] update apt sources

[doc/book/admin/setup] add section about docker install

[doc] remove setup instructions for Windows

[doc/book/devweb/ajax] warning about deprecated use of ajax

[doc] add links to pypi and npm

[doc] remove guestrepo as a recommendation

[doc] remove Subversion mentions

[doc] fix typo

[doc] Update changes title, 3.27 is now released

[pkg] Version 3.28.0.dev0

merge 3.27

Added tag 3.27.0, debian/3.27.0-1 for changeset e77900f19390

[pkg] version 3.27

Backed out changeset b1ef9690f357 This is not compatible with python3.5

Remove useless error FindEntittyError This error is not used since the deprecated find_one_entity method has been removed in 566f8fce5168

[pkg] Version 3.27.0rc3

[sobjects/notification] fix broken email notifications In https://hg.logilab.org/review/cubicweb/rev/8caa109dfe945592a34904bb56971cc57d1c6084 EntityView.w become a method using EntityView._w In notifications we reset "self.w" for every notifications since we handle multiple streams. We should set "self._w" to None instead, otherwise subsequent calls to "self.w()" will fail with TypeError: 'NoneType' object is not callable.

[server.source.native] exceptions should never pass silently

[py] Make flake8 less angry with cubicweb/server/test/

[doc/fix] correct link to screenshots in changelog Closes #17260396

closing branch 3.23

closing branch 3.22

closing branch 3.21

closing branch 3.20

[server/querier] drop ExecutionPlan.annotate_rqlst that is never used

[server.querier] improve docstrings and comments

[mypy] type AppObject.category

[mypy] type Hook.events

[mypy] type __select__ everywhere

[python3] 'unicode' function doesn't exist anymore

[mypy/fix] Incompatible types in assignment (expression has type "staticmethod", variable has type "Callable[[ETag], Any]")

[py] Make flake8 less angry with cubicweb/server/sources/

[mypy/fix] Module 'urllib' has no attribute 'quote'

autopep8

[python3] replace 'unicode' by 'str'

autopep8

[test] ensure FirefoxHelper successfully exited

[test/ux] add a warning when test from FirefoxHelper timeout

[test/fix] tempfile is non portable linux command and is useless here Closes #17260390

[test/fix] prevent FirefoxHelper from silently failing to start This was breaking some tests without any obvious error message and you should fail as early as possible to make debugging easier. Closes #17260390

[doc] document debug toolbar

[doc] document new debug channels mechanism

DeprecationWarning: Please use assertEqual instead.

[doc/fix] listing of js_api in index was broken

[doc] cubicweb.server.session.Session doesn't exist anymore

[doc] remove autodoc for functions and class that don't exist anymore

[doc/fix] BwCompatCWRegistry class doesn't exist anymore

[doc] set_/free_cnxset method doesn't exist anymore

[refactoring] rename logilab.database as db to logilab_database

[UX] make error message explicit with useful information

[refactoring] blank lines to visually group lines for lisbility

[refactoring] class variable is useless

[comment] add comment for maybe unhandled situation

[refactoring] don't hide exceptions

[refactoring] blank lines to make core more readable

[refactoring] not needed anymore in python3

[refactoring] inline useless variable

[debug_channels/doc] add docstring to functions

[doc/building/fix] encoding issue was crashing sphinx in python3

[pkg] Version 3.27.0rc2

[changelog] talk about the new debug channels mechanism

[changelog] add information about the new debug html attributes

[changelog] change bullet point organization So everything related to the debugtoolbar is close to its section.

[changelog] document the new toolbar panels with screenshots

[comment] comment didn't matched reality

[debug-toolbar/display_source_code] change link display from "<>" to "[source]" It is way more explicit and understandable and doesn't take that much place.

[tox] add doc8 target to test documentation

[doc8] D002 Trailing whitespace

[doc/conf] update year of copyright

[doc/book] add RQL use cases with search/card/python/javascript Related to https://www.cubicweb.org/ticket/3899077

[debug-toolbar/fix] only import mako when the toolbar is loaded

[pkg] require logilab-common >= 1.5.2 Followup a902521

[web/views] Fix AutoformSectionRelationTags.set_muledit_editable It is a method call, so `self` is passed implicitely as first argument, so it is useless to pass it also explicitely as second argument. In fact, it does not work without this. A monkey patch had been done in a private client's project, but the fix is revelant for everyone.

[html] Add tags ol, ul, li, i, q - It is useful. - A private client's project use this.

[debug-toolbar/registry] move to Registry.add_select_best_listener new api

[pkginfo] Retrieve Cubicweb version using pkg_resources

[pkginfo] Remove unused parameter To retrieve cube dependencies or cube requirements, no more need to pass the 'oldkey' parameter to _cube_deps function as this parameter is unused.

Fix flake8 issues cubicweb/server/sources/native.py:505: [E501] line too long (101 > 100 characters) cubicweb/pyramid/__init__.py:31: [E501] line too long (104 > 100 characters)

Add missing dbmako/mako files in python sdist

[debug] add in each html snippet from where it has been generated in the code Closes #17219704

Use python3 shebang for scripts Reported by lintian "python-script-but-no-python-dep"

[pkg] Version 3.27.0rc1

[debug-toolbar/display_source_code] add links to files in tracebacks

[debug-toolbar] link to source code of all objects/classes Closes #17256791

[debug-toolbar/display_source_code] add a function to add links to source file in traceback Closes #17256791

[debug-toolbar/display_source_code] add function to generate html link to source code

[debug-toolbar/display_source_code/security] add security mechanism to only read whitelisted files Closes #17256791

[debug-toolbar/display_source_code] add helper to render link to source file Closes #17256791

[debug-toolbar/display_source_code] add a pyramid view that display syntax highlighted python source file This will be used for tool building for easier debugging. Closes #17256791

[mod] allow to pass generic additional arguments to pygments HtmlFormatter

[debug/fix] ensure that not syntax highlighted code is a string Otherwise it could be in another unrendered form that makes marko complains. Closes #17256791

[debug-toolbar] add registry decisions debug panel Closes #17219866

Increase needed version of logilab-common to >= 1.5.0

[debug-toolbar] add registry panel Closes #17219866

[debug-toolbar] add sql panel Closes #17219873

[debug-toolbar] add cw general panel with controller Closes #17219897

[debug-toolbar] make linter happy

[pyramid/ctl/debugtoolbar] automatically include custom panels on -t

[debug-toolbar/rql] display sql queries generated by rql ones

[debug-toolbar/rql] add RQL panel Closes #17219673

[debug/emit/rql] add RQL debug channel and emit queries This is used for the RQL debug panel but can be used as a generic mechanism for several tools.

[debug/source_highlight] rename highlight to highlight_terminal

[debug/source_highlight] add highlight_html and generate_css for debugtool panels

[debug/rql] bind a uniq token per rql to trace its decomposition This is aimed to be used by the RQL debug panel (and the SQL one later on) but can also be used by other debugging tools.

[debug] add a new channel events mechanism for debugging

[ctl] allow to specific instance name for instance commands in $CW_INSTANCE Closes #17253994

[cubicweb/utils] add QueryCache.__contains__() to improve dict-like behavior. Closes #255426

[migrations/pdb] add to every failing migration operation a "p(db)" option Instead, the migration command will just crash without offering the possibility of the user to debug or continue the migration. Closes #17219772

[pyramid/ctl] add a new option to activate the debugtoolbar (-t) While this toolbar isn't yet very integrated with CW, it integrates an inline debugging shell like werkzeug for flask or django_extensions which greatly helps debugging on exception. It can already be manually activated by writting "pyramid.includes = pyramid_debugtoolbar" but it's hidden somewhere in the documentation and not very accessible and annoying to do. Closes #17219765

[changelog] add missing information to the 3.27 changelog

Merge 3.26

[debug] add ALL possibility to --dbglevel

[ux] display instance name in suggested upgrade command

[migration/pdb] display traceback instead of only the exception for easier debugging Closes #17219820

[migration/pdb] add option to use pdb.post_mortem if traceback is provided Post mortem is a mode where the pdb shell is opened **where** the exception as occured instead at the breakpoint for set_trace. This is way more useful for debugging for the user because is will have the full context of the error. Closes #17219827

[migration/shell] select ipdb if present on (d)ebug mode Closes #17219833

[mod] move get_pdb to utils.py

Add a migration function in order to relocate bfss Related to https://www.cubicweb.org/ticket/1903304

[pyramid/debug] on every request display request path and selected controller This will display lines like: 2019-06-12 16:26:57 - (cubicweb.pyramid.bwcompat) INFO: REQUEST [view] '/wiki/334037' selected controller <cubicweb.web.views.basecontrollers.ViewController object at 0x7f133802ae90> at /root/.virtualenvs/abreton/local/lib/python2.7/site-packages/cubicweb/web/views/basecontrollers.py:120 2019-06-12 16:26:59 - (cubicweb.pyramid.bwcompat) INFO: REQUEST [data] '/data/ea5eb3b6f89fba0ff4b671093c88d3dd/images/cartouche-mur.jpg' selected controller <cubicweb.web.views.staticcontrollers.DataController object at 0x7f1332a84d50> at /root/.virtualenvs/abreton/local/lib/python2.7/site-packages/cubicweb/web/views/staticcontrollers.py:179 The make debugging easier as this isn't done already. Most other web frameworks do something similar for the developper to be able to understand what is happening right now. Closes #17219741

[logging/debug] move transaction operations logs from self.debug to DBG_OPS There were a mixing between displaying transaction operations log on logger.debug and only when DBG_OPS was on, uniformize everything behind DBG_OPS. Closes #17229126

[debug] syntax highlight SQL and RQL debug output This prevent DBG_RQL and DBG_SQL output to looks like a gigantic blob of white text. Do this only if we detect that we are in a tty and that pygments is installed. Closes #17222885

[logging] send logs by default to stdout Following the move to have commands only working on foreground sending logs to a file by default doesn't make much more sens anymore so send them to stdout by default and add a new option to send them to a file if needed

[cubicweb-ctl] backport --dbglevel option of pyramid to all instance commands Closes #17219653

[cubicweb-ctl] backport --loglevel option of pyramid to all instance commands

[cubicweb-ctl/fix] correctly get exception traceback_ for pdb.post_mortem In python 3 the behavior of sys.exc_info had a very subtle change: - in python 2 you can call if whenever you want after a try/except statement and you'll get information about this last raise - ipython 3, once you get out of try/except, sys.exc_info is cleaned and you'll get (None, None, None) Hardened the test to avoid this error from happening again.

Document mercurial configuration for contributing * how to use master/review repositories * how to send the "Available at" command in patchbomb emails * how to add the "cubicweb" flag in patchbomb emails * how to use our "jenkins" mercurial extension Closes #17243538

Add documentation on workflow permission

Remove undefined function in documentation

Merge 3.26

[pyramid/ctl] pyramid command will always run in foreground from now on Daemonization used to make sens in the past, but today "pyramid" command is only used for dev and should never be used for deployement (you should use a wsgi server for that instead) so daemonization doesn't fit any use case anymore. Closes #17232923

[clean] remove pyramid warning about looping task This warning isn't useful anymore.

[doc] add instruction to re-enable ckeditor

[fix] reference to underclared and unused variable kwargs

Avoid to update inlined relation column to NULL when deleting entities When deleting entities, cubicweb run a rql DELETE on all relations to trigger hooks. For an inlined relation this also mean set the column to NULL. This operation may fail if there's additional constraints on the column. Also this is a weird and useless behavior since deleting the entity row will by definition delete the relation. We still doesn't handle the case where both subject and object are going to be deleted because rows need to be deleted in a particular order that cubicweb doesn't handle. Add a test checking UPDATE does not occur but hooks are correctly called. Closes #17236690

Drop useless ConstraintInsertionTC This test does nothing and is here from the begining of repo history. Now it raise an error "TypeError: Skipped expected string as 'msg' parameter, got 'SkipTest' instead. Perhaps you meant to use a mark?" Just drop it.

Backed out changeset 741dc2590f90 It was for cube s3storage, but this piece of information was apparently not in the email (used for review), so this patch was published in the wrong repository. :-/

[.gitlab-ci] initial version (tox targets)

Merge with 3.26

Added tag debian/3.26.14-1, 3.26.14 for changeset 172f683a84f6

[pkg] version 3.26.14

[py3] Pass bytes as "msg" to smtplib.SMTP.sendmail() When passing a unicode string to smtplib.SMTP.sendmail() as "msg" argument, there is an implicit bytes encoding using "ascii" encoding in python3. Of course this does not work if the string contains non-ASCII characters. In fact, config's sendmails method intent to pass bytes to smtplib.SMTP.sendmail() as it uses msg.as_string() method. Unfortunately, in python3, this method returns a unicode string whereas it returns a bytes string in python2; we thus fix this by calling as_bytes() method on python3. As there is no "as_bytes" method in python2, we need to handle python2 compatibility by hand and either call as_string() or as_bytes(). In testlib, where we mock smtplib.SMTP, we need to keep the "msg" argument of Email class (defined in testlib as well) a unicode string. Otherwise, it fails to be parsed by email.message_from_string() (from stdlib) if it is bytes on python3.

[debian] Cleanup d/source/options from now gone symlinks

[pkg] Version 3.27.0.a2

[debug/clean] remove unused DBG_MS flag

Avoid using gone hooks_control() in migration This deprecated function got dropped in a8c1ea390400. Remove unused import in 3.10.9_Any.py migration; replace usage in bootstrapmigration_repository.py by non-deprecated form.

[tox] Remove --ignore in check-manifest check All symlinks have been dropped in previous changesets.

[doc] link to 3.27 (and missing 3.26) pages

[pkg] Version 3.27.0a1

[test] Replace symlinks by real copies This solves a "python setup.py build" issue.

[pkg] Version 3.27.0a0

Merge with 3.26

Added tag debian/3.26.13-1, 3.26.13 for changeset 1fc684253207

[pkg] Version 3.26.13

[test] Replace symlinks in legacy_cubes by real copies This solves a "python setup.py build" issue on my machine. Copying these files should not be a big deal because they have been dropped in the "default" branch and we would not touch them in 3.26 branch.

[pkg] Prune packaging files from sdist

[pkg] Fix spelling mistake in doc-base abstract

[pkg] Fix doc-base section As pointed by Lintian, the “Apps” section is only used in menu, not in doc-base. We can just remove it.

[pkg] Move lintian-overrides file to debian/source directory Just use the now preferred location.