Completed

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

- 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
>>>>>>>>>>>>>>>>

Skills: PHP, Software Architecture

See more: node.js web service, • implement an application/system in node.js that consists of services to enter and manipulate tabular numerical values data s, Node js Mongo DB, node.js oracle database connection example, node oracle db example, node js oracle database tutorial, node oracle db git, node-oracle db tutorial, node-oracle db installation on windows, node.js oracle tutorial, node oracledb insert, angular js node js express js mongo db, create an API in node js , aws, php, zend, opencart, codeigniter, node.js, mongo db, MySQL, jquery, jquery mobile, javascript, ext js, ajax, html5, css3, e, node.js web application, node js pos application, node js chat application tutorial, node js chat application github, how to deploy node js application on server, create node js project

About the Employer:
( 6 reviews ) REGGIO EMILIA, Italy

Project ID: #17927914

Awarded to:

shiningdevelopor

Dear client I can make your job perfectly I have experienced about nodejs,oracle I think that your job is excellent If u want me, I m sure about your job I have experienced for 6+ years and also I m full stac More

€200 EUR in 1 day
(57 Reviews)
6.2

5 freelancers are bidding on average €171 for this job

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, More

€250 EUR in 3 days
(67 Reviews)
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 More

€55 EUR in 1 day
(9 Reviews)
3.7
wang1986

Dear sir! Thanks for your posting job! I am a 8+ years experienced senior web developer who has been focusing on Web development. Please feel free to look around my last projects. * [login to view URL] - Angular.js/N More

€200 EUR in 3 days
(10 Reviews)
3.8
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 days
(0 Reviews)
0.0