U YHg@sxddlmZddlmZddlmZmZmZddlm Z ddl m Z ddl m Z GdddeZGd d d e ejZd S) )absolute_import) BaseQuery) app_loggerdbdb_model) replace_chars)TimestampMixin)ContentVersionc@s$eZdZddZddZddZdS) ContentQuerycCs|tj|kSN)filterContentidfirst)self content_idr0/var/www/dostadmin/dostadmin/db_model/content.pyget_content_with_id sz ContentQuery.get_content_with_idcCs|Sr )allrrrrget_content_log szContentQuery.get_content_logcCs&|tjt|k}|r"|jSdSr )r r namerrr)r content_namecontentrrrfind_content_id_with_namesz&ContentQuery.find_content_id_with_nameN)__name__ __module__ __qualname__rrrrrrrr sr c@seZdZdZeZejejddZ eje ddddZ eeje dZ eje dddZejd dd d Zejd dd d Zejdddd Zejdddd ZddZeddZdS)r rT) primary_key2F)uniquenullableztopic.id)r"Campaignz!Content.id == Campaign.content_id)backref primaryjoin Programseqz#Content.id == Programseq.content_idProviderNumberz'Content.id == ProviderNumber.content_idr z'Content.id == ContentVersion.content_idcCsdt|jd|jS)NZContent_ )strrrrrrr__repr__3szContent.__repr__c Cs|D]}td|d}d}z4t|d}t|d}t|d}t|d}WnPtk r}z2|rtd||d|}n|}WYqW5d}~XYnXztjjj |d} WnVtk r}z6|rtd ||d |}nd |}WYqW5d}~XYnXt |d } t j | t j | jrz0t| j| ||d dd} t j | t j Wqtk r}ztd|W5d}~XYqXq|S)Nzadding content %srz5Exception occurred while adding new contents. Error: z, )Zip_namezNException occurred while fetching language id for adding new contents. Error: z, No language named: zNo language named: )ractiveg?)r language_id exotel_appid duration_secsstatusversionz@Exception occurred while adding content version. Error message: )rinforint ExceptionerrorrLanguagequeryfind_language_id_with_namer rsessionaddcommitrr ) clsrcerrorsrr1r0languageer/Z content_recZcontent_version_recrrradd_new_contents6sb          zContent.add_new_contentsN)rrr __tablename__r query_classrColumnIntegerrStringr ForeignKeyZtopic_idtype relationship campaigns programseqprovidernumbercontent_versionr* classmethodrCrrrrr s:r N) __future__rflask_sqlalchemyr dostadminrrrutils.helpers.helpersrdostadmin.mixinsrZ"dostadmin.db_model.content_versionr r Modelr rrrrs