Function insertTestArticle

server/tests/integration/addie-learning.test.ts:96–127

(options: {
      title: string;
      daysAgo?: number;
      qualityScore?: number;
      tags?: string[];
      topic?: string;
    })

    });

    async function insertTestArticle(options: {
      title: string;
      daysAgo?: number;
      qualityScore?: number;
      tags?: string[];
      topic?: string;
    }) {
      const fetchedAt = new Date();
      if (options.daysAgo) {
        fetchedAt.setDate(fetchedAt.getDate() - options.daysAgo);
      }

      await pool.query(
        `INSERT INTO addie_knowledge (
          title, category, content, source_url, source_type, fetch_status,
          last_fetched_at, quality_score, relevance_tags, summary, is_active
        ) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11)`,
        [
          `${TEST_NEWS_PREFIX}${options.title}`,
          'news',
          options.topic ? `Content about ${options.topic}` : 'Test article content',
          `https://example.com/${options.title.toLowerCase().replace(/\s+/g, '-')}`,
          'rss',
          'success',
          fetchedAt,
          options.qualityScore ?? 4,
          options.tags ?? [],
          `Summary of ${options.title}`,
          true,
        ]
      );
    }

    describe('getRecentNews', () => {
      it('should return recent articles sorted by date', async () => {