%global _empty_manifest_terminate_build 0
Name: python-YamlBase
Version: 0.1.1
Release: 1
Summary: YamlBase: simple yaml config based VCS for database
License: MIT
URL: https://pypi.org/project/YamlBase/
Source0: https://mirrors.aliyun.com/pypi/web/packages/f1/70/7f1dc727694b83ef7d5d34f211f520fd9265b67b57d5eeb1629296199775/YamlBase-0.1.1.tar.gz
BuildArch: noarch
%description
# YamlBase
[](https://codecov.io/gh/mv-yurchenko/YBase)
[](https://github.com/mv-yurchenko/YBase/actions)
[](https://www.codefactor.io/repository/github/mv-yurchenko/ybase)
[](https://badge.fury.io/py/YamlBase)
[](https://badge.fury.io/gh/mv-yurchenko%2FYBase)
This utility allows you to manage tables in a database using YAML files, which makes it faster to create and delete tables in multiple databases simultaneously
## The following databases are currently supported:
- [SQLite](###sqlite-config-example)
## Installation
```shell script
pip install YamlBase
```
## Config examples
### SQLite config example
Click to expand!
> base_example.yaml
```
db_type: "SQLite" # - type of database
ip: "H:/YBase/" # - path to file with database
db_name: "test_db" # - database file name
username: ""
password: ""
schemas: # - list of schemas in database (main - default in SQLite)
main:
table_1: # - table description example
name: "table1" # - must be same as block name
descriprion: "table for test" # - some custom descriprions
permissions: [] # - unused in SQLite
columns: # - list of columns
column1: # - column example
name: "column1" # - must be same as block name
type: "text" # - type of columns in SQLite
is_pk: 1 # - is column a primary key
is_sk: 0 # - is column is secondary key (if 1 than defina sk_link)
sk_link: 0 # - sk link for table (table.column)
```
> actions_example.yaml
```
# table : action
# table must be in database if remove or in base_config if insert
# table1 : insert - insert action
# table2 : remove - remove action
```
## Usage Example
To use this utility, you need 2 files, one is the configuration of new tables for the database, and the second is a file with a list of actions
File examples:
- actions_example.yaml
- base_example.yaml
%package -n python3-YamlBase
Summary: YamlBase: simple yaml config based VCS for database
Provides: python-YamlBase
BuildRequires: python3-devel
BuildRequires: python3-setuptools
BuildRequires: python3-pip
%description -n python3-YamlBase
# YamlBase
[](https://codecov.io/gh/mv-yurchenko/YBase)
[](https://github.com/mv-yurchenko/YBase/actions)
[](https://www.codefactor.io/repository/github/mv-yurchenko/ybase)
[](https://badge.fury.io/py/YamlBase)
[](https://badge.fury.io/gh/mv-yurchenko%2FYBase)
This utility allows you to manage tables in a database using YAML files, which makes it faster to create and delete tables in multiple databases simultaneously
## The following databases are currently supported:
- [SQLite](###sqlite-config-example)
## Installation
```shell script
pip install YamlBase
```
## Config examples
### SQLite config example
Click to expand!
> base_example.yaml
```
db_type: "SQLite" # - type of database
ip: "H:/YBase/" # - path to file with database
db_name: "test_db" # - database file name
username: ""
password: ""
schemas: # - list of schemas in database (main - default in SQLite)
main:
table_1: # - table description example
name: "table1" # - must be same as block name
descriprion: "table for test" # - some custom descriprions
permissions: [] # - unused in SQLite
columns: # - list of columns
column1: # - column example
name: "column1" # - must be same as block name
type: "text" # - type of columns in SQLite
is_pk: 1 # - is column a primary key
is_sk: 0 # - is column is secondary key (if 1 than defina sk_link)
sk_link: 0 # - sk link for table (table.column)
```
> actions_example.yaml
```
# table : action
# table must be in database if remove or in base_config if insert
# table1 : insert - insert action
# table2 : remove - remove action
```
## Usage Example
To use this utility, you need 2 files, one is the configuration of new tables for the database, and the second is a file with a list of actions
File examples:
- actions_example.yaml
- base_example.yaml
%package help
Summary: Development documents and examples for YamlBase
Provides: python3-YamlBase-doc
%description help
# YamlBase
[](https://codecov.io/gh/mv-yurchenko/YBase)
[](https://github.com/mv-yurchenko/YBase/actions)
[](https://www.codefactor.io/repository/github/mv-yurchenko/ybase)
[](https://badge.fury.io/py/YamlBase)
[](https://badge.fury.io/gh/mv-yurchenko%2FYBase)
This utility allows you to manage tables in a database using YAML files, which makes it faster to create and delete tables in multiple databases simultaneously
## The following databases are currently supported:
- [SQLite](###sqlite-config-example)
## Installation
```shell script
pip install YamlBase
```
## Config examples
### SQLite config example
Click to expand!
> base_example.yaml
```
db_type: "SQLite" # - type of database
ip: "H:/YBase/" # - path to file with database
db_name: "test_db" # - database file name
username: ""
password: ""
schemas: # - list of schemas in database (main - default in SQLite)
main:
table_1: # - table description example
name: "table1" # - must be same as block name
descriprion: "table for test" # - some custom descriprions
permissions: [] # - unused in SQLite
columns: # - list of columns
column1: # - column example
name: "column1" # - must be same as block name
type: "text" # - type of columns in SQLite
is_pk: 1 # - is column a primary key
is_sk: 0 # - is column is secondary key (if 1 than defina sk_link)
sk_link: 0 # - sk link for table (table.column)
```
> actions_example.yaml
```
# table : action
# table must be in database if remove or in base_config if insert
# table1 : insert - insert action
# table2 : remove - remove action
```
## Usage Example
To use this utility, you need 2 files, one is the configuration of new tables for the database, and the second is a file with a list of actions
File examples:
- actions_example.yaml
- base_example.yaml
%prep
%autosetup -n YamlBase-0.1.1
%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-YamlBase -f filelist.lst
%dir %{python3_sitelib}/*
%files help -f doclist.lst
%{_docdir}/*
%changelog
* Thu Jun 08 2023 Python_Bot - 0.1.1-1
- Package Spec generated