public function setUp()
{
$url = $this->getAppUrl();
$serverUrl = RingsideWebTestConfig::$server;
$this->cleanDb();
mysql_upload_string("\n\t\t\tinsert into users (id, username, password) values (200001, '*****@*****.**', '" . sha1('ringside') . "');\n\t\t\tinsert into users (id, username, password) values (200002, '*****@*****.**', '" . sha1('ringside') . "');\n\t\t\tinsert into principal (principal_id, user_name) values (50001, '*****@*****.**');\n\t\t\tinsert into principal_map (principal_id, uid, trust_key, network_key, user_name)\n\t\t\tvalues (50001, 300001, 'facebook', '1234', '*****@*****.**');\n\t\t\tinsert into principal_map (principal_id, uid, trust_key, network_key, user_name)\n\t\t\tvalues (50001, 200001, 'ringside-web', '" . RingsideSocialConfig::$apiKey . "', '*****@*****.**');\n\t\t\tinsert into principal (principal_id, user_name) values (50002, '*****@*****.**');\n\t\t\tinsert into principal_map (principal_id, uid, trust_key, network_key, user_name)\n\t\t\tvalues (50002, 300002, 'facebook', '1234', '*****@*****.**');\n\t\t\tinsert into principal_map (principal_id, uid, trust_key, network_key, user_name)\n\t\t\tvalues (50002, 200002, 'ringside-web', '" . RingsideSocialConfig::$apiKey . "', '*****@*****.**');\n\t\t\t-- Deploy the application to all test users\n\t\t\tINSERT INTO app (id, callback_url, api_key, secret_key, name, canvas_url, sidenav_url, isdefault, support_email, canvas_type, application_type, mobile, deployed, description, default_fbml, tos_url, icon_url, postadd_url, postremove_url, privacy_url, ip_list, about_url) VALUES (90000, '{$serverUrl}/idmapapp/', 'idmapapp', 'idmapappsecret', 'Identity Mapping Application', 'idmap', 'idmap', 0, null, 1, 'WEB', 0, 1, null, null, null, null, null, null, null, null, null);\n\t\t\tINSERT INTO users_app (app_id, user_id, allows_status_update, allows_create_listing, allows_photo_upload, fbml, auth_information, auth_profile, auth_leftnav, auth_newsfeeds, enabled, modified, created) SELECT 90000, id, 1, 1, 1, null, 1, 1, 1, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP from users WHERE users.id > 200001 && users.id < 201000;\n\t\t\t");
}
private function cleanDb()
{
$sqlDelete = "\r\n\t\tDELETE FROM rs_social_session_history;\r\n\t\t";
mysql_upload_string($sqlDelete);
}
public function setUp()
{
$this->cleanDb();
$sql = "\n\t\t\t\t\tINSERT INTO rs_trust_authorities (trust_key, trust_name, trust_auth_url, trust_login_url)\n\t\t\t\t\tVALUES ('testRingside', 'Ringside Test', 'http://localhost/api/restserver.php', 'http://localhost/web/login.php');\n\t\t\t\t\tINSERT INTO rs_trust_authorities (trust_key, trust_name, trust_auth_url, trust_login_url)\n\t\t\t\t\tVALUES ('testFacebook', 'Facebook Test', 'http://api.facebook.com/restserver.php', 'http://www.facebook.com/login.php');\n\t\t\t\t\t";
mysql_upload_string($sql);
}
public function setUp()
{
$this->resetDb();
// These are the principals we will map
mysql_upload_string("\n\t\t\t\t\t\t\tinsert into app (id, name, canvas_url, sidenav_url) values (1234, 'Test app', 'test_app', 'http://example.com/test_app');\n\t\t\t\t\t\t\tINSERT INTO rs_trust_authorities (trust_key, trust_name, trust_auth_url, trust_login_url)\n\t\t\t\t\tVALUES ('testRingside', 'Ringside Test', 'http://localhost/api/restserver.php', 'http://localhost/web/login.php');\n\t\t\t\t\tINSERT INTO rs_trust_authorities (trust_key, trust_name, trust_auth_url, trust_login_url)\n\t\t\t\t\tVALUES ('testFacebook', 'Facebook Test', 'http://api.facebook.com/restserver.php', 'http://www.facebook.com/login.php');\n\t\t\t\t\t\t\t\t\tinsert into principal (id) values (50002);\n\t\t\t\t\t\t\t\t\tinsert into principal_map (principal_id, app_id, uid, network_id)\n\t\t\t\t\t\t\t\t\tvalues (50002, 1234, 100002, 'testFacebook');\n\t\t\t\t\t\t\t\t\tinsert into principal_map (principal_id, app_id, uid, network_id)\n\t\t\t\t\t\t\t\t\tvalues (50002, 1234, 200002, 'testRingside');");
}
public function setUp()
{
$this->resetDb();
mysql_upload_string("insert into app (id, name, canvas_url, sidenav_url) values (1234, 'Test app', 'test_app', 'http://example.com/test_app');\n\t\t\t\t\t\t\t\t\tinsert into principal (id) values (50001);\n\t\t\t\t\t\t\t\t\tinsert into principal_map (principal_id, app_id, uid, network_id)\n\t\t\t\t\t\t\t\t\tvalues (50001, 1234, 100001, '1234');\n\t\t\t\t\t\t\t\t\tinsert into principal (id) values (50002);\n\t\t\t\t\t\t\t\t\tinsert into principal_map (principal_id, app_id, uid, network_id)\n\t\t\t\t\t\t\t\t\tvalues (50002, 1234, 100002, '1234');");
}
