Log output from database scripts need improved, they're giving false information

[boc-the-git]

Take this for instance:

PinePods/startup/setuppostgresdatabase.py

Lines 136 to 151 in b098f85

	logging.info("Creating EmailSettings table...")
	try:
	cursor.execute("""
	CREATE TABLE IF NOT EXISTS "EmailSettings" (
	EmailSettingsID SERIAL PRIMARY KEY,
	Server_Name VARCHAR(255),
	Server_Port INT,
	From_Email VARCHAR(255),
	Send_Mode VARCHAR(255),
	Encryption VARCHAR(255),
	Auth_Required BOOLEAN,
	Username VARCHAR(255),
	Password VARCHAR(255)
	)
	""")
	logging.info("EmailSettings table created successfully.")

It tells me on every container start that it has created the table, when in fact it hasn't.

Some other examples (not an exhaustive list!):

PinePods/startup/setuppostgresdatabase.py

Lines 188 to 193 in b098f85

	cursor.execute("""
	INSERT INTO "Users" (Fullname, Username, Email, Hashed_PW, IsAdmin)
	VALUES (%s, %s, %s, %s, %s)
	ON CONFLICT (Username) DO NOTHING
	""", ('Background Tasks', 'bt', 'inactive', hashed_password, False))
	logging.info("Added new 'bt' user.")

PinePods/startup/setuppostgresdatabase.py

Line 265 in b098f85

logging.info("created default admin.")

PinePods/startup/setuppostgresdatabase.py

Lines 347 to 356 in b098f85

	try:
	cursor.execute("""CREATE TABLE IF NOT EXISTS "UserSettings" (
	UserSettingID SERIAL PRIMARY KEY,
	UserID INT UNIQUE,
	Theme VARCHAR(255) DEFAULT 'nordic',
	FOREIGN KEY (UserID) REFERENCES "Users"(UserID)
	)""")
	except Exception as e:
	print(f"Error adding UserSettings table: {e}")
	logging.info("created UserSettings table.")

[madeofpendletonwool]

You're absolutely right. Lot of this is leftover remnants from testing. I went ahead and cleaned it all up. Messaged output from startup should be much more clear now in #232. This will release as part of 0.6.4