#editorial | Logs for 2021-11-11

« return
[13:44:21] <Bytram> wow Am I out of it! Just realized today is Veteran's Day in the US ( https://en.wikipedia.org )
[13:44:22] <systemd> ^ 03Veterans Day - Wikipedia
[13:45:42] <Bytram> >>> Veterans Day (originally known as Armistice Day) is a federal holiday in the United States observed annually on November 11, for honoring military veterans, who are people who have served in the United States Armed Forces (that were discharged under conditions other than dishonorable).[1][2] It coincides with other holidays including Armistice Day and Remembrance Day which are celebrated in other countries that mark the anniversary
[13:45:42] <Bytram> of the end of World War I.[3] Major hostilities of World War I were formally ended at the 11th hour of the 11th day of the 11th month of 1918 when the Armistice with Germany went into effect. At the urging of major U.S. veteran organizations, Armistice Day was renamed Veterans Day in 1954.[4]
[13:54:13] <Bytram> We should have Holiday/Weekend story spacing today!
[14:16:14] <Bytram> FatPhil: You around?
[14:17:20] <Bytram> chromas: You around?
[14:24:21] <Bytram> I'm trying to reschedule today's stories to be 4h45m apart. Am looking at using dateutils.dconv to automagically come up with new date/time stamps that can be copy/pasted into a story edit... having a brain cramp trying to sort out the syntax. Think it's possible to start with ( https://soylentnews.org )
[14:24:22] <systemd> ^ 03backSlash 14:24:22 = 14:24:22 GMT
[14:24:52] <Bytram> =eds
[14:24:52] <systemd> ^ Editor ping for Bytram, chromas, cmn32480, CoolHand, FatPhil, Fnord666, fyngyrz, janrinok, mrpg, n1, nick, spiraldancing, takyon
[14:31:15] <Bytram> Prolly easiest to space *all* stories *starting* with today (2021-11-11) and space them 4h45m apart... and *then* go back and tighten the spacing for stories that fall into tomorrow (2021-11-12) to be 2h45m apart?
[14:55:29] <Bytram> gtg; biab
[15:32:30] <Bytram> alternatively, from the DB:
[15:32:42] <Bytram> PASTE-BEGIN:
[15:32:47] <Bytram> mysql> SELECT stories.stoid, stories.sid, stories.time, substr(story_text.title, 1, 80) FROM stories, story_text WHERE stories.stoid = story_text.stoid AND time >= '2021-11-11' ORDER BY time ;
[15:32:48] <Bytram> +--------+------------------+---------------------+----------------------------------------------------------------------------------+
[15:32:48] <Bytram> | stoid | sid | time | substr(story_text.title, 1, 80) |
[15:32:48] <Bytram> +--------+------------------+---------------------+----------------------------------------------------------------------------------+
[15:32:50] <Bytram> | 378829 | 21/11/10/1415241 | 2021-11-11 02:43:00 | US Government Strategy to Establish National Privacy Standard |
[15:32:53] <Bytram> | 378830 | 21/11/10/1421221 | 2021-11-11 05:30:00 | Compact Fusion Power Plant Concept Uses State-Of-The-Art Physics To Improve Ener |
[15:32:56] <Bytram> | 378831 | 21/11/10/1426244 | 2021-11-11 08:14:00 | Archaeologists Discover Ancient 'Hangover Prevention' Ring |
[15:32:59] <Bytram> | 378832 | 21/11/11/0656259 | 2021-11-11 11:10:00 | Google Summer of Code Now Open to Adults |
[15:33:02] <Bytram> | 378833 | 21/11/11/071238 | 2021-11-11 14:00:00 | Last of Original SCO v IBM Linux Lawsuit Settled |
[15:33:05] <Bytram> | 378834 | 21/11/11/1229215 | 2021-11-11 16:48:00 | SpinLaunch's Rocket-Free Kinetic Launch System Conducts First Test Flight |
[15:33:10] <Bytram> | 378835 | 21/11/11/1237241 | 2021-11-11 19:35:00 | TSMC and Sony Officially Create Partnership to Build $7 Billion Fab in Japan |
[15:33:13] <Bytram> | 378836 | 21/11/11/1242238 | 2021-11-11 22:17:00 | NASA Solar Probe 'Touched the Sun' but is Enduring Dangerous Plasma Explosions |
[15:33:16] <Bytram> | 378837 | 21/11/11/148237 | 2021-11-12 01:05:00 | State Hackers Breach Defense, Energy, Healthcare Orgs Worldwide |
[15:33:19] <Bytram> | 377334 | 21/03/26/223200 | 2022-03-26 21:37:00 | A Resignation |
[15:33:22] <Bytram> +--------+------------------+---------------------+----------------------------------------------------------------------------------+
[15:33:25] <Bytram> 10 rows in set (0.00 sec)
[15:33:27] <Bytram> mysql>
[15:33:29] <Bytram> PASTE-END
[15:34:01] <Bytram> .
[15:35:24] <Bytram> Reversed order:
[15:35:32] <Bytram> PASTE-BEGIN
[15:35:49] <Bytram> mysql> SELECT stories.stoid, stories.sid, stories.time, substr(story_text.title, 1, 80) FROM stories, story_text WHERE stories.stoid = story_text.stoid AND time >= '2021-11-11' ORDER BY time DESC ;
[15:35:49] <Bytram> +--------+------------------+---------------------+----------------------------------------------------------------------------------+
[15:35:49] <Bytram> | stoid | sid | time | substr(story_text.title, 1, 80) |
[15:35:49] <Bytram> +--------+------------------+---------------------+----------------------------------------------------------------------------------+
[15:35:51] <Bytram> | 377334 | 21/03/26/223200 | 2022-03-26 21:37:00 | A Resignation |
[15:35:54] <Bytram> | 378837 | 21/11/11/148237 | 2021-11-12 01:05:00 | State Hackers Breach Defense, Energy, Healthcare Orgs Worldwide |
[15:35:57] <Bytram> | 378836 | 21/11/11/1242238 | 2021-11-11 22:17:00 | NASA Solar Probe 'Touched the Sun' but is Enduring Dangerous Plasma Explosions |
[15:36:00] <Bytram> | 378835 | 21/11/11/1237241 | 2021-11-11 19:35:00 | TSMC and Sony Officially Create Partnership to Build $7 Billion Fab in Japan |
[15:36:03] <Bytram> | 378834 | 21/11/11/1229215 | 2021-11-11 16:48:00 | SpinLaunch's Rocket-Free Kinetic Launch System Conducts First Test Flight |
[15:36:06] <Bytram> | 378833 | 21/11/11/071238 | 2021-11-11 14:00:00 | Last of Original SCO v IBM Linux Lawsuit Settled |
[15:36:11] <Bytram> | 378832 | 21/11/11/0656259 | 2021-11-11 11:10:00 | Google Summer of Code Now Open to Adults |
[15:36:14] <Bytram> | 378831 | 21/11/10/1426244 | 2021-11-11 08:14:00 | Archaeologists Discover Ancient 'Hangover Prevention' Ring |
[15:36:17] <Bytram> | 378830 | 21/11/10/1421221 | 2021-11-11 05:30:00 | Compact Fusion Power Plant Concept Uses State-Of-The-Art Physics To Improve Ener |
[15:36:20] <Bytram> | 378829 | 21/11/10/1415241 | 2021-11-11 02:43:00 | US Government Strategy to Establish National Privacy Standard |
[15:36:23] <Bytram> +--------+------------------+---------------------+----------------------------------------------------------------------------------+
[15:36:26] <Bytram> 10 rows in set (0.05 sec)
[15:36:28] <Bytram> mysql>
[15:36:30] <Bytram> PASTE-END
[16:17:13] <janrinok> =systemd https://www.tomshardware.com
[16:27:31] -!- inky has quit [Ping timeout: 264 seconds]
[17:02:39] -!- inky [inky!~inky@185.31.hkr.mig] has joined #editorial
[18:22:07] -!- inky has quit [Ping timeout: 264 seconds]
[18:24:45] -!- inky [inky!~inky@urmvjcxbzcyhj.tor-exit.calyxinstitute.org] has joined #editorial
[20:23:36] <halibut> Bytram: You probably figured out a solution. In case you are interested, I put together a python script that can do something similar. It reads the mysql output (currently assuming only stoid and time columns), and outputs UPDATE lines (heavily mangled, since I do not have a MySQL database to experiment on) that sets the desired time spacing.
[20:23:45] <halibut> It reads something like this from stdin:
[20:23:51] <halibut> | stoid | time |
[20:23:58] <halibut> +--------+---------------------+
[20:23:58] <halibut> | 378829 | 2021-11-11 02:43:00 |
[20:23:59] <halibut> | 378830 | 2021-11-11 05:30:00 |
[20:23:59] <halibut> | 378831 | 2021-11-11 08:14:00 |
[20:24:00] <halibut> | 378832 | 2021-11-11 11:10:00 |
[20:24:16] <halibut> and outputs something like this (again, I know the MySQL is not correct, but hopefully can be fixed):
[20:24:24] <halibut> UPDATE VALUES (time) ('2021-11-11 07:28:00') WHERE stoid = '378830';
[20:24:24] <halibut> UPDATE VALUES (time) ('2021-11-11 12:13:00') WHERE stoid = '378831';
[20:24:24] <halibut> UPDATE VALUES (time) ('2021-11-11 16:58:00') WHERE stoid = '378832';
[20:24:35] <halibut> (only three lines because the first is left alone).
[20:25:33] <halibut> Apologies for the mess, but here is the file. Copy these four lines to convertdate.b64, and run: base64 -d convertdate.b64 | xz -dc >convertdate.py
[20:25:51] <halibut> /Td6WFoAAATm1rRGAgAhARwAAAAQz1jM4ALcAaZdABGIQkeKIzPDdw8z/VhnH14++zRlb+ysPMFGkEzWrWXk0WviEjfXjsLFIDv94rXL5x6wyBqMrcVl1mEttM+4Ff6J47Ik0qZFgQzah1qs51QiVvQVnl5d0ge6pK5pAQ5Kzr+0wSJEv9rmtsdOcoeils1Z
[20:25:55] <halibut> zT6U1L197aHqJdp1PGGEdFwOfDxi//ZYocDVO4xEDwinX09UhwhDqcx7KCrTZKZ8y+FGsP7IPx1Dh64ClGqOyd1lDkKSuz7BZQBpZEB28piPpsVSoIStc3lxCi5f0VNlQC+kEUbdRQWz40rkyfX6FB2tIqf8/Il0yh7MdK9TbhTwv49lKtue9B4z0hFJO5FH
[20:25:59] <halibut> CpyNyvYFeeviPqBtw5v6UDRFiy7sIdgs/5kTL2uc13PTlfFAP/ZDnS3/lRQP+s+4xQ70w6z7YaGrKm1rGqRLuliegaojEfkV2rvvtEDDryuHT+aPZyUHbfKIdaqhGyYuYvtkgrjhkaXTnvA7Oe0KyGucQ1d3AJ/LJHdwkdPqZwTER3E2SncgydEpb//pn5EU
[20:26:03] <halibut> z5k95Sk6BgH8Eofvf6C+Xvk40bDgAAAAV4GAeJhy22kAAcID3QUAAB2yIAqxxGf7AgAAAAAEWVo=