Service application node.js , query on Oracle DB, create files on shared folder

In Corso Pubblicato 5 anni fa Pagato alla consegna
In Corso Pagato alla consegna

- Data source Database type: oracle 11 (or higher).

- The database is already existing and with data inside.

- Server environment: windows server 2012/2016.

- Development on dedicated vps server.

- All phases of preparation and configuration of the Set up of Development Environment must be fully documented. The source code must be documented and commented.

- Backend app node.js

- No user interface required.

- The application will have to become a windows service ( [login to view URL] )

- Application algorithm:

1. Run a query every 30 seconds, read the records of a table with a control field = 0

2. If there are records, create two text files in a shared folder.

o First file must contain some values retrieved from the query just executed.

Name of file: [login to view URL]

o Second File is standard (it never changes).

Name of file: [login to view URL]

3. If everything is ok, update the related record on database by setting the control field = 1

Example of file attached to the project.

Details for the connection to database, query script, name of shared folder, variables to write on file, will be provided later. Please start creating the application template and then add these details later.

- Data source Database type: oracle 11 (or higher).
- The database is already existing and with data inside, only need to query and update.
- Server environment: windows server 2012/2016.
- Development on dedicated vps server.
- All phases of preparation and configuration of the Set up of Development Environment must be fully documented. The source code must be documented and commented.
- Backend app node.js

- No user interface required.
- The application will have to become a windows service ( https://github.com/jfromaniello/winser )

- Application algorithm:


1. Run a query every 30 seconds, read the records of a table with a control field = 0

<<<<<<<<<<<<<<<<<<<<<
select PROGR_RECORD, CODICE_ORDINE, NUMERO_FASE, STATO, ATTIVITA, DATA, CODICE_RISORSA, CODICE_PARTE, QUANTITA, DESCRIZIONE_OPERAZIONE from pressa_prod where processato = 0 and rownum = 1
<<<<<<<<<<<<<<<<<<<<<























2. If there are records, create two text files in a file system folder like c:\temp.

o First file must contain some values retrieved from the query just executed.
Name of file: set.job



//file : set.job

JOB set.job RESPONSE "set.rsp";

SET SetDescPrt "<CODICE_PARTE>"
SET @SetDescLot "<CODICE_ORDINE>"
SET SetDescMld "<NUMERO_FASE>"
SET SetDescJob "<DESCRIZIONE_OPERAZIONE>"
SET SetDescMat[1,1] ""
SET @SetPrtWht 1
SET @ActCntMld 1
SET SetCntCyc <QUANTITA>
SET @StdTimCyc 0.00
SET @SetDescMsg[1] " "
SET @SetDescMsg[2] " "
SET @SetDescMsg[3] " "
SET @SetDescMsg[4] " "
SET @SetDescMsg[5] " "
SET @SetDescMsg[6] " "
SET @SetConfMsg 0
SET @SetJobEnd 2

o Second File is standard (it never changes).
Name of file: Sess0006.req




3. If everything is ok, update the related record on database by setting the control field = 1

>>>>>>>>>>>>>
UPDATE pressa_prod SET processato = 1 WHERE progr_record = 1
>>>>>>>>>>>>>>>>

PHP Architettura Software

Rif. progetto: #17927914

Info sul progetto

4 proposte Progetto a distanza Attivo 5 anni fa

4 freelance hanno fatto un'offerta media di €164 per questo lavoro

arifjaunpur

Hello, I have experience in NodeJS and Oracle DB. Let me know when we can discuss. I am Sr. full stack developer & DevOps with 5+ years experience. I have experience in JavaScript, NodeJS, ExpressJS, AngularJS, Altro

€250 EUR in 3 giorni
(72 valutazioni)
6.4
PandaWebAg

Hello ! I'm a web developper, focused on javascript technologies. I've worked on windows server during my computer degree and I'm able to create your nodejs script pretty easily using libraries. I'll also be able to Altro

€55 EUR in 1 giorno
(10 valutazioni)
3.7
ShaherYarMCT

Sir i can provide you with this in less than 2 weaks. Also we are a team and want to work with you. It will be a great experience for us, I hope you will reply us so that we can further discuss it with you.

€150 EUR in 3 giorni
(0 valutazioni)
0.0