Skip to content

04-Taosdump

taosdump basic
1. Create database and tables with various data types
2. Insert data with special values
3. Use taosdump to export the database
4. Drop the original database
5. Use taosdump to import the database back with different options
6. Verify the imported database, tables, and data
7. Boundary value testing for database and table names
8. Check large data insertion and export/import
9. Check taosdump with different configurations
10. Check taosdump export/import with chinese string value
11. Inspect avro files generated with -I argument
12. Dump/restore a specific normal table in a database
13. Dump/restore some super/child tables in a database
14. Dump/restore database with escaped argument -e
15. Dump/restore into different data types
16. Dump/restore table with many columns(MAX 300 columns)
path: cases/81-Tools/04-Taosdump/test_taosdump_basic.py

taosdump bugs
1. Verify bug TS-2769 (start-time end-time)
2. Verify bug TS-7053 (start-time end-time + precision)
3. Verify bug TS-3072 (database name case sensitivity)
path: cases/81-Tools/04-Taosdump/test_taosdump_bugs.py

taosdump commandline
1. Insert data with taosBenchmark
2. Test taosdump commandline arguments:
- dump in/out with Native/Rest/WebSocket modes
- basic commandline arguments
- except commandline arguments
- check connMode priority cmd > env
3. Verify dump and import data is correctly.
4. Check long password support.
5. Inspect avro files generated with -I argument
6. Dump/restore database with escaped argument -e
path: cases/81-Tools/04-Taosdump/test_taosdump_commandline.py

taosdump compatible
1. Backup data come from v3.1.0.0
2. Restore data with taosdump
3. Verify data correctness
- compare sum value for numeric type
- compare last value for string/boolean type
path: cases/81-Tools/04-Taosdump/test_taosdump_compa.py

taosdump data types
1. taosdump type big int
2. taosdump type binary
3. taosdump type bool
4. taosdump type double
5. taosdump type float
6. taosdump type json
7. taosdump type small int
8. taosdump type int
9. taosdump type tiny int
10. taosdump type unsigned big int
11. taosdump type unsigned int
12. taosdump type unsigned small int
13. taosdump type unsigned tiny int
14. taosdump type geometry
15. taosdump type varbinary
path: cases/81-Tools/04-Taosdump/test_taosdump_datatypes.py

taosdump except
1. taosBenchmark prepare data with super table and normal table
2. taosdump start dump out database
3. Create except with kill -9 taosadapter during dump out
4. Start taosadapter again
5. taosdump dump in database
6. Verify data correctness with sum aggregation
7. Verify data correctness with row by row comparison on some data
path: cases/81-Tools/04-Taosdump/test_taosdump_except.py

taosdump max columns export and round-trip
1. Create supertable with 3968 columns + 128 tags (64-char names)
2. Create normal table with 4096 columns (64-char names)
3. Export database via taosdump
4. Verify avro files are NOT corrupted (size > 100 bytes)
5. Inspect all avro files with --inspect
6. Round-trip test: export with all data types and mixed-case names
7. Drop and restore database
8. Verify schema, column types, case-sensitive names, row counts, and values
path: cases/81-Tools/04-Taosdump/test_taosdump_maxcols.py

taosdump precision
1. Create a database with nanosecond precision and multiple tables
2. Insert data into the tables with nanosecond timestamps
3. Use taosdump to export the entire database
4. Use taosdump to export data within specific time ranges using -S and -E
5. Drop the original database
6. Use taosdump to import the exported data back into the database
7. Verify that the imported data matches the original data for all exports
path: cases/81-Tools/04-Taosdump/test_taosdump_precision.py

taosdump primary key
1. Prepare database with primary key using taosBenchmark
2. Dump out database using taosdump
3. Dump in database using taosdump
4. Verify data correctness with sum aggregation
5. Verify meta correctness with taosBenchmark json file
path: cases/81-Tools/04-Taosdump/test_taosdump_primarykey.py

taosdump privilege
1. Create database and tables with various data types
2. Insert data with non-null and null values
3. Use taosdump to export the database with a non-root user
4. Drop the original database
5. Use taosdump to import the database back with a non-root user
6. Verify the imported database, tables, and data
path: cases/81-Tools/04-Taosdump/test_taosdump_privilege.py

taosdump precision
1. Prepare data with taosBenchmark -f schemaChange.json/schemaChangeNew.json
2. Use taosdump to export the entire database
3. Use taosdump to import the exported data back into a new database
4. Verify that the imported data matches the original data
5. Use taosdump to export specific tables from the original database
6. Use taosdump to import the exported data back into another new database
7. Verify that the imported data matches the original data for the specified tables
8. Drop old super tables and recreate new ones with schema changes (e.g., missing columns or tags)
9. Use taosdump to import the previously exported data into the modified tables
10. Verify that the data import handles the schema changes correctly
11. Test exception handling when the target tables have schema changes (e.g., missing columns or tags)
path: cases/81-Tools/04-Taosdump/test_taosdump_schema_change.py