Ajax + Python + PostgreSQL sample

Introduction

• Sample to get data from database and create dynamic web page

sample

• index.html

<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');
  });
};

• get_data.py

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))