# irelia-database > Database to profitfy Latest version **2.9.11** (published 2020-04-13) · MIT license · 0 weekly downloads > **Deprecated.** This package is deprecated. ## Install ```sh npm install irelia-database pnpm add irelia-database yarn add irelia-database bun add irelia-database ``` ## Health **Score 10/100 (F)** — status: deprecated. Negative: deprecated. ## Facts | | | |---|---| | Version | 2.9.11 | | Published | 2020-04-13 | | First published | 2019-10-08 | | Weekly downloads | 0 | | License | MIT | | TypeScript types | none | | Module format | CommonJS | | Dependencies | 9 | | Unpacked size | 596.5 KB | | Known vulnerabilities | 0 (+5 in 1 direct dependencies) | | Install scripts | no | | Author | Profitfy | | Maintainers | profitfy | ## Links - npm: https://www.npmjs.com/package/irelia-database - Repository: https://profitfy@bitbucket.org/profitfy/irelia-database - Homepage: https://bitbucket.org/profitfy/irelia-database#readme - npm.io page: https://npm.io/package/irelia-database ## Dependencies (9) - [pg](https://npm.io/package/pg.md) ^7.12.0 - [chance](https://npm.io/package/chance.md) ^1.1.3 - [dotenv](https://npm.io/package/dotenv.md) ^8.0.0 - [lodash](https://npm.io/package/lodash.md) ^4.17.15 - [pgtools](https://npm.io/package/pgtools.md) ^0.3.0 - [slugify](https://npm.io/package/slugify.md) ^1.3.5 - [bcryptjs](https://npm.io/package/bcryptjs.md) ^2.4.3 - [sequelize](https://npm.io/package/sequelize.md) ^5.21.6 - [moment-timezone](https://npm.io/package/moment-timezone.md) ^0.5.27 ## Recent versions - 2.9.11 (latest) — 2020-04-13 - 2.9.10 — 2020-04-13 - 2.9.9 — 2020-04-13 - 2.9.7 — 2020-04-09 - 2.9.6 — 2020-04-07 - 2.9.5 — 2020-04-07 - 2.9.4 — 2020-04-07 - 2.9.3 — 2020-04-06 - 2.9.2 — 2020-04-06 - 2.8.11 — 2020-04-01 - 2.9.1 — 2020-04-01 - 2.9.0 — 2020-04-01 - 2.8.10 — 2020-03-31 - 2.8.9 — 2020-03-30 - 2.8.8 — 2020-03-26 - … 291 more at https://npm.io/package/irelia-database/versions ## README # irelia-database Models and migrations for the database. ## Dependencies - [git](https://git-scm.com/downloads) - [nodejs](https://nodejs.org/en/download/) ^v9.6.1 - [yarn](https://yarnpkg.com/en/) - [PostgreSQL](https://www.postgresql.org/download/) You need a local running database with access to the current user. ## Documentation To find out more, check the documentation: http://docs.sequelizejs.com/manual/installation/getting-started.html ## Setup ```bash git clone https://KevChips@bitbucket.org/profitfy/irelia-database.git cd irelia-database yarn install ``` ## Service ### Plan - Functions --- #### - savePlan ##### Parameters - `planData`: Plan Data. ##### Return An object with Plan data. #### - listPlans ##### Parameters - This method has not parameter ##### Return A list of Plan data. #### - listPlanById ##### Parameters - `planId`: Plan Id. ##### Return An object with Plan data filtered by id. #### - listPlanByName ##### Parameters - `planName`: Plan Name. ##### Return An object with Plan data filtered by name. #### - updatePlanById ##### Parameters - `planId`: Plan Id. - `planData`: Plan Data. ##### Return An object with Plan data updated. ### DashboardUser - Functions --- #### - saveDashboardUser ##### Parameters - `dashboardUserData`: Dashboard User Data. ##### Return An object with Dashboard User data. #### - listDashboardUsers ##### Parameters - This method has not parameter ##### Return A list of Dashboard User data. #### - listDashboardUsersByEmail ##### Parameters - `dashboardUserEmails`: Array With Dashboard User Email. ##### Return A list of Dashboard User data filtered by email. #### - listDashboardUserByEmail ##### Parameters - `dashboardUserEmail`: Dashboard User email. ##### Return An object with Dashboard User data filtered by email. #### - listDashboardUserToLogin ##### Parameters - `dashboardUserEmail`: Dashboard User email. ##### Return An object with Dashboard User data with password. #### - listDashboardUserById ##### Parameters - `dashboardUserId`: Dashboard User id. ##### Return An object with Dashboard User data filtered by id. #### - listDashboardUserByResetToken ##### Parameters - `passwordResetToken`: Dashboard User Password Reset Token. ##### Return An object with Dashboard User data filtered by id. #### - listDashboardUsersActive ##### Parameters - This method has not parameter ##### Return A list of objects with all Dashboard User data filtered by active true. #### - listDashboardUsersInactive ##### Parameters - This method has not parameter ##### Return A list of Dashboard User data filtered by active false. #### - updateDashboardUserById ##### Parameters - `dashboardUserId`: Dashboard User id. - `dashboardUserData`: Dashboard User data to update. ##### Return An object with Dashboard User data updated. #### - deleteDashboardUserById ##### Parameters - `dashboardUserId`: Dashboard User id. ##### Return An object wih Dashboard User data deleted. #### - updateDashboardUserPlan ##### Parameters - `dashboardUserId`: Dashboard User id. - `planId`: Plan id. ##### Return An object with Dashboard User data updated. ### Notification - Functions --- #### - saveNotification ##### Parameters - `notificationData`: Notification Data. ##### Return An object with Notification data. #### - listNotificationById ##### Parameters - `notificationId`: Notification Id. ##### Return An object with Notification data filtered by id. #### - listNotificationByDashboardUserId ##### Parameters - `dashboardUserId`: Dashboard User Id. ##### Return An object with Notification data filtered by dashboard user id. #### - updateNotificationById ##### Parameters - `notificationId`: Notification Id. - `notificationData`: Notification Data. ##### Return An object with Notification data updated. ### Subscription - Functions --- #### - saveSubscription ##### Parameters - `subscriptionData`: Subscription Data. ##### Return An object with Subscription data. #### - listSubscriptionById ##### Parameters - `subscriptionId`: Subscription Id. ##### Return An object with Subscription data filtered by id. #### - listSubscriptionByDashboardUserId ##### Parameters - `dashboardUserId`: Dashboard User Id. ##### Return An object with Subscription data filtered by dashboard user id. #### - updateSubscriptionById ##### Parameters - `subscriptionId`: Subscription Id. - `subscriptionData`: Subscription Data. ##### Return An object with Subscription data updated. ### Mercado Pago Credential - Functions --- #### - saveMercadoPagoCredential ##### Parameters - `mercadoPagoCredentialData`: Mercado Pago Credential Data. ##### Return An object with Mercado Pago Credential data. #### - saveMercadoPagoCredentialWithStore ##### Parameters - `mercadoPagoCredentialData`: Object With Mercado Pago Credential Data. - `shopifyStoreSlug`: Object With Shopify Store Slug. ##### Return An object with Mercado Pago Credential data. #### - listMercadoPagoCredentials ##### Parameters - This method has not parameter ##### Return A list of objects with Mercado Pago Credential data. #### - listMercadoPagoCredentialById ##### Parameters - `mercadoPagoCredentialId`: Mercado Pago Credential Id. ##### Return An object with Mercado Pago Credential data filtered by id. #### - listMercadoPagoCredentialByShopifyStoreSlug ##### Parameters - `shopifyStoreSlug`: Shopify Store Slug. ##### Return An object with Mercado Pago Credential data filtered by shopify store slug. #### - updateMercadoPagoCredentialById ##### Parameters - `mercadoPagoCredentialId`: Mercado Pago Credential Id. - `mercadoPagoCredentialData`: Mercado Pago Credential Data. ##### Return An object with Mercado Pago Credential data updated. ### Shopify Store - Functions --- #### - saveShopifyStore ##### Parameters - `shopifyStoreData`: Shopify Store Data. ##### Return An object with Shopify Store data. #### - saveShopifyStoreProductsVariantsAndOrders ##### Parameters - `shopifyProductsData`: Shopify Store Products Data. - `shopifyVariantsData`: Shopify Store Variants Data. ##### Return This function does not has a return. #### - listShopifyStores ##### Parameters - This method has not parameter ##### Return A list of Shopify Store data. #### - listShopifyStoreByDomain ##### Parameters - `shopifyStoreDomain`: Shopify Store Domain. ##### Return An object with Shopify Store data filtered by domain. #### - listShopifyStoreById ##### Parameters - `shopifyStoreId`: Shopify Store Id. ##### Return An object with Shopify Store data filtered by id. #### - getStoreAndProfitByDates ##### Parameters - `shopifyStoreSlug`: Object With Shopify Store Slug. - `startDate`: Object With Start Date. - `endDate`: Object With End Date. - `tz`: Object With Shopify Store Timezone. ##### Return An object with Shopify Store data with calculated profit by range of start date to end date. #### - listShopifyStoresCreatedByDate ##### Parameters - `startDate`: Object With Start Date. - `endDate`: Object With End Date. ##### Return A list of Shopify Store data filtered by created at by range of start date to end date. #### - listActiveShopifyStores ##### Parameters - `offset`: Object With Page Number. - `limit`: Object With Elements Quantity Per Page. ##### Return A list of actives Shopify Store data. #### - listInactiveShopifyStores ##### Parameters - `offset`: Object With Page Number. - `limit`: Object With Elements Quantity Per Page. ##### Return A list of inactives Shopify Store data. #### - listShopifyStoreBySlug ##### Parameters - `shopifyStoreSlug`: Shopify Store Slug. ##### Return An object with Shopify Store data filtered by slug. #### - listShopifyStoreWithMercadoPagoCredentialBySlug ##### Parameters - `shopifyStoreSlug`: Shopify Store Slug. ##### Return An object with Shopify Store data filtered by slug. #### - listShopifyStoresByUserId ##### Parameters - `dashboardUserId`: Dashboard User Id. ##### Return A list of Shopify Store data filtered by dashboard user id. #### - updateShopifyStoreById ##### Parameters - `shopifyStoreId`: Shopify Store Id. - `shopifyStoreData`: Shopify Store Data. ##### Return An object with Shopify Store data updated. ### Shopify Product - Functions --- #### - saveShopifyProduct ##### Parameters - `shopifyProductData`: Shopify Product Data. ##### Return An object with Shopify Store Data. #### - saveShopifyProducts ##### Parameters - `shopifyProductsData`: An array with Shopify Product Data. ##### Return A list of Shopify Product data what was inserted. #### - listShopifyProductsWithStore ##### Parameters - `shopifyStoreIds`: Object With An Array Of Shopify Store Ids. ##### Return A list of Shopify Product data filtered by Shopify Store ids. #### - getStoreAndProfitByDates ##### Parameters - `shopifyProductSlug`: Object With Shopify Product Slug. - `startDate`: Object With Start Date. - `endDate`: Object With End Date. - `tz`: Object With Shopify Store Timezone. ##### Return An object with Shopify Product data with calculated profit by range of start date to end date. #### - listShopifyProducts ##### Parameters - This method has not parameter ##### Return A list of Shopify Product data. #### - listShopifyProductById ##### Parameters - `shopifyProductId`: Shopify Product Id. ##### Return An object with Shopify Product data filtered by id. #### - listShopifyProductBySlug ##### Parameters - `shopifyProductSlug`: Shopify Product Slug. ##### Return A list of Shopify Product data filtered by slug. #### - listShopifyProductsByStoreId ##### Parameters - `shopifyStoreId`: Object With Shopify Product Id. - `offset`: Object With Page Number. - `limit`: Object With Elements Quantity Per Page. ##### Return A list of Shopify Product data filtered by store id. #### - updateShopifyProductById ##### Parameters - `shopifyProductId`: Shopify Product Id. - `shopifyProductData`: Shopify Product Data. ##### Return An object with Shopify Product data updated. #### - updateShopifyProductBySlug ##### Parameters - `shopifyProductSlug`: Shopify Product Slug. - `shopifyProductData`: Shopify Product Data. ##### Return An object with Shopify Product data updated. ### Shopify Variant - Functions --- #### - saveShopifyVariant ##### Parameters - `shopifyVariantData`: Shopify Variant Data. ##### Return An object with Store data. #### - saveShopifyVariants ##### Parameters - `shopifyVariantsData`: An Array With Shopify Variant Data. ##### Return Do not have return. #### - listShopifyVariantsByProductId ##### Parameters - `shopifyProductId`: Shopify Product Id. ##### Return A list of Shopify Variant data filtered by product id. #### - listShopifyVariantById ##### Parameters - `shopifyVariantId`: Shopify Variant Id. ##### Return A list of objects with Shopify Variant data filtered by id. #### - updateShopifyVariantById ##### Parameters - `shopifyVariantId`: Shopify Variant Id. - `shopifyVariantData`: Shopify Variant Data. ##### Return An object with Shopify Variant data updated. ### Shopify Store Profit - Functions --- #### - saveShopifyStoreProfit ##### Parameters - `shopifyStoreProfitData`: Shopify Store Profit Data. ##### Return An object with Shopify Store Profit data. #### - saveShopifyStoreProfits ##### Parameters - `shopifyStoreProfitsData`: An Array With Shopify Store Profit Data. ##### Return A list of Shopify Store Profit data that was inserted. #### - listShopifyStoreProfitByStoreId ##### Parameters - `shopifyStoreId`: Shopify Store Id. ##### Return An object with Shopify Store Profit data filtered by store id. #### - getDataToShowChart ##### Parameters - `shopifyStoreId`: Object With Shopify Store Id. - `startDate`: Object With Start Date. - `endDate`: Object With End Date. - `tz`: Object With Shopify Store Timezone. ##### Return An list with formatted data to show profit chart. #### - listTodayShopifyStoreProfitByStoreId ##### Parameters - `shopifyStoreId`: Object With Shopify Store Id. - `todayDate`: Object With Today Date. - `tz`: Object With Shopify Store Timezone. ##### Return An object with today Shopify Store Profit. #### - updateShopifyStoreProfitById ##### Parameters - `shopifyStoreProfitId`: Shopify Store Profit Id. - `shopifyStoreProfitData`: Shopify Store Profit Data. ##### Return An object with Shopify Store Profit data updated. ### Shopify Product Profit - Functions --- #### - saveShopifyProductProfit ##### Parameters - `shopifyProductProfitData`: Shopify Product Profit Data. ##### Return An object with Shopify Product Profit data. #### - saveShopifyProductProfits ##### Parameters - `shopifyProductProfitsData`: An Array With Shopify Product Profit Data. ##### Return A list of Shopify Product Profit data that was inserted. #### - listShopifyProductProfitsByProductId ##### Parameters - `shopifyProductId`: Shopify Product Id. ##### Return A list of Shopify Product Profit data filtered by product id. #### - listShopifyProductsProfitsByStore ##### Parameters - `shopifyStoreSlug`: Object With Shopify Store Slug. - `limit`: Object With Elements Quantity Per Page. ##### Return A list of Shopify Products data filtered by store slug. #### - listTodayShopifyProductProfitByProductId ##### Parameters - `shopifyProductId`: Object With Shopify Product Id. - `todayDate`: Object With Today Date. - `tz`: Object With Shopify Store Timezone. ##### Return An object with today Shopify Product Profit. #### - updateShopifyProductProfitById ##### Parameters - `shopifyProductProfitId`: Shopify Product Profit Id. - `shopifyProductProfitData`: Shopify Product Profit Data. ##### Return An object with Shopify Product Profit data updated. ### Shopify Order - Functions --- #### - saveShopifyOrder ##### Parameters - `shopifyOrderData`: Shopify Order Data. ##### Return An object with Shopify Order data. #### - saveShopifyOrders ##### Parameters - `shopifyOrdersData`: An array with Shopify Orders Data. ##### Return Do not have return. #### - listOrdersAndMercadoPagoCredentialByShopifyStoresId ##### Parameters - `shopifyStoreIds`: Object With Shopify Store Ids. - `startDate`: Object With Start Date. - `endDate`: Object With End Date. - `tz`: Object With Shopify Store Timezone. ##### Return A list of Shopify Order data and Mercado Pago Credential filtered by range of startDate to endDate. #### - listShopifyOrdersUpdatedByDate ##### Parameters - `shopifyStoreId`: Object With Shopify Store Id. - `startDate`: Object With Start Date. - `endDate`: Object With End Date. - `tz`: Object With Shopify Store Timezone. ##### Return A list of Shopify Order data filtered by updated at and range of startDate to endDate. #### - listShopifyOrdersCreatedByDate ##### Parameters - `shopifyStoreId`: Object With Shopify Store Id. - `startDate`: Object With Start Date. - `endDate`: Object With End Date. - `tz`: Object With Shopify Store Timezone. ##### Return A list of Shopify Order data filtered by created at and range of startDate to endDate. ### Shopify Custom Spend - Functions --- #### - saveShopifyCustomSpend ##### Parameters - `shopifyCustomSpendData`: Object With Shopify Custom Spend Data. - `tz`: Object With Shopify Store Timezone. ##### Return An object with Shopify Custom Spend data. #### - listShopifyCustomSpendsByShopifyStoreId ##### Parameters - `shopifyStoreId`: Shopify Store Id. ##### Return A list of objects with Shopify Custom Spend data filtered by Shopify Store id. #### - listShopifyCustomSpendById ##### Parameters - `shopifyCustomSpendId`: Shopify Custom Spend Id. ##### Return An object with Shopify Custom Spend data filtered by id. #### - listShopifyCustomSpendsByBillingDate ##### Parameters - `shopifyStoreId`: Object With Shopify Store Id. - `todayDate`: Object With Today Date. - `tz`: Object With Shopify Store Timezone. ##### Return A list of Shopify Custom Spend data filtered by billing date and Shopify Store id. #### - listAndUpdateShopifyCustomSpendsByYesterdayBillingDate ##### Parameters - `shopifyStoreId`: Object With Shopify Store Id. - `todayDate`: Object With Today Date. - `tz`: Object With Shopify Store Timezone. ##### Return A list of Shopify Custom Spend data filtered by yesterday billing date and Shopify Store id. #### - updateShopifyCustomSpendById ##### Parameters - `shopifyCustomSpendId`: Object With Shopify Custom Spend Id. - `shopifyCustomSpendData`: Object With Shopify Custom Spend Data. - `todayDate`: Object With Today Date. - `tz`: Object With Shopify Store Timezone. ##### Return An object with Shopify Custom Spend data updated. ### Shopify Custom Spend Billing - Functions --- #### - saveShopifyCustomSpendBilling ##### Parameters - `shopifyCustomSpendBillingData`: Shopify Custom Spend Billing Data. ##### Return An object with Shopify Custom Spend data. #### - listShopifyCustomSpendsBillingByBillingDate ##### Parameters - `shopifyStoreId`: Object With Shopify Store Id. - `todayDate`: Object With Today Date. - `tz`: Object With Shopify Store Timezone. ##### Return A list of Shopify Custom Spend Billing data filtered by billing date and Shopify Store id. #### - listShopifyCustomSpendBillingByBillingDate ##### Parameters - `shopifyStoreId`: Object With Shopify Store Id. - `todayDate`: Object With Today Date. - `tz`: Object With Shopify Store Timezone. ##### Return An object Custom Spend Billing data filtered by billing date and Shopify Store id. #### - updateShopifyCustomSpendBillingById ##### Parameters - `shopifyCustomSpendBillingId`: Shopify Custom Spend Billing Id. - `shopifyCustomSpendBillingData`: Shopify Custom Spend Billing Data. ##### Return An object with Shopify Custom Spend Billing data updated. ### Facebook Credential - Functions --- #### - saveFacebookCredential ##### Parameters - `facebookCredentialData`: Facebook Credential Data. ##### Return An object with Facebook Credential data. #### - listFacebookCredentials ##### Parameters - This method has not parameter ##### Return A list of objects with Facebook Credential data. #### - listFacebookCredentialById ##### Parameters - `facebookCredentialId`: Facebook Credential Id. ##### Return An object with Facebook Credential data filtered by id. #### - listFacebookCredentialByUserId ##### Parameters - `dashboardUserId`: Dashboard User Id. ##### Return An object with Facebook Credential data filtered by dashboard user id. #### - updateFacebookCredentialById ##### Parameters - `facebookCredentialId`: Facebook Credential Id. - `facebookCredentialData`: Facebook Credential Data. ##### Return An object with Facebook Credential data updated. #### - deleteFacebookCredentialByDashboardUser ##### Parameters - `dashboardUserId`: Dashboard User Id. ##### Return An object with Facebook Credential data deleted. ### Facebook Ad Account - Functions --- #### - saveFacebookAdAccount ##### Parameters - `facebookAdAccountData`: Facebook Ad Account data. ##### Return An object with Facebook Ad Account data. #### - saveFacebookAdAccounts ##### Parameters - `facebookAdAccountsData`: Array With Facebook Ad Account Data. ##### Return An object with Facebook Ad Account data. #### - saveFacebookAdAccountsActive ##### Parameters - `facebookAdAccountsData`: Array With Facebook Ad Account Data With Active Property. ##### Return An object with Facebook Ad Account data. #### - listFacebookAdAccounts ##### Parameters - This method has not parameter ##### Return A list of Facebook Ad Account data. #### - listFacebookAdAccountById ##### Parameters - `adAccountId`: Facebook Ad Account Id. ##### Return An object with Facebook Ad Account data filtered by id. #### - listFacebookAdAccountByDashboardUserId ##### Parameters - `dashboardUserId`: Object With Dashboard User Id. - `shopifyStoreId`: Object With Shopify Store id. ##### Return A list of Facebook Ad Account data filtered by Dashboard User id and Shopify Store id. #### - listActiveFacebookAdAccountByDashboardUserId ##### Parameters - `dashboardUserId`: Dashboard User Id. ##### Return A list with Facebook Ad Account data filtered by Dashboard User id. #### - listFacebookAdAccountByShopifyStoreId ##### Parameters - `shopifyStoreId`: Shopify Store Id. ##### Return A list Facebook Ad Account data filtered by Shopify Store id. #### - listActiveFacebookAdAccountByShopifyStoreId ##### Parameters - `shopifyStoreId`: Shopify Store Id. ##### Return A list Facebook Ad Account data filtered by Shopify Store id. #### - updateFacebookAdAccountById ##### Parameters - `adAccountId`: Object With Facebook Ad Account Id. - `adAccountData`: Object With Facebook Ad Account Data. - `todayDate`: Object With Today Date. - `tz`: Object With Shopify Store Timezone. ##### Return An object with Facebook Ad Account data updated. #### - deleteFacebookAdAccountsByDashboardUser ##### Parameters - `dashboardUserId`: Object With Dashboard User Id. - `todayDate`: Object With Today Date. - `tz`: Object With Shopify Store Timezone. ##### Return A list of Facebook Ad Account data deleted. ### Facebook Ad Account Insight - Functions --- #### - saveFacebookAdAccountInsight ##### Parameters - `facebookAdAccountInsightData`: Facebook Ad Account Insight Data. ##### Return An object with Facebook Ad Account Insight data. #### - listFacebookAdAccountsInsightByInsightDate ##### Parameters - `shopifyStoreId`: Object With Shopify Store Id. - `todayDate`: Object With Today Date. - `tz`: Object With Shopify Store Timezone. ##### Return A list of Facebook Ad Accounts Insight filtered by Shopify Store id and today date. #### - listFacebookAdAccountInsightByInsightDate ##### Parameters - `facebookAdAccountId`: Object With Facebook Ad Account Id. - `todayDate`: Object With Today Date. - `tz`: Object With Shopify Store Timezone. ##### Return A list of Facebook Ad Accounts Insight filtered by insight date, Facebook Ad Account id and today date. #### - updateFacebookAdAccountInsightById ##### Parameters - `facebookAdAccountInsightId`: Facebook Ad Account Insight Id. - `facebookAdAccountInsightData`: Facebook Ad Account Insight Data. ##### Return An object with Facebook Ad Account Insight data updated. ### Facebook Campaign - Functions --- #### - saveFacebookCampaign ##### Parameters - `facebookCampaignData`: Facebook Campaign Data. ##### Return An object with Facebook Campaign data. #### - saveFacebookCampaigns ##### Parameters - `facebookCampaignData`: Array With Facebook Campaign Data. ##### Return A list of Facebook Campaign data that was inserted. #### - saveFacebookCampaignsActive ##### Parameters - `facebookCampaignData`: Array With Facebook Campaign Data With Active Property. ##### Return A list of Facebook Campaign data that was inserted. #### - listFacebookCampaigns ##### Parameters - This method has not parameter ##### Return A list of objects with Facebook Campaign data. #### - listFacebookCampaignById ##### Parameters - `facebookCampaignId`: Facebook Campaign Id. ##### Return An object with Facebook Campaign data filtered by id. #### - listActiveFacebookCampaignByShopifyProductId ##### Parameters - `shopifyProductId`: Shopify Product Id. ##### Return An object with Facebook Campaign data filtered by Shopify Product id. #### - listFacebookCampaignByFacebookAdAccountId ##### Parameters - `facebookAdAccountId`: Facebook Ad Account Id. ##### Return An object with Facebook Campaign data filtered by facebook ad account id. #### - listActiveFacebookCampaignByFacebookAdAccountId ##### Parameters - `facebookAdAccountId`: Object With Facebook Ad Account Id. - `todayDate`: Object With Today Date. - `tz`: Object With Shopify Store Timezone. ##### Return An object with Facebook Campaign data filtered by facebook ad account id. #### - updateFacebookCampaignById ##### Parameters - `facebookCampaignId`: Object With Facebook Campaign Id. - `facebookCampaignData`: Object With Facebook Campaign Data. - `todayDate`: Object With Today Date. - `tz`: Object With Shopify Store Timezone. ##### Return An object with Facebook Campaign data updated. #### - deleteFacebookCampaignsByDashboardUser ##### Parameters - `dashboardUserId`: Object With Dashboard User Id. - `todayDate`: Object With Today Date. - `tz`: Object With Shopify Store Timezone. ##### Return A list of Facebook Campaign data deleted. ### Facebook Campaign Insight - Functions --- #### - saveFacebookCampaignInsight ##### Parameters - `facebookCampaignInsightData`: Facebook Campaign Insight Data. ##### Return An object with Facebook Campaign Insight data. #### - listFacebookCampaignsInsightByInsightDate ##### Parameters - `shopifyProductId`: Object With Shopify Product Id. - `todayDate`: Object With Today Date. - `tz`: Object With Shopify Store Timezone. ##### Return A list of Facebook Campaigns Insight filtered by Shopify Product id and today date. #### - listFacebookCampaignInsightByInsightDate ##### Parameters - `facebookCampaignId`: Object With Facebook Campaign Id. - `todayDate`: Object With Today Date. - `tz`: Object With Shopify Store Timezone. ##### Return A list of Facebook Campaigns Insight filtered by insight date, Facebook Campaign id and today date. #### - updateFacebookAdAccountInsightById ##### Parameters - `facebookCampaignInsightId`: Facebook Campaign Insight Id. - `facebookCampaignInsightData`: Facebook Campaign Insight Data. ##### Return An object with Facebook Campaign Insight data updated. ## Migration To generate new migration use: ```bash yarn migration:create --name=test ``` To apply migrations to a database use (environment vars): ```bash yarn run db:migrate ``` To drop all migrations in database use: ```bash yarn run db:migrate:undo:all ``` ## Seed To generate new seed use: ```bash yarn seed:create --name=test ``` To apply seeds to a database use (environment vars): ```bash yarn run db:seed ``` To revert all seed in database use: ```bash yarn run db:seed:undo ``` ## Tests To execute all tests use: ```bash yarn test ``` ## License © 2019 PROFITFY.ME ALL RIGHTS RESERVED --- _Source: https://npm.io/package/irelia-database · Machine-readable twin of the npm.io package page. Health data is recomputed on every publish._