MM-Tweeter - Revision history

Jferguson at 22:28, 9 June 2012

2012-06-09T22:28:21Z

@@ Line 1: / Line 1: @@
 ==Project Status==
 * Functional
@@ Line 4: / Line 9: @@
 ==Software License==
 * TBD - Source Currently Unavailable
 ==Usage==

Jferguson at 22:26, 9 June 2012

2012-06-09T22:26:42Z

← Older revision		Revision as of 22:26, 9 June 2012
Line 1:		Line 1:
			==Project Status==
			* Functional

			==Software License==
			* TBD - Source Currently Unavailable

	==Conditional Auto Tweeter written in PHP==		==Conditional Auto Tweeter written in PHP==
	* Using OAuth Library by Matt Harris: https://github.com/themattharris/tmhOAuth		* Using OAuth Library by Matt Harris: https://github.com/themattharris/tmhOAuth

Jferguson at 22:23, 9 June 2012

2012-06-09T22:23:11Z

← Older revision		Revision as of 22:23, 9 June 2012
Line 22:		Line 22:
	* Checks pending table and checks if their post date < current time		* Checks pending table and checks if their post date < current time
	* Cron running every 30 minutes to post any pending		* Cron running every 30 minutes to post any pending
			* If there is an error with a tweet it will try to tweet it $attempts times (Default 3)
			** If it is unable to be tweeted (Error Code != 200) after $attempts times it is deleted from pending and added to history with the last error code

	==To Be Done==		==To Be Done==
			* Perhaps ability for source to query their tweets based on history/pending?
			* <del>Need to ensure response code making it back to user</del> Solved By: Impossible since we're always tweeting into the future. Refer to ability of source to query their history
	* <del>Need to handle adding to pending table</del>		* <del>Need to handle adding to pending table</del>
	* <del>Need to handle adding to history</del>		* <del>Need to handle adding to history</del>
	* <del>Need to handle Remove from pending</del>		* <del>Need to handle Remove from pending</del>
	* <del>Cron local system to test for pending tweets</del>		* <del>Cron local system to test for pending tweets</del>
	* Testing
	* <del>Need to provide fallback if no $post_date supplied.</del>		* <del>Need to provide fallback if no $post_date supplied.</del>
	* Need to ensure response code making it back to user
	* <del>Need to add warning if $content > 160 characters OR Blank.</del> Solved by: they're using a twitter api, they should self limit <= 160 characters		* <del>Need to add warning if $content > 160 characters OR Blank.</del> Solved by: they're using a twitter api, they should self limit <= 160 characters
	** Perhaps ability for source to query their tweets based on history/pending?\
	* <del>Need ensure $content is not NULL in addpending()</del> Solved by: checking if $content = '' before addpending()		* <del>Need ensure $content is not NULL in addpending()</del> Solved by: checking if $content = '' before addpending()
	* <del>Log post attempts? Check error codes so we're not hammering away at twitter</del> Solved by: $attempts checking: default 3		* <del>Log post attempts? Check error codes so we're not hammering away at twitter</del> Solved by: $attempts checking: default 3

Jferguson: /* To Be Done */

2012-05-28T19:10:23Z

To Be Done

← Older revision		Revision as of 19:10, 28 May 2012
Line 31:		Line 31:
	* <del>Need to provide fallback if no $post_date supplied.</del>		* <del>Need to provide fallback if no $post_date supplied.</del>
	* Need to ensure response code making it back to user		* Need to ensure response code making it back to user
	* Need to add warning if $content > 160 characters OR Blank.		* <del>Need to add warning if $content > 160 characters OR Blank.</del> Solved by: they're using a twitter api, they should self limit <= 160 characters
	** Perhaps ability for source to query their tweets based on history/pending?\		** Perhaps ability for source to query their tweets based on history/pending?\
	* <del>Need ensure $content is not NULL in addpending()</del> Solved by checking if $content = '' before addpending()		* <del>Need ensure $content is not NULL in addpending()</del> Solved by: checking if $content = '' before addpending()
	* Log post attempts? Check error codes so we're not hammering away at twitter		* <del>Log post attempts? Check error codes so we're not hammering away at twitter</del> Solved by: $attempts checking: default 3

	==Goals==		==Goals==

Jferguson: /* Database Schema */

2012-05-28T18:28:14Z

Database Schema

