#!/usr/bin/env python
import sys,os
import _mssql

if len(sys.argv) != 5:
	print 'data_import.py [server] [username] [password] [database]'
else:
	print 'host=%s, user=%s, password=%s, database=%s' % (sys.argv[1],sys.argv[2],sys.argv[3],sys.argv[4])
	conn = _mssql.connect(server=sys.argv[1], user=sys.argv[2], password=sys.argv[3], database=sys.argv[4])
	print '>',
	cmd = raw_input()
	while cmd != 'exit':
		if cmd != '':
			print cmd
			try:
				conn.execute_query(cmd)
				for row in conn:
					for i in range(0,( len(row) / 2 )):
						print row[i],'|',
					print ''
			except _mssql.MssqlDatabaseException,e:
				print e
		print '>',
		cmd = raw_input();
	
	conn.close()