rilISSKrSSKrSSKrSSKJr \"5 SSKrSSKJr SSKJ r SSK J r \R"\ 5R5RRr\S- S- r\R%SSS 9 \S - r\R("S S 5R+5S ;r\R("S5=(d \R."S5r"SS\ 5r\"\R4R7\SS5S9rSrSrSrSr g)N) load_dotenv)Jinja2Templates) StaticFiles)ResponseappdatabaseT)parentsexist_okz db.sqlite3APP_ENVdev)prod productionAPP_SECRET_KEY@c0^\rSrSrS\4U4SjjrSrU=r$)CachedStaticFilesreturncF>[TU]"U0UD6nSURS'U$)Nz#public, max-age=31536000, immutablez Cache-Control)super file_responseheaders)selfargskwargsresp __class__s 3/home/mario/Escritorio/thel4footbal/app/database.pyrCachedStaticFiles.file_responses*w$d5f5(M _% )__name__ __module__ __qualname____firstlineno__rr__static_attributes__ __classcell__)rs@rrrsr r templates) directorycv[R"[SSS9n[RUlUR S5 UR S5 UR S5 UR S5 UR S5 UR S5 UR S 5 U$![ a U$f=f) NF)isolation_levelcheck_same_threadzPRAGMA foreign_keys = ON;zPRAGMA journal_mode = WAL;zPRAGMA synchronous = NORMAL;zPRAGMA busy_timeout = 5000;zPRAGMA cache_size = -20000;zPRAGMA temp_store = MEMORY;zPRAGMA mmap_size = 268435456;)sqlite3connectDB_PATHRow row_factoryexecute Exception)conns rget_connr5s ??7DE RD{{DLL,-LL-.LL/0LL./LL./LL./  45 K   K sB** B87B8c[5$)N)r5r!r r_connr7.s :r cURSUS35R5Vs1sHo"SiM sn$s snf![a [5s$f=f)NzPRAGMA table_info())r2fetchallr3set)r4tablers r_table_columnsr?1sU"ll-?wa+HIRRTUT!TUUU u s%=8==AAc [5nUR5nURS5 URS5 URS5R5Vs1sHo"SiM nnSU;aURS5 SU;aURS5 S U;aURS 5 S U;aURS 5 URS 5 URS5R5Vs1sHo"SiM nnSU;a#URS5 URS5 URS5 URS5 URS5 URS5 URS5 URS5 URS5 URS5R5Vs1sHo"SiM nnSU;a"URS5 URS5 SU;aURS5 SU;aURS 5 S!U;aURS"5 S#U;aURS$5 S%U;aURS&5 S U;aURS'5 S(U;aURS)5 S*U;aURS+5 S,U;aURS-5 S.U;aURS/5 S0U;aURS15 URS25 URS35R5Vs1sHo"SiM nnS0U;aURS45 URS55 URS65 URS75 URS85 URS95 URS:5 URS;5 URS<5 URS=5 URS>5 URS?5 URS@5 URSA5 [ USB5nSCU;aURSD5 SEU;aURSF5 URSG5 URSH5 [ USI5nSJU;aURSK5 SLU;aURSM5 SNU;aURSO5 URSP5 URSQ5 URSR5 URSS5 URST5 URSU5 URSV5 URSW5 URSX5 URSY5 URSZ5 URS[5 URS\5 URS]5 URS^5 URS_5 UR 5 SSS5 gs snfs snf![a GNf=fs snfs snf!,(df  g=f)`NzPRAGMA foreign_keys=ONa CREATE TABLE IF NOT EXISTS users ( id INTEGER PRIMARY KEY AUTOINCREMENT, email TEXT NOT NULL UNIQUE, name TEXT NOT NULL, first_name TEXT, last_name TEXT, phone TEXT, password_hash TEXT NOT NULL, role TEXT NOT NULL DEFAULT 'alumno', created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%S','now','localtime')) ) zPRAGMA table_info(users)r: first_namez,ALTER TABLE users ADD COLUMN first_name TEXT last_namez+ALTER TABLE users ADD COLUMN last_name TEXTphonez'ALTER TABLE users ADD COLUMN phone TEXTis_mvp90z@ALTER TABLE users ADD COLUMN is_mvp90 INTEGER NOT NULL DEFAULT 0aJ CREATE TABLE IF NOT EXISTS user_profile ( user_id INTEGER PRIMARY KEY, phone TEXT, avatar TEXT, city TEXT, dni TEXT, birth_date TEXT, gender TEXT, FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE ) zPRAGMA table_info(user_profile)genderz/ALTER TABLE user_profile ADD COLUMN gender TEXTa1 UPDATE user_profile SET gender = ( SELECT sexo FROM estadisticas_jugadores WHERE estadisticas_jugadores.user_id = user_profile.user_id ) WHERE gender IS NULL a CREATE TABLE IF NOT EXISTS user_sports ( user_id INTEGER PRIMARY KEY, team TEXT, category TEXT, position TEXT, dominant_foot TEXT, strengths TEXT, weaknesses TEXT, injury_history TEXT, training_type TEXT, FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE ) a CREATE TABLE IF NOT EXISTS user_health ( user_id INTEGER PRIMARY KEY, physical_work INTEGER, physical_work_details TEXT, smoking INTEGER, alcohol INTEGER, recovery TEXT, chest_pain INTEGER, discomfort INTEGER, FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE ) ap CREATE TABLE IF NOT EXISTS user_consent ( user_id INTEGER PRIMARY KEY, whatsapp_content INTEGER, video_permission INTEGER, privacy_acceptance INTEGER, data_confirmation INTEGER, agreement INTEGER, FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE ) a0 CREATE TABLE IF NOT EXISTS user_guardians ( user_id INTEGER PRIMARY KEY, occupation TEXT, study_place TEXT, parent_name TEXT, parent_email TEXT, FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE ) a9 CREATE TABLE IF NOT EXISTS user_marketing ( user_id INTEGER PRIMARY KEY, found_us TEXT, enjoyment TEXT, nerves_confidence TEXT, additional_comments TEXT, FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE ) z CREATE TABLE IF NOT EXISTS user_finance ( user_id INTEGER PRIMARY KEY, matricula_eur REAL NOT NULL DEFAULT 0, FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE ) a CREATE TABLE IF NOT EXISTS reservations ( id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%S','now','localtime')), date TEXT NOT NULL, time TEXT, duration_minutes INTEGER, price_cents INTEGER NOT NULL DEFAULT 0, name TEXT, email TEXT, phone TEXT, notes TEXT, user_id INTEGER, status TEXT NOT NULL DEFAULT 'confirmada', docente_id INTEGER NOT NULL, paid INTEGER NOT NULL DEFAULT 0, FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE SET NULL, FOREIGN KEY(docente_id) REFERENCES users(id) ON DELETE CASCADE ) zPRAGMA table_info(reservations) created_atz3ALTER TABLE reservations ADD COLUMN created_at TEXTzmUPDATE reservations SET created_at = strftime('%Y-%m-%dT%H:%M:%S','now','localtime') WHERE created_at IS NULLtimez-ALTER TABLE reservations ADD COLUMN time TEXTduration_minutesz cols_users cols_profilecols_rescols_rs cols_courses cols_lessonss rinit_dbra7s D KKM *+  %&II.H$I$R$R$TU$Tqd$T U z ) IID E j ( IIC D * $ II? @ Z ' IIX Y  '(ii0Q&R&[&[&]^&]!&] ^ < ' IIG H                  (#$)),M"N"W"W"YZ"YQaD"YZ x ' IIK L IIF G  ! IIE F X - IIT U  ( IIb c  ! IIE F ( " IIF G ( " IIF G ( " IIF G H $ IIK L 8 # IIe f x ' IIa b  ! II[ \  "#+T!U!^!^!`a!`AQ4!`a  IIc d    TU WX ef   " de YZ ]^     "   no   $&d,=>  - IIP Q , . IIQ R     (&d,=> | + IIE F < / IIR S L 0 IIS T     ij gh ij kl op ef ij UV UV UV UV UV UV hi } "V,_  |[Jbo sjAX4X-BX4=X X4%X6BX4X*EX45X/KX4 X4 X'#X4&X'' X44 Y)!r-pathlibosdotenvrsecretsfastapi.templatingrfastapi.staticfilesrfastapirPath__file__resolveparentBASE_DIRDB_DIRmkdirr/getenvlowerIS_PROD token_urlsafe SECRET_KEYrpathjoinr(r5r7r?rar!r rrws  .+ << ! ) ) + 2 2 9 9 E J & TD ) <  ))Iu % + + -1G G YY' ( EG,A,A",E   bggll8UK&P Q   r