there is no "easy" way to do this

1. Generate the list
2. Drop the nick_id from nick_values
3. Drop the nick_id from nicknames
4. Delete the key from nick_ids

https://zppixbot.toolforge.org/zppixbot/wiki/index.php?title=Privacy_Policy&diff=38&oldid=5

Mentioned in SAL (#wikimedia-cloud) [2020-06-01T13:30:13Z] <RhinosF1> ran select nick_id from nick_values where value < 1546300800 and key = "seen_timestamp" on default.db to generate P11346 for T254154

We can make an python script to run the SQL and remove the data from the tables

In SQL:

DELETE from nick_values where nick_id is 34;
DELETE from nicknames where nick_id is 34;
DELETE from nick_ids where nick_id is 34;

would drop user 34 from everywhere in default.db

In T254154#6183365, @RhinosF1 wrote:

In SQL:

DELETE from nick_values where nick_id is 34;
DELETE from nicknames where nick_id is 34;
DELETE from nick_ids where nick_id is 34;

would drop user 34 from everywhere in default.db

Looks alright to me. We can begin a python script to automate this tomorrow. For a more long-term solution we can make a python script to review the data in the tables to see what needs to be removed.

For a more long-term solution we can make a python script to review the data in the tables to see what needs to be removed.

That's 1 select query

In T254154#6183372, @RhinosF1 wrote:

For a more long-term solution we can make a python script to review the data in the tables to see what needs to be removed.

That's 1 select query

By that I meant to add on to the script to make it one automated process.

EXAMPLE:

select nick_id from nick_values where value < 1546300800 and key = "seen_timestamp"

for criteria 2

select nick_id from nick_values where value < "##RhinosF1" and key = "seen_channel"

for criteria 1

In T254154#6183376, @Examknow wrote:

In T254154#6183372, @RhinosF1 wrote:

For a more long-term solution we can make a python script to review the data in the tables to see what needs to be removed.

That's 1 select query

By that I meant to add on to the script to make it one automated process.

ah

Mentioned in SAL (#wikimedia-cloud) [2020-06-02T10:06:12Z] <RhinosF1> run dbclean.py using

Mentioned in SAL (#wikimedia-cloud) [2020-06-02T10:08:05Z] <RhinosF1> run dbclean.py using

Checking a few bits of orphan data