<feed xmlns='http://www.w3.org/2005/Atom'>
<title>delta/python-packages/sqlalchemy.git/tox.ini, branch 2020_tutorial</title>
<subtitle>github.com: zzzeek/sqlalchemy.git
</subtitle>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/python-packages/sqlalchemy.git/'/>
<entry>
<title>Propose --nomemory by default</title>
<updated>2020-07-08T19:58:38+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2020-07-08T19:32:38+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/python-packages/sqlalchemy.git/commit/?id=e2d4b2e72cb97bc5612fa9d1ec7d0ab15d38efe1'/>
<id>e2d4b2e72cb97bc5612fa9d1ec7d0ab15d38efe1</id>
<content type='text'>
the memory tests are solely responsible for the largest chunk of
time and CPU energy taken up in running the tests.   Regressions
in this area are nonexistent unless major changes are being
taken up.   Try to revert them to False and see if a single
gerrit job can perhaps run these.

Change-Id: Ibaead2d1c0a76f1339bee63652a8aead689e8b75
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
the memory tests are solely responsible for the largest chunk of
time and CPU energy taken up in running the tests.   Regressions
in this area are nonexistent unless major changes are being
taken up.   Try to revert them to False and see if a single
gerrit job can perhaps run these.

Change-Id: Ibaead2d1c0a76f1339bee63652a8aead689e8b75
</pre>
</div>
</content>
</entry>
<entry>
<title>Use python version in extras_require; integrate with tox</title>
<updated>2020-06-29T19:01:28+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2020-06-29T18:01:07+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/python-packages/sqlalchemy.git/commit/?id=897cd1766d1fabb2368d07a6958496815abe4589'/>
<id>897cd1766d1fabb2368d07a6958496815abe4589</id>
<content type='text'>
We want to use Oracle version &gt;=7 for all platforms,
but &lt;8 for Python 2.

Similarly, we want to use mysqlclient &gt;= 1.4.0 for all
platforms, but &lt; 2 for Python 2.

Have tox.ini defer to setup.cfg for DBAPIs.

We're not testing mysql-connector-python right now so remove
this from tox.ini.

Change-Id: I02611937da71d2950545e42c34f0b9798478e2a8
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
We want to use Oracle version &gt;=7 for all platforms,
but &lt;8 for Python 2.

Similarly, we want to use mysqlclient &gt;= 1.4.0 for all
platforms, but &lt; 2 for Python 2.

Have tox.ini defer to setup.cfg for DBAPIs.

We're not testing mysql-connector-python right now so remove
this from tox.ini.

Change-Id: I02611937da71d2950545e42c34f0b9798478e2a8
</pre>
</div>
</content>
</entry>
<entry>
<title>Default psycopg2 executemany mode to "values_only"</title>
<updated>2020-06-25T22:58:34+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2020-06-23T20:21:04+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/python-packages/sqlalchemy.git/commit/?id=f1a3038f480ee1965928cdcd1dc0c47347f270bc'/>
<id>f1a3038f480ee1965928cdcd1dc0c47347f270bc</id>
<content type='text'>
The psycopg2 dialect now defaults to using the very performant
``execute_values()`` psycopg2 extension for compiled INSERT statements,
and also impements RETURNING support when this extension is used.  This
allows INSERT statements that even include an autoincremented SERIAL
or IDENTITY value to run very fast while still being able to return the
newly generated primary key values.   The ORM will then integrate this
new feature in a separate change.

Implements RETURNING for insert with executemany

Adds support to return_defaults() mode and inserted_primary_key
to support mutiple INSERTed rows, via return_defauls_rows
and inserted_primary_key_rows accessors.

within default execution context, new cached compiler
getters are used to fetch primary keys from rows

inserted_primary_key now returns a plain tuple. this
is not yet a row-like object however this can be
added.

Adds distinct "values_only" and "batch" modes, as
"values" has a lot of benefits but "batch" breaks
cursor.rowcount

psycopg2 minimum version 2.7 so we can remove the
large number of checks for very old versions of
psycopg2

simplify tests to no longer distinguish between
native and non-native json

Fixes: #5401
Change-Id: Ic08fd3423d4c5d16ca50994460c0c234868bd61c
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
The psycopg2 dialect now defaults to using the very performant
``execute_values()`` psycopg2 extension for compiled INSERT statements,
and also impements RETURNING support when this extension is used.  This
allows INSERT statements that even include an autoincremented SERIAL
or IDENTITY value to run very fast while still being able to return the
newly generated primary key values.   The ORM will then integrate this
new feature in a separate change.

Implements RETURNING for insert with executemany

Adds support to return_defaults() mode and inserted_primary_key
to support mutiple INSERTed rows, via return_defauls_rows
and inserted_primary_key_rows accessors.

within default execution context, new cached compiler
getters are used to fetch primary keys from rows

