Ejemplo n.º 1
0
	virtual void CreateTable()
	{
		Statement stmt(*m_sqliteDriver, "SELECT count(*) FROM sqlite_master WHERE type = 'table' AND name = 'MyTable'");

		if (stmt.executeStep())
		{
			Column col = stmt.getColumn(0);
			int tableCount = col.getInt();
			if (tableCount == 0)
			{
				m_sqliteDriver->execute("create table MyTable(id integer primary key autoincrement,name varchar(100))");
			}
		}
	}
Ejemplo n.º 2
0
//test create
TEST_F(SqliteWrapTest, CreateTable)
{
	int result;
	Statement stmt(*m_sqliteDriver, "SELECT count(*) FROM sqlite_master WHERE type = 'table' AND name = 'MyTable'");

	if (stmt.execute())
	{
		Column col = stmt.getColumn(0);
		int tableCount = col.getInt();
		if (tableCount == 0)
		{
			result = m_sqliteDriver->execute("create table MyTable(id integer primary key autoincrement,name varchar(100))");
			EXPECT_EQ(result, SQLITE_OK);

			Statement stmt(*m_sqliteDriver, "select * from MyTable");
			int column_count = stmt.getColumnCount();
			EXPECT_EQ(column_count, 2);
		}
	}
}