#Performing Overlapping Data Migration in MySQL
This example will assume a really simple schema -- users and messages.
CREATE DATABASE data_1;
CREATE DATABASE data_2;
USE data_1;
DROP TABLE IF EXISTS users;
#Performing Overlapping Data Migration in MySQL
This example will assume a really simple schema -- users and messages.
CREATE DATABASE data_1;
CREATE DATABASE data_2;
USE data_1;
DROP TABLE IF EXISTS users;
| package controllers | |
| import play.api._ | |
| import play.api.mvc._ | |
| object Application extends Controller { | |
| def doStuff:Result = { | |
| if (1 != 1) return InternalServerError("Whoa shit") |
| import java.util.Date | |
| import play.api.libs.json._ | |
| case class Event(name:String,when:Date) extends JsSerializable | |
| object Event extends ((String,Date) => Event) { | |
| implicit val r = Json.reads[Event]() | |
| implicit val w = Json.writes[Event]() | |
| } |
| DATA_TO_SIGN = SOME_DATA + PRIVATE_API_KEY | |
| md5 -s "DATA_TO_SIGN" | |
| curl "https://www.somewebservice.com/api/v1/getAwesomeStuff" --data "API_KEY=YOUR_PUBLIC_API_KEY&signature=CALCULATED_SIGNATURE" |
| SELECT COUNT(a.asdf) as count_of_asdfs FROM (SELECT 2 as asdf ) as a JOIN (SELECT 3 as fdsa) as b ON b.fdsa=3 GROUP BY b.fdsa; |
| ### Keybase proof | |
| I hereby claim: | |
| * I am kaeawc on github. | |
| * I am kaeawc (https://keybase.io/kaeawc) on keybase. | |
| * I have a public key whose fingerprint is 6E7A 3856 CF66 FF0B 848B 723A 3150 F227 277B B2D8 | |
| To claim this, I am signing this object: |
| base64 -D thefile | tar -xz |
| apikey = 'you_api_key' | |
| list_id = 'your_list_id' | |
| from mailchimp import Mailchimp | |
| mailchimp = Mailchimp(apikey=apikey) | |
| mailchimp.lists.subscribe(id=list_id, email={u"email",u"[email protected]"}) |
| mandrill.messages.send_template(template_name='welcome-new-user', template_content=[], message={'to':[{'email': '[email protected]'}]}, send_at=future_time) | |
| # [{u'_id': u'ae905120f7194c1fb6d9e529db3fc353', | |
| # u'email': u'[email protected]', | |
| # u'reject_reason': None, | |
| # u'status': u'scheduled'}] | |
| mandrill.messages.list_scheduled(to='[email protected]') | |
| # [{u'_id': u'ae905120f7194c1fb6d9e529db3fc353', |