SDK Quick Reference - Method Testing Results

At a Glance: What Works & What Doesn’t

✅ FULLY WORKING (100% Tested, 100% Pass Rate)

Control Flow (9/9 methods)

• conditional(...).then(...).else(...).endConditional()
• for(), endFor(), while(), endWhile()
• break(), continue(), throw()
• group()

Database (15/15 methods)

• All CRUD: dbQuery(), dbGet(), dbAdd(), dbEdit(), dbDelete()
• Bulk: dbBulkAdd(), dbBulkUpdate(), dbBulkDelete()
• Advanced: dbCount(), dbHas(), dbPatch(), dbTransaction()
• List types: dbQuerySingle(), dbQueryList(), dbQueryCount()

Math (8/8 methods)

• All math operations: mathAdd(), mathSubtract(), mathMultiply(), mathDivide(), mathModulus()
• Bitwise: mathBitwiseAnd(), mathBitwiseOr(), mathBitwiseXor()
• Rounding: mathRound()

Utilities (5/5 methods)

• debug(), response(), concat(), applyFilter(), chainFilters()

⚠️ MOSTLY WORKING (80%+ Success Rate)

Variables (9/10 methods)

• ✅ var(), varArray(), varObject(), varConcat(), varUpdate()
• ✅ All aliases: createVariable(), variable(), updateVariable()
• ❌ buildObject() - use varObject() instead

API Operations (8/10 methods)

• ✅ apiCall(), apiDelete(), apiPut(), apiPatch(), apiGraphql(), apiWebhook(), apiLambda(), apiRetry()
• ❌ apiGet() - use apiCall('GET', ...) instead
• ❌ apiPost() - use apiCall('POST', ...) instead

Objects (8/10 methods)

• ✅ objectKeys(), objectValues(), objectEntries(), objectHas(), objectGet(), objectSet(), objectDelete(), buildObjectWithFilters()
• ❌ objectMerge() - implementation error
• ❌ objectAssign() - doesn’t exist

Security (5/8 methods)

• ✅ requiresAuth(), verifyPassword(), uuid(), randomNumber(), verifyAuthToken()
• ❌ hashPassword() - Xano auto-hashes, not needed
• ❌ createAuthToken() - Different implementation
• ❌ checkPermission() - Not implemented

⚠️ PARTIAL WORKING (50-80% Success Rate)

Arrays (10/15 methods)

• ✅ Working: arrayEvery(), arrayFilter(), arrayFind(), arrayHas(), arrayPush(), arrayPop(), arrayShift(), arrayUnshift(), arrayMerge(), arrayFindIndex()
• ❌ Missing: arrayMap(), arrayReverse(), arraySort(), arraySlice(), arrayJoin()
• Workaround: Use XanoScript filters with applyFilter() or chainFilters()

Text (9/15 methods)

• ✅ Working: textUpper(), textLower(), textTrim(), textSplit(), textReplace(), textStartsWith(), textEndsWith(), textSubstring(), textLength()
• ❌ Missing: textCapitalize(), textIncludes(), textPadStart(), textPadEnd(), textIndexOf(), textSlice()
• Workaround: Use XanoScript filters for advanced text operations

❌ NOT TESTED YET (228 Methods - 68% of SDK)

High Priority (50 methods)

• Storage operations (7/25 TESTED - 28%)
  • ✅ WORKING: storageCreateImage(), storageCreateVideo(), storageCreateAudio(), storageCreateAttachment(), storageCreateFileResource(), storageReadFileResource(), storageSignPrivateUrl()
  • ❌ BROKEN: storageGenerateThumbnail(), storageGenerateUrl() (XanoScript errors)
  • ⚠️ UNTESTED: File management (delete, copy, move), metadata operations, folders
• File operations (15): fileRead(), fileWrite(), fileSave(), etc.
• Cloud operations (15): cloudDeploy(), cloudExecute(), etc.

Important (80 methods)

• Advanced database: dbAdvancedQuery(), dbQueryWithJoins(), dbQueryWithSorting(), etc.
• Stream operations (12): streamFromCsv(), streamFromJsonl(), etc.
• Task methods: taskSchedule(), taskCall(), taskFreq(), etc.
• Algolia search (8): algoliaIndex(), algoliaSearch(), etc.
• Expect methods (15+): expectToBeTrue(), expectToEqual(), etc.

Specialized (100+ methods)

• Advanced security: apiOAuth(), apiSoap(), apiCircuitBreaker()
• Redis operations
• Email operations
• Real-time operations
• Zip archive operations
• Custom validators

Common Mistakes & How to Fix Them

❌ WRONG: Using API Convenience Methods

.apiGet('https://api.test.com', {}, 'result')  // FAILS: apiGet doesn't exist
.apiPost('https://api.test.com', {data: 1}, 'result')  // FAILS: apiPost doesn't exist

✅ CORRECT: Use apiCall with HTTP method

.apiCall('GET', 'https://api.test.com', {}, 'result')
.apiCall('POST', 'https://api.test.com', {data: 1}, 'result')

❌ WRONG: Using else_if

.conditional('$score >= 90')
  .then(b => b.varUpdate('grade', '"A"'))
  .else_if('$score >= 80')  // FAILS: else_if not supported
    .varUpdate('grade', '"B"')
  .endConditional()

✅ CORRECT: Use nested if/else

.conditional('$score >= 90')
  .then(b => b.varUpdate('grade', '"A"'))
  .else(b => {
    b.conditional('$score >= 80')
      .then(b2 => b2.varUpdate('grade', '"B"'))
      .else(b2 => b2.varUpdate('grade', '"C"'))
      .endConditional();
  })
  .endConditional()

❌ WRONG: Using missing array methods

.input('arr', 'json', {default: [1,2,3,4,5]})
.arrayMap('$input.arr', '$item * 2', 'result')  // FAILS: arrayMap doesn't exist

✅ CORRECT: Use filters instead

.input('arr', 'json', {default: [1,2,3,4,5]})
.applyFilter('result', 'map:(item * 2)')
// OR
.var('result', '$input.arr|map:(item * 2)')

❌ WRONG: Password hashing

.input('password', 'text')
.hashPassword('$input.password', 'hashed')  // Deprecated - not needed

✅ CORRECT: Let Xano auto-hash

// Xano automatically hashes passwords on auth tables
// Just create the user with a password field
.dbAdd('users', {
  email: '$input.email',
  password: '$input.password'  // Xano auto-hashes this
}, 'user')

Test Statistics

Production Readiness: By Component

Key Takeaways

1. Core SDK is solid: Control flow, database, API, and math operations are production-ready
2. Method aliases removed: Some convenience aliases documented don’t exist - use primary methods
3. Use filters for advanced ops: Missing array/text methods can be replaced with XanoScript filters
4. 228 methods untested: Need Phase 2-6 testing for Storage, Files, Streams, and specialized operations
5. 82% success on tested methods: High confidence in tested subset

Next Action: See SDK_COMPREHENSIVE_TEST_REPORT.md for full details and Phase 2-6 testing plan.