diff options
| -rw-r--r-- | .gitignore | 1 | ||||
| -rw-r--r-- | python-sqlite-utils.spec | 170 | ||||
| -rw-r--r-- | sources | 1 |
3 files changed, 172 insertions, 0 deletions
@@ -0,0 +1 @@ +/sqlite-utils-3.30.tar.gz diff --git a/python-sqlite-utils.spec b/python-sqlite-utils.spec new file mode 100644 index 0000000..98e8373 --- /dev/null +++ b/python-sqlite-utils.spec @@ -0,0 +1,170 @@ +%global _empty_manifest_terminate_build 0 +Name: python-sqlite-utils +Version: 3.30 +Release: 1 +Summary: CLI tool and Python utility functions for manipulating SQLite databases +License: Apache License, Version 2.0 +URL: https://github.com/simonw/sqlite-utils +Source0: https://mirrors.nju.edu.cn/pypi/web/packages/ba/8d/9660dc531135779a1980e670d78d1402506e02fc1aaa10556da6ecf9960c/sqlite-utils-3.30.tar.gz +BuildArch: noarch + +Requires: python3-sqlite-fts4 +Requires: python3-click +Requires: python3-click-default-group-wheel +Requires: python3-tabulate +Requires: python3-dateutil +Requires: python3-furo +Requires: python3-sphinx-autobuild +Requires: python3-codespell +Requires: python3-sphinx-copybutton +Requires: python3-beanbag-docutils +Requires: python3-flake8 +Requires: python3-mypy +Requires: python3-types-click +Requires: python3-types-tabulate +Requires: python3-types-python-dateutil +Requires: python3-data-science-types +Requires: python3-pytest +Requires: python3-black +Requires: python3-hypothesis +Requires: python3-cogapp + +%description + 1 4 Cleo + 2 2 Pancakes +You can import JSON data into a new database table like this: + $ curl https://api.github.com/repos/simonw/sqlite-utils/releases \ + | sqlite-utils insert releases.db releases - --pk id +Or for data in a CSV file: + $ sqlite-utils insert dogs.db dogs dogs.csv --csv +`sqlite-utils memory` lets you import CSV or JSON data into an in-memory database and run SQL queries against it in a single command: + $ cat dogs.csv | sqlite-utils memory - "select name, age from stdin" +See the [full CLI documentation](https://sqlite-utils.datasette.io/en/stable/cli.html) for comprehensive coverage of many more commands. +## Using as a library +You can also `import sqlite_utils` and use it as a Python library like this: +```python +import sqlite_utils +db = sqlite_utils.Database("demo_database.db") +# This line creates a "dogs" table if one does not already exist: +db["dogs"].insert_all([ + {"id": 1, "age": 4, "name": "Cleo"}, + {"id": 2, "age": 2, "name": "Pancakes"} +], pk="id") +``` +Check out the [full library documentation](https://sqlite-utils.datasette.io/en/stable/python-api.html) for everything else you can do with the Python library. +## Related projects +* [Datasette](https://datasette.io/): A tool for exploring and publishing data +* [csvs-to-sqlite](https://github.com/simonw/csvs-to-sqlite): Convert CSV files into a SQLite database +* [db-to-sqlite](https://github.com/simonw/db-to-sqlite): CLI tool for exporting a MySQL or PostgreSQL database as a SQLite file +* [dogsheep](https://dogsheep.github.io/): A family of tools for personal analytics, built on top of `sqlite-utils` + +%package -n python3-sqlite-utils +Summary: CLI tool and Python utility functions for manipulating SQLite databases +Provides: python-sqlite-utils +BuildRequires: python3-devel +BuildRequires: python3-setuptools +BuildRequires: python3-pip +%description -n python3-sqlite-utils + 1 4 Cleo + 2 2 Pancakes +You can import JSON data into a new database table like this: + $ curl https://api.github.com/repos/simonw/sqlite-utils/releases \ + | sqlite-utils insert releases.db releases - --pk id +Or for data in a CSV file: + $ sqlite-utils insert dogs.db dogs dogs.csv --csv +`sqlite-utils memory` lets you import CSV or JSON data into an in-memory database and run SQL queries against it in a single command: + $ cat dogs.csv | sqlite-utils memory - "select name, age from stdin" +See the [full CLI documentation](https://sqlite-utils.datasette.io/en/stable/cli.html) for comprehensive coverage of many more commands. +## Using as a library +You can also `import sqlite_utils` and use it as a Python library like this: +```python +import sqlite_utils +db = sqlite_utils.Database("demo_database.db") +# This line creates a "dogs" table if one does not already exist: +db["dogs"].insert_all([ + {"id": 1, "age": 4, "name": "Cleo"}, + {"id": 2, "age": 2, "name": "Pancakes"} +], pk="id") +``` +Check out the [full library documentation](https://sqlite-utils.datasette.io/en/stable/python-api.html) for everything else you can do with the Python library. +## Related projects +* [Datasette](https://datasette.io/): A tool for exploring and publishing data +* [csvs-to-sqlite](https://github.com/simonw/csvs-to-sqlite): Convert CSV files into a SQLite database +* [db-to-sqlite](https://github.com/simonw/db-to-sqlite): CLI tool for exporting a MySQL or PostgreSQL database as a SQLite file +* [dogsheep](https://dogsheep.github.io/): A family of tools for personal analytics, built on top of `sqlite-utils` + +%package help +Summary: Development documents and examples for sqlite-utils +Provides: python3-sqlite-utils-doc +%description help + 1 4 Cleo + 2 2 Pancakes +You can import JSON data into a new database table like this: + $ curl https://api.github.com/repos/simonw/sqlite-utils/releases \ + | sqlite-utils insert releases.db releases - --pk id +Or for data in a CSV file: + $ sqlite-utils insert dogs.db dogs dogs.csv --csv +`sqlite-utils memory` lets you import CSV or JSON data into an in-memory database and run SQL queries against it in a single command: + $ cat dogs.csv | sqlite-utils memory - "select name, age from stdin" +See the [full CLI documentation](https://sqlite-utils.datasette.io/en/stable/cli.html) for comprehensive coverage of many more commands. +## Using as a library +You can also `import sqlite_utils` and use it as a Python library like this: +```python +import sqlite_utils +db = sqlite_utils.Database("demo_database.db") +# This line creates a "dogs" table if one does not already exist: +db["dogs"].insert_all([ + {"id": 1, "age": 4, "name": "Cleo"}, + {"id": 2, "age": 2, "name": "Pancakes"} +], pk="id") +``` +Check out the [full library documentation](https://sqlite-utils.datasette.io/en/stable/python-api.html) for everything else you can do with the Python library. +## Related projects +* [Datasette](https://datasette.io/): A tool for exploring and publishing data +* [csvs-to-sqlite](https://github.com/simonw/csvs-to-sqlite): Convert CSV files into a SQLite database +* [db-to-sqlite](https://github.com/simonw/db-to-sqlite): CLI tool for exporting a MySQL or PostgreSQL database as a SQLite file +* [dogsheep](https://dogsheep.github.io/): A family of tools for personal analytics, built on top of `sqlite-utils` + +%prep +%autosetup -n sqlite-utils-3.30 + +%build +%py3_build + +%install +%py3_install +install -d -m755 %{buildroot}/%{_pkgdocdir} +if [ -d doc ]; then cp -arf doc %{buildroot}/%{_pkgdocdir}; fi +if [ -d docs ]; then cp -arf docs %{buildroot}/%{_pkgdocdir}; fi +if [ -d example ]; then cp -arf example %{buildroot}/%{_pkgdocdir}; fi +if [ -d examples ]; then cp -arf examples %{buildroot}/%{_pkgdocdir}; fi +pushd %{buildroot} +if [ -d usr/lib ]; then + find usr/lib -type f -printf "/%h/%f\n" >> filelist.lst +fi +if [ -d usr/lib64 ]; then + find usr/lib64 -type f -printf "/%h/%f\n" >> filelist.lst +fi +if [ -d usr/bin ]; then + find usr/bin -type f -printf "/%h/%f\n" >> filelist.lst +fi +if [ -d usr/sbin ]; then + find usr/sbin -type f -printf "/%h/%f\n" >> filelist.lst +fi +touch doclist.lst +if [ -d usr/share/man ]; then + find usr/share/man -type f -printf "/%h/%f.gz\n" >> doclist.lst +fi +popd +mv %{buildroot}/filelist.lst . +mv %{buildroot}/doclist.lst . + +%files -n python3-sqlite-utils -f filelist.lst +%dir %{python3_sitelib}/* + +%files help -f doclist.lst +%{_docdir}/* + +%changelog +* Mon Apr 10 2023 Python_Bot <Python_Bot@openeuler.org> - 3.30-1 +- Package Spec generated @@ -0,0 +1 @@ +52664b3f9b763524f5b36a9df5ded8ef sqlite-utils-3.30.tar.gz |