hqlparsertest.java

hibernate 开源框架的代码 jar包希望大家能喜欢

		parse( "select foo.long, foo.component.name, foo, foo.foo from foo in class org.hibernate.test.Foo" );
		parse( "select avg(foo.float), max(foo.component.name), count(distinct foo.id) from foo in class org.hibernate.test.Foo" );
		parse( "select foo.long, foo.component, foo, foo.foo from foo in class org.hibernate.test.Foo" );
		parse( "from o in class org.hibernate.test.MoreStuff" );
		parse( "from o in class org.hibernate.test.Many" );
		parse( "from o in class org.hibernate.test.Fee" );
		parse( "from o in class org.hibernate.test.Qux" );
		parse( "from o in class org.hibernate.test.Y" );
		parse( "from o in class org.hibernate.test.Fumm" );
		parse( "from o in class org.hibernate.test.X" );
		parse( "from o in class org.hibernate.test.Simple" );
		parse( "from o in class org.hibernate.test.Location" );
		parse( "from o in class org.hibernate.test.Holder" );
		parse( "from o in class org.hibernate.test.Part" );
		parse( "from o in class org.hibernate.test.Baz" );
		parse( "from o in class org.hibernate.test.Vetoer" );
		parse( "from o in class org.hibernate.test.Sortable" );
		parse( "from o in class org.hibernate.test.Contained" );
		parse( "from o in class org.hibernate.test.Stuff" );
		parse( "from o in class org.hibernate.test.Immutable" );
		parse( "from o in class org.hibernate.test.Container" );
		parse( "from o in class org.hibernate.test.X$XX" );
		parse( "from o in class org.hibernate.test.One" );
		parse( "from o in class org.hibernate.test.Foo" );
		parse( "from o in class org.hibernate.test.Fo" );
		parse( "from o in class org.hibernate.test.Glarch" );
		parse( "from o in class org.hibernate.test.Fum" );
		parse( "from n in class org.hibernate.test.Holder" );
		parse( "from n in class org.hibernate.test.Baz" );
		parse( "from n in class org.hibernate.test.Bar" );
		parse( "from n in class org.hibernate.test.Glarch" );
		parse( "from n in class org.hibernate.test.Holder where n.name is not null" );
		parse( "from n in class org.hibernate.test.Baz where n.name is not null" );
		parse( "from n in class org.hibernate.test.Bar where n.name is not null" );
		parse( "from n in class org.hibernate.test.Glarch where n.name is not null" );
		parse( "from n in class org.hibernate.test.Holder" );
		parse( "from n in class org.hibernate.test.Baz" );
		parse( "from n in class org.hibernate.test.Bar" );
		parse( "from n in class org.hibernate.test.Glarch" );
		parse( "from n0 in class org.hibernate.test.Holder, n1 in class org.hibernate.test.Holder where n0.name = n1.name" );
		parse( "from n0 in class org.hibernate.test.Baz, n1 in class org.hibernate.test.Holder where n0.name = n1.name" );
		parse( "from n0 in class org.hibernate.test.Bar, n1 in class org.hibernate.test.Holder where n0.name = n1.name" );
		parse( "from n0 in class org.hibernate.test.Glarch, n1 in class org.hibernate.test.Holder where n0.name = n1.name" );
		parse( "from n0 in class org.hibernate.test.Holder, n1 in class org.hibernate.test.Baz where n0.name = n1.name" );
		parse( "from n0 in class org.hibernate.test.Baz, n1 in class org.hibernate.test.Baz where n0.name = n1.name" );
		parse( "from n0 in class org.hibernate.test.Bar, n1 in class org.hibernate.test.Baz where n0.name = n1.name" );
		parse( "from n0 in class org.hibernate.test.Glarch, n1 in class org.hibernate.test.Baz where n0.name = n1.name" );
		parse( "from n0 in class org.hibernate.test.Holder, n1 in class org.hibernate.test.Bar where n0.name = n1.name" );
		parse( "from n0 in class org.hibernate.test.Baz, n1 in class org.hibernate.test.Bar where n0.name = n1.name" );
		parse( "from n0 in class org.hibernate.test.Bar, n1 in class org.hibernate.test.Bar where n0.name = n1.name" );
		parse( "from n0 in class org.hibernate.test.Glarch, n1 in class org.hibernate.test.Bar where n0.name = n1.name" );
		parse( "from n0 in class org.hibernate.test.Holder, n1 in class org.hibernate.test.Glarch where n0.name = n1.name" );
		parse( "from n0 in class org.hibernate.test.Baz, n1 in class org.hibernate.test.Glarch where n0.name = n1.name" );
		parse( "from n0 in class org.hibernate.test.Bar, n1 in class org.hibernate.test.Glarch where n0.name = n1.name" );
		parse( "from n0 in class org.hibernate.test.Glarch, n1 in class org.hibernate.test.Glarch where n0.name = n1.name" );
		parse( "from n in class org.hibernate.test.Holder where n.name = :name" );
		parse( "from o in class org.hibernate.test.MoreStuff" );
		parse( "from o in class org.hibernate.test.Many" );
		parse( "from o in class org.hibernate.test.Fee" );
		parse( "from o in class org.hibernate.test.Qux" );
		parse( "from o in class org.hibernate.test.Y" );
		parse( "from o in class org.hibernate.test.Fumm" );
		parse( "from o in class org.hibernate.test.X" );
		parse( "from o in class org.hibernate.test.Simple" );
		parse( "from o in class org.hibernate.test.Location" );
		parse( "from o in class org.hibernate.test.Holder" );
		parse( "from o in class org.hibernate.test.Part" );
		parse( "from o in class org.hibernate.test.Baz" );
		parse( "from o in class org.hibernate.test.Vetoer" );
		parse( "from o in class org.hibernate.test.Sortable" );
		parse( "from o in class org.hibernate.test.Contained" );
		parse( "from o in class org.hibernate.test.Stuff" );
		parse( "from o in class org.hibernate.test.Immutable" );
		parse( "from o in class org.hibernate.test.Container" );
		parse( "from o in class org.hibernate.test.X$XX" );
		parse( "from o in class org.hibernate.test.One" );
		parse( "from o in class org.hibernate.test.Foo" );
		parse( "from o in class org.hibernate.test.Fo" );
		parse( "from o in class org.hibernate.test.Glarch" );
		parse( "from o in class org.hibernate.test.Fum" );
		parse( "select baz.code, min(baz.count) from baz in class org.hibernate.test.Baz group by baz.code" );
		parse( "selecT baz from baz in class org.hibernate.test.Baz where baz.stringDateMap['foo'] is not null or baz.stringDateMap['bar'] = ?" );
		parse( "select baz from baz in class org.hibernate.test.Baz where baz.stringDateMap['now'] is not null" );
		parse( "select baz from baz in class org.hibernate.test.Baz where baz.stringDateMap['now'] is not null and baz.stringDateMap['big bang'] < baz.stringDateMap['now']" );
		parse( "select index(date) from org.hibernate.test.Baz baz join baz.stringDateMap date" );
		parse( "from foo in class org.hibernate.test.Foo where foo.integer not between 1 and 5 and foo.string not in ('cde', 'abc') and foo.string is not null and foo.integer<=3" );
		parse( "from org.hibernate.test.Baz baz inner join baz.collectionComponent.nested.foos foo where foo.string is null" );
		parse( "from org.hibernate.test.Baz baz inner join baz.fooSet where '1' in (from baz.fooSet foo where foo.string is not null)" );
		parse( "from org.hibernate.test.Baz baz where 'a' in elements(baz.collectionComponent.nested.foos) and 1.0 in elements(baz.collectionComponent.nested.floats)" );
		parse( "from org.hibernate.test.Foo foo join foo.foo where foo.foo in ('1','2','3')" );
		parse( "select foo.foo from org.hibernate.test.Foo foo where foo.foo in ('1','2','3')" );
		parse( "select foo.foo.string from org.hibernate.test.Foo foo where foo.foo in ('1','2','3')" );
		parse( "select foo.foo.string from org.hibernate.test.Foo foo where foo.foo.string in ('1','2','3')" );
		parse( "select foo.foo.long from org.hibernate.test.Foo foo where foo.foo.string in ('1','2','3')" );
		parse( "select count(*) from org.hibernate.test.Foo foo where foo.foo.string in ('1','2','3') or foo.foo.long in (1,2,3)" );
		parse( "select count(*) from org.hibernate.test.Foo foo where foo.foo.string in ('1','2','3') group by foo.foo.long" );
		parse( "from org.hibernate.test.Foo foo1 left join foo1.foo foo2 left join foo2.foo where foo1.string is not null" );
		parse( "from org.hibernate.test.Foo foo1 left join foo1.foo.foo where foo1.string is not null" );
		parse( "from org.hibernate.test.Foo foo1 left join foo1.foo foo2 left join foo1.foo.foo foo3 where foo1.string is not null" );
		parse( "select foo.formula from org.hibernate.test.Foo foo where foo.formula > 0" );
		parse( "from org.hibernate.test.Foo as foo join foo.foo as foo2 where foo2.id >'a' or foo2.id <'a'" );
		parse( "from org.hibernate.test.Holder" );
		parse( "from org.hibernate.test.Baz baz left outer join fetch baz.manyToAny" );
		parse( "from org.hibernate.test.Baz baz join baz.manyToAny" );
		parse( "select baz from org.hibernate.test.Baz baz join baz.manyToAny a where index(a) = 0" );
		parse( "select bar from org.hibernate.test.Bar bar where bar.baz.stringDateMap['now'] is not null" );
		parse( "select bar from org.hibernate.test.Bar bar join bar.baz b where b.stringDateMap['big bang'] < b.stringDateMap['now'] and b.stringDateMap['now'] is not null" );
		parse( "select bar from org.hibernate.test.Bar bar where bar.baz.stringDateMap['big bang'] < bar.baz.stringDateMap['now'] and bar.baz.stringDateMap['now'] is not null" );
		parse( "select foo.string, foo.component, foo.id from org.hibernate.test.Bar foo" );
		parse( "select elements(baz.components) from org.hibernate.test.Baz baz" );
		parse( "select bc.name from org.hibernate.test.Baz baz join baz.components bc" );
		parse( "from org.hibernate.test.Foo foo where foo.integer < 10 order by foo.string" );
		parse( "from org.hibernate.test.Fee" );
		parse( "from org.hibernate.test.Holder h join h.otherHolder oh where h.otherHolder.name = 'bar'" );
		parse( "from org.hibernate.test.Baz baz join baz.fooSet foo join foo.foo.foo foo2 where foo2.string = 'foo'" );
		parse( "from org.hibernate.test.Baz baz join baz.fooArray foo join foo.foo.foo foo2 where foo2.string = 'foo'" );
		parse( "from org.hibernate.test.Baz baz join baz.stringDateMap date where index(date) = 'foo'" );
		parse( "from org.hibernate.test.Baz baz join baz.topGlarchez g where index(g) = 'A'" );
		parse( "select index(g) from org.hibernate.test.Baz baz join baz.topGlarchez g" );
		parse( "from org.hibernate.test.Baz baz left join baz.stringSet" );
		parse( "from org.hibernate.test.Baz baz join baz.stringSet str where str='foo'" );
		parse( "from org.hibernate.test.Baz baz left join fetch baz.stringSet" );
		parse( "from org.hibernate.test.Baz baz join baz.stringSet string where string='foo'" );
		parse( "from org.hibernate.test.Baz baz inner join baz.components comp where comp.name='foo'" );
		parse( "from org.hibernate.test.Glarch g inner join g.fooComponents comp where comp.fee is not null" );
		parse( "from org.hibernate.test.Glarch g inner join g.fooComponents comp join comp.fee fee where fee.count > 0" );
		parse( "from org.hibernate.test.Glarch g inner join g.fooComponents comp where comp.fee.count is not null" );
		parse( "from org.hibernate.test.Baz baz left join fetch baz.fooBag" );
		parse( "from org.hibernate.test.Glarch" );
		parse( "from org.hibernate.test.Fee" );
		parse( "from org.hibernate.test.Baz baz left join fetch baz.sortablez order by baz.name asc" );
		parse( "from org.hibernate.test.Baz baz order by baz.name asc" );
		parse( "from org.hibernate.test.Foo foo, org.hibernate.test.Baz baz left join fetch baz.fees" );
		parse( "from org.hibernate.test.Foo foo, org.hibernate.test.Bar bar" );
		parse( "from org.hibernate.test.Foo foo" );
		parse( "from org.hibernate.test.Foo foo, org.hibernate.test.Bar bar, org.hibernate.test.Bar bar2" );
		parse( "from org.hibernate.test.X x" );
		parse( "from org.hibernate.test.Foo foo" );
		parse( "select distinct foo from org.hibernate.test.Foo foo" );
		parse( "from org.hibernate.test.Glarch g where g.multiple.glarch=g and g.multiple.count=12" );
		parse( "from org.hibernate.test.Bar bar left join bar.baz baz left join baz.cascadingBars b where bar.name like 'Bar %'" );
		parse( "select bar, b from org.hibernate.test.Bar bar left join bar.baz baz left join baz.cascadingBars b where bar.name like 'Bar%'" );
		parse( "select bar, b from org.hibernate.test.Bar bar left join bar.baz baz left join baz.cascadingBars b where ( bar.name in (:nameList0_, :nameList1_, :nameList2_) or bar.name in (:nameList0_, :nameList1_, :nameList2_) ) and bar.string = :stringVal" );
		parse( "select bar, b from org.hibernate.test.Bar bar inner join bar.baz baz inner join baz.cascadingBars b where bar.name like 'Bar%'" );
		parse( "select bar, b from org.hibernate.test.Bar bar left join bar.baz baz left join baz.cascadingBars b where bar.name like :name and b.name like :name" );
		parse( "select bar from org.hibernate.test.Bar as bar where bar.x > ? or bar.short = 1 or bar.string = 'ff ? bb'" );
		parse( "select bar from org.hibernate.test.Bar as bar where bar.string = ' ? ' or bar.string = '?'" );
		parse( "from org.hibernate.test.Baz baz, baz.fooArray foo" );
		parse( "from s in class org.hibernate.test.Stuff where s.foo.id = ? and s.id.id = ? and s.moreStuff.id.intId = ? and s.moreStuff.id.stringId = ?" );
		parse( "from s in class org.hibernate.test.Stuff where s.foo.id = ? and s.id.id = ? and s.moreStuff.name = ?" );
		parse( "from s in class org.hibernate.test.Stuff where s.foo.string is not null" );
		parse( "from s in class org.hibernate.test.Stuff where s.foo > '0' order by s.foo" );
		parse( "from ms in class org.hibernate.test.MoreStuff" );
		parse( "from foo in class org.hibernate.test.Foo" );
		parse( "from fee in class org.hibernate.test.Fee" );
		parse( "select new Result(foo.string, foo.long, foo.integer) from foo in class org.hibernate.test.Foo" );
		parse( "select new Result( baz.name, foo.long, count(elements(baz.fooArray)) ) from org.hibernate.test.Baz baz join baz.fooArray foo group by baz.name, foo.long" );
		parse( "select new Result( baz.name, max(foo.long), count(foo) ) from org.hibernate.test.Baz baz join baz.fooArray foo group by baz.name" );
		parse( "select max( elements(bar.baz.fooArray) ) from org.hibernate.test.Bar as bar" );
		parse( "from org.hibernate.test.Baz baz left join baz.fooToGlarch join fetch baz.fooArray foo left join fetch foo.foo" );
		parse( "select baz.name from org.hibernate.test.Bar bar inner join bar.baz baz inner join baz.fooSet foo where baz.name = bar.string" );
		parse( "SELECT baz.name FROM org.hibernate.test.Bar AS bar INNER JOIN bar.baz AS baz INNER JOIN baz.fooSet AS foo WHERE baz.name = bar.string" );
		parse( "select baz.name from org.hibernate.test.Bar bar join bar.baz baz left outer join baz.fooSet foo where baz.name = bar.string" );
		parse( "select baz.name from org.hibernate.test.Bar bar, bar.baz baz, baz.fooSet foo where baz.name = bar.string" );
		parse( "SELECT baz.name FROM org.hibernate.test.Bar AS bar, bar.baz AS baz, baz.fooSet AS foo WHERE baz.name = bar.string" );
		parse( "select baz.name from org.hibernate.test.Bar bar left join bar.baz baz left join baz.fooSet foo where baz.name = bar.string" );
		parse( "select foo.string from org.hibernate.test.Bar bar left join bar.baz.fooSet foo where bar.string = foo.string" );
		parse( "select baz.name from org.hibernate.test.Bar bar left join bar.baz baz left join baz.fooArray foo where baz.name = bar.string" );
		parse( "select foo.string from org.hibernate.test.Bar bar left join bar.baz.fooArray foo where bar.string = foo.string" );
		parse( "select foo from bar in class org.hibernate.test.Bar inner join bar.baz as baz inner join baz.fooSet as foo" );
		parse( "select foo from bar in class org.hibernate.test.Bar inner join bar.baz.fooSet as foo" );
		parse( "select foo from bar in class org.hibernate.test.Bar, bar.baz as baz, baz.fooSet as foo" );
		parse( "select foo from bar in class org.hibernate.test.Bar, bar.baz.fooSet as foo" );
		parse( "from org.hibernate.test.Bar bar join bar.baz.fooArray foo" );
		parse( "from bar in class org.hibernate.test.Bar, foo in elements( bar.baz.fooArray )" );
		parse( "select one.id, elements(one.manies) from one in class org.hibernate.test.One" );
		parse( "select max( elements(one.manies) ) from one in class org.hibernate.test.One" );
		parse( "select one, elements(one.manies) from one in class org.hibernate.test.One" );
		parse( "select one, max(elements(one.manies)) from one in class org.hibernate.test.One group by one" );
		parse( "select elements(baz.fooArray) from baz in class org.hibernate.test.Baz where baz.id=?" );
		parse( "select elements(baz.fooArray) from baz in class org.hibernate.test.Baz where baz.id=?" );
		parse( "select indices(baz.fooArray) from baz in class org.hibernate.test.Baz where baz.id=?" );
		parse( "select baz, max(elements(baz.timeArray)) from baz in class org.hibernate.test.Baz group by baz" );
		parse( "select baz, baz.stringSet.size, count(distinct elements(baz.stringSet)), max(elements(baz.stringSet)) from baz in class org.hibernate.test.Baz group by baz" );
		parse( "select max( elements(baz.timeArray) ) from baz in class org.hibernate.test.Baz where baz.id=?" );
		parse( "select max(elements(baz.stringSet)) from baz in class org.hibernate.test.Baz where baz.id=?" );
		parse( "select size(baz.stringSet) from baz in class org.hibernate.test.Baz where baz.id=?" );
		parse( "from org.hibernate.test.Foo foo where foo.component.glarch.id is not null" );
		parse( "from baz in class org.hibernate.test.Baz" );
		parse( "select elements(baz.stringArray) from baz in class org.hibernate.test.Baz" );
		parse( "from foo in class org.hibernate.test.Foo" );
		parse( "select elements(baz.stringList) from baz in class org.hibernate.test.Baz" );
		parse( "select count(*) from org.hibernate.test.Bar" );
		parse( "select count(*) from b in class org.hibernate.test.Bar" );
		parse( "from g in class org.hibernate.test.Glarch" );
		parse( "select baz, baz from baz in class org.hibernate.test.Baz" );
		parse( "select baz from baz in class org.hibernate.test.Baz order by baz" );
		parse( "from bar in class org.hibernate.test.Bar" );
		parse( "from g in class org.hibernate.test.Glarch" );
		parse( "from f in class org.hibernate.test.Foo" );
		parse( "from o in class org.hibernate.test.One" );
		parse( "from q in class org.hibernate.test.Qux" );
		parse( "select foo from foo in class org.hibernate.test.Foo where foo.string='foo bar'" );