summaryrefslogtreecommitdiff
path: root/orkbasej/java/net/sf/oreka/test/FillDatabase.java
blob: 0b0596cddf6e0ab14c9b299f13c502f4f744e4d0 (plain)
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
111
112
113
114
115
116
117
118
119
120
/*
 * Oreka -- A media capture and retrieval platform
 * 
 * Copyright (C) 2005, orecx LLC
 *
 * http://www.orecx.com
 *
 * This program is free software, distributed under the terms of
 * the GNU General Public License.
 * Please refer to http://www.gnu.org/copyleft/gpl.html
 *
 */

package net.sf.oreka.test;

import java.util.Date;

import net.sf.oreka.Direction;
import net.sf.oreka.HibernateManager;
import net.sf.oreka.persistent.LoginString;
import net.sf.oreka.persistent.RecProgram;
import net.sf.oreka.persistent.RecSegment;
import net.sf.oreka.persistent.RecTape;
import net.sf.oreka.persistent.Service;
import net.sf.oreka.persistent.User;

import org.hibernate.Session;
import org.hibernate.Transaction;

public class FillDatabase {

	static HibernateManager hibernateManager = HibernateManager.instance();
	
	public static void main(String args[]) throws Exception
	{
		hibernateManager.configure("c:/oreka/test/mysql.hbm.xml");
		
		Session hbnSession = hibernateManager.getSession();
		Transaction tx = hbnSession.beginTransaction();
		
		Service service = new Service();
		service.setFileServePath("");
		service.setFileServeProtocol("http");
		service.setFileServeTcpPort(8080);
		service.setHostname("localhost");
		service.setRecordMaster(true);
		service.setName("orkaudio1");
		hbnSession.save(service);
		
		User user = new User();
		user.setFirstname("salisse");
		LoginString ls = new LoginString();
		ls.setUser(user);
		ls.setLoginString("1973");
		hbnSession.save(user);
		hbnSession.save(ls);
		
		// create program that does not filter anything
		RecProgram prog1 = new RecProgram();
		hbnSession.save(prog1);
		
		// Create a bunch of segments
		String lastParty = "123-234-5678";
		java.util.Random generator = new java.util.Random();
		for(int i=0; i<500; i++) {
			RecSegment seg = new RecSegment();
			RecTape tape = new RecTape();
			
			tape.setService(service);
			tape.setFilename("f1.mp3");
			
			Date date = new Date(new Date().getTime() - 600000 +(i*1000));
			seg.setTimestamp(date);
			tape.setTimestamp(date);
			
			String randomString = "" + generator.nextInt();
			randomString = randomString.replace("-", "a");
			seg.setLocalParty(randomString);
			seg.setRemoteParty(lastParty);
			lastParty = randomString;
			
			float randomDirection = generator.nextFloat();
			if(randomDirection > .5){
				seg.setDirection(Direction.IN);
			}
			else {
				seg.setDirection(Direction.OUT);				
			}
			
			long duration = (long)(generator.nextFloat()*60.0);
			seg.setDuration(duration);
			tape.setDuration(duration+1);
			
			seg.setRecTape(tape);
			hbnSession.save(tape);
			hbnSession.save(seg);
		}
		
//		StringBuffer queryString = new StringBuffer("from RecSegment as seg ");
//		Query query = hbnSession.createQuery(queryString.toString());
//		
//		ScrollableResults scrollDocs = query.scroll();		
//		scrollDocs.first();
//		
//		while (scrollDocs.get()!= null)
//		{
//			RecSegment seg = (RecSegment)scrollDocs.get(0);
//			//RecTape tape = (RecTape)scrollDocs.get(1);
//			//RecTape tape = new RecTape();
//			System.out.println(seg.getId());
//			scrollDocs.next();
//		}
		
		tx.commit();
		hbnSession.close();
		
		System.out.println("Done");
	}
	
}