Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance. Project price only 1 $
You can buy this project and download/modify it how often you want.
/**
* Copyright (c) 2009-2016, netbout.com
* All rights reserved.
*
* Redistribution and use in source and binary forms, with or without
* modification, are PROHIBITED without prior written permission from
* the author. This product may NOT be used anywhere and on any computer
* except the server platform of netbout Inc. located at www.netbout.com.
* Federal copyright law prohibits unauthorized reproduction by any means
* and imposes fines up to $25,000 for violation. If you received
* this code accidentally and without intent to use it, please report this
* incident to the author by email.
*
* THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
* "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
* LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
* A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
* OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
* SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
* LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
* DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON
* ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
* OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT
* OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
* SUCH DAMAGE.
*/
package com.netbout.mock;
import com.jcabi.aspects.Immutable;
import com.jcabi.aspects.Loggable;
import com.jcabi.jdbc.JdbcSession;
import com.jcabi.jdbc.Outcome;
import com.jcabi.urn.URN;
import com.netbout.spi.Alias;
import com.netbout.spi.Aliases;
import java.io.IOException;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Collection;
import java.util.LinkedList;
import java.util.Locale;
import lombok.EqualsAndHashCode;
import lombok.ToString;
/**
* Cached aliases.
*
* @author Yegor Bugayenko ([email protected])
* @version $Id: 00d033c7e14ab375d50c3924a59fea325e1340fa $
* @since 2.4
*/
@Immutable
@ToString
@Loggable(Loggable.DEBUG)
@EqualsAndHashCode(of = { "sql", "urn" })
final class MkAliases implements Aliases {
/**
* SQL data source provider.
*/
private final transient Sql sql;
/**
* His URN.
*/
private final transient URN urn;
/**
* Public ctor.
* @param src Source
* @param name URN of user
*/
MkAliases(final Sql src, final URN name) {
this.sql = src;
this.urn = name;
}
@Override
public String check(final String name) throws IOException {
final boolean exists;
try {
exists = new JdbcSession(this.sql.source())
.sql("SELECT COUNT(*) FROM alias WHERE name = ?")
.set(name)
.select(Outcome.NOT_EMPTY);
} catch (final SQLException ex) {
throw new IOException(ex);
}
final String msg;
if (exists) {
msg = String.format("alias '%s' occupied", name);
} else {
msg = "";
}
return msg;
}
@Override
public Alias add(final String name) throws IOException {
try {
new JdbcSession(this.sql.source())
// @checkstyle LineLength (1 line)
.sql("INSERT INTO alias (name, urn, photo, locale, email) VALUES (?, ?, ?, ?, ?)")
.set(name)
.set(this.urn.toString())
.set(Alias.BLANK)
.set(Locale.ENGLISH)
.set("[email protected]")
.insert(Outcome.VOID);
} catch (final SQLException ex) {
throw new IOException(ex);
}
return new MkAlias(this.sql, name);
}
@Override
public Iterable iterate() throws IOException {
try {
return new JdbcSession(this.sql.source())
.sql("SELECT name FROM alias WHERE urn = ?")
.set(this.urn.toString())
.select(
new Outcome>() {
@Override
public Iterable handle(final ResultSet rset,
final Statement stmt) throws SQLException {
final Collection list =
new LinkedList();
while (rset.next()) {
list.add(
new MkAlias(
MkAliases.this.sql,
rset.getString(1)
)
);
}
return list;
}
}
);
} catch (final SQLException ex) {
throw new IOException(ex);
}
}
}
