Emoji Search Script

[ramiroaraujo]

Open emoji-search in Script Kit

A rather simple Emoji search that uses local database for fast lookup. It actually bootstrap by creating a sqlite database out of the emojilib JSON, in particular for storing usage and sorting by it. It will search by name and keywords, and the list will be sorted by most used

// Name: Emoji Search
// Description: Search and copy emoji to clipboard using SQLite database

import "@johnlindquist/kit"

const Database = await npm("better-sqlite3")
const databaseFile = projectPath("db", "emoji-search-emojilib.db")

const emojilibURL = "https://raw.githubusercontent.com/muan/emojilib/main/dist/emoji-en-US.json"

const createDatabase = async () => {
    const response = await get(emojilibURL)
    const emojiData = response.data as Record<string, string[]>

    //create db and table
    const db = new Database(databaseFile)
    db.exec(`CREATE TABLE IF NOT EXISTS emojis
           (emoji TEXT PRIMARY KEY, name TEXT, keywords TEXT, used INTEGER DEFAULT 0)`)

    //populate with data from emojilib
    for (const [emojiChar, emojiInfo] of Object.entries(emojiData)) {
        const description = emojiInfo[0]
        const tags = emojiInfo.slice(1).join(', ')

        db.prepare("INSERT OR REPLACE INTO emojis VALUES (?, ?, ?, 0)").run(emojiChar, description, tags)
    }
    db.close()
};

if (!await pathExists(databaseFile)) {
    await createDatabase()
}

const db = new Database(databaseFile)

const queryEmojis = async () => {
    const sql = "SELECT emoji, name, keywords FROM emojis ORDER BY used DESC"
    const stmt = db.prepare(sql)
    return stmt.all()
}

const snakeToHuman = (text) => {
    return text
        .split('_')
        .map((word, index) => index === 0 ? word.charAt(0).toUpperCase() + word.slice(1) : word)
        .join(' ')
}

const emojis = await queryEmojis()

const selectedEmoji = await arg("Search Emoji", emojis.map(({ emoji, name, keywords }) => ({
    name: `${snakeToHuman(name)} ${keywords}`,
    html: md(`<div class="flex items-center">
            <span class="text-5xl">${emoji}</span>
            <div class="flex flex-col ml-2">
                <span class="text-2xl" style="color: lightgrey">${snakeToHuman(name)}</span>
                <small style="color: darkgrey">${keywords}</small>       
            </div>
        </div>`),
    value: emoji,

})))

await clipboard.writeText(selectedEmoji)

// Update the 'used' count
const updateSql = "UPDATE emojis SET used = used + 1 WHERE emoji = ?"
const updateStmt = db.prepare(updateSql)
updateStmt.run(selectedEmoji)

db.close()

[shyagamzo]

Funny how much code is necessary just to deal with emojis😄

Love the script. Thank you.

[johnlindquist]

@shyagamzo try

await emoji()

😉

[shyagamzo]

Oh...

Well, funny how much code is necessary to deal with emojis....... 😂

Nice one. Yu iz da king uv shortcuts John 🤩

[Animeshz]

Hey, I tried running the script, but it doesn't go off:

00:39:05.794 › ☠️ ERROR PROMPT SHOULD SHOW ☠️
00:39:05.795 › SyntaxError: Unexpected identifier
    at ESMLoader.moduleStrategy (node:internal/modules/esm/translators:119:18)
    at ESMLoader.moduleProvider (node:internal/modules/esm/loader:468:14)
    at async link (node:internal/modules/esm/module_job:68:21)

Shows some error that are internal to node, and I can't figure out where to look for, can you please help me out @ramiroaraujo ? Thanks!

[ramiroaraujo]

hahaha I think @johnlindquist's solution is a bit simpler 😅😅😅
I'd rather stick with that one