FilesExpand file tree

master

/

build-appimage.yml

Copy path

View runs

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

88 lines (76 loc) · 4.24 KB

master

/

build-appimage.yml

Copy path

Top

File metadata and controls

• Code
• Blame

88 lines (76 loc) · 4.24 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

# KEEP THE RUNNER OS AS LOW AS POSSIBLE.

# If built on the latest OS, it may not run on previous OS versions.

# Related: https://docs.appimage.org/reference/best-practices.html#binaries-compiled-on-old-enough-base-system

name: Build - AppImage

on:

workflow_call:

inputs:

NIGHTLY:

default: false

type: boolean

jobs:

build:

name: ${{ matrix.os }} - SQLCipher ${{ matrix.sqlcipher }}

runs-on: ${{ matrix.os }}

strategy:

fail-fast: false

matrix:

os: [ubuntu-20.04]

sqlcipher: ["0", "1"]

steps:

- name: Checkout

uses: actions/checkout@v4

- name: Install dependencies

run: |

sudo apt update

sudo apt install libqcustomplot-dev libqscintilla2-qt5-dev libqt5svg5 qttools5-dev

- if: matrix.sqlcipher == 0

name: Build SQLite

run: |

TARBALL=$(curl -s https://sqlite.org/download.html | awk '/<!--/,/-->/ {print}' | grep 'sqlite-autoconf' | cut -d ',' -f 3)

SHA3=$(curl -s https://sqlite.org/download.html | awk '/<!--/,/-->/ {print}' | grep 'sqlite-autoconf' | cut -d ',' -f 5)

curl -LsS -o sqlite.tar.gz https://sqlite.org/${TARBALL}

VERIFY=$(openssl dgst -sha3-256 sqlite.tar.gz | cut -d ' ' -f 2)

if [ "$SHA3" != "$VERIFY" ]; then exit 1 ; fi

tar -xzf sqlite.tar.gz && cd sqlite-autoconf-*

CPPFLAGS="-DSQLITE_ENABLE_COLUMN_METADATA=1 -DSQLITE_MAX_VARIABLE_NUMBER=250000 -DSQLITE_ENABLE_RTREE=1 -DSQLITE_ENABLE_GEOPOLY=1 -DSQLITE_ENABLE_FTS3=1 -DSQLITE_ENABLE_FTS3_PARENTHESIS=1 -DSQLITE_ENABLE_FTS5=1 -DSQLITE_ENABLE_STAT4=1 -DSQLITE_ENABLE_JSON1=1 -DSQLITE_SOUNDEX=1 -DSQLITE_ENABLE_MATH_FUNCTIONS=1 -DSQLITE_MAX_ATTACHED=125 -DSQLITE_ENABLE_MEMORY_MANAGEMENT=1 -DSQLITE_ENABLE_SNAPSHOT=1" ./configure --enable-shared=no

make -j2 && sudo make install -j2

- if: matrix.sqlcipher == 1

name: Build SQLCipher

run: |

sudo apt install libssl-dev tcl

git clone https://github.com/sqlcipher/sqlcipher && cd sqlcipher && git checkout v4.6.1

./configure --enable-tempstore=yes --with-crypto-lib=openssl --enable-load-extension --disable-tcl CFLAGS="-DSQLCIPHER_CRYPTO_OPENSSL -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_GEOPOLY -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_MEMORY_MANAGEMENT=1 -DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_SNAPSHOT=1 -DSQLITE_ENABLE_STAT4 -DSQLITE_HAS_CODEC -DSQLITE_SOUNDEX"

make -j2 && sudo make install -j2

- name: Configure build

run: |

mkdir appbuild && mkdir appdir && cd appbuild

cmake -DCMAKE_BUILD_TYPE=Release -DCMAKE_INSTALL_PREFIX:PATH=../appdir/usr -Wno-dev -DFORCE_INTERNAL_QSCINTILLA=ON -Dsqlcipher=${{ matrix.sqlcipher }} ..

- name: Build

working-directory: ./appbuild

run: make install -j2

- name: Build AppImage

run: |

wget -c -nv "https://github.com/linuxdeploy/linuxdeploy/releases/download/1-alpha-20240109-1/linuxdeploy-x86_64.AppImage"

wget -c -nv "https://github.com/linuxdeploy/linuxdeploy-plugin-qt/releases/download/1-alpha-20240109-1/linuxdeploy-plugin-qt-x86_64.AppImage"

chmod a+x linuxdeploy-x86_64.AppImage linuxdeploy-plugin-qt-x86_64.AppImage

if [ "${{ inputs.NIGHTLY }}" = "true" ]; then

export VERSION=$(date +%Y%m%d)

else

export VERSION=$(printf "dev-`git -C . rev-parse --short HEAD`")

fi

LD_LIBRARY_PATH="$LD_LIBRARY_PATH:/usr/local/lib" ./linuxdeploy-x86_64.AppImage --appdir=appdir --desktop-file=appdir/usr/share/applications/sqlitebrowser.desktop --plugin qt --output appimage

- name: Rename a file

run: |

for i in DB_Browser_for_SQLite*; do mv "$i" "${i//_/.}"; done

if [ "${{ matrix.sqlcipher }}" = "1" ]; then

export FILE=$(ls DB.Browser.for.SQLite*.AppImage)

export FILE=${FILE/SQLite/SQLCipher}

mv DB.Browser.for.SQLite*.AppImage $FILE

fi

- name: Upload artifacts

uses: actions/upload-artifact@v4

with:

name: build-artifacts-${{ matrix.os }}-${{ matrix.sqlcipher }}

path: DB.Browser.for.*.AppImage

retention-days: 1