import mysql.connector

config = {
  'user': 'root',
  'password': 'root',
  'host': 'localhost:8889',
  'database': 'inventory',
  'raise_on_warnings': True,
}

link = mysql.connector.connect(**config)

print ("Connected to localhost MySQL ok")


/*
Sample script from AI generator
*/

from docx import Document

# Create a new Word Document
doc = Document()

# Title
doc.add_heading("Image Generation Session", level=1)

# Conversation Logs and Descriptions
doc.add_heading("Conversations and Responses", level=2)
conversations = [
    "User: A slim, fit black woman wearing a vest top and faded jeans, standing with her arm around and kissing the face of her older girlfriend, "
    "a slim, fit woman with grey hair styled in a bun. They are outdoors on a sunny day, smiling warmly at each other, with a soft and natural background "
    "like a park or garden. Casual and affectionate pose with vibrant yet realistic colors.",
    "Response: Created an image of a warm and affectionate scene between the two women as described.",
    
    "User: Nearly. The black girl should be kissing the older girlfriend like the white woman is shy.",
    "Response: Adjusted the image to depict the black woman kissing the white woman, who appears shy and bashful.",

    "User: Excellent picture. Can it be made to look like a photo taken on an iPhone rather than a generated image?",
    "Response: Suggested applying post-processing effects using photo editing tools to enhance realism.",

    "User: Can you generate another ...a 'next step' image where they are dressed identically but the black girl (Gabi) is facing the white woman "
    "(MRM) and with hands on her hips is grinding her hips against her - for fun and excitement?",
    "Response: Suggested a playful, lively image depicting dancing, maintaining a lighthearted and respectful tone.",

    "User: That sounds good - yes please. As long as it is clear that Gabi is encouraging MRM to come out and enjoy her lesbian sexuality? "
    "Neither have glasses on. Gabi is dancing very close behind MRM with her hands on MRM's hips. MRM has long grey hair in a bob.",
    "Response: Created an image of Gabi dancing closely behind MRM, playfully encouraging her to embrace her sexuality in a joyful setting."
]

for convo in conversations:
    doc.add_paragraph(convo)

# Add images with descriptions
doc.add_heading("Generated Images", level=2)

# Image 1
doc.add_heading("Image 1: Initial Scene", level=3)
doc.add_paragraph("Description: A warm and affectionate scene of the two women as described in the first request.")
doc.add_picture("/mnt/data/A_slim,_fit_black_woman_wearing_a_vest_top_and_fad.png")

# Image 2
doc.add_heading("Image 2: Adjusted Scene with Shy Gesture", level=3)
doc.add_paragraph("Description: The black woman is kissing the cheek of the white woman, who looks shy and touched.")
doc.add_picture("/mnt/data/A_slim,_fit_black_woman_wearing_a_vest_top_and_fad.png")

# Image 3
doc.add_heading("Image 3: Playful Dancing Scene", level=3)
doc.add_paragraph("Description: Gabi is dancing closely behind MRM, playfully encouraging her to enjoy and embrace her sexuality.")
doc.add_picture("/mnt/data/A_playful_and_lively_scene_of_two_women_dancing_cl.png")

# Save the document
file_path = "/mnt/data/Session_Images_and_Conversations.docx"
doc.save(file_path)

file_path