static void Main(string[] args)
{
var parser = new Parser();
using (var fs = File.OpenRead("complicated.sasm"))
using (var sr = new StreamReader(fs))
while (!sr.EndOfStream)
{
parser.ParseLine(sr.ReadLine());
}
var modules = ModuleBuilder.CreateFrom(parser.GetCode());
IEnumerable <IBlock> blocks = null;
var email = Ask("What is your email address?");
var password = Ask("What is your password?");
var worldid = Ask("What is the World ID?");
int worldWidth, worldHeight;
var bot = PlayerIO.QuickConnect.SimpleConnect("everybody-edits-su9rn58o40itdbnw69plyw", email, password, null)
.ApplyFluency() //make the client fluent
.Multiplayer
.CreateJoinRoom(worldid, "Everybodyedits237", false, null, null)
.OnDisconnect((c, i, e) => {
if (i)
{
c.Reconnect().Send("init");
}
})
.On("init", (c, e) => {
e.Get(18, out worldWidth)
.Get(19, out worldHeight);
blocks = modules.BuildWorld(worldWidth, worldHeight);
c.Send("init2");
})
.On("init2", (c, e) => {
var timedQuery = new QueryExecutioner <IBlock>();
timedQuery.ProcessQueryItem += (i) => {
var arguments = i.GetEEArgs(0, 0);
c.Send("b", arguments);
Thread.Sleep(10);
};
foreach (var i in blocks)
{
timedQuery.AddQueryItem(i);
}
})
.Send("init");
Console.ReadLine();
}
public void RightJoinTest()
{
Database DB = new Database(@"C:\Users\Moataz\Workspace\Software\Database Architect\Active Code\DatabaseArchitect\Southwind\Database.db.txt");
DB.Read();
foreach (Table T in DB.Tables)
{
T.ReadRecords();
}
Query Q = new Query("SELECT * FROM Projects RIGHT JOIN Grades ON GradeID=ID;");
QueryScanner QS = new QueryScanner(Q);
Q = QS.Scan();
QueryParser QP = new QueryParser(Q);
QueryTree QT = QP.Reorder();
QueryExecutioner QE = new QueryExecutioner(QT, DB, null);
Table Ti = QE.ExecuteQuery();
}
public void SELECT1()
{
Database DB = new Database(@"C:\Users\Moataz\Workspace\Software\Database Architect\Active Code\DatabaseArchitect\Southwind\Database.db.txt");
DB.Read();
foreach (Table T in DB.Tables)
{
T.ReadRecords();
}
Query Q = new Query("SELECT Rating,Name,Rating FROM Projects WHERE Rating=90 or Name=\"Software Architect\" or Name=\"DatabaseArchitect\";");
QueryScanner QS = new QueryScanner(Q);
Q = QS.Scan();
QueryParser QP = new QueryParser(Q);
QueryTree QT = QP.Reorder();
QueryExecutioner QE = new QueryExecutioner(QT, DB, null);
Table Ti = QE.ExecuteQuery();
}
static object ProcessQuery(Request Qr)
{
if (!(Qr.Attachment is string))
{
return("Invalid Query");
}
string Qs = Qr.Attachment as string;
Query Q = new Query(Qs);
try
{
QueryScanner QS = new QueryScanner(Q);
Q = QS.Scan();
QueryParser QP = new QueryParser(Q);
QueryTree Qt = QP.Reorder();
QueryExecutioner Qexec = new QueryExecutioner(Qt, Server.Database, ServerReaders.ReadRecords);
Table Ti = Qexec.ExecuteQuery();
if (Qexec.AfterEffect[0])
{
Server.Database.Write();
}
if (Qexec.AfterEffect[1])
{
Qexec.Tables.Last().Write();
}
if (Qexec.AfterEffect[2])
{
Qexec.Tables.Last().WriteRecords();
}
if (Ti == null)
{
return(Qexec.Result);
}
return(Ti);
}
catch (Exception Ex)
{
return(Ex.Message);
}
}
public void UpdateTest()
{
Database DB = new Database(@"C:\Users\Moataz\Workspace\Software\Database Architect\Active Code\DatabaseArchitect\Southwind\Database.db.txt");
DB.Read();
foreach (Table T in DB.Tables)
{
T.ReadRecords();
}
Query Q = new Query("UPDATE Projects SET ID=1, Name=\"Database Architect\", Rating=100 WHERE ID=1;");
QueryScanner QS = new QueryScanner(Q);
Q = QS.Scan();
QueryParser QP = new QueryParser(Q);
QueryTree QT = QP.Reorder();
QueryExecutioner QE = new QueryExecutioner(QT, DB, null);
QE.ExecuteQuery();
}
public Room()
{
this._players = new PlayerManager <TPlayer>();
this._query = new QueryExecutioner <RoomItem <TPlayer> >();
this._query.ProcessQueryItem += this.ProcessQuery;
}
