@POST @Path("/login") @Consumes(MediaType.MULTIPART_FORM_DATA) public Response authenticate( @FormDataParam("username") String userId, @FormDataParam("password") String password) { Session session = databaseManager.getSession(); ResultSet user = session.execute("SELECT * FROM righteous.user where user_id = '" + userId + "'"); Row row = null; if (user.isExhausted()) { session.close(); return Response.status(200).entity("Invalid Username or Password").build(); } else { row = user.one(); } if (row.getString("user_id").equals(userId) && row.getString("user_password").equals(password)) { session.close(); return Response.status(200).entity("success").build(); } else { session.close(); return Response.status(200).entity("Invalid Username or Password").build(); } }
public java.util.LinkedList<Pic> getPicsForUser(String User) { java.util.LinkedList<Pic> Pics = new java.util.LinkedList<>(); Session session = cluster.connect("instagrAndrew"); PreparedStatement ps = session.prepare("select picid, hashtag, pic_added from userpiclist where user =?"); ResultSet rs = null; BoundStatement boundStatement = new BoundStatement(ps); rs = session.execute( // this is where the query is executed boundStatement.bind( // here you are binding the 'boundStatement' User)); if (rs.isExhausted()) { System.out.println("No Images returned"); return null; } else { for (Row row : rs) { Pic pic = new Pic(); java.util.UUID UUID = row.getUUID("picid"); Date d = row.getDate("pic_added"); java.sql.Timestamp tmp = new java.sql.Timestamp(d.getTime()); pic.setUUID(UUID); pic.setDate(tmp); String ht = row.getString("hashtag"); if (ht != null) { pic.setHashtag(ht); } Pics.add(pic); } } return Pics; }
public boolean validateUser(String username, String password) { AeSimpleSHA1 sha1handler = new AeSimpleSHA1(); String EncodedPassword = null; try { EncodedPassword = sha1handler.SHA1(password); } catch (UnsupportedEncodingException | NoSuchAlgorithmException et) { System.out.println("Can't check your password"); return false; } Session session = cluster.connect("ducquak"); PreparedStatement pS = session.prepare("SELECT * FROM users"); ResultSet rs = null; BoundStatement boundStatement = new BoundStatement(pS); rs = session.execute( // this is where the query is executed boundStatement // here you are binding the 'boundStatement' ); if (rs.isExhausted()) { System.out.println("Nothing returned"); return false; } else { for (Row row : rs) { String userName = row.getString("userName"); if (userName.equals(username)) { String StoredPass = row.getString("password"); if (StoredPass.compareTo(EncodedPassword) == 0) return true; } } } return false; }
/** Test simple statement inserts for all collection data types */ public void collectionInsertTest() throws Throwable { ResultSet rs; for (String execute_string : COLLECTION_INSERT_STATEMENTS) { rs = session.execute(execute_string); assertTrue(rs.isExhausted()); } assertEquals(SAMPLE_COLLECTIONS.size(), 255); assertEquals(COLLECTION_INSERT_STATEMENTS.size(), SAMPLE_COLLECTIONS.size()); }
/** Test simple statement inserts for all primitive data types */ public void primitiveInsertTest() throws Throwable { ResultSet rs; for (String execute_string : PRIMITIVE_INSERT_STATEMENTS) { rs = session.execute(execute_string); assertTrue(rs.isExhausted()); } assertEquals(SAMPLE_DATA.size(), 15); assertEquals(PRIMITIVE_INSERT_STATEMENTS.size(), SAMPLE_DATA.size()); }
/** * @param resultSet * @param type * @return * @deprecated as of 1.5, {@link * org.springframework.data.cassandra.mapping.CassandraMappingContext} handles type * conversion. */ @Deprecated public Object getSingleEntity(ResultSet resultSet, Class<?> type) { Object result = (resultSet.isExhausted() ? null : template.getConverter().read(type, resultSet.one())); warnIfMoreResults(resultSet); return result; }
private void warnIfMoreResults(ResultSet resultSet) { if (log.isWarnEnabled() && !resultSet.isExhausted()) { int count = 0; while (resultSet.one() != null) { count++; } log.warn("ignoring extra {} row{}", count, count == 1 ? "" : "s"); } }
public java.util.LinkedList<Pic> getMatchingPics(String searched) { java.util.LinkedList<Pic> picList = new java.util.LinkedList<Pic>(); Session session = cluster.connect("instagrAndrew"); PreparedStatement ps = session.prepare("select * from userpicList"); ResultSet rs = null; BoundStatement boundStatement = new BoundStatement(ps); rs = session.execute(boundStatement); if (rs.isExhausted()) { System.out.println("No Images returned"); return new java.util.LinkedList<Pic>(); } else { for (Row row : rs) { String fullString = row.getString("hashtag"); UUID uuid = row.getUUID("picId"); String us = row.getString("user"); Date d = row.getDate("pic_added"); java.sql.Timestamp tmp = new java.sql.Timestamp(d.getTime()); String[] tags; try { tags = fullString.split(","); } catch (Exception ex) { tags = null; } if (tags != null) { for (int i = 0; i < tags.length; i++) { if (tags[i].toLowerCase().equals(searched.toLowerCase())) { Pic toAdd = new Pic(); toAdd.setUUID(uuid); toAdd.setDate(tmp); toAdd.setUser(us); toAdd.setHashtag(fullString); picList.add(toAdd); break; } } } } } return picList; }
private void initScheme(Session session, String keyspace) throws IOException { if (keyspace == null) { keyspace = AlertProperties.getProperty(ALERTS_CASSANDRA_KEYSPACE, "hawkular_alerts"); } if (log.isDebugEnabled()) { log.debug("Checking Schema existence for keyspace: " + keyspace); } ResultSet resultSet = session.execute( "SELECT * FROM system.schema_keyspaces WHERE keyspace_name = '" + keyspace + "'"); if (!resultSet.isExhausted()) { log.debug("Schema already exist. Skipping schema creation."); initialized = true; return; } log.infof("Creating Schema for keyspace %s", keyspace); ImmutableMap<String, String> schemaVars = ImmutableMap.of("keyspace", keyspace); String updatedCQL = null; try (InputStream inputStream = CassCluster.class.getResourceAsStream("/hawkular-alerts-schema.cql"); InputStreamReader reader = new InputStreamReader(inputStream)) { String content = CharStreams.toString(reader); for (String cql : content.split("(?m)^-- #.*$")) { if (!cql.startsWith("--")) { updatedCQL = substituteVars(cql.trim(), schemaVars); if (log.isDebugEnabled()) { log.debug("Executing CQL:\n" + updatedCQL + "\n"); } session.execute(updatedCQL); } } } catch (Exception e) { log.errorf("Failed schema creation: %s\nEXECUTING CQL:\n%s", e, updatedCQL); } initialized = true; log.infof("Done creating Schema for keyspace: " + keyspace); }
public UUID getProfilePic(String User) { Session session = cluster.connect("instagrAndrew"); PreparedStatement ps = session.prepare("select profilepic from userprofiles where login =?"); ResultSet rs = null; BoundStatement boundStatement = new BoundStatement(ps); rs = session.execute( // this is where the query is executed boundStatement.bind( // here you are binding the 'boundStatement' User)); if (rs.isExhausted()) { System.out.println("No Images returned"); return null; } else { for (Row row : rs) { java.util.UUID UUID = row.getUUID("profilepic"); return UUID; } return null; } }
public Pic getPic(int image_type, java.util.UUID picid) { Session session = cluster.connect("instagrAndrew"); ByteBuffer bImage = null; String type = null; int length = 0; String date = ""; try { Convertors convertor = new Convertors(); ResultSet rs = null; PreparedStatement ps = null; if (image_type == Convertors.DISPLAY_IMAGE) { ps = session.prepare( "select image,imagelength,type,interaction_time from pics where picid =?"); } else if (image_type == Convertors.DISPLAY_THUMB) { ps = session.prepare( "select thumb,imagelength,thumblength,type,interaction_time from pics where picid =?"); } else if (image_type == Convertors.DISPLAY_PROCESSED) { ps = session.prepare( "select processed,processedlength,type,interaction_time from pics where picid =?"); } BoundStatement boundStatement = new BoundStatement(ps); rs = session.execute( // this is where the query is executed boundStatement.bind( // here you are binding the 'boundStatement' picid)); if (rs.isExhausted()) { System.out.println("No Images returned"); return null; } else { for (Row row : rs) { if (image_type == Convertors.DISPLAY_IMAGE) { bImage = row.getBytes("image"); length = row.getInt("imagelength"); // date = row.getString("interaction_time"); // hashtag = row.getString("hashtag"); } else if (image_type == Convertors.DISPLAY_THUMB) { bImage = row.getBytes("thumb"); length = row.getInt("thumblength"); // date = row.getString("interaction_time"); // hashtag = row.getString("hashtag"); } else if (image_type == Convertors.DISPLAY_PROCESSED) { bImage = row.getBytes("processed"); length = row.getInt("processedlength"); // date = row.getString("interaction_time"); // hashtag = row.getString("hashtag"); } type = row.getString("type"); } } } catch (Exception et) { System.out.println("Can't get Pic - " + et); return null; } session.close(); Pic p = new Pic(); p.setPic(bImage, length, type, null); return p; }
/** @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub Cluster cluster = Cluster.builder().addContactPoint("localhost").build(); Session session = cluster.connect(); String vehicleId = request.getParameter("veh_id"); String trackDate = request.getParameter("date_val"); String queryString = "SELECT time, latitude, longitude FROM vehicle_tracker.location WHERE vehicle_id = '" + vehicleId + "' AND date = '" + trackDate + "' LIMIT 1"; ResultSet result = session.execute(queryString); PrintWriter out = response.getWriter(); out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0 Transitional//EN\"><html>"); out.println("<head><title>Track a Vehicle</title></head>"); out.println("<body>"); out.println("<h1>Track a Vehicle</h1>"); out.println("Enter the track date and id of the vehicle you want to track"); out.println("<p> </p>"); out.println("<form id=\"form1\" name=\"form1\" method=\"get\" action=\"\">"); out.println("<table>"); out.println("<tr><td>Date (e.g. 2014-05-19):</td>"); out.println("<td><input type=\"text\" name=\"date_val\" id=\"date_val\"/></td></tr>"); out.println("<tr><td>Vehicle id (e.g. FLN78197):</td>"); out.println("<td><input type=\"text\" name=\"veh_id\" id=\"veh_id\" /></td></tr>"); out.println( "<tr><td></td><td><input type=\"submit\" name=\"submit\" id=\"submit\" value=\"Submit\"/></td></tr>"); out.println("</table>"); out.println("</form>"); out.println("<p> </p>"); if (request.getParameter("veh_id") == null) { // blank } else if (result.isExhausted()) { out.println("<hr/>"); out.println("<p> </p>"); out.println( "Sorry, no results for vehicle id " + request.getParameter("veh_id") + " for " + request.getParameter("date_val")); } else { out.println("<hr/>"); out.println("<table cellpadding=\"4\">"); out.println( "<tr><td colspan=\"3\"><h2>" + request.getParameter("veh_id") + "</h2></td></tr>"); out.println( "<tr><td><b>Date and Time</b></td><td><b>Latitude</b></td><td><b>Longitude</b></td></tr>"); for (Row row : result) { out.println("<tr>"); out.println("<td>" + row.getDate("time") + "</td>"); out.println("<td>" + row.getDouble("latitude") + "</td>"); out.println("<td>" + row.getDouble("longitude") + "</td>"); out.println("</tr>"); } out.println("</table>"); } out.println("</body></html>"); }