from datetime import datetime

# Current date in the format used in the file (e.g., "4/30/2025 12:00")
current_date = datetime.now().strftime("%-m/%-d/%Y %H:%M")

# Sample list of 100 Italian female names with meanings
italian_female_names = [
    ("Alessia", "Defender or helper of mankind."),
    ("Bianca", "White or fair."),
    ("Chiara", "Bright or clear."),
    ("Donatella", "Given by God."),
    ("Elisabetta", "God is my oath."),
    ("Francesca", "Free one."),
    ("Giulia", "Youthful."),
    ("Isabella", "God is my oath."),
    ("Lucia", "Light."),
    ("Marcella", "Warlike."),
    ("Noemi", "Pleasantness."),
    ("Ornella", "Flowering ash tree."),
    ("Paola", "Small or humble."),
    ("Raffaella", "God has healed."),
    ("Serena", "Calm or peaceful."),
    ("Tatiana", "Fairy queen."),
    ("Valentina", "Strong and healthy."),
    ("Zita", "Seeker or little girl."),
    ("Vittoria", "Victory."),
    ("Ginevra", "White phantom."),
    ("Camilla", "Attendant for a temple."),
    ("Annalisa", "Graced with God's bounty."),
    ("Carlotta", "Free woman."),
    ("Elettra", "Shining or bright."),
    ("Fiorella", "Little flower."),
    ("Gemma", "Gem or jewel."),
    ("Ilaria", "Cheerful or happy."),
    ("Ludovica", "Famous in war."),
    ("Mariella", "Little Mary."),
    ("Nerina", "Sea nymph."),
    ("Ottavia", "Eighth-born."),
    ("Prisca", "Ancient."),
    ("Romina", "From Rome."),
    ("Sabrina", "Legendary princess."),
    ("Tiziana", "Honored or blessed."),
    ("Violetta", "Little violet."),
    ("Aria", "Melody or air."),
    ("Bruna", "Brown-haired."),
    ("Celestina", "Heavenly."),
    ("Diletta", "Beloved."),
    ("Emanuela", "God is with us."),
    ("Flavia", "Golden or blonde."),
    ("Gaia", "Joyful."),
    ("Imelda", "Universal battle."),
    ("Lia", "Bearer of good news."),
    ("Milena", "Gracious."),
    ("Nicoletta", "Victory of the people."),
    ("Olga", "Holy or blessed."),
    ("Piera", "Rock or stone."),
    ("Renata", "Reborn."),
    ("Silvana", "Of the forest."),
    ("Teresa", "Harvester."),
    ("Ursula", "Little bear."),
    ("Viola", "Violet flower."),
    ("Angela", "Messenger of God."),
    ("Beatrice", "Bringer of joy."),
    ("Claudia", "Lame or enclosure."),
    ("Diana", "Divine or heavenly."),
    ("Elda", "Warrior."),
    ("Felicita", "Happiness."),
    ("Gloria", "Glory."),
    ("Irene", "Peace."),
    ("Letizia", "Joy or happiness."),
    ("Manuela", "God is with us."),
    ("Nadia", "Hope."),
    ("Oriana", "Golden or dawn."),
    ("Patrizia", "Noble."),
    ("Rita", "Pearl."),
    ("Simona", "Heard by God."),
    ("Teodora", "Gift of God."),
    ("Vanessa", "Butterfly."),
    ("Zelinda", "Shield of victory."),
    ("Assunta", "Taken up."),
    ("Benedetta", "Blessed."),
    ("Carla", "Strong woman."),
    ("Desideria", "Desired one."),
    ("Emilia", "To strive or excel."),
    ("Fabiola", "Bean grower."),
    ("Grazia", "Grace."),
    ("Ida", "Industrious one."),
    ("Lavinia", "Woman of Rome."),
    ("Matilde", "Mighty in battle."),
    ("Nives", "Snow."),
    ("Palmira", "City of palms."),
    ("Quirina", "Spear or warrior."),
    ("Rosalia", "Rose."),
    ("Stefania", "Crown or garland."),
    ("Tonia", "Invaluable."),
    ("Veronica", "Bringer of victory."),
    ("Adriana", "Dark one."),
    ("Bettina", "God is my oath."),
    ("Cecilia", "Blind."),
    ("Domenica", "Belonging to the Lord."),
    ("Eugenia", "Well-born."),
    ("Filomena", "Lover of strength."),
    ("Gilda", "Sacrifice or value."),
    ("Ines", "Chaste or pure."),
    ("Lelia", "Well-spoken."),
    ("Margherita", "Daisy."),
    ("Nicole", "Victory of the people."),
    ("Ondina", "Little wave."),
    ("Prisilla", "Ancient."),
    ("Rina", "Joyful song."),
    ("Sofia", "Wisdom."),
    ("Tilde", "Powerful in battle."),
    ("Ylenia", "Light."),
]

# Create SQL insert strings
insert_statements = []
start_sno = 10001  # Start from a higher S.No to avoid conflicts

for i, (name, meaning) in enumerate(italian_female_names):
    sno = start_sno + i
    sql_row = f"({sno}, '{name}', '{meaning}', 'Italian', 'female', 'FALSE', '', '{current_date}', '', 0, 0)"
    insert_statements.append(sql_row)

# Combine into one SQL INSERT statement
full_sql_insert = "INSERT INTO `babynames` (`sno`, `name`, `meaning`, `origin`, `sex`, `celebrity`, `shortmeaning`, `regdate`, `unisex`, `views`, `popcnt`) VALUES\n" + ",\n".join(insert_statements) + ";"

# Display a preview
full_sql_insert[:2000]  # Show only first part for preview
