Introduction Ask Anything

Delete all routes node 1 Delete all routes node 2

Transaction log

Drop schema 'tx_log_test'

Wait for node 2 restart Restart node 2

Wait for node 1 restart Remove node on node 2

Wait for node 1 restart Drop schema 'incredible_bulk' node 2

Drop schema four node 1 Drop schema four node 3 Drop schema four node 4 Configure cluster node 2 drop all nodes

Clean up routes

Wait for node 1 restart Wait for node 2 restart Wait for node 3 restart Wait for node 4 restart

Five_Node_Cluster

Add Schemas and Tables

CREATE TABLE hub2 on Node 1 CREATE TABLE collar2 on Node 2

Check Cluster Node1 Check other cluster after adding node Check Cluster Node3 Check Cluster Node4 Check Cluster Node5

Test schema/table/attr propagation

RE-CREATE TABLE hub2 on Node1 TEST that schema treat_sys still exists on Node2 TEST that schema treat_sys still exists on Node3 TEST correct tables on Node4 TEST that schema treat_sys still exists on Node5

Test insert/update/upsert propagation

TEST upserted data NOT in Node2 TEST data in Node1 TEST more updated data in Node5 TEST more updated data NOT in Node3 TEST upserted data in Node4

Test Roles with Insert/Update/Read/Delete

Drop_role - non-SU role CONFIRM nonSU deletes data in Node2 Try to Read with non SU on Node3 Try to Read with non SU on Node5 CONFIRM nonSU deletes data in Node4

Bulk Add Records

Confirm data in Node1 Confirm data not in Node5 Confirm data in Node3 Confirm data in Node2 Confirm data in Node4

Confirm delete record on Node1 Confirm delete record on Node2 Confirm delete record on Node4 Confirm delete record on Node5 Confirm Not delete on Node3

DELETE routes Confirm dropped schema Node2 Confirm dropped schema Node3 Confirm dropped schema Node4 Confirm dropped schema Node5

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

NoSQL Operations

Search By Conditions

Bulk Operations

Users and Roles

Configure Cluster

Custom Functions

Deploy Custom Function Project

Search Jobs By Start Date

Delete Audit Logs Before

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

HarperDB 4.1.0-SQL Operations

HarperDB 4.1.0-Bulk Operations

HarperDB 4.1.0-Users and Roles

HarperDB 4.1.0-Clustering

Configure Cluster

HarperDB 4.1.0-Custom Functions

Deploy Custom Function Project

HarperDB 4.1.0-Registration

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

HarperDB 4.0.0-NoSQL Operations

Search By Conditions

HarperDB 4.0.0-SQL Operations

HarperDB 4.0.0-Bulk Operations

HarperDB 4.0.0-Users and Roles

HarperDB 4.0.0-Clustering

Configure Cluster

HarperDB 4.0.0-Custom Functions

Deploy Custom Function Project

HarperDB 4.0.0-Registration

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

HarperDB 3.3.0-NoSQL Operations

Search By Conditions

HarperDB 3.3.0-SQL Operations

HarperDB 3.3.0-Bulk Operations

HarperDB 3.3.0-Users and Roles

HarperDB 3.3.0-Clustering

HarperDB 3.3.0-Custom Functions

Deploy Custom Function Project

HarperDB 3.3.0-Registration

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

HarperDB 3.2.1-NoSQL Operations

Search By Conditions

HarperDB 3.2.1-SQL Operations

HarperDB 3.2.1-Bulk Operations

HarperDB 3.2.1-Users and Roles

HarperDB 3.2.1-Clustering

HarperDB 3.2.1-Custom Functions

Deploy Custom Function Project

HarperDB 3.2.1-Registration

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

HarperDB 3.0.0-NoSQL Operations

Search By Conditions

HarperDB 3.0.0-SQL Operations

HarperDB 3.0.0-Bulk Operations

HarperDB 3.0.0-Users and Roles

HarperDB 3.0.0-Clustering

HarperDB 3.0.0-Registration

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

HarperDB 2.3.0-NoSQL Operations

Search By Value

HarperDB 2.3.0-SQL Operations

HarperDB 2.3.0-Bulk Operations

HarperDB 2.3.0-Users and Roles

