You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
cartodb-postgresql/test
Rafa de la Torre 67663c79aa
Check removal of SECURITY DEFINER
5 years ago
..
extension Check removal of SECURITY DEFINER 5 years ago
organization Remove unnecessary changes 5 years ago
overviews Fix the tests for boolean columns and overview creation 9 years ago
perf Import cartodb/lib/sql/test, add search_path tweaker 11 years ago
CDB_AnalysisCheckTest.sql Fix the test/CDB_AnalysisCheckTest.sql 5 years ago
CDB_AnalysisCheckTest_expect Test cleanup 8 years ago
CDB_CartodbfyTableTest.sql Added test for the case that arose in #325 7 years ago
CDB_CartodbfyTableTest_expect Added test for the case that arose in #325 7 years ago
CDB_DateToNumberTest.sql Makes CDB_DateToNumber() tests more intuitive 2202 9 years ago
CDB_DateToNumberTest_expect Makes CDB_DateToNumber() tests more intuitive 2202 9 years ago
CDB_DigitSeparatorTest.sql Import cartodb/lib/sql/test, add search_path tweaker 11 years ago
CDB_DigitSeparatorTest_expect Use PG 9.5 for travis tests; fix tests 8 years ago
CDB_DistTypeTest.sql adding tests 9 years ago
CDB_DistTypeTest_expect adding tests 9 years ago
CDB_DistinctMeasureTest.sql fixed symlink path, other minor items 9 years ago
CDB_DistinctMeasureTest_expect update test output 9 years ago
CDB_EqualIntervalBinsTest.sql Test behavior of binning fuctions with nulls 9 years ago
CDB_EqualIntervalBinsTest_expect Test behavior of binning fuctions with nulls 9 years ago
CDB_EstimateRowCountTest.sql Add CDB_EstimateRowCount function 8 years ago
CDB_EstimateRowCountTest_expect Add CDB_EstimateRowCount function 8 years ago
CDB_GhostTables.sql fix test 6 years ago
CDB_GhostTables_expect fix test correctly 6 years ago
CDB_GreatCircle.sql Add optional parameter for max. great circle segment length 9 years ago
CDB_GreatCircle_expect Test: Update CDB_GreatCircle_expect for Postgis 2.4 6 years ago
CDB_HeadsTailsBinsTest.sql Test behavior of binning fuctions with nulls 9 years ago
CDB_HeadsTailsBinsTest_expect Test behavior of binning fuctions with nulls 9 years ago
CDB_HelperTest.sql Add a new helper function _CDB_Table_Exists 6 years ago
CDB_HelperTest_expect Add a new helper function _CDB_Table_Exists 6 years ago
CDB_HexagonTest.sql Fix tests 7 years ago
CDB_HexagonTest_expect Fix tests 7 years ago
CDB_JenksBinsTest.sql Jenks: Add test for less data than breaks 6 years ago
CDB_JenksBinsTest_expect Jenks: Add test for less data than breaks 6 years ago
CDB_MathTest.sql added CDB_Math_mode 10 years ago
CDB_MathTest_expect added CDB_Math_mode 10 years ago
CDB_OverviewsTest.sql CDB_OverviewsTest: Run analyze for consistency 6 years ago
CDB_OverviewsTest_expect CDB_OverviewsTest: Run analyze for consistency 6 years ago
CDB_QuantileBinsTest.sql fix alias of column 7 years ago
CDB_QuantileBinsTest_expect moves quantile bins to use postgres precentile functions 7 years ago
CDB_QueryStatementsTest.sql Fix tests 8 years ago
CDB_QueryStatementsTest_expect Fix tests 8 years ago
CDB_QueryTablesTest.sql Use PG 9.5 for travis tests; fix tests 8 years ago
CDB_QueryTablesTest_expect Change querytables expect test 6 years ago
CDB_QuotaTest.sql Fix issues when running under pg10 7 years ago
CDB_QuotaTest_expect Exclude analysis cache tables from the quota 8 years ago
CDB_RectangleTest.sql Fix tests 7 years ago
CDB_RectangleTest_expect Fix tests 7 years ago
CDB_StatsTest.sql Do not use random() for the distribution to test CDB_Stats functions 9 years ago
CDB_StatsTest_expect Raise min message so we don't have to validate notices 9 years ago
CDB_SyncTableTest.sql Add tests for quoted table & column names 5 years ago
CDB_SyncTableTest_expect Add tests for quoted table & column names 5 years ago
CDB_TransformToWebmercatorTest.sql Import cartodb/lib/sql/test, add search_path tweaker 11 years ago
CDB_TransformToWebmercatorTest_expect Import cartodb/lib/sql/test, add search_path tweaker 11 years ago
CDB_UserTablesTest.sql Tests: Only create publicuser if necessary 5 years ago
CDB_UserTablesTest_expect Tests: Only create publicuser if necessary 5 years ago
CDB_Username.sql read tis config from cdb_conf 6 years ago
CDB_Username_expect decouple tests from cartodb 6 years ago
CDB_XYZ_ExtentTest.sql Round extent outputs in test 9 years ago
CDB_XYZ_ExtentTest_expect Round extent outputs in test 9 years ago
Makefile Re-add the test/Makefile which was available while in cartodb/lib/sql 11 years ago
README Add instructions about adding a test 10 years ago

README

Adding tests consists in adding 2 files in this directory: one file

containing the sql code and another containing the expected output.

Example, to add a test for CDB_Something function, you'd add:

- CDB_SomethingTest.sql
- CDB_SomethingTest_expect

To easy the generation of the expected file you can initially omit it,
then run "make -C .. installcheck" from the top-level dir and copy
../results/test/CDB_SomethingTest.out to CDB_SomethingTest_expect chopping
off the first line:

make -C .. installcheck
tail -n +2 ../results/test/CDB_SomethingTest.out > CDB_SomethingTest_expect