Cloudflare DevelopersCD
Cloudflare Developers•2y ago
roccho

D1 cannot a certain column despite that this column already tested. test'user.register' has already

D1 cannot a certain column despite that this column already tested.
test'user.register' has already been passed.
but when 'validate inserted ...' test, vitest alert us.
FAIL packages/economy/src/route/index.query.test.ts > queries > after ddl > user.register > validate inserted user.register Error: D1_ERROR: no such column: email

Anything wrong?

  describe('after ddl', () => {
    describe('user.register', async () => {
      const { results } = await d1db.prepare('PRAGMA table_info(user);').all()
      const columnNames = results.map((result) => result.name)
      test('user.register column has been created', async () => {
        console.debug('columnNames', columnNames)
        expect(columnNames).toContain('email')
        expect(columnNames).toContain('user_id')
        expect(columnNames).toContain('user_name')
        expect(columnNames).toContain('user_role')
      })

      test('validate inserted user.register', async () => {
        const query = endpoints.user.register.query.insert_user({
          email: 'email',
          user_id: 'user_id',
          user_name: 'user_name',
          user_role: 'user_role',
        })
        await d1db.prepare(query).run()
        const { results } = await d1db.prepare('SELECT * FROM user;').all()
Was this page helpful?