<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.1/jquery.min.js">
</script>
//var data = 10;
//var data_list=['hoge','geho];
function get_data(data, data_list){
var request = {
data1 : data,
data2 : data_list
};
$.ajax({
url: 'get_data.py',
type: 'POST',
data: JSON.stringify(request)
})
.done(function(data){
result = JSON.parse(data);
for (i=0;i<result.length;i++){
console.log(result[i][0]);
}
})
.fail(function(){
console.log('failed');
});
};
import sys
import json
import psycopg2
# connect postgreSQL
users = 'postgres'
dbnames = 'postgres'
passwords = '*******'
conn = psycopg2.connect(" user=" + users +" dbname=" + dbnames +" password=" + passwords)
cur = conn.cursor()
# index.Get the data skipped from html
recieve = sys.stdin.read()
params = json.loads(recieve)
data = params["data1"]
data_list = params["data2"]
#Create and execute SQL statement
sql = 'select data from dataTbale where (AAA = data) and ((BBB = data_list[0]) or (BBB = data_list[1]))'
cur.execute(sql)
results = cur.fetchall()
conn.commit()
#Clean up
cur.close()
conn.close()
# index.Notify html side
print('Content-type: text/html\n')
print(json.dumps(results))
Recommended Posts