31:T116f,highlightRender( 'bash', ` mysql> CREATE DATABASE IF NOT EXISTS developer_survey; Query OK, 1 row affected, 1 warning (0.02 sec) mysql> use developer_survey; Database changed mysql> CREATE TABLE IF NOT EXISTS developer_survey_2019 ( Respondent BIGINT UNSIGNED NOT NULL DEFAULT 0, MainBranch VARCHAR(128) NOT NULL, Hobbyist VARCHAR(8) NOT NULL, OpenSourcer VARCHAR(128) NOT NULL, OpenSource VARCHAR(128) NOT NULL, Employment VARCHAR(128) NOT NULL, Country VARCHAR(64) NOT NULL, Student VARCHAR(32) NOT NULL, EdLevel VARCHAR(128) NOT NULL, UndergradMajor VARCHAR(128) NOT NULL, EduOther VARCHAR(1024) NOT NULL, OrgSize VARCHAR(128) NOT NULL, DevType VARCHAR(1024) NOT NULL, YearsCode VARCHAR(32) NOT NULL, Age1stCode VARCHAR(32) NOT NULL, YearsCodePro VARCHAR(32) NOT NULL, CareerSat VARCHAR(64) NOT NULL, JobSat VARCHAR(64) NOT NULL, MgrIdiot VARCHAR(64) NOT NULL, MgrMoney VARCHAR(16) NOT NULL, MgrWant VARCHAR(32) NOT NULL, JobSeek VARCHAR(128) NOT NULL, LastHireDate VARCHAR(64) NOT NULL, LastInt VARCHAR(512) NOT NULL, FizzBuzz VARCHAR(8) NOT NULL, JobFactors VARCHAR(512) NOT NULL, ResumeUpdate VARCHAR(128) NOT NULL, CurrencySymbol VARCHAR(8) NOT NULL, CurrencyDesc VARCHAR(128) NOT NULL, CompTotal VARCHAR(32) NOT NULL, CompFreq VARCHAR(32) NOT NULL, ConvertedComp VARCHAR(32) NOT NULL, WorkWeekHrs VARCHAR(16) NOT NULL, WorkPlan VARCHAR(128) NOT NULL, WorkChallenge VARCHAR(255) NOT NULL, WorkRemote VARCHAR(128) NOT NULL, WorkLoc VARCHAR(64) NOT NULL, ImpSyn VARCHAR(32) NOT NULL, CodeRev VARCHAR(64) NOT NULL, CodeRevHrs VARCHAR(16) NOT NULL, UnitTests VARCHAR(128) NOT NULL, PurchaseHow VARCHAR(128) NOT NULL, PurchaseWhat VARCHAR(64) NOT NULL, LanguageWorkedWith VARCHAR(255) NOT NULL, LanguageDesireNextYear VARCHAR(255) NOT NULL, DatabaseWorkedWith VARCHAR(255) NOT NULL, DatabaseDesireNextYear VARCHAR(255) NOT NULL, PlatformWorkedWith VARCHAR(255) NOT NULL, PlatformDesireNextYear VARCHAR(255) NOT NULL, WebFrameWorkedWith VARCHAR(255) NOT NULL, WebFrameDesireNextYear VARCHAR(255) NOT NULL, MiscTechWorkedWith VARCHAR(255) NOT NULL, MiscTechDesireNextYear VARCHAR(255) NOT NULL, DevEnviron VARCHAR(255) NOT NULL, OpSys VARCHAR(32) NOT NULL, Containers VARCHAR(128) NOT NULL, BlockchainOrg VARCHAR(128) NOT NULL, BlockchainIs VARCHAR(128) NOT NULL, BetterLife VARCHAR(8) NOT NULL, ITperson VARCHAR(64) NOT NULL, OffOn VARCHAR(16) NOT NULL, SocialMedia VARCHAR(32) NOT NULL, Extraversion VARCHAR(32) NOT NULL, ScreenName VARCHAR(32) NOT NULL, SOVisit1st VARCHAR(32) NOT NULL, SOVisitFreq VARCHAR(64) NOT NULL, SOVisitTo VARCHAR(512) NOT NULL, SOFindAnswer VARCHAR(64) NOT NULL, SOTimeSaved VARCHAR(64) NOT NULL, SOHowMuchTime VARCHAR(32) NOT NULL, SOAccount VARCHAR(64) NOT NULL, SOPartFreq VARCHAR(64) NOT NULL, SOJobs VARCHAR(128) NOT NULL, EntTeams VARCHAR(128) NOT NULL, SOComm VARCHAR(32) NOT NULL, WelcomeChange VARCHAR(64) NOT NULL, SONewContent VARCHAR(255) NOT NULL, Age VARCHAR(32) NOT NULL, Gender VARCHAR(64) NOT NULL, Trans VARCHAR(8) NOT NULL, Sexuality VARCHAR(128) NOT NULL, Ethnicity VARCHAR(512) NOT NULL, Dependents VARCHAR(16) NOT NULL, SurveyLength VARCHAR(128) NOT NULL, SurveyEase VARCHAR(128) NOT NULL, PRIMARY KEY (Respondent) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; Query OK, 0 rows affected (0.21 sec) ` )32:[] 2f:{"title":"Stack Overflow Annual Developer Survey [2019]","cells":[{"id":0,"value":"md`# Stack Overflow Annual Developer Survey [2019]`","pinned":false,"hidden":false,"mode":"ojs"},{"id":8,"value":"md`\n## Prerequisite\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":11,"value":"md`\n### Database\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":40,"value":"md`\n#### The Address of Downloading Database\n- \n\n#### Usage\n- Download this repository\n- Enter MySQL of Stack Overflow directory and run this command \"docker-compose up -d\" \n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":39,"value":"md`\n#### The Steps of Create Databases\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":38,"value":"md`\n##### Docker-compose.yaml\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":37,"value":"highlightRender(\n 'yaml',\n `\nversion: \"3\"\n\nservices:\n mysql:\n container_name: mysql\n image: mysql:5.7\n volumes:\n - ./single:/var/lib/mysql\n ports:\n - \"127.0.0.1:3306:3306\"\n environment:\n MYSQL_ROOT_PASSWORD: 123456\n restart: always\n`\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":36,"value":"md`\n##### Note \nIn order for docker to be able to read the data files, **you need to place the .csv files in single directory**\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":35,"value":"md`\n##### Create Databases And Tables\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":34,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":33,"value":"md`\n##### Import Data\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":32,"value":"highlightRender(\n 'shell',\n `\nmysql> LOAD DATA LOCAL INFILE \"/var/lib/mysql/survey_results_public.csv\"\n INTO TABLE developer_survey_2019\n FIELDS TERMINATED BY ','\n ENCLOSED BY '\"'\n LINES TERMINATED BY '\\\\n'\n IGNORE 1 ROWS;\nQuery OK, 88883 rows affected, 0 warnings (51.17 sec)\nRecords: 88883 Deleted: 0 Skipped: 0 Warnings: 0\n`\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":83,"value":"md`\n## MainBranch\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":82,"value":"html`

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":81,"value":"dataMainBranch = [\n { item: 'I am a developer by profession', value: Number(numMainBranch[0].toFixed(2)) },\n { item: 'I am a student who is learning to code', value: Number(numMainBranch[1].toFixed(2)) },\n { item: 'I am not primarily a developer, but I write code sometimes as part of my work', value: Number(numMainBranch[2].toFixed(2)) },\n { item: 'I code primarily as a hobby', value: Number(numMainBranch[3].toFixed(2)) },\n { item: 'I used to be a developer by profession, but no longer am', value: Number(numMainBranch[4].toFixed(2)) },\n];","pinned":false,"hidden":false,"mode":"ojs"},{"id":80,"value":"dataMainBranchchart = {\n const chart = new G2.Chart({\n container: 'c1',\n forceFit: true,\n height: 300,\n padding: 'auto'\n });\n return chart\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":79,"value":"showDeveloperSurvey(dataMainBranch, dataMainBranchchart)","pinned":false,"hidden":false,"mode":"ojs"},{"id":25,"value":"md`\n## Hobbyist\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":24,"value":"html`

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":23,"value":"dataHobbyist = [\n { item: 'Yes', value: Number(numHobbyist[0].toFixed(2)) },\n { item: 'No', value: Number(numHobbyist[1].toFixed(2)) },\n];","pinned":false,"hidden":false,"mode":"ojs"},{"id":22,"value":"dataHobbyistchart = {\n const chart = new G2.Chart({\n container: 'c2',\n forceFit: true,\n height: 300,\n padding: 'auto'\n });\n return chart\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":21,"value":"showDeveloperSurvey(dataHobbyist, dataHobbyistchart)","pinned":false,"hidden":false,"mode":"ojs"},{"id":20,"value":"md`\n## OpenSourcer\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":19,"value":"html`

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":18,"value":"dataOpenSourcer = [\n { item: 'Never', value: Number(numOpenSourcer[0].toFixed(2)) },\n { item: 'Less than once per year', value: Number(numOpenSourcer[1].toFixed(2)) },\n { item: 'Less than once a month but more than once per year', value: Number(numOpenSourcer[2].toFixed(2)) },\n { item: 'Once a month or more often', value: Number(numOpenSourcer[3].toFixed(2)) },\n];","pinned":false,"hidden":false,"mode":"ojs"},{"id":17,"value":"dataOpenSourcerchart = new G2.Chart({\n container: 'c3',\n forceFit: true,\n height: 300,\n padding: 'auto'\n});","pinned":false,"hidden":false,"mode":"ojs"},{"id":16,"value":"showDeveloperSurvey(dataOpenSourcer, dataOpenSourcerchart)","pinned":false,"hidden":false,"mode":"ojs"},{"id":74,"value":"md`\n## Employment\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":73,"value":"html`

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":72,"value":"dataEmployment = [\n { item: 'Employed full-time', value: Number(numEmployment[0].toFixed(2)) },\n { item: 'Independent contractor, freelancer, or self-employed', value: Number(numEmployment[1].toFixed(2)) },\n { item: 'Not employed, but looking for work', value: Number(numEmployment[2].toFixed(2)) },\n { item: 'Employed part-time', value: Number(numEmployment[3].toFixed(2)) },\n { item: 'Not employed, and not looking for work', value: Number(numEmployment[4].toFixed(2)) },\n { item: 'NA', value: Number(numEmployment[5].toFixed(2)) },\n];","pinned":false,"hidden":false,"mode":"ojs"},{"id":71,"value":"dataEmploymentchart = new G2.Chart({\n container: 'c4',\n forceFit: true,\n height: 300,\n padding: 'auto'\n});","pinned":false,"hidden":false,"mode":"ojs"},{"id":70,"value":"showDeveloperSurvey(dataEmployment, dataEmploymentchart)","pinned":false,"hidden":false,"mode":"ojs"},{"id":15,"value":"showDeveloperSurvey = (data, chart) => {\n chart.source(data);\n chart.legend({\n position: 'right-center',\n offsetX: -100\n });\n chart.coord('theta', {\n radius: 0.75\n });\n chart.intervalStack().position('value').color('item', [ '#1890ff', '#37c661', '#fbce1e', '#2b3b79', '#8a4be2', '#1dc5c5' ])\n .style({\n stroke: 'white',\n lineWidth: 1\n })\n .label('value', {\n formatter: (val) => {\n return val + '%';\n }\n });\n chart.render();\n return 'show'\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":114,"value":"md`\n## Query\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":113,"value":"allCounts = 88883","pinned":false,"hidden":false,"mode":"ojs"},{"id":112,"value":"Query = (list, content) => {\n return client.queryRow(`SELECT COUNT(*) FROM developer_survey_2019 WHERE ${list} = ${content}`)\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":111,"value":"Query('MainBranch', '\\\"I am a developer by profession\\\"')","pinned":false,"hidden":false,"mode":"ojs"},{"id":110,"value":"numMainBranch = [65679/allCounts * 100, 65679/allCounts * 100, 7539/allCounts * 100, 3340/allCounts * 100, 1584/allCounts * 100]","pinned":false,"hidden":false,"mode":"ojs"},{"id":109,"value":"numHobbyist = [71257/allCounts * 100, 17626/allCounts * 100]","pinned":false,"hidden":false,"mode":"ojs"},{"id":108,"value":"numOpenSourcer = [32295/allCounts * 100, 24972/allCounts * 100, 20561/allCounts * 100, 11055/allCounts * 100]","pinned":false,"hidden":false,"mode":"ojs"},{"id":107,"value":"numEmployment = [64440/allCounts * 100, 8511/allCounts * 100, 5600/allCounts * 100, 4469/allCounts * 100, 3803/allCounts * 100, 1702/allCounts * 100]","pinned":false,"hidden":false,"mode":"ojs"},{"id":5,"value":"md`\n## Imports\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":95,"value":"client = DatabaseClient('developer_survey')","pinned":true,"hidden":false,"mode":"ojs"},{"id":14,"value":"G2 = require('@antv/g2')","pinned":true,"hidden":false,"mode":"ojs"},{"id":28,"value":"highlightRender = (language, src) => {\n let pre = document.createElement('pre');\n pre.innerHTML = `\n ${src}\n `;\n highlight.highlightBlock(pre);\n return pre;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":27,"value":"highlight = require('https://cdn.jsdelivr.net/gh/highlightjs/cdn-release@9.17.1/build/highlight.min.js')","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W32","stdlib":"1","titling":"auto"}