Changeset View
Changeset View
Standalone View
Standalone View
swh/storage/postgresql/db.py
| Show All 23 Lines | def jsonize(d): | ||||
| return _jsonize(dict(d) if d is not None else None) | return _jsonize(dict(d) if d is not None else None) | ||||
| class Db(BaseDb): | class Db(BaseDb): | ||||
| """Proxy to the SWH DB, with wrappers around stored procedures | """Proxy to the SWH DB, with wrappers around stored procedures | ||||
| """ | """ | ||||
| current_version = 171 | current_version = 172 | ||||
| def mktemp_dir_entry(self, entry_type, cur=None): | def mktemp_dir_entry(self, entry_type, cur=None): | ||||
| self._cursor(cur).execute( | self._cursor(cur).execute( | ||||
| "SELECT swh_mktemp_dir_entry(%s)", (("directory_entry_%s" % entry_type),) | "SELECT swh_mktemp_dir_entry(%s)", (("directory_entry_%s" % entry_type),) | ||||
| ) | ) | ||||
| @stored_procedure("swh_mktemp_revision") | @stored_procedure("swh_mktemp_revision") | ||||
| def mktemp_revision(self, cur=None): | def mktemp_revision(self, cur=None): | ||||
| ▲ Show 20 Lines • Show All 1,180 Lines • ▼ Show 20 Lines | |||||
| ] | ] | ||||
| """List of columns of the raw_extrinsic_metadata table, used when writing | """List of columns of the raw_extrinsic_metadata table, used when writing | ||||
| metadata.""" | metadata.""" | ||||
| _raw_extrinsic_metadata_insert_query = f""" | _raw_extrinsic_metadata_insert_query = f""" | ||||
| INSERT INTO raw_extrinsic_metadata | INSERT INTO raw_extrinsic_metadata | ||||
| ({', '.join(_raw_extrinsic_metadata_insert_cols)}) | ({', '.join(_raw_extrinsic_metadata_insert_cols)}) | ||||
| VALUES ({', '.join('%s' for _ in _raw_extrinsic_metadata_insert_cols)}) | VALUES ({', '.join('%s' for _ in _raw_extrinsic_metadata_insert_cols)}) | ||||
| ON CONFLICT (target, authority_id, discovery_date, fetcher_id) | ON CONFLICT (id) | ||||
| DO NOTHING | DO NOTHING | ||||
| """ | """ | ||||
| raw_extrinsic_metadata_get_cols = [ | raw_extrinsic_metadata_get_cols = [ | ||||
| "raw_extrinsic_metadata.target", | "raw_extrinsic_metadata.target", | ||||
| "raw_extrinsic_metadata.type", | "raw_extrinsic_metadata.type", | ||||
| "discovery_date", | "discovery_date", | ||||
| "metadata_authority.type", | "metadata_authority.type", | ||||
| ▲ Show 20 Lines • Show All 204 Lines • Show Last 20 Lines | |||||