- Create dir
qlanir
- Cd to
qlanir
git clone [email protected]:baio/qlanir.app.git
This is client application (nodejs server + static files), ural already included in this project
git [email protected]: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