Service application node.js , query on Oracle DB, create files on shared folder
€30-250 EUR
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
>>>>>>>>>>>>>>>>
Rif. progetto: #17927914
Info sul progetto
4 freelance hanno fatto un'offerta media di €164 per questo lavoro
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
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
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.