old_contents: import os
  import datetime
  import time
  from models import checkin, metadata
  from sqlalchemy import create_engine, MetaData
  
  # Generates the variables used later
  engine = create_engine('sqlite:///checkins.db')
  
  #TODO: get the name associated with cardnumber from API
  def returnName(numb):
  	#Temp name until API is in place
  	name = "Onliner"
  	return name
  
  # Connects and safely creates the DB if it doesn't exist
  try:
  	conn = engine.connect()
  	metadata.create_all(engine)
  
  except:
  	print("Oooops. Something went wrong while connecting to the database, is it up?")
  
  
  number = ""
  dateNow = datetime.datetime.now()
  firstWatch = dateNow.replace(hour=8, minute=0, second=0, microsecond=0)
  lastWatch = dateNow.replace(hour=14, minute=0, second=0, microsecond=0)
  # Main program that loops
  while (number != 'exit'):
  	print ("Scan Card:")
  
  	# Gets input from card-reader
  	number = str(input())
  
  	if ((dateNow < firstWatch ) or (dateNow > lastWatch)):
  		print ("\nNot within watchhours. Checkin not registered")
  		continue
  
  	if (number.isdigit() and (len(number) > 6)):
  		# Uses function to get name from API
  		username = returnName(number)
  
  		# Gets current date and trims it down to relevant size
  		tempdate = datetime.datetime.now()
  		date = str(tempdate.weekday()) + ':' + str(tempdate.hour) + ':' + str(tempdate.minute) + ':' + str(tempdate.day) + ':' + str(tempdate.month)
  
  		# Formats name for later use in watchreporter PS: Uses first and last name. Will add exception handling later
  		tempName = username.split(' ')
  		username = (tempName[0] + " " + tempName[(len(tempName) - 1)])
  
  		# Generates an SQL-query
  		ins = checkin.insert().values(name = username, cardnumber = number, time = date)
  
  		# Executes the SQL-query
  		try:
  			result = conn.execute(ins)
  		except:
  			print("Something went wrong writing to the database. Your check-in was not registered")
  			continue
  
  		print("You are checked in. Console will reset in 10 seconds")
  
  		# Waits and then clears the console
  		time.sleep(10)
  		os.system('cls' if os.name == 'nt' else 'clear')
  
  	else:
  		print('Did not recognize card-number. Scan again')
  
new_contents: import os
  import datetime
  import time
  from models import checkin, metadata
  from sqlalchemy import create_engine, MetaData
  
  # Generates the variables used later
  engine = create_engine('sqlite:///checkins.db')
  
  #TODO: get the name associated with cardnumber from API
  def returnName(numb):
  	#Temp name until API is in place
  	name = "Onliner"
  	return name
  
  # Connects and safely creates the DB if it doesn't exist
  try:
  	conn = engine.connect()
  	metadata.create_all(engine)
  
  except:
  	print("Oooops. Something went wrong while connecting to the database, is it up?")
  
  
  number = ""
  dateNow = datetime.datetime.now()
  firstWatch = dateNow.replace(hour=8, minute=0, second=0, microsecond=0)
  lastWatch = dateNow.replace(hour=14, minute=0, second=0, microsecond=0)
  # Main program that loops
  while (number != 'exit'):
  	print ("Scan Card:")
  
  	# Gets input from card-reader
  	number = str(input())
  
  	if ((dateNow < firstWatch ) or (dateNow > lastWatch)):
  		print ("\nNot within watchhours. Checkin not registered")
  		time.sleep(2)
  		os.system('cls' if os.name == 'nt' else 'clear')
  		continue
  
  	if (number.isdigit() and (len(number) > 6)):
  		# Uses function to get name from API
  		username = returnName(number)
  
  		# Gets current date and trims it down to relevant size
  		tempdate = datetime.datetime.now()
  		date = str(tempdate.weekday()) + ':' + str(tempdate.hour) + ':' + str(tempdate.minute) + ':' + str(tempdate.day) + ':' + str(tempdate.month)
  
  		# Formats name for later use in watchreporter PS: Uses first and last name. Will add exception handling later
  		tempName = username.split(' ')
  		username = (tempName[0] + " " + tempName[(len(tempName) - 1)])
  
  		# Generates an SQL-query
  		ins = checkin.insert().values(name = username, cardnumber = number, time = date)
  
  		# Executes the SQL-query
  		try:
  			result = conn.execute(ins)
  		except:
  			print("Something went wrong writing to the database. Your check-in was not registered")
  			continue
  
  		print("You are checked in. Console will reset in 10 seconds")
  
  		# Waits and then clears the console
  		time.sleep(10)
  		os.system('cls' if os.name == 'nt' else 'clear')
  
  	else:
  		print('Did not recognize card-number. Scan again')
  
subject: clear settings added