Revision 56483
Added by Antonis Lempesis almost 5 years ago
IrusStats.java | ||
---|---|---|
69 | 69 |
String sqlCreateTableSushiLog = "CREATE TABLE IF NOT EXISTS sushilog(source TEXT, repository TEXT, rid TEXT, date TEXT, metric_type TEXT, count INT, PRIMARY KEY(source, repository, rid, date, metric_type));"; |
70 | 70 |
stmt.executeUpdate(sqlCreateTableSushiLog); |
71 | 71 |
|
72 |
stmt.executeUpdate("CREATE TABLE IF NOT EXISTS public.sushilog AS TABLE sushilog;");
|
|
72 |
stmt.executeUpdate("CREATE TABLE IF NOT EXISTS public.sushilog(source TEXT, repository TEXT, rid TEXT, date TEXT, metric_type TEXT, count INT, PRIMARY KEY(source, repository, rid, date, metric_type));");
|
|
73 | 73 |
|
74 | 74 |
String sqlCopyPublicSushiLog="INSERT INTO sushilog SELECT * FROM public.sushilog;"; |
75 | 75 |
stmt.executeUpdate(sqlCopyPublicSushiLog); |
Also available in: Unified diff
Minor bug fixes