All Downloads are FREE. Search and download functionalities are using the official Maven repository.
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.
io.baltoro.client.Replicator Maven / Gradle / Ivy
package io.baltoro.client;
import java.sql.PreparedStatement;
import java.util.ArrayList;
import java.util.List;
import java.util.Timer;
import java.util.TimerTask;
import java.util.concurrent.ConcurrentLinkedQueue;
import org.apache.derby.iapi.error.StandardException;
import org.apache.derby.iapi.sql.ParameterValueSet;
import org.apache.derby.iapi.types.DataValueDescriptor;
import org.apache.derby.impl.jdbc.EmbedPreparedStatement42;
import com.fasterxml.jackson.databind.ObjectMapper;
import io.baltoro.client.util.StringUtil;
import io.baltoro.to.ReplicationTO;
public class Replicator
{
//static boolean REPLICATION_ON = false;
//static boolean INT_SYNC = false;
static boolean runnig = false;
static private Timer pusher;
static private Timer puller;
private static ConcurrentLinkedQueue pushQueue = new ConcurrentLinkedQueue<>();
private static ObjectMapper mapper = new ObjectMapper();
private static LocalDB db = Baltoro.getDB();
private static boolean pullDone = false;
static
{
if(!runnig)
{
synchronized ("db-running".intern())
{
if(!runnig)
{
initReplicator();
runnig = true;
}
}
}
}
static void start()
{
}
public static String getSQL(PreparedStatement st)
{
EmbedPreparedStatement42 stmt = (EmbedPreparedStatement42) st;
ParameterValueSet params = stmt.getParms();
//ParameterValueSet sparams = params;
int quote, dblquote, question, current, length;
String thesql = stmt.getSQLText();
StringBuffer postsql = new StringBuffer();
String theparam = null;
int i = 0;
current = 0;
length = thesql.length();
while (current < length)
{
quote = thesql.indexOf("'", current);
dblquote = thesql.indexOf("\"", current);
question = thesql.indexOf("?", current);
if (quote == -1)
{
quote = length;
}
if (dblquote == -1)
{
dblquote = length;
}
if (question == -1)
{
question = length;
}
if ((question < quote) && (question < dblquote))
{
try
{
DataValueDescriptor ds = params.getParameter(i++);
String type = ds.getTypeName();
if(type.contains("INT"))
{
theparam = ds.getString();
}
else if(type.equals("BLOB"))
{
theparam = "NULL";
}
else
{
theparam = "'" + ds.getString() + "'";
}
//theparam = params.getParameter(i++).getString();
}
catch (StandardException se)
{
se.printStackTrace();
/* non-string parameter */
}
postsql.append(thesql.substring(current, question));
if (theparam == null)
{
postsql.append("null");
}
else
{
postsql.append(theparam);
}
current = question + 1;
}
else if (quote < dblquote)
{
quote = thesql.indexOf("'", quote + 1);
postsql.append(thesql.substring(current, quote + 1));
current = quote + 1;
}
else if (dblquote < length)
{
dblquote = thesql.indexOf("\"", dblquote + 1);
postsql.append(thesql.substring(current, dblquote + 1));
current = dblquote + 1;
}
else
{
postsql.append(thesql.substring(current, length));
current = length;
}
}
return postsql.toString();
}
public static void push(PreparedStatement st, String ... att)
{
if(Baltoro.env == Env.UT)
{
return;
}
String sql = getSQL(st);
ReplicationTO obj = new ReplicationTO();
obj.serverId = -1;
obj.cmd = sql;
obj.att = getAtt(sql, att);
pushQueue.add(obj);
}
public static void pushBatch(String sqls, String att)
{
if(Baltoro.env == Env.UT)
{
return;
}
ReplicationTO obj = new ReplicationTO();
obj.serverId = -1;
obj.cmd = sqls;
obj.att = att;
pushQueue.add(obj);
}
public static void push(String sql, String att)
{
if(Baltoro.env == Env.UT)
{
return;
}
ReplicationTO obj = new ReplicationTO();
obj.serverId = -1;
obj.att = att;
obj.cmd = sql;
pushQueue.add(obj);
}
public static ReplicationTO create(String sql, String ... att)
{
ReplicationTO to = new ReplicationTO();
to.serverId = -1;
to.att = getAtt(sql, att);
to.cmd = sql;
return to;
}
private static String getAtt(String sql, String ... att)
{
StringBuffer token = new StringBuffer();
if(sql.startsWith("insert into link_att") || sql.startsWith("delete from link_att") || sql.startsWith("updatde link_att"))
{
token.append("tab:LKAT");
}
else if(sql.startsWith("insert into link") || sql.startsWith("delete from link") || sql.startsWith("updatde link"))
{
token.append("tab:LINK");
}
else if(sql.startsWith("insert into base") || sql.startsWith("delete from base") || sql.startsWith("updatde base"))
{
token.append("tab:BASE");
}
else if(sql.startsWith("insert into version") || sql.startsWith("delete from version") || sql.startsWith("updatde version"))
{
token.append("tab:VERN");
}
else if(sql.startsWith("insert into metadata") || sql.startsWith("delete from metadata") || sql.startsWith("updatde metadata"))
{
token.append("tab:MTDT");
}
else if(sql.startsWith("insert into permission") || sql.startsWith("delete from permission") || sql.startsWith("updatde permission"))
{
token.append("tab:PERM");
}
else if(sql.startsWith("insert into content") || sql.startsWith("delete from content") || sql.startsWith("updatde content"))
{
token.append("tab:UPCT");
}
else if(sql.startsWith("insert into type") || sql.startsWith("delete from type") || sql.startsWith("updatde type"))
{
token.append("tab:TYPE");
}
//String sNames = Baltoro.serviceNames.toString().replaceAll(",", " ").toUpperCase();
String[] sNames = Baltoro.serviceNames.toString().split(",");
for (int i = 0; i < sNames.length; i++)
{
String sName = sNames[i].toUpperCase();
token.append(" service:"+sName+" ");
}
token.append(" ");
if(StringUtil.isNotNullAndNotEmpty(att))
{
for (int i = 0; i < att.length; i++)
{
if(att[i].length() == 4)
{
token.append("obj:"+att[i]+" ");
}
else
{
token.append(att[i]+" ");
}
}
}
return token.toString();
}
private static void initReplicator()
{
if(Baltoro.env == Env.UT)
{
return;
}
pusher = new Timer();
pusher.schedule(new TimerTask()
{
@Override
public void run()
{
try
{
if(!pullDone)
{
System.out.println("Replicator ====> waiting for pull to finish ....... wait 5 secs ");
Thread.sleep(5000);
return;
}
boolean hasMore = true;
List list = new ArrayList<>(100);
while(hasMore)
{
ReplicationTO obj = pushQueue.poll();
if(obj == null || list.size() > 100)
{
hasMore = false;
break;
}
else
{
list.add(obj);
}
}
if(list.size() > 0)
{
System.out.println("... pushing "+list.size()+" data ");
String json = mapper.writeValueAsString(list);
long initOn = db.startRepPush(list.size());
String _serverId = Baltoro.cs.pushReplication(json);
long serverId = Long.parseLong(_serverId);
db.updateRepPush(initOn, serverId);
System.out.println(" last push on ==> "+db.getLastPush());
}
}
catch (Exception e)
{
e.printStackTrace();
}
}
}, 1000, 1000);
puller = new Timer();
puller.schedule(new TimerTask()
{
@Override
public void run()
{
try
{
long lServerPushId = db.getLastPush();
long lServerPullId = db.getLastPull();
pullReplication(lServerPushId, lServerPullId);
}
catch (Exception e)
{
e.printStackTrace();
}
}
}, 1000, 1000);
}
private static long pullReplication(long lServerPushId, long lServerPullId) throws Exception
{
//System.out.println("current push ID ["+lServerPushId+"], pull ID ["+lServerPushId+"]");
ReplicationTO[] tos = Baltoro.cs.pullReplication(""+lServerPushId,""+lServerPullId);
if(StringUtil.isNullOrEmpty(tos))
{
if(!pullDone)
{
System.out.println("INIT PULL finished ....... ");
synchronized (Baltoro.PULL_REPLICATION_SYNC_KEY.intern())
{
Baltoro.PULL_REPLICATION_SYNC_KEY.notify();
}
}
pullDone = true;
return 0;
}
long milli = db.startRepPull();
System.out.println("current pull ID ["+lServerPullId+"] ===========> pulling replicated records receiving..... "+tos.length +" local rep uuid = "+milli);
long lastServerId = db.executeReplicationSQL(tos);
db.updateRepPull(milli, lastServerId, tos.length);
return tos.length;
}
}
class Repl
{
long initOn;
long compOn;
long serverId;
int sqlCount;
}
