.env file

dataframe['column_name'].value_counts().plot(kind='bar')
plt.show()

INSERTING ONE AND MANY
db.places.insertOne({})
db.places.insertMany({})

UPDATING - ONE AND MANY
db.places.updateOne({"country": "India"}, {$set: {"continent": "Europe"}})
db.places.updateMany({"country": "India"}, {$set: {"flag": "Updated Flag"}})

DELETING
db.places.deleteOne({"continent": "Africa"})
db.places.deleteMany({"continent": "Africa"})
db.places.findAndDelete({})

FINDING
db.students.find({"name":"Andy"})
db.students.find({"name":"Mike"})

FINDING using $OR and $IN
this will return entries that have hobbies of baseball OR MAC and Linux users
db.students.find( { $or: [ { "hobbies": { $in: ["Baseball"]}}. { "os" { $in: ["Mac", "Lin"]}}]})

also compatible with SOME regex expressions

SORTING:
db.animals.find().sort({weight: -1}); <== this is descending, a positive value is ascending

MYSQL
DB_NAME=
DB_PASSWORD=
DB_USER=root

MONGODB
Open Mongosh - copy string and add to:

-- config file notes

// Config is the only access of 'dotenv'

import dotenv from "dotenv";

dotenv.config();

export default {
  port: process.env.PORT || 3000,
  db: process.env.DB_CLIENT_URL,
};

npm install --legacy-peer-deps
npm cache clear --force

visitors = p.visitors.customers.where(tags: 'UNSUBSCRIBE 2021')
visitor_ids = visitors.pluck(:id);1

STATUSES_FOR_DELETION = [Automations::Trigger::Status::NOT_EXECUTED, Automations::Trigger::Status::RETRIGGERED].freeze
scheduled_steps = Automations::ScheduledStep.in(campaign_id: campaign_ids).in('triggers.visitor_id': visitor_ids)
scheduled_steps.map do |step|
  step.triggers.where(visitor: @visitor).in(status: STATUSES_FOR_DELETION).destroy_all
end

Mails::SingleEmail.where(project: p, sent_at: nil, processing: false).in(recipient_id: visitor_ids).destroy_all

Debug::MergeLog.where(project: p).in(legacy_visitor: visitor_ids).destroy_all

visitors.each.with_index do |visitor, index|
  visitor.events.destroy_all
  visitor.destroy

  puts index if index % 1000 == 0
end

{%- for block in section.blocks -%}
{%- assign product = all_products[block.settings.product] -%}
 <div class="img">{{ product.title }}</div>
{%- endfor -%}

<div id="section-{{ section.id }}">
  {%- for block in section.blocks -%}
    <ul>
      <li class="cate"> {{ block.settings.cate }} </li>
      <li class="date"> {{ block.settings.date }} </li>
      <li class="text"> {{ block.settings.text }} </li>
    </dl>
  {%- endfor -%}
</div>

{% schema %}
  {
    "name": "Top-topics",//セクション名
    "class": "top-topics",//セクションに自動で追加されるclass名
    "blocks": [// 画像や商品など数が増える可能性がある設定を記述する
      {
        "type": "text",
        "name": "Topic",//入力画面でのタイトル
        "limit": 5,
        "settings": [
          {
            "type": "select",
            "id": "cate",
            "label": "Category",
            "options": [
              {
                "value": "topics",
                "label": "Topics"
              },
              {
                "value": "news",
                "label": "News"
              }
            ],
            "default": "topics"
          },
          {
            "id": "date",
            "type": "text",
            "label": "日付を入力",
            "default": "2021.03.27"
          },
          {
            "id": "text",
            "type": "text",
            "label": "テキストを入力",
            "default": "テキストを入力"
          }
        ]
      }
    ],
    "presets":[
      {
        "category": "Text",//管理画面のセクション一覧のグループに表示される名前
        "name": "Top topics"
      }
    ]
  }
{% endschema %}

{% stylesheet %}

{% endstylesheet %}

{% javascript %}
{% endjavascript %}

Visitor.customers.each do |visitor|
  aggregated_customer = create_customer(visitor)
  puts aggregated_customer.email
  session = create_session(aggregated_customer, visitor.sessions.first)
  visitor.events.each do |event|
    create_event(aggregated_customer, event, session)
  end
end

def create_event(customer, event, session)
  case event.event_type
  when 'became_customer'
    create_became_customer(customer, session, event)
  when 'order'
    create_order(customer, session, event)
  when 'view_product'
    create_view_product(customer, session, event)
  when 'view_category'
    create_view_category(customer, session, event)
  when 'add_to_cart'
    create_add_to_cart(customer, session, event)
  when 'pageview'
    create_pageview(customer, session, event)
  when 'checkout_start'
    create_checkout_start(customer, session, event)
  when 'view_cart'
    create_custom_event(customer, session, event)
  end
