// 111111.cpp : Defines the entry point for the console application
#include "stdafx.h"
#include<iostream>
#include<iomanip>
#include<stdlib.h>
#include<ctime>
#include<fstream>
#include<conio.h>

using std::ofstream;

using std::endl;
using std::cout;
using std::cerr;
using std::ios;
using std::cin;

int main()
{   int row,i,k,N,u,q;
	

	cout<<"*****************Programa poiska optimalnogo indexa************\n";

	cout<<"		Vuberete odin iz pynktov:\n";
	cout<<"1)Sozdat bazy danyh;\n";
	cout<<"2)Vuhod iz programy.\n";
	cin>>k;

	if(k=1) {// !!!!!!!!!!!!!!!!!

		//Создание файла sort.sql в текстовом формате для печати
		
		ofstream basePrintFile("sort.sql", ios::out);
		if(!basePrintFile){
		cerr<<"Nevozmojno otkrit' file"<<endl;
		exit(1);
				}
		cout<<"*********Baza danyh nazyvaetsa sort.sql*********\n";
		cout<<"		Vuberete odin iz pynktov:\n";
		cout<<"1)Sozdat tablicy v bazy danyh;\n";
		cout<<"2)Vuhod iz programy.\n";
		cin>>u;
		
		if(u=1) {
		cout<<"Vvedite kolichestvo strok bazy danyh:";
		cin>>N;
		cout<<"Vvedite kolichestvo stolbsov:";
		cin>>row;

	//Создание файла populate.sql в текстовом формате для печати
	ofstream insertPrintFile("populate.sql", ios::out);
	if(!insertPrintFile){
		cerr<<"Nevozmojno otkrit' file"<<endl;
		exit(1);
		}
		
	cout<<"********Tablica sohranena v faile populate.sql********\n ";


int **r = new int *[N];
for(int i = 0; i < N; i++)
r[i] = new int [row];

	srand(time(0));
	basePrintFile<<"create database sort_a;"<<'\n'
		<<"use sort_a;"<<'\n'
		<<"create table data"<<'\n'
		<<"("<<'\n';
		//<<"id int unsigned not null auto_increment primary key,"<<'\n'
		for(int i=0;i<row;i++)
		{   basePrintFile<<"number"<<i<<" int(11) not null"<<",\n";
		     
		}
		basePrintFile<<");"<<'\n';

		cout<<"		Vuberete odin iz pynktov:\n";
		cout<<"1)Sgenerirovat danye bez index;\n";
		cout<<"2)Sgenerirovat danye s index;\n";
		cout<<"3)Sgenerirovat danye s parnymi index;\n";
		cin>>q;

		if(q=1) {
			for (int i=0; i<N; i++)
{	
	 insertPrintFile<<"INSERT INTO data VALUES (";
	for(int j=0;j<row;j++)
	{
				r[i][j]=rand()%N;
			if(j==row-1)
				insertPrintFile<<r[i][j];
			else
				insertPrintFile<<r[i][j]<<",";
	}
insertPrintFile<<");\n";

		}
		}
			if(q=2) {

				for (int i=0; i<N; i++)
{	
	 insertPrintFile<<"INSERT INTO data VALUES (";
	insertPrintFile<<i<<",";
	for(int j=0;j<row;j++)
	{
		
				r[i][j]=rand()%N;
			if(j==row-1)
				insertPrintFile<<r[i][j];
			else
				insertPrintFile<<r[i][j]<<",";
	}
	
	
insertPrintFile<<");\n";

		}
			}

			else {

    insertPrintFile<<"USE sort_a;"<<'\n';
for (int i=0; i<N; i++)
{	
	if (i%2)
	{
		insertPrintFile<<"INSERT INTO data (number_1,number_2,number_3,number_4,number_5) VALUES (";
		for(int j=0;j<row;j++)
	{
		
				r[i][j]=rand()%N;
			if(j==row-1)
				insertPrintFile<<r[i][j];
			else
				insertPrintFile<<r[i][j]<<",";
			
	}
	
	
insertPrintFile<<");\n";

	}

	else {

	 insertPrintFile<<"INSERT INTO data VALUES (";
	insertPrintFile<<i<<",";
	for(int j=0;j<row;j++)
	{
		
				r[i][j]=rand()%N;
			if(j==row-1)
				insertPrintFile<<r[i][j];
			else
				insertPrintFile<<r[i][j]<<",";
	}
	
	
insertPrintFile<<");\n";

		}
	}  

	}
			cout<<"*******Danye sgenerirovany v faile populate.sql********\n";
	_getch();

}
	
	else  {
		cout<<"vvvv";
        return 0;
	}
	// !!!!!!!!!!!!!!!!!
        }
	else {
		cout<<"bbb";
		return 0;
	}// !!!!!!!!!!!!!!!!!
	

}