Queries.java

package net.metanotion.formsauth;

/** <i>This is a SQL query class generated by the SQLC compiler.</i> */
@javax.annotation.Generated("net.metanotion.sqlc.SQLC")  final class Queries {
	private final net.metanotion.util.Dictionary<Class,net.metanotion.util.types.Parser> types;
	public Queries() { this.types = new net.metanotion.util.types.TypeDictionary(); }
	public Queries(net.metanotion.util.Dictionary<Class,net.metanotion.util.types.Parser> types) { this.types = types; }
	public java.util.List<String> getValidationCodeByToken(final java.sql.Connection _0, final @javax.inject.Named("vid") long _1, final @javax.inject.Named("uuid") String _2) throws Exception {
			try (final java.sql.PreparedStatement _3 = _0.prepareStatement("SELECT Username FROM ValidationRequests WHERE ValidateID = ? AND UUID = ?")) {
			_3.setLong(1, _1);
			_3.setString(2, _2);
			try (final java.sql.ResultSet _4 = _3.executeQuery()) {
			final java.util.List<String> _5 = new java.util.ArrayList<String>();
		while(_4.next()) {
					_5.add(_4.getString(1));
		}
			return _5;
}
}
	}
	public java.util.List<net.metanotion.formsauth.ResetCode> getResetCode(final java.sql.Connection _0, final @javax.inject.Named("uname") String _1) throws Exception {
			try (final java.sql.PreparedStatement _2 = _0.prepareStatement("SELECT ResetID, UUID FROM PasswordResets WHERE Username = ?")) {
			_2.setString(1, _1);
			try (final java.sql.ResultSet _3 = _2.executeQuery()) {
			final java.util.List<net.metanotion.formsauth.ResetCode> _4 = new java.util.ArrayList<net.metanotion.formsauth.ResetCode>();
		final net.metanotion.util.reflect.GetInitializer<net.metanotion.formsauth.ResetCode> _5 = net.metanotion.util.reflect.ReflectiveFieldInitializer.getInitializer(net.metanotion.formsauth.ResetCode.class, this.types);
		while(_3.next()) {
					final net.metanotion.util.reflect.Initializer<net.metanotion.formsauth.ResetCode> _6 = _5.initializer();
					_6.put("ResetID", _3.getInt("ResetID"));
					_6.put("UUID", _3.getString("UUID"));
					_4.add(_6.instance());
		}
			return _4;
}
}
	}
	public int validateUsername(final java.sql.Connection _0, final @javax.inject.Named("uname") String _1) throws Exception {
			try (final java.sql.PreparedStatement _2 = _0.prepareStatement("INSERT INTO ValidatedPasswordAuthAccounts(Username) VALUES (?)")) {
			_2.setString(1, _1);
			final int _3 = _2.executeUpdate();
			return _3;
}
	}
	public java.util.List<String> getResetCodeByToken(final java.sql.Connection _0, final @javax.inject.Named("rid") long _1, final @javax.inject.Named("uuid") String _2) throws Exception {
			try (final java.sql.PreparedStatement _3 = _0.prepareStatement("SELECT Username FROM PasswordResets WHERE ResetID = ? AND UUID = ?")) {
			_3.setLong(1, _1);
			_3.setString(2, _2);
			try (final java.sql.ResultSet _4 = _3.executeQuery()) {
			final java.util.List<String> _5 = new java.util.ArrayList<String>();
		while(_4.next()) {
					_5.add(_4.getString(1));
		}
			return _5;
}
}
	}
	public int addRole(final java.sql.Connection _0, final @javax.inject.Named("uid") long _1, final @javax.inject.Named("roleName") String _2) throws Exception {
			try (final java.sql.PreparedStatement _3 = _0.prepareStatement("INSERT INTO UserRoles(UserID, RoleName) VALUES (?, ?)")) {
			_3.setLong(1, _1);
			_3.setString(2, _2);
			final int _4 = _3.executeUpdate();
			return _4;
}
	}
	public int reserveRID(final java.sql.Connection _0) throws Exception {
			try (final java.sql.PreparedStatement _1 = _0.prepareStatement("SELECT nextval('PasswordResets_ResetID_seq') AS RID")) {
			try (final java.sql.ResultSet _2 = _1.executeQuery()) {
		_2.next();
			return _2.getInt(1);
}
}
	}
	public int deleteValidationCode(final java.sql.Connection _0, final @javax.inject.Named("uname") String _1) throws Exception {
			try (final java.sql.PreparedStatement _2 = _0.prepareStatement("DELETE FROM ValidationRequests WHERE Username = ?")) {
			_2.setString(1, _1);
			final int _3 = _2.executeUpdate();
			return _3;
}
	}
	public int addValidationCode(final java.sql.Connection _0, final @javax.inject.Named("uname") String _1, final @javax.inject.Named("vid") int _2, final @javax.inject.Named("uuid") String _3) throws Exception {
			try (final java.sql.PreparedStatement _4 = _0.prepareStatement("INSERT INTO ValidationRequests(Username, ValidateID, UUID) VALUES (?, ?, ?)")) {
			_4.setString(1, _1);
			_4.setInt(2, _2);
			_4.setString(3, _3);
			final int _5 = _4.executeUpdate();
			return _5;
}
	}
	public int deleteResetCode(final java.sql.Connection _0, final @javax.inject.Named("uname") String _1) throws Exception {
			try (final java.sql.PreparedStatement _2 = _0.prepareStatement("DELETE FROM PasswordResets WHERE Username = ?")) {
			_2.setString(1, _1);
			final int _3 = _2.executeUpdate();
			return _3;
}
	}
	public java.util.List<net.metanotion.formsauth.ValidationCode> getValidationCode(final java.sql.Connection _0, final @javax.inject.Named("uname") String _1) throws Exception {
			try (final java.sql.PreparedStatement _2 = _0.prepareStatement("SELECT ValidateID, UUID FROM ValidationRequests WHERE Username = ?")) {
			_2.setString(1, _1);
			try (final java.sql.ResultSet _3 = _2.executeQuery()) {
			final java.util.List<net.metanotion.formsauth.ValidationCode> _4 = new java.util.ArrayList<net.metanotion.formsauth.ValidationCode>();
		final net.metanotion.util.reflect.GetInitializer<net.metanotion.formsauth.ValidationCode> _5 = net.metanotion.util.reflect.ReflectiveFieldInitializer.getInitializer(net.metanotion.formsauth.ValidationCode.class, this.types);
		while(_3.next()) {
					final net.metanotion.util.reflect.Initializer<net.metanotion.formsauth.ValidationCode> _6 = _5.initializer();
					_6.put("ValidateID", _3.getInt("ValidateID"));
					_6.put("UUID", _3.getString("UUID"));
					_4.add(_6.instance());
		}
			return _4;
}
}
	}
	public int addResetCode(final java.sql.Connection _0, final @javax.inject.Named("uname") String _1, final @javax.inject.Named("rid") int _2, final @javax.inject.Named("uuid") String _3) throws Exception {
			try (final java.sql.PreparedStatement _4 = _0.prepareStatement("INSERT INTO PasswordResets(Username, ResetID, UUID) VALUES (?, ?, ?)")) {
			_4.setString(1, _1);
			_4.setInt(2, _2);
			_4.setString(3, _3);
			final int _5 = _4.executeUpdate();
			return _5;
}
	}
	public int reserveVID(final java.sql.Connection _0) throws Exception {
			try (final java.sql.PreparedStatement _1 = _0.prepareStatement("SELECT nextval('ValidationRequests_ValidateID_seq') AS VID")) {
			try (final java.sql.ResultSet _2 = _1.executeQuery()) {
		_2.next();
			return _2.getInt(1);
}
}
	}
	public java.util.List<net.metanotion.formsauth.Account> getAccounts(final java.sql.Connection _0, final @javax.inject.Named("uid") long _1) throws Exception {
			try (final java.sql.PreparedStatement _2 = _0.prepareStatement("SELECT\tpw.Username AS username,\r\n\t\t\t\t\tCASE va.Username\r\n\t\t\t\t\t\tWHEN pw.Username THEN true\r\n\t\t\t\t\t\tELSE false\r\n\t\t\t\t\tEND AS validated \r\n\t\t\t\tFROM PasswordAuthenticationUsers pw \r\n\t\t\t\t\tLEFT JOIN ValidatedPasswordAuthAccounts va\r\n\t\t\t\t\t\tON (pw.Username = va.Username)\r\n\t\t\t\tWHERE UserID = ?")) {
			_2.setLong(1, _1);
			try (final java.sql.ResultSet _3 = _2.executeQuery()) {
			final java.util.List<net.metanotion.formsauth.Account> _4 = new java.util.ArrayList<net.metanotion.formsauth.Account>();
		final net.metanotion.util.reflect.GetInitializer<net.metanotion.formsauth.Account> _5 = net.metanotion.util.reflect.ReflectiveFieldInitializer.getInitializer(net.metanotion.formsauth.Account.class, this.types);
		while(_3.next()) {
					final net.metanotion.util.reflect.Initializer<net.metanotion.formsauth.Account> _6 = _5.initializer();
					_6.put("username", _3.getString("username"));
					_6.put("validated", _3.getBoolean("validated"));
					_4.add(_6.instance());
		}
			return _4;
}
}
	}
	public int deleteRoles(final java.sql.Connection _0, final @javax.inject.Named("uid") long _1) throws Exception {
			try (final java.sql.PreparedStatement _2 = _0.prepareStatement("DELETE FROM UserRoles WHERE UserID = ?")) {
			_2.setLong(1, _1);
			final int _3 = _2.executeUpdate();
			return _3;
}
	}
}