SQLConn
Advanced tools
+1
-1
| Metadata-Version: 2.1 | ||
| Name: SQLConn | ||
| Version: 0.0.8 | ||
| Version: 0.0.9 | ||
| Summary: This package facilitates easy SQL database integration. | ||
@@ -5,0 +5,0 @@ Home-page: https://github.com/janyoungjin/SQLConn |
+1
-1
@@ -8,3 +8,3 @@ from setuptools import setup, find_packages | ||
| name='SQLConn', | ||
| version='0.0.8', | ||
| version='0.0.9', | ||
| description='This package facilitates easy SQL database integration.', | ||
@@ -11,0 +11,0 @@ long_description=long_description, |
| Metadata-Version: 2.1 | ||
| Name: SQLConn | ||
| Version: 0.0.8 | ||
| Version: 0.0.9 | ||
| Summary: This package facilitates easy SQL database integration. | ||
@@ -5,0 +5,0 @@ Home-page: https://github.com/janyoungjin/SQLConn |
+14
-8
@@ -98,14 +98,20 @@ from pandas import read_sql | ||
| class OracleConn(SQLConn): | ||
| def __init__(self,password:str,host:str='127.0.0.1',user:str="system",database:str="xe",port:str|int=1521) -> None: | ||
| def __init__(self, password: str, host: str = '127.0.0.1', user: str = "system", database: str = "xe", port: str | int = 1521) -> None: | ||
| try: | ||
| import cx_Oracle | ||
| except ImportError: | ||
| raise ImportError("cx_Oracle is not installed. Please install it using 'pip install SQLConn[oracle]'") | ||
| super().__init__() | ||
| self.__host=host | ||
| self.__user=user | ||
| self.__password=password | ||
| self.__database=database | ||
| self.__port=int(port) | ||
| self._conn=cx_Oracle.connect(self.__user,self.__password,f'{self.__host}:{self.__port}/{self.__database}') | ||
| self.__host = host | ||
| self.__user = user | ||
| self.__password = password | ||
| self.__database = database | ||
| self.__port = int(port) | ||
| self._conn = cx_Oracle.connect(self.__user, self.__password, f'{self.__host}:{self.__port}/{self.__database}') | ||
| @property | ||
| def URL(self): | ||
| return f'oracle+cx_oracle://{self.__user}:{self.__password}@{self.__host}:{self.__port}/?service_name={self.__database}' | ||
| class PostgresqlConn(SQLConn): | ||
@@ -112,0 +118,0 @@ def __init__(self,password:str,host:str='127.0.0.1',user:str="postgres",database:str="postgres",port:str|int=5432) -> None: |
Alert delta unavailable
Currently unable to show alert delta for PyPI packages.
38936
0.59%156
2.63%