Page MenuHomeDevCentral
Feed All Stories

Sun, Jan 15

dereckson added inline comments to D2738: Fetch last FANTOIR file.
Sun, Jan 15, 06:12
dereckson planned changes to D2738: Fetch last FANTOIR file.

Blocked by publication of opendatasoft-explore-api library.

Sun, Jan 15, 05:58
dereckson requested review of D2738: Fetch last FANTOIR file.
Sun, Jan 15, 05:57
dereckson added a revision to T1750: Import FANTOIR database: D2738: Fetch last FANTOIR file.
Sun, Jan 15, 05:57 · Nasqueron Databases
dereckson closed D2735: Generate Wikidate health report for FANTOIR code.
Sun, Jan 15, 02:00
dereckson committed rDSb88d6b90d4f0: Generate Wikidate health report for FANTOIR code (authored by dereckson).
Generate Wikidate health report for FANTOIR code
Sun, Jan 15, 02:00
dereckson updated the diff for D2735: Generate Wikidate health report for FANTOIR code.

Rebased

Sun, Jan 15, 01:59
dereckson closed D2731: Query Wikidata to enrich FANTOIR file.
Sun, Jan 15, 01:31
dereckson committed rDS6580112d2da3: Query Wikidata to enrich FANTOIR file (authored by dereckson).
Query Wikidata to enrich FANTOIR file
Sun, Jan 15, 01:31
dereckson updated the diff for D2731: Query Wikidata to enrich FANTOIR file.

case

Sun, Jan 15, 01:30
dereckson accepted D2731: Query Wikidata to enrich FANTOIR file.
Sun, Jan 15, 01:29
dereckson retitled D2731: Query Wikidata to enrich FANTOIR file from WIP: Query Wikidata to enrich FANTOIR file to Query Wikidata to enrich FANTOIR file.
Sun, Jan 15, 01:24
dereckson updated the task description for T1752: Publish SPARQL client in Rust.
Sun, Jan 15, 01:22 · Wikimedia, Nasqueron Databases

Sat, Jan 14

dereckson triaged T1753: Rust syntax highlighting on DevCentral as High priority.
Sat, Jan 14, 21:13 · Nasqueron API, Nasqueron Databases, DevCentral
dereckson placed T1752: Publish SPARQL client in Rust up for grabs.
Sat, Jan 14, 21:10 · Wikimedia, Nasqueron Databases
dereckson triaged T1752: Publish SPARQL client in Rust as Wishlist priority.
Sat, Jan 14, 21:10 · Wikimedia, Nasqueron Databases
dereckson updated the diff for D2731: Query Wikidata to enrich FANTOIR file.

Refactor to a cleaner implementation, move sparql mod to services

Sat, Jan 14, 19:05
dereckson added a comment to P308 Transform sparql module from fantoir-datasource in standalone crate.

To avoid match/let ... = ...() in the middle of a HOF chain, I've prepared helper methods to read the inner content of an enum:

Sat, Jan 14, 19:04 · Nasqueron Databases
dereckson created P308 Transform sparql module from fantoir-datasource in standalone crate.
Sat, Jan 14, 19:02 · Nasqueron Databases
dereckson updated the diff for D2731: Query Wikidata to enrich FANTOIR file.

Fix SPARQL client, refactor

Sat, Jan 14, 18:17
dereckson accepted D2735: Generate Wikidate health report for FANTOIR code.

Works for me, but depends of D2731.

Sat, Jan 14, 03:01
dereckson updated the diff for D2735: Generate Wikidate health report for FANTOIR code.

Move more report code to commands::wikidate::report mod

Sat, Jan 14, 02:59
dereckson closed D2737: Generate code for fantoir-datasource Wikidata qualification.
Sat, Jan 14, 02:44
dereckson committed rHELPER742bafa76758: Generate code for fantoir-datasource Wikidata qualification (authored by dereckson).
Generate code for fantoir-datasource Wikidata qualification
Sat, Jan 14, 02:44
dereckson accepted D2737: Generate code for fantoir-datasource Wikidata qualification.
Sat, Jan 14, 02:44
dereckson updated the diff for D2737: Generate code for fantoir-datasource Wikidata qualification.

Skip first CSV line

Sat, Jan 14, 02:44
dereckson accepted D2737: Generate code for fantoir-datasource Wikidata qualification.
Sat, Jan 14, 02:42
dereckson updated the test plan for D2737: Generate code for fantoir-datasource Wikidata qualification.
Sat, Jan 14, 02:38
dereckson added a revision to T1751: Enrich FANTOIR database with Wikidata information: D2737: Generate code for fantoir-datasource Wikidata qualification.
Sat, Jan 14, 02:37 · Wikimedia, Nasqueron Databases
dereckson requested review of D2737: Generate code for fantoir-datasource Wikidata qualification.
Sat, Jan 14, 02:37
dereckson closed D2736: Configure Arcanist.
Sat, Jan 14, 02:29
dereckson committed rHELPERfe6ab20faf53: Configure Arcanist (authored by dereckson).
Configure Arcanist
Sat, Jan 14, 02:29
dereckson accepted D2736: Configure Arcanist.
Sat, Jan 14, 02:29
dereckson updated the test plan for D2736: Configure Arcanist.
Sat, Jan 14, 02:29
dereckson requested review of D2736: Configure Arcanist.
Sat, Jan 14, 02:29
dereckson committed rHELPER3e6044c715e4: Two generators for www.nasqueron.org content from sites.json: (authored by dereckson).
Two generators for www.nasqueron.org content from sites.json:
Sat, Jan 14, 02:13

Fri, Jan 13

dereckson planned changes to D2735: Generate Wikidate health report for FANTOIR code.
Fri, Jan 13, 08:02
dereckson updated the summary of D2731: Query Wikidata to enrich FANTOIR file.
Fri, Jan 13, 07:59
dereckson added a revision to T1751: Enrich FANTOIR database with Wikidata information: D2731: Query Wikidata to enrich FANTOIR file.
Fri, Jan 13, 07:59 · Wikimedia, Nasqueron Databases
dereckson requested review of D2735: Generate Wikidate health report for FANTOIR code.
Fri, Jan 13, 07:59
dereckson added a revision to T1751: Enrich FANTOIR database with Wikidata information: D2735: Generate Wikidate health report for FANTOIR code.
Fri, Jan 13, 07:59 · Wikimedia, Nasqueron Databases
dereckson updated the diff for D2731: Query Wikidata to enrich FANTOIR file.

This version is ready and can correctly update Wikidata. If we can solve the 403 issue when connecting to SPARQL endpoint, it's ready to commit. Meanwhile, to test this code, you can run the query and save the result (in XML format) at tmp/wikidata-query-result.xml

Fri, Jan 13, 06:01

Thu, Jan 12

dereckson closed D2734: Search the imported FANTOIR database.
Thu, Jan 12, 19:05
dereckson committed rDS5357130c932f: Search the imported FANTOIR database (authored by dereckson).
Search the imported FANTOIR database
Thu, Jan 12, 19:05
dereckson accepted D2734: Search the imported FANTOIR database.
Thu, Jan 12, 19:04
dereckson updated the diff for D2734: Search the imported FANTOIR database.

Fix CRLF issues

Thu, Jan 12, 19:03
dereckson added a revision to T1750: Import FANTOIR database: D2734: Search the imported FANTOIR database.
Thu, Jan 12, 19:01 · Nasqueron Databases
dereckson requested review of D2734: Search the imported FANTOIR database.
Thu, Jan 12, 19:01
dereckson added a revision to T1751: Enrich FANTOIR database with Wikidata information: D2734: Search the imported FANTOIR database.
Thu, Jan 12, 19:01 · Wikimedia, Nasqueron Databases
dereckson updated the summary of D2731: Query Wikidata to enrich FANTOIR file.
Thu, Jan 12, 18:58
dereckson updated the diff for D2731: Query Wikidata to enrich FANTOIR file.

Clean comment and debug code

Thu, Jan 12, 06:03
dereckson updated the diff for D2731: Query Wikidata to enrich FANTOIR file.

Don't hardcore wikidata table name twice

Thu, Jan 12, 05:59
dereckson updated the diff for D2731: Query Wikidata to enrich FANTOIR file.

Rebased

Thu, Jan 12, 05:57
dereckson committed rDS3ff0473187d4: Promote imported FANTOIR version (authored by dereckson).
Promote imported FANTOIR version
Thu, Jan 12, 05:36
dereckson retitled D2733: Promote imported FANTOIR version from Promote importe FANTOIR version to Promote imported FANTOIR version.
Thu, Jan 12, 05:33
dereckson closed D2733: Promote imported FANTOIR version.
Thu, Jan 12, 05:33
dereckson committed rDSb6d0e43ca9f3: Promote importe FANTOIR version (authored by dereckson).
Promote importe FANTOIR version
Thu, Jan 12, 05:33
dereckson accepted D2733: Promote imported FANTOIR version.
Thu, Jan 12, 05:31
dereckson added a revision to T1750: Import FANTOIR database: D2733: Promote imported FANTOIR version.
Thu, Jan 12, 05:30 · Nasqueron Databases
dereckson requested review of D2733: Promote imported FANTOIR version.
Thu, Jan 12, 05:30
dereckson closed D2732: Update Arcanist callsign.
Thu, Jan 12, 05:07
dereckson committed rDS502520b33e3c: Update Arcanist callsign (authored by dereckson).
Update Arcanist callsign
Thu, Jan 12, 05:07
dereckson accepted D2732: Update Arcanist callsign.
Thu, Jan 12, 05:06
dereckson requested review of D2732: Update Arcanist callsign.
Thu, Jan 12, 05:06
dereckson committed rDSb483889ac492: Import FANTOIR file into PostgreSQL db (authored by dereckson).
Import FANTOIR file into PostgreSQL db
Thu, Jan 12, 05:05
dereckson closed D2729: Import FANTOIR file into PostgreSQL db.

Merged.

Thu, Jan 12, 05:04
dereckson set the repository for D2729: Import FANTOIR file into PostgreSQL db to rDS Nasqueron Datasources.
Thu, Jan 12, 05:03
dereckson accepted D2729: Import FANTOIR file into PostgreSQL db.
Thu, Jan 12, 05:00
dereckson updated the diff for D2729: Import FANTOIR file into PostgreSQL db.

fantoir2db is now fantoir-datasource

Thu, Jan 12, 05:00
dereckson updated the diff for D2731: Query Wikidata to enrich FANTOIR file.

Remove test limit

Thu, Jan 12, 01:55
dereckson moved T1751: Enrich FANTOIR database with Wikidata information from Backlog to Working on on the Nasqueron Databases board.
Thu, Jan 12, 01:47 · Wikimedia, Nasqueron Databases
dereckson added a project to T1751: Enrich FANTOIR database with Wikidata information: Wikimedia.
Thu, Jan 12, 01:46 · Wikimedia, Nasqueron Databases
dereckson updated the task description for T1751: Enrich FANTOIR database with Wikidata information.
Thu, Jan 12, 01:46 · Wikimedia, Nasqueron Databases
dereckson triaged T1751: Enrich FANTOIR database with Wikidata information as Normal priority.
Thu, Jan 12, 01:37 · Wikimedia, Nasqueron Databases
dereckson updated the summary of D2729: Import FANTOIR file into PostgreSQL db.
Thu, Jan 12, 01:33
dereckson added a revision to T1750: Import FANTOIR database: D2729: Import FANTOIR file into PostgreSQL db.
Thu, Jan 12, 01:33 · Nasqueron Databases
dereckson triaged T1750: Import FANTOIR database as Normal priority.
Thu, Jan 12, 01:33 · Nasqueron Databases
dereckson planned changes to D2731: Query Wikidata to enrich FANTOIR file.
Thu, Jan 12, 01:19
dereckson updated the diff for D2731: Query Wikidata to enrich FANTOIR file.

A lot of code to handle exceptions, mainly because there are
several formats used to represent the FANTOIR code.

Thu, Jan 12, 01:19

Wed, Jan 11

dereckson abandoned D2721: Serve API URL cleaner.
Wed, Jan 11, 00:23
dereckson abandoned D2719: Clean TikTok URL.
Wed, Jan 11, 00:23

Tue, Jan 10

dereckson requested review of D2731: Query Wikidata to enrich FANTOIR file.
Tue, Jan 10, 19:53
dereckson updated alken-orin.
Tue, Jan 10, 02:40
dereckson triaged T1749: Update token on Phabricator Notifications Center configuration as Unbreak Now! priority.
Tue, Jan 10, 02:29 · Notifications center, DevCentral
dereckson closed T1727: 500 error when Phabricator sends a payload to the notifications center as Resolved.

I've regenerated /usr/share/ca-certificates and /etc/ssl/certs based on a "recent" Debian ca-certificates package against Debian Sid, version 20211016. Works like a charm now.

Tue, Jan 10, 02:25 · User-Dereckson, Regression, DevCentral, Notifications center
dereckson updated subscribers of T1727: 500 error when Phabricator sends a payload to the notifications center.

Container still runs on Jessie, we need to deploy new @DorianWinty work on recent Debian PHP 8 container, with correct certificates.

Tue, Jan 10, 02:04 · User-Dereckson, Regression, DevCentral, Notifications center
dereckson added a comment to T1727: 500 error when Phabricator sends a payload to the notifications center.

Disabled Sentry, so we can have a correct log of the stacktrace, and updated description accordingly.

Tue, Jan 10, 02:01 · User-Dereckson, Regression, DevCentral, Notifications center
dereckson updated the task description for T1727: 500 error when Phabricator sends a payload to the notifications center.
Tue, Jan 10, 01:58 · User-Dereckson, Regression, DevCentral, Notifications center
dereckson closed D2730: Remove trailing spaces.
Tue, Jan 10, 01:57
dereckson committed rVIPER4c95b72cf250: Remove trailing spaces (authored by dereckson).
Remove trailing spaces
Tue, Jan 10, 01:57
dereckson added a member for Trusted users: inidal.
Tue, Jan 10, 01:56
dereckson accepted D2730: Remove trailing spaces.
Tue, Jan 10, 01:56
dereckson added a comment to T992: Start documentation for the notifications center.

"The notification lifecycle: how a notification is provided and consumed" schema

Tue, Jan 10, 01:56 · documentation, Notifications center
dereckson requested review of D2730: Remove trailing spaces.
Tue, Jan 10, 01:56

Mon, Jan 9

dereckson updated the diff for D2729: Import FANTOIR file into PostgreSQL db.

Extract run_multiple_queries method to the db module. We can't easily move the create_table function, as it needs schema-dependant replacement.

Mon, Jan 9, 18:37
dereckson updated the diff for D2729: Import FANTOIR file into PostgreSQL db.

Switch to subcommands pattern (like git), so we can extend it

Mon, Jan 9, 18:22
dereckson updated the diff for D2729: Import FANTOIR file into PostgreSQL db.

Creation date can be unknown, add code_fantoir to help cross data with other db, fix last line record parsing

Mon, Jan 9, 17:36

Jan 9 2023

dereckson requested review of D2729: Import FANTOIR file into PostgreSQL db.
Jan 9 2023, 02:12

Jan 5 2023

dereckson added a comment to D2379: Parse FANTOIR database.

Draft implementation: rFANTDB59128e4bfd41 (needs to add all FANTOIR field).

Jan 5 2023, 04:25
dereckson committed rDS59128e4bfd41: WIP: Import FANTOIR file into PostgreSQL db (authored by dereckson).
WIP: Import FANTOIR file into PostgreSQL db
Jan 5 2023, 04:22