old_contents: #!/usr/bin/env python3
  
  import click
  import sqlite3
  import signal
  import sys
  import sched
  import time
  import uuid
  import datetime
  import Adafruit_DHT
  from pylepton import Lepton
  from skimage import io
  
  DATABSE_NAME = 'sessions.db'
  conn = sqlite3.connect(DATABSE_NAME)
  cursor = conn.cursor()
  sensor = Adafruit_DHT.DHT22
  pin = 4
  
  @click.group()
  def cli():
      pass
  
  @cli.command()
  def initdb():
      cursor.execute('''CREATE TABLE readings
                   (session_id text, date date, subject_type integer, car_id integer, temp real, image_name text)''')
      click.echo('Initialized the database')
  
  @cli.command()
  @click.option(
      '--subject-type',
      prompt='What type of subject? (none/adult/child/pet)',
      type=click.Choice(['none', 'adult', 'child', 'pet']),
      default='adult')
  @click.option(
      '--car-id',
      prompt='What is the car id?',
      type=int,
      default=1)
  def record(subject_type, car_id):
      click.echo('Session info collected')
      blah = raw_input('\nPress enter to start collecting data\n')
      click.echo('Collecting data...')
      collect_data(subject_type, car_id)
  
  def collect_data(subject_type, car_id):
      signal.signal(signal.SIGINT, end_collection)
  
      session_id = str(uuid.uuid4())
  
      s = sched.scheduler(time.time, time.sleep)
      s.enter(1, 1, collect_sample, (s,conn,cursor,session_id,subject_type,car_id))
      s.run()
  
  def collect_sample(sc,conn,cursor,session_id,subject_type,car_id):
      click.echo('Recording sample')
  
      now = datetime.datetime.now()
      image_name = '{}_{}.png'.format(session_id, now)
  
      with Lepton() as l:
          frame,_ = l.capture()
          io.imsave('image_data/{}', image_name, frame)
  
      _, temperature = Adafruit_DHT.read(sensor, pin)
  
      if temperature is None:
  	    click.echo('Failed to get temperature reading.')
  
      cursor.execute("INSERT INTO project VALUES (?, ?, ?, ?, ?, ?)",(session_id, now, subject_type, car_id, temperature, image_name))
      conn.commit()
      sc.enter(1, 1, collect_sample, (sc,conn,cursor))
  
  def end_collection(signal, frame):
      click.echo('Data collection ended')
      conn.close()
      sys.exit(0)
  
  if __name__ == '__main__':
      cli()
  
new_contents: #!/usr/bin/env python3
  
  import click
  import sqlite3
  import signal
  import sys
  import sched
  import time
  import uuid
  import datetime
  import Adafruit_DHT
  from pylepton import Lepton
  from skimage import io
  
  DATABSE_NAME = 'sessions.db'
  conn = sqlite3.connect(DATABSE_NAME)
  cursor = conn.cursor()
  sensor = Adafruit_DHT.DHT22
  pin = 4
  
  @click.group()
  def cli():
      pass
  
  @cli.command()
  def initdb():
      cursor.execute('''CREATE TABLE readings
                   (session_id text, date date, subject_type integer, car_id integer, temp real, image_name text)''')
      click.echo('Initialized the database')
  
  @cli.command()
  @click.option(
      '--subject-type',
      prompt='What type of subject? (none/adult/child/pet)',
      type=click.Choice(['none', 'adult', 'child', 'pet']),
      default='adult')
  @click.option(
      '--car-id',
      prompt='What is the car id?',
      type=int,
      default=1)
  def record(subject_type, car_id):
      click.echo('Session info collected')
      blah = raw_input('\nPress enter to start collecting data\n')
      click.echo('Collecting data...')
      collect_data(subject_type, car_id)
  
  def collect_data(subject_type, car_id):
      signal.signal(signal.SIGINT, end_collection)
  
      session_id = str(uuid.uuid4())
  
      s = sched.scheduler(time.time, time.sleep)
      s.enter(1, 1, collect_sample, (s,conn,cursor,session_id,subject_type,car_id))
      s.run()
  
  def collect_sample(sc,conn,cursor,session_id,subject_type,car_id):
      click.echo('Recording sample')
  
      now = datetime.datetime.now()
      image_name = '{}_{}.png'.format(session_id, now)
  
      with Lepton() as l:
          frame,_ = l.capture()
          io.imsave('image_data/{}', image_name, frame)
  
      _, temperature = Adafruit_DHT.read(sensor, pin)
  
      if temperature is None:
  	    click.echo('Failed to get temperature reading.')
  
      cursor.execute("INSERT INTO readings VALUES (?, ?, ?, ?, ?, ?)",(session_id, now, subject_type, car_id, temperature, image_name))
      conn.commit()
      sc.enter(1, 1, collect_sample, (sc,conn,cursor))
  
  def end_collection(signal, frame):
      click.echo('Data collection ended')
      conn.close()
      sys.exit(0)
  
  if __name__ == '__main__':
      cli()
  
subject: save to correct table