From 2d49816a59805ce0321a32f7f88eaef4e20b8d8e Mon Sep 17 00:00:00 2001 From: CoprDistGit Date: Fri, 5 May 2023 04:24:42 +0000 Subject: automatic import of python-sqlserverport --- .gitignore | 1 + python-sqlserverport.spec | 228 ++++++++++++++++++++++++++++++++++++++++++++++ sources | 1 + 3 files changed, 230 insertions(+) create mode 100644 python-sqlserverport.spec create mode 100644 sources 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 - 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 -- cgit v1.2.3