Implement support for getting and parsing blocks and transactions

2 files changed, 20 insertions, 0 deletions

diff --git a/packages/pipeline/src/entities/Block.ts b/packages/pipeline/src/entities/Block.ts
new file mode 100644
index 000000000..49e0ef840
--- /dev/null
+++ b/packages/pipeline/src/entities/Block.ts
@@ -0,0 +1,9 @@
+import { Column, Entity, PrimaryColumn } from 'typeorm';
+
+@Entity()
+export class Block {
+    @PrimaryColumn() public hash!: string;
+    @PrimaryColumn() public number!: number;
+
+    @Column() public unixTimestampSeconds!: number;
+}
diff --git a/packages/pipeline/src/entities/Transaction.ts b/packages/pipeline/src/entities/Transaction.ts
new file mode 100644
index 000000000..d89d44746
--- /dev/null
+++ b/packages/pipeline/src/entities/Transaction.ts
@@ -0,0 +1,11 @@
+import { Column, Entity, PrimaryColumn } from 'typeorm';
+
+@Entity()
+export class Transaction {
+    @PrimaryColumn() public transactionHash!: string;
+    @PrimaryColumn() public blockHash!: string;
+    @PrimaryColumn() public blockNumber!: number;
+
+    @Column() public gasUsed!: number;
+    @Column() public gasPrice!: number;
+}