bcp.c File Reference

#include "common.h"
#include <odbcss.h>
#include <common/test_assert.h>

Include dependency graph for bcp.c:

Go to the source code of this file.

Go to the SVN repository for this file.

Classes
struct	prefixed_int
struct	prefixed_str

Macros
#define	TDSODBC_BCP
#define	VARCHAR_BIND(x)
#define	INT_BIND(x)    bcp_bind( odbc_conn, (unsigned char *) (prefixlen == 0 ? (void*)&x.value : &x), prefixlen, SQL_VARLEN_DATA, NULL, termlen, BCP_TYPE_SQLINT4, col++ )
#define	NULL_BIND(x, type)    bcp_bind( odbc_conn, (unsigned char *) (prefixlen == 0 ? (void*)&x.value : &null_prefix), prefixlen, prefixlen == 0 ? SQL_NULL_DATA : SQL_VARLEN_DATA, NULL, termlen, type, col++ )

Typedefs
typedef char	bcp_init_char_t

Functions
static void	init (void)
static void	test_bind (int prefixlen)
static void	set_attr (void)
static void	report_bcp_error (const char *errmsg, int line, const char *file)
static void	normal_inserts (int prefixlen)
static void	normal_select (void)
static void	special_inserts (void)
static void	special_select (void)
int	main (int argc, char *argv[])

Variables
static struct prefixed_int	not_null_bit = {4, 1}
static struct prefixed_str	not_null_char = {64, "a char"}
static struct prefixed_str	not_null_varchar = {64, "a varchar"}
static struct prefixed_str	not_null_datetime = {64, "2003-12-17 15:44:00.000"}
static struct prefixed_str	not_null_smalldatetime = {64, "2003-12-17 15:44:00"}
static struct prefixed_str	not_null_money = {64, "12.34"}
static struct prefixed_str	not_null_smallmoney = {64, "12.34"}
static struct prefixed_str	not_null_float = {64, "12.34"}
static struct prefixed_str	not_null_real = {64, "12.34"}
static struct prefixed_str	not_null_decimal = {64, "12.34"}
static struct prefixed_str	not_null_numeric = {64, "12.34"}
static struct prefixed_int	not_null_int = {4, 1234}
static struct prefixed_int	not_null_smallint = {4, 1234}
static struct prefixed_int	not_null_tinyint = {4, 123}
static struct prefixed_str	not_null_nvarchar = {64, "a wide var"}
static ODBCINT64	null_prefix = -1
static const char *	expected []
static const int	total_cols = 29
static const char *	expected_special []
static int	tds_version
static const char	table_name [] = "all_types_bcp_unittest"

Macro Definition Documentation

INT_BIND

#define INT_BIND

(

x

)

bcp_bind( odbc_conn, (unsigned char *) (prefixlen == 0 ? (void*)&x.value : &x), prefixlen, SQL_VARLEN_DATA, NULL, termlen, BCP_TYPE_SQLINT4, col++ )

Definition at line 141 of file bcp.c.

NULL_BIND

#define NULL_BIND	(		x,
			type
	)		bcp_bind( odbc_conn, (unsigned char *) (prefixlen == 0 ? (void*)&x.value : &null_prefix), prefixlen, prefixlen == 0 ? SQL_NULL_DATA : SQL_VARLEN_DATA, NULL, termlen, type, col++ )

Definition at line 144 of file bcp.c.

TDSODBC_BCP

#define TDSODBC_BCP

Definition at line 2 of file bcp.c.

VARCHAR_BIND

#define VARCHAR_BIND

(

x

)

Value:

        bcp_bind( odbc_conn, \
                  (unsigned char *) (prefixlen == 0 ? (void*)&x.value : &x), \
                  prefixlen, (SQLINTEGER) strlen(x.value), NULL, termlen, \
                  BCP_TYPE_SQLVARCHAR, col++ )

Definition at line 135 of file bcp.c.

Typedef Documentation

bcp_init_char_t

typedef char bcp_init_char_t

Definition at line 10 of file bcp.c.

Function Documentation

init()

static void init ( void  )

static

Definition at line 62 of file bcp.c.

References odbc_command, and tds_version.

Referenced by main().

main()

int main	(	int	argc,
		char *	argv[]
	)

Definition at line 252 of file bcp.c.

References init(), normal_inserts(), normal_select(), NULL, odbc_command, odbc_connect(), odbc_disconnect(), odbc_set_conn_attr, odbc_tds_version(), set_attr(), special_inserts(), special_select(), util::strcmp(), table_name, and tds_version.

normal_inserts()

static void normal_inserts ( int  prefixlen )

static

Definition at line 289 of file bcp.c.

References bcp_batch(), bcp_done(), bcp_init(), bcp_sendrow(), FAIL, i, NULL, odbc_conn, report_bcp_error(), T, table_name, and test_bind().

