\n \n \n \n \n\n
\n \n \n \n
require<\/span> "rubygems"<\/span> <\/div>require<\/span> "java"<\/span> <\/div>require<\/span> "jdbc/mysql"<\/span> <\/div>require<\/span> 'RedCloth'<\/span> <\/div>require<\/span> 'net/http'<\/span> <\/div>require<\/span> 'uri'<\/span> <\/div> <\/div>PosterousUsername<\/span> =<\/span> ''<\/span> <\/div>PosterousPassword<\/span> =<\/span> ''<\/span> <\/div> <\/div>@posts<\/span> =<\/span> {}<\/span> <\/div> <\/div>def<\/span> post_entries<\/span> <\/div>  begin<\/span> <\/div>    # Prep the connection <\/span><\/div>    Java<\/span>::<\/span>com<\/span>.<\/span>mysql<\/span>.<\/span>jdbc<\/span>.<\/span>Driver<\/span> <\/div>    userurl<\/span> =<\/span> "jdbc:mysql://localhost/jasonwong"<\/span> <\/div>    connSelect<\/span> =<\/span> java<\/span>.<\/span>sql<\/span>.<\/span>DriverManager<\/span>.<\/span>get_connection<\/span>(<\/span>userurl<\/span>,<\/span> "root"<\/span>,<\/span> ""<\/span>)<\/span> <\/div>    stmtSelect<\/span> =<\/span> connSelect<\/span>.<\/span>create_statement<\/span> <\/div> <\/div>    # Define the query <\/span><\/div>    selectquery<\/span> =<\/span> "SELECT * FROM content_versions;"<\/span> <\/div> <\/div>    # Execute the query <\/span><\/div>    q<\/span> =<\/span> stmtSelect<\/span>.<\/span>execute_query<\/span>(<\/span>selectquery<\/span>)<\/span> <\/div> <\/div>    # For each row returned do some stuff <\/span><\/div>    while<\/span> (<\/span>q<\/span>.<\/span>next<\/span>)<\/span> do<\/span> <\/div>      id<\/span> =<\/span> q<\/span>.<\/span>getObject<\/span>(<\/span>"article_id"<\/span>)<\/span> <\/div>      title<\/span> =<\/span> q<\/span>.<\/span>getObject<\/span>(<\/span>"title"<\/span>)<\/span> <\/div>      body<\/span> =<\/span> q<\/span>.<\/span>getObject<\/span>(<\/span>"body"<\/span>)<\/span> <\/div>      version<\/span> =<\/span> q<\/span>.<\/span>getObject<\/span>(<\/span>"version"<\/span>)<\/span> <\/div>      date<\/span> =<\/span> q<\/span>.<\/span>getObject<\/span>(<\/span>"created_at"<\/span>)<\/span> <\/div> <\/div>      if<\/span> !<\/span>@posts<\/span>[<\/span>id<\/span>]<\/span> ||<\/span> @posts<\/span>[<\/span>id<\/span>][<\/span>:version<\/span>]<\/span> ><\/span> version<\/span>.<\/span>to_i<\/span> <\/div>        @posts<\/span>[<\/span>id<\/span>]<\/span> =<\/span> {}<\/span> unless<\/span> @posts<\/span>[<\/span>id<\/span>]<\/span> <\/div> <\/div>        @posts<\/span>[<\/span>id<\/span>][<\/span>:title<\/span>]<\/span> =<\/span> title<\/span> <\/div>        @posts<\/span>[<\/span>id<\/span>][<\/span>:body<\/span>]<\/span> =<\/span> body<\/span> <\/div>        @posts<\/span>[<\/span>id<\/span>][<\/span>:version<\/span>]<\/span> =<\/span> version<\/span>.<\/span>to_i<\/span> <\/div>        @posts<\/span>[<\/span>id<\/span>][<\/span>:date<\/span>]<\/span> =<\/span> date<\/span> <\/div>        @posts<\/span>[<\/span>id<\/span>][<\/span>:tags<\/span>]<\/span> =<\/span> []<\/span> <\/div> <\/div>        q2q<\/span> =<\/span> "select name from tags inner join taggings where tags.id = taggings.tag_id and taggings.taggable_id = <\/span>#{<\/span>id<\/span>}<\/span>;"<\/span> <\/div> <\/div>        stmtSelect2<\/span> =<\/span> connSelect<\/span>.<\/span>create_statement<\/span> <\/div>        q2<\/span> =<\/span> stmtSelect2<\/span>.<\/span>execute_query<\/span>(<\/span>q2q<\/span>)<\/span> <\/div>        while<\/span>(<\/span>q2<\/span>.<\/span>next<\/span>)<\/span> do<\/span> <\/div>          @posts<\/span>[<\/span>id<\/span>][<\/span>:tags<\/span>]<\/span> <<<\/span> q2<\/span>.<\/span>getObject<\/span>(<\/span>"name"<\/span>)<\/span> <\/div>        end<\/span> <\/div>        stmtSelect2<\/span>.<\/span>close<\/span> <\/div>      end<\/span> <\/div> <\/div>    end<\/span> <\/div> <\/div>    @posts<\/span>.<\/span>keys<\/span>.<\/span>each<\/span> do<\/span> |<\/span>key<\/span>|<\/span> <\/div>      puts<\/span> @posts<\/span>[<\/span>key<\/span>][<\/span>:title<\/span>]<\/span> <\/div>      post_to_site<\/span> key<\/span> <\/div>      sleep<\/span> 1<\/span> <\/div>    end<\/span> <\/div>  end<\/span> <\/div> <\/div>  # Close off the connection <\/span><\/div>  stmtSelect<\/span>.<\/span>close<\/span> <\/div>  connSelect<\/span>.<\/span>close<\/span> <\/div>end<\/span> <\/div> <\/div>def<\/span> post_to_site<\/span> key<\/span> <\/div>  site_id<\/span> =<\/span> '237669'<\/span> <\/div> <\/div>  #3: Detailed control <\/span><\/div>  url<\/span> =<\/span> URI<\/span>.<\/span>parse<\/span>(<\/span>'http://posterous.com/api/newpost'<\/span>)<\/span> <\/div>  req<\/span> =<\/span> Net<\/span>::<\/span>HTTP<\/span>::<\/span>Post<\/span>.<\/span>new<\/span>(<\/span>url<\/span>.<\/span>path<\/span>)<\/span> <\/div>  req<\/span>.<\/span>basic_auth<\/span> PosterousUsername<\/span>,<\/span> PosterousPassword<\/span> <\/div>  req<\/span>.<\/span>set_form_data<\/span>({<\/span>'title'<\/span> =><\/span> @posts<\/span>[<\/span>key<\/span>][<\/span>:title<\/span>]<\/span>,<\/span> <\/div>                     'body'<\/span> =><\/span> @posts<\/span>[<\/span>key<\/span>][<\/span>:body<\/span>]<\/span>,<\/span> <\/div>                     'site_id'<\/span> =><\/span> site_id<\/span>,<\/span> <\/div>                     'date'<\/span> =><\/span> @posts<\/span>[<\/span>key<\/span>][<\/span>:date<\/span>]<\/span>,<\/span> <\/div>                     'tags'<\/span> =><\/span> @posts<\/span>[<\/span>key<\/span>][<\/span>:tags<\/span>].<\/span>join<\/span>(<\/span>','<\/span>)})<\/span> <\/div>  res<\/span> =<\/span> Net<\/span>::<\/span>HTTP<\/span>.<\/span>new<\/span>(<\/span>url<\/span>.<\/span>host<\/span>,<\/span> url<\/span>.<\/span>port<\/span>)<\/span>.<\/span>start<\/span> {<\/span>|<\/span>http<\/span>|<\/span> http<\/span>.<\/span>request<\/span>(<\/span>req<\/span>)<\/span> }<\/span> <\/div>  case<\/span> res<\/span> <\/div>  when<\/span> Net<\/span>::<\/span>HTTPSuccess<\/span>,<\/span> Net<\/span>::<\/span>HTTPRedirection<\/span> <\/div>    # OK <\/span><\/div>  else<\/span> <\/div>    puts<\/span> res<\/span>.<\/span>error!<\/span> <\/div>  end<\/span> <\/div>end<\/span> <\/div> <\/div>post_entries<\/span> <\/div><\/pre><\/div>\n          \n        <\/div>\n\n        \n          view raw<\/a>\n          mep2postereous.rb<\/a>\n          This Gist<\/a> brought to you by GitHub<\/a>.\n        <\/div>\n      <\/div>\n    \n  \n<\/div>\n')