Notes

function randNames(){
var names = "Al-Rashidia Al-Tahadi Al-Raiah Santarah Koorah Al-Ahli Al-Ruabi Al-khameis Al-Areda Al-Shabab Al-Ejazah Al-Zaher Al-Mojahdein Al-Sharaei Al-Awali Rokni Shababiat Makkah Al-Safira Al-Qadiseiah Al-Nassar Al-Hassani Al-Zawia Al-Rian Al-Ain Hadramoot Al-Moghamas King Abdullah Al-Baladiah Al-Malawi Al-Bahar Al-Hilal Al-Jamoum Al-Farouq Zamaan Umm Alqura Al-Wehda Al-Etifaq Al-Zohoor Al-Salam";
var names = "ali ammar saud turki khalid maher yazeed yaser ahmad mazen omar majed hasan amjad saleh naif ziyad fisal malek muhamad alaa amir anmar hashim jasim jssar ibrahim";
names = names.split(" ");
var rlt = [];
while(rlt.length < 2){
rlt.push(names[Math.floor(Math.random() * names.length)])
}
return rlt.join(" ");
}
function randPhone(){
var rlt = "05";
var isp = "45638";
rlt += isp[Math.floor(Math.random()*isp.length)];
while(rlt.length < 10){
rlt += Math.floor(Math.random()*10);
}
console.log(rlt.length)
return rlt;
}
function randnameC(){
var names = "Al-Rashidia Al-Tahadi Al-Raiah Santarah Koorah Al-Ahli Al-Ruabi Al-khameis Al-Areda Al-Shabab Al-Ejazah Al-Zaher Al-Mojahdein Al-Sharaei Al-Awali Rokni Shababiat Makkah Al-Safira Al-Qadiseiah Al-Nassar Al-Hassani Al-Zawia Al-Rian Al-Ain Hadramoot Al-Moghamas King Abdullah Al-Baladiah Al-Malawi Al-Bahar Al-Hilal Al-Jamoum Al-Farouq Zamaan Umm Alqura Al-Wehda Al-Etifaq Al-Zohoor Al-Salam";
names = names.split(" ");
var rlt = [];
while(rlt.length < 1){
rlt.push(names[Math.floor(Math.random() * names.length)])
}
return rlt.join(" ");
}
function randEmail(){
var dict = "abcdefghijk0lmn1opqrst2uvw3xyz_4ABC5DE6FG7HIJ8KL9MNOPQRSTUVWXYZ"
var rlt = "";
var range = Math.ceil(Math.random()*5) + 6;
while(rlt.length < range){
rlt += dict[Math.floor(Math.random()*dict.length)];
}
rlt += '@';
var isp = ['hotmail','gmail','yahoo'];
rlt += isp[Math.floor(Math.random()*isp.length)];
rlt += '.com';
return rlt;
}
function randIBAN(){
var rlt = "SA";
while(rlt.length < 24){
rlt += Math.floor(Math.random()*10);
}
return rlt;
}
function rand(x){
return x[Math.floor(Math.random()*x.length)]
}
function grtC(x){
var rlt = "";
var names = "Al-Rashidia Al-Tahadi Al-Raiah Santarah Koorah Al-Ahli Al-Ruabi Al-khameis Al-Areda Al-Shabab Al-Ejazah Al-Zaher Al-Mojahdein Al-Sharaei Al-Awali Rokni Shababiat Makkah Al-Safira Al-Qadiseiah Al-Nassar Al-Hassani Al-Zawia Al-Rian Al-Ain Hadramoot Al-Moghamas King Abdullah Al-Baladiah Al-Malawi Al-Bahar Al-Hilal Al-Jamoum Al-Farouq Zamaan Umm Alqura Al-Wehda Al-Etifaq Al-Zohoor Al-Salam";
names = names.split(" ");
for(var i = 1;i <x+1;i++){
//insert into courts values
rlt += "into courts values (" + i + ",'"+names[i-1]+"','"+rand('SML')+"','"+rand(['football','basketball','vollyball'])+"',"+(Math.floor(Math.random()*70)+100)+",'"+rand(['makkah','riyadh','jeddah','taif','madinah']) + "')n";
}
return rlt;
}
function grtU(x){
var rlt = "";
var agee,credit;
for(var i = 1;i<x+1;i++){
credit = (Math.floor(Math.random()*500)+20);
agee = (Math.floor(Math.random()*17)+15);
//insert into user_ values
rlt += " into user_ values (" + i + ",'" + randNames() + "','" + randEmail() + "','" + randPhone() + "'," + agee + ",'" + randIBAN() + "'," + credit + ")n";
}
return rlt;
}
function randDate(x){
rlt = [];
var cd = new Date();
var nd = new Date(2019,07,10,10);
var a = [];
var bool ;
var i = 0;
while(i < x){
bool = false;
m = (Math.ceil(Math.random()*12))
d = (Math.ceil(Math.random()*26))
h = (Math.ceil(Math.random()*24))

if(typeof a[m] != "undefined"){
if(typeof a[m][d] != "undefined"){
if(typeof a[m][d][h] == "undefined"){
bool = true;
}
}else{
bool = true;
}
}else{
bool = true;
}
if(bool){
if(d < 10){
d = "0" + d;
}
if(m < 10){
m = "0" + m;
}
if(h < 10){
h = "0" + h;
}
rlt.push([d +"\"+ m +"\"+ "19",h]);
i++;
}

}
return rlt;
}
function grtR(x){
var rlt = "";
var dates = randDate(x+1);
for(var i = 0;i<x+1;i++){
rlt += "into res values (" + (Math.ceil(Math.random()*50)) + "," + (Math.ceil(Math.random()*42)) + ", TO_DATE('"+dates[i][0]+"', 'DD/MM/YY') ,'" + dates[i][1] + "')n"
}
return rlt;
}