Add Remove line option

[MitkoVtori]

Add option to remove a single line or a bunch of lines in range from file/table...

[MitkoVtori]

Python-ConsoleSQL/ConsoleSQL.py

Lines 171 to 215 in 40e04ca

	def delete_lines(database, path, file_name, *lines):
	'''
	Console command
	DEL TABLE/FILE FileName LINES firstline secondline seventhline
	'''
	if path == "table":
	if os.path.exists(f"databases/{database}/tables/{file_name}.txt"):
	file = [line[:-1] if line[-1] == '\n' else line for line in open(f"databases/{database}/tables/{file_name}.txt", "r")]
	for num, line in enumerate(lines):
	if 0 <= (line+1)-num < len(file):
	file.pop((line+1)-num)
	os.remove(f"databases/{database}/tables/{file_name}.txt")
	f = open(f"databases/{database}/tables/{file_name}.txt", "a+")
	for line in file:
	f.write(f"{line}\n")
	f.close()
	elif path == "file":
	if os.path.exists(f"databases/{database}/files/{file_name}.txt"):
	file = [line[:-1] if line[-1] == '\n' else line for line in open(f"databases/{database}/files/{file_name}.txt", "r")]
	for num, line in enumerate(lines):
	if 0 <= (line - 1) - num < len(file):
	file.pop((line - 1) - num)
	os.remove(f"databases/{database}/files/{file_name}.txt")
	f = open(f"databases/{database}/files/{file_name}.txt", "a+")
	for line in file:
	f.write(f"{line}\n")
	f.close()
	else:
	return Fore.LIGHTWHITE_EX + f"Invalid path name '{path}'"
	return Fore.LIGHTWHITE_EX + "lines removed!"