#!/usr/bin/env python

import Adafruit_DHT
import psycopg2
from time import strftime

DHT_MODEL = 11
GPIO = 4

humidity, temperature = Adafruit_DHT.read_retry(DHT_MODEL, GPIO)

insert = ('INSERT INTO week_temp (temp, humidity, time) VALUES
          ({:.0f}, {:.0f}, \'{}\'::timestamp);'
          .format(temperature, humidity, strftime('%Y-%m-%d %H:%M:')))

try:
    connect = psycopg2.connect(database='db_name', user='user_name',
                               host='ip_addr', password='passwd')

    cursor = connect.cursor()
    cursor.execute(insert)
    connect.commit()
    connect.close()
except:
    pass