Clustering/schema.lua at master · mksteve/Clustering · GitHub

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
return
{
    Tables = {
       "CREATE TABLE IF NOT EXISTS TwitterMain      ( ID INTEGER PRIMARY KEY AUTOINCREMENT, username TEXT, tweetid TEXT );",
       "CREATE TABLE IF NOT EXISTS TwitterWords     ( ID INTEGER, word TEXT );",
       "CREATE TABLE IF NOT EXISTS TwitterWordPairs ( ID INTEGER, word TEXT );",
       "CREATE TABLE IF NOT EXISTS TwitterHashTags  ( ID INTEGER, word TEXT );",
       "CREATE TABLE IF NOT EXISTS TwitterRefers    ( ID INTEGER, word TEXT );",
       "CREATE TABLE IF NOT EXISTS TwitterText      ( ID INTEGER, data TEXT );",


       "CREATE TABLE IF NOT EXISTS TwitterWords_Size     ( ID INTEGER, count INTEGER);",
       "CREATE TABLE IF NOT EXISTS TwitterWordPairs_Size     ( ID INTEGER, count INTEGER);",
       "CREATE TABLE IF NOT EXISTS TwitterHashTags_Size    ( ID INTEGER, count INTEGER );",
       "CREATE TABLE IF NOT EXISTS TwitterRefers_Size    ( ID INTEGER, count INTEGER );",

    },
    Indices = {
       "CREATE INDEX IF NOT EXISTS IdxTwitterWords_id_text ON TwitterWords( ID, word );",
       "CREATE INDEX IF NOT EXISTS IdxTwitterWordPairss_id_text ON TwitterWordPairs( ID, word );",
       "CREATE INDEX IF NOT EXISTS IdxTwitterHashTags_id_text ON TwitterHashTags( ID, word );",
       "CREATE INDEX IF NOT EXISTS IdxTwitterRefers_id_text ON TwitterRefers( ID, word );",
       "CREATE INDEX IF NOT EXISTS IdxTwitterText_id  ON   TwitterText ( ID );",

       "CREATE INDEX IF NOT EXISTS IdxTwitterWords_Size    ON TwitterWords_Size( ID );",
       "CREATE INDEX IF NOT EXISTS IdxTwitterWordPairs_Size    ON TwitterWordPairs_Size( ID );",
       "CREATE INDEX IF NOT EXISTS IdxTwitterHashTags_Size ON TwitterHashTags_Size( ID );",
       "CREATE INDEX IF NOT EXISTS IdxTwitterRefers_Size   ON TwitterRefers_Size( ID );",
    },
    DropIndices = {
       "DROP INDEX IF EXISTS IdxTwitterWords_id_text ON TwitterWords( ID, word );",
       "DROP INDEX IF EXISTS IdxTwitterWordPairss_id_text ON TwitterWordPairs( ID, word );",
       "DROP INDEX IF EXISTS IdxTwitterHashTags_id_text ON TwitterHashTags( ID, word );",
       "DROP INDEX IF EXISTS IdxTwitterRefers_id_text ON TwitterRefers( ID, word );",

       "DROP INDEX IF EXISTS IdxTwitterWords_Size    ON TwitterWords_Size( ID );",
       "DROP INDEX IF EXISTS IdxTwitterWordPairs_Size    ON TwitterWordPairs_Size( ID );",
       "DROP INDEX IF EXISTS IdxTwitterHashTags_Size ON TwitterHashTags_Size( ID );",
       "DROP INDEX IF EXISTS IdxTwitterRefers_Size   ON TwitterRefers_Size( ID );",
    },
    Order = {
       "Identity",
       "Words",
       "Text",
       "WordPairs",
       "HashTags",
       "Refers",
    },
    Identity = {
        Table = "TwitterMain",
        Type  = "Main",
        SQLInsert   = "INSERT INTO TwitterMain (username, tweetid ) VALUES ( ?,? );",
        Fields = {
            "username",
            "tweetid",
        },
    },
    Text = {
        Table = "TwitterText",
        SQLInsert       = "INSERT INTO TwitterText ( ID,  data) VALUES ( ?,? );",
        DoSize = true,
        Type  = "Table",
        Fields = {
            "$IDX",
            "Text",
         },
    },

    Words = {
        Table = "TwitterWords",
        SQLInsert       = "INSERT INTO TwitterWords ( ID, word) VALUES ( ?,? );",
        DoSize = true,
        Type  = "Array",
        Part  = "Words",
        Fields = {
            "$IDX",
            "$VALUE",
         },
    },
    WordPairs = {
        Table = "TwitterWordPairs",
        SQLInsert       = "INSERT INTO TwitterWordPairs ( ID, word) VALUES ( ?,? );",
        DoSize = true,
        Type  = "Array",
        Part  = "WordPairs",
        Fields = {
            "$IDX",
            "$VALUE",
         },
    },
    HashTags = {
        Table = "TwitterHashTags",
        SQLInsert       = "INSERT INTO TwitterHashTags ( ID, word) VALUES ( ?,? );",
        DoSize = true,
        Type  = "Array",
        Part  = "HashTags",
        Fields = {
            "$IDX",
            "$VALUE",
         },
    },
    Refers = {
        Table = "TwitterRefers",
        SQLInsert       = "INSERT INTO TwitterRefers ( ID, word) VALUES ( ?,? );",
        DoSize = true,
        Type  = "Array",
        Part  = "Refers",
        Fields = {
            "$IDX",
            "$VALUE",
         },
    },
}