Qodex.ai
Qodex.ai
IntroductionAsk Anything
Cluster Test C
Routes
Delete all routes node 1Delete all routes node 2
Transaction log
Drop schema 'tx_log_test'
Unidirectional
Wait for node 2 restartRestart node 2
Bidirectional
Wait for node 1 restartRemove node on node 2
Bulk load
Wait for node 1 restartDrop schema 'incredible_bulk' node 2
Four node
Drop schema four node 1Drop schema four node 3Drop schema four node 4Configure cluster node 2 drop all nodes
Clean up routes
Wait for node 1 restartWait for node 2 restartWait for node 3 restartWait for node 4 restart
Five_Node_Cluster
Add Routes
Restart Node1
Add Schemas and Tables
CREATE TABLE hub2 on Node 1CREATE TABLE collar2 on Node 2
Add Nodes
Check Cluster Node1Check other cluster after adding nodeCheck Cluster Node3Check Cluster Node4Check Cluster Node5
Test schema/table/attr propagation
RE-CREATE TABLE hub2 on Node1TEST that schema treat_sys still exists on Node2TEST that schema treat_sys still exists on Node3TEST correct tables on Node4TEST that schema treat_sys still exists on Node5
Test insert/update/upsert propagation
TEST upserted data NOT in Node2TEST data in Node1TEST more updated data in Node5TEST more updated data NOT in Node3TEST upserted data in Node4
Test Roles with Insert/Update/Read/Delete
Drop_role - non-SU roleCONFIRM nonSU deletes data in Node2Try to Read with non SU on Node3Try to Read with non SU on Node5CONFIRM nonSU deletes data in Node4
Bulk Add Records
Confirm data in Node1Confirm data not in Node5Confirm data in Node3Confirm data in Node2Confirm data in Node4
Delete Records
Confirm delete record on Node1Confirm delete record on Node2Confirm delete record on Node4Confirm delete record on Node5Confirm Not delete on Node3
Cleanup
DELETE routesConfirm dropped schema Node2Confirm dropped schema Node3Confirm dropped schema Node4Confirm dropped schema Node5
HarperDB 4.2.0
QuickStart Examples
Select Dogs and Join Breed
Advanced JSON SQL Examples
search_json as a condition, in a select with a table join
Schemas and Tables
Drop Attribute
NoSQL Operations
Search By Conditions
SQL Operations
Delete
Bulk Operations
Import from S3
Users and Roles
Drop User
Clustering
Configure Cluster
Custom Functions
Deploy Custom Function Project
Registration
Set License
Jobs
Search Jobs By Start Date
Logs
Delete Audit Logs Before
Utilities
Set Configuration
Token Authentication
Refresh Operation Token
HarperDB API Archive
HarperDB 4.1.0-QuickStart Examples
Select Dogs and Join Breed
HarperDB 4.1.0-Advanced JSON SQL Examples
search_json as a condition, in a select with a table join
HarperDB 4.1.0-NoSQL Operations
Search By Conditions
HarperDB 4.1.0-Schemas and Tables
Drop Attribute
HarperDB 4.1.0-SQL Operations
Delete
HarperDB 4.1.0-Bulk Operations
Import from S3
HarperDB 4.1.0-Users and Roles
Drop User
HarperDB 4.1.0-Clustering
Configure Cluster
HarperDB 4.1.0-Custom Functions
Deploy Custom Function Project
HarperDB 4.1.0-Registration
Set License
HarperDB 4.1.0-Jobs
Search Jobs By Start Date
HarperDB 4.1.0-Logs
Delete Audit Logs Before
HarperDB 4.1.0-Utilities
Set Configuration
HarperDB 4.1.0-Token Authentication
Refresh Operation Token
HarperDB 4.0.0-QuickStart Examples
Select Dogs and Join Breed
HarperDB 4.0.0-Advanced JSON SQL Examples
search_json as a condition, in a select with a table join
HarperDB 4.0.0-Schemas and Tables
Drop Attribute
HarperDB 4.0.0-NoSQL Operations
Search By Conditions
HarperDB 4.0.0-SQL Operations
Delete
HarperDB 4.0.0-Bulk Operations
Import from S3
HarperDB 4.0.0-Users and Roles
Drop User
HarperDB 4.0.0-Clustering
Configure Cluster
HarperDB 4.0.0-Custom Functions
Deploy Custom Function Project
HarperDB 4.0.0-Registration
Set License
HarperDB 4.0.0-Jobs
Search Jobs By Start Date
HarperDB 4.0.0-Logs
Delete Audit Logs Before
HarperDB 4.0.0-Utilities
Set Configuration
HarperDB 4.0.0-Token Authentication
Refresh Operation Token
HarperDB 3.3.0-QuickStart Examples
Select Dogs and Join Breed
HarperDB 3.3.0-Advanced JSON SQL Examples
search_json as a condition, in a select with a table join
HarperDB 3.3.0-Schemas and Tables
Drop Attribute
HarperDB 3.3.0-NoSQL Operations
Search By Conditions
HarperDB 3.3.0-SQL Operations
Delete
HarperDB 3.3.0-Bulk Operations
Import from S3
HarperDB 3.3.0-Users and Roles
Drop User
HarperDB 3.3.0-Clustering
Cluster Status
HarperDB 3.3.0-Custom Functions
Deploy Custom Function Project
HarperDB 3.3.0-Registration
Set License
HarperDB 3.3.0-Jobs
Search Jobs By Start Date
HarperDB 3.3.0-Logs
Delete Transaction Log Before
HarperDB 3.3.0-Utilities
Set Configuration
HarperDB 3.3.0-Token Authentication
Refresh Operation Token
HarperDB 3.2.1-QuickStart Examples
Select Dogs and Join Breed
HarperDB 3.2.1-Advanced JSON SQL Examples
search_json as a condition, in a select with a table join
HarperDB 3.2.1-Schemas and Tables
Drop Attribute
HarperDB 3.2.1-NoSQL Operations
Search By Conditions
HarperDB 3.2.1-SQL Operations
Delete
HarperDB 3.2.1-Bulk Operations
Import from S3
HarperDB 3.2.1-Users and Roles
Drop User
HarperDB 3.2.1-Clustering
Cluster Status
HarperDB 3.2.1-Custom Functions
Deploy Custom Function Project
HarperDB 3.2.1-Registration
Set License
HarperDB 3.2.1-Jobs
Search Jobs By Start Date
HarperDB 3.2.1-Logs
Delete Transaction Log Before
HarperDB 3.2.1-Utilities
Set Configuration
HarperDB 3.2.1-Token Authentication
Refresh Operation Token
HarperDB 3.0.0-QuickStart Examples
Select Dogs and Join Breed
HarperDB 3.0.0-Advanced JSON SQL Examples
search_json as a condition, in a select with a table join
HarperDB 3.0.0-Schemas and Tables
Drop Attribute
HarperDB 3.0.0-NoSQL Operations
Search By Conditions
HarperDB 3.0.0-SQL Operations
Delete
HarperDB 3.0.0-Bulk Operations
Import from S3
HarperDB 3.0.0-Users and Roles
List Users
HarperDB 3.0.0-Clustering
Cluster Status
HarperDB 3.0.0-Registration
Set License
HarperDB 3.0.0-Jobs
Search Jobs By Start Date
HarperDB 3.0.0-Logs
Delete Transaction Log Before
HarperDB 3.0.0-Utilities
Set Configuration
HarperDB 3.0.0-Token Authentication
Refresh Operation Token
HarperDB 2.3.0-QuickStart Examples
Select Dogs and Join Breed
HarperDB 2.3.0-Advanced JSON SQL Examples
search_json as a condition, in a select with a table join
HarperDB 2.3.0-Schemas and Tables
Drop Attribute
HarperDB 2.3.0-NoSQL Operations
Search By Value
HarperDB 2.3.0-SQL Operations
Delete
HarperDB 2.3.0-Bulk Operations
Import from S3
HarperDB 2.3.0-Users and Roles
List Users
HarperDB 2.3.0-Clustering
Cluster Status
HarperDB 2.3.0-Registration
Set License
HarperDB 2.3.0-Jobs
Search Jobs By Start Date
HarperDB 2.3.0-Logs
Delete Transaction Log Before
HarperDB 2.3.0-Utilities
System Information
HarperDB 2.3.0-Token Authentication
Create Authentication Tokens
HarperDB 2.2.0-QuickStart Examples
Select Dogs And Join Breed
HarperDB 2.2.0-Advanced JSON SQL Examples
search_json as a condition, in a select with a table join
HarperDB 2.2.0-Schemas and Tables
Drop Attribute
HarperDB 2.2.0-NoSQL Operations
Search By Value
HarperDB 2.2.0-SQL Operations
Delete
HarperDB 2.2.0-CSV Operations
CSV URL Load
HarperDB 2.2.0-Users and Roles
List Users
HarperDB 2.2.0-Clustering
Cluster Status
HarperDB 2.2.0-Registration
Set License
HarperDB 2.2.0-Jobs
Search Jobs By Start Date
HarperDB 2.2.0-Logs
Delete Transaction Log Before
HarperDB 2.2.0-Utilities
System Information
HarperDB 2.1.2-QuickStart Examples
Select Dogs And Join Breed
HarperDB 2.1.2-Advanced JSON SQL Examples
search_json as a condition, in a select with a table join
HarperDB 2.1.2-Schemas and Tables
Drop Attribute
HarperDB 2.1.2-NoSQL Operations
Search By Value
HarperDB 2.1.2-SQL Operations
Delete
HarperDB 2.1.2-CSV Operations
CSV URL Load
HarperDB 2.1.2-Users and Roles
List Users
HarperDB 2.1.2-Clustering
Cluster Status
HarperDB 2.1.2-Registration
Set License
HarperDB 2.1.2-Utilities
System Information
HarperDB 2.1.2-Jobs
Search Jobs By Start Date
HarperDB 1.3.2-QuickStart
SQL Complex SELECT
HarperDB 1.3.2-Schemas & Tables
drop_table
HarperDB 1.3.2-Bulk Data Load
csv_url_loadcsv_file_load
HarperDB 1.3.2-Core Operations
search_by_valuesearch_by_hash
HarperDB 1.3.2-Roles & Users
drop_userlist_users
HarperDB 1.3.2-Utility
cluster_status
HarperDB 1.3.2-SQL
SQL_delete
HarperDB 1.3.2-Jobs
export_to_s3
HarperDB 1.1.0-QuickStart
SQL Complex SELECT
HarperDB 1.1.0- Schemas & Tables
drop_table
HarperDB 1.1.0-Bulk Data Load-Core Operations
search_by_valuesearch_by_hash
HarperDB 1.1.0-Bulk Data Load
csv_url_loadcsv_file_load
HarperDB 1.1.0-Core Operations
search_by_valuesearch_by_hash
HarperDB 1.1.0-Roles & Users
drop_userlist_users
HarperDB 1.1.0-Utility
add_node
HarperDB 1.1.0-SQL
SQL_delete
HarperDB API Docs
HarperDB Integration Tests
1. Environment Setup
create_table for conditions tests
2. Data Load-CSV
Check Job Completed
2. Data Load-CSV URL Load
Check CSV job error
2. Data Load-JSON
Insert data into another.breed
2. Data Load-CSV Bulk Load Tests-Invalid Attribute Check
Check Job Failed
2. Data Load-CSV Bulk Load Tests
csv bulk load update confirm
2. Data Load
Update records missing records
3. SQLTests-Invalid Attribute Check
insert some invalid attribute names - multiple rows
3. SQLTests-Search Response Data Type Check
select by hash multiple results
3. SQLTests-Date Function Check
check that DATE(__createdtime__) returns correct value w/ correct alias
3. SQLTests-SEARCH_JSON calls
filter on credits.cast with join to movie
3. SQLTests-SQL INSERT/UPDATE with Expressions & Functions
update value in table for non-existent row
3. SQLTests-Restricted Keywords
Drop table keywords
3. SQLTests-SQL Update dev.cat
Drop table cat from dev.cat
3. SQLTests
Delete dev.dog records previously created
4. NoSQL Tests-Invalid Attribute Check
insert some invalid attribute names - multiple rows
4. NoSQL Tests-Search Response Data Type Check
NoSQL search by value multiple results
4. NoSQL Tests-Test desc / offset / limit
NoSQL search by value reverse offset 20 limit 20
4. NoSQL Tests
search by conditions - ends_with condition, offset, limit of 3
5. NoSQL Role Testing-Bulk Load Perms Tests
Drop bulk_load_user role
5. NoSQL Role Testing
NoSQL drop cluster_user role
6. SQL Role Testing
Drop non-existent role
7. Jobs & Job Role Testing-S3 Operations
Drop S3 schema
7. Jobs & Job Role Testing
Jobs - Delete Jobs_test schema
8. Delete Tests-Delete Records Before Tests
Search by hash confirm
8. Delete Tests-Delete Records Before Alias Tests
Search by hash confirm
8. Delete Tests-Drop schema tests
Drop number number schema
8. Delete Tests-Post drop attribute tests
Drop schema drop_attr
8. Delete Tests
test SQL deleteing with numeric no condition
8a. Restart HDB to update config
Restart for new settings
9. Transactions-Delete Audit Logs Before Tests
Check Delete Audit Logs Job Completed
9. Transactions-Read Transaction Logs
drop test_read table
10. Other Role Tests-Describe ops role testing-super_user tests
Describe Table - table doesn't exist
10. Other Role Tests-Describe ops role testing-[NOMINAL] Non-SU test_user
Drop_role - non-SU role
10. Other Role Tests-Describe ops role testing-Non-SU role w/ NO PERMS
Drop_role - NO PERMS role
10. Other Role Tests-Describe ops role testing-Non-SU role w/ ONE TABLE PERM
Drop_role - ONE TABLE PERMS role
10. Other Role Tests-Add Role - error checks
Add CU role with perms - expect fail
10. Other Role Tests-Test SU-only Ops Permissions
Drop_role - non-SU role
10. Other Role Tests-System schema role perms tests
Delete attribute from system table
10. Other Role Tests-Search schema error checks
Drop role for search schema error checks
10. Other Role Tests
Drop_role for non-SU role
11. Alter User Tests
Drop test non-SU role
12. Configuration-Create_Attribute tests
Confirm attribute secondary indexing works
12. Configuration
Drop_role - non-SU roleTest local studio HTML is returned
13. System Information
Get some System Information (time, memory)
14. Token Auth
test refresh_operation_token with incorrect token
15. Custom Functions & components
drop deploy-test-ghcall custom function
16. Terminology Updates
drop_database job_guy
17. Environment Clean Up
drop schema test_delete_before (disabled)
Postman to Markdown
Generate Markdown
IntroductionAsk Anything
Cluster Test C
Routes
Delete all routes node 1Delete all routes node 2
Transaction log
Drop schema 'tx_log_test'
Unidirectional
Wait for node 2 restartRestart node 2
Bidirectional
Wait for node 1 restartRemove node on node 2
Bulk load
Wait for node 1 restartDrop schema 'incredible_bulk' node 2
Four node
Drop schema four node 1Drop schema four node 3Drop schema four node 4Configure cluster node 2 drop all nodes
Clean up routes
Wait for node 1 restartWait for node 2 restartWait for node 3 restartWait for node 4 restart
Five_Node_Cluster
Add Routes
Restart Node1
Add Schemas and Tables
CREATE TABLE hub2 on Node 1CREATE TABLE collar2 on Node 2
Add Nodes
Check Cluster Node1Check other cluster after adding nodeCheck Cluster Node3Check Cluster Node4Check Cluster Node5
Test schema/table/attr propagation
RE-CREATE TABLE hub2 on Node1TEST that schema treat_sys still exists on Node2TEST that schema treat_sys still exists on Node3TEST correct tables on Node4TEST that schema treat_sys still exists on Node5
Test insert/update/upsert propagation
TEST upserted data NOT in Node2TEST data in Node1TEST more updated data in Node5TEST more updated data NOT in Node3TEST upserted data in Node4
Test Roles with Insert/Update/Read/Delete
Drop_role - non-SU roleCONFIRM nonSU deletes data in Node2Try to Read with non SU on Node3Try to Read with non SU on Node5CONFIRM nonSU deletes data in Node4
Bulk Add Records
Confirm data in Node1Confirm data not in Node5Confirm data in Node3Confirm data in Node2Confirm data in Node4
Delete Records
Confirm delete record on Node1Confirm delete record on Node2Confirm delete record on Node4Confirm delete record on Node5Confirm Not delete on Node3
Cleanup
DELETE routesConfirm dropped schema Node2Confirm dropped schema Node3Confirm dropped schema Node4Confirm dropped schema Node5
HarperDB 4.2.0
QuickStart Examples
Select Dogs and Join Breed
Advanced JSON SQL Examples
search_json as a condition, in a select with a table join
Schemas and Tables
Drop Attribute
NoSQL Operations
Search By Conditions
SQL Operations
Delete
Bulk Operations
Import from S3
Users and Roles
Drop User
Clustering
Configure Cluster
Custom Functions
Deploy Custom Function Project
Registration
Set License
Jobs
Search Jobs By Start Date
Logs
Delete Audit Logs Before
Utilities
Set Configuration
Token Authentication
Refresh Operation Token
HarperDB API Archive
HarperDB 4.1.0-QuickStart Examples
Select Dogs and Join Breed
HarperDB 4.1.0-Advanced JSON SQL Examples
search_json as a condition, in a select with a table join
HarperDB 4.1.0-NoSQL Operations
Search By Conditions
HarperDB 4.1.0-Schemas and Tables
Drop Attribute
HarperDB 4.1.0-SQL Operations
Delete
HarperDB 4.1.0-Bulk Operations
Import from S3
HarperDB 4.1.0-Users and Roles
Drop User
HarperDB 4.1.0-Clustering
Configure Cluster
HarperDB 4.1.0-Custom Functions
Deploy Custom Function Project
HarperDB 4.1.0-Registration
Set License
HarperDB 4.1.0-Jobs
Search Jobs By Start Date
HarperDB 4.1.0-Logs
Delete Audit Logs Before
HarperDB 4.1.0-Utilities
Set Configuration
HarperDB 4.1.0-Token Authentication
Refresh Operation Token
HarperDB 4.0.0-QuickStart Examples
Select Dogs and Join Breed
HarperDB 4.0.0-Advanced JSON SQL Examples
search_json as a condition, in a select with a table join
HarperDB 4.0.0-Schemas and Tables
Drop Attribute
HarperDB 4.0.0-NoSQL Operations
Search By Conditions
HarperDB 4.0.0-SQL Operations
Delete
HarperDB 4.0.0-Bulk Operations
Import from S3
HarperDB 4.0.0-Users and Roles
Drop User
HarperDB 4.0.0-Clustering
Configure Cluster
HarperDB 4.0.0-Custom Functions
Deploy Custom Function Project
HarperDB 4.0.0-Registration
Set License
HarperDB 4.0.0-Jobs
Search Jobs By Start Date
HarperDB 4.0.0-Logs
Delete Audit Logs Before
HarperDB 4.0.0-Utilities
Set Configuration
HarperDB 4.0.0-Token Authentication
Refresh Operation Token
HarperDB 3.3.0-QuickStart Examples
Select Dogs and Join Breed
HarperDB 3.3.0-Advanced JSON SQL Examples
search_json as a condition, in a select with a table join
HarperDB 3.3.0-Schemas and Tables
Drop Attribute
HarperDB 3.3.0-NoSQL Operations
Search By Conditions
HarperDB 3.3.0-SQL Operations
Delete
HarperDB 3.3.0-Bulk Operations
Import from S3
HarperDB 3.3.0-Users and Roles
Drop User
HarperDB 3.3.0-Clustering
Cluster Status
HarperDB 3.3.0-Custom Functions
Deploy Custom Function Project
HarperDB 3.3.0-Registration
Set License
HarperDB 3.3.0-Jobs
Search Jobs By Start Date
HarperDB 3.3.0-Logs
Delete Transaction Log Before
HarperDB 3.3.0-Utilities
Set Configuration
HarperDB 3.3.0-Token Authentication
Refresh Operation Token
HarperDB 3.2.1-QuickStart Examples
Select Dogs and Join Breed
HarperDB 3.2.1-Advanced JSON SQL Examples
search_json as a condition, in a select with a table join
HarperDB 3.2.1-Schemas and Tables
Drop Attribute
HarperDB 3.2.1-NoSQL Operations
Search By Conditions
HarperDB 3.2.1-SQL Operations
Delete
HarperDB 3.2.1-Bulk Operations
Import from S3
HarperDB 3.2.1-Users and Roles
Drop User
HarperDB 3.2.1-Clustering
Cluster Status
HarperDB 3.2.1-Custom Functions
Deploy Custom Function Project
HarperDB 3.2.1-Registration
Set License
HarperDB 3.2.1-Jobs
Search Jobs By Start Date
HarperDB 3.2.1-Logs
Delete Transaction Log Before
HarperDB 3.2.1-Utilities
Set Configuration
HarperDB 3.2.1-Token Authentication
Refresh Operation Token
HarperDB 3.0.0-QuickStart Examples
Select Dogs and Join Breed
HarperDB 3.0.0-Advanced JSON SQL Examples
search_json as a condition, in a select with a table join
HarperDB 3.0.0-Schemas and Tables
Drop Attribute
HarperDB 3.0.0-NoSQL Operations
Search By Conditions
HarperDB 3.0.0-SQL Operations
Delete
HarperDB 3.0.0-Bulk Operations
Import from S3
HarperDB 3.0.0-Users and Roles
List Users
HarperDB 3.0.0-Clustering
Cluster Status
HarperDB 3.0.0-Registration
Set License
HarperDB 3.0.0-Jobs
Search Jobs By Start Date
HarperDB 3.0.0-Logs
Delete Transaction Log Before
HarperDB 3.0.0-Utilities
Set Configuration
HarperDB 3.0.0-Token Authentication
Refresh Operation Token
HarperDB 2.3.0-QuickStart Examples
Select Dogs and Join Breed
HarperDB 2.3.0-Advanced JSON SQL Examples
search_json as a condition, in a select with a table join
HarperDB 2.3.0-Schemas and Tables
Drop Attribute
HarperDB 2.3.0-NoSQL Operations
Search By Value
HarperDB 2.3.0-SQL Operations
Delete
HarperDB 2.3.0-Bulk Operations
Import from S3
HarperDB 2.3.0-Users and Roles
List Users
HarperDB 2.3.0-Clustering
Cluster Status
HarperDB 2.3.0-Registration
Set License
HarperDB 2.3.0-Jobs
Search Jobs By Start Date
HarperDB 2.3.0-Logs
Delete Transaction Log Before
HarperDB 2.3.0-Utilities
System Information
HarperDB 2.3.0-Token Authentication
Create Authentication Tokens
HarperDB 2.2.0-QuickStart Examples
Select Dogs And Join Breed
HarperDB 2.2.0-Advanced JSON SQL Examples
search_json as a condition, in a select with a table join
HarperDB 2.2.0-Schemas and Tables
Drop Attribute
HarperDB 2.2.0-NoSQL Operations
Search By Value
HarperDB 2.2.0-SQL Operations
Delete
HarperDB 2.2.0-CSV Operations
CSV URL Load
HarperDB 2.2.0-Users and Roles
List Users
HarperDB 2.2.0-Clustering
Cluster Status
HarperDB 2.2.0-Registration
Set License
HarperDB 2.2.0-Jobs
Search Jobs By Start Date
HarperDB 2.2.0-Logs
Delete Transaction Log Before
HarperDB 2.2.0-Utilities
System Information
HarperDB 2.1.2-QuickStart Examples
Select Dogs And Join Breed
HarperDB 2.1.2-Advanced JSON SQL Examples
search_json as a condition, in a select with a table join
HarperDB 2.1.2-Schemas and Tables
Drop Attribute
HarperDB 2.1.2-NoSQL Operations
Search By Value
HarperDB 2.1.2-SQL Operations
Delete
HarperDB 2.1.2-CSV Operations
CSV URL Load
HarperDB 2.1.2-Users and Roles
List Users
HarperDB 2.1.2-Clustering
Cluster Status
HarperDB 2.1.2-Registration
Set License
HarperDB 2.1.2-Utilities
System Information
HarperDB 2.1.2-Jobs
Search Jobs By Start Date
HarperDB 1.3.2-QuickStart
SQL Complex SELECT
HarperDB 1.3.2-Schemas & Tables
drop_table
HarperDB 1.3.2-Bulk Data Load
csv_url_loadcsv_file_load
HarperDB 1.3.2-Core Operations
search_by_valuesearch_by_hash
HarperDB 1.3.2-Roles & Users
drop_userlist_users
HarperDB 1.3.2-Utility
cluster_status
HarperDB 1.3.2-SQL
SQL_delete
HarperDB 1.3.2-Jobs
export_to_s3
HarperDB 1.1.0-QuickStart
SQL Complex SELECT
HarperDB 1.1.0- Schemas & Tables
drop_table
HarperDB 1.1.0-Bulk Data Load-Core Operations
search_by_valuesearch_by_hash
HarperDB 1.1.0-Bulk Data Load
csv_url_loadcsv_file_load
HarperDB 1.1.0-Core Operations
search_by_valuesearch_by_hash
HarperDB 1.1.0-Roles & Users
drop_userlist_users
HarperDB 1.1.0-Utility
add_node
HarperDB 1.1.0-SQL
SQL_delete
HarperDB API Docs
HarperDB Integration Tests
1. Environment Setup
create_table for conditions tests
2. Data Load-CSV
Check Job Completed
2. Data Load-CSV URL Load
Check CSV job error
2. Data Load-JSON
Insert data into another.breed
2. Data Load-CSV Bulk Load Tests-Invalid Attribute Check
Check Job Failed
2. Data Load-CSV Bulk Load Tests
csv bulk load update confirm
2. Data Load
Update records missing records
3. SQLTests-Invalid Attribute Check
insert some invalid attribute names - multiple rows
3. SQLTests-Search Response Data Type Check
select by hash multiple results
3. SQLTests-Date Function Check
check that DATE(__createdtime__) returns correct value w/ correct alias
3. SQLTests-SEARCH_JSON calls
filter on credits.cast with join to movie
3. SQLTests-SQL INSERT/UPDATE with Expressions & Functions
update value in table for non-existent row
3. SQLTests-Restricted Keywords
Drop table keywords
3. SQLTests-SQL Update dev.cat
Drop table cat from dev.cat
3. SQLTests
Delete dev.dog records previously created
4. NoSQL Tests-Invalid Attribute Check
insert some invalid attribute names - multiple rows
4. NoSQL Tests-Search Response Data Type Check
NoSQL search by value multiple results
4. NoSQL Tests-Test desc / offset / limit
NoSQL search by value reverse offset 20 limit 20
4. NoSQL Tests
search by conditions - ends_with condition, offset, limit of 3
5. NoSQL Role Testing-Bulk Load Perms Tests
Drop bulk_load_user role
5. NoSQL Role Testing
NoSQL drop cluster_user role
6. SQL Role Testing
Drop non-existent role
7. Jobs & Job Role Testing-S3 Operations
Drop S3 schema
7. Jobs & Job Role Testing
Jobs - Delete Jobs_test schema
8. Delete Tests-Delete Records Before Tests
Search by hash confirm
8. Delete Tests-Delete Records Before Alias Tests
Search by hash confirm
8. Delete Tests-Drop schema tests
Drop number number schema
8. Delete Tests-Post drop attribute tests
Drop schema drop_attr
8. Delete Tests
test SQL deleteing with numeric no condition
8a. Restart HDB to update config
Restart for new settings
9. Transactions-Delete Audit Logs Before Tests
Check Delete Audit Logs Job Completed
9. Transactions-Read Transaction Logs
drop test_read table
10. Other Role Tests-Describe ops role testing-super_user tests
Describe Table - table doesn't exist
10. Other Role Tests-Describe ops role testing-[NOMINAL] Non-SU test_user
Drop_role - non-SU role
10. Other Role Tests-Describe ops role testing-Non-SU role w/ NO PERMS
Drop_role - NO PERMS role
10. Other Role Tests-Describe ops role testing-Non-SU role w/ ONE TABLE PERM
Drop_role - ONE TABLE PERMS role
10. Other Role Tests-Add Role - error checks
Add CU role with perms - expect fail
10. Other Role Tests-Test SU-only Ops Permissions
Drop_role - non-SU role
10. Other Role Tests-System schema role perms tests
Delete attribute from system table
10. Other Role Tests-Search schema error checks
Drop role for search schema error checks
10. Other Role Tests
Drop_role for non-SU role
11. Alter User Tests
Drop test non-SU role
12. Configuration-Create_Attribute tests
Confirm attribute secondary indexing works
12. Configuration
Drop_role - non-SU roleTest local studio HTML is returned
13. System Information
Get some System Information (time, memory)
14. Token Auth
test refresh_operation_token with incorrect token
15. Custom Functions & components
drop deploy-test-ghcall custom function
16. Terminology Updates
drop_database job_guy
17. Environment Clean Up
drop schema test_delete_before (disabled)
Postman to Markdown
Generate Markdown
HomeCluster Test CFour node

Four node

Number of APIs: 4

  1. Drop schema four node 1 POST http://{{NODE1_HOST}}:{{HDB_PORT}}

  2. Drop schema four node 3 POST http://{{NODE3_HOST}}:{{HDB_PORT}}

  3. Drop schema four node 4 POST http://{{NODE4_HOST}}:{{HDB_PORT}}

  4. Configure cluster node 2 drop all nodes POST http://{{NODE2_HOST}}:{{HDB_PORT}}

Previous
Drop schema 'incredible_bulk' node 2
Next
Drop schema four node 1