Ii!gdZddlZddlZddlZddlmZmZmZmZddlm Z ddl m Z ddl m Z mZmZddldZdd Zd d ddddddddddddddddgZgdZddddd dddd d!d"dd#d$d%d&d'dd(d)d*d+d,dd-d.d/d0d1dd2d3d4d5d6dgZd7d8d9d:d;d id d<d=d>d9d:d;d?id"d<d@dAd9dBdCdDid'd<dEdFd9dGdHd1dId,d<dJd&dKdLd;d id1d<dMdNdKdLd;d'id6d<dOdPdQdRdSdTidUd<dVd0dQdRdSd)idWd<dXd+dQdRdSd.idYd<dZd[d9d\d]d'd^d?d<d_d`dKdadbd'idcd<dddedKdfdgd,idhd<didjd9dkd;d'idld<dmdnd9dod;d?idpd<dqdrdKdsidtd<dudvdKdwd;d1idxd<gZdydHd]ddzd{d d|d}gd~ddHdddd{d ddgd~ddHd]ddTdd ddgd~ddHdddd{d ddgd~ddHddTddd ddgd~ddHdddTdd ddgd~ddDddddd dgdddDddddd dgdddDddddd ddgdddDddddd dgddddddd dgddddddd dgdddddTd dgdddddd ddgdddddd ddgdddddd d ddgddddddd d{gdddddddd dddddddd"dddddddd"dddddddd ddddd$d'ddgdddddd'd͜ddddd d͜gZdddddҜdddddҜdddddҜd]ddddҜdddddҜdddddҜddddߜddddߜgZdZedk(rej6eyy)u Demo Data Seeder — Generates realistic data for the AI Adoption Tracker demo. Run: python -m app.seed Creates: 6 departments, 30 employees, 25+ activities, 200+ completions, quizzes, tracked links, sync configs, badges, levels, anomaly flags. N)datedatetime timedeltatimezone)text) AsyncSession) async_sessionengineBase)*cHtjtjS)N)rnowrutc/code/app/seed.pyutcnowrs << %%rZc\tj||}tt|z S)Ndays)randomrandintrr)start_days_ago end_days_agodeltas r random_daters$ NN< 8E 8iU+ ++r Engineeringz'Software engineering and platform teams)name description Marketingz!Brand, growth, and communications Operationsz*Business operations and process excellenceFinancezFinancial planning and analysisHRzPeople and cultureProductzProduct management and design))zSara Al-Mansoorir)z Khalid Rahmanr)z Ahmed Bashirr)z Rania Faroukr)z Yusuf Qasimr)z Noura Saeedr)zTariq Al-Hassanr)z Dina Mahmoudr)z Fatima Hassanr")z Nadia Karimr")z Salim Darwishr")z Huda Nasserr")z Zainab Othmanr")z Omar Yusufr#)z Rami Saeedr#)z Mariam Khalilr#)zFaisal Al-Tamimir#)z Samira Jaberr#)z Layla Noorr$)z Hassan Malikr$)z Aisha Rashidr$)z Bilal Hamdanr$)z Mona El-Aminr%)z Jamal Barakatr%)z Wafa Suleimanr%)z Kareem Haddadr%)z Lina Tahar&)z Ammar Zakariar&)z Rana Ismailr&)z Sami Al-Farsir&Novicez#64748bu🌱)r min_xpcoloricon sort_orderExplorerz#0ea5e9u🔍 Practitioneriz#8b5cf6u⚡Advocatei z#f59e0bu🔥Championiz#ef4444u🏆 Visionaryiz#ec4899u👑z First Stepsu🚀 completionactivities_completedcount)r r*categorycondition_typecondition_valuer+zDedicated Learneru📚 Bookwormu📖category_complete_allr:readingzCourse Collectoru🎓category_countcourse)r:r9Hackerspecialhackathon_countzHackathon Veteranu🏅z Rising Staru⭐xp xp_threshold thresholdi,z AI Champion Trailblazer z Udemy Prou🎯platform_countudemy)platformr9zMulti-Tool Masteru🛠️ multi_tool min_tools zCopilot Power Useru🤖copilot_power_usermin_apps z Quiz Whizu🧠 quiz_perfect zContent Consumeru👀content_consumerz Agent Builderu🏗️ agent_builder Contributoru🤝 contributorz!ChatGPT for Business Productivitybeginnerchatgpt productivity)titler:rOxp_valueestimated_duration_minutes difficulty trust_tiertagszAI Fundamentals for Everyonelinkedin_learninghai fundamentalszPrompt Engineering Mastery intermediateprompts engineeringzAI in Project ManagementxpmzMachine Learning Fundamentalscourseraiadvancedmlz data-sciencezMicrosoft Copilot Deep Divevivacopilotm365DWA AI Strategy 2026 (Slides)internal2strategy)rcr:rOrd xp_open_pctrergrhAI Ethics WhitepaperK-ethicsRAG Architecture Guide (PDF)<(rag architecturezPrompt Library Best Practicesz Intro to Copilot Studio (Stream)videostreamPzcopilot-studio)rcr:rOrdrergrhzBuilding AI Agents TutorialdagentsQ4 2025 AI Hackathon hackathon)rcr:rOrdrgrhPrompt-a-thon February 2026AI Innovation Day Q2 2026 innovationzCopilot in Teams WorkshopworkshopteamszAI for Non-Technical Staffz"Microsoft 365 Copilot Active Usage tool_usage m365_copilotTmonthly)rcr:rOrd is_recurringrecurrence_periodrgzClaude Active UsageclaudezGenSpark Active UsagegensparkzGitHub Copilot Active Usagegithub Google AI Essentials Certificate certificationgooglezPrompt Library Contribution contribution)rcr:rOrdrgzBuilt Copilot Agentagent_creationzMicrosoft 365 Copilotapi)r display_name sync_typesync_interval_minutes purview_auditzMicrosoft Purview Audit Logs viva_learningzMicrosoft Viva LearningzUdemy BusinessizLinkedIn Learninggithub_copilotzGitHub CopilotiGenSpark excel_import)r rrzClaude (Anthropic)cKddlm}|dgd}tj4d{}|j t j jd{|j t j jd{dddd{t4d{}tdi}tD]&}tdi|}|j||||d<(|jd{td tD]}|jt!di||jd{td t"D]'}|jt%di|d d |dd i)|jd{tdi} t't(D]\} \} } | j+dj-} | j+dj-}| d|d}t/dd| z|| || j0| dk(rdn| dkrdnd|j3dd}|j||| | <|jd{tdi}t4D]H}t7di|j9Dcic]\}}|| c}}}|j||||d<J|jd{tdt4Dcgc] }|ddk(s |}}t'|D]\} }||d}t;|j0d | d!zd"d#|j<j-j?d$d%d&|j<d'|j<vrd(nd)|j<vrd*nd+d,tAd-d.tCjDd/d01}|j||jd{td2d3d4d5gd6d!d7d8gd9d!d7d:gd;d!d7gd<d=d>d?gd@d!d7dAgdBdCd7dDgdEd!d7gd<dFdGdHgdId!d7dJgdKd!d7dLgdMd!d7dNgdOd!d7gd<g}|D]r}|jG|dP}|stI|j0|ddQ|dRS}|j||jd{|j0|_%ttdTtM| jO}t4Dcgc]}|jGdUr|}}t4Dcgc]}|jGdUs|}}|D]j}t(Dcgc]\}}||jPk(s|c}}d}|dVvrdWn|dXvrdYndZ}tCjR|tUtW||z[} | D]}!||!d}tCjXd\d]gd^dZg_d}"tAd`d/}#|!jGdad!}$|"d\k(r |jZnd}%|"d\k(r|j\dbkr |jZ}%t_|j0|j0|"|"d\k(rdbntCjDdcdd|#tatCjDd!defz |"d\k(r|#nd|%|$dCkrdgndh|$i }&|j|&mtcdjD]}'tetad.|'zfz jgdk}(|D]}!||!d}dl|!dvrdmndn})tCjR|tUtW||)z[}*|*D]}t_|j0|j0d\dbtAd.|'d!zzd.|'zd!z|jZ|!jGdad!k(rdgndo|!jGdad!|(p }&|j|&|jd{tdq|D]}ddrl4m5}+m6},|jo|,|+jq|+jst^jtdjwt^jx|j0k(t^jzd\k(d{}-|-j}}.|.|_?|jo|,|+jq|+jst^jtdjwt^jx|j0k(t^jzd\k(t^jdCkd{}/|/j}|_AttD]}0|.|0dsk\s |0d|_C|jd{tdtt4Dcgc] }|dduk(s |}1}dvtdwdxdyd\dzd{d|td}dCdcd\d~d{dtd}ddddzd{g}2t'|2D]J\} }3|jG|1| d}td|r |j0ndddd|3}4|j|4L|jd{tdtD]{}5t|5d|5d|5dd|5jGdd|5ddk(r tAdjdnd|5ddk(rdnd|5ddk(rtCjDddnd}6|j|6}|jd{td|jo,tjwtjdk(d{}7|7jj}8|8ddD]}6tcdCD]}9t|6j0tCjgdtAdd!tAdd!tCjDdydtCjDdCdtCjDd/dyd}:|j|:td|tCjDdyd0};|jt|;j0dd|;jPd|jt|;j0dd|;jPd|tCjDd/de}<|d}=|jt||>r|tCjDddc}?t_|?j0|>j0ddbtAddCddhdjd }&|j|&|jd{|jt|&j0|?j0dddtdtcdD] }@tCj|}tCjXgdgd_d}AtCjtM|jO}t|j0|A|Adk(r |j<ndAdk(r*tCjt"Dcgc]}|d c}ndAdk(r*tCjtDcgc]}|d c}nddtAd.d}B|j|B |jd{tdtW|dtWt4dtddddd{y7777#1d{7swYxYw77g7"7 7 cc}}w7 cc}w7 7 cc}wcc}wcc}}w77077,cc}w7h77y7&cc}wcc}w77#1d{7swYyxYww)zMain seed function.r) CryptContextbcryptauto)schemes deprecatedNu🌱 Seeding departments...r u🌱 Seeding levels...u🌱 Seeding badges...r!z Earn the z badgeu🌱 Seeding employees....z@dwa.aezDWA-iadminr6 team_leademployeedemo123T) employee_idemail full_name department_idrole password_hash is_activeu🌱 Seeding activities...rcu🌱 Seeding tracked links...r:r@readr03dz-https://dwa.sharepoint.com/sites/ai-hub/docs/ -z.pdfPDFpdfSlidespptxarticlez AI Adoptionrr}r4) activity_id short_codedestination_urlrc content_typeshared_in_channel shared_at click_countu🌱 Seeding quizzes...zAI Strategy 2026 Quizrzz0What is DWA's primary AI adoption goal for 2026?)z Cost cuttingzEnterprise-wide AI fluencyzReplace all jobsz Build AGI)questionoptions correct_indexz)Which tool is DWA's primary AI assistant?)ChatGPTzMicrosoft CopilotGeminiClaudez'What metric tracks AI adoption success?)z Revenue onlyzActive usage + skill growthzHeadcount reductionz Prompt count)rcactivity questionszAI Ethics Quizrz&What is the main concern with AI bias?)SpeedzUnfair outcomes for groupsCost Complexityz-Who is responsible for ethical AI use at DWA?)zOnly ITz Only legalEveryonezOnly managementr.z-What should you do if AI output seems biased?)z Ignore itzReport and reviewz Use it anywayz Delete itzRAG Architecture QuizrzWhat does RAG stand for?)zRapid AI GenerationzRetrieval Augmented GenerationzReal-time AI GatewayzRandom Answer Generatorz What is the main benefit of RAG?)zFaster trainingz*Grounded responses with less hallucinationz Lower costz Better UIz!What feeds into the RAG pipeline?)zOnly the promptzA vector database of documentszRandom internet datazUser history onlyz&RAG is best suited for which use case?)zImage generationzEnterprise knowledge Q&AzMusic compositionz Video editingrFr)rrcpassing_score_pctru🌱 Seeding completions...r)rr&g?)r"r#gffffff?皙?)k completed in_progressg?)weightsrrgrrrrYrapi_sync self_reported) user_idrstatus progress_pct started_at completed_at xp_awardedsourcergr0z%Y-%mCopilotffffff?g?r) rrrrrrrrg period_keyu🌱 Calculating XP totals...)funcselectr(u!🌱 Seeding hackathon details...rrirRr[r^)r event_daterduration_hoursrirJrrUupcomingz DWA HQ, Ajmanr|)rlocationmax_participantsu#🌱 Seeding data source configs...rrrrkrsuccessneverr=)r rr is_enabledr last_sync_atlast_sync_statuslast_sync_recordsu🌱 Seeding demo sync jobs...r2)rrrpartialrIr scheduled)data_source_idrrrrecords_processedrecords_createdrecords_updated triggered_byu🌱 Seeding anomaly flags...speed_violationwarningzF completed 'Machine Learning Fundamentals' (8hr course) in 12 minutes.)r flag_typeseverityr!burst_violationz( completed 7 activities on a single day.u] completed a 4hr course in 45 minutes — reviewed and approved (attended in-person session).z@Attended instructor-led session, course auto-marked as complete.)rrrr!resolved resolved_by resolved_atresolution_noteu%🌱 Seeding verification requests...rpending_verificationz%https://coursera.org/verify/DEMO12345) rrrrrrrrg evidence_url certificatez+Completed Google AI Essentials on Coursera.) completion_idrr evidence_typenotesu🌱 Seeding activity feed...)r7 badge_earnedlevel_up)rrg?r7rr)activity_title badge_name new_level)r event_type event_data created_atu ✅ Seeded z employees, z4 activities, data sources, badges, levels, and more!z1 Admin login: sara.al-mansoori@dwa.ae / demo123r)Qpasslib.contextrr beginrun_syncr metadatadrop_all create_allr print DEPARTMENTS Departmentaddflush LEVELS_DATALevel BADGES_DATABadge enumerate EMPLOYEESsplitlowerUseridhashACTIVITIES_DATAActivityitems TrackedLinkrcreplacerrrgetQuizquiz_idlistvaluesrsampleintlenchoicesrdrActivityCompletionrrangerstrftime sqlalchemyrrexecutecoalescesumrwhererrscalartotal_xprg verified_xpreversed current_levelr Hackathon DATA_SOURCESDataSourceConfigrscalarsallSyncJobchoice AnomalyFlagVerificationRequest ActivityFeedcommit)Cr pwd_contextconndbdept_mapddeptlbuser_mapir dept_namefirstlastruser activity_maparvactreading_activitieslink quiz_dataqdquiz all_users non_recurring recurringncompletion_rateactivities_to_completea_datar comp_datetrustrFcomp month_offsetperiod usage_rate active_usersrrresulttotalresult2lvlhack_activitieshackathon_datahdhackdsconfigconfigs_result api_configsjjob flagged_user resolved_user admin_user cert_activity pending_user_rfeedsC rseedrsI,zfEK||~~mmDMM22333mmDMM44555~" +,A??D FF4L"&HQvY hhj &'A FF5:1: hhj &'A FF5H1HIai[*GH Ihhj )*$-i$8 A iJJLO))+E::<#))+DgQtfG,E"46(O&y144 !QWAE[z)..y9D FF4L!HTN%9hhj *+  A:qwwy9ytq!ady9:C FF3K'*L7 $!hhj -.)8WAAjMY2C #W+&( o  t hhj  "gg  +,*+ $3QOq155;PO Q /I11553HQ ID"+C)$!QqDNN/BA)CAFD&*.H&HdVZ^yVyd@CO%+]]=CMHZ]lHlDm%n "0"6'?3m(DsTWjYZ[\'A.  <3%+{%:S\\[(S__s-BB) GG #!(.+(=6>>RTVXCY(9&..B:O+PP.4 .C!).!:$ t +1 <"!HLh\0A!BBLLWUF#"6'?3$-$@Sc %}}Y#c)nz>Y:Z[ (D- $$'FF*%(%0|a7G1H"|J[^_J_%`#&<<-3ZZ -E-JzP^#)::lA#>#) DFF4L) $%&hhj -.D /::t}}TXX.@.K.K%LaPQWW&..$''9&--<F MMOE!DMJJt}}TXX.@.K.K%LaPQWW&..$''9&--<&11Q6G '~~/D  ,CM)),VD&-+2hhj 12&5Vo:+9U1oV+4b";MYdxz {2$tQPRBS_j~ A0T1b@Q]g{} ~  ~.EAr""?1#5g#>?C&)CFFt(!# D FF4L/hhj 34B%Z/[/&(ff-Dc&J24[/U2J[A.PT.0o.FG<>{Ou! RID`   W  ov ,1Q/O _ se*}-}} 0}} } }1})25A},A }/A }2!C }546 }847}>8 ~~!C:~;B=A~ A~ ~  )~~~ -~ 1I~B /~0B0 ~"!3$9~%: ~(~(#B"~-B&,~0-A :~3;I~6C/ ~9 $0 ~>?76  } }}&} }&! ,/258  "%(0369   __main__)rr)__doc__asyncioruuidrrrrrBrsqlalchemy.ext.asyncior app.databaser r r app.modelsrrr"r+r&r(r1rMr__name__runrrrrsd 88/44&, +TU )LM *VW 'HI "67 'FG    4YVWX 3FZ[\ sY]^_ 3FZ[\ 4)V[\] D9f\]^  F XnELNODP`ab &l^tKRTVJWghi \UlCMOXBYijk \]mPXcdCeuvw u)O`v}@AvBRST &i[lCJLMBN^_` Et~s~ADsEUVW FP^tBEtFVWX FP^tBFtGWXY &lVfIP[\|]mop )^jALNO@P`bc !6y\pGQSTFUegh &lVd{BDEzFVXY \]oFMOQERbde iYZiAQST F UbxBCxDTVW! *2xU\jmNQak{|GPR`Fab,(PcqtUXhrBCNRTbMcd*gcfGJZhxyDMO\C]^(hL_mpQTdn~JNPTIUV-8Q[ilMP`jz{FJLZE[\+vcfGJZhxyDMOUCVW-9R\jl}`brs~H}IJ$)actvWYiju}t~,)Q[ik|~_aqr}BDR|ST-9R\jl}`brs~G}HI0gS[ikLN^_jzi{|+hdgHJZ[fneop$+:cfvwCNBOP+R\jm}~JUW`Iab){PZhk{|HSUaGbc)zzgjKM]^irt{h|}* PZhjKM]^ishtu2 ZhvxKOfo@A#8acuyQZjkl%