forked from pool/sqlitebrowser
3766e6f8f6
+ CSV file import and export code has been extensively modified
for better RFC compatibility
+ support for custom collation sequences. This lets people use
SQLite3 databases copied from their Android phone or tablet.
+ several fixes in our SQL grammar parser
+ Make adding new rows less confusing by showing automatically
generated data by default values, triggers or the PK right after
the new row is added
+ Edit Table dialog: Add option for adding a unique constraint to columns
+ UI improvements: Show line numbers in the SQL log
+ Add a database schema pane (can be torn off)
+ Added a Russian translation, fixed German translation
+ new Project files feature, for saving metadata about your SQLite
Database files
+ New: Plotting, a quick and dirty way to draw graphs from your
table data
+ Bi-licensed under MPLv2 and GPLv3
- use cmake now instead of old qmake
- let make install the sqlitebrowser binary
OBS-URL: https://build.opensuse.org/package/show/server:database/sqlitebrowser?expand=0&rev=7
114 lines
3.5 KiB
RPMSpec
114 lines
3.5 KiB
RPMSpec
#
|
|
# spec file for package sqlitebrowser
|
|
#
|
|
# Copyright (c) 2014 SUSE LINUX Products GmbH, Nuernberg, Germany.
|
|
#
|
|
# All modifications and additions to the file contributed by third parties
|
|
# remain the property of their copyright owners, unless otherwise agreed
|
|
# upon. The license for this file, and modifications and additions to the
|
|
# file, is the same license as for the pristine package itself (unless the
|
|
# license for the pristine package is not an Open Source License, in which
|
|
# case the license is the MIT License). An "Open Source License" is a
|
|
# license that conforms to the Open Source Definition (Version 1.9)
|
|
# published by the Open Source Initiative.
|
|
|
|
# Please submit bugfixes or comments via http://bugs.opensuse.org/
|
|
#
|
|
|
|
|
|
Name: sqlitebrowser
|
|
Version: 3.4.0
|
|
Release: 0
|
|
Summary: Create, design and edit SQLite Databases
|
|
License: GPL-3.0+ and MPL-2.0
|
|
Group: Productivity/Office/Organizers
|
|
Url: https://github.com/rp-/sqlitebrowser/
|
|
# https://github.com/rp-/sqlitebrowser/releases
|
|
Source0: sqlitebrowser-sqlitebrowser-ce41627.tar.bz2
|
|
Source1: sqlitebrowser.1
|
|
%if 0%{?suse_version}
|
|
BuildRequires: update-desktop-files
|
|
%endif
|
|
BuildRequires: autoconf
|
|
BuildRequires: automake
|
|
BuildRequires: cmake
|
|
BuildRequires: gcc
|
|
BuildRequires: gcc-c++
|
|
BuildRequires: hicolor-icon-theme
|
|
BuildRequires: libQtWebKit-devel
|
|
BuildRequires: libqt4-devel >= 4.6
|
|
BuildRequires: sqlite3-devel
|
|
BuildRequires: update-desktop-files
|
|
%if 0%{?suse_version} > 1100
|
|
BuildRequires: pkgconfig(glib-2.0)
|
|
%endif
|
|
BuildRoot: %{_tmppath}/%{name}-%{version}-build
|
|
|
|
%description
|
|
SQLite Database Browser is a freeware, public domain, open source visual tool
|
|
used to create, design and edit database files compatible with SQLite. It 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
|
|
|
|
%prep
|
|
%setup -q -n sqlitebrowser-sqlitebrowser-ce41627
|
|
|
|
%build
|
|
cmake -DCMAKE_INSTALL_PREFIX=%{_prefix} .
|
|
make %{?_smp_mflags}
|
|
|
|
%install
|
|
make DESTDIR="%{buildroot}" install
|
|
mkdir -p %{buildroot}/%{_bindir} %{buildroot}/%{_datadir}/{applications,pixmaps}
|
|
install -Dm644 %{SOURCE1} %{buildroot}/%{_mandir}/man1/%{name}.1
|
|
install -m644 images/%{name}.png %{buildroot}/%{_datadir}/pixmaps/%{name}.png
|
|
cat > %{buildroot}/%{_datadir}/applications/%{name}.desktop << EOF
|
|
[Desktop Entry]
|
|
Categories=Application;Network;GNOME;GTK;System;X-SuSE-ServiceConfiguration;
|
|
StartupNotify=true
|
|
Exec=%{_bindir}/%{name}
|
|
Name=%{name}
|
|
GenericName=SQLite Database browser
|
|
Terminal=false
|
|
Type=Application
|
|
Icon=%{name}
|
|
EOF
|
|
%if 0%{?suse_version}
|
|
%suse_update_desktop_file %{name}
|
|
%endif
|
|
|
|
%clean
|
|
rm -fr %{buildroot}
|
|
|
|
%if 0%{?suse_version} > 1130
|
|
%post
|
|
%desktop_database_post
|
|
|
|
%postun
|
|
%desktop_database_postun
|
|
%endif
|
|
|
|
%files
|
|
%defattr(-,root,root)
|
|
%doc README.md LICENSE currentrelease
|
|
%{_mandir}/man1/%{name}.1*
|
|
%{_bindir}/*
|
|
%{_datadir}/applications/*
|
|
%{_datadir}/pixmaps/*
|
|
%{_datadir}/icons/hicolor/*/apps/sqlitebrowser.png
|
|
|
|
%changelog
|