end


AGGREGATED_CLASSES = {
  "became_customer" => Colander::Crm::Aggregated::Customers::BecameCustomer,
  "order" => Colander::Crm::Aggregated::Customers::Order,
  "view_product" => Colander::Crm::Aggregated::Customers::ViewProduct,
  "add_to_cart" => Colander::Crm::Aggregated::Customers::AddToCart,
  "view_cart" => Colander::Crm::Aggregated::Customers::Custom,
  "checkout_start" => Colander::Crm::Aggregated::Customers::CheckoutStart,
  "pageview" => Colander::Crm::Aggregated::Customers::Pageview,
  "view_category" => Colander::Crm::Aggregated::Customers::ViewCategory,
}

def find_or_init(event_type, customer)
  puts event_type
  AGGREGATED_CLASSES[event_type].find_or_initialize_by(
    email: customer.email,
    customer_id: customer.id,
    project: customer.project
  )
end

def create_order(customer, session, event)
  a_event = find_or_init(event.event_type, customer)
  a_event.timestamp = session.starts_at
  a_event.coupons |= event.params['coupons'] if event.params['coupons']
  a_event.shop_item_ids |= event.params['items'].map { |item| item['id'] }
  a_event.shop_order_ids = a_event.shop_order_ids << event.params['order_id']
  a_event.save!
end

def create_became_customer(customer, session, event)
  a_event = find_or_init(event.event_type, customer)
  a_event.timestamp = session.starts_at
  a_event.save!
end

def create_pageview(customer, session, event)
  a_event = find_or_init(event.event_type, customer)
  a_event.timestamp = session.starts_at
  a_event.save!
end

def create_add_to_cart(customer, session, event)
  a_event = find_or_init(event.event_type, customer)
  a_event.timestamp = session.starts_at
  a_event.shop_item_ids |= [event.params['id']]
  a_event.save!
end

def create_view_category(customer, session, event)
  a_event = find_or_init(event.event_type, customer)
  a_event.timestamp = session.starts_at
  a_event.shop_item_ids |= [event.params['id']]
  a_event.save!
end

def create_view_product(customer, session, event)
  a_event = find_or_init(event.event_type, customer)
  a_event.timestamp = session.starts_at
  a_event.shop_item_ids |= [event.params['id']]
  a_event.save!
end

def create_checkout_start(customer, session, event)
  a_event = find_or_init(event.event_type, customer)
  a_event.timestamp = session.starts_at
  a_event.save!
end

def create_custom_event(customer, session, event)
  a_event = find_or_init(event.event_type, customer)
  a_event.timestamp = session.starts_at
  a_event.names |= ['view_cart']
  a_event.save!
end

def create_session(customer, session)
  Colander::Crm::Session.create!(
    starts_at: session.created_at,
    expires_at: session.exp_at,
    origin: session.m['ref']['origin'],
    project: session.project,
    person: customer)
end

def create_customer(visitor)
  Colander::Crm::Aggregated::Customers::Customer.create!(
    email: visitor.email,
    timestamp: visitor.id.to_time,
    first_name: visitor.params['first_name'], 
    last_name: visitor.params['last_name'],
    project: visitor.project, 
    first_seen: visitor.first_seen,
    last_seen: visitor.last_seen,
    idents: visitor.ident,
    ip: visitor.ip,
    ip_country: visitor.m['geo']['country'],
    ip_city: visitor.m['geo']['city'],
    ip_region: visitor.m['geo']['region'],
    billing_country: visitor.params['country'],
    billing_city: visitor.params['city'],
    billing_region: visitor.params['region'],
    sessions_total: visitor.sessions_total,
    orders_total: visitor.orders_total,
    phone: visitor.params['phone'],
    postcode: visitor.params['postcode'],
    address: visitor.params['address'],
    subscribed: visitor.unsubscribed,
    tags: visitor.tags,
    last_feedback_score: visitor.last_cfs_score,
    revenue_total: visitor.revenue,
    last_order: visitor.last_order,
  )
end


Visitor.customers.each do |visitor|
  customer = Colander::Crm::Aggregated::Customers::Customer.where(email: visitor.email).first
  customer.update!(ip: visitor.ip, address: visitor.params['address'])
end

