with Minerstat and Neon Postgres?
Emit new event when a new column is added to a table. See the documentation
Emit new event when a row is added or modified. See the documentation
Emit new event when a new row is added to a table. See the documentation
Emit new event when new rows are returned from a custom query that you provide. See the documentation
Emit new event when a new table is added to the database. See the documentation
Finds a row in a table via a lookup column. See the documentation
Finds a row in a table via a custom query. See the documentation
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
minerstat: {
type: "app",
app: "minerstat",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://api.minerstat.com/v2/worker`,
headers: {
Authorization: `Bearer ${this.minerstat.$auth.api_token}`,
"Accept": `application/json`,
},
params: {
name: `Apollo`,
},
})
},
})
import { axios } from "@pipedream/platform";
import { neon } from "@neondatabase/serverless";
export default defineComponent({
props: {
neon_postgres: {
type: "app",
app: "neon_postgres",
}
},
async run({ steps, $ }) {
const { host, port, user, password, database } = this.neon_postgres.$auth
const connectionString = `postgresql://${user}:${password}@${host}:${port}/${database}`
const sql = neon(connectionString)
const result = await sql`SELECT version()`
const { version } = result[0]
return version
},
})