| 312 | } |
| 313 | |
| 314 | function writeDatabase() { |
| 315 | console.log('\nWriting SQLite database...'); |
| 316 | |
| 317 | // Remove existing database |
| 318 | if (existsSync(DB_PATH)) { |
| 319 | unlinkSync(DB_PATH); |
| 320 | } |
| 321 | |
| 322 | const db = new Database(DB_PATH); |
| 323 | |
| 324 | // Create tables |
| 325 | db.exec(` |
| 326 | CREATE TABLE repos ( |
| 327 | id INTEGER PRIMARY KEY, |
| 328 | owner TEXT NOT NULL, |
| 329 | name TEXT NOT NULL, |
| 330 | full_name TEXT UNIQUE NOT NULL |
| 331 | ); |
| 332 | |
| 333 | CREATE TABLE users ( |
| 334 | id INTEGER PRIMARY KEY, |
| 335 | login TEXT UNIQUE NOT NULL, |
| 336 | issues_opened INTEGER DEFAULT 0, |
| 337 | prs_opened INTEGER DEFAULT 0, |
| 338 | comments_made INTEGER DEFAULT 0 |
| 339 | ); |
| 340 | |
| 341 | CREATE TABLE issues ( |
| 342 | id INTEGER PRIMARY KEY, |
| 343 | repo_id INTEGER NOT NULL, |
| 344 | number INTEGER NOT NULL, |
| 345 | title TEXT, |
| 346 | body TEXT, |
| 347 | state TEXT, |
| 348 | author TEXT, |
| 349 | labels_json TEXT, |
| 350 | created_at TEXT, |
| 351 | updated_at TEXT, |
| 352 | closed_at TEXT, |
| 353 | FOREIGN KEY (repo_id) REFERENCES repos(id), |
| 354 | UNIQUE(repo_id, number) |
| 355 | ); |
| 356 | |
| 357 | CREATE TABLE pulls ( |
| 358 | id INTEGER PRIMARY KEY, |
| 359 | repo_id INTEGER NOT NULL, |
| 360 | number INTEGER NOT NULL, |
| 361 | title TEXT, |
| 362 | body TEXT, |
| 363 | state TEXT, |
| 364 | author TEXT, |
| 365 | merged INTEGER DEFAULT 0, |
| 366 | merged_at TEXT, |
| 367 | created_at TEXT, |
| 368 | updated_at TEXT, |
| 369 | FOREIGN KEY (repo_id) REFERENCES repos(id), |
| 370 | UNIQUE(repo_id, number) |
| 371 | ); |