PHP RedBean_OODB::showTables Examples

Example #1

File: test.php Project: seanhess/redbean

$db->exec("INSERT INTO  `redbeantables` (\n`id` ,\n`tablename`\n)\nVALUES (\nNULL ,  'indexer'\n);\n");
for ($i = 0; $i < 20; $i++) {
    $db->exec("INSERT INTO  `indexer` (\n`id` ,\n`highcard` ,\n`lowcard` ,\n`lowcard2`,\n`highcard2`\n)\nVALUES (\nNULL ,  rand(),  'a',  rand(), CONCAT( rand()*100, '" . str_repeat('x', 1000) . "' )\n);\n");
}
for ($i = 0; $i < 500; $i++) {
    RedBean_OODB::keepInShape();
}
$row = $db->getRow("select * from slimtable limit 1");
SmartTest::test($row["col1"], 1);
SmartTest::test($row["col2"], "mustbevarchar");
SmartTest::test($row["col3"], 1000);
SmartTest::test(count($db->get("describe slimtable")), 4);
RedBean_OODB::dropColumn("slimtable", "col3");
SmartTest::test(count($db->get("describe slimtable")), 3);
RedBean_OODB::KeepInShape(true);
$tables = RedBean_OODB::showTables();
SmartTest::test(in_array("slimtable", $tables), false);
//Tests for each individual engine
function testsperengine()
{
    global $tests;
    SmartTest::instance()->progress();
    SmartTest::instance()->testPack = "perform generic bean manipulation";
    $ok = 1;
    $bean = RedBean_OODB::dispense("note");
    $bean->message = "hai";
    $bean->color = 3;
    $bean->date = time();
    $bean->special = 'n';
    $bean->state = 90;
    RedBean_OODB::set($bean);