inserted_primary_key now returns a plain tuple. this
is not yet a row-like object however this can be
added.

Adds distinct "values_only" and "batch" modes, as
"values" has a lot of benefits but "batch" breaks
cursor.rowcount

psycopg2 minimum version 2.7 so we can remove the
large number of checks for very old versions of
psycopg2

simplify tests to no longer distinguish between
native and non-native json

Fixes: #5401
Change-Id: Ic08fd3423d4c5d16ca50994460c0c234868bd61c
</pre>
</div>
</content>
</entry>
<entry>
<title>add posargs to pep8</title>
<updated>2020-05-29T20:47:29+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2020-05-29T20:47:29+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/python-packages/sqlalchemy.git/commit/?id=7ff6cf1eaa84f1387d60d4eb7ba752480a6bf567'/>
<id>7ff6cf1eaa84f1387d60d4eb7ba752480a6bf567</id>
<content type='text'>
we want to be able to specify --output-file

Change-Id: Ib4e992d47587385a50c35ca915bc5adcb2ca49fa
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
we want to be able to specify --output-file

Change-Id: Ib4e992d47587385a50c35ca915bc5adcb2ca49fa
</pre>
</div>
</content>
</entry>
<entry>
<title>Add github action workflow to run tests on master and on pr to master</title>
<updated>2020-04-03T18:11:24+00:00</updated>
<author>
<name>Federico Caselli</name>
<email>cfederico87@gmail.com</email>
</author>
<published>2020-04-03T18:11:24+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/python-packages/sqlalchemy.git/commit/?id=c658540b9ae36e86a92e11667d3679ac1f3eac2e'/>
<id>c658540b9ae36e86a92e11667d3679ac1f3eac2e</id>
<content type='text'>
Trying the pr to check if it works right away

### Description
&lt;!-- Describe your changes in detail --&gt;

### Checklist
&lt;!-- go over following points. check them with an `x` if they do apply, (they turn into clickable checkboxes once the PR is submitted, so no need to do everything at once)

--&gt;

This pull request is:

- [ ] A documentation / typographical error fix
	- Good to go, no issue or tests are needed
- [x] A short code fix
	- please include the issue number, and create an issue if none exists, which
	  must include a complete example of the issue.  one line code fixes without an
	  issue and demonstration will not be accepted.
	- Please include: `Fixes: #&lt;issue number&gt;` in the commit message
	- please include tests.   one line code fixes without tests will not be accepted.
- [ ] A new feature implementation
	- please include the issue number, and create an issue if none exists, which must
	  include a complete example of how the feature would look.
	- Please include: `Fixes: #&lt;issue number&gt;` in the commit message
	- please include tests.

**Have a nice day!**

Closes: #5222
Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/5222
Pull-request-sha: afbb8567525f3841554d3ba599ef4d713c78e647

Change-Id: I4981b02f900e76e446cf42e6cc6495ffc0883951
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Trying the pr to check if it works right away

### Description
&lt;!-- Describe your changes in detail --&gt;

### Checklist
&lt;!-- go over following points. check them with an `x` if they do apply, (they turn into clickable checkboxes once the PR is submitted, so no need to do everything at once)

--&gt;

This pull request is:

- [ ] A documentation / typographical error fix
	- Good to go, no issue or tests are needed
- [x] A short code fix
	- please include the issue number, and create an issue if none exists, which
	  must include a complete example of the issue.  one line code fixes without an
	  issue and demonstration will not be accepted.
	- Please include: `Fixes: #&lt;issue number&gt;` in the commit message
	- please include tests.   one line code fixes without tests will not be accepted.
- [ ] A new feature implementation
	- please include the issue number, and create an issue if none exists, which must
	  include a complete example of how the feature would look.
	- Please include: `Fixes: #&lt;issue number&gt;` in the commit message
	- please include tests.

**Have a nice day!**

Closes: #5222
Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/5222
Pull-request-sha: afbb8567525f3841554d3ba599ef4d713c78e647

Change-Id: I4981b02f900e76e446cf42e6cc6495ffc0883951
</pre>
</div>
</content>
</entry>
<entry>
<title>Fix tests failing for SQLite file databases; repair provisioning</title>
<updated>2020-03-13T19:04:33+00:00</updated>
<author>
<name>Gord Thompson</name>
<email>gord@gordthompson.com</email>
</author>
<published>2020-02-26T19:50:01+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/python-packages/sqlalchemy.git/commit/?id=79a53645ba8e6c12aff33d9ba1318ea4328ab7de'/>
<id>79a53645ba8e6c12aff33d9ba1318ea4328ab7de</id>
<content type='text'>
1. ensure provision.py loads dialect implementations when running
reap_dbs.py.   Reapers haven't been working since
598f2f7e557073f29563d4d567f43931fc03013f .

2. add some exclusion rules to allow the sqlite_file target to work;
add to tox.

3. add reap dbs target for SQLite, repair SQLite drop_db routine
which also wasn't doing the right thing for memory databases
etc.

4. Fix logging in provision files, as the main provision logger
is the one that's enabled by reap_dbs and maybe others, have all
the provision files use the provision logger.

Fixes: #5180
Fixes: #5168

Change-Id: Ibc1b0106394d20f5bcf847f37b09d185f26ac9b5
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
1. ensure provision.py loads dialect implementations when running
reap_dbs.py.   Reapers haven't been working since
598f2f7e557073f29563d4d567f43931fc03013f .

2. add some exclusion rules to allow the sqlite_file target to work;
add to tox.

3. add reap dbs target for SQLite, repair SQLite drop_db routine
which also wasn't doing the right thing for memory databases
etc.

4. Fix logging in provision files, as the main provision logger
is the one that's enabled by reap_dbs and maybe others, have all
the provision files use the provision logger.

Fixes: #5180
Fixes: #5168

Change-Id: Ibc1b0106394d20f5bcf847f37b09d185f26ac9b5
</pre>
</div>
</content>
</entry>
<entry>
<title>Disable sqlite_file tests by default, take two</title>
<updated>2020-03-13T16:14:12+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2020-03-13T16:14:12+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/python-packages/sqlalchemy.git/commit/?id=67e51ea5dcb3955105c35bf8149785bd72c7a521'/>
<id>67e51ea5dcb3955105c35bf8149785bd72c7a521</id>
<content type='text'>
We need no tests to run for sqlite_file until we merge
a full fix for it.   We'd like Jenkins to include this target.

Change-Id: I2737fa462572f08e2925b232a8f24d1ecd26b3ac
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
We need no tests to run for sqlite_file until we merge
a full fix for it.   We'd like Jenkins to include this target.

Change-Id: I2737fa462572f08e2925b232a8f24d1ecd26b3ac
</pre>
</div>
</content>
</entry>
<entry>
<title>Add placeholder for sqlite file database</title>
<updated>2020-03-12T23:12:09+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2020-03-12T23:12:09+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/python-packages/sqlalchemy.git/commit/?id=4b3a68e91c73ae84a3719d6933dc991ec2453d5b'/>
<id>4b3a68e91c73ae84a3719d6933dc991ec2453d5b</id>
<content type='text'>
So that we can enable this in jenkins until
 Ibc1b0106394d20f5bcf847f37b09d185f26ac9b5 is merged.

Change-Id: Ia704e75bf3767e02d448a6af02530dfc89c9920b
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
So that we can enable this in jenkins until
 Ibc1b0106394d20f5bcf847f37b09d185f26ac9b5 is merged.

Change-Id: Ia704e75bf3767e02d448a6af02530dfc89c9920b
</pre>
</div>
</content>
</entry>
<entry>
<title>Also run black --check in the tox pep8 env</title>
<updated>2020-03-10T19:05:46+00:00</updated>
<author>
<name>Federico Caselli</name>
<email>cfederico87@gmail.com</email>
</author>
<published>2020-03-10T18:49:39+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/python-packages/sqlalchemy.git/commit/?id=d8378f45bbb2a63eb1e396506f175e2f203b9cb3'/>
<id>d8378f45bbb2a63eb1e396506f175e2f203b9cb3</id>
<content type='text'>
Change-Id: I3b86bb3b4263048646676972bb2a870c7e2a7393
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Change-Id: I3b86bb3b4263048646676972bb2a870c7e2a7393
</pre>
</div>
</content>
</entry>
<entry>
<title>Revise cx_Oracle, mysqlclient versions</title>
<updated>2020-02-18T16:09:43+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2020-02-18T16:09:43+00:00</published>
<link rel='alternate' type='text/html' href='http://git.baserock.org/cgit/delta/python-packages/sqlalchemy.git/commit/?id=d1fe8f432d2ceb8808c09472135e64c0a384c292'/>
<id>d1fe8f432d2ceb8808c09472135e64c0a384c292</id>
<content type='text'>
cx_Oracle is dropping Python 2 in version 8.0
mysqlclient is dropping Python 2 in version 2.0

We are no longer testing cx_Oracle &lt; 7 on CI so drop older
cx_Oracle versions from tox.

Change-Id: I18d8b47077d50ac02aedb6fdeb24f7c99b56aa7c
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
cx_Oracle is dropping Python 2 in version 8.0
mysqlclient is dropping Python 2 in version 2.0

We are no longer testing cx_Oracle &lt; 7 on CI so drop older
cx_Oracle versions from tox.

Change-Id: I18d8b47077d50ac02aedb6fdeb24f7c99b56aa7c
</pre>
</div>
</content>
</entry>
</feed>
