NinoCode/Active_prgs/Sql_Get.py

## Sql_Get.py
## This program will serve as a funtion that will allow me to get information from the mw repository.
## It shouldent be run as a program but instead be imported and run once when a program needs a new
## list of info.  For example a firm dir program should only update a static list once a day and get
## its info from the list and not reconnect to the server everytime.


import dbi
import odbc

def Connect_to_db(CS_RetrieveList):
    """ This program takes one argument and returns the huge list.  The one argument, which is what you want
    returned, should be seperated by a comma and a space.  (case matters!)"""
    myconn = odbc.odbc('MW_repository')
    mycursor = myconn.cursor()
    #mycursor.execute('SELECT NetLogin, NameFull FROM Employees')
    mycursor.execute('SELECT %s FROM Employees'% CS_RetrieveList)
    mydata = mycursor.fetchall()
    mycursor.close()
    myconn.close()
    return mydata

if __name__ == '__main__':
    #sql_data will give you a list of tuples that will need to be converted to a list of strings.
    sql_data = Connect_to_db('NetLogin, NameFull')
    w = open('u:\\sql.txt','w')
    w.writelines(sql_data)
    w.close()
Revision:	8
Committed:	Sat May 5 04:21:19 2012 UTC (13 years, 10 months ago) by ninoborges
Content type:	text/x-python
File size:	1203 byte(s)
Log Message:	Initial Import
#	Content
1	## Sql_Get.py
2	## This program will serve as a funtion that will allow me to get information from the mw repository.
3	## It shouldent be run as a program but instead be imported and run once when a program needs a new
4	## list of info. For example a firm dir program should only update a static list once a day and get
5	## its info from the list and not reconnect to the server everytime.
6
7
8	import dbi
9	import odbc
10
11	def Connect_to_db(CS_RetrieveList):
12	""" This program takes one argument and returns the huge list. The one argument, which is what you want
13	returned, should be seperated by a comma and a space. (case matters!)"""
14	myconn = odbc.odbc('MW_repository')
15	mycursor = myconn.cursor()
16	#mycursor.execute('SELECT NetLogin, NameFull FROM Employees')
17	mycursor.execute('SELECT %s FROM Employees'% CS_RetrieveList)
18	mydata = mycursor.fetchall()
19	mycursor.close()
20	myconn.close()
21	return mydata
22
23	if __name__ == '__main__':
24	#sql_data will give you a list of tuples that will need to be converted to a list of strings.
25	sql_data = Connect_to_db('NetLogin, NameFull')
26	w = open('u:\\sql.txt','w')
27	w.writelines(sql_data)
28	w.close()