DB_SCHEMA =  \
"""
CREATE TABLE IF NOT EXISTS
    events(
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            type TEXT,
            remarks TEXT,
            correspond TEXT
            )
"""

QUERY_INSERT_EVENT = \
"""
INSERT INTO events(type, remarks, correspond) VALUES (?,?,?)

"""

QUERY_COUNT_INTERACTION = \
"""
SELECT correspond, count(correspond)
  FROM events
 GROUP by correspond
"""


DB_SCHEMA_INT = \
"""
CREATE TABLE IF NOT EXISTS
    intimacy(
            correspond TEXT PRIMARY KEY,
			score INTEGER
            )

"""

QUERY_UPDATE_INT = \
"""
INSERT INTO intimacy(correspond,score)
  VALUES(?1, 0)
  ON CONFLICT(correspond) DO UPDATE SET
	score=score+1
  WHERE correspond=?2
"""

QUERY_GET_INT = \
"""
SELECT correspond, score FROM intimacy;
"""