TestVPrepare.cpp File Reference

#include "dbwrappers/sqlitedataset.h"
#include <array>
#include <string>
#include <gtest/gtest.h>

Classes
struct	VPrepareNoParamTest
class	VPrepareNoParamTester

Functions
	TEST_P (VPrepareNoParamTester, Sqlite)
	INSTANTIATE_TEST_SUITE_P (TestDbWrappers, VPrepareNoParamTester, testing::ValuesIn(VPrepareNoParamTests))

Variables
const auto	VPrepareNoParamTests

Function Documentation

INSTANTIATE_TEST_SUITE_P()

INSTANTIATE_TEST_SUITE_P	(	TestDbWrappers	,
		VPrepareNoParamTester	,
		testing::ValuesIn(VPrepareNoParamTests)	)

TEST_P()

TEST_P	(	VPrepareNoParamTester	,
		Sqlite	)

Variable Documentation

VPrepareNoParamTests

const auto VPrepareNoParamTests

Initial value:

= std::array{
    VPrepareNoParamTest{"foo", "foo", "foo"},
    
    VPrepareNoParamTest{"SELECT %%s", "SELECT %s", "SELECT %s"},
    VPrepareNoParamTest{"SELECT %%", "SELECT %", "SELECT %"},
    VPrepareNoParamTest{"SELECT %%foo", "SELECT %foo", "SELECT %foo"},
    
    VPrepareNoParamTest{"strftime(\"%%s\",c01)", "strftime(\"%s\",c01)", "strftime(\"%s\",c01)"},
    VPrepareNoParamTest{"CAST(strftime(\"%%s\",c01) AS INTEGER)",
                        "CAST(strftime(\"%s\",c01) AS INTEGER)",
                        "CAST(UNIX_TIMESTAMP(c01) AS SIGNED INTEGER)"},
    VPrepareNoParamTest{"CAST(strftime(\"%%s\",c01) AS REAL)", "CAST(strftime(\"%s\",c01) AS REAL)",
                        "CAST(strftime(\"%s\",c01) AS REAL)"},
    
    VPrepareNoParamTest{"SELECT RANDOM(), foo", "SELECT RANDOM(), foo", "SELECT RAND(), foo"},
    
    VPrepareNoParamTest{"SELECT CAST(foo AS TEXT), bar", "SELECT CAST(foo AS TEXT), bar",
                        "SELECT CAST(foo AS CHAR), bar"},
    VPrepareNoParamTest{"SELECT CAST(foo AS INTEGER), bar", "SELECT CAST(foo AS INTEGER), bar",
                        "SELECT CAST(foo AS SIGNED INTEGER), bar"},
    VPrepareNoParamTest{"SELECT CAST(foo AS REAL), bar", "SELECT CAST(foo AS REAL), bar",
                        "SELECT CAST(foo AS REAL), bar"},
    
    VPrepareNoParamTest{"SELECT foo COLLATE NOCASE, bar", "SELECT foo COLLATE NOCASE, bar",
                        "SELECT foo, bar"},
    VPrepareNoParamTest{"SELECT foo COLLATE ALPHANUM, bar", "SELECT foo COLLATE ALPHANUM, bar",
                        "SELECT foo, bar"},
    VPrepareNoParamTest{"SELECT foo COLLATE BINARY, bar", "SELECT foo COLLATE BINARY, bar",
                        "SELECT foo COLLATE BINARY, bar"},
}