[Cs-rssdb-commits] SF.net SVN: cs-rssdb:[72] trunk/0.2

[<cra...@us...>]

Revision: 72
          http://cs-rssdb.svn.sourceforge.net/cs-rssdb/?rev=72&view=rev
Author:   crazedsanity
Date:     2011-02-07 15:11:40 +0000 (Mon, 07 Feb 2011)

Log Message:
-----------
Upgrade from 0.1.3 to 0.2.0-BETA1.

/rssDBClass.php:
	* extends cs_webapplibsAbstract for upgrade capabilities
	* __construct():
		-- code to run an upgrade.
	* parse_file():
		-- check if the article exists before trying to blindly insert it
	* get_source_from_filename():
		-- breaks the filename into bits, querying until there are no more 
		bits or there is a single record found.
	* insert_article():
		-- removed some commented-out code.
/bin/downloader.php:
	* connect the database & pass it to rssDB{}.
/schema/rss_schema.pgsql.sql:
	* rss_article_table:
		-- created changed to timestamptz to match article_date.
	* drop no longer support the meta tables (unused).
/upgrades/upgrade.xml:
	* section for upgrading to 0.2.0-BETA1
/upgrades/upgradeTo_0.2.php:
	* run_upgrade():
		-- code that runs the SQL file for schema changes.
/upgrades/sql/upgradeTo0.2.pgsql.sql:
	* drop unnecessary columns from the rss_source_table
	* add article_guid column to rss_article_table
	* drop the meta tables

Modified Paths:
--------------
    trunk/0.2/bin/downloader.php
    trunk/0.2/rssDBClass.php
    trunk/0.2/schema/rss_schema.pgsql.sql
    trunk/0.2/upgrades/sql/upgradeTo0.2.pgsql.sql
    trunk/0.2/upgrades/upgrade.xml
    trunk/0.2/upgrades/upgradeTo_0.2.php


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.