import pxssh
try:
s = pxssh.pxssh()
#hostname = raw_input('hostname: ')
#username = raw_input('username: ')
hostname = '---------'
username = '---------'
s.login (hostname, username)
s.sendline ('psql doit tamr') # run a command
s.prompt() # match the prompt
print s.before # print everything before the prompt.
s.sendline ('12345')
s.prompt()
print s.before
s.sendline('\o ' + hcr_csv_file.replace(directory, ''))
s.sendline('\i hcr_' + category + '_query.sql')
s.sendline('\o ' + pde_csv_file.replace(directory, ''))
s.sendline('\i pde_' + category + '_query.sql')
s.sendline('\q')
s.logout()
except pxssh.ExceptionPxssh, e:
print "pxssh failed on login."
print str(e)