blob: 890501ea4d89395d1a3f3fb9c2a4fc7e33e9b649 (
plain)
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
|
%global _empty_manifest_terminate_build 0
Name: python-snowconvert-deploy-tool
Version: 0.0.25
Release: 1
Summary: Mobilize.Net Database Deploy tool for Snowflake
License: MIT
URL: https://github.com/MobilizeNet/SnowConvert_Support_Library/tree/main/tools/snowconvert-deploy
Source0: https://mirrors.aliyun.com/pypi/web/packages/4c/28/5e3f7b9883bc31b51ebb9dc446bd7d38df9032411fa9fe52b158dd2134f3/snowconvert-deploy-tool-0.0.25.tar.gz
BuildArch: noarch
Requires: python3-snowflake-connector-python
Requires: python3-oscrypto
Requires: python3-Rich
%description
`sc-deploy-db` is a cross-platform command line tool for deploying scripts to Snowflake.
This tool is designed to help with the deployment of large data warehouses.
A typical challenge when deploying code to snowflake is handling dependendencies. For example if you have a
view and it depends on some other views, then your deployment will fail if you do not deploy
the dependendencies first.
`sc-deploy-db` can handle dependendencies between objects. The tool uses a brute-force
approach in which if an object fails due to a missing dependendency it will put it a queue
and then the deployment of that object it will retried.
The tool will keep trying to deploy until it gets to point where no more objects can be deployed.
The tool will also provide deployment logs that will help you to identify and track any deployment issues.
For projects using `SnowConvert`_ this deploy tool is highly recommended.
Also a lot of tools have limitations when deploying files that contain several code snippets. A typical error you might get is::
000006 (0A000): Multiple SQL statements in a single API call are not supported; use one API call per statement instead.
This tool has some options that can process the code inside the files, splitting it based on pattern before deployment helping
in those situations. Please read more about it the following sections.
However starting on version 0.0.18 the tool can leverate the connector capabilities for running multiple statements.
The split functionality has been left for cases where this may still be needed.
%package -n python3-snowconvert-deploy-tool
Summary: Mobilize.Net Database Deploy tool for Snowflake
Provides: python-snowconvert-deploy-tool
BuildRequires: python3-devel
BuildRequires: python3-setuptools
BuildRequires: python3-pip
%description -n python3-snowconvert-deploy-tool
`sc-deploy-db` is a cross-platform command line tool for deploying scripts to Snowflake.
This tool is designed to help with the deployment of large data warehouses.
A typical challenge when deploying code to snowflake is handling dependendencies. For example if you have a
view and it depends on some other views, then your deployment will fail if you do not deploy
the dependendencies first.
`sc-deploy-db` can handle dependendencies between objects. The tool uses a brute-force
approach in which if an object fails due to a missing dependendency it will put it a queue
and then the deployment of that object it will retried.
The tool will keep trying to deploy until it gets to point where no more objects can be deployed.
The tool will also provide deployment logs that will help you to identify and track any deployment issues.
For projects using `SnowConvert`_ this deploy tool is highly recommended.
Also a lot of tools have limitations when deploying files that contain several code snippets. A typical error you might get is::
000006 (0A000): Multiple SQL statements in a single API call are not supported; use one API call per statement instead.
This tool has some options that can process the code inside the files, splitting it based on pattern before deployment helping
in those situations. Please read more about it the following sections.
However starting on version 0.0.18 the tool can leverate the connector capabilities for running multiple statements.
The split functionality has been left for cases where this may still be needed.
%package help
Summary: Development documents and examples for snowconvert-deploy-tool
Provides: python3-snowconvert-deploy-tool-doc
%description help
`sc-deploy-db` is a cross-platform command line tool for deploying scripts to Snowflake.
This tool is designed to help with the deployment of large data warehouses.
A typical challenge when deploying code to snowflake is handling dependendencies. For example if you have a
view and it depends on some other views, then your deployment will fail if you do not deploy
the dependendencies first.
`sc-deploy-db` can handle dependendencies between objects. The tool uses a brute-force
approach in which if an object fails due to a missing dependendency it will put it a queue
and then the deployment of that object it will retried.
The tool will keep trying to deploy until it gets to point where no more objects can be deployed.
The tool will also provide deployment logs that will help you to identify and track any deployment issues.
For projects using `SnowConvert`_ this deploy tool is highly recommended.
Also a lot of tools have limitations when deploying files that contain several code snippets. A typical error you might get is::
000006 (0A000): Multiple SQL statements in a single API call are not supported; use one API call per statement instead.
This tool has some options that can process the code inside the files, splitting it based on pattern before deployment helping
in those situations. Please read more about it the following sections.
However starting on version 0.0.18 the tool can leverate the connector capabilities for running multiple statements.
The split functionality has been left for cases where this may still be needed.
%prep
%autosetup -n snowconvert-deploy-tool-0.0.25
%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-snowconvert-deploy-tool -f filelist.lst
%dir %{python3_sitelib}/*
%files help -f doclist.lst
%{_docdir}/*
%changelog
* Tue Jun 20 2023 Python_Bot <Python_Bot@openeuler.org> - 0.0.25-1
- Package Spec generated
|
