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
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
|
%global _empty_manifest_terminate_build 0
Name: python-sql-queries
Version: 0.1.2
Release: 1
Summary: Build simple SQL queries fast and clean
License: GNU General Public License v3 (GPLv3)
URL: https://pypi.org/project/sql-queries/
Source0: https://mirrors.nju.edu.cn/pypi/web/packages/44/8b/39110589bbe30163ca4533db0833b892c3397a89f9a49e86f511cce574ad/sql_queries-0.1.2.tar.gz
BuildArch: noarch
%description
Are you finding yourself writing long strings to build up a SQL query in python
to communicate with your SQL database? Then **sql_queries** is what you are looking for.
This package provides you with tools to build simple SQL queries from the ground up,
without having to manually type out formatted spaghetti strings over and over again.
With this module, you'll no longer need codeblocks like this to write your queries :
```python
field = 'x'
table = 'a'
cond = 10
query = 'SELECT {} FROM {} WHERE {} = {}'.format(field, table, field, cond)
```
And this is only a simple example.
The **sql_queries** equivalent of the above looks like this:
```python
from sql_query import sql_select
query = sql_select('x', 'a')
query.where(attr='x', cond=10)
```
A simple *SELECT-FROM-WHERE* example has been demonstrated above with the **sql_select** object.
This object also supports *GROUP BY*, *HAVING*, *ORDER BY*, *LIMIT* and *JOIN* statements.
There is also the **sql_update** object, which supports *UPDATE*, *SET* and *WHERE* statements.
Review the documentation to get a better understanding of how to implement these statements.
For a quick demo you can also view to one minute demo's to get you started with this module.
These can be found on [youtube](https://www.youtube.com/playlist?list=PLI4WFrsrAg8sCeBj5xdJ6n79_3Yq3Sz23).
Convert a **sql_query** (sub)object to a string using the build-in str() function to get your
SQL query as text. The result can be used directly in for example pandas' *pd.read_sql_query()*
or sqlalchemy's *engine.execute(text())* methods.
### Known limitations for this version:
* Exceptions haven't yet been properly implemented.
* The .join method can only be used in combination with loading plain field (e.g. using COUNT(FieldX) in the SELECT statement will result in an invalid query)
* The module has only been properly tested with a SQLite3 database.
### Tutorial video's
A series of one minute demo's to get started with this module can be found on [youtube](https://www.youtube.com/playlist?list=PLI4WFrsrAg8sCeBj5xdJ6n79_3Yq3Sz23).
%package -n python3-sql-queries
Summary: Build simple SQL queries fast and clean
Provides: python-sql-queries
BuildRequires: python3-devel
BuildRequires: python3-setuptools
BuildRequires: python3-pip
%description -n python3-sql-queries
Are you finding yourself writing long strings to build up a SQL query in python
to communicate with your SQL database? Then **sql_queries** is what you are looking for.
This package provides you with tools to build simple SQL queries from the ground up,
without having to manually type out formatted spaghetti strings over and over again.
With this module, you'll no longer need codeblocks like this to write your queries :
```python
field = 'x'
table = 'a'
cond = 10
query = 'SELECT {} FROM {} WHERE {} = {}'.format(field, table, field, cond)
```
And this is only a simple example.
The **sql_queries** equivalent of the above looks like this:
```python
from sql_query import sql_select
query = sql_select('x', 'a')
query.where(attr='x', cond=10)
```
A simple *SELECT-FROM-WHERE* example has been demonstrated above with the **sql_select** object.
This object also supports *GROUP BY*, *HAVING*, *ORDER BY*, *LIMIT* and *JOIN* statements.
There is also the **sql_update** object, which supports *UPDATE*, *SET* and *WHERE* statements.
Review the documentation to get a better understanding of how to implement these statements.
For a quick demo you can also view to one minute demo's to get you started with this module.
These can be found on [youtube](https://www.youtube.com/playlist?list=PLI4WFrsrAg8sCeBj5xdJ6n79_3Yq3Sz23).
Convert a **sql_query** (sub)object to a string using the build-in str() function to get your
SQL query as text. The result can be used directly in for example pandas' *pd.read_sql_query()*
or sqlalchemy's *engine.execute(text())* methods.
### Known limitations for this version:
* Exceptions haven't yet been properly implemented.
* The .join method can only be used in combination with loading plain field (e.g. using COUNT(FieldX) in the SELECT statement will result in an invalid query)
* The module has only been properly tested with a SQLite3 database.
### Tutorial video's
A series of one minute demo's to get started with this module can be found on [youtube](https://www.youtube.com/playlist?list=PLI4WFrsrAg8sCeBj5xdJ6n79_3Yq3Sz23).
%package help
Summary: Development documents and examples for sql-queries
Provides: python3-sql-queries-doc
%description help
Are you finding yourself writing long strings to build up a SQL query in python
to communicate with your SQL database? Then **sql_queries** is what you are looking for.
This package provides you with tools to build simple SQL queries from the ground up,
without having to manually type out formatted spaghetti strings over and over again.
With this module, you'll no longer need codeblocks like this to write your queries :
```python
field = 'x'
table = 'a'
cond = 10
query = 'SELECT {} FROM {} WHERE {} = {}'.format(field, table, field, cond)
```
And this is only a simple example.
The **sql_queries** equivalent of the above looks like this:
```python
from sql_query import sql_select
query = sql_select('x', 'a')
query.where(attr='x', cond=10)
```
A simple *SELECT-FROM-WHERE* example has been demonstrated above with the **sql_select** object.
This object also supports *GROUP BY*, *HAVING*, *ORDER BY*, *LIMIT* and *JOIN* statements.
There is also the **sql_update** object, which supports *UPDATE*, *SET* and *WHERE* statements.
Review the documentation to get a better understanding of how to implement these statements.
For a quick demo you can also view to one minute demo's to get you started with this module.
These can be found on [youtube](https://www.youtube.com/playlist?list=PLI4WFrsrAg8sCeBj5xdJ6n79_3Yq3Sz23).
Convert a **sql_query** (sub)object to a string using the build-in str() function to get your
SQL query as text. The result can be used directly in for example pandas' *pd.read_sql_query()*
or sqlalchemy's *engine.execute(text())* methods.
### Known limitations for this version:
* Exceptions haven't yet been properly implemented.
* The .join method can only be used in combination with loading plain field (e.g. using COUNT(FieldX) in the SELECT statement will result in an invalid query)
* The module has only been properly tested with a SQLite3 database.
### Tutorial video's
A series of one minute demo's to get started with this module can be found on [youtube](https://www.youtube.com/playlist?list=PLI4WFrsrAg8sCeBj5xdJ6n79_3Yq3Sz23).
%prep
%autosetup -n sql-queries-0.1.2
%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-sql-queries -f filelist.lst
%dir %{python3_sitelib}/*
%files help -f doclist.lst
%{_docdir}/*
%changelog
* Tue May 30 2023 Python_Bot <Python_Bot@openeuler.org> - 0.1.2-1
- Package Spec generated
|
