devernote/devernote.install at master · akempler/devernote · 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
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
<?php
/**
 * @file
 * Provides installation functions.
 */

/**
 * Implements hook_schema().
 */
function devernote_schema() {

  $schema['devernote_notes'] = array(
    'description' => 'Relationship of evernote note id to drupal node nid.',
    'fields' => array(
      'note_guid' => array(
        'description' => 'The unique guid of the evernote note.',
        'type' => 'varchar',
        'length' => '250',
        'not null' => TRUE,
        'default' => '0',
      ),
      'nid' => array(
        'description' => 'The {node}.nid of the node created from the note.',
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => '0',
      ),
      'uid' => array(
        'description' => 'The {users}.uid of the user creating the note.',
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => '0',
      ),
    ),
    'primary key' => array('note_guid'),
    'indexes' => array(
      'note_guid' => array('note_guid'),
      'nid' => array('nid'),
    ),
  );

  $schema['devernote_user'] = array(
    'description' => 'User specific data.',
    'fields' => array(
      'uid' => array(
        'description' => 'The {users}.uid of the user creating the note.',
        'type' => 'int',
        'not null' => TRUE,
        'default' => 0,
      ),
      'oauth_token' => array(
        'description' => 'The oauth token provided by evernote.',
        'type' => 'varchar',
        'length' => '250',
        'not null' => TRUE,
        'default' => '0',
      ),
      'notestoreurl' => array(
        'description' => 'The notestoreurl provided by evernote.',
        'type' => 'varchar',
        'length' => '250',
        'not null' => TRUE,
        'default' => '',
      ),
      'expires' => array(
        'description' => 'Unix timestamp for when the oauth_token expires.',
        'type' => 'int',
        'not null' => TRUE,
        'default' => 0,
      ),
      'updates' => array(
        'description' => 'The number of evernote updates for the user.',
        'type' => 'int',
        'not null' => TRUE,
        'default' => 0,
      ),
      'tag' => array(
        'description' => 'The Evernote tag used for flagging imports.',
        'type' => 'varchar',
        'length' => '50',
        'not null' => TRUE,
        'default' => '',
      ),
      'tag_guid' => array(
        'description' => 'guid of the Evernote tag used for flagging imports.',
        'type' => 'varchar',
        'length' => '250',
        'not null' => TRUE,
        'default' => '0',
      ),
      'secret_key' => array(
        'description' => 'Secret key provided by Evernote to access api.',
        'type' => 'varchar',
        'length' => '250',
        'not null' => TRUE,
        'default' => 0,
      ),
      'consumer_key' => array(
        'description' => 'Consumer key provided by Evernote to access api.',
        'type' => 'varchar',
        'length' => '250',
        'not null' => TRUE,
        'default' => 0,
      ),
    ),
    'primary key' => array('uid'),
    'indexes' => array(
      'uid' => array('uid'),
    ),
  );

  return $schema;
}

/**
 * New columns in {devernote_user} : secret_key, consumer_key
 */
function devernote_update_7000() {

  $spec = array(
    'description' => 'Secret key provided by Evernote to access api.',
    'type' => 'varchar',
    'length' => '250',
    'not null' => TRUE,
    'default' => 0,
  );
  db_add_field( 'devernote_user', 'secret_key', $spec);

  $spec = array(
    'description' => 'Consumer key provided by Evernote to access api.',
    'type' => 'varchar',
    'length' => '250',
    'not null' => TRUE,
    'default' => 0,
  );
  db_add_field( 'devernote_user', 'consumer_key', $spec);

  variable_del('devernote_consumer_key');
  variable_del('devernote_secret_key');

  drupal_set_message('Please tell all users to re-enter their consumer and secret keys.', 'warning');
}


/**
 * Implements hook_uninstall().
 */
function devernote_uninstall() {

  variable_del('devernote_enc_method');
  variable_del('devernote_nodestatus');
  variable_del('devernote_nodepromoted');
  variable_del('devernote_nodecomments');
  variable_del('devernote_inputformat');
  variable_del('devernote_imagestyle');
  variable_del('devernote_div2p');
  variable_del('devernote_convertheadings');
}