c1 = Colander::Crm::Aggregated::Customers::Customer.create(email: 'bumblebee@gega.com', first_name: 'Bumble', last_name: 'Bee', project: Project.first, timestamp: 2.days.ago)
cs1 = Colander::Crm::Session.create!(starts_at: 2.days.ago, expires_at: 2.days.ago + 1.hour, origin: 'test', project: c1.project, person: c1)
Colander::Crm::Aggregated::Customers::ViewProduct.create!(email: c1.email, customer_id: c1.id, project: c1.project, timestamp: cs1.starts_at, shop_item_ids: ['1708'])
Colander::Crm::Aggregated::Customers::AbandonedCart.create!(email: c1.email, customer_id: c1.id, project: c1.project, timestamp: cs1.starts_at + 1.minutes)
c1.update(orders_total:0, revenue_total: 0.0, ip_country: "USA", ip_city: 'Wildwood', ip_region: 'NJ', first_seen: cs2.starts_at, last_seen: cs1.starts_at + 1.minutes, tags: ['panda'], last_feedback_score: 1)


c2 = Colander::Crm::Aggregated::Customers::Customer.create(email: 'optimus@gega.com', project: Project.first, timestamp: 1.day.ago)
cs2 = Colander::Crm::Session.create!(starts_at: 1.day.ago, expires_at: 1.day.ago + 1.hour, origin: 'test', project: c2.project, person: c2)
Colander::Crm::Aggregated::Customers::Custom.create!(email: c2.email, customer_id: c2.id, project: c2.project, timestamp: cs2.starts_at, names: ['view_cart'])
Colander::Crm::Aggregated::Customers::ViewProduct.create!(email: c2.email, customer_id: c2.id, project: c2.project, timestamp: cs2.starts_at, shop_item_ids: ['13237', "1700", "10529"])
Colander::Crm::Aggregated::Customers::AddToCart.create!(email: c2.email, customer_id: c2.id, project: c2.project, timestamp: cs2.starts_at + 2.minutes, shop_item_ids: ['1700', "10529"])
Colander::Crm::Aggregated::Customers::CheckoutStart.create!(email: c2.email, customer_id: c2.id, project: c2.project, timestamp: cs2.starts_at + 3.minutes)
o2 = Colander::Crm::Aggregated::Customers::Order.create!(email: c2.email, customer_id: c2.id, project: c2.project, timestamp: cs2.starts_at + 5.minutes, shop_order_ids: ['2'], shop_item_ids: ['1700', "10529"], coupons: ['FRESH15', 'MYFREESHIPING'])
c2.update(orders_total:1, revenue_total: 100, ip_country: "USA", ip_city: 'Wildwood', ip_region: 'NJ', billing_country: 'USA', billing_city: 'Wildwood', billing_region: 'NJ', last_order: o2.timestamp, 
first_seen: cs2.starts_at, last_seen: o2.timestamp, tags: ['panda', 'rhino'], last_feedback_score: 10, sessions_total: 1)



c3 = Colander::Crm::Aggregated::Customers::Customer.create(email: 'voltron@gega.com', project: Project.first, timestamp: Time.now)
cs3 = Colander::Crm::Session.create!(starts_at: Time.now, expires_at: 1.hour.from_now, origin: 'test', project: c3.project, person: c3)
Colander::Crm::Aggregated::Customers::Custom.create!(email: c3.email, customer_id: c3.id, project: c3.project, timestamp: cs3.starts_at, names: ['view_cart'])
Colander::Crm::Aggregated::Customers::ViewProduct.create!(email: c3.email, customer_id: c3.id, project: c3.project, timestamp: cs3.starts_at, shop_item_ids: ['18110', "1700", "1774"])
Colander::Crm::Aggregated::Customers::AddToCart.create!(email: c3.email, customer_id: c3.id, project: c3.project, timestamp: cs3.starts_at + 2.minutes, shop_item_ids: ['18110', "1700"])
Colander::Crm::Aggregated::Customers::CheckoutStart.create!(email: c3.email, customer_id: c3.id, project: c3.project, timestamp: cs3.starts_at + 3.minutes)
o3 = Colander::Crm::Aggregated::Customers::Order.create!(email: c3.email, customer_id: c3.id, project: c3.project, timestamp: cs3.starts_at + 5.minutes, shop_order_ids: ['10'], shop_item_ids: ['18110', "1700"], coupons: ['FRESH15'])
c3.update(orders_total:1, revenue_total: 500, ip_country: "USA", ip_city: 'Atlantic City', ip_region: 'NJ', billing_country: 'USA', billing_city: 'Wildwood', billing_region: 'NJ', last_order: o3.timestamp, 
first_seen: cs3.starts_at, last_seen: o3.timestamp, tags: ['lion'], last_feedback_score: 5, sessions_total: 1)