eps1lon/poe-db: relational db backend for Path of ... - GitHub

Relational database for Content.ggpk from Path of [email protected]. Requirements. python 3.4 for PyPoe. install. $ git ... Skiptocontent {{message}} eps1lon / poe-db Public Notifications Star 5 Fork 0 relationaldbbackendforPathofExile'sContent.ggpk 5 stars 0 forks Star Notifications Code Issues 1 Pullrequests 0 Actions Projects 0 Wiki Security Insights More Code Issues Pullrequests Actions Projects Wiki Security Insights master Branches Tags Couldnotloadbranches Nothingtoshow Loading {{refName}} default Couldnotloadtags Nothingtoshow {{refName}} default Loading 3 branches 4 tags Code Loading Latestcommit   Gitstats 384 commits Files Permalink Failedtoloadlatestcommitinformation. Type Name Latestcommitmessage Committime .github/PULL_REQUEST_TEMPLATE     .vscode     cache     data     pypoe@a7d6e4e     scripts     src     .babelrc     .env.example     .eslintignore     .eslintrc     .gitignore     .gitmodules     .nvmrc     .prettierrc     .travis.yml     CHANGELOG.md     README.md     package.json     server.js     yarn.lock     Viewcode poe-db Requirements install DatabaseSetup environmentvariables Endpoints /describe/:model_name /find/:model_name /find/:model_name/:id /find/:model_name /describe/:model_name /scoped/:model_name/:scope_name devenvironment Patchworkflow models README.md poe-db [email protected]. Requirements python3.4forPyPoe install $gitclone--recursivehttps://github.com/eps1lon/[email protected] #runinapython3.4virtualenvforPyPoE: $yarninstall--production #youmightneedtoconfigPyPoEtofindtheContent.ggpk $yarnrunload-content #Besuretosetthenecessaryenvironmentvariablesfortheconnection $yarnrundb:build DatabaseSetup #justtodisplaywhatpriviligesareneeded CREATEUSER'poedb'@'localhost'IDENTIFIEDBY'***'; CREATEDATABASEpoedb; GRANTUSAGEON*.*TO'poedb'@'localhost'; GRANTALLPRIVILEGESON`poedb`.*TO'poedb'@'localhost'; environmentvariables Thefollowingvariableshavetobesetasenvironmentvariablesinorderto authenticatetothedatabase(alternativelyfollowtheinstructionsin.env.example): POEDB_HOST POEDB_USERneedsthefollowingprivileges drop/createhostwidefordb:create,db:drop allread/writeprivilegesforthespecifieddb POEDB_PW POEDB_DB Endpoints /describe/:model_name :model_name-inCamelCasesingular { attributes:Attribute[], belongsTo:Association[], hasMany:Association[], belongsToMany:Association[], asCollection:string,//tablename } /find/:model_name queryparams: page-type:number,default:1 page_size-type:number,default:20 order-type:[AttributeName,'ASC'|'DESC'][] withDescription-includesthe/describeendpointtype:boolean,default:false attributes-whitelist,type:AttributeName[] where-plainjsobject,seehttp://docs.sequelizejs.com/manual/tutorial/querying.html#where /find/:model_name/:id :model_name-inCamelCasesingular :id-primarykey includesbelongsToandbelongsToManyassociations { count:1, rows:ModelInstance, } /find/:model_name :model_name-inCamelCaseplural includesbelongsToassociations //Returns { count:number, rows:ModelInstance[], } /describe/:model_name :model_name-inCamelCasesingular //Returns { attributes:Attribute[], belongsTo:Association[], hasMany:Association[], belongsToMany:Association[], asCollection:string,//tablename } /scoped/:model_name/:scope_name :model_name-inCamelCasesingular :scope_name-definedscopeforthisspecificmodel queryparams: page-type:number,default:1 page_size-type:number,default:20 where-plainjsobject,seehttp://docs.sequelizejs.com/manual/tutorial/querying.html#where //Returns ModelInstance[] devenvironment Therepositoryshouldcontainthelatestmodels.Iftheyareoutofdate thepackagecontainsscriptstogeneratenewones.Todosorunthefollowing commands: $yarninstall $yarnrundev:parseContent $yarnrundev:models Remembertoaddandrunmigrationsifnecessary. Patchworkflow DevworkflowincasethespecinContent.ggpkchanges(i.e.apatchhits): WaitforspecupdateinOmegaK2/PyPoEorchangesubmoduleandfileaPR. $yarnrunload-content $yarnrundev:models--poe$POE_CLIENT_VERSION $yarnrundb:schema $yarnrundb:migration:generate#adjustforrenames #verifygeneratedmigrationsusediffbetweenmodelsasahelper $yarnrundb:migration:runup $yarnrundb:insert $yarnruntest#mainlyforscopetests models Themodelsinsrc/models/baseareautogenerated.Forspecificscopes, getters,settersetccreateorupdatethespecificfilesinthecorrespondingfolders. About relationaldbbackendforPathofExile'sContent.ggpk Topics database pathofexile Resources Readme Releases 4 tags Packages0 Nopackagespublished Languages JavaScript 100.0% Youcan’tperformthatactionatthistime. Yousignedinwithanothertaborwindow.Reloadtorefreshyoursession. Yousignedoutinanothertaborwindow.Reloadtorefreshyoursession.