88d18619bb
Major Features Implemented: - Full Vue.js 3 admin interface with Vite build system - OpenAI Chat Completions API integration (replaced deprecated Assistants API) - PostgreSQL database with Sequelize ORM - Complete conversation management system - User authentication system (admin@oliver.agency, user@oliver.agency) - AI-powered conversation title generation - Server-Sent Events for streaming responses - Conversation soft delete functionality - Rate limiting middleware with development bypass Backend Infrastructure: - Node.js/Express server with comprehensive error handling - Database models: User, Assistant, Conversation, Message - Chat API endpoints with full conversation history context - Conversation CRUD operations with soft delete - Migration and seeding scripts - Environment-based configuration Frontend Features: - Responsive Vue.js interface with router - Real-time chat with streaming responses - Conversation sidebar with delete functionality - Agent selection dropdown - Persistent user sessions with hash-based user IDs - Conversation history loading and continuity - Login system with user role management - Prominent logout functionality Technical Improvements: - Fixed conversation continuity by loading full message history - Implemented conversation title generation using GPT-4o-mini - Added conversation persistence mechanisms (periodic refresh, window focus) - Enhanced error handling and rate limiting - Proper environment variable management - Clean project structure with separated concerns 🤖 Generated with [Claude Code](https://claude.ai/code) Co-Authored-By: Claude <noreply@anthropic.com>
54 lines
No EOL
1.1 KiB
JavaScript
54 lines
No EOL
1.1 KiB
JavaScript
const { DataTypes } = require('sequelize');
|
|
const { sequelize } = require('../config/database');
|
|
|
|
const Conversation = sequelize.define('Conversation', {
|
|
id: {
|
|
type: DataTypes.UUID,
|
|
defaultValue: DataTypes.UUIDV4,
|
|
primaryKey: true,
|
|
},
|
|
userId: {
|
|
type: DataTypes.UUID,
|
|
allowNull: false,
|
|
references: {
|
|
model: 'users',
|
|
key: 'id',
|
|
},
|
|
},
|
|
assistantId: {
|
|
type: DataTypes.UUID,
|
|
allowNull: false,
|
|
references: {
|
|
model: 'assistants',
|
|
key: 'id',
|
|
},
|
|
},
|
|
title: {
|
|
type: DataTypes.STRING,
|
|
allowNull: true,
|
|
},
|
|
status: {
|
|
type: DataTypes.ENUM('active', 'archived', 'deleted'),
|
|
defaultValue: 'active',
|
|
},
|
|
metadata: {
|
|
type: DataTypes.JSONB,
|
|
defaultValue: {},
|
|
},
|
|
lastMessageAt: {
|
|
type: DataTypes.DATE,
|
|
defaultValue: DataTypes.NOW,
|
|
},
|
|
}, {
|
|
tableName: 'conversations',
|
|
timestamps: true,
|
|
indexes: [
|
|
{ fields: ['userId'] },
|
|
{ fields: ['assistantId'] },
|
|
{ fields: ['status'] },
|
|
{ fields: ['lastMessageAt'] },
|
|
{ fields: ['userId', 'status'] },
|
|
],
|
|
});
|
|
|
|
module.exports = Conversation; |