U
    [Mh	                     @   s0  d Z ddlmZmZ ddlmZ ddlZddlZed edZ	e
d zee	Ze Ze
d ed	ZeeZe Zese
d
 ed e
d eD ]@Ze
ded  ded  ded dkrdnd ded   qedZeeZe Ze
de  edkrvedZeeZe Ze
d eD ]6Ze
ded  ded  ded  ded   q>e
d ded  Ze
d! e
d" e
d! e
d# e
d$e  e
d! e
d% e
d& e
d' e
d( e
d) W 5 Q R X W n2 ek
r* Z  ze
d*e   W 5 dZ [ X Y nX dS )+z0
Debug your developers table and create a token
    )create_enginetext)load_dotenvNz
.env.localDATABASE_URLu"   🔍 Debugging developers table...u)   📋 Checking developers table structure:z
            SELECT column_name, data_type, is_nullable, column_default
            FROM information_schema.columns 
            WHERE table_name = 'developers'
            ORDER BY ordinal_position
        u    ❌ No 'developers' table found!   zAvailable columns:z   - z (z) -    ZYESZNULLzNOT NULLz - Default:    zSELECT COUNT(*) FROM developersu#   
📊 Current developers in table: zBSELECT id, name, email, active, created_at FROM developers LIMIT 3zSample data:z	   - ID: z, Name: z	, Email: z
, Active: u   
🔑 Creating test token...ZAWToken_    z<============================================================u   🎉 TEST REGISTRATION DATA:zName: Test DeveloperzToken: u   📋 Instructions:z%1. Start your backend: python main.pyz22. Visit: http://localhost:8000/register-developerz!3. Enter the name and token abovez4. Try registration!u   ❌ Error: )!__doc__Z
sqlalchemyr   r   Zdotenvr   osZsecretsgetenvr   printZengineZconnectZconnZcolumns_queryZexecuteresultZfetchallcolumnsexitcolZcount_queryZcount_resultZscalarZ
total_devsZsample_queryZsample_resultZsample_datarowZtoken_urlsafetoken	Exceptione r   r   ./debug_table.py<module>   s\   

>


4