synle / sqlui-native

SQLUI Native (sqluinative) is a simple UI client for most SQL Engines written in Electron. It is compatible with Windows, Mac, Ubuntu / Debian and Redhat. It supports most dialects of RMBDs like MySQL, Microsoft SQL Server, Postgres, SQLite and has limited supports for Cassandra, MongoDB, Redis, CockroachDB, Azure CosmosDB and Azure Storage Tab
https://synle.github.io/sqlui-native/
MIT License
59 stars 8 forks source link

Create a windows app store distribution #618

Closed synle closed 2 years ago

synle commented 2 years ago

https://github.com/felixrieseberg/electron-windows-store

https://www.electronjs.org/docs/latest/tutorial/windows-store-guide

https://www.electron.build/configuration/appx.html

synle commented 2 years ago
yarn run v1.22.19
$ cpx "build/**/*" .
$ electron-builder build --publish=never -w appx
  • electron-builder  version=23.3.3 os=10.0.22000
  • loaded configuration  file=package.json ("build" field)
  • writing effective config  file=dist\builder-effective-config.yaml
  • rebuilding native dependencies  dependencies=sqlite3@5.0.11 platform=win32 arch=x64
  • rebuilding native dependency  name=sqlite3 version=5.0.11
  • packaging       platform=win32 arch=x64 electron=19.0.10 appOutDir=dist\win-unpacked
  • building        target=AppX arch=x64 file=dist\sqlui-native 1.61.6.appx
  • AppX is not signed  reason=Windows Store only build
  ⨯ Exit code: 1. Command failed: C:\Users\lengu\AppData\Local\electron-builder\Cache\winCodeSign\winCodeSign-2.6.0\windows-10\x64\makeappx.exe pack /o /f D:\git\sqlui-native\dist\__appx-x64\mapping.txt /p bf15e8eec8a7960e7d0cb60fe2d13b47ebac2443ae8f2339915d2f78b3c7aba9 (sha256 hash) 1.61.6.appx

Microsoft (R) MakeAppx Tool
Copyright (C) 2013 Microsoft.  All rights reserved.

The path (/p) parameter is: "\\?\D:\git\sqlui-native\dist\sqlui-native 1.61.6.appx"
The mapping file (/f) parameter is: "D:\git\sqlui-native\dist\__appx-x64\mapping.txt"
Reading mapping file "D:\git\sqlui-native\dist\__appx-x64\mapping.txt"
Packing 77 file(s) listed in "D:\git\sqlui-native\dist\__appx-x64\mapping.txt" (mapping file) to "\\?\D:\git\sqlui-native\dist\sqlui-native 1.61.6.appx" (output file name).
Memory limit defaulting to 21163118592 bytes.
Using "D:\git\sqlui-native\dist\__appx-x64\AppxManifest.xml" as the manifest for the package.
MakeAppx : error: Error info: /*[local-name()="Package" and namespace-uri()="http://schemas.microsoft.com/appx/manifest/foundation/windows10"]/*[local-name()="Applications" and namespace-uri()="http://schemas.microsoft.com/appx/manifest/foundation/windows10"][1]/*[local-name()="Application" and namespace-uri()="http://schemas.microsoft.com/appx/manifest/foundation/windows10"][1]/@Id
'sqlui-native' violates pattern constraint of '([A-Za-z][A-Za-z0-9]*)(\.[A-Za-z][A-Za-z0-9]*)*'.
The attribute 'Id' with value 'sqlui-native' failed to parse.
MakeAppx : error: Package creation failed.
MakeAppx : error: 0x80080204 - The specified package format is not valid: The package manifest is not valid.
  failedTask=build stackTrace=Error: Exit code: 1. Command failed: C:\Users\lengu\AppData\Local\electron-builder\Cache\winCodeSign\winCodeSign-2.6.0\windows-10\x64\makeappx.exe pack /o /f D:\git\sqlui-native\dist\__appx-x64\mapping.txt /p bf15e8eec8a7960e7d0cb60fe2d13b47ebac2443ae8f2339915d2f78b3c7aba9 (sha256 hash) 1.61.6.appx

Microsoft (R) MakeAppx Tool
Copyright (C) 2013 Microsoft.  All rights reserved.

The path (/p) parameter is: "\\?\D:\git\sqlui-native\dist\sqlui-native 1.61.6.appx"
The mapping file (/f) parameter is: "D:\git\sqlui-native\dist\__appx-x64\mapping.txt"
Reading mapping file "D:\git\sqlui-native\dist\__appx-x64\mapping.txt"
Packing 77 file(s) listed in "D:\git\sqlui-native\dist\__appx-x64\mapping.txt" (mapping file) to "\\?\D:\git\sqlui-native\dist\sqlui-native 1.61.6.appx" (output file name).
Memory limit defaulting to 21163118592 bytes.
Using "D:\git\sqlui-native\dist\__appx-x64\AppxManifest.xml" as the manifest for the package.
MakeAppx : error: Error info: /*[local-name()="Package" and namespace-uri()="http://schemas.microsoft.com/appx/manifest/foundation/windows10"]/*[local-name()="Applications" and namespace-uri()="http://schemas.microsoft.com/appx/manifest/foundation/windows10"][1]/*[local-name()="Application" and namespace-uri()="http://schemas.microsoft.com/appx/manifest/foundation/windows10"][1]/@Id
'sqlui-native' violates pattern constraint of '([A-Za-z][A-Za-z0-9]*)(\.[A-Za-z][A-Za-z0-9]*)*'.
The attribute 'Id' with value 'sqlui-native' failed to parse.
MakeAppx : error: Package creation failed.
MakeAppx : error: 0x80080204 - The specified package format is not valid: The package manifest is not valid.

    at D:\git\sqlui-native\node_modules\builder-util\src\util.ts:133:18
    at ChildProcess.exithandler (node:child_process:406:5)
    at ChildProcess.emit (node:events:520:28)
    at maybeClose (node:internal/child_process:1092:16)
    at Process.ChildProcess._handle.onexit (node:internal/child_process:302:5)