public static function has($username)
{
return Pdb::exists(self::$table, array('name=?' => $username));
}
function clear_relation_db($main_table, $ref_table, $relation_table = null, $key_main = null, $key_ref = null)
{
if ($relation_table === null) {
$relation_table = $main_table . '_' . $ref_table;
}
if ($key_main === null) {
$key_main = $main_table;
}
if ($key_ref === null) {
$key_ref = $ref_table;
}
$all = Pdb::fetchAll('*', $relation_table);
if ($all === false) {
Pdb::del($ref_table);
return;
}
// del in relation table
foreach ($all as $info) {
if (!Pdb::exists($main_table, array('id=?' => $info[$key_main]))) {
Pdb::del($relation_table, array($key_main . '=?' => $info[$key_main]));
}
}
// del in ref table
$all = Pdb::fetchAll('*', $ref_table);
if (empty($all)) {
return;
}
foreach ($all as $info) {
$id = $info['id'];
if (!Pdb::exists($relation_table, array($key_ref . '=?' => $id))) {
Pdb::del($ref_table, array('id=?' => $id));
}
}
}
public static function check($username, $password)
{
return Pdb::exists(self::$table, array('name=?' => $username, 'password=?' => md5($password)));
}
public function exists()
{
$self = get_called_class();
return Pdb::exists($self::$table, $this->selfCond());
}
// clear address
clear_relation_db(Customer::$table, Address::$table);
// clear user log
clear_db(UserLog::$table, Customer::$table, 'subject');
// clear account
clear_11_db(Customer::$table, Account::$table);
// clear account log
clear_1m_db(Account::$table, AccountHistory::$table);
// clear price_data
$pds = Pdb::fetchAll('id', PriceData::$table);
if ($pds) {
$tbl = Order::$table;
foreach ($pds as $id) {
$cond1 = array('factory_price = ?' => $id);
$cond2 = array('customer_price = ?' => $id);
if (!Pdb::exists($tbl, $cond1) && !Pdb::exists($tbl, $cond2)) {
Pdb::del(PriceData::$table, array('id = ?' => $id));
}
}
}
// clear stone
clear_11_db(Order::$table, Stone::$table);
if (_get('exit')) {
echo '<script src="static/hide.js"></script>';
echo '<div class="conclusion pass">All Clear!</div>';
exit;
}
$all_pass = true;
// case 1 autoload
begin_test();
$id = 101;
