'Import CSV file (convert to JSON format) into Deta Base (database)

I try to convert the CSV file into JSON format and import it into Deta Base (database). Here is a main.py code I run from a terminal. No error shows up, but Deta Base (database) is empty not even created. Any suggestion on what is wrong with my Python script?

import csv
from deta import Deta

# Initialize with a Project Key
deta = Deta("HERE-IS-DETA-ID")

# Path to CSV file
csvFilePath = r"data.csv"

# This how to connect to or create a database
db = deta.Base("simple_db_testing")


# Create and use DB
someone = deta.Base("somewhere")

# Define conversion from CSV to JSON
def csv_to_json(csvFilePath):
    jsonArray = []
      
    # Read csv file
    with open(csvFilePath, encoding='utf-8') as csvf: 
        # Load csv file data using csv library's dictionary reader
        csvReader = csv.DictReader(csvf) 
        print(csvReader)
        # Convert each csv row into python dict
        for row in csvReader: 
            # Add this python dict to json array
            jsonArray.append(row)
            print(jsonArray)
            # Inser JsonArray into DB named "someone"
            for each in jsonArray:
                someone.put(each)


Solution 1:[1]

import csv
from deta import Deta

# Initialize with a Project Key
deta = Deta("HERE-IS-DETA-ID")

# Path to CSV file
csvFilePath = r"data.csv"

# This how to connect to or create a database
db = deta.Base("simple_db_testing")


# Create and use DB
someone = deta.Base("somewhere")

# Define conversion from CSV to JSON
def csv_to_json(csvFilePath):
    # Read csv file
    with open(csvFilePath, encoding='utf-8') as csvf: 
        # Load csv file data using csv library's dictionary reader
        csvReader = csv.DictReader(csvf)
        # Convert each csv row into python dict
        for row in csvReader:
            # Insert object into DB named "someone"
            someone.put(row)

Solution 2:[2]

It was a missing calling function at the end of the script.

import csv
from deta import Deta

# Initialize with a Project Key
deta = Deta("HERE-IS-DETA-ID")

# Path to CSV file
csvFilePath = r"data2.csv"

# Create and use DB - this database is being used
someone = deta.Base("somewhere2")

# Define conversion from CSV to JSON
def csv_to_json(csvFilePath):
    # Read csv file
    with open(csvFilePath, encoding='utf-8') as csvf: 
        # Load csv file data using csv library's dictionary reader
        csvReader = csv.DictReader(csvf)
        # Convert each csv row into python dict
        for row in csvReader:
            # Insert object into DB named "someone"
            someone.put(row)
            # Print rows inserted into DB
            print(row)
#need to call the function
csv_to_json(csvFilePath)

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 cofob
Solution 2 ku2ck4