wwnbb’s gists

wwnbb / upload_and_sumbit.py

Created November 7, 2023 08:21

upload_and_sumbit.py

	from typing import List
	from fastapi import FastAPI, UploadFile, File, Form
	from uuid import uuid4

	app = FastAPI()

	# Simulate a database for storing file references
	file_db = {}

	@app.post("/upload-files/")

wwnbb / find_cycles.sql

Created October 19, 2023 15:36

How to find cycles in parent <- child relationships.

	WITH RECURSIVE recursive_search AS (
	SELECT
	uuid,
	ARRAY[uuid] AS path,
	false AS cycle_found
	FROM some_table
	WHERE parent_uuid IS NOT NULL
	UNION ALL
	SELECT
	d.uuid,

wwnbb / many_to_many_example.py

Created September 5, 2023 07:22

This gist show how to use many to many relationships in async sqlalchemy v2

	import asyncio
	from sqlalchemy import Column, Integer, String, Table, ForeignKey, select
	from sqlalchemy.ext.asyncio import create_async_engine
	from sqlalchemy.orm import relationship
	from sqlalchemy.orm import joinedload
	from sqlalchemy.orm import declarative_base
	from sqlalchemy.ext.asyncio import async_sessionmaker

	Base = declarative_base()

wwnbb / error.log

Last active August 4, 2023 09:30

Example: how to create many to many relatinships using sqlalchemy

	FROM (SELECT users.id AS users_id
	FROM users
	WHERE users.id = $1::INTEGER) AS anon_1 JOIN user_group AS user_group_1 ON anon_1.users_id = user_group_1.user_id JOIN groups ON groups.id = user_group_1.group_id
	2023-08-04 13:29:46,430 INFO sqlalchemy.engine.Engine [generated in 0.00010s] (31,)
	2023-08-04 13:29:46,432 INFO sqlalchemy.engine.Engine ROLLBACK
	Traceback (most recent call last):
	File "/Users/admin/work/py/async_sqlalchemy/main.py", line 134, in <module>
	main()
	File "/Users/admin/work/py/async_sqlalchemy/main.py", line 130, in main
	asyncio.run(amain())

wwnbb / main.py

Created November 8, 2020 23:30 — forked from sirex/main.py

sqlalchemy joins with AS

	import sqlalchemy as sa
	import sqlparse

	metadata = sa.MetaData()

	tasks = sa.Table(
	'tasks', metadata,
	sa.Column('id', sa.Integer, primary_key=True),
	sa.Column('bot', sa.String(255), nullable=False),
	sa.Column('task', sa.String(255), nullable=False),

wwnbb / controller_dir.coffee

Created October 30, 2017 15:07

	class MyController
	@$inject: ['$scope']
	@hello: "ЗДРАСТЕ"

	constructor: ($scope) ->
	$scope.hello = 124
	@hello = "234"
	console.log($scope.hello)

	# insert services in constructor (services) ->

wwnbb / xinitrc

Created October 18, 2017 05:58

wwnbb / gist:634f807327f507fcf23e9e5802b1a89c

Created August 27, 2017 11:04

wwnbb / auth.js

Created January 23, 2015 11:27

	'use strict';


	angular.module('auth')

	.directive('authApplication', function($http, localStorageService, User) {
	return {
	restrict: 'A',
	scope: false,
	link: function (scope, elem, attrs) {

wwnbb / gist:c8773d18c40b113a0682

Created January 23, 2015 11:22

	'use strict';


	angular.module('auth')

	.directive('authApplication', function($http, localStorageService, User) {
	return {
	restrict: 'A',
	scope: false,
	link: function (scope, elem, attrs) {

wwnbb wwnbb