dotnet-soddi 0.3.2

DotNet-Soddi (Stack Overflow 数据转储导入器)

安装

dotnet tool install --global dotnet-soddi --version 0.2.1

受到原始 Soddi 的启发，DotNet-Soddi 是一个控制台应用程序，它不仅帮助导入 Stack Overflow 数据转储，还可以获取它们。

功能

• 从命令行发现存档。
• 从 xml 文件导入数据或直接从 .7z 存档文件中导入。
• 基于站点名称通过 HTTP 从命令行下载存档文件。
• 基于站点名称通过 BitTorrent 下载存档文件。

限制

不是所有 Soddi 的功能都受支持。

• 它仅适用于 SQL Server。
• 全文不兼容。

在两行中下载并安装数据库

以下命令将下载 math.stackexchange.com 的存档，然后将其导入名为 math.stackexchange.com 的现有数据库中

soddi download math
soddi import math -d math.stackexchange.com

由于数据库大小和 archive.org 的带宽，你可能最好使用 torrent 选项。以下命令将执行连接到适当的追踪器和节点以下载数学数据库并完成后退出的所有操作。

soddi torrent math

使用方法

soddi download

通过 HTTP 从 archive.org 下载 Stack Overflow 网站存档。

USAGE:

download archive for aviation.stackexchange.com:
  soddi download aviation
download archive for math.stackexchange.com to a particular folder:
  soddi download --output c:\stack-data math
pick from archives containing stack and download:
  soddi download --pick stack

  -o, --output        Output folder
  -p, --pick          (Default: false) Pick from a list of archives to download
  --help              Display this help screen.
  --version           Display version information.
  Archive (pos. 0)    Required. Archive to download

soddi list

列出可用的 Stack Overflow 数据转储。

USAGE:

List all archives:
  soddi list
List all archives containing the letters "av":
  soddi list av
List all archives containing the letters "av" including meta sites:
  soddi list --includeMeta av

  --includeMeta       (Default: false) Include meta databases.
  --help              Display this help screen.
  --version           Display version information.
  Pattern (pos. 0)    (Default: ) Pattern to include (e.g. "av" includes all archives containing "av").

soddi import

从 7z 存档或文件夹导入数据。

USAGE:

Import data using defaults:
  soddi import math.stackexchange.com.7z
Import data from a folder containing a collection of .7z or .xml files:
  soddi import stackoverflow
Import data using a connection string and database name:
  soddi import --connectionString "Server=(local)\Sql2017;User Id=admin;password=t3ddy" --database math
  math.stackexchange.com.7z
Import data using defaults and create database:
  soddi import --dropAndCreate math.stackexchange.com.7z
Import data using defaults without constraints:
  soddi import --skipConstraints math.stackexchange.com.7z

  -d, --database            Name of database. If omitted the name of the file or folder will be used.
  -c, --connectionString    (Default: Server=.;Integrated Security=true) Connection string to server. Initial catalog
                            will be ignored and the database parameter will be used for the database name.
  --dropAndCreate           (Default: false) Drop and recreate database. If a database already exists with this name it
                            will be dropped. Then a database will be created in the default server file location with
                            the default server options.
  --skipConstraints         (Default: false) Skip adding primary keys and unique constraints.
  --skipTags                (Default: false) Skip adding PostTags table.
  --help                    Display this help screen.
  --version                 Display version information.
  Path (pos. 0)             Required. File or folder containing xml archives. The file must be a .7z file. If using a
                            folder it can contain either .7z or .xml content

soddi torrent

通过 BitTorrent 下载数据库。对于大型数据库，这可能会显著更快。

USAGE:

Download files associated with the math site from the torrent file:
  soddi torrent math
Download to a specific folder:
  soddi torrent --output "c:\torrent files" math
Enable port forwarding:
  soddi torrent --portForward math
Pick from archives containing "stack":
  soddi torrent --pick stack

  -o, --output         Output folder
  -f, --portForward    (Default: false) Experimental. Enable port forwarding
  -p, --pick           (Default: false) Pick from a list of archives to download
  --help               Display this help screen.
  --version            Display version information.
  Archive (pos. 0)     Required. Archive to download

soddi brent

超实验性的。通过 BitTorrent 下载并解压 BrentO 提供的数据库 之一。

如果你不提供 ARCHIVE_NAME，系统将提示你输入一个。

USAGE:
    soddi brent [ARCHIVE_NAME] [OPTIONS]

EXAMPLES:
    soddi brent
    soddi brent small
    soddi brent medium
    soddi brent large
    soddi brent extra-large

ARGUMENTS:
    [ARCHIVE_NAME]    Archive to download

OPTIONS:
    -h, --help              Prints help information
    -o, --output            Output folder
        --skipExtraction    Don't extract the downloaded 7z files
    -f, --portForward       Experimental. Enable port forwarding