HarperDB 2.3.0-Clustering

HarperDB 2.3.0-Registration

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

HarperDB 2.2.0-NoSQL Operations

Search By Value

HarperDB 2.2.0-SQL Operations

HarperDB 2.2.0-CSV Operations

HarperDB 2.2.0-Users and Roles

HarperDB 2.2.0-Clustering

HarperDB 2.2.0-Registration

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

HarperDB 2.1.2-NoSQL Operations

Search By Value

HarperDB 2.1.2-SQL Operations

HarperDB 2.1.2-CSV Operations

HarperDB 2.1.2-Users and Roles

HarperDB 2.1.2-Clustering

HarperDB 2.1.2-Registration

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

HarperDB 1.3.2-Bulk Data Load

csv_url_load csv_file_load

HarperDB 1.3.2-Core Operations

search_by_value search_by_hash

HarperDB 1.3.2-Roles & Users

drop_user list_users

HarperDB 1.3.2-Utility

HarperDB 1.3.2-SQL

HarperDB 1.3.2-Jobs

HarperDB 1.1.0-QuickStart

SQL Complex SELECT

HarperDB 1.1.0- Schemas & Tables

HarperDB 1.1.0-Bulk Data Load-Core Operations

search_by_value search_by_hash

HarperDB 1.1.0-Bulk Data Load

csv_url_load csv_file_load

HarperDB 1.1.0-Core Operations

search_by_value search_by_hash

HarperDB 1.1.0-Roles & Users

drop_user list_users

HarperDB 1.1.0-Utility

HarperDB 1.1.0-SQL

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

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

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

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

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 role Test local studio HTML is returned

13. System Information

Get some System Information (time, memory)

test refresh_operation_token with incorrect token

15. Custom Functions & components

drop deploy-test-gh call custom function

16. Terminology Updates

drop_database job_guy

17. Environment Clean Up

drop schema test_delete_before (disabled)

Postman to Markdown

Generate Markdown

Introduction Ask Anything

Delete all routes node 1 Delete all routes node 2

Transaction log

Drop schema 'tx_log_test'

Wait for node 2 restart Restart node 2

Wait for node 1 restart Remove node on node 2

Wait for node 1 restart Drop schema 'incredible_bulk' node 2

Drop schema four node 1 Drop schema four node 3 Drop schema four node 4 Configure cluster node 2 drop all nodes

Clean up routes

Wait for node 1 restart Wait for node 2 restart Wait for node 3 restart Wait for node 4 restart

Five_Node_Cluster

Add Schemas and Tables

CREATE TABLE hub2 on Node 1 CREATE TABLE collar2 on Node 2

Check Cluster Node1 Check other cluster after adding node Check Cluster Node3 Check Cluster Node4 Check Cluster Node5

Test schema/table/attr propagation

RE-CREATE TABLE hub2 on Node1 TEST that schema treat_sys still exists on Node2 TEST that schema treat_sys still exists on Node3 TEST correct tables on Node4 TEST that schema treat_sys still exists on Node5

Test insert/update/upsert propagation

TEST upserted data NOT in Node2 TEST data in Node1 TEST more updated data in Node5 TEST more updated data NOT in Node3 TEST upserted data in Node4

Test Roles with Insert/Update/Read/Delete

Drop_role - non-SU role CONFIRM nonSU deletes data in Node2 Try to Read with non SU on Node3 Try to Read with non SU on Node5 CONFIRM nonSU deletes data in Node4

Bulk Add Records

Confirm data in Node1 Confirm data not in Node5 Confirm data in Node3 Confirm data in Node2 Confirm data in Node4

Confirm delete record on Node1 Confirm delete record on Node2 Confirm delete record on Node4 Confirm delete record on Node5 Confirm Not delete on Node3

DELETE routes Confirm dropped schema Node2 Confirm dropped schema Node3 Confirm dropped schema Node4 Confirm dropped schema Node5

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

NoSQL Operations

Search By Conditions

Bulk Operations

Users and Roles

Configure Cluster

Custom Functions

Deploy Custom Function Project

Search Jobs By Start Date

Delete Audit Logs Before

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

HarperDB 4.1.0-SQL Operations

HarperDB 4.1.0-Bulk Operations