Referenced by main().

normal_select()

static void normal_select ( void  )

static

Definition at line 382 of file bcp.c.

References CHKCloseCursor, CHKFetch, CHKGetData, exit(), expected, i, odbc_command, ok, output, SQL_C_CHAR, SQL_NULL_DATA, SQLLEN, util::strcmp(), and total_cols.

Referenced by main().

report_bcp_error()

static void report_bcp_error ( const char *  errmsg, int  line, const char *  file  )

static

Definition at line 238 of file bcp.c.

References file, NULL, odbc_report_error(), and odbc_stmt.

Referenced by normal_inserts(), and special_inserts().

set_attr()

static void set_attr ( void  )

static

Definition at line 232 of file bcp.c.

References odbc_conn, and SQLSetConnectAttr.

Referenced by main().

special_inserts()

static void special_inserts ( void  )

static

Definition at line 325 of file bcp.c.

References bcp_batch(), bcp_bind(), bcp_done(), bcp_init(), bcp_sendrow(), tagTIMESTAMP_STRUCT::day, DBDATETIME::dtdays, DBDATETIME::dttime, FAIL, tagTIMESTAMP_STRUCT::fraction, tagTIMESTAMP_STRUCT::hour, tagTIMESTAMP_STRUCT::minute, tagTIMESTAMP_STRUCT::month, not_null_bit, NULL, odbc_conn, tagSQL_NUMERIC_STRUCT::precision, report_bcp_error(), tagSQL_NUMERIC_STRUCT::scale, tagTIMESTAMP_STRUCT::second, tagSQL_NUMERIC_STRUCT::sign, SQL_NULL_DATA, T, tagSQL_NUMERIC_STRUCT::val, and tagTIMESTAMP_STRUCT::year.

Referenced by main().

special_select()

static void special_select ( void  )

static

Definition at line 414 of file bcp.c.

References CHKCloseCursor, CHKFetch, CHKGetData, exit(), expected_special, i, odbc_command, ok, output, SQL_C_CHAR, SQLLEN, and util::strcmp().

Referenced by main().

test_bind()

static void test_bind ( int  prefixlen )

static

Definition at line 148 of file bcp.c.

References assert, INT_BIND, not_null_bit, not_null_char, not_null_datetime, not_null_decimal, not_null_float, not_null_int, not_null_money, not_null_numeric, not_null_nvarchar, not_null_real, not_null_smalldatetime, not_null_smallint, not_null_smallmoney, not_null_tinyint, not_null_varchar, NULL_BIND, SUCCEED, and VARCHAR_BIND.

Referenced by normal_inserts().

Variable Documentation

expected

const char* expected[]

static

Initial value:

= {
    "1",
    "a char    ","a varchar","2003-12-17 15:44:00.000","2003-12-17 15:44:00",
    "12.34","12.34","12.34","12.3400002","12.34","12.34",
    "1234","1234","123",
    "a wide var",
}

Definition at line 42 of file bcp.c.

Referenced by BOOST_AUTO_TEST_CASE(), CNewCleanup_imp::CdRegionEC(), char_test(), check_contains(), check_is(), CheckDiffs(), CheckLocalId(), CheckPrintPubProblems(), CheckPropagatedLocation(), CheckReturnCode(), CheckStrings(), CheckTargetedLocusEntry(), CheckType(), AbstractParser::Consume(), SPSG_Throttling::Discovered(), doFetch(), AbstractParser::Expect(), AbstractParser::ExpectSymbol(), get_results(), CPMCIDConverterServer::GetPmids(), IsMatchingIdMissing(), main(), normal_select(), odbc_get_cmd_line(), CMultiSourceWriterImpl::Open(), AbstractParser::ParseError(), ncbi::TAtomicStack< value_type >::pop_front(), ncbi::TAtomicStack< value_type >::push_front(), query_test(), RemoveStrain(), SPSG_Reply::SItem::Reset(), s_CompareFtables(), s_ReportCharCommentError(), s_USAStateTest(), same_int(), DeBruijn::SAtomic< uint8_t >::Set(), SPSG_Reply::SState::SetStatus(), DeBruijn::CDBGraph::SetVisited(), Test(), test(), test0(), test_row(), TestForRecomb(), TestInput(), TestMultipleEquivBioSources(), TestOneLatLonCountry(), TestOutput(), TestProc(), TestTable(), SPSG_Request::UpdateItem(), AbstractParser::ValueOf(), verify(), CSingleFeatValidator::x_ReportECNumFileStatus(), and CCassQueryList::Yield().

expected_special

const char* expected_special[]

static

Initial value:

= {
    "2015-03-14 15:26:53.000",
    "2015-03-14 15:26:53.589793",
    "3.141593000",
    "3.141593",     
    "",
}

