# Install PostgreSQL adapter
npm install pg pg-hstore

# Database schema creation
CREATE TABLE projects (
  id SERIAL PRIMARY KEY,
  name VARCHAR(100) NOT NULL,
  category VARCHAR(50),
  description TEXT,
  model_path TEXT,
  datasheet_path TEXT,
  thumbnail_url TEXT,
  architect_id INTEGER,
  created_at TIMESTAMP DEFAULT NOW(),
  updated_at TIMESTAMP DEFAULT NOW()
);

CREATE TABLE users (
  id SERIAL PRIMARY KEY,
  email VARCHAR(255) UNIQUE NOT NULL,
  password_hash VARCHAR(255),
  role VARCHAR(20) DEFAULT 'user',
  profile_data JSONB,
  created_at TIMESTAMP DEFAULT NOW()
);

# Install MongoDB adapter
npm install mongoose

# Connection configuration
const mongoose = require('mongoose');

const connectDB = async () => {
  try {
    await mongoose.connect(process.env.MONGODB_URI);
    console.log('MongoDB Connected');
  } catch (error) {
    console.error('DB Connection Error:', error);
    process.exit(1);
  }
};

// Project schema
const ProjectSchema = new mongoose.Schema({
  name: { type: String, required: true },
  category: String,
  models: [{ 
    url: String, 
    format: String,
    size: Number 
  }],
  metadata: mongoose.Schema.Types.Mixed
}, { timestamps: true });

# Install AWS SDK
npm install aws-sdk multer-s3

# S3 configuration
const aws = require('aws-sdk');
const multerS3 = require('multer-s3');

const s3 = new aws.S3({
  accessKeyId: process.env.AWS_ACCESS_KEY,
  secretAccessKey: process.env.AWS_SECRET_KEY,
  region: process.env.AWS_REGION
});

const upload = multer({
  storage: multerS3({
    s3: s3,
    bucket: 'serene-creations-files',
    metadata: (req, file, cb) => {
      cb(null, {fieldName: file.fieldname});
    },
    key: (req, file, cb) => {
      const fileName = Date.now().toString() + 
                      '-' + file.originalname;
      cb(null, fileName);
    }
  })
});

# Install Google Cloud SDK
npm install @google-cloud/storage

# GCS configuration
const { Storage } = require('@google-cloud/storage');

const storage = new Storage({
  projectId: process.env.GOOGLE_PROJECT_ID,
  keyFilename: './service-account-key.json'
});

const bucket = storage.bucket('serene-projects-bucket');

const uploadToGCS = (file) => {
  return new Promise((resolve, reject) => {
    const gcsFile = bucket.file(file.originalname);
    const stream = gcsFile.createWriteStream({
      metadata: {
        contentType: file.mimetype,
        cacheControl: 'public, max-age=31536000'
      }
    });
    
    stream.end(file.buffer);
    stream.on('finish', () => resolve(gcsFile.publicUrl()));
    stream.on('error', reject);
  });
};

# Install email service
npm install @sendgrid/mail

# Email configuration
const sgMail = require('@sendgrid/mail');
sgMail.setApiKey(process.env.SENDGRID_API_KEY);

const sendProjectNotification = async (data) => {
  const msg = {
    to: data.recipientEmail,
    from: '[email protected]',
    subject: 'New Project Available',
    templateId: 'd-1234567890abcdef',
    dynamicTemplateData: {
      projectName: data.projectName,
      category: data.category,
      viewUrl: data.viewUrl
    }
  };
  
  try {
    await sgMail.send(msg);
    console.log('Email sent successfully');
  } catch (error) {
    console.error('Email error:', error);
  }
};

# Install Firebase Admin SDK
npm install firebase-admin

# Firebase configuration
const admin = require('firebase-admin');

admin.initializeApp({
  credential: admin.credential.cert({
    projectId: process.env.FIREBASE_PROJECT_ID,
    privateKey: process.env.FIREBASE_PRIVATE_KEY,
    clientEmail: process.env.FIREBASE_CLIENT_EMAIL
  })
});

# Verify ID tokens
const verifyToken = async (idToken) => {
  try {
    const decodedToken = await admin
      .auth()
      .verifyIdToken(idToken);
    return decodedToken;
  } catch (error) {
    throw new Error('Invalid token');
  }
};