search

uwescience / sqlshare-pythonclient

The Python client for the SQLShare REST API
3 stars 1 forks source link

fetchdata error #4

Closed che625 closed 11 years ago

che625 commented 11 years ago

Hi, I'm trying to configure my computer to download tab-separated values from sqlshare and am having some difficulties. I have installed Python and when trying to run python fetchdata.py I am getting the following error:

d-128-208-138-209:tools claireellis$ python fetchdata.py -d "[che625@washington.edu].[BiGO_MethylatedCGs_oysterv9]" -f tsv -o /Users/claireellis/Desktop/methylated.txt Traceback (most recent call last): File "fetchdata.py", line 77, in main() File "fetchdata.py", line 71, in main data = fetchdata(args.sql, args.format) File "fetchdata.py", line 29, in fetchdata conn = sqlshare.SQLShare() File "/Users/claireellis/Downloads/sqlshare-pythonclient-master/sqlshare/init.py", line 66, in init self.username = self.config.get('sqlshare','user') File "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/ConfigParser.py", line 618, in get raise NoOptionError(option, section) ConfigParser.NoOptionError: No option 'user' in section: 'sqlshare'

I am thinking that my issue might have something to do with my config file but I created it exactly as stated in the setup instructions. Any suggestions? thanks!

dhalperi commented 11 years ago

(Just got off a plane, sorry for delay:). Can you please run `ls -l ~/.sqlshare

dhalperi commented 11 years ago

sorry, hit enter too soon.

ls -l ~/.sqlshare

and then

cat ~/.sqlshare/config

and post both outputs here?

che625 commented 11 years ago

cat: /Users/claireellis/.sqlshare/config: No such file or directory

I'm guessing that my config file is in the wrong directory? Thanks for the help Dan!

dhalperi commented 11 years ago

yeah, let me go look at the instructions again.

dhalperi commented 11 years ago

okay, see new instructions here under step 3: https://github.com/uwescience/sqlshare-pythonclient/blob/master/README.md#quick-setup-instructions

Does that make more sense? Please let me know how to clear it up :)

dhalperi commented 11 years ago

Hi Claire, just checking in, did you get this working?