Skip to content

Instantly share code, notes, and snippets.

Michael mazz

Block or report user

Report or block mazz

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View ValueObservation.swift
let databasePool: DatabasePool = self.userService.rawDatabasePool()
let coursesObservation = ValueObservation.tracking { db -> [MbyCourse] in
var courses: [MbyCourse] = []
do {
let mbyCourses = try MbyCourse
.filter(Column("orgUuid") == self.orgUuid.value) // also tried removing this filter line
.filter(Column("archived") == false) // also tried removing this filter line
.fetchAll(db)
courses = mbyCourses
View deploy.log
Attaching to faithfulword-phx_proxy_1, faithfulword-phx_postgres_1, faithfulword-phx_faithful_word_1
proxy_1 | time="2019-10-09T02:19:28Z" level=info msg="Traefik version v1.7.18 built on 2019-09-26_01:56:30PM"
proxy_1 | time="2019-10-09T02:19:28Z" level=info msg="\nStats collection is disabled.\nHelp us improve Traefik by turning this feature on :)\nMore details on: https://docs.traefik.io/v1.7/basics/#collected-data\n"
proxy_1 | time="2019-10-09T02:19:29Z" level=info msg="Preparing server http &{Address::80 TLS:<nil> Redirect:<nil> Auth:<nil> WhitelistSourceRange:[] WhiteList:<nil> Compress:false ProxyProtocol:<nil> ForwardedHeaders:0xc0009500e0} with readTimeout=0s writeTimeout=0s idleTimeout=3m0s"
proxy_1 | time="2019-10-09T02:19:29Z" level=info msg="Preparing server https &{Address::443 TLS:0xc0004b4480 Redirect:<nil> Auth:<nil> WhitelistSourceRange:[] WhiteList:<nil> Compress:false ProxyProtocol:<nil> ForwardedHeaders:0xc0009501a0} with readTimeout=0s writeTimeout=0s
View snippet.swift
public func fetchCourses() -> Single<[MbyCourse]> {
return Single.create { [unowned self] single in
do {
var fetchCourses: [MbyCourse] = []
// let chapters: [Org]!
try self.dbPool.read { db in
fetchCourses = try MbyCourse.fetchAll(db)
}
single(.success(fetchCourses))
} catch {
View Playlist.swift
import Foundation
import GRDB
public struct Playlist: Codable {
var uuid: String
public var channelUuid: String
public var bannerPath: String?
public var localizedname: String
public var languageId: String
public var mediaCategory: String
View Dockerfile
# docker build -t olivetree:builder --target=builder .
FROM elixir:1.8.1-alpine as builder
RUN apk add --no-cache \
gcc \
git \
make \
musl-dev
RUN mix local.rebar --force && \
mix local.hex --force
WORKDIR /app
View iex.log
iex(2)> import Ecto.Query
Ecto.Query
iex(3)> Video |> select([v], v.id)
#Ecto.Query<from v0 in DB.Schema.Video, select: v0.id>
iex(4)> Video |> select([v], v.id) |> DB.Repo.all()
[debug] QUERY OK source="videos" db=1.9ms decode=2.6ms queue=6.5ms
SELECT v0."id" FROM "videos" AS v0 []
[1]
iex(5)> Video |> select([v], v.id) |> DB.Repo.all() |> Enum.map(&Video.changeset_generate_hash_id/1)
[debug] QUERY OK source="videos" db=0.3ms
View config.exs
...
config :my_app_api, MyAppApi.Endpoint,
url: [host: "api.%%%%.app"],
secret_key_base: "%%%%",
render_errors: [view: MyAppApi.ErrorView, accepts: ~w(html json)],
pubsub: [name: MyAppApi.PubSub, adapter: Phoenix.PubSub.PG2],
live_view: [signing_salt: "%%%%"]
...
View compile_error.ex
# ** (Ecto.Query.CompileError) Tuples can only be used in comparisons with literal tuples of the same size
def search(query_string, offset \\ 0, limit \\ 0,
media_category,
playlist_uuid,
channel_uuid,
published_after
) do
conditions = false
@mazz
mazz / query.ex
Created Apr 23, 2019
line 18 and line 19 assignment does not impact outer scope established on line 1 and line 2
View query.ex
direction = :asc
sorting = :track_number
# direction = :desc
# sorting = :presented_at
media_category = Ecto.Query.from(playlist in Playlist,
where: playlist.uuid == ^playlist_uuid,
select: playlist.media_category)
|> Repo.one
|> IO.inspect
@mazz
mazz / ecto_postgres_fulltext_search_querying_example.ex
Created Apr 16, 2019 — forked from pmarreck/ecto_postgres_fulltext_search_querying_example.ex
How to set up postgres fulltext search triggers, index, and tsvector column on Elixir/Phoenix, with Ecto querying, including ranking and sorting by rank
View ecto_postgres_fulltext_search_querying_example.ex
defmodule YourAppName.Search do
# ...
@doc """
Queries listings.
"""
def query_listings(query, current_user) do
default_scope = from l in Listing, where: l.draft == false or l.user_id == ^current_user.id, order_by: [desc: l.updated_at], limit: 50
id = _try_integer(query)
You can’t perform that action at this time.