PostgreSQL/libpqxx Class Generator

// $Id: articlesrs.h 2080 2006-08-18 01:53:19Z phil $
// articlesrs.h: Declaration of the CArticle and CArticlesRS classes

// Generated by pgpqgen 17/08/2006 4:02:29 PM

#pragma once

#include "pqxxTransfer.h"

namespace Database
{
	class CArticle
	{
	public:
		CArticle()
			: archived(false)
			, id(NULLINT)
			, numwords(NULLINT)
			, weight(NULLDBL)
		{
			submitted.SetStatus(COleDateTime::invalid);
		}

		bool operator==(const CArticle& other)
		{
			return archived == other.archived
				&& author == other.author
				&& content == other.content
				&& id == other.id
				&& numwords == other.numwords
				&& price == other.price
				&& submitted == other.submitted
				&& title == other.title
				&& weight == other.weight;
		}

	public:
		bool archived;
		std::string author;
		std::string content;
		int id;
		int numwords;
		COleCurrency price;
		COleDateTime submitted;
		std::string title;
		double weight;

	};

	class CArticlesRS
		: public CPqxxTransfer<CArticlesRS>
		, public CArticle
	{
		typedef CPqxxTransfer<CArticlesRS> baseClass;

	public:
		CArticlesRS() : baseClass("articles") { initColDescs(); }
		CArticlesRS(const pqxx::result::const_iterator& src) : baseClass("articles") { initColDescs(); xferValues(src); }

		static const std::string defaultQuery()
		{
			return "SELECT "
				"archived"
				", author"
				", content"
				", id"
				", numwords"
				", price"
				", submitted"
				", title"
				", weight"
				" FROM public.articles";
		}

		CArticlesRS& operator=(const CArticle& other)
		{
			initColDescs();

			archived = other.archived;
			author = other.author;
			content = other.content;
			numwords = other.numwords;
			price = other.price;
			submitted = other.submitted;
			title = other.title;
			weight = other.weight;

			return *this;
		}

		BEGIN_DB_MAP(CArticlesRS, 9)
			DB_BOOL_ENTRY(0, archived)
			DB_STRING_ENTRY(1, author)
			DB_STRING_ENTRY(2, content)
			DB_INT_INDEX(3, id)
			DB_INT_ENTRY(4, numwords)
			DB_CURR_ENTRY(5, price)
			DB_DATE_ENTRY(6, submitted)
			DB_STRING_ENTRY(7, title)
			DB_DOUBLE_ENTRY(8, weight)
		END_DB_MAP()
	};
}