Markdown to Roam Research

md2rrjson.py

""" Markdown (with date in title) files import to Roam Research using JSON format
"""

import os
import glob
import re
import json
import maya
from nanoid import generate

EMAIL=''
HEADLINE=''

def list_files():
    list = []
    for x in glob.glob("auto/*.md"):
       list.append(x)
    return list

def _title(date):
    """Format creationDate string using maya, to make datetime string macos friendly"""
    month_dict = ["", "January",
                    "February",
                    "March",
                    "April",
                    "May",
                    "June",
                    "July",
                    "August",
                    "September",
                    "October",
                    "November",
                    "December"]
    return month_dict[date.month] + ' ' + str(date.day) + suffix(date.day) + ', ' + str(date.year)

def suffix(d):
    return 'th' if 11 <= d <= 13 else {1: 'st', 2: 'nd', 3: 'rd'}.get(d % 10, 'th')

list_md = list_files()

results = []

for i in list_md:
    rrjson = {
            "create-email": EMAIL,
            "create-time": 0,
            "title": '',
            "children": [
                {
                    "string": HEADLINE,
                    "create-email": EMAIL,
                    "create-time": 0,
                    "children": [
                        {
                            "string": '',
                            "create-email": EMAIL,
                            "create-time": 0,
                            "uid": '',
                            "edit-time": 0,
                            "edit-email": EMAIL
                            }
                        ],
                    "uid": '',
                    "edit-time": 0,
                    "edit-email": EMAIL
                }
            ],
            "uid": '',
            "edit-time": 0,
            "edit-email": EMAIL
        }


    with open(i, 'r') as f:
        lines = f.readlines()
        body = ''.join(lines)
        date_str = re.findall(r"\d+\.\d+\.\d+",f.name)[0]
        date = maya.parse(date_str)

        title = _title(date)
        create_time = date.epoch * 1000
        edit_time = date.epoch * 1000
        print (title)

        # body
        rrjson['children'][0]['children'][0]['string'] = body

        # uid
        rrjson['uid'] = generate(size=9)
        rrjson['children'][0]['uid'] = generate(size=9)
        rrjson['children'][0]['children'][0]['uid'] = generate(size=9)

        # time
        rrjson['create-time'] = create_time
        rrjson['edit-time'] = edit_time
        rrjson['children'][0]['create-time'] = create_time
        rrjson['children'][0]['edit-time'] = edit_time
        rrjson['children'][0]['children'][0]['create-time'] = create_time
        rrjson['children'][0]['children'][0]['edit-time'] = edit_time

        # title
        rrjson['title'] = title

    results.append(rrjson)

with open('rrtest.json', "w") as f:
        json.dump(results, f, ensure_ascii=False)