PHP App\Lib Database::exec 예제들

예제 #1

파일: install_db.php 프로젝트: jonataa/vaga_dev_fullstack

<?php

require_once __DIR__ . '/../vendor/autoload.php';
use App\Lib\Database;
Database::getInstance('sqlite:db/database.sq3');
Database::exec("DROP TABLE IF EXISTS tasks");
Database::exec("CREATE TABLE tasks (id INTEGER PRIMARY KEY AUTOINCREMENT, title TEXT NOT NULL, done INTEGER NOT NULL DEFAULT 0)");
Database::exec("\n  INSERT INTO tasks (title, done)\n  VALUES\n    ('Fazer desafio da iTFLEX', 0),\n    ('Tomar um café', 1)\n");

예제 #2

파일: AbstractTestCase.php 프로젝트: jonataa/vaga_dev_fullstack

 public function databaseDestroy()
 {
     Database::exec('DROP TABLE tasks');
 }