SQLConn
Advanced tools
+1
-6
| Metadata-Version: 2.1 | ||
| Name: SQLConn | ||
| Version: 0.0.14 | ||
| Version: 0.0.15 | ||
| Summary: This package facilitates easy SQL database integration. | ||
@@ -13,7 +13,2 @@ Home-page: https://github.com/janyoungjin/SQLConn | ||
| Description-Content-Type: text/markdown | ||
| Requires-Dist: pandas | ||
| Requires-Dist: sqlalchemy | ||
| Requires-Dist: pymysql | ||
| Requires-Dist: pymssql | ||
| Requires-Dist: psycopg2-binary | ||
@@ -20,0 +15,0 @@ # SQLConn |
+1
-1
@@ -8,3 +8,3 @@ from setuptools import setup, find_packages | ||
| name='SQLConn', | ||
| version='0.0.14', | ||
| version='0.0.15', | ||
| 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.14 | ||
| Version: 0.0.15 | ||
| Summary: This package facilitates easy SQL database integration. | ||
@@ -13,7 +13,2 @@ Home-page: https://github.com/janyoungjin/SQLConn | ||
| Description-Content-Type: text/markdown | ||
| Requires-Dist: pandas | ||
| Requires-Dist: sqlalchemy | ||
| Requires-Dist: pymysql | ||
| Requires-Dist: pymssql | ||
| Requires-Dist: psycopg2-binary | ||
@@ -20,0 +15,0 @@ # SQLConn |
| from pandas import read_sql | ||
| import warnings | ||
| from sqlalchemy import create_engine | ||
| from sqlalchemy.engine.base import Engine | ||
| from abc import ABC, abstractmethod | ||
@@ -10,2 +9,3 @@ import pymysql | ||
| import sqlite3 | ||
| from typing import Union | ||
@@ -75,3 +75,3 @@ class SQLConn(ABC): | ||
| class MYSQLConn(SQLConn): | ||
| def __init__(self,password:str,host:str='127.0.0.1',user:str="root",database:str="mysql",port:str|int=3306) -> None: | ||
| def __init__(self,password:str,host:str='127.0.0.1',user:str="root",database:str="mysql",port:Union[str,int]=3306) -> None: | ||
| super().__init__() | ||
@@ -89,3 +89,3 @@ self.__host=host | ||
| class MSSQLConn(SQLConn): | ||
| def __init__(self,password:str,host:str='127.0.0.1',user:str="sa",database:str="master",port:str|int=1433) -> None: | ||
| def __init__(self,password:str,host:str='127.0.0.1',user:str="sa",database:str="master",port:Union[str,int]=1433) -> None: | ||
| super().__init__() | ||
@@ -104,3 +104,3 @@ self.__host=host | ||
| class PostgresqlConn(SQLConn): | ||
| def __init__(self,password:str,host:str='127.0.0.1',user:str="postgres",database:str="postgres",port:str|int=5432) -> None: | ||
| def __init__(self,password:str,host:str='127.0.0.1',user:str="postgres",database:str="postgres",port:Union[str,int]=5432) -> None: | ||
| super().__init__() | ||
@@ -107,0 +107,0 @@ self.__host=host |
Alert delta unavailable
Currently unable to show alert delta for PyPI packages.
37713
-0.67%