neocl / jamdict Goto Github PK

# find all idseq of lexical entry (i.e. words) that have at least 1 sense with pos = suru verb - irregular
with jam.jmdict.ctx() as ctx:
    # query all word's idseqs
    rows = ctx.select(
        query="SELECT DISTINCT idseq FROM Sense WHERE ID IN (SELECT sid FROM pos WHERE text = ?)",
        params=("expressions (phrases, clauses, etc.)",))
    for row in rows:
        # reuse database connection with ctx=ctx for better performance
        word = jam.jmdict.get_entry(idseq=row['idseq'], ctx=ctx)
        ruler.add_patterns([{"label": "EXPRESSION", "pattern": x.text} for x in word.kanji_forms])
        ruler.add_patterns([{"label": "EXPRESSION", "pattern": x.text} for x in word.kana_forms])
        print("Working on expressions...")

PS C:\Users\User> python.exe -m pip install jamdict-data
Collecting jamdict-data
  Downloading jamdict_data-1.5.tar.gz (53.9 MB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 53.9/53.9 MB 9.8 MB/s eta 0:00:00
  Installing build dependencies ... done
  Getting requirements to build wheel ... done
  Preparing metadata (pyproject.toml) ... error
  error: subprocess-exited-with-error

  × Preparing metadata (pyproject.toml) did not run successfully.
  │ exit code: 1
  ╰─> [13 lines of output]
      running dist_info
      creating C:\Users\User\AppData\Local\Temp\pip-modern-metadata-_2sae9a0\jamdict_data.egg-info
      writing C:\Users\User\AppData\Local\Temp\pip-modern-metadata-_2sae9a0\jamdict_data.egg-info\PKG-INFO
      writing dependency_links to C:\Users\User\AppData\Local\Temp\pip-modern-metadata-_2sae9a0\jamdict_data.egg-info\dependency_links.txt
      writing top-level names to C:\Users\User\AppData\Local\Temp\pip-modern-metadata-_2sae9a0\jamdict_data.egg-info\top_level.txt
      writing manifest file 'C:\Users\User\AppData\Local\Temp\pip-modern-metadata-_2sae9a0\jamdict_data.egg-info\SOURCES.txt'
      reading manifest file 'C:\Users\User\AppData\Local\Temp\pip-modern-metadata-_2sae9a0\jamdict_data.egg-info\SOURCES.txt'
      reading manifest template 'MANIFEST.in'
      adding license file 'LICENSE'
      writing manifest file 'C:\Users\User\AppData\Local\Temp\pip-modern-metadata-_2sae9a0\jamdict_data.egg-info\SOURCES.txt'
      creating 'C:\Users\User\AppData\Local\Temp\pip-modern-metadata-_2sae9a0\jamdict_data-1.5.dist-info'
      Unpacking database from C:\Users\User\AppData\Local\Temp\pip-install-6nyf8b0w\jamdict-data_51d99a1c3c554a3a9b8858235b75d3ac\jamdict_data\jamdict.db.xz to C:\Users\User\AppData\Local\Temp\pip-install-6nyf8b0w\jamdict-data_51d99a1c3c554a3a9b8858235b75d3ac\jamdict_data\jamdict.db
      error: [WinError 32] The process cannot access the file because it is being used by another process: 'jamdict_data/jamdict.db.xz'
      [end of output]

  note: This error originates from a subprocess, and is likely not a problem with pip.
error: metadata-generation-failed

× Encountered error while generating package metadata.
╰─> See above for output.

note: This is an issue with the package mentioned above, not pip.
hint: See above for details.

========================================
Found entries
========================================
Entry: 1132270 | Kj:   | Kn: ムーン
--------------------
1. moon ((noun (common) (futsuumeishi)))

========================================
Found characters
========================================

$ python -m jamdict import
Jamdict 0.1a11.post2
Python library for using Japanese dictionaries and resources (Jim Breen's JMdict, KanjiDic2, KRADFILE, JMnedict)

Basic configuration
------------------------------------------------------------
JAMDICT_HOME: ~/.jamdict [OK]
jamdict-data: version 1.5.1a2 [OK]
Config file : Not available.
     Run `python3 -m jamdict config` to create configuration file if needed.

Data files
------------------------------------------------------------
Jamdict DB location: ~/extern/jamdict_data/jamdict_data/jamdict.db - [NOT FOUND]
JMDict XML file    : ~/.jamdict/data/JMdict_e.gz - [OK]
KanjiDic2 XML file : ~/.jamdict/data/kanjidic2.xml.gz - [OK]
JMnedict XML file  : ~/.jamdict/data/JMnedict.xml.gz - [OK]

Others
------------------------------------------------------------
puchikarui: version 0.1
chirptext : version 0.1.2
lxml      : False
Importing data to: ~/extern/jamdict_data/jamdict_data/jamdict.db
Started - [Creating Jamdict SQLite database. This process may take very long time ...]
WARNING:puchikarui.puchikarui:DB does not exist at ~/extern/jamdict_data/jamdict_data/jamdict.db. Setup is required.
WARNING:jamdict.util:Building Kanjidic2 DB using a different DB context None vs ~/extern/jamdict_data/jamdict_data/jamdict.db
ERROR:puchikarui.puchikarui:Query failed: q=INSERT INTO character (ID,literal,stroke_count,grade,freq,jlpt) VALUES (?,?,?,?,?,?) , p=(None, '亜', 7, '8', '1509', '1')
Traceback (most recent call last):
  File "~/.venv/Lib/site-packages/puchikarui/puchikarui.py", line 469, in execute
    _r = self.cur.execute(query, params)
         ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
sqlite3.OperationalError: database is locked
Traceback (most recent call last):
  File "<frozen runpy>", line 198, in _run_module_as_main
  File "<frozen runpy>", line 88, in _run_code
  File "~/.venv/Lib/site-packages/jamdict/__main__.py", line 2, in <module>
    tools.main()
  File "~/.venv/Lib/site-packages/jamdict/tools.py", line 294, in main
    app.run()
  File "~/.venv/Lib/site-packages/chirptext/cli.py", line 135, in run
    args.func(self, args)
  File "~/.venv/Lib/site-packages/jamdict/tools.py", line 83, in import_data
    jam.import_data()
  File "~/.venv/Lib/site-packages/jamdict/util.py", line 502, in import_data
    self.kd2.insert_chars(self.kd2_xml, ctx=kd_ctx)
  File "~/.venv/Lib/site-packages/jamdict/kanjidic2_sqlite.py", line 124, in insert_chars
    self.insert_char(c, ctx=ctx)
  File "~/.venv/Lib/site-packages/jamdict/kanjidic2_sqlite.py", line 132, in insert_char
    c.ID = ctx.character.save(c)
           ^^^^^^^^^^^^^^^^^^^^^
  File "~/.venv/Lib/site-packages/puchikarui/puchikarui.py", line 366, in save
    return self._context.insert_object(self._table, obj, columns, self._table._field_map)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "~/.venv/Lib/site-packages/puchikarui/puchikarui.py", line 439, in insert_object
    self.insert_record(table, values, columns)
  File "~/.venv/Lib/site-packages/puchikarui/puchikarui.py", line 414, in insert_record
    self.execute(query, values)
  File "~/.venv/Lib/site-packages/puchikarui/puchikarui.py", line 469, in execute
    _r = self.cur.execute(query, params)
         ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
sqlite3.OperationalError: database is locked