Abstract the support for ORDER BY and LIMIT/OFFSET SQL generation
all DB engines do not support the same syntax for these features, MS SQLServer being the bad boy we try to support in CW.
* Use two new methods of dbhelper to add LIMIT/OFFSET clauses and ORDER BY clauses
* added unit tests for sqlserver backend
* changed unittest_rql2sql to lauch the backend tests even if the driver module is not installed on the machine, so
that we can run the sqlserver tests on linux (and the mysql tests too)
* adapt msstep.py to the new interface
closes #1154756
Source: cubicwebSection: webPriority: optionalMaintainer: Logilab S.A. <contact@logilab.fr>Uploaders: Sylvain Thenault <sylvain.thenault@logilab.fr>, Julien Jehannet <julien.jehannet@logilab.fr>, Adrien Di Mascio <Adrien.DiMascio@logilab.fr>, Aurélien Campéas <aurelien.campeas@logilab.fr>, Nicolas Chauvat <nicolas.chauvat@logilab.fr>Build-Depends: debhelper (>=7), python (>=2.5), python-central (>=0.5)Standards-Version: 3.9.1Homepage: http://www.cubicweb.orgXS-Python-Version: >= 2.5, << 2.7Package: cubicwebArchitecture: allXB-Python-Version: ${python:Versions}Depends: ${misc:Depends}, ${python:Depends}, cubicweb-server (=${source:Version}), cubicweb-twisted (=${source:Version})XB-Recommends: (postgresql, postgresql-plpython) | mysql | sqlite3Recommends: postgresql|mysql|sqlite3Description: the complete CubicWeb framework CubicWeb is a semantic web application framework. . This package will install all the components you need to run cubicweb on a single machine. You can also deploy cubicweb by running the different process on different computers, in which case you need to install the corresponding packages on the different hosts.Package: cubicweb-serverArchitecture: allXB-Python-Version: ${python:Versions}Conflicts: cubicweb-multisourcesReplaces: cubicweb-multisourcesProvides: cubicweb-multisourcesDepends: ${misc:Depends}, ${python:Depends}, cubicweb-common (=${source:Version}), cubicweb-ctl (=${source:Version}), python-logilab-database (>=1.4.0), cubicweb-postgresql-support|cubicweb-mysql-support|python-pysqlite2Recommends: pyro (<<4.0.0), cubicweb-documentation (=${source:Version})Description: server part of the CubicWeb framework CubicWeb is a semantic web application framework. . This package provides the repository server part of the system. . This package provides the repository server part of the library and necessary shared data files such as the schema library.Package: cubicweb-postgresql-supportArchitecture: all# postgresql-client packages for backup/restore of non local databaseDepends: ${misc:Depends}, python-psycopg2, postgresql-clientDescription: postgres support for the CubicWeb framework CubicWeb is a semantic web application framework. . This virtual package provides dependencies to use postgres for the cubicweb repository.Package: cubicweb-mysql-supportArchitecture: all# mysql-client packages for backup/restore of non local databaseDepends: ${misc:Depends}, python-mysqldb, mysql-clientDescription: mysql support for the CubicWeb framework CubicWeb is a semantic web application framework. . This virtual package provides dependencies to use mysql for the cubicweb repository.Package: cubicweb-twistedArchitecture: allXB-Python-Version: ${python:Versions}Provides: cubicweb-web-frontendDepends: ${misc:Depends}, ${python:Depends}, cubicweb-web (=${source:Version}), cubicweb-ctl (=${source:Version}), python-twisted-webRecommends: pyro (<<4.0.0), cubicweb-documentation (=${source:Version})Description: twisted-based web interface for the CubicWeb framework CubicWeb is a semantic web application framework. . This package provides a twisted based HTTP server to serve the adaptative web interface (see cubicweb-web package). . This package provides only the twisted server part of the library.Package: cubicweb-webArchitecture: allXB-Python-Version: ${python:Versions}Depends: ${misc:Depends}, ${python:Depends}, cubicweb-common (=${source:Version}), python-simplejson (>=1.3)Recommends: python-docutils, python-vobject, fckeditor, python-fyzz, python-imaging, python-rdflibDescription: web interface library for the CubicWeb framework CubicWeb is a semantic web application framework. . This package provides an adaptative web interface to the CubicWeb server. Install the cubicweb-twisted package to serve this interface via HTTP. . This package provides the web interface part of the library and necessary shared data files such as defaut views, images...Package: cubicweb-commonArchitecture: allXB-Python-Version: ${python:Versions}Depends: ${misc:Depends}, ${python:Depends}, graphviz, gettext, python-logilab-mtconverter (>=0.8.0), python-logilab-common (>=0.55.0), python-yams (>=0.30.4), python-rql (>=0.28.0), python-lxmlRecommends: python-simpletal (>=4.0), python-cryptoConflicts: cubicweb-coreReplaces: cubicweb-coreDescription: common library for the CubicWeb framework CubicWeb is a semantic web application framework. . This package provides the common parts of the library used by both server code and web application code.Package: cubicweb-ctlArchitecture: allXB-Python-Version: ${python:Versions}Depends: ${misc:Depends}, ${python:Depends}, cubicweb-common (=${source:Version})Description: tool to manage the CubicWeb framework CubicWeb is a semantic web application framework. . This package provides a control script to manage (create, upgrade, start, stop, etc) CubicWeb applications. It also include the init.d script to automatically start and stop CubicWeb applications on boot or shutdown.Package: cubicweb-devArchitecture: allXB-Python-Version: ${python:Versions}Depends: ${misc:Depends}, ${python:Depends}, cubicweb-server (=${source:Version}), cubicweb-web (=${source:Version}), python-pysqlite2Suggests: w3c-dtd-xhtmlDescription: tests suite and development tools for the CubicWeb framework CubicWeb is a semantic web application framework. . This package provides the CubicWeb tests suite and some development tools helping in the creation of application.Package: cubicweb-documentationRecommends: doc-baseDescription: documentation for the CubicWeb framework CubicWeb is a semantic web application framework. . This package provides the system's documentation.