/sqlite3cc

To get this branch, use:
bzr branch http://bzr.ed.am/sqlite3cc

« back to all changes in this revision

Viewing changes to test/test-main.cc

  • Committer: edam
  • Date: 2010-07-29 06:39:13 UTC
  • Revision ID: edam@waxworlds.org-20100729063913-wvcvkogsa2alwkhr
- moved basic_statement::operator <<() back to basic_statement and just create another specialisation in command so that it can use sqlite::exec

Show diffs side-by-side

added added

removed removed

Lines of Context:
34
34
                boost::filesystem::remove( DBFILE );
35
35
 
36
36
        // open database
37
 
        sqlite::connection db( DBFILE );
38
 
 
39
 
        std::cout << "SQLite threading mode: " << sqlite::threadsafe() << "\n";
 
37
        sqlite::database db( DBFILE );
40
38
 
41
39
        // - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
42
40
 
79
77
        sqlite::query q1( db, "SELECT age, age + 3, name "
80
78
                "FROM pets WHERE NOT age IS NULL "
81
79
                "ORDER BY age ASC" );
82
 
 
83
 
        // test column count and names
84
80
        assert( q1.column_count() == 3 );
85
 
        assert( q1.column_name( 2 ) == "name" );
86
81
 
87
82
        // test rows
88
83
        unsigned int age;
109
104
        // test end of results
110
105
        assert( !q1.step() );
111
106
 
112
 
        // test num results
113
 
        sqlite::query q3( db, "SELECT name FROM pets WHERE age = 16" );
114
 
        assert( q3.num_results() == 2 );
115
 
 
116
107
        // - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
117
108
 
118
 
        // test query iterator
 
109
        // test query itterator
119
110
        sqlite::query q2( db, "SELECT * FROM pets ORDER BY age DESC" );
120
 
        sqlite::query::iterator i1 = q2.begin();
121
 
        assert( i1 != q2.end() );
122
 
 
123
 
        // test resetting iterators
124
 
        unsigned int count = 0;
125
 
        for( sqlite::query::iterator i = q2.begin(); i != q2.end(); i++ )
126
 
        {
127
 
                // test iterator dereferencing and row numbers
128
 
                assert( count++ == i->row_number() );
129
 
                if( i->row_number() == 3 )
 
111
        for( sqlite::query::iterator i = q2.begin(); i != q2.end(); i++ ) {
 
112
                if( i->index() == 3 )
130
113
                        assert( i->column< std::string >( 0 ) == "tessa" &&
131
114
                                i->column< unsigned int >( 1 ) == 16 );
132
 
        }
133
 
 
134
 
//      for( sqlite::query::iterator i = q2.begin(); i != q2.end(); i++ ) {
135
115
//              for( unsigned int a = 0; a < q2.column_count(); a++ )
136
116
//                      std::cout << q2.column_name( a ) << "[" <<
137
117
//                      i->column< std::string >( a ) << "] ";
138
118
//              std::cout << "\n";
139
 
//      }
 
119
        }
 
120
        assert( q2.column_count() == 2 );
 
121
        assert( q2.column_name( 0 ) == "name" );
140
122
 
141
123
        // - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
142
124
 
143
125
        // test transactions
144
 
        {
145
 
                sqlite::transaction_guard< sqlite::deferred_tranaction > t1( db );
146
 
        }
147
 
        {
148
 
                sqlite::transaction_guard< sqlite::immediate_transaction > t1( db );
149
 
        }
150
 
        {
151
 
                sqlite::transaction_guard< sqlite::exclusive_transaction > t1( db );
152
 
        }
153
 
        {
154
 
                sqlite::transaction_guard< sqlite::recursive_transaction > t1( db );
155
 
                sqlite::transaction_guard< sqlite::recursive_transaction > t2( db );
156
 
        }
 
126
        {       sqlite::transaction_guard< > t1( db ); }
 
127
        {       sqlite::transaction_guard< sqlite::exclusive_transaction > t1( db ); }
 
128
        {       sqlite::transaction_guard< sqlite::recursive_transaction > t1( db );
 
129
                sqlite::transaction_guard< sqlite::recursive_transaction > t2( db ); }
157
130
 
158
131
        // test transaction guard rollback
159
132
        {