Definition at line 51 of file bcp.c.

Referenced by special_select().

not_null_bit

struct prefixed_int not_null_bit = {4, 1}

static

Definition at line 10 of file bcp.c.

Referenced by special_inserts(), and test_bind().

not_null_char

struct prefixed_str not_null_char = {64, "a char"}

static

Definition at line 10 of file bcp.c.

Referenced by test_bind().

not_null_datetime

struct prefixed_str not_null_datetime = {64, "2003-12-17 15:44:00.000"}

static

Definition at line 10 of file bcp.c.

Referenced by test_bind().

not_null_decimal

struct prefixed_str not_null_decimal = {64, "12.34"}

static

Definition at line 10 of file bcp.c.

Referenced by test_bind().

not_null_float

struct prefixed_str not_null_float = {64, "12.34"}

static

Definition at line 10 of file bcp.c.

Referenced by test_bind().

not_null_int

struct prefixed_int not_null_int = {4, 1234}

static

Definition at line 10 of file bcp.c.

Referenced by test_bind().

not_null_money

struct prefixed_str not_null_money = {64, "12.34"}

static

Definition at line 10 of file bcp.c.

Referenced by test_bind().

not_null_numeric

struct prefixed_str not_null_numeric = {64, "12.34"}

static

Definition at line 10 of file bcp.c.

Referenced by test_bind().

not_null_nvarchar

struct prefixed_str not_null_nvarchar = {64, "a wide var"}

static

Definition at line 10 of file bcp.c.

Referenced by test_bind().

not_null_real

struct prefixed_str not_null_real = {64, "12.34"}

static

Definition at line 10 of file bcp.c.

Referenced by test_bind().

not_null_smalldatetime

struct prefixed_str not_null_smalldatetime = {64, "2003-12-17 15:44:00"}

static

Definition at line 10 of file bcp.c.

Referenced by test_bind().

not_null_smallint

struct prefixed_int not_null_smallint = {4, 1234}

static

Definition at line 10 of file bcp.c.

Referenced by test_bind().

not_null_smallmoney

struct prefixed_str not_null_smallmoney = {64, "12.34"}

static

Definition at line 10 of file bcp.c.

Referenced by test_bind().

not_null_tinyint

struct prefixed_int not_null_tinyint = {4, 123}

static

Definition at line 10 of file bcp.c.

Referenced by test_bind().

not_null_varchar

struct prefixed_str not_null_varchar = {64, "a varchar"}

static

Definition at line 10 of file bcp.c.

Referenced by test_bind().

null_prefix

ODBCINT64 null_prefix = -1

static

Definition at line 40 of file bcp.c.

table_name

const char table_name[] = "all_types_bcp_unittest"

static

Definition at line 249 of file bcp.c.

Referenced by _SQLTables(), CTL_Connection::BCPIn(), CODBC_Connection::BCPIn(), I_Connection::BCPIn(), CDB_Connection::BCPIn(), CBulkInsert::CBulkInsert(), CBulkInsertImpl::CBulkInsertImpl(), CKMetadata::CKMetadata(), CODBC_BCPInCmd::CODBC_BCPInCmd(), CConnection::CreateBulkInsert(), IConnection::CreateBulkInsert(), CDbapiCursorApp::CreateTable(), CTL_BCPInCmd::CTL_BCPInCmd(), CVDBTable::CVDBTable(), CTL_CursorCmd::Delete(), CTL_CursorCmdExpl::Delete(), CODBC_CursorCmd::Delete(), CODBC_CursorCmdExpl::Delete(), CDB_CursorCmd::Delete(), CDbapiSampleApp::DeleteLostTables(), CDbapiSampleApp::DeleteTable(), CDbapiTestSpeedApp::FetchFile(), CDbapiTestSpeedApp::FetchResults(), CConnection::GetBulkInsert(), IConnection::GetBulkInsert(), main(), CSDBAPI::NewBlobStore(), CDatabase::NewBlobStore(), CDatabase::NewBookmark(), CDatabase::NewBulkInsert(), normal_inserts(), CWGSDb_Impl::OpenTable(), Ctbl_feat::Read(), tds_cursor_update(), CTL_CursorCmd::Update(), CDB_CursorCmd::Update(), and CTL_Connection::x_IsLegacyBlobColumnType().

tds_version

int tds_version

static

Definition at line 59 of file bcp.c.

Referenced by CDbapiCtlibCFBase::CreateInstance(), CDbapiOdbcCFBase::CreateInstance(), CTL_Connection::CTL_Connection(), CTL_Connection::GetBLKVersion(), init(), and main().

total_cols

const int total_cols = 29

static

Definition at line 49 of file bcp.c.

Referenced by normal_select().