Package com.almworks.sqlite4java

Examples of com.almworks.sqlite4java.SQLiteStatement

407
408
409
410
411
412
413
414
415
416
417
418
419
420
    "FROM " +
      "exclude " +
    "WHERE " +
      "projectId = " + projectId;

    SQLiteStatement st = Db.getInstance().query(sql);

    while(st.step())
    {
      exclude.add(st.columnString(0));
    }

    return exclude;
  }
View Full Code Here
110
111
112
113
114
115
116
117
118
119
120
121
122
      "?, " +
      "?, " +
      "?" +
    ")";

    SQLiteStatement st = Db.getInstance().query(sql);

    st.bind(1, this.getType());
    st.bind(2, this.getName());
    st.bind(3, serialize(this.getConfig()));

    st.step();
  }
View Full Code Here
130
131
132
133
134
135
136
137
138
139
140
141
142
      "name = ?, " +
      "config = ? " +
    "WHERE " +
      "id = " + this.getId();

    SQLiteStatement st = Db.getInstance().query(sql);

    st.bind(1, this.getType());
    st.bind(2, this.getName());
    st.bind(3, serialize(this.getConfig()));

    st.step();
  }
View Full Code Here
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
    "FROM " +
      "resources " +
    "WHERE " +
      "id = " + id;

    SQLiteStatement st = Db.getInstance().query(sql);

    st.step();

    if(st.hasRow())
    {
      Resource resource = new Resource();

      resource.id = st.columnInt(0);
      resource.type = st.columnString(1);
      resource.name = st.columnString(2);
      resource.config = Resource.unserialize(st.columnBlob(3));

      return resource;
    }
    else
    {
View Full Code Here
191
192
193
194
195
196
197
198
199
200
201
202
203
204
    String sql = "SELECT " +
      "id " +
    "FROM " +
      "resources";

    SQLiteStatement st = Db.getInstance().query(sql);

    while(st.step())
    {
      resources.add(Resource.getResourceById(st.columnInt(0)));
    }

    return resources;
  }
View Full Code Here
88
89
90
91
92
93
94
95
96
97
98
99
    ") VALUES (" +
      "?, " +
      "?" +
    ")";

    SQLiteStatement st = Db.getInstance().query(sql);

    st.bind(1, this.getProjectId());
    st.bind(2, this.getPattern());

    st.step();
  }
View Full Code Here
106
107
108
109
110
111
112
113
114
115
116
117
      "projectId = ?, " +
      "pattern = ? " +
    "WHERE " +
      "id = " + this.getId();

    SQLiteStatement st = Db.getInstance().query(sql);

    st.bind(1, this.getProjectId());
    st.bind(2, this.getPattern());

    st.step();
  }
View Full Code Here
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
    "FROM " +
      "exclude " +
    "WHERE " +
      "id = " + id;

    SQLiteStatement st = Db.getInstance().query(sql);

    st.step();

    if(st.hasRow())
    {
      Exclude exclude = new Exclude();

      exclude.id = st.columnInt(0);
      exclude.projectId = st.columnInt(1);
      exclude.pattern = st.columnString(2);

      return exclude;
    }
    else
    {
View Full Code Here
185
186
187
188
189
190
191
192
193
194
195
196
197
198
    if(limit > 0)
    {
      sql+= " LIMIT " + limit;
    }

    SQLiteStatement st = Db.getInstance().query(sql);

    while(st.step())
    {
      releases.add(Release.getReleaseById(st.columnInt(0)));
    }

    return releases;
  }
View Full Code Here
211
212
213
214
215
216
217
218
219
220
221
222
223
224
    "FROM " +
      "exclude " +
    "ORDER BY " +
      "id DESC";

    SQLiteStatement st = Db.getInstance().query(sql);

    while(st.step())
    {
      excludes.add(Exclude.getExcludeById(st.columnInt(0)));
    }

    return excludes;
  }
View Full Code Here
TOP

Related Classes of com.almworks.sqlite4java.SQLiteStatement

  • com.cloudera.recordbreaker.analyzer.FSAnalyzer
  • com.k42b3.kadabra.record.Exclude
  • com.k42b3.kadabra.record.Project
  • com.k42b3.kadabra.record.Release
  • com.k42b3.kadabra.record.Resource
  • com.kolakcc.loljclient.model.Champion
  • com.kolakcc.loljclient.model.Item
  • com.splout.db.engine.SQLite4JavaClient
  • com.splout.db.hadoop.engine.SQLite4JavaOutputFormat
  • de.zib.scalaris.examples.wikipedia.data.xml.WikiDumpGetCategoryTreeHandler
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.