xlsxtomysql

LOW

maintainer sinbud2004 0 votes scanned 2026-09-29 09:23:18.383364

View on AUR

Why flagged

Uploaded within the last 14 days with 2 or fewer community votes — little peer review so far.

Triggered rules

Low Few votes, recently uploaded zero_votes_recent

Uploaded within the last 14 days with 2 or fewer community votes — little peer review so far.

PKGBUILD

      1# Maintainer: sinbud2004 <sinbud2004@gmail.com>
    
      2pkgname=xlsxtomysql
    
      3pkgver=2.2.0
    
      4pkgrel=1
    
      5pkgdesc="Excel to MySQL: convert .xlsx/.xls spreadsheets into CREATE TABLE + INSERT statements (zero-dependency single-file Rust CLI)"
    
      6arch=('x86_64' 'aarch64')
    
      7url="https://github.com/Paul-sinbud2004/xlsxtomysql"
    
      8license=('MIT')
    
      9depends=('python' 'python-openpyxl')
    
      10optdepends=('python-xlrd: read Excel 2003 (.xls) spreadsheets')
    
      11makedepends=('rust')
    
      12source=("$pkgname-$pkgver.tar.gz::$url/releases/download/v$pkgver/$pkgname-$pkgver-src.tar.gz")
    
      13sha256sums=('8b59e1aa1257a54201f14837e1c8eeabfd57456210bd4073f8a7d8c545a34018')
    
      14
    
      15build() {
    
      16    cd "$pkgname-$pkgver"
    
      17
    
      18    # 单文件实现：一句 rustc 即可，不需要 cargo、没有任何 crate 依赖。
    
      19    # 参数与上游 build.sh --release 保持一致；RUSTFLAGS 放最后，尊重打包环境。
    
      20    rustc --edition 2021 \
    
      21          -C opt-level=3 -C lto -C codegen-units=1 -C strip=symbols \
    
      22          ${RUSTFLAGS:-} \
    
      23          xlsxtomysql.rs -o xlsxtomysql
    
      24}
    
      25
    
      26check() {
    
      27    cd "$pkgname-$pkgver"
    
      28
    
      29    ./xlsxtomysql --version
    
      30    ./xlsxtomysql --help  >/dev/null
    
      31    ./xlsxtomysql --man   >/dev/null
    
      32    ./xlsxtomysql --lang en --help >/dev/null
    
      33
    
      34    # 英文模式不应残留中文
    
      35    if ./xlsxtomysql --lang en --help | grep -qP '[\x{4e00}-\x{9fff}]'; then
    
      36        echo "error: English --help still contains CJK characters" >&2
    
      37        return 1
    
      38    fi
    
      39
    
      40    # 真实转换：仓库自带一张示例表（文本日期 / 手机号 / 百分比）
    
      41    ./xlsxtomysql examples/students.xlsx 学生信息 students 1 2 --lang en \
    
      42        --out "$srcdir/check.sql" --progress off --no-color >/dev/null
    
      43
    
      44    grep -q 'CREATE TABLE IF NOT EXISTS `students`' "$srcdir/check.sql"
    
      45    grep -q '`手机号` varchar(32)'  "$srcdir/check.sql"
    
      46    grep -q '`出生日期` date'       "$srcdir/check.sql"
    
      47}
    
      48
    
      49package() {
    
      50    cd "$pkgname-$pkgver"
    
      51
    
      52    install -Dm755 xlsxtomysql "$pkgdir/usr/bin/xlsxtomysql"
    
      53
    
      54    install -Dm644 docs/xlsxtomysql.1    "$pkgdir/usr/share/man/man1/xlsxtomysql.1"
    
      55    install -Dm644 docs/xlsxtomysql.zh.1 "$pkgdir/usr/share/man/zh_CN/man1/xlsxtomysql.1"
    
      56
    
      57    install -Dm644 LICENSE "$pkgdir/usr/share/licenses/$pkgname/LICENSE"
    
      58}
    
      59

Scan history

Scanned at (UTC)	Severity	Rules
2026-09-29 09:23:18	Low	1