~tsep-dev/tsep/0.9-beta

$this->db->query('CREATE TABLE ' . $name . ' (id int(11) AUTO_INCREMENT, bool tinyint(1), small_int tinyint(2), primary key(id), KEY `pointless_bool` ( `bool` ));');

192

$expected = array(

193

'PRIMARY' => array('column' => 'id', 'unique' => 1),

194

'pointless_bool' => array('column' => 'bool', 'unique' => 0),

195

);

196

$result = $this->db->index($name, false);

197

$this->assertEqual($expected, $result);

198

$this->db->query('DROP TABLE ' . $name);

199

200

$name = $this->db->fullTableName('with_two_keys');

201

$this->db->query('CREATE TABLE ' . $name . ' (id int(11) AUTO_INCREMENT, bool tinyint(1), small_int tinyint(2), primary key(id), KEY `pointless_bool` ( `bool` ), KEY `pointless_small_int` ( `small_int` ));');

202

$expected = array(

203

'PRIMARY' => array('column' => 'id', 'unique' => 1),

204

'pointless_bool' => array('column' => 'bool', 'unique' => 0),

205

'pointless_small_int' => array('column' => 'small_int', 'unique' => 0),

206

);

207

$result = $this->db->index($name, false);

208

$this->assertEqual($expected, $result);

209

$this->db->query('DROP TABLE ' . $name);

210

211

$name = $this->db->fullTableName('with_compound_keys');

212

213

$expected = array(

214

'PRIMARY' => array('column' => 'id', 'unique' => 1),

215

'pointless_bool' => array('column' => 'bool', 'unique' => 0),

216

'pointless_small_int' => array('column' => 'small_int', 'unique' => 0),

217

'one_way' => array('column' => array('bool', 'small_int'), 'unique' => 0),

218

);

219

$result = $this->db->index($name, false);

220

$this->assertEqual($expected, $result);

221

$this->db->query('DROP TABLE ' . $name);

222

223

$name = $this->db->fullTableName('with_multiple_compound_keys');

224

225

$expected = array(

226

'PRIMARY' => array('column' => 'id', 'unique' => 1),

227

'pointless_bool' => array('column' => 'bool', 'unique' => 0),

228

'pointless_small_int' => array('column' => 'small_int', 'unique' => 0),

229

'one_way' => array('column' => array('bool', 'small_int'), 'unique' => 0),

230

'other_way' => array('column' => array('small_int', 'bool'), 'unique' => 0),

231

);

232

$result = $this->db->index($name, false);

233

$this->assertEqual($expected, $result);

234

$this->db->query('DROP TABLE ' . $name);

235

}

236

237

/**

238

* testColumn method

239

240

* @return void

241

* @access public

242

243

function testColumn() {

244

$result = $this->db->column('varchar(50)');

245

$expected = 'string';

246

$this->assertEqual($result, $expected);

247

248

$result = $this->db->column('text');

249

$expected = 'text';

250

$this->assertEqual($result, $expected);

251

252

$result = $this->db->column('int(11)');

253

$expected = 'integer';

254

$this->assertEqual($result, $expected);

255

256

$result = $this->db->column('int(11) unsigned');

257

$expected = 'integer';

258

$this->assertEqual($result, $expected);

259

260

$result = $this->db->column('tinyint(1)');

261

$expected = 'boolean';

262

$this->assertEqual($result, $expected);

263

264

$result = $this->db->column('boolean');

265

$expected = 'boolean';

266

$this->assertEqual($result, $expected);

267

268

$result = $this->db->column('float');

269

$expected = 'float';

270

$this->assertEqual($result, $expected);

271

272

$result = $this->db->column('float unsigned');

273

$expected = 'float';

274

$this->assertEqual($result, $expected);

275

276

$result = $this->db->column('double unsigned');

277

$expected = 'float';

278

$this->assertEqual($result, $expected);

279

280

$result = $this->db->column('decimal(14,7) unsigned');

281

$expected = 'float';

282

$this->assertEqual($result, $expected);

283

}

284

285

/**

286

* test transaction commands.

287

288

* @return void

289

* @access public

290

291

function testTransactions() {

292

$this->db->testing = false;

293

$result = $this->db->begin($this->model);

294

$this->assertTrue($result);

295

296

$beginSqlCalls = Set::extract('/.[query=START TRANSACTION]', $this->db->_queriesLog);

297

$this->assertEqual(1, count($beginSqlCalls));

298

299

$result = $this->db->commit($this->model);

300

$this->assertTrue($result);

301

}

302

/**

303

* test that float values are correctly identified

304

305

* @return void

306

307

function testFloatParsing() {

308

$model =& new Model(array('ds' => 'test_suite', 'table' => 'datatypes', 'name' => 'Datatype'));

309

$result = $this->db->describe($model);

310

$this->assertEqual((string)$result['float_field']['length'], '5,2');

311

}

312

313

/**

314

* test that tableParameters like collation, charset and engine are functioning.

315

316

* @access public

317

* @return void

318

319

function testReadTableParameters() {

320

$this->db->cacheSources = $this->db->testing = false;

321

$this->db->query('CREATE TABLE ' . $this->db->fullTableName('tinyint') . ' (id int(11) AUTO_INCREMENT, bool tinyint(1), small_int tinyint(2), primary key(id)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;');

322

$result = $this->db->readTableParameters('tinyint');

323

$expected = array(

324

'charset' => 'utf8',

325

'collate' => 'utf8_unicode_ci',

326

'engine' => 'InnoDB');

327

$this->assertEqual($result, $expected);

328

329

$this->db->query('DROP TABLE ' . $this->db->fullTableName('tinyint'));

330

$this->db->query('CREATE TABLE ' . $this->db->fullTableName('tinyint') . ' (id int(11) AUTO_INCREMENT, bool tinyint(1), small_int tinyint(2), primary key(id)) ENGINE=MyISAM DEFAULT CHARSET=cp1250 COLLATE=cp1250_general_ci;');

331

$result = $this->db->readTableParameters('tinyint');

332

$expected = array(

333

'charset' => 'cp1250',

334

'collate' => 'cp1250_general_ci',

335

'engine' => 'MyISAM');

336

$this->assertEqual($result, $expected);

337

$this->db->query('DROP TABLE ' . $this->db->fullTableName('tinyint'));

338

}

339

}

Older »