var xsql = require('../lib/instance');


describe('escape', function () {
	describe('quotes', function () {
		it('mysql', function () {
			var x = new xsql({dialect:'mysql'});
			x.quotes('name').should.equal('`name`');
		});
		it('sqlite', function () {
			var x = new xsql({dialect:'sqlite'});
			x.quotes('name').should.equal('"name"');
		});
		it('pg', function () {
			var x = new xsql({dialect:'pg'});
			x.quotes('name').should.equal('"name"');
		});
	});

	describe('wrap', function () {
		it('single quote by default', function () {
			var x = new xsql({dialect:'pg'});
			x.wrap('str').should.equal("'str'");
		});
		it('specify single quote', function () {
			var x = new xsql({dialect:'pg'});
			x.wrap('str',"'").should.equal("'str'");
		});
		it('specify double quote', function () {
			var x = new xsql({dialect:'pg'});
			x.wrap('str','"').should.equal('"str"');
		});
		it('specify quote', function () {
			var x = new xsql({dialect:'pg'});
			x.wrap('str','`').should.equal('`str`');
		});
	});

	describe('escape', function () {
		it('escape single quotes', function () {
			var x = new xsql({dialect:'pg'});
			x.escape("that's true").should.equal("that''s true");
		});
	});

	describe('string', function () {
		it('escape single quotes', function () {
			var x = new xsql({dialect:'pg'});
			x.string("that's true").should.equal("'that''s true'");
		});
	});
});