Source Code for Module ioids.xmldb_infos

 1  """ 
 2  Some additional information for XML database. 
 3   
 4  Inter-Organisational Intrusion Detection System (IOIDS) 
 5   
 6  @author: Michael Pilgermann 
 7  @contact: mailto:mpilgerm@glam.ac.uk 
 8  @license: GPL (General Public License) 
 9  """ 
10   
11  ## 
12  ## In the XML RPC database, we have to provide the datatype for each column whenever 
13  ## we want to perfrom an insert. However, we cannot know about them a priori; consequently 
14  ## for each column in each table used, the datatype has to be defined here. Use the 
15  ## following syntax: 
16  ## 
17  ## DATATYPES['$TABLENAME.$COLUMN_NAME'] = '$DATATYPE_NAME' 
18  ## 
19  import soapsytools.xmldb_infos 
20  DATATYPES = soapsytools.xmldb_infos.DATATYPES 
21   
22  DATATYPES['ioids_event.ioids_event_id'] = 'bigserial' 
23  DATATYPES['ioids_event.classification_id'] = 'bigint' 
24  DATATYPES['ioids_event.ioids_sender_id'] = 'varchar(100)' 
25  DATATYPES['ioids_event.event_id'] = 'bigint' 
26  DATATYPES['ioids_event.timestamp_received'] = 'timestamp' 
27  DATATYPES['ioids_event.community_id'] = 'varchar(100)' 
28  DATATYPES['ioids_event.ioids_source_id'] = 'varchar(100)' 
29   
30  DATATYPES['ioids_peer.ioids_peer_id']  ='bigserial' 
31  DATATYPES['ioids_peer.peer_memberid']  ='varchar(100)' 
32   
33  DATATYPES['ioids_sender.ioids_sender_id'] = 'bigserial' 
34  DATATYPES['ioids_sender.ioids_peer_id'] = 'bigint' 
35   
36  DATATYPES['ioids_source.ioids_source_id'] = 'bigserial' 
37  DATATYPES['ioids_source.ioids_peer_id'] = 'bigint' 
38   
39  DATATYPES['ioids_classification.classification_id'] = 'bigint' 
40  DATATYPES['ioids_classification.classification_code'] = 'int' 
41  DATATYPES['ioids_classification.classification_name'] = 'text' 
42   
43  DATATYPES['ioids_relation.ioids_relation_id'] = 'bigserial' 
44  DATATYPES['ioids_relation.ioids_event_id'] = 'bigint' 
45  DATATYPES['ioids_relation.event_id'] = 'bigint' 
46  DATATYPES['ioids_relation.ioids_relation_type_id'] = 'bigint' 
47   
48  DATATYPES['ioids_relation_type.ioids_relation_type_id'] = 'bigserial' 
49  DATATYPES['ioids_relation_type.ioids_relation_type_name'] = 'text' 
50