%global _empty_manifest_terminate_build 0 Name: python-piccolo Version: 0.109.0 Release: 1 Summary: A fast, user friendly ORM and query builder which supports asyncio. License: MIT URL: https://github.com/piccolo-orm/piccolo Source0: https://mirrors.nju.edu.cn/pypi/web/packages/7c/b3/e5c25d817d7d5b00c6ad4a9a129c12f697cbb55ddc800b8d8d161204eb9a/piccolo-0.109.0.tar.gz BuildArch: noarch Requires: python3-black Requires: python3-colorama Requires: python3-Jinja2 Requires: python3-targ Requires: python3-inflection Requires: python3-typing-extensions Requires: python3-pydantic[email] Requires: python3-orjson Requires: python3-ipython Requires: python3-asyncpg Requires: python3-aiosqlite Requires: python3-uvloop Requires: python3-orjson Requires: python3-ipython Requires: python3-asyncpg Requires: python3-aiosqlite Requires: python3-uvloop %description ![Logo](https://raw.githubusercontent.com/piccolo-orm/piccolo/master/docs/logo_hero.png "Piccolo Logo") ![Tests](https://github.com/piccolo-orm/piccolo/actions/workflows/tests.yaml/badge.svg) ![Release](https://github.com/piccolo-orm/piccolo/actions/workflows/release.yaml/badge.svg) [![Documentation Status](https://readthedocs.org/projects/piccolo-orm/badge/?version=latest)](https://piccolo-orm.readthedocs.io/en/latest/?badge=latest) [![PyPI](https://img.shields.io/pypi/v/piccolo?color=%2334D058&label=pypi)](https://pypi.org/project/piccolo/) [![codecov](https://codecov.io/gh/piccolo-orm/piccolo/branch/master/graph/badge.svg?token=V19CWH7MXX)](https://codecov.io/gh/piccolo-orm/piccolo) Piccolo is a fast, user friendly ORM and query builder which supports asyncio. [Read the docs](https://piccolo-orm.readthedocs.io/en/latest/). ## Features Some of it’s stand out features are: - Support for sync and async. - A builtin playground, which makes learning a breeze. - Tab completion support - works great with iPython and VSCode. - Batteries included - a User model, authentication, migrations, an [admin GUI](https://github.com/piccolo-orm/piccolo_admin), and more. - Modern Python - fully type annotated. - Make your codebase modular and scalable with Piccolo apps (similar to Django apps). ## Syntax The syntax is clean and expressive. You can use it as a query builder: ```python # Select: await Band.select( Band.name ).where( Band.popularity > 100 ) # Join: await Band.select( Band.name, Band.manager.name ) # Delete: await Band.delete().where( Band.popularity < 1000 ) # Update: await Band.update({Band.popularity: 10000}).where( Band.name == 'Pythonistas' ) ``` Or like a typical ORM: ```python # To create a new object: b = Band(name='C-Sharps', popularity=100) await b.save() # To fetch an object from the database, and update it: b = await Band.objects().get(Band.name == 'Pythonistas') b.popularity = 10000 await b.save() # To delete: await b.remove() ``` ## Installation Installing with PostgreSQL driver: ```bash pip install 'piccolo[postgres]' ``` Installing with SQLite driver: ```bash pip install 'piccolo[sqlite]' ``` Installing with all optional dependencies (easiest): ```bash pip install 'piccolo[all]' ``` ## Building a web app? Let Piccolo scaffold you an ASGI web app, using Piccolo as the ORM: ```bash piccolo asgi new ``` [Starlette](https://www.starlette.io/), [FastAPI](https://fastapi.tiangolo.com/), [BlackSheep](https://www.neoteroi.dev/blacksheep/), [Xpresso](https://xpresso-api.dev/) and [Starlite](https://starlite-api.github.io/starlite/) are currently supported. ## Are you a Django user? We have a handy page which shows the equivalent of [common Django queries in Piccolo](https://piccolo-orm.readthedocs.io/en/latest/piccolo/query_types/django_comparison.html). ## Documentation Our documentation is on [Read the docs](https://piccolo-orm.readthedocs.io/en/latest/piccolo/getting_started/index.html). We also have some great [tutorial videos on YouTube](https://www.youtube.com/channel/UCE7x5nm1Iy9KDfXPNrNQ5lA). %package -n python3-piccolo Summary: A fast, user friendly ORM and query builder which supports asyncio. Provides: python-piccolo BuildRequires: python3-devel BuildRequires: python3-setuptools BuildRequires: python3-pip %description -n python3-piccolo ![Logo](https://raw.githubusercontent.com/piccolo-orm/piccolo/master/docs/logo_hero.png "Piccolo Logo") ![Tests](https://github.com/piccolo-orm/piccolo/actions/workflows/tests.yaml/badge.svg) ![Release](https://github.com/piccolo-orm/piccolo/actions/workflows/release.yaml/badge.svg) [![Documentation Status](https://readthedocs.org/projects/piccolo-orm/badge/?version=latest)](https://piccolo-orm.readthedocs.io/en/latest/?badge=latest) [![PyPI](https://img.shields.io/pypi/v/piccolo?color=%2334D058&label=pypi)](https://pypi.org/project/piccolo/) [![codecov](https://codecov.io/gh/piccolo-orm/piccolo/branch/master/graph/badge.svg?token=V19CWH7MXX)](https://codecov.io/gh/piccolo-orm/piccolo) Piccolo is a fast, user friendly ORM and query builder which supports asyncio. [Read the docs](https://piccolo-orm.readthedocs.io/en/latest/). ## Features Some of it’s stand out features are: - Support for sync and async. - A builtin playground, which makes learning a breeze. - Tab completion support - works great with iPython and VSCode. - Batteries included - a User model, authentication, migrations, an [admin GUI](https://github.com/piccolo-orm/piccolo_admin), and more. - Modern Python - fully type annotated. - Make your codebase modular and scalable with Piccolo apps (similar to Django apps). ## Syntax The syntax is clean and expressive. You can use it as a query builder: ```python # Select: await Band.select( Band.name ).where( Band.popularity > 100 ) # Join: await Band.select( Band.name, Band.manager.name ) # Delete: await Band.delete().where( Band.popularity < 1000 ) # Update: await Band.update({Band.popularity: 10000}).where( Band.name == 'Pythonistas' ) ``` Or like a typical ORM: ```python # To create a new object: b = Band(name='C-Sharps', popularity=100) await b.save() # To fetch an object from the database, and update it: b = await Band.objects().get(Band.name == 'Pythonistas') b.popularity = 10000 await b.save() # To delete: await b.remove() ``` ## Installation Installing with PostgreSQL driver: ```bash pip install 'piccolo[postgres]' ``` Installing with SQLite driver: ```bash pip install 'piccolo[sqlite]' ``` Installing with all optional dependencies (easiest): ```bash pip install 'piccolo[all]' ``` ## Building a web app? Let Piccolo scaffold you an ASGI web app, using Piccolo as the ORM: ```bash piccolo asgi new ``` [Starlette](https://www.starlette.io/), [FastAPI](https://fastapi.tiangolo.com/), [BlackSheep](https://www.neoteroi.dev/blacksheep/), [Xpresso](https://xpresso-api.dev/) and [Starlite](https://starlite-api.github.io/starlite/) are currently supported. ## Are you a Django user? We have a handy page which shows the equivalent of [common Django queries in Piccolo](https://piccolo-orm.readthedocs.io/en/latest/piccolo/query_types/django_comparison.html). ## Documentation Our documentation is on [Read the docs](https://piccolo-orm.readthedocs.io/en/latest/piccolo/getting_started/index.html). We also have some great [tutorial videos on YouTube](https://www.youtube.com/channel/UCE7x5nm1Iy9KDfXPNrNQ5lA). %package help Summary: Development documents and examples for piccolo Provides: python3-piccolo-doc %description help ![Logo](https://raw.githubusercontent.com/piccolo-orm/piccolo/master/docs/logo_hero.png "Piccolo Logo") ![Tests](https://github.com/piccolo-orm/piccolo/actions/workflows/tests.yaml/badge.svg) ![Release](https://github.com/piccolo-orm/piccolo/actions/workflows/release.yaml/badge.svg) [![Documentation Status](https://readthedocs.org/projects/piccolo-orm/badge/?version=latest)](https://piccolo-orm.readthedocs.io/en/latest/?badge=latest) [![PyPI](https://img.shields.io/pypi/v/piccolo?color=%2334D058&label=pypi)](https://pypi.org/project/piccolo/) [![codecov](https://codecov.io/gh/piccolo-orm/piccolo/branch/master/graph/badge.svg?token=V19CWH7MXX)](https://codecov.io/gh/piccolo-orm/piccolo) Piccolo is a fast, user friendly ORM and query builder which supports asyncio. [Read the docs](https://piccolo-orm.readthedocs.io/en/latest/). ## Features Some of it’s stand out features are: - Support for sync and async. - A builtin playground, which makes learning a breeze. - Tab completion support - works great with iPython and VSCode. - Batteries included - a User model, authentication, migrations, an [admin GUI](https://github.com/piccolo-orm/piccolo_admin), and more. - Modern Python - fully type annotated. - Make your codebase modular and scalable with Piccolo apps (similar to Django apps). ## Syntax The syntax is clean and expressive. You can use it as a query builder: ```python # Select: await Band.select( Band.name ).where( Band.popularity > 100 ) # Join: await Band.select( Band.name, Band.manager.name ) # Delete: await Band.delete().where( Band.popularity < 1000 ) # Update: await Band.update({Band.popularity: 10000}).where( Band.name == 'Pythonistas' ) ``` Or like a typical ORM: ```python # To create a new object: b = Band(name='C-Sharps', popularity=100) await b.save() # To fetch an object from the database, and update it: b = await Band.objects().get(Band.name == 'Pythonistas') b.popularity = 10000 await b.save() # To delete: await b.remove() ``` ## Installation Installing with PostgreSQL driver: ```bash pip install 'piccolo[postgres]' ``` Installing with SQLite driver: ```bash pip install 'piccolo[sqlite]' ``` Installing with all optional dependencies (easiest): ```bash pip install 'piccolo[all]' ``` ## Building a web app? Let Piccolo scaffold you an ASGI web app, using Piccolo as the ORM: ```bash piccolo asgi new ``` [Starlette](https://www.starlette.io/), [FastAPI](https://fastapi.tiangolo.com/), [BlackSheep](https://www.neoteroi.dev/blacksheep/), [Xpresso](https://xpresso-api.dev/) and [Starlite](https://starlite-api.github.io/starlite/) are currently supported. ## Are you a Django user? We have a handy page which shows the equivalent of [common Django queries in Piccolo](https://piccolo-orm.readthedocs.io/en/latest/piccolo/query_types/django_comparison.html). ## Documentation Our documentation is on [Read the docs](https://piccolo-orm.readthedocs.io/en/latest/piccolo/getting_started/index.html). We also have some great [tutorial videos on YouTube](https://www.youtube.com/channel/UCE7x5nm1Iy9KDfXPNrNQ5lA). %prep %autosetup -n piccolo-0.109.0 %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-piccolo -f filelist.lst %dir %{python3_sitelib}/* %files help -f doclist.lst %{_docdir}/* %changelog * Tue Apr 25 2023 Python_Bot - 0.109.0-1 - Package Spec generated