mpackdb

4.7 KB

1. import MPackDB from '../src/MPackDB.js';
2. import { rm } from 'fs/promises';
4. const TEST_DB_PATH = 'db/prefix';
6. console.log('='.repeat(60));
7. console.log('Primary Key Prefix Syntax Test');
8. console.log('='.repeat(60));
10. await rm(TEST_DB_PATH, { recursive: true, force: true });
12. // ============================================================================
13. // Test 1: *id = numeric primary key
14. // ============================================================================
15. console.log('\n📋 Test 1: *id = numeric primary key');
16. console.log('-'.repeat(60));
18. const db1 = new MPackDB(`${TEST_DB_PATH}/numeric`, {
19. primaryKey: '*id' // No need for primaryKeyType!
20. });
22. await db1.insert({ name: 'Alice', age: 30 });
23. await db1.insert({ name: 'Bob', age: 25 });
25. const all1 = await db1.find();
26. console.log(`✓ Inserted 2 records with auto-increment IDs: ${all1.map(r => r.id).join(', ')}`);
28. const byId1 = await db1.find(0);
29. console.log(`✓ Find by ID (0): ${byId1[0]?.name}`);
31. await db1.close();
33. // ============================================================================
34. // Test 2: @uuid = UUID primary key
35. // ============================================================================
36. console.log('\n📋 Test 2: @uuid = UUID primary key');
37. console.log('-'.repeat(60));
39. const db2 = new MPackDB(`${TEST_DB_PATH}/uuid`, {
40. primaryKey: '@uuid' // No need for primaryKeyType!
41. });
43. await db2.insert({ uuid: 'aaa-111', name: 'Alice', age: 30 });
44. await db2.insert({ uuid: 'bbb-222', name: 'Bob', age: 25 });
46. const all2 = await db2.find();
47. console.log(`✓ Inserted 2 records with UUIDs: ${all2.map(r => r.uuid).join(', ')}`);
49. const byUuid = await db2.find('aaa-111');
50. console.log(`✓ Find by UUID (aaa-111): ${byUuid[0]?.name}`);
52. await db2.close();
54. // ============================================================================
55. // Test 3: username = string primary key (default)
56. // ============================================================================
57. console.log('\n📋 Test 3: username = string primary key (default)');
58. console.log('-'.repeat(60));
60. const db3 = new MPackDB(`${TEST_DB_PATH}/string`, {
61. primaryKey: 'username' // No prefix = string
62. });
64. await db3.insert({ username: 'alice123', name: 'Alice', age: 30 });
65. await db3.insert({ username: 'bob456', name: 'Bob', age: 25 });
67. const all3 = await db3.find();
68. console.log(`✓ Inserted 2 records with usernames: ${all3.map(r => r.username).join(', ')}`);
70. const byUsername = await db3.find('bob456');
71. console.log(`✓ Find by username (bob456): ${byUsername[0]?.name}`);
73. await db3.close();
75. // ============================================================================
76. // Test 4: Mixed indexes with prefixes
77. // ============================================================================
78. console.log('\n📋 Test 4: Mixed indexes with prefixes');
79. console.log('-'.repeat(60));
81. const db4 = new MPackDB(`${TEST_DB_PATH}/mixed`, {
82. primaryKey: '*id', // Numeric primary key
83. indexes: ['email', '*score', '@uuid'], // Lexical, numeric, UUID indexes
84. indexPersistThreshold: 2
85. });
87. await db4.insert({ email: '[email protected]', score: 95, uuid: 'aaa-111' });
88. await db4.insert({ email: '[email protected]', score: 87, uuid: 'bbb-222' });
89. await db4.insert({ email: '[email protected]', score: 92, uuid: 'ccc-333' });
91. await new Promise(resolve => setTimeout(resolve, 100));
93. const all4 = await db4.find();
94. console.log(`✓ Inserted 3 records with mixed indexes`);
96. // Check index files
97. const { readdirSync, statSync } = await import('fs');
98. const indexFiles = readdirSync(TEST_DB_PATH).filter(f => f.startsWith('mixed.') && f.endsWith('.txt'));
99. const nonEmpty = indexFiles.filter(f => statSync(`${TEST_DB_PATH}/${f}`).size > 0);
101. console.log(`✓ Created ${nonEmpty.length} index files: ${nonEmpty.join(', ')}`);
103. await db4.close();
105. // ============================================================================
106. // Test 5: Verify meta.json only has nextId for numeric PK
107. // ============================================================================
108. console.log('\n📋 Test 5: Verify meta.json content');
109. console.log('-'.repeat(60));
111. const { readFileSync } = await import('fs');
113. const meta1 = JSON.parse(readFileSync(`${TEST_DB_PATH}/numeric.meta.json`, 'utf-8'));
114. console.log(`✓ Numeric PK meta: ${JSON.stringify(meta1)} (has nextId: ${meta1.hasOwnProperty('nextId')})`);
116. const meta2 = JSON.parse(readFileSync(`${TEST_DB_PATH}/uuid.meta.json`, 'utf-8'));
117. console.log(`✓ UUID PK meta: ${JSON.stringify(meta2)} (has nextId: ${meta2.hasOwnProperty('nextId')})`);
119. const meta3 = JSON.parse(readFileSync(`${TEST_DB_PATH}/string.meta.json`, 'utf-8'));
120. console.log(`✓ String PK meta: ${JSON.stringify(meta3)} (has nextId: ${meta3.hasOwnProperty('nextId')})`);
122. console.log('\n' + '='.repeat(60));
123. console.log('✓ All prefix syntax tests passed!');
124. console.log('='.repeat(60));