Hacktoberfest 2026：维护者为十月标记出来的 issue，仍然开放、适合新手。 浏览 Hacktoberfest issue

SQLite console opens (0.1.7)

未关闭
  • 哪里不对？
#46 4 条评论 0 个 reaction 已指派 0 人 在 GitHub 查看

还没有人认领这个 Issue。

评估

难度
4/5
预计耗时
3-5 天
新手友好度
35/100
Issue 类型
缺陷
描述清晰度
需要澄清
活跃度
停滞
技术栈
python, sqlite
领域
cli, database

调研方向

首先在 0.1.7 版本上重现 semsql make mirror/doid.db，并检查围绕日志中显示的 sqlite3 命令生成的 SQLite 管道。跟踪控制台为何仍保持交互状态，然后验证自动化命令能够完成，并且使用 ; 或 && 链接的命令能够继续执行，而不需要 Ctrl+D，也不会冻结终端。

由索引模型根据 Issue 内容生成。

描述

Overview

When using semsql, the SQLite console opens. I need to exit it manually in order for the command to continue. Since this is running in a pipeline that is meant to be automated, I shouldn't use semsql until I can fix this.

Log

Problem beings at sqlite>:

sh [run.sh](http://run.sh/) semsql make mirror/doid.db; beep
cat /usr/local/lib/python3.10/dist-packages/semsql/builder//sql_schema/semsql.sql | sqlite3 .template.db.tmp && \
sqlite3 -echo .template.db.tmp -cmd ".mode csv" -cmd ".import /usr/local/lib/python3.10/dist-packages/semsql/builder//prefixes/prefixes.csv prefix" -cmd ".exit" && \
mv .template.db.tmp .template.db
SQLite version 3.37.2 2022-01-06 13:25:41
Enter ".help" for usage hints.
sqlite>

relation-graph --disable-owl-nothing true \
                       --ontology-file mirror/doid.owl\
                       --output-file mirror/doid-relation-graph.tsv.ttl.tmp \
                       --equivalence-as-subclass true \
               --output-subclasses true \
                       --reflexive-subclasses true && \
riot --out RDFXML mirror/doid-relation-graph.tsv.ttl.tmp > mirror/doid-relation-graph.tsv.owl.tmp && \
sqlite3 mirror/doid-relation-graph.tsv.db.tmp -cmd ".mode csv" ".import /usr/local/lib/python3.10/dist-packages/semsql/builder//prefixes/prefixes.csv prefix" && \
rdftab mirror/doid-relation-graph.tsv.db.tmp < mirror/doid-relation-graph.tsv.owl.tmp && \
sqlite3 mirror/doid-relation-graph.tsv.db.tmp -cmd '.separator "\t"' -cmd '.header on' "SELECT subject,predicate,object FROM statements " > mirror/doid-relation-graph.tsv.tmp && \
mv mirror/doid-relation-graph.tsv.tmp mirror/doid-relation-graph.tsv && \
rm mirror/doid-relation-graph.tsv.*.tmp
ls
2022.08.10 14:30:55:858 zio-default-async-1 INFO org.renci.relationgraph.Main.program:57
    Running reasoner
2022.08.10 14:31:01:715 zio-default-async-1 INFO org.renci.relationgraph.Main.program:60
    Done running reasoner
2022.08.10 14:31:27:450 zio-default-async-4 INFO org.renci.relationgraph.Main.program:70
    Computed relations in 25.638s
beep
cp .template.db mirror/doid.db.tmp && \
rdftab mirror/doid.db.tmp < mirror/doid.owl && \
sqlite3 mirror/doid.db.tmp -cmd '.separator "\t"' ".import mirror/doid-relation-graph.tsv entailed_edge" && \
gzip mirror/doid-relation-graph.tsv && \
cat /usr/local/lib/python3.10/dist-packages/semsql/builder//indexes/*.sql | sqlite3 mirror/doid.db.tmp && \
mv mirror/doid.db.tmp mirror/doid.db

Additional information

Version: 0.1.7: Using this version because I'm not currently able to use the next highest version, 0.2.0.

I have to exit using Ctrl+D. @hrshdhgd Do you happen to have this issue? Do you know of any other way to exit the SQLite console? Also, this causes a bug if I have a chained command, where my terminal window freezes and I have to close it. For example, I'm doing semsql make mirror/doid.db; beep. The ; beep part makes a sound after running so I know it's done. But if there is a ; or an && and I use Ctrl+D to exit the console, instead of it continuing, my terminal freezes at this point.

主要语言
Python
星标
70
派生
7
平均合并
4 小时 18 分钟
30 天内合并 PR
1

环境准备

  • 提供 Dockerfile 或 Docker Compose 文件
  • 没有 Pull Request 模板
  • 阅读贡献指南

从这里开始

  1. 先读完整个 Issue，再读项目的贡献指南。
  2. 在 Issue 下留言说明你要接手 —— 这能避免两个人做同样的事。
  3. Fork 仓库，在一个分支上完成修改。
  4. 提交 Pull Request，并在描述里引用这个 Issue 编号。

INCATools/semantic-sql 的其他 Issue

查看 INCATools/semantic-sql 的全部 Issue

相似的 Issue

更多 Python Issue

把新 issue 发到你的邮箱

精选适合新手参与的 GitHub issue 摘要。