recruto / test_insert.py
badarfaisal989u9's picture
Initial deployment
04b8502
Raw History Blame Contribute Delete
1.81 kB
import sys
import os
import uuid
import json
import asyncio
from sqlalchemy import text
from sqlalchemy.ext.asyncio import create_async_engine, AsyncSession
from sqlalchemy.orm import sessionmaker
DATABASE_URL = "mysql+aiomysql://root:Newpassword%40123@127.0.0.1:3306/recruto_mcq"
engine = create_async_engine(DATABASE_URL)
async_session = sessionmaker(engine, class_=AsyncSession, expire_on_commit=False)
async def test():
async with async_session() as db:
candidate_id = f"candidate_{uuid.uuid4()}"
try:
insert_query = text("""
INSERT INTO cv_candidates (
email, name, phone, role, skills, cv_filename, cv_text,
status, skill_match_percentage, cv_source, job_id, raw_text,
experience, education, created_at
) VALUES (
:email, :name, :phone, :role, :skills, :cv_filename, :cv_text,
:status, :skill_match_percentage, :cv_source, :job_id, :raw_text,
:experience, :education, NOW()
)
""")
await db.execute(insert_query, {
"email": "test@test.com",
"name": "Test Name",
"phone": "123",
"role": "Role",
"skills": "[]",
"cv_filename": "Test.pdf",
"cv_text": "text",
"status": "processed",
"skill_match_percentage": 0.0,
"cv_source": "test",
"job_id": None,
"raw_text": "text",
"experience": "[]",
"education": "[]"
})
await db.commit()
print("INSERT WORKS WITHOUT CANDIDATE_ID")
except Exception as e:
print(f"Error: {e}")
asyncio.run(test())