RPM database filling : admin-triggered synchronization - Githubissues

agallou / mageia-app-db

GNU Affero General Public License v3.0

6 stars 3 forks source link

RPM database filling : admin-triggered synchronization #186

Closed agallou closed 10 years ago

agallou commented 10 years ago

Author Name: Samuel Verschelde (@stormi) Original Redmine Issue: 29, http://mageia-app-db.tuxette.fr/issues/29 Original Date: 2011/03/17 Original Assignee: Samuel Verschelde

Add the ability to synchronize the database on admin's request (symfony task)

agallou commented 10 years ago

Original Redmine Comment Author Name: Samuel Verschelde (@stormi) Original Date: 2010/11/29 20:45:06 +0100

See [[QueryingSophie]]

The plan would be :

every 5 minutes, ask for the latest additions in sophie (based on row creation date in Sophie's database)
every day (for example), compare our list of pkgids with that of sophie, and synchronize the differences, if there are differences

agallou commented 10 years ago

Original Redmine Comment Author Name: Samuel Verschelde (@stormi) Original Date: 2011/03/16 00:52:29 +0100

commit:9f0dd92ad8b9da7ac5aaa9aceef366e677132347

huge commit for work on synchronization

* update database schema
** new field rpm.source_rpm_name
** new field rpm.md5name, for use in a unique indexe
** indexes
* progress on synchronization :
** get information from sophie
** update packages and RPMs
** impact on various model classes
** the fetch-rpms task no longer creates a CSV but performs the real
import from sophie

various TODOs remain.

agallou commented 10 years ago

Original Redmine Comment Author Name: Samuel Verschelde (@stormi) Original Date: 2011/03/16 00:53:28 +0100

commit:2e36c28975f6bcb909091dfcc66e7c85cf414f6a

check missing dr, media, arch in sophie's response

a missing element makes the task fail unless the --ignore-missing-from-sophie option is set

agallou commented 10 years ago

Original Redmine Comment Author Name: Samuel Verschelde (@stormi) Original Date: 2011/03/29 22:17:13 +0200

\o/