[Cs-rssdb-commits] SF.net SVN: cs-rssdb:[57] trunk/0.1

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

Revision: 57
          http://cs-rssdb.svn.sourceforge.net/cs-rssdb/?rev=57&view=rev
Author:   crazedsanity
Date:     2009-09-11 17:50:53 +0000 (Fri, 11 Sep 2009)

Log Message:
-----------
Drop columns, store last_downloaded, get list of downloadable files, ++...

/rssDBClass.php:
	* run_sql() [DELETED]:
		-- use cs_phpDB::run_query(), cs_phpDB::run_insert(), and
		cs_phpDB::run_update() to run these SQL commands instead.
	* get_source_from_filename():
		-- use source_name to create filename automatically
		-- drop extension from filename to match to source.
		-- use cs_phpDB methods instead of run_sql()
	* insert_article():
		-- call cs_phpDB::run_insert() instead of run_sql()
	* article_exists():
		-- call cs_phpDB::run_query() to pull data instead of run_sql().
	* get_source():
		-- use cs_phpDB::run_query() instead of run_sql()
	* get_recent_articles():
		-- use cs_phpDB::run_query() instead of run_sql()
	* get_download_list() [NEW]:
		-- retrieve list of downloadable files
		-- NOTE::: this is to be used wiht pending downloader.php...
/bin/parse_rss_feeds():
	* remove unnecessary includes
	* pass RSS_FILES_DIR constant to rssDB::__construct().
/schema/rss_schema.pgsql.sql:
	* rss_source_table:
		-- drop filename (now derived)
		-- add column for "last_downloaded" for scriptiness.
	* SOURCE LIST:::
		-- update to not have filename.
/tests/testOfCSRSSDB.php:
	* setUp():
		-- attempt to drop tables
		-- load schema in a transaction
	* tearDown():
		-- rollback the transaction
	* test_basics():
		-- test pulling articles & retrieving list of downloadable feeds.

Modified Paths:
--------------
    trunk/0.1/bin/parse_rss_feeds.php
    trunk/0.1/rssDBClass.php
    trunk/0.1/schema/rss_schema.pgsql.sql
    trunk/0.1/tests/testOfCSRSSDB.php


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