Prediction

Model

muqtadar08/finetuned_gemma_sql_generator:3b5f9fda

4a9jahe17srg80cf08ybwmjggg

Status

Succeeded

Source

Web

Hardware

Total duration

51.0s

Created

over 1 year ago by muqtadar08

Webhook

–

Input

question: find the price of laptop
ddl_doc: CREATE TABLE products ( product_id INT, product_name VARCHAR(100), category VARCHAR(50), price DECIMAL(10, 2), stock_quantity INT ); INSERT INTO products (product_id, product_name, category, price, stock_quantity) VALUES (1, 'Smartphone', 'Electronics', 599.99, 100), (2, 'Laptop', 'Electronics', 999.99, 50), (3, 'Headphones', 'Electronics', 99.99, 200), (4, 'T-shirt', 'Apparel', 19.99, 300), (5, 'Jeans', 'Apparel', 49.99, 150);

{
  "ddl_doc": "CREATE TABLE products (\n    product_id INT,\n    product_name VARCHAR(100),\n    category VARCHAR(50),\n    price DECIMAL(10, 2),\n    stock_quantity INT\n);\n\nINSERT INTO products (product_id, product_name, category, price, stock_quantity)\nVALUES\n    (1, 'Smartphone', 'Electronics', 599.99, 100),\n    (2, 'Laptop', 'Electronics', 999.99, 50),\n    (3, 'Headphones', 'Electronics', 99.99, 200),\n    (4, 'T-shirt', 'Apparel', 19.99, 300),\n    (5, 'Jeans', 'Apparel', 49.99, 150);",
  "question": "find the price of laptop"
}

Install Replicate’s Node.js client library:

npm install replicate

Set the REPLICATE_API_TOKEN environment variable:

export REPLICATE_API_TOKEN=r8_Lxj**********************************

This is your API token. Keep it to yourself.

Import and set up the client:

import Replicate from "replicate";

const replicate = new Replicate({
  auth: process.env.REPLICATE_API_TOKEN,
});

Run muqtadar08/finetuned_gemma_sql_generator using Replicate’s API. Check out the model's schema for an overview of inputs and outputs.

const output = await replicate.run(
  "muqtadar08/finetuned_gemma_sql_generator:3b5f9fda888ca684c347536ba9fc01a7cfc60a83ae30f39c220dd072289df0ec",
  {
    input: {
      ddl_doc: "CREATE TABLE products (\n    product_id INT,\n    product_name VARCHAR(100),\n    category VARCHAR(50),\n    price DECIMAL(10, 2),\n    stock_quantity INT\n);\n\nINSERT INTO products (product_id, product_name, category, price, stock_quantity)\nVALUES\n    (1, 'Smartphone', 'Electronics', 599.99, 100),\n    (2, 'Laptop', 'Electronics', 999.99, 50),\n    (3, 'Headphones', 'Electronics', 99.99, 200),\n    (4, 'T-shirt', 'Apparel', 19.99, 300),\n    (5, 'Jeans', 'Apparel', 49.99, 150);",
      question: "find the price of laptop"
    }
  }
);

console.log(output);

To learn more, take a look at the guide on getting started with Node.js.

Install Replicate’s Python client library:

pip install replicate

Set the REPLICATE_API_TOKEN environment variable:

export REPLICATE_API_TOKEN=r8_Lxj**********************************

This is your API token. Keep it to yourself.

Import the client:

import replicate

Run muqtadar08/finetuned_gemma_sql_generator using Replicate’s API. Check out the model's schema for an overview of inputs and outputs.

output = replicate.run(
    "muqtadar08/finetuned_gemma_sql_generator:3b5f9fda888ca684c347536ba9fc01a7cfc60a83ae30f39c220dd072289df0ec",
    input={
        "ddl_doc": "CREATE TABLE products (\n    product_id INT,\n    product_name VARCHAR(100),\n    category VARCHAR(50),\n    price DECIMAL(10, 2),\n    stock_quantity INT\n);\n\nINSERT INTO products (product_id, product_name, category, price, stock_quantity)\nVALUES\n    (1, 'Smartphone', 'Electronics', 599.99, 100),\n    (2, 'Laptop', 'Electronics', 999.99, 50),\n    (3, 'Headphones', 'Electronics', 99.99, 200),\n    (4, 'T-shirt', 'Apparel', 19.99, 300),\n    (5, 'Jeans', 'Apparel', 49.99, 150);",
        "question": "find the price of laptop"
    }
)

print(output)

To learn more, take a look at the guide on getting started with Python.

Set the REPLICATE_API_TOKEN environment variable:

export REPLICATE_API_TOKEN=r8_Lxj**********************************

This is your API token. Keep it to yourself.

Run muqtadar08/finetuned_gemma_sql_generator using Replicate’s API. Check out the model's schema for an overview of inputs and outputs.

curl -s -X POST \
  -H "Authorization: Bearer $REPLICATE_API_TOKEN" \
  -H "Content-Type: application/json" \
  -H "Prefer: wait" \
  -d $'{
    "version": "muqtadar08/finetuned_gemma_sql_generator:3b5f9fda888ca684c347536ba9fc01a7cfc60a83ae30f39c220dd072289df0ec",
    "input": {
      "ddl_doc": "CREATE TABLE products (\\n    product_id INT,\\n    product_name VARCHAR(100),\\n    category VARCHAR(50),\\n    price DECIMAL(10, 2),\\n    stock_quantity INT\\n);\\n\\nINSERT INTO products (product_id, product_name, category, price, stock_quantity)\\nVALUES\\n    (1, \'Smartphone\', \'Electronics\', 599.99, 100),\\n    (2, \'Laptop\', \'Electronics\', 999.99, 50),\\n    (3, \'Headphones\', \'Electronics\', 99.99, 200),\\n    (4, \'T-shirt\', \'Apparel\', 19.99, 300),\\n    (5, \'Jeans\', \'Apparel\', 49.99, 150);",
      "question": "find the price of laptop"
    }
  }' \
  https://api.replicate.com/v1/predictions

To learn more, take a look at Replicate’s HTTP API reference docs.

Output

SELECT price FROM products WHERE category = 'Electronics' AND product_name = 'Laptop';

Generated in

51.0 seconds

Tweak it Report