sindricui

sindric-lib-email-notifier

Object.defineProperty(exports, "__esModule", { value: true });

exports.endConnections = exports.updateOrderResults = exports.orderStatus = exports.isMembershipDrop = exports.updateDropDetails = exports.getDropDetails = exports.updateUserStatusAsPending = exports.getVerifyId = exports.getTitleFromPackId = exports.getItemAttributes = exports.getRedeemAttributes = exports.getAuctionDropDetails = exports.getTitleFromItemId = exports.getTitleFromDropId = exports.getCreatorDetails = exports.getEmailIdFromUserId = exports.getSourcePlatformDetailsFromPlatformTokenId = exports.getPlatformDetails = exports.getSubscribers = void 0;

const DatabaseConfig_1 = require("./DatabaseConfig");

const Utils_1 = require("../services/Utils");

        return (await DatabaseConfig_1.database).query(query);

        throw new Error('Failed to get records from subscriber table');

const getPlatformDetails = async (platform, platformId) => {

    const query = `select platformName from tbl_platform where platformName = "${platform}" and platformId = "${platformId}";`;

        throw new Error('Failed to get records from platforms table');

exports.getPlatformDetails = getPlatformDetails;

const getSourcePlatformDetailsFromPlatformTokenId = async (platformTokenId) => {

    const query = `select * from tbl_nft_collection where platformTokenId = "${platformTokenId}";`;

        throw new Error('Failed to get records from tbl_nft_collection table');

exports.getSourcePlatformDetailsFromPlatformTokenId = getSourcePlatformDetailsFromPlatformTokenId;

const getEmailIdFromUserId = async (userId) => {

    const query = `select emailId from tbl_user where userId = "${userId}";`;

        throw new Error('Failed to get records from users table');

exports.getEmailIdFromUserId = getEmailIdFromUserId;

const getCreatorDetails = async (creatorId) => {

    const query = `select creatorName, emailId  from tbl_creator where creatorId = "${creatorId}";`;

        throw new Error('Failed to get records from creator table');

exports.getCreatorDetails = getCreatorDetails;

const getTitleFromDropId = async (dropId) => {

    const query = `select title, assetThumbnail from tbl_drop where dropId = "${dropId}";`;

        throw new Error('Failed to get records from drop table');

exports.getTitleFromDropId = getTitleFromDropId;

const getTitleFromItemId = async (itemId) => {

    const query = `select title, itemThumbnail from tbl_item where dropId = "${itemId}";`;

    const query = `select title, itemThumbnail from tbl_item where itemId = "${itemId}";`;

        throw new Error('Failed to get records from item table');

exports.getTitleFromItemId = getTitleFromItemId;

const getAuctionDropDetails = async (packId) => {

    const query = `select d.dropId, d.title, d.assetThumbnail, p.endTime from tbl_drop d, tbl_pack p 

        where d.packId=p.packId and d.packId="${packId}";`;

exports.getAuctionDropDetails = getAuctionDropDetails;

const getRedeemAttributes = async (dropId, redeemAttributeGroupId) => {

    const query = `select attributeName, attributeValue from tbl_drop_redeem_attribute 

        where dropId="${dropId}" and redeemAttributeGroupId="${redeemAttributeGroupId}";`;

        throw new Error('Failed to get records from drop redeem attributes table');

exports.getRedeemAttributes = getRedeemAttributes;

const getItemAttributes = async (itemId, itemAttributeGroupId) => {

    const query = `select attributeName, attributeValue from tbl_item_attribute_group 

        where itemId="${itemId}" and itemAttributeGroupId="${itemAttributeGroupId}";`;

        throw new Error('Failed to get records from item attribute group table');

exports.getItemAttributes = getItemAttributes;

const getTitleFromPackId = async (packId) => {

    const query = `select title, assetThumbnail from tbl_pack where packId = "${packId}";`;

exports.getTitleFromPackId = getTitleFromPackId;

    const query = `SELECT verifyId FROM tbl_user WHERE emailId = '${emailId}';`;

        throw new Error('Failed to get records from user table');

const updateUserStatusAsPending = async (emailId) => {

    const query = `UPDATE tbl_user SET status = 'PENDING' WHERE emailId = '${emailId}';`;

        throw new Error('Failed to update user status');

exports.updateUserStatusAsPending = updateUserStatusAsPending;

        SELECT d.dropId, d.assetThumbnail, d.title, d.description, a.artistName, d.dropStartTime, d.emailSend

                 INNER JOIN tbl_artist AS a

                            ON d.artistId = a.artistId

const updateDropDetails = async (dropId) => {

    "eslint-config-airbnb-base": "^14.2.1",

		{
		"name": "sindric-lib-email-notifier",
		"version": "2.2.1",
		"version": "2.2.2",
		"description": "",
		@@ -5,0 +5,0 @@ "main": "dist/index.js",

		@@ -76,3 +76,3 @@ "use strict";
		const getTitleFromItemId = async (itemId) => {
		const query = `select title, itemThumbnail from tbl_item where dropId = "${itemId}";`;
		const query = `select title, itemThumbnail from tbl_item where itemId = "${itemId}";`;
		try {
		@@ -79,0 +79,0 @@ return (await DatabaseConfig_1.database).query(query);