aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--api/api.proto10
-rw-r--r--db/db.go20
2 files changed, 29 insertions, 1 deletions
diff --git a/api/api.proto b/api/api.proto
index 2c6c20d..796e34b 100644
--- a/api/api.proto
+++ b/api/api.proto
@@ -7,6 +7,14 @@ message PingMessage {
string greeting = 1;
}
+message Item {
+ int32 id = 1
+ string field = 2;
+ string field2 = 3;
+ google.protobuf.Timestamp created = 5;
+ google.protobuf.Timestamp last_updated = 5;
+}
+
service Ping {
rpc SayHello(PingMessage) returns (PingMessage) {
option (google.api.http) = {
@@ -14,4 +22,4 @@ service Ping {
body: "*"
};
}
-} \ No newline at end of file
+}
diff --git a/db/db.go b/db/db.go
new file mode 100644
index 0000000..c1a06a0
--- /dev/null
+++ b/db/db.go
@@ -0,0 +1,20 @@
+package db
+
+import (
+ "database/sql"
+ "fmt"
+ _ "github.com/lib/pq"
+ "log"
+)
+
+func createDBHandle(user, pass, addr, table string) (*DB, error) {
+ return sql.Open("postgres", fmt.Sprintf("postgres://%s:%s@%s/%s", user, pass, addr, table))
+}
+
+func GetDBHandle(user, pass, addr, table string) (*DB, error) {
+ return createDBHandle(user, pass, addr, table)
+}
+
+func (*sql.DB) GetItem() interface{} {
+
+}