metadata.json

{
    "title": "Setup qlanir project on local machine.",
    "visbility": "public"
}

post.md

• Create dir qlanir
• Cd to qlanir
• git clone git@bitbucket.org:baio/qlanir.app.git This is client application (nodejs server + static files), ural already included in this project
• git clonegit@bitbucket.org:baio/qlanir.service.git This is service application (ASP.NET MVC)
• Create test db - dbname qlanir.test
• Change db collation to cyrillic

ALTER DATABASE qlanir.test SET SINGLE_USER WITH ROLLBACK IMMEDIATE
ALTER DATABASE qlanir.test COLLATE Cyrillic_General_CI_AI
ALTER DATABASE qlanir.test SET MULTI_USER

• Open qlanir.service/QLight.sln in visual studio +Rebuild (nugets must be installed automatically on this step)
• Open ITS.Net.Model.edml file -> open data base explorer -> change connection for model
• Context menu Update data base from model Regenerate storage checkbox must be OFF! Uncheck VSubjectLinks when list of created object appears. +Now test db should be created, make default scripts on it
• Open SQL_SCRIPTS\func_views_columns.sql, connect to db, execute scripts - this is some updates for db which couldn't be created by EF
• Open SQL_SCRIPTS\defaults.sql, connect to db, execute scripts - this is some default values for tables
• Now we have fully fuunctional db for tests.
• Open Test explorer - select Run all - all tests should be passed.
• Now repeat, same steps and created work data base qlanir.
• Run project QLight, open link ...\api\People - should return empty array, no exceptions.
• Here service is installed
• Cd to qlanir.app directory
• npm install
• Open webstorm -> Run -> Edit configuration -> + -> Node.js -> Path to Node App JS File = server.js
• Change in public\app\config base_url to you local service url.
• Run server (default port 8001)
• Now application fully installed, check it - open browser http:\\localhost:8001