orquestrador-database-code7 v3.0.0-beta.0.2636
Orchy Base
Orchy Base is an ORM (sequelize, mongoose) wrapper that simplifies the CRUD development. By centralizing all the main features of an ORM in one place.
This node package was build with the microservice architecture in mind, so it is a fit when the software architecture requires a lot of database configuration around all the microservices.
Installation
Before using the Orchy Base some configuration is required.
Set up the environment variable
Create an environment variable file .env
for development purpose.
NODE_ENV=development OR staging OR production
ORCHYBASE_POSTGRES_DATABASE=DATABASE
ORCHYBASE_POSTGRES_USERNAME=USERNAME
ORCHYBASE_POSTGRES_PASSWORD=PASSWORD
ORCHYBASE_POSTGRES_HOST=HOST
ORCHYBASE_MONGO_URI=MONGODB_URI
Usage
To properly use the node package simply instantiate a new object.
const orchybase = new OrchyBase();
Available methods and its parameters
createLoad() returns a object with created information
const newLoad = await orchyBase.createLoad({
id_load: BIGINT,
id_flow: STRING
api_key: STRING,
register: NUMBER,
active: BOOLEAN,
created_at: DATE,
updated_at: NULL OR DATE,
});
createQueue() returns a object with created information
const newQueue = await orchyBase.createQueue({
id_load: NUMBER,
id_queue: BIGINT,
schedule: DATE,
status: NUMBER,
created_at: DATE,
updated_at: NULL OR DATE,
});
createContact() returns a object with created information
const newContact = await orchyBase.createContact({
id_contact: BIGINT,
id_load: NUMBER,
name: STRING,
key: STRING,
created_at: DATE,
updated_at: NULL OR DATE,
});
createContactData() returns a object with created information
const newContactData = await orchyBase.createContactData({
id_contact_data: BIGINT,
id_contact: NUMBER,
data_type: NUMBER,
contact_data: STRING,
status: NUMBER,
created_at: DATE,
updated_at: NULL OR DATE,
});
createLoadInfo() returns a object with created information
const newLoadInfo = await orchyBase.createLoadInfo({
id_flow: STRING,
id_load: STRING,
api_key: STRING,
start: DATE,
finish: DATE,
schedule: DATE,
contacts: STRING,
telephones: STRING,
telephones_ddd: [STRING],
email: STRING,
created_at: DATE,
updated_at: NULL OR DATE,
});
createLoadStatus() returns a object with created information
const newLoadStatus = await orchyBase.createLoadStatus({
id_flow: STRING;
id_load: STRING;
api_key: STRING;
start: DATE;
finish: DATE;
total: STRING;
contact_total: STRING;
telephone_total: STRING;
email_total: STRING;
contact_processed: STRING;
telephone_processed: STRING;
email_processed: STRING;
created_at: DATE;
updated_at: NULL OR DATE;
});
createQueueContact() returns a object with created information
const newQueueContact = await orchyBase.createQueueContact({
id_contact_data: NUMBER;
schedule: NUMBER;
event_type: STRING;
data_type: STRING;
contact_data: STRING;
status: NUMBER;
created_at: DATE;
updated_at: NULL OR DATE;
});
11 days ago
13 days ago
14 days ago
14 days ago
15 days ago
22 days ago
22 days ago
24 days ago
28 days ago
1 month ago
1 month ago
1 month ago
2 months ago
2 months ago
2 months ago
3 months ago
7 months ago
7 months ago
7 months ago
7 months ago
7 months ago
7 months ago
8 months ago
12 months ago
12 months ago
12 months ago
1 year ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago