gistfile1.sc

		target = """insert into mt_entry (mt_author_id, mt_authored_on, entry_basename, entry_blog_id, mt_class,
			entry_convert_breaks, entry_created_by, entry_created_on, entry_excerpt, entry_status,
			entry_text, entry_text_more, entry_title, entry_week_number, mubble_id)
			values(1, 1, '%(publish_date)', '%(filename)', 1, 'entry',
			0, 0, '%(publish_date)', '%(excerpt)', %(status),
			'%(text)', '%(text_more)', '%(title)', '%(weeknumber)', '%(mubble_id)')
			on duplicate key update 
			mt_author_id=values(mt_author_id),
			mt_authored_on = values(mt_authored_on), 
			entry_basename = values(entry_basename), 
			entry_blog_id = values(entry_blog_id), 
			mt_class = values(my_class),
			entry_convert_breaks = values(entry_convert_breaks), 
			entry_created_by = values(entry_created_by), 
			entry_created_on = values(entry_created_on), 
			entry_excerpt = values(entry_excerpt), 
			entry_status = values(entry_status),
			entry_text = values(entry_text), 
			entry_text_more = values(entry_text_more), 
			entry_title = values(entry_title), 
			entry_week_number = values(entry_week_number)"""
		status = 2
		body_parts = rdr["Body"].ToString().split("<More />")
		text = body_parts[0]
		text_more = ''
		if len(body_parts) > 1:
			text_more = body_parts[1]

		publish_date = rdr["PublishDate"].AddHours(-6)
		print target
		target = target % {
					'publish_date' : escape(publish_date),
					'filename' : escape(rdr["Slug"]),
					'excerpt' : escape(rdr['Excerpt']),
					'status' : status,
					'text' : escape(text),
					'text_more' : escape(text_more),
					'title' : escape(rdr["Title"]),
					'weeknumber' : publish_date.ToString("yyyy"),
					'mubble_id' : escape(rdr["ID"])
		}

		print target