← Older revision		Revision as of 18:28, 28 May 2012
Line 50:		Line 50:
	`added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,		`added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
	`source` varchar(255) NOT NULL,		`source` varchar(255) NOT NULL,
			`attempts` int(1) NOT NULL,
			`last_error_code` int(3) NOT NULL,
	PRIMARY KEY (`id`)		PRIMARY KEY (`id`)
	) ENGINE=MyISAM DEFAULT CHARSET=latin1;		) ENGINE=MyISAM DEFAULT CHARSET=latin1 ;
	</pre>		</pre>
	* History Table		* History Table

Jferguson at 18:18, 28 May 2012

2012-05-28T18:18:38Z

← Older revision		Revision as of 18:18, 28 May 2012
Line 29:		Line 29:
	* <del>Cron local system to test for pending tweets</del>		* <del>Cron local system to test for pending tweets</del>
	* Testing		* Testing
	* Need to provide fallback if no $post_date supplied.		* <del>Need to provide fallback if no $post_date supplied.</del>
	* Need to ensure response code making it back to user		* Need to ensure response code making it back to user
	* Need to add warning if $content > 160 characters.		* Need to add warning if $content > 160 characters OR Blank.
	** Perhaps ability for source to query their tweets based on history/pending?\		** Perhaps ability for source to query their tweets based on history/pending?\
	* Need ensure $content is not NULL in addpending()		* <del>Need ensure $content is not NULL in addpending()</del> Solved by checking if $content = '' before addpending()
	* Log post attempts? Check error codes so we're not hammering away at twitter		* Log post attempts? Check error codes so we're not hammering away at twitter

Jferguson at 21:26, 8 May 2012

2012-05-08T21:26:03Z

← Older revision		Revision as of 21:26, 8 May 2012
Line 10:		Line 10:
	** post_date (When the tweet should be posted + 5 minutes)		** post_date (When the tweet should be posted + 5 minutes)
	** content (this is what you want tweeted)		** content (this is what you want tweeted)
	* Example: <pre>http://midsouthmakers.org/mm-tweeter/?source=samplesource&secret=samplesecret&post_date=2012-05-07%2011:46:10&content=Sample Tweet</pre>		* Example: <pre>http://api.midsouthmakers.org/mm-tweeter/?source=samplesource&secret=samplesecret&post_date=2012-05-07%2011:46:10&content=Sample Tweet</pre>
	** $_POST or $_GET methods should work in the same manner.		** $_POST or $_GET methods should work in the same manner.
	* Execute the request		* Execute the request

Jferguson at 17:39, 7 May 2012

2012-05-07T17:39:45Z

← Older revision		Revision as of 17:39, 7 May 2012
Line 32:		Line 32:
	* Need to ensure response code making it back to user		* Need to ensure response code making it back to user
	* Need to add warning if $content > 160 characters.		* Need to add warning if $content > 160 characters.
	** Perhaps ability for source to query their tweets based on history/pending?		** Perhaps ability for source to query their tweets based on history/pending?\
			* Need ensure $content is not NULL in addpending()
			* Log post attempts? Check error codes so we're not hammering away at twitter

	==Goals==		==Goals==

Jferguson at 17:35, 7 May 2012

2012-05-07T17:35:05Z

← Older revision		Revision as of 17:35, 7 May 2012
Line 21:		Line 21:
	* Able to be run from a url to post static tweets.		* Able to be run from a url to post static tweets.
	* Checks pending table and checks if their post date < current time		* Checks pending table and checks if their post date < current time
			* Cron running every 30 minutes to post any pending

	==To Be Done==		==To Be Done==
Line 26:		Line 27:
	* <del>Need to handle adding to history</del>		* <del>Need to handle adding to history</del>
	* <del>Need to handle Remove from pending</del>		* <del>Need to handle Remove from pending</del>
	* Cron local system to test for pending tweets		* <del>Cron local system to test for pending tweets</del>
	* Testing		* Testing
	* Need to provide fallback if no $post_date supplied.		* Need to provide fallback if no $post_date supplied.

Jferguson: /* To Be Done */

2012-05-07T17:12:27Z

To Be Done

← Older revision		Revision as of 17:12, 7 May 2012
Line 30:		Line 30:
	* Need to provide fallback if no $post_date supplied.		* Need to provide fallback if no $post_date supplied.
	* Need to ensure response code making it back to user		* Need to ensure response code making it back to user
			* Need to add warning if $content > 160 characters.
	** Perhaps ability for source to query their tweets based on history/pending?		** Perhaps ability for source to query their tweets based on history/pending?