Sweep: Migrate ohno/todo.py to sqlite from existing approach of .txt file

[AnkitmB125]

[sweep-ai-deprecated]

Hey @AnkitmB125,

I've started working on this issue. The plan is to migrate the current file-based storage system in ohno/todo.py to a SQLite database. This will involve creating a new SQLite database, updating the append_to_do, delete_to_do, and get_to_do_list_from_file functions to interact with the SQLite database, and handling exceptions properly.

Give me a minute!

Some code snippets I looked at (click to expand). If some file is missing from here, you can mention the path in the ticket description.

ohno/ohno/main.py

Lines 1 to 56 in 1d3e10e

	import os
	import subprocess
	import re
	import sys
	import requests
	from bs4 import BeautifulSoup
	import urllib
	from ohno.gui import *
	import tkinter as tk
	from tkinter import ttk
	import json
	GREEN = '\033[92m'
	GRAY = '\033[90m'
	CYAN = '\033[36m'
	RED = '\033[31m'
	YELLOW = '\033[33m'
	END = '\033[0m'
	UNDERLINE = '\033[4m'
	BOLD = '\033[1m'
	def confirm():
	option = {"yes": True, "y": True, "no": False, "n": False, "": True}
	while True:
	print(BOLD + YELLOW + "\nDo you want to search StackOverflow? [Y/N] " + END, end='')
	choice = input().lower()
	if choice in option:
	return option[choice]
	print("Please respond with ('yes' or 'no') or ('y' or 'n').\n")
	# returns compiler
	def get_lang(File_Path):
	if File_Path.endswith(".py"):
	return "python3 "
	elif File_Path.endswith(".cpp"):
	return "g++ "
	elif File_Path.endswith(".java"):
	return "javac "
	elif File_Path.endswith(".c"):
	return "gcc "
	elif File_Path.endswith(".js"):
	return "rhino "
	else:
	return None
	# prints help
	def print_help():
	print("%sNAME%s\n\tOhno\n"%(BOLD,END))
	print("%sSYNOPSIS%s\n\t%sohno%s %s[%sfile_name]%s\n" % (BOLD, END,BOLD, END, YELLOW,UNDERLINE,END))
	print("\t%sohno%s -q %s[%scustom_query]%s\n"%(BOLD, END, YELLOW,UNDERLINE,END) )
	print("\t%sohno%s --query %s[%scustom_query]%s\n"%(BOLD, END, YELLOW,UNDERLINE,END) )
	print("\t%sohno%s -g %s[%scode_name]%s\n"%(BOLD, END, YELLOW,UNDERLINE,END) )
	print("\t%sohno%s --gfg %s[%scode_name]%s\n"%(BOLD, END, YELLOW,UNDERLINE,END) )

ohno/requirements.txt

Lines 1 to 14 in 1d3e10e

	beautifulsoup4==4.7.1
	certifi==2018.11.29
	chardet==3.0.4
	EasyProcess==0.2.5
	idna==2.8
	lxml==4.3.0
	python-dateutil==2.7.5
	PyVirtualDisplay==0.2.1
	requests==2.21.0
	selenium==3.141.0
	six==1.12.0
	soupsieve==1.6.2
	urllib3==1.24.2
	pyxhook==1.0.0

ohno/README.md

Lines 1 to 23 in 1d3e10e

	# ohno
	A full utility command line tool for a programmer that helps save time and memory which are most important while coding.
	It searches **stackoverflow** when an error is encountered while executing the program and displays the full results without opening the browser thus saving time and effort to copy-paste the error and then searching it.
	If a user wants a custom query on stackoverflow, he can easily do it too.
	If a user wants to refer to an algo or code, it can be done from the command line itself.
	As a user doesn't have all the compilers installed in his system, **ohno** compiles various less-known languages and displays the result in the terminal.
	A coding calender is provided in which competitive programmers can check details of upcoming contests on different platforms and plan their strategy using the **todo** utility.
	While coding in a contest or just practicing, a user can directly submit codes on **spoj** and **codechef** with just the ID of the code. This saves a lot of time and effort as he doesn't have to open the browser and submit the code manually.
	## Requirements
	* python3
	* pip
	## Installation

ohno/ohno/test/input.txt

Line 1 in 1d3e10e

5

https://github.com/AnkitmB125/ohno/blob/1d3e10e50fb782c6270e5b28fc582641e2e4be69/ohno/todo.py#L1-L189

---

I'm a bot that handles simple bugs and feature requests but I might make mistakes. Please be kind!