Revision a16796047b33e91a2e270bcb385a545ec8760095 authored by Nicolas Dandrimont on 31 May 2018, 15:06:28 UTC, committed by Nicolas Dandrimont on 05 June 2018, 11:56:09 UTC
Summary:
To do so, we import a function from a recent version of psycopg2,
execute_values, which can execute queries efficiently with a list of values.

We also scale the cursor back from having things in SQL functions towards having
things inside the db.py database "backend". This will make it easier to iterate,
as we won't have to deploy function changes to twenty different databases.

After these changes, testing the web UI on a physical replica works.

Close T1073

Test Plan:
Local integration tests are happy; Navigating the frontend backed by
a physical replica seems to be okay now.

Reviewers: #reviewers!

Maniphest Tasks: T1073

Differential Revision: https://forge.softwareheritage.org/D340
1 parent 7c85120
History
File Mode Size
bin
debian
docs
sql
swh
utils
.gitignore -rw-r--r-- 81 bytes
AUTHORS -rw-r--r-- 112 bytes
LICENSE -rw-r--r-- 34.3 KB
MANIFEST.in -rw-r--r-- 183 bytes
Makefile -rw-r--r-- 163 bytes
Makefile.local -rw-r--r-- 182 bytes
README.db_testing -rw-r--r-- 673 bytes
README.dev -rw-r--r-- 1.7 KB
requirements-swh.txt -rw-r--r-- 88 bytes
requirements.txt -rw-r--r-- 57 bytes
setup.py -rwxr-xr-x 983 bytes

README.db_testing

back to top