public void SetPartMarker()
{
Tokenizer testSubject = new Tokenizer("set part marker");
testSubject.SetPartMarker();
testSubject.GetNextAsString();
testSubject.GetNextAsString();
Assert.AreEqual("set part", testSubject.GetPart(testSubject.PartMarker, testSubject.Position));
testSubject.SetPartMarker();
testSubject.GetNextAsString();
Assert.AreEqual(" marker", testSubject.GetPart(testSubject.PartMarker, testSubject.Position));
}
public void LastPart()
{
Tokenizer testSubject = new Tokenizer("create table test(id int, \"val\" varchar(12));");
Assert.AreEqual(Token.ValueFor.CREATE, testSubject.GetNextAsSimpleToken());
Assert.AreEqual(6, testSubject.Position);
Assert.AreEqual("create", testSubject.LastPart);
Assert.AreEqual(Token.ValueFor.TABLE, testSubject.GetNextAsSimpleToken());
Assert.AreEqual(12, testSubject.Position);
Assert.AreEqual("create table", testSubject.LastPart);
testSubject.PartMarker = testSubject.Position + 1;
Assert.AreEqual("TEST", testSubject.GetNextAsSimpleName());
Assert.AreEqual(17, testSubject.Position);
Assert.AreEqual("test", testSubject.LastPart);
Assert.AreEqual(Token.ValueFor.OPENBRACKET, testSubject.GetNextAsSimpleToken());
Assert.AreEqual(18, testSubject.Position);
Assert.AreEqual("test(", testSubject.LastPart);
Assert.AreEqual("ID", testSubject.GetNextAsSimpleName());
Assert.AreEqual(20, testSubject.Position);
Assert.AreEqual("test(id", testSubject.LastPart);
Assert.AreEqual(Token.ValueFor.INT, testSubject.GetNextAsSimpleToken());
Assert.AreEqual(24, testSubject.Position);
Assert.AreEqual("test(id int", testSubject.LastPart);
testSubject.SetPartMarker();
Assert.AreEqual(Token.ValueFor.COMMA, testSubject.GetNextAsSimpleToken());
Assert.AreEqual(25, testSubject.Position);
Assert.AreEqual(Token.ValueFor.COMMA, testSubject.LastPart);
Assert.AreEqual("val", testSubject.GetNextAsName());
Assert.AreEqual(SqlTokenType.DelimitedIdentifier, testSubject.TokenType);
Assert.AreEqual(31,testSubject.Position);
Assert.AreEqual(", \"val\"", testSubject.LastPart);
Assert.AreEqual(Token.ValueFor.VARCHAR, testSubject.GetNextAsSimpleToken());
Assert.AreEqual(39, testSubject.Position);
Assert.AreEqual(", \"val\" varchar", testSubject.LastPart);
Assert.AreEqual(Token.ValueFor.OPENBRACKET, testSubject.GetThis(Token.ValueFor.OPENBRACKET));
Assert.AreEqual(40, testSubject.Position);
Assert.AreEqual(", \"val\" varchar(", testSubject.LastPart);
Assert.AreEqual(12, testSubject.GetNextAsInt());
Assert.AreEqual(42, testSubject.Position);
Assert.AreEqual(", \"val\" varchar(12", testSubject.LastPart);
Assert.AreEqual(Token.ValueFor.CLOSEBRACKET, testSubject.GetThis(Token.ValueFor.CLOSEBRACKET));
Assert.AreEqual(43, testSubject.Position);
Assert.AreEqual(", \"val\" varchar(12)", testSubject.LastPart);
testSubject.SetPartMarker();
Assert.AreEqual(Token.ValueFor.CLOSEBRACKET, testSubject.GetThis(Token.ValueFor.CLOSEBRACKET));
Assert.AreEqual(44, testSubject.Position);
Assert.AreEqual(Token.ValueFor.CLOSEBRACKET, testSubject.LastPart);
Assert.AreEqual(Token.ValueFor.SEMICOLON, testSubject.GetThis(Token.ValueFor.SEMICOLON));
Assert.AreEqual(45, testSubject.Position);
Assert.AreEqual(");", testSubject.LastPart);
Assert.AreEqual(string.Empty, testSubject.GetNextAsString());
Assert.AreEqual(45, testSubject.Position);
Assert.AreEqual(");", testSubject.LastPart);
testSubject.SetPartMarker();
Assert.AreEqual(string.Empty, testSubject.LastPart);
}
public void PartMarker()
{
Tokenizer testSubject = new Tokenizer("part of this");
testSubject.SetPartMarker();
int origin = testSubject.PartMarker;
testSubject.GetNextAsString();
testSubject.GetNextAsString();
Assert.AreEqual("part of", testSubject.GetPart(origin, testSubject.Position));
}
public void GetPart()
{
Tokenizer testSubject = new Tokenizer("FOO.BAR AS BAR.FOO");
string actual = testSubject.GetPart(0, "FOO.BAR AS BAR.FOO".Length);
Assert.AreEqual("FOO.BAR AS BAR.FOO", actual);
testSubject.SetPartMarker();
Assert.AreEqual(0, testSubject.PartMarker);
Assert.AreEqual(0, testSubject.Position);
actual = testSubject.GetNextAsString();
Assert.AreEqual("BAR", actual);
Assert.AreEqual(SqlTokenType.IdentifierChain, testSubject.TokenType);
Assert.That(!testSubject.WasIdentifierChainPredecessorDelimited);
Assert.AreEqual("FOO", testSubject.IdentifierChainPredecessor);
Assert.AreEqual("FOO.BAR ".IndexOf(' '), testSubject.Position);
actual = testSubject.GetPart(testSubject.PartMarker, testSubject.Position);
Assert.AreEqual("FOO.BAR", actual);
testSubject.SetPartMarker();
actual = testSubject.GetNextAsString();
Assert.AreEqual(Token.ValueFor.AS, actual);
Assert.AreEqual("FOO.BAR_AS ".IndexOf(' '), testSubject.Position);
actual = testSubject.GetPart(testSubject.PartMarker, testSubject.Position);
Assert.AreEqual(" AS", actual);
}