HarperDB 4.1.0-Users and Roles

HarperDB 4.1.0-Clustering

Configure Cluster

HarperDB 4.1.0-Custom Functions

Deploy Custom Function Project

HarperDB 4.1.0-Registration

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

HarperDB 4.0.0-NoSQL Operations

Search By Conditions

HarperDB 4.0.0-SQL Operations

HarperDB 4.0.0-Bulk Operations

HarperDB 4.0.0-Users and Roles

HarperDB 4.0.0-Clustering

Configure Cluster

HarperDB 4.0.0-Custom Functions

Deploy Custom Function Project

HarperDB 4.0.0-Registration

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

HarperDB 3.3.0-NoSQL Operations

Search By Conditions

HarperDB 3.3.0-SQL Operations

HarperDB 3.3.0-Bulk Operations

HarperDB 3.3.0-Users and Roles

HarperDB 3.3.0-Clustering

HarperDB 3.3.0-Custom Functions

Deploy Custom Function Project

HarperDB 3.3.0-Registration

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

HarperDB 3.2.1-NoSQL Operations

Search By Conditions

HarperDB 3.2.1-SQL Operations

HarperDB 3.2.1-Bulk Operations

HarperDB 3.2.1-Users and Roles

HarperDB 3.2.1-Clustering

HarperDB 3.2.1-Custom Functions

Deploy Custom Function Project

HarperDB 3.2.1-Registration

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

HarperDB 3.0.0-NoSQL Operations

Search By Conditions

HarperDB 3.0.0-SQL Operations

HarperDB 3.0.0-Bulk Operations

HarperDB 3.0.0-Users and Roles

HarperDB 3.0.0-Clustering

HarperDB 3.0.0-Registration

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

HarperDB 2.3.0-NoSQL Operations

Search By Value

HarperDB 2.3.0-SQL Operations

HarperDB 2.3.0-Bulk Operations

HarperDB 2.3.0-Users and Roles

HarperDB 2.3.0-Clustering

HarperDB 2.3.0-Registration

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

HarperDB 2.2.0-NoSQL Operations

Search By Value

HarperDB 2.2.0-SQL Operations

HarperDB 2.2.0-CSV Operations

HarperDB 2.2.0-Users and Roles

HarperDB 2.2.0-Clustering

HarperDB 2.2.0-Registration

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

HarperDB 2.1.2-NoSQL Operations

Search By Value

HarperDB 2.1.2-SQL Operations

HarperDB 2.1.2-CSV Operations

HarperDB 2.1.2-Users and Roles

HarperDB 2.1.2-Clustering

HarperDB 2.1.2-Registration

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

HarperDB 1.3.2-Bulk Data Load

csv_url_load csv_file_load

HarperDB 1.3.2-Core Operations

search_by_value search_by_hash

HarperDB 1.3.2-Roles & Users

drop_user list_users

HarperDB 1.3.2-Utility

HarperDB 1.3.2-SQL

HarperDB 1.3.2-Jobs

HarperDB 1.1.0-QuickStart

SQL Complex SELECT

HarperDB 1.1.0- Schemas & Tables

HarperDB 1.1.0-Bulk Data Load-Core Operations

search_by_value search_by_hash

HarperDB 1.1.0-Bulk Data Load

csv_url_load csv_file_load

HarperDB 1.1.0-Core Operations

search_by_value search_by_hash

HarperDB 1.1.0-Roles & Users

drop_user list_users

HarperDB 1.1.0-Utility

HarperDB 1.1.0-SQL

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

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

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

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

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 role Test local studio HTML is returned

13. System Information

Get some System Information (time, memory)

test refresh_operation_token with incorrect token

15. Custom Functions & components

drop deploy-test-gh call custom function

16. Terminology Updates

drop_database job_guy

17. Environment Clean Up

drop schema test_delete_before (disabled)

Postman to Markdown

Generate Markdown

Home HarperDB Integration Tests3. SQLTests-Date Function Check

3. SQLTests-Date Function Check

Number of APIs: 1

check that DATE(createdtime) returns correct value w/ correct alias POST {{host}}:{{port}}

select by hash multiple results

check that DATE(__createdtime__) returns correct value w/ correct alias