Source

libdb-mock-proto-cpp / DBMockExample.cpp

/*
 Prototype for a mockable database library
 Copyright (C) 2012 Daybo Logic
 All rights reserved.

 Redistribution and use in source and binary forms, with or without
 modification, are permitted provided that the following conditions
 are met:
 1. Redistributions of source code must retain the above copyright
    notice, this list of conditions and the following disclaimer.
 2. Redistributions in binary form must reproduce the above copyright
    notice, this list of conditions and the following disclaimer in the
    documentation and/or other materials provided with the distribution.
 3. Neither the name of the project nor the names of its contributors
    may be used to endorse or promote products derived from this software
    without specific prior written permission.

 THIS SOFTWARE IS PROVIDED BY THE PROJECT AND CONTRIBUTORS ``AS IS'' AND
 ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
 IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
 ARE DISCLAIMED.  IN NO EVENT SHALL THE PROJECT OR CONTRIBUTORS BE LIABLE
 FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL
 DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS
 OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION)
 HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT
 LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY
 OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
 SUCH DAMAGE.
*/

/*
  This is a basic class which shows the concept of creating a table
  in a dynamic, faked database.  It is derived from DBMock.
*/

#include "DBMockExample.hpp"

DBMockExample::DBMockExample()
{
	this->name("DBMockExample");
	this->CreateTables();
	this->PopulateData();
}

void DBMockExample::CreateTables()
{
	this->query(
		"CREATE TABLE offices (\n"
		"	id INTEGER NOT NULL PRIMARY KEY,\n"
		"	city CHAR(16)\n"
		")"
	);
	this->query(
		"CREATE TABLE employees (\n"
		"	id INTEGER NOT NULL AUTOINCREMENT PRIMARY KEY,\n"
		"	enrolled DATETIME,\n"
		"	terminated DATETIME\n"
		")"
	);
}

void DBMockExample::PopulateData()
{
	this->query("INSERT INTO offices (city) VALUES(\'London\')");
	this->query("INSERT INTO offices (city) VALUES(\'Bristol\')");
	this->query("INSERT INTO offices (city) VALUES(\'Leeds\')");
	this->query("INSERT INTO offices (city) VALUES(\'Newport\')");
}
Tip: Filter by directory path e.g. /media app.js to search for public/media/app.js.
Tip: Use camelCasing e.g. ProjME to search for ProjectModifiedEvent.java.
Tip: Filter by extension type e.g. /repo .js to search for all .js files in the /repo directory.
Tip: Separate your search with spaces e.g. /ssh pom.xml to search for src/ssh/pom.xml.
Tip: Use ↑ and ↓ arrow keys to navigate and return to view the file.
Tip: You can also navigate files with Ctrl+j (next) and Ctrl+k (previous) and view the file with Ctrl+o.
Tip: You can also navigate files with Alt+j (next) and Alt+k (previous) and view the file with Alt+o.