noelrappin

# syntax=docker/dockerfile:1
FROM ruby:3.1.2
RUN apt-get update -qq && apt-get install -y sqlite3
WORKDIR /myapp
COPY Gemfile /myapp/Gemfile
COPY Gemfile.lock /myapp/Gemfile.lock
RUN bundle install

# Add a script to be executed every time the container starts.
COPY entrypoint.sh /usr/bin/

chriswhong

The absolute easiest way to get a CSV into a postgresql table is to use ogr2ogr with AUTODETECT_TYPE=YES.

I learned a while back that this is what cartoDB uses to import your CSV into postgis (with a lot of other parameters added)

ogr2ogr -f PostgreSQL PG:"host=localhost user=postgres dbname=postgres password=password"  docs.csv -oo AUTODETECT_TYPE=YES

coco98

import requests

#Fetch existing tables
tables = requests.post('http://localhost:8080/v1/query', json={
    "type":"select",
    "args":{
        "table": {"schema": "information_schema", "name": "tables"}, 
        "columns": ["table_name"], 
        "where": {"table_schema": {"$eq": "public"}}
    }

odlp

require "bundler/inline"

gemfile do
  gem "rspec"
end

require "rspec/autorun"

RSpec.describe "inline Bundler and autorun RSpec" do
  it "is convenient for self-contained examples & bug repros" do