
    taj                         d dl Z d dlZd dlmZ ddlmZ  ej                  d      Z G d de j                        Z	 G d d	      Z
y)
    N)get_dynamic_connection   )CreateTeamInputzscheduler.teamc                       e Zd Z G d d      Z ej
                         Z ej                         Z ej                         Z
d Zy)
CreateTeamc                       e Zd Z ed      Zy)CreateTeam.ArgumentsT)requiredN)__name__
__module____qualname__r   input     J/var/www/html/myl_app/scheduler-service/schema/mutations/team_mutations.py	Argumentsr	   	   s    .r   r   c                    |j                   j                  d      }|st        dd      S 	 t        |      5 }|j	                         5 }|j                  d|j                  f       |j                         s-t        dd|j                   d      cd d d        cd d d        S |j                  d|j                  f       |j                         s-t        dd	|j                   d      cd d d        cd d d        S |j                  Z|j                  d
|j                  f       |j                         s-t        dd|j                   d      cd d d        cd d d        S |j                  d|j                  |j                  f       |j                         r:t        dd|j                   d|j                   d      cd d d        cd d d        S |j                  d d }|j                  d|j                  ||j                  |j                  |j                  |j                  t        |j                        nd f       |j                          |j                  }d d d        d d d        t        dd|j                   d      S # 1 sw Y   -xY w# 1 sw Y   1xY w# t        $ r1}t         j#                  d| d       t        dd      cY d }~S d }~ww xY w)Ndb_nameFz%Organisation database not configured.)successmessagez*SELECT id FROM level WHERE id = %s LIMIT 1zDivision ID z not found.z5SELECT rsc_id FROM resource WHERE rsc_id = %s LIMIT 1z	Field ID z9SELECT season_id FROM season WHERE season_id = %s LIMIT 1z
Season ID z>SELECT id FROM team WHERE teamname = %s AND level = %s LIMIT 1zTeam 'z ' already exists in division ID .   a  
                        INSERT INTO team (
                            teamname, abbr, level, homefield, affiliation,
                            year, League_ID, validated, paid_in_full
                        ) VALUES (%s, %s, %s, %s, %s, %s, 1, 1, 0)
                        Tz' created successfully.)r   r   team_idz'Unexpected error during team creation: )exc_infoz;An unexpected database error occurred during team creation.)contextgetr   r   cursorexecutedivision_idfetchonehome_field_id	season_id	team_nameaffiliationstrcommit	lastrowid	Exceptionloggererror)	selfinfor   r   conncurabbr_valr   es	            r   mutatezCreateTeam.mutate   s   ,,""9-e5\]]F	'0 8,D[[] 7,cKK LuO`O`Nbc<<>)$)&253D3D2E[$Q 	7, 7,8, 8, KK WZ_ZmZmYop<<>)$)&/0C0C/DK$P 7, 7,8, 8,& 2$_bgbqbqast"||~#-(-*4U__4E[(Q$+7, 7,8, 8,8 KKX%*;*;< ||~)$)&,U__,==]^c^o^o]ppq$r A7, 7,8, 8,L  %s3HKK "OO$!--!//!--49OO4OC0UY  KKM!mmGo7,8,t   11HI s7, 7,8, 8,~  	LLB1#FQULVU 	s   J% JAJ	J	J% #AJ*	J3	J% =AJ	J	J% #AJ	J	J% BJ!J)#J% J	JJ"J% %	K.&KKKN)r   r   r   r   grapheneBooleanr   Stringr   Intr   r1   r   r   r   r   r      s?    / / h GhooGhllnGKr   r   c                   ,    e Zd Zej	                         Zy)TeamMutationN)r   r   r   r   Fieldcreate_teamr   r   r   r7   r7   ]   s    ""$Kr   r7   )r2   loggingdbr   typesr   	getLoggerr)   Mutationr   r7   r   r   r   <module>r?      sC      % #			+	,S"" Sj% %r   