python - popen sql string issue -

-



using popen run postgresql query. works:

maxid = 10  psql = "psql -d db -u user -t -c 'select id, experiment_id results id > " + maxid + "'"  ssh = subprocess.popen(['ssh', 'me@server', psql],                        shell=false,                        stdout=subprocess.pipe,                        stderr=subprocess.pipe) result = ssh.stdout.readlines()

when add clause, fails:

psql = "psql -d db -u user -t -c 'select id, experiment_id results status '%completed%' , id > " + maxid + "'"  ['error:  syntax error @ or near "%"\n', 'line 1: ...t_id" results status %completed...\n', '                                                             ^\n']

i've tried several quotation alternatives can't seem right.

any appreciated.

td

update: able preserve double-quoted column names across call psql original issue of passing clause in single quotes. solution below:

found hint here: keeping double quotes when passing string popen in c

psqlcmd = 'psql -u choa -d iondb -t -c '  sql = "\"select id, experiment_id, \\\"resultsname\\\" rundb_results status '%completed%' , id > 5;\""  print(psqlcmd) print(sql)  ssh = subprocess.popen(['ssh', 'me@server', psqlcmd, sql],                        shell=false,                        stdout=subprocess.pipe,                        stderr=subprocess.pipe) result = ssh.stdout.readlines()

i've tried reproduce , managed on shell, doing through python mess. i'll show findings incase helps solve problem.

notice difference double quotes on outside of select statement.

you need either escape set of single quotes, or change double quotes , escape set of double quotes.

[root@server tmp]# /opt/rh/postgresql/bin/psql -d database -u user -c 'select * control option_name '%manage%';' error:  syntax error @ or near "%" line 1: select * control option_name %manage%;                                                      ^   [root@server tmp]# /opt/rh/postgresql/bin/psql -d database -u user -c "select * control option_name '%manage%';"  option_name  | status  --------------+--------  manage_ntpd  | false  manage_dhcp4 | false  manage_dhcp6 | false  manage_named | false (4 rows)




wiki

Comments

Post a Comment

Popular posts from this blog

python - Read npy file directly from S3 StreamingBody -

-
i have many .npy (numpy) , .json files saved in s3, need download , load these files. for json files downloading files , loading dictionary using following code: obj = s3.object(bucket, key) response = obj.get() body = response['body'].read().decode('utf-8') data = json.loads(body) that way avoid writing .json file disk , reading it. now want same .npy files, equivalent? currently downloading file, saving temp file on disk , loading np.load avoid if possible. following https://stackoverflow.com/a/28196540/3509999 : obj = s3.object(bucket, key) io.bytesio(obj.get()["body"].read()) f: # rewind file f.seek(0) arr = np.load(f) wiki
Read more

python - Minimize function with Scipy minimize -

-
trying obtain d value (integer) std_diff objective function minimal, using scipy minimize. my code: def std_diff(d): return std(diff(df['bn'].values,d)); scipy.optimize import minimize b=(3,) res = minimize(std_diff,(1,), method='slsqp', bounds = b) **df['bn'].values** out[72]: array([ 2, 2, 2, 2, 3, 2, 7, 5, 7, 11, 8, 2, 11, 7, 15, 8, 7, 12, 21, 19, 32, 35, 40, 35, 21, 19, 25, 20, 40, 80, 99], dtype=int64) error is"indexerror: many indices array " in case not use bounds : res = minimize(std_diff,(1,), method='slsqp'), error: > in _minimize_slsqp(func, x0, args, jac, bounds, constraints, maxiter, > ftol, iprint, disp, eps, callback, **unknown_options) > 368 fx = float(np.asarray(func(x))) > 369 except: > --> 370 raise valueerror("objective function must return scalar") > 371 # compute constraints > 3
Read more

kotlin - Out-projected type in generic interface prohibits the use of metod with generic parameter -

-
i start using kotlin , defined interface this: interface aadapter<vh : recyclerview.viewholder> { fun oncreateaviewholder(parent: viewgroup): vh fun onbindaviewholder(v: vh, position: int) } and when try use on code: class klasa ( private val adapter: aadapter<*> ) { fun dosth(){ //... val vh = this.adapter.oncreateaviewholder(parent) //on below line error adapter.onbindaviewholder(v, position) //... } } i error out-projected type 'aadapter<*>' prohibits use of 'public abstract fun onbindaviewholder(v: t, position: int): unit i tied add "in" or "out" definition i'm confused. how allow it. replace aadapter<*> aadapter<recyclerview.viewholder> . class klasa ( private val adapter: aadapter<recyclerview.viewholder> ) { // ... because have declared aadapter has type parameter vh type subclass of recyclerview.
Read more