Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Jun 17th, 2012  |  syntax: None  |  size: 2.49 KB  |  hits: 19  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. ________________________
  2. XML Schema
  3.  
  4.   1 <?xml version="1.0"?>
  5.   2 <database>
  6.   3     <table name="bootstrap" comment="This table is only intended to ever have one record">                                                                                                                    
  7.   4         <field name="schemaVersion" type="REAL" />
  8.   5         <field name="dbSchema" type="VARCHAR(1048576)" comment="1 MB of text" />
  9.   6     </table>
  10.   7     <table name="Symbol">
  11.   8         <field name="Type"              type="SMALLINT" />
  12.   9         <field name="SymbolSpace"       type="INTEGER" />
  13.  10     </table>
  14.  11     <table name="PrimitiveSymbolToContent">
  15.  12         <field name="SymbolID"          type="INTEGER" ref_target="Symbol(SymbolID)" />
  16.  13         <field name="Content"           type="VARCHAR(1024)" />
  17.  14     </table>
  18.  15     <table name="SymbolComposition">
  19.  16         <field name="CompositeSymbolID" type="INTEGER" ref_target="Symbol(SymbolID)" />
  20.  17         <field name="ComponentID"       type="INTEGER" ref_target="Symbol(SymbolID)" />
  21.  18     </table>
  22.  19     <table name="Memory">
  23.  20         <field name="Starttime"         type="timestamp" />
  24.  21         <field name="Duration"          type="timestamp" />
  25.  22     </table>
  26.  23     <table name="MemoryFrame">
  27.  24         <field name="MemoryID"          type="INTEGER" ref_target="Memory(MemoryID)" />
  28.  25         <field name="SequenceIndex"     type="INTEGER" />
  29.  26         <field name="TimeOffset"        type="INTERVAL" />
  30.  27     </table>
  31.  28     <table name="MemorySymbol">
  32.  29         <field name="MemoryFrameID"     type="INTEGER" ref_target="MemoryFrame(MemoryFrameID)" />
  33.  30         <field name="SymbolID"          type="INTEGER" ref_target="Symbol(SymbolID)" />
  34.  31         <field name="Activation"        type="REAL" />
  35.  32     </table>
  36.  33     <table name="Recommendation">
  37.  34         <field name="RecommenderID"     type="INTEGER" ref_target="Symbol(SymbolID)" />
  38.  35         <field name="RecommendeeID"     type="INTEGER" ref_target="Symbol(SymbolID)" />
  39.  36         <field name="Probability"       type="REAL" />
  40.  37     </table>
  41.  38 </database>
  42.  
  43. ___________________
  44.  
  45. 153     dbRdr = DBEntryReader('Symbol')
  46. 154     dbRdr.FilterByType([0,2])
  47. 155     dbRdr.FilterBySymbolID([1,2,3])
  48. 156     dbRdr.Execute()
  49. 157     while dbRdr.Read():
  50. 158         print('SymbolID', dbRdr.SymbolID)
  51. 159         print('Type', dbRdr.Type)
  52. 160         print('SymbolSpace', dbRdr.SymbolSpace)
  53. 161     dbRdr.Close()
create a new version of this paste RAW Paste Data