public function setUp()
{
$conn = self::$connection;
TRW\ActiveRecord\IdentityMap::clearAll();
$conn->query("DELETE FROM players");
$conn->query("INSERT INTO players(id, type ,name, club, batting_average, bowling_average) \n\t\t\tVALUES\n\t\t\t(1, 'Player', 'foo', null, null, null),\n\t\t\t(2, 'Cricketer', 'hoge', null, 100, null),\n\t\t\t(3, 'Bowller', 'bar', null, 20, 10),\n\n\t\t\t(4, 'FootBaller','fuga', 'A club', null, null)");
}
public function setUp()
{
$conn = self::$connection;
TRW\ActiveRecord\IdentityMap::clearAll();
$conn->query("DELETE FROM inheritances");
$conn->query("INSERT INTO inheritances\n\t\t\t(id, type, parent, child) \n\t\t\tVALUES\n\t\t\t(1, 'Inheritance', 'parent', null),\n\t\t\t(2, 'Child', null, 'child')");
$conn->query("DELETE FROM inheritancedependents");
$conn->query("INSERT INTO inheritancedependents (id, name, child_id)\n\t\t\tVALUES(1, 'one', 1),(2, 'two', 2)");
}
public function setUp()
{
$conn = self::$connection;
TRW\ActiveRecord\IdentityMap::clearAll();
$conn->query("DELETE FROM users");
$conn->query("INSERT INTO users(id,name) VALUES(1,'bar'), (2, 'foo'), (3, 'hoge'), (4, 'fuga')");
$conn->query("DELETE FROM comments");
$conn->query("INSERT INTO comments(id, text, user_id)\n\t\t\tVALUES(1, 'bar comment first', 1), (2, 'bar comment second', 1), (3, 'foo comment first', 2)");
$conn->query("DELETE FROM users_skills");
$conn->query("INSERT INTO users_skills(id, users_id, skills_id) \n\t\t\tVALUES(1, 1, 1), (2, 1, 2), (3, 2, 1)");
$conn->query("DELETE FROM skills");
$conn->query("INSERT INTO skills(id, name)\n\t\t\t VALUES(1,'skill1'), (2, 'skill2'), (3, 'skill3')");
$conn->query("DELETE FROM profiles");
$conn->query("INSERT INTO profiles(id, text, user_id) \n\t\t\tVALUES(1, 'bar profile', 1), (2, 'foo frofile', 2), (3, 'hoge frofile', 3)");
}
