diff options
| -rw-r--r-- | .gitignore | 1 | ||||
| -rw-r--r-- | python-pyadomd.spec | 270 | ||||
| -rw-r--r-- | sources | 1 |
3 files changed, 272 insertions, 0 deletions
@@ -0,0 +1 @@ +/pyadomd-0.1.1.tar.gz diff --git a/python-pyadomd.spec b/python-pyadomd.spec new file mode 100644 index 0000000..5e9dcdb --- /dev/null +++ b/python-pyadomd.spec @@ -0,0 +1,270 @@ +%global _empty_manifest_terminate_build 0 +Name: python-pyadomd +Version: 0.1.1 +Release: 1 +Summary: A pythonic approach to query SSAS data models +License: Apache License 2.0 +URL: https://github.com/Andboye/Pyadomd +Source0: https://mirrors.nju.edu.cn/pypi/web/packages/92/1a/cbc4b46c1ad13782670d01c6c20d4f2ee7e0f6aeb80dd9e0ba06aa2664b0/pyadomd-0.1.1.tar.gz +BuildArch: noarch + + +%description +# pyadomd + +A pythonic approach to query SSAS data models. + + + + + +[](https://pyadomd.readthedocs.io/en/latest/?badge=latest) + +## Installation + +```console +pip install pyadomd +``` + +## Query SSAS Tabular model + +```python +from sys import path +path.append('\\Program Files\\Microsoft.NET\\ADOMD.NET\\150') + +from pyadomd import Pyadomd + +conn_str = 'Provider=MSOLAP;Data Source=localhost;Catalog=AdventureWorks;' +query = """EVALUATE Product""" + +with Pyadomd(conn_str) as conn: + with conn.cursor().execute(query) as cur: + print(cur.fetchall()) +``` + +## Integrates easily with pandas + +```python + +from pandas import DataFrame + +with Pyadomd(conn_str) as conn: + with conn.cursor().execute(query) as cur: + df = DataFrame(cur.fetchone(), columns=[i.name for i in cur.description]) +``` + +## FAQ + +Q: I get the following exception? +```C# +System.IO.FileNotFoundException: Unable to find assembly 'Microsoft.AnalysisServices.AdomdClient'. + at Python.Runtime.CLRModule.AddReference(String name) +``` +A: This exception is most likely raised because you have'ent added the folder with the Microsoft.AnalysisServices.AdomdClient.dll to your path, before you import the pyadomd package. + +Example: +```Python +from sys import path +#added to the path _before_ importing the pyadomd package +path.append('\\Program Files\\Microsoft.NET\\ADOMD.NET\\150') + +from pyadomd import Pyadomd +``` + +Q: When I try to connect an Azure Analysis Service instance I get an: +``` +Authentication faild: User ID and Password are required when user interface is not available? +``` + +A: This exception is most likely raised due to your "app" is not registered. Please follow the microsoft app registration documentation [microsoft docs](https://docs.microsoft.com/en-us/azure/active-directory/develop/howto-create-service-principal-portal). The script: connect_to_ass.py ([link to script](https://github.com/S-C-O-U-T/Pyadomd/blob/master/test/connect_to_aas_win.py)) is a simple example on how to create a connection to a Azure Analysis Service. Please note that this is only an example, and not necessarily suitable for all apps. + +%package -n python3-pyadomd +Summary: A pythonic approach to query SSAS data models +Provides: python-pyadomd +BuildRequires: python3-devel +BuildRequires: python3-setuptools +BuildRequires: python3-pip +%description -n python3-pyadomd +# pyadomd + +A pythonic approach to query SSAS data models. + + + + + +[](https://pyadomd.readthedocs.io/en/latest/?badge=latest) + +## Installation + +```console +pip install pyadomd +``` + +## Query SSAS Tabular model + +```python +from sys import path +path.append('\\Program Files\\Microsoft.NET\\ADOMD.NET\\150') + +from pyadomd import Pyadomd + +conn_str = 'Provider=MSOLAP;Data Source=localhost;Catalog=AdventureWorks;' +query = """EVALUATE Product""" + +with Pyadomd(conn_str) as conn: + with conn.cursor().execute(query) as cur: + print(cur.fetchall()) +``` + +## Integrates easily with pandas + +```python + +from pandas import DataFrame + +with Pyadomd(conn_str) as conn: + with conn.cursor().execute(query) as cur: + df = DataFrame(cur.fetchone(), columns=[i.name for i in cur.description]) +``` + +## FAQ + +Q: I get the following exception? +```C# +System.IO.FileNotFoundException: Unable to find assembly 'Microsoft.AnalysisServices.AdomdClient'. + at Python.Runtime.CLRModule.AddReference(String name) +``` +A: This exception is most likely raised because you have'ent added the folder with the Microsoft.AnalysisServices.AdomdClient.dll to your path, before you import the pyadomd package. + +Example: +```Python +from sys import path +#added to the path _before_ importing the pyadomd package +path.append('\\Program Files\\Microsoft.NET\\ADOMD.NET\\150') + +from pyadomd import Pyadomd +``` + +Q: When I try to connect an Azure Analysis Service instance I get an: +``` +Authentication faild: User ID and Password are required when user interface is not available? +``` + +A: This exception is most likely raised due to your "app" is not registered. Please follow the microsoft app registration documentation [microsoft docs](https://docs.microsoft.com/en-us/azure/active-directory/develop/howto-create-service-principal-portal). The script: connect_to_ass.py ([link to script](https://github.com/S-C-O-U-T/Pyadomd/blob/master/test/connect_to_aas_win.py)) is a simple example on how to create a connection to a Azure Analysis Service. Please note that this is only an example, and not necessarily suitable for all apps. + +%package help +Summary: Development documents and examples for pyadomd +Provides: python3-pyadomd-doc +%description help +# pyadomd + +A pythonic approach to query SSAS data models. + + + + + +[](https://pyadomd.readthedocs.io/en/latest/?badge=latest) + +## Installation + +```console +pip install pyadomd +``` + +## Query SSAS Tabular model + +```python +from sys import path +path.append('\\Program Files\\Microsoft.NET\\ADOMD.NET\\150') + +from pyadomd import Pyadomd + +conn_str = 'Provider=MSOLAP;Data Source=localhost;Catalog=AdventureWorks;' +query = """EVALUATE Product""" + +with Pyadomd(conn_str) as conn: + with conn.cursor().execute(query) as cur: + print(cur.fetchall()) +``` + +## Integrates easily with pandas + +```python + +from pandas import DataFrame + +with Pyadomd(conn_str) as conn: + with conn.cursor().execute(query) as cur: + df = DataFrame(cur.fetchone(), columns=[i.name for i in cur.description]) +``` + +## FAQ + +Q: I get the following exception? +```C# +System.IO.FileNotFoundException: Unable to find assembly 'Microsoft.AnalysisServices.AdomdClient'. + at Python.Runtime.CLRModule.AddReference(String name) +``` +A: This exception is most likely raised because you have'ent added the folder with the Microsoft.AnalysisServices.AdomdClient.dll to your path, before you import the pyadomd package. + +Example: +```Python +from sys import path +#added to the path _before_ importing the pyadomd package +path.append('\\Program Files\\Microsoft.NET\\ADOMD.NET\\150') + +from pyadomd import Pyadomd +``` + +Q: When I try to connect an Azure Analysis Service instance I get an: +``` +Authentication faild: User ID and Password are required when user interface is not available? +``` + +A: This exception is most likely raised due to your "app" is not registered. Please follow the microsoft app registration documentation [microsoft docs](https://docs.microsoft.com/en-us/azure/active-directory/develop/howto-create-service-principal-portal). The script: connect_to_ass.py ([link to script](https://github.com/S-C-O-U-T/Pyadomd/blob/master/test/connect_to_aas_win.py)) is a simple example on how to create a connection to a Azure Analysis Service. Please note that this is only an example, and not necessarily suitable for all apps. + +%prep +%autosetup -n pyadomd-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-pyadomd -f filelist.lst +%dir %{python3_sitelib}/* + +%files help -f doclist.lst +%{_docdir}/* + +%changelog +* Wed May 10 2023 Python_Bot <Python_Bot@openeuler.org> - 0.1.1-1 +- Package Spec generated @@ -0,0 +1 @@ +e6b9b74547d42f6f34cfff171633ce1b pyadomd-0.1.1.tar.gz |