1 /*
2 * Copyright 2015-2018 HuntLabs.cn.
3 *
4 * Licensed under the Apache License, Version 2.0 (the "License");
5 * you may not use this file except in compliance with the License.
6 * You may obtain a copy of the License at
7 *
8 * http://www.apache.org/licenses/LICENSE-2.0
9 *
10 * Unless required by applicable law or agreed to in writing, software
11 * distributed under the License is distributed on an "AS IS" BASIS,
12 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13 * See the License for the specific language governing permissions and
14 * limitations under the License.
15 */16 17 modulehunt.sql.builder.SQLBuilder;
18 19 importhunt.sql.SQLUtils;
20 21 interfaceSQLBuilder {
22 23 SQLBuilderselect(string[] column...);
24 25 SQLBuilderselectWithAlias(stringcolumn, string_alias);
26 27 SQLBuilderfrom(stringtable);
28 29 SQLBuilderfrom(stringtable, string_alias);
30 31 SQLBuilderorderBy(string[] columns...);
32 33 SQLBuildergroupBy(stringexpr);
34 35 SQLBuilderhaving(stringexpr);
36 37 SQLBuilderinto(stringexpr);
38 39 SQLBuilderlimit(introwCount);
40 41 SQLBuilderoffset(intoffset);
42 43 SQLBuilderlimit(introwCount, intoffset);
44 45 SQLBuilderwhere(stringsql);
46 47 SQLBuilderwhereAnd(stringsql);
48 49 SQLBuilderwhereOr(stringsql);
50 51 SQLBuilderjoin(stringtable , string_alias = null, stringcond = null);
52 53 SQLBuilderinnerJoin(stringtable , string_alias = null, stringcond = null);
54 55 SQLBuilderleftJoin(stringtable , string_alias = null, stringcond = null);
56 57 SQLBuilderrightJoin(stringtable , string_alias = null, stringcond = null);
58 59 stringtoString();
60 61 stringtoString(FormatOptionoption);
62 }