Menu ▾ ▴

[r16]: / trunk / src / ppg_insert.java  Maximize  Restore  History

Download this file

111 lines (68 with data), 4.0 kB 

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
//import de.svenjacobs.loremipsum.LoremIpsum;





public class ppg_insert {



	/**

	 * @param args

	 */

	public static void main(String[] args) {



		Integer qtd_sisic_avaliador = 45;

		Integer qtd_sisic_login = qtd_sisic_avaliador;

		

		Integer fk_user_id = 0;

		Integer fk_avaliador_id = 0;

		

		//LoremIpsum li = new LoremIpsum(); 



		

		MyDataAccess.open();

		

		

		MyTable sisic_avaliador = new MyTable("sisic_avaliador", qtd_sisic_avaliador);

		sisic_avaliador.addColumn("aval_codigo", new MyPKColumn() );

		sisic_avaliador.addColumn("aval_nome",  new MyColumn("varchar", 35) );

		sisic_avaliador.addColumn("aval_cpf",  new MyColumn("???????????") );

		sisic_avaliador.addColumn("aval_lattes",  new MyColumn("http://lattes.cnpq.br/????????") );

		sisic_avaliador.addColumn("aval_telefone_residencial",  new MyColumn("(71)????-????") );

		sisic_avaliador.addColumn("aval_telefone_comercial",  new MyColumn("(71)????-????") );

		sisic_avaliador.addColumn("aval_celular",  new MyColumn("(71)????-????") );

		sisic_avaliador.addColumn("aval_area_titulacao",  new MyColumn("varchar", 10) );

		sisic_avaliador.addColumn("aval_instituicao",  new MyColumn("varchar", 35) );

		sisic_avaliador.addColumn("aval_fk_titulacao",  new MyFKColumn("sisic_titulacao", "tit_codigo") );

		sisic_avaliador.addColumn("aval_ativo",  new MyColumn("int", null) );

		sisic_avaliador.addColumn("aval_fk_login",  new MyFKColumn("sisic_login", "login_codigo") );

		sisic_avaliador.addColumn("aval_maximo_projetos",  new MyColumn("int", null) );

		sisic_avaliador.addColumn("aval_projetos_atribuidos",  new MyColumn("int", null) );

		

		

		

		MyTable sisic_login = new MyTable("sisic_login", qtd_sisic_login);

		sisic_login.addColumn("login_codigo", new MyPKColumn() );

		sisic_login.addColumn("login_login",  new MyColumn("varchar", 150) );

		sisic_login.addColumn("login_senha",  new MyColumn("varchar", 50) );

		sisic_login.addColumn("login_nome",  new MyColumn("varchar", 150) );

		sisic_login.addColumn("login_email",  new MyColumn("user_????????@teste.com") );

		sisic_login.addColumn("login_data_cadastro",  new MyColumn("date", null) );

		//sisic_login.addColumn("login_data_ultimo_acesso",  new MyColumn("timestamp", null) );

		sisic_login.addColumn("login_fk_perfil",  new MyFKColumn("sisic_perfil", "perfil_codigo") );

		sisic_login.addColumn("login_ativo",  new MyColumn("int", null) );

		

/*



DELETE FROM sisic_avaliador;

DELETE FROM sisic_login WHERE login_login like "AVALIADOR_%";



SELECT * FROM sisic_login WHERE login_login like "AVALIADOR_%";

SELECT * FROM sisic_avaliador s;



*/

		

		for(int i = 0; i < qtd_sisic_avaliador; i++)

		{

		

			

			

			sisic_login.setCustomValue(true, "login_login",  MyRand.MasKedNumber("AVALIADOR_" + i));

			sisic_login.setCustomValue(false, "login_senha",  "MD5('teste')");

			sisic_login.setCustomValue(true, "login_ativo",  "1");

			sisic_login.setCustomValue(true, "login_fk_perfil",  "4"); //perfil do avaliador == 4;

			

			

			//System.out.println(sisic_login.generateInsert());

			fk_user_id = MyDataAccess.ExecuteInsert(sisic_login.generateInsert());

		

			

			sisic_avaliador.setCustomValue(true, "aval_fk_login", fk_user_id.toString());

			

			sisic_avaliador.setCustomValue(true, "aval_fk_titulacao",  MyRand.RandomInt(1, 3).toString());

			sisic_avaliador.setCustomValue(true, "aval_ativo",  "1" );

			

			String proj = MyRand.RandomInt(1, 3).toString();

			

			sisic_avaliador.setCustomValue(true, "aval_maximo_projetos", proj);

			sisic_avaliador.setCustomValue(true, "aval_projetos_atribuidos", proj);

			

			

			//System.out.println(sisic_avaliador.generateInsert());

			fk_avaliador_id = MyDataAccess.ExecuteInsert(sisic_avaliador.generateInsert());

			

			

			/*

			 * INSERT INTO sisic_professor_sub_area_conhecimento values

			 * */

			

			//System.out.println((i * 100 / qtd_sisic_avaliador)+"%");

			

		

		}

		

		System.out.println(("100%"));

		

		

		

		MyDataAccess.close();

		



	}



}