automatic import of python-sqlserverportopeneuler20.03

3 files changed, 230 insertions, 0 deletions

diff --git a/.gitignore b/.gitignore
index e69de29..c1791b4 100644
--- a/.gitignore
+++ b/.gitignore
@@ -0,0 +1 @@
+/sqlserverport-1.0.1.tar.gz
diff --git a/python-sqlserverport.spec b/python-sqlserverport.spec
new file mode 100644
index 0000000..c49cba3
--- /dev/null
+++ b/python-sqlserverport.spec
@@ -0,0 +1,228 @@
+%global _empty_manifest_terminate_build 0
+Name:		python-sqlserverport
+Version:	1.0.1
+Release:	1
+Summary:	Query SQL Browser for port used by named instance
+License:	MIT
+URL:		https://github.com/gordthompson/sqlserverport
+Source0:	https://mirrors.nju.edu.cn/pypi/web/packages/d4/85/fba3397080fc9d05685266291fb05d3269b044a0108adb11c6d016b92116/sqlserverport-1.0.1.tar.gz
+BuildArch:	noarch
+
+
+%description
+# sqlserverport
+
+A simple Python module to query the SQL Browser service for the port number of a SQL Server instance. The Linux implementation of Microsoft's "ODBC Driver xx for SQL Server" is (still) unable to resolve instance names, so Windows users can just do
+
+```python
+import pyodbc
+serverspec = r'myserver\SQLEXPRESS'
+conn = pyodbc.connect('DRIVER=ODBC Driver 17 for SQL Server;SERVER={};...'.format(serverspec))
+```
+
+but that won't work on Linux. This module lets us do
+
+```python
+import pyodbc
+import sqlserverport
+servername = 'myserver'
+serverspec = '{0},{1}'.format(
+    servername,
+    sqlserverport.lookup(servername, 'SQLEXPRESS'))
+conn = pyodbc.connect('DRIVER=ODBC Driver 17 for SQL Server;SERVER={};...'.format(serverspec))
+```
+
+## Installing
+
+```
+pip install sqlserverport
+```
+
+## Example
+
+```python
+# example.py
+import sqlserverport
+
+# test data
+server_name = "192.168.0.103"
+instance_name = "SQLEXPRESS"
+
+try:
+    result = r"Instance {0}\{1} is listening on port {2}.".format(
+        server_name,
+        instance_name,
+        sqlserverport.lookup(server_name, instance_name),
+    )
+except sqlserverport.BrowserError as err:
+    result = err.message
+except sqlserverport.NoTcpError as err:
+    result = err.message
+
+print(result)
+```
+
+
+
+%package -n python3-sqlserverport
+Summary:	Query SQL Browser for port used by named instance
+Provides:	python-sqlserverport
+BuildRequires:	python3-devel
+BuildRequires:	python3-setuptools
+BuildRequires:	python3-pip
+%description -n python3-sqlserverport
+# sqlserverport
+
+A simple Python module to query the SQL Browser service for the port number of a SQL Server instance. The Linux implementation of Microsoft's "ODBC Driver xx for SQL Server" is (still) unable to resolve instance names, so Windows users can just do
+
+```python
+import pyodbc
+serverspec = r'myserver\SQLEXPRESS'
+conn = pyodbc.connect('DRIVER=ODBC Driver 17 for SQL Server;SERVER={};...'.format(serverspec))
+```
+
+but that won't work on Linux. This module lets us do
+
+```python
+import pyodbc
+import sqlserverport
+servername = 'myserver'
+serverspec = '{0},{1}'.format(
+    servername,
+    sqlserverport.lookup(servername, 'SQLEXPRESS'))
+conn = pyodbc.connect('DRIVER=ODBC Driver 17 for SQL Server;SERVER={};...'.format(serverspec))
+```
+
+## Installing
+
+```
+pip install sqlserverport
+```
+
+## Example
+
+```python
+# example.py
+import sqlserverport
+
+# test data
+server_name = "192.168.0.103"
+instance_name = "SQLEXPRESS"
+
+try:
+    result = r"Instance {0}\{1} is listening on port {2}.".format(
+        server_name,
+        instance_name,
+        sqlserverport.lookup(server_name, instance_name),
+    )
+except sqlserverport.BrowserError as err:
+    result = err.message
+except sqlserverport.NoTcpError as err:
+    result = err.message
+
+print(result)
+```
+
+
+
+%package help
+Summary:	Development documents and examples for sqlserverport
+Provides:	python3-sqlserverport-doc
+%description help
+# sqlserverport
+
+A simple Python module to query the SQL Browser service for the port number of a SQL Server instance. The Linux implementation of Microsoft's "ODBC Driver xx for SQL Server" is (still) unable to resolve instance names, so Windows users can just do
+
+```python
+import pyodbc
+serverspec = r'myserver\SQLEXPRESS'
+conn = pyodbc.connect('DRIVER=ODBC Driver 17 for SQL Server;SERVER={};...'.format(serverspec))
+```
+
+but that won't work on Linux. This module lets us do
+
+```python
+import pyodbc
+import sqlserverport
+servername = 'myserver'
+serverspec = '{0},{1}'.format(
+    servername,
+    sqlserverport.lookup(servername, 'SQLEXPRESS'))
+conn = pyodbc.connect('DRIVER=ODBC Driver 17 for SQL Server;SERVER={};...'.format(serverspec))
+```
+
+## Installing
+
+```
+pip install sqlserverport
+```
+
+## Example
+
+```python
+# example.py
+import sqlserverport
+
+# test data
+server_name = "192.168.0.103"
+instance_name = "SQLEXPRESS"
+
+try:
+    result = r"Instance {0}\{1} is listening on port {2}.".format(
+        server_name,
+        instance_name,
+        sqlserverport.lookup(server_name, instance_name),
+    )
+except sqlserverport.BrowserError as err:
+    result = err.message
+except sqlserverport.NoTcpError as err:
+    result = err.message
+
+print(result)
+```
+
+
+
+%prep
+%autosetup -n sqlserverport-1.0.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-sqlserverport -f filelist.lst
+%dir %{python3_sitelib}/*
+
+%files help -f doclist.lst
+%{_docdir}/*
+
+%changelog
+* Fri May 05 2023 Python_Bot <Python_Bot@openeuler.org> - 1.0.1-1
+- Package Spec generated
diff --git a/sources b/sources
new file mode 100644
index 0000000..a8ceb34
--- /dev/null
+++ b/sources
@@ -0,0 +1 @@
+5ba16198d8a0222447171d7beda66faa  sqlserverport-1.0.1.tar.gz