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
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
|
name: sqlitebrowser # the name of the snap
version: master
base: core20
version-script: printf "`cat currentrelease | head -n 1 `-`git rev-list master --count`-` git -C . rev-parse --short HEAD`"
summary: DB Browser for SQLite # 79 char long summary
description: |
SQLite Database Browser is a visual tool used to create, design and edit database files compatible with SQLite. Its interface is based on Qt, and is meant to be used for users and developers that want to create databases, edit and search data using a familiar spreadsheet-like interface, without the need to learn complicated SQL commands. Controls and wizards are available for users to:
* Create and compact database files
* Create, define, modify and delete tables
* Create, define and delete indexes
* Browse, edit, add and delete records
* Search records
* Import and export records as text
* Import and export tables from/to CSV files
* Import and export databases from/to SQL dump files
* Issue SQL queries and inspect the results
* Examine a log of all SQL commands issued by the application
SQLite Database Browser is not a visual shell for the sqlite command line tool. It does not require familiarity with SQL commands.
confinement: strict # use "strict" to enforce system access only via declared interfaces
grade: stable
icon: images/logo.svg
type: app
plugs:
gtk-3-themes:
interface: content
target: $SNAP/data-dir/themes
default-provider: gtk-common-themes:gtk-3-themes
sound-themes:
interface: content
target: $SNAP/data-dir/sounds
default-provider: gtk-common-themes:sound-themes
icon-themes:
interface: content
target: $SNAP/data-dir/icons
default-provider: gtk-common-themes:icon-themes
apps:
sqlitebrowser:
command: usr/local/bin/sqlitebrowser
command-chain:
- bin/desktop-launch
- usr/local/bin/sqlitebrowser
desktop: usr/local/share/applications/sqlitebrowser.desktop
environment:
DISABLE_WAYLAND: 1
TMPDIR: $XDG_RUNTIME_DIR
XLOCALEDIR: '$SNAP/usr/share/X11/locale'
LOCPATH: '$SNAP/usr/lib/locale'
GTK_PATH: $SNAP/lib/gtk-2.0
GTK_DATA_PREFIX: $SNAP
XDG_DATA_DIRS: $SNAP/share:$XDG_DATA_DIRS
XDG_CONFIG_HOME: '$HOME/.config'
XKB_CONFIG_ROOT: '$SNAP/usr/share/X11/xkb'
XDG_CONFIG_DIRS: '$SNAP/etc/xdg:$XDG_CONFIG_DIRS'
XDG_DATA_HOME: '$SNAP/usr/share'
QT_QPA_PLATFORMTHEME: qt5ct
plugs:
- desktop
- gsettings
- home
- unity7
- wayland
- x11
- removable-media
- cups-control
build-packages:
- build-essential
- g++
- qtbase5-dev
- qttools5-dev
- qttools5-dev-tools
- libsqlite3-dev
- cmake
- libsqlcipher-dev
- libqcustomplot-dev
- libqt5scintilla2-dev
- git
parts:
sqlitebrowser:
plugin: cmake
cmake-parameters: ["-DUSE_QT5=True", "-Dsqlcipher=1", "-Wno-dev","-DSQLITE_ENABLE_JSON1=1"]
source: .
desktop-qt5:
build-packages:
- qtbase5-dev
- dpkg-dev
- libgtk-3-dev
make-parameters:
- FLAVOR=qt5
plugin: make
source: https://github.com/ubuntu/snapcraft-desktop-helpers.git
source-subdir: qt
stage-packages:
- libxkbcommon0
- ttf-ubuntu-font-family
- dmz-cursor-theme
- light-themes
- adwaita-icon-theme
- gnome-themes-standard
- shared-mime-info
- libgtk-3-0
- libqt5gui5
- libgdk-pixbuf2.0-0
- libqt5svg5
- libglib2.0-bin
- libgtk-3-bin
- unity-gtk3-module
- libappindicator3-1
- locales-all
- xdg-user-dirs
- ibus-gtk3
- libibus-1.0-5
- libgtk2.0-0
- qt5-image-formats-plugins
dump:
source: .
plugin: dump
after:
- desktop-qt5
- sqlitebrowser
stage-packages:
- libc6
- libgcc1
- libsqlite3-0
- libstdc++6
- libsqlcipher-dev
- libatk-adaptor
- libgail-common
- libgail-3-0
- libgail-3-dev
- libgail-dev
- qtwayland5
- libqscintilla2-qt5-15
- libqt5printsupport5
- libqt5xml5
- libsqlcipher0
- libgtk-3-0
filesets:
wanted:
- bin/*
- share/*
- usr/lib/*.*
- usr/lib/*-linux-gnu*/libsqlcipher.so.0*
- usr/lib/*-linux-gnu*/libdb*
- usr/lib/*-linux-gnu*/libz.so*
- usr/lib/*-linux-gnu*/libatk*
- usr/lib/*-linux-gnu*/libgail*
- usr/lib/*-linux-gnu*/gtk-2.0/modules/*
- etc/X11/Xsession.d/90atk-adaptor
- usr/lib/gnome-settings-daemon-3.0/gtk-modules/at-spi2-atk.desktop
- usr/lib/unity-settings-daemon-1.0/gtk-modules/at-spi2-atk.desktop
- usr/lib/*-linux-gnu*/libQt5PrintSupport.so*
- usr/lib/*-linux-gnu*/libQt5Xml.so*
prime:
- $wanted
|
