sqlobject-cvs

[Oleg B. <no...@so...>]

This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "SQLObject development repository".

The branch, master has been updated
       via  105482c683f49316620c7ff64396192c8abb3942 (commit)
       via  0f4fb0fa1f774e6f2ec531c67ba4e97fb9ff6939 (commit)
       via  ee15cd6bd42ec42eaa0d00e1058d6ebc7dd0aafe (commit)
       via  ee704768917d455c0f90a763082494ad94634385 (commit)
       via  d0ec9104a802b6f8491b9ba3cc5813e7b81edda5 (commit)
       via  966f671ec2d5f52ea98f36205476a039eafc56ea (commit)
       via  f1dea2688494b18b939641b4b3af2670cab88935 (commit)
       via  7a8467679c84b4299b0f98961211756c8b09fc65 (commit)
       via  4825b7585632b421d6b594a169387e29cff69b5a (commit)
       via  be944d0c2a185d49b0578bf5b86e1c2e4e5c1b0c (commit)
      from  54828276f33faf5bfb476ab88435a5f797a0a870 (commit)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------
http://sourceforge.net/p/sqlobject/sqlobject/ci/105482c683f49316620c7ff64396192c8abb3942

commit 105482c683f49316620c7ff64396192c8abb3942
Author: Oleg Broytman <ph...@ph...>
Date:   Fri Jan 13 21:53:11 2017 +0300

    Update News: add appveyor for windows testing
    
    [skip ci]

diff --git a/docs/News.rst b/docs/News.rst
index 0ec2c98..f83bee3 100644
--- a/docs/News.rst
+++ b/docs/News.rst
@@ -25,8 +25,7 @@ Minor features
   order. pyfirebirdsql is supported but untested.
 
 * Add ``driver`` keyword for MySQLConnection. Allowed value are 'mysqldb',
-  'connector', 'oursql' and 'pymysql'. Default is to test for mysqldb only;
-  (connector, oursql and pymysql drivers still cause problems).
+  'connector', 'oursql' and 'pymysql'. Default is to test for mysqldb only.
 
 * Add support for `MySQL Connector
   <https://pypi.python.org/pypi/mysql-connector>`_ (pure python; `binary
@@ -49,10 +48,10 @@ Drivers (work in progress)
   are still problems with the driver.
 
 * Add support for `pg8000 <https://pypi.python.org/pypi/pg8000>`_
-  PostgreSQL driver. There are major problems with the driver.
+  PostgreSQL driver. There are major problems with the driver caused by both
+  the driver and SQLObject.
 
-* Add support for `pyfirebirdsql
-  <https://pypi.python.org/pypi/firebirdsql>`_ (untested).
+* Add support for `pyfirebirdsql <https://pypi.python.org/pypi/firebirdsql>`_.
 
 Documentation
 -------------
@@ -80,6 +79,9 @@ Tests
 * Run at Travis CI tests with Firebird backend (server version 2.5; drivers fdb
   and firebirdsql). There are problems with tests.
 
+* Add appveyor for windows testing. Run tests with Postgres and MS SQL. There
+  are problems.
+
 SQLObject 3.1.0
 ===============
 

http://sourceforge.net/p/sqlobject/sqlobject/ci/0f4fb0fa1f774e6f2ec531c67ba4e97fb9ff6939

commit 0f4fb0fa1f774e6f2ec531c67ba4e97fb9ff6939
Merge: 5482827 ee15cd6
Author: Oleg Broytman <ph...@ph...>
Date:   Fri Jan 13 22:49:57 2017 +0400

    Merge pull request #132 from drnlm/feature/add_appveyor_for_windows_testing
    
    Add appveyor for windows testing


http://sourceforge.net/p/sqlobject/sqlobject/ci/ee15cd6bd42ec42eaa0d00e1058d6ebc7dd0aafe

commit ee15cd6bd42ec42eaa0d00e1058d6ebc7dd0aafe
Author: Neil <drn...@gm...>
Date:   Fri Jan 13 20:05:01 2017 +0200

    Drop -v for pymssql. Use postgres test order so more tests are run before timeout issues kick in

diff --git a/tox.ini b/tox.ini
index 116c698..ed162c5 100644
--- a/tox.ini
+++ b/tox.ini
@@ -257,7 +257,8 @@ commands = flake8 .
 commands =
     -sqlcmd -U sa -P "Password12!" -S .\SQL2014 -Q "DROP DATABASE sqlobject_test"
     sqlcmd -U sa -P "Password12!" -S .\SQL2014 -Q "CREATE DATABASE sqlobject_test"
-    pytest -v --timeout=30 --cov=sqlobject -D "mssql://sa:Password12!@localhost\SQL2014/sqlobject_test?driver=pymssql"
+    pytest --timeout=30 --cov=sqlobject -D "mssql://sa:Password12!@localhost\SQL2014/sqlobject_test?driver=pymssql" tests include/tests inheritance/tests versioning/test
+
     sqlcmd -U sa -P "Password12!" -S .\SQL2014 -Q "DROP DATABASE sqlobject_test"
 
 [winpsycopg]

http://sourceforge.net/p/sqlobject/sqlobject/ci/ee704768917d455c0f90a763082494ad94634385

commit ee704768917d455c0f90a763082494ad94634385
Author: Neil <drn...@gm...>
Date:   Fri Jan 13 19:34:56 2017 +0200

    Longer timeout

diff --git a/tox.ini b/tox.ini
index f9d7460..116c698 100644
--- a/tox.ini
+++ b/tox.ini
@@ -257,7 +257,7 @@ commands = flake8 .
 commands =
     -sqlcmd -U sa -P "Password12!" -S .\SQL2014 -Q "DROP DATABASE sqlobject_test"
     sqlcmd -U sa -P "Password12!" -S .\SQL2014 -Q "CREATE DATABASE sqlobject_test"
-    pytest -v --timeout=10 --cov=sqlobject -D "mssql://sa:Password12!@localhost\SQL2014/sqlobject_test?driver=pymssql"
+    pytest -v --timeout=30 --cov=sqlobject -D "mssql://sa:Password12!@localhost\SQL2014/sqlobject_test?driver=pymssql"
     sqlcmd -U sa -P "Password12!" -S .\SQL2014 -Q "DROP DATABASE sqlobject_test"
 
 [winpsycopg]

http://sourceforge.net/p/sqlobject/sqlobject/ci/d0ec9104a802b6f8491b9ba3cc5813e7b81edda5

commit d0ec9104a802b6f8491b9ba3cc5813e7b81edda5
Author: Neil <drn...@gm...>
Date:   Fri Jan 13 15:44:02 2017 +0200

    Use pytest-timeout to avoid mssql tests hanging

diff --git a/tox.ini b/tox.ini
index dbd9db3..f9d7460 100644
--- a/tox.ini
+++ b/tox.ini
@@ -25,6 +25,7 @@ deps =
     firebirdsql: firebirdsql
     postgres-pg8000: pg8000
     mssql: pymssql
+    mssql: pytest-timeout
 passenv = CI TRAVIS TRAVIS_* PGPASSWORD
 # Don't fail or warn on uninstalled commands
 whitelist_externals =
@@ -256,7 +257,7 @@ commands = flake8 .
 commands =
     -sqlcmd -U sa -P "Password12!" -S .\SQL2014 -Q "DROP DATABASE sqlobject_test"
     sqlcmd -U sa -P "Password12!" -S .\SQL2014 -Q "CREATE DATABASE sqlobject_test"
-    pytest --cov=sqlobject -D "mssql://sa:Password12!@localhost\SQL2014/sqlobject_test?driver=pymssql" tests
+    pytest -v --timeout=10 --cov=sqlobject -D "mssql://sa:Password12!@localhost\SQL2014/sqlobject_test?driver=pymssql"
     sqlcmd -U sa -P "Password12!" -S .\SQL2014 -Q "DROP DATABASE sqlobject_test"
 
 [winpsycopg]

http://sourceforge.net/p/sqlobject/sqlobject/ci/966f671ec2d5f52ea98f36205476a039eafc56ea

commit 966f671ec2d5f52ea98f36205476a039eafc56ea
Author: Neil <drn...@gm...>
Date:   Fri Jan 13 15:30:08 2017 +0200

    reduce number of tests run for now.
    
    Also make test failures verbose

diff --git a/tox.ini b/tox.ini
index 20bba1d..dbd9db3 100644
--- a/tox.ini
+++ b/tox.ini
@@ -256,7 +256,7 @@ commands = flake8 .
 commands =
     -sqlcmd -U sa -P "Password12!" -S .\SQL2014 -Q "DROP DATABASE sqlobject_test"
     sqlcmd -U sa -P "Password12!" -S .\SQL2014 -Q "CREATE DATABASE sqlobject_test"
-    pytest --cov=sqlobject -D "mssql://sa:Password12!@localhost\SQL2014/sqlobject_test?driver=pymssql"
+    pytest --cov=sqlobject -D "mssql://sa:Password12!@localhost\SQL2014/sqlobject_test?driver=pymssql" tests
     sqlcmd -U sa -P "Password12!" -S .\SQL2014 -Q "DROP DATABASE sqlobject_test"
 
 [winpsycopg]

http://sourceforge.net/p/sqlobject/sqlobject/ci/f1dea2688494b18b939641b4b3af2670cab88935

commit f1dea2688494b18b939641b4b3af2670cab88935
Author: Neil <drn...@gm...>
Date:   Fri Jan 13 13:18:11 2017 +0200

    Trying to get ms sql tests running

diff --git a/appveyor.yml b/appveyor.yml
index cf238fc..4f017cf 100644
--- a/appveyor.yml
+++ b/appveyor.yml
@@ -7,7 +7,6 @@ version: 3.2.{build}
 clone_depth: 50
 
 services:
-   - mssql2014
    - postgresql
 
 environment:
@@ -60,6 +59,22 @@ install:
    - "python --version"
    - "pip install -r requirements.txt"
    - "pip install tox"
+   # Enable TCP for mssql
+   # (from appveyor documentation)
+   - ps: |
+      [reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") | Out-Null
+      [reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.SqlWmiManagement") | Out-Null
+      $serverName = $env:COMPUTERNAME
+      $instanceName = 'SQL2014'
+      $smo = 'Microsoft.SqlServer.Management.Smo.'
+      $wmi = new-object ($smo + 'Wmi.ManagedComputer')
+      $uri = "ManagedComputer[@Name='$serverName']/ServerInstance[@Name='$instanceName']/ServerProtocol[@Name='Tcp']"
+      $Tcp = $wmi.GetSmoObject($uri)
+      $Tcp.IsEnabled = $true
+      $TCP.alter()
+      Set-Service SQLBrowser -StartupType Manual
+      Start-Service SQLBrowser
+      Start-Service "MSSQL`$$instanceName"
 
 # Not a C project, so no build step
 build: false
diff --git a/tox.ini b/tox.ini
index aacbc70..20bba1d 100644
--- a/tox.ini
+++ b/tox.ini
@@ -19,12 +19,12 @@ deps =
     mysql-oursql: oursql
     pymysql: pymysql
     postgres-psycopg: psycopg2
-    winpsycopg: psycopg2
     postgres-pygresql: pygresql
     pypostgresql: py-postgresql
     firebird-fdb: fdb
     firebirdsql: firebirdsql
     postgres-pg8000: pg8000
+    mssql: pymssql
 passenv = CI TRAVIS TRAVIS_* PGPASSWORD
 # Don't fail or warn on uninstalled commands
 whitelist_externals =
@@ -34,6 +34,7 @@ whitelist_externals =
     rm
     sudo
     isql-fb
+    sqlcmd
 
 # MySQL test environments
 [mysqldb]
@@ -253,7 +254,10 @@ commands = flake8 .
 # Windows testing
 [winmssql]
 commands =
-   here
+    -sqlcmd -U sa -P "Password12!" -S .\SQL2014 -Q "DROP DATABASE sqlobject_test"
+    sqlcmd -U sa -P "Password12!" -S .\SQL2014 -Q "CREATE DATABASE sqlobject_test"
+    pytest --cov=sqlobject -D "mssql://sa:Password12!@localhost\SQL2014/sqlobject_test?driver=pymssql"
+    sqlcmd -U sa -P "Password12!" -S .\SQL2014 -Q "DROP DATABASE sqlobject_test"
 
 [winpsycopg]
 commands =

http://sourceforge.net/p/sqlobject/sqlobject/ci/7a8467679c84b4299b0f98961211756c8b09fc65

commit 7a8467679c84b4299b0f98961211756c8b09fc65
Author: Neil <drn...@gm...>
Date:   Fri Jan 13 12:37:10 2017 +0200

    Whitelist PGPASSWORD for windows

diff --git a/appveyor.yml b/appveyor.yml
index 636a1e3..cf238fc 100644
--- a/appveyor.yml
+++ b/appveyor.yml
@@ -21,7 +21,7 @@ environment:
       TOX_ENV: "pywin27-mssql"
     - PYTHON: "C:\\Python27"
       db: postgresql
-      TOX_ENV: "pywin27-postgres"
+      TOX_ENV: "pywin27-postgres-psycopg"
     #- PYTHON: "C:\\Python27-x64"
     #  db: mssql2014
     #- PYTHON: "C:\\Python27-x64"
@@ -31,7 +31,7 @@ environment:
       TOX_ENV: "pywin34-mssql"
     - PYTHON: "C:\\Python34"
       db: postgresql
-      TOX_ENV: "pywin34-postgres"
+      TOX_ENV: "pywin34-postgres-psycopg"
     #- PYTHON: "C:\\Python34-x64"
     #  db: mssql2014
     #- PYTHON: "C:\\Python34-x64"
@@ -60,8 +60,6 @@ install:
    - "python --version"
    - "pip install -r requirements.txt"
    - "pip install tox"
-   - "pip install psycopg2"
-   - "echo %PGPASSWORD%"
 
 # Not a C project, so no build step
 build: false
diff --git a/tox.ini b/tox.ini
index 8d40d7b..aacbc70 100644
--- a/tox.ini
+++ b/tox.ini
@@ -1,6 +1,6 @@
 [tox]
 minversion = 1.8
-envlist = py{26,27}-{mysqldb,mysql-oursql},py{34,35}-{mysqlclient,pypostgresql},py{26,27,34,35}-{mysql-connector,pymysql,postgres-psycopg,postgres-pygresql,postgres-pg8000,sqlite},py{27,34,35}-{firebird-fdb,firebirdsql},py{27,34}-flake8,pywin{27,34}-{postgres,mssql}
+envlist = py{26,27}-{mysqldb,mysql-oursql},py{34,35}-{mysqlclient,pypostgresql},py{26,27,34,35}-{mysql-connector,pymysql,postgres-psycopg,postgres-pygresql,postgres-pg8000,sqlite},py{27,34,35}-{firebird-fdb,firebirdsql},py{27,34}-flake8,pywin{27,34}-{postgres-psycopg,mssql}
 
 # Base test environment settings
 [testenv]
@@ -19,12 +19,13 @@ deps =
     mysql-oursql: oursql
     pymysql: pymysql
     postgres-psycopg: psycopg2
+    winpsycopg: psycopg2
     postgres-pygresql: pygresql
     pypostgresql: py-postgresql
     firebird-fdb: fdb
     firebirdsql: firebirdsql
     postgres-pg8000: pg8000
-passenv = CI TRAVIS TRAVIS_*
+passenv = CI TRAVIS TRAVIS_* PGPASSWORD
 # Don't fail or warn on uninstalled commands
 whitelist_externals =
     mysql
@@ -33,7 +34,6 @@ whitelist_externals =
     rm
     sudo
     isql-fb
-    set
 
 # MySQL test environments
 [mysqldb]
@@ -257,20 +257,18 @@ commands =
 
 [winpsycopg]
 commands =
-    set
-    set PGPASSWORD="Password12!"
     -dropdb -w -U postgres sqlobject_test
     createdb -w -U postgres sqlobject_test
-    pytest --cov=sqlobject -D postgres://postgres:@localhost/sqlobject_test?driver=psycopg&charset=utf-8 tests include/tests inheritance/tests versioning/test
+    pytest --cov=sqlobject -D "postgres://postgres:Password12!@localhost/sqlobject_test?driver=psycopg2&charset=utf-8" tests include/tests inheritance/tests versioning/test
     dropdb -w -U postgres sqlobject_test
 
-[testenv:pywin27-postgres]
+[testenv:pywin27-postgres-psycopg]
 commands = {[winpsycopg]commands}
 
 [testenv:pywin27-mssql]
 commands = {[winmssql]commands}
 
-[testenv:pywin34-postgres]
+[testenv:pywin34-postgres-psycopg]
 commands = {[winpsycopg]commands}
 
 [testenv:pywin34-mssql]

http://sourceforge.net/p/sqlobject/sqlobject/ci/4825b7585632b421d6b594a169387e29cff69b5a

commit 4825b7585632b421d6b594a169387e29cff69b5a
Author: Neil <drn...@gm...>
Date:   Fri Jan 13 12:20:34 2017 +0200

    Add -w flags so postgres password issues fail

diff --git a/appveyor.yml b/appveyor.yml
index fec1e5a..636a1e3 100644
--- a/appveyor.yml
+++ b/appveyor.yml
@@ -11,8 +11,8 @@ services:
    - postgresql
 
 environment:
-  PGUSER: postgres
-  PGPASSWORD: Password12!
+  PGUSER: "postgres"
+  PGPASSWORD: "Password12!"
 
   matrix:
     # from https://www.appveyor.com/docs/installed-software/#python
@@ -61,6 +61,7 @@ install:
    - "pip install -r requirements.txt"
    - "pip install tox"
    - "pip install psycopg2"
+   - "echo %PGPASSWORD%"
 
 # Not a C project, so no build step
 build: false
diff --git a/tox.ini b/tox.ini
index 1e5cb00..8d40d7b 100644
--- a/tox.ini
+++ b/tox.ini
@@ -33,6 +33,7 @@ whitelist_externals =
     rm
     sudo
     isql-fb
+    set
 
 # MySQL test environments
 [mysqldb]
@@ -254,14 +255,23 @@ commands = flake8 .
 commands =
    here
 
+[winpsycopg]
+commands =
+    set
+    set PGPASSWORD="Password12!"
+    -dropdb -w -U postgres sqlobject_test
+    createdb -w -U postgres sqlobject_test
+    pytest --cov=sqlobject -D postgres://postgres:@localhost/sqlobject_test?driver=psycopg&charset=utf-8 tests include/tests inheritance/tests versioning/test
+    dropdb -w -U postgres sqlobject_test
+
 [testenv:pywin27-postgres]
-commands = {[psycopg]commands}
+commands = {[winpsycopg]commands}
 
 [testenv:pywin27-mssql]
 commands = {[winmssql]commands}
 
 [testenv:pywin34-postgres]
-commands = {[psycopg]commands}
+commands = {[winpsycopg]commands}
 
 [testenv:pywin34-mssql]
 commands = {[winmssql]commands}

http://sourceforge.net/p/sqlobject/sqlobject/ci/be944d0c2a185d49b0578bf5b86e1c2e4e5c1b0c

commit be944d0c2a185d49b0578bf5b86e1c2e4e5c1b0c
Author: Neil <drn...@gm...>
Date:   Fri Jan 13 11:35:16 2017 +0200

    Trying to make appveyor work

diff --git a/appveyor.yml b/appveyor.yml
new file mode 100644
index 0000000..fec1e5a
--- /dev/null
+++ b/appveyor.yml
@@ -0,0 +1,69 @@
+# Install SQLObject on windows and test against MS SQL server and postgres
+# Heavily inspired by Oliver Grisel's appveyor-demo (https://github.com/ogrisel/python-appveyor-demo)
+# and Michael Sverdlik's appveyor-utils (https://github.com/cloudify-cosmo/appveyor-utils)
+version: 3.2.{build}
+
+# Match travis
+clone_depth: 50
+
+services:
+   - mssql2014
+   - postgresql
+
+environment:
+  PGUSER: postgres
+  PGPASSWORD: Password12!
+
+  matrix:
+    # from https://www.appveyor.com/docs/installed-software/#python
+    - PYTHON: "C:\\Python27"
+      db: mssql2014
+      TOX_ENV: "pywin27-mssql"
+    - PYTHON: "C:\\Python27"
+      db: postgresql
+      TOX_ENV: "pywin27-postgres"
+    #- PYTHON: "C:\\Python27-x64"
+    #  db: mssql2014
+    #- PYTHON: "C:\\Python27-x64"
+    #  db: postgresql
+    - PYTHON: "C:\\Python34"
+      db: mssql2014
+      TOX_ENV: "pywin34-mssql"
+    - PYTHON: "C:\\Python34"
+      db: postgresql
+      TOX_ENV: "pywin34-postgres"
+    #- PYTHON: "C:\\Python34-x64"
+    #  db: mssql2014
+    #- PYTHON: "C:\\Python34-x64"
+    #  db: postgresql
+    #- PYTHON: "C:\\Python35"
+    #  db: mssql2014
+    #- PYTHON: "C:\\Python35"
+    #  db: postgresql
+    #- PYTHON: "C:\\Python35-x64"
+    #  db: mssql2014
+    #- PYTHON: "C:\\Python35-x64"
+    #  db: postgresql
+    #- PYTHON: "C:\\Python36"
+    #  db: mssql2014
+    #- PYTHON: "C:\\Python36"
+    #  db: postgresql
+    #- PYTHON: "C:\\Python36-x64"
+    #  db: mssql2014
+    #- PYTHON: "C:\\Python36-x64"
+    #  db: postgresql
+
+
+install:
+   # Ensure we use the right python version
... 54 lines suppressed ...


hooks/post-receive
-- 
SQLObject development repository