-
Notifications
You must be signed in to change notification settings - Fork 2
/
python_SQL_Server_Connect.py
33 lines (27 loc) · 1.07 KB
/
python_SQL_Server_Connect.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
import pyodbc
class SQLServerConnect:
def __init__(self,server,database) -> None:
self.server = server
self.database = database
def establish_conn(self):
try:
conn_str = f'DRIVER={{SQL Server}};SERVER={self.server};DATABASE={self.database};Trusted_Connection=yes;'
self.conn = pyodbc.connect(conn_str)
print("***** Connection Established Successfully *****")
except:
print("Unable to Establish the Connection")
print("Server Name or Database Name has some mistake. Please Check! ")
def execute_query(self,query):
cursor = self.conn.cursor()
cursor.execute(query)
rows = cursor.fetchall()
return rows
def close_conn(self):
self.conn.close()
print("***** Closed the Connection Successfully *****")
if __name__ == "__main__":
obj = SQLServerConnect('servername','database')
obj.establish_conn()
obj.execute_query("SELECT * FROM Person")
obj.execute_query("SELECT first_name FROM Person")
obj.close_conn()