(An Untitled Masterwork)
ActivePublic
Actions

Authored by douardda on Mar 26 2021, 9:52 AM.

Tags

None

Subscribers

None

	ddouard@petitpalais:~$ cat revision-cvs-extract.py
	#!/usr/bin/env python
	import sys
	import iso8601

	try:
	for line in sys.stdin:
	row = line.split(',')
	date = iso8601.parse_date(row[1])

	print(f"{row[0][2:]},{date},{row[6][2:]}")
	except BrokenPipeError:
	pass

	ddouard@petitpalais:~$ zcat /data/aeviso/revision.csv.gz \| python3 revision-cvs-extract.py \| head
	646617f642f8a7bd83e25427b59c1e8ea37c4eac,2014-03-21 19:32:26+00:00,d293b944413339fdd0ceff6eb3da400ec9ca4969
	5cfc2b50cff63bb7bff11f212488317e8ef99039,2014-03-21 13:10:39+00:00,7904233253dacc25b90343c3ac8e4ee2fcdaad9e
	aaa802f565163487be2415fffa35356a508ecaa2,2014-03-20 21:30:05+00:00,dfb491529991648bc698c9794ebba30a5e889275
	2136251fdb0506cf87664dc313b92ff41033998b,2014-03-20 12:59:14+00:00,dfb491529991648bc698c9794ebba30a5e889275
	8e074ebf60da33938f38ea11c96dad8c5ea05644,2014-03-20 12:53:41+00:00,d0f42083b8be9d486bb39c3139034010c641a48f
	a1367b6c961cce399ff89f2400906d5d3c616d73,2014-03-19 21:41:42+00:00,4f4496c46d156fca838e58ed37632ccf15627e09
	5103c8fcd47574824983269d861a0fdba3b39d9e,2014-03-18 16:33:30+00:00,970be42a4b8824168d6934979db50d1dc607e3e6
	9e70fd23f886e330269871ee464a6419340f7a5f,2014-03-19 21:45:31+00:00,3fac6d34dc37ada78b740c10faa351ba0eb92299
	d1b395b53321995105e83724d9b30d9c237ab030,2014-03-19 16:23:12+00:00,11af95303cec29a01d5787c428fa2f976bd76c9d
	6e0dfdaba1f13473d3d439c5a100d5d8f7e639e7,2014-03-19 21:44:07+00:00,ef5cf6c95438a356d56779d7d1fe5c87bbd06fc5

(An Untitled Masterwork)ActivePublicActions