[PYTHON] IPMsg Log Converter for Mac

--The log of IPMsg for Mac is standard, just look at it with an editor. ――So I made a script to format it into sqlite3.db format. --You can see it with various sqlite viewers.

Repository (GitHub)

• https://github.com/qoAopx/ipmsg_logconv

Required environment (mac os)

--Created in the following environment.

1. nkf (can be installed with 2.1.4 brew)
2. python3 (with pyenv etc.)
3. sqlite3 (can be installed with 3.20.0 brew)
4. sqlite3 viewer such as DB Browser

How to use

--Download or git clone to download the project --Double-click convert_ipmsg_log.command --Format the ipmsg text log file into sqlite3.db format. --Open the formatted sqlite3.db file. (The default app will start.)

--It is recommended to create an alias for convert_ipmsg_log.command.

the way to use

--Since it is in sqlite3.db format, you can usually see it in Browse Data of DB Browser, and you can also filter and sort without SQL.

――Furthermore, if you use SQL, you can extract the message one day ago.

SELECT 
	*
FROM
	ipmsg_log
WHERE
	datetime >  datetime( current_timestamp , "-1 days") 
ORDER BY
	datetime desc