File size: 1,827 Bytes
4bf0aa2
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
import mongoose, { Schema, Document } from 'mongoose';

export interface IPlatformConnection extends Document {
    userId: string; // Firebase UID
    platform: 'amazon' | 'flipkart' | 'bigbasket' | 'jiomart' | 'blinkit';
    platformUserId: string;
    accessToken: string; // Encrypted
    refreshToken: string; // Encrypted
    email: string;
    displayName: string;
    connectedAt: Date;
    lastUsed: Date;
    expiresAt: Date;
    isActive: boolean;
    metadata: {
        accountType?: string;
        preferences?: any;
    };
}

const PlatformConnectionSchema = new Schema<IPlatformConnection>({
    userId: {
        type: String,
        required: true,
        index: true
    },
    platform: {
        type: String,
        required: true,
        enum: ['amazon', 'flipkart', 'bigbasket', 'jiomart', 'blinkit']
    },
    platformUserId: {
        type: String,
        required: true
    },
    accessToken: {
        type: String,
        required: true
    },
    refreshToken: {
        type: String,
        required: true
    },
    email: {
        type: String,
        required: true
    },
    displayName: {
        type: String,
        required: true
    },
    connectedAt: {
        type: Date,
        default: Date.now
    },
    lastUsed: {
        type: Date,
        default: Date.now
    },
    expiresAt: {
        type: Date,
        required: true
    },
    isActive: {
        type: Boolean,
        default: true
    },
    metadata: {
        type: Schema.Types.Mixed,
        default: {}
    }
}, {
    timestamps: true
});

// Compound index for unique user-platform combinations
PlatformConnectionSchema.index({ userId: 1, platform: 1 }, { unique: true });

export const PlatformConnection = mongoose.model<IPlatformConnection>('PlatformConnection', PlatformConnectionSchema);