Skip to content

Instantly share code, notes, and snippets.

from sqlalchemy import create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, String, ForeignKey
from sqlalchemy.orm import sessionmaker
engine = create_engine('sqlite:///')
Session = sessionmaker(bind=engine)
sess = Session()
Base = declarative_base()
from sqlalchemy import create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, String, ForeignKey
from sqlalchemy.orm import sessionmaker
# engine = create_engine('sqlite:///')
engine = create_engine('sqlite:///')
Session = sessionmaker(bind=engine)
sess = Session()
Base = declarative_base()
from sqlalchemy import create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, String, ForeignKey
from sqlalchemy.orm import sessionmaker
# engine = create_engine('sqlite:///')
engine = create_engine('sqlite:///example_1_fk_check.db')
Session = sessionmaker(bind=engine)
sess = Session()
Base = declarative_base()
В SQLite порядок и отсутствуие ключе не важны В PG все иначе. Работает только если мы:
1. ссылаемся на существующие ключи
2. порядок добавления правильный. в начале добавляем adr1 потом user1
from sqlalchemy import create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, String, ForeignKey
from sqlalchemy.orm import sessionmaker
from sqlalchemy_utils import database_exists, create_database
@bubnenkoff
bubnenkoff / gist:6a51ebd1e14b864d45fe33c4cb40edc4
Created April 5, 2018 09:07
Пример модели для SQLAlchemy в SQLite ограничение на ForeignKey по умолчанию не работает, в PG все норм.
from sqlalchemy import create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, String, ForeignKey
from sqlalchemy.orm import sessionmaker
from sqlalchemy_utils import database_exists, create_database
engine = create_engine('sqlite:///')
engine = create_engine('sqlite:///example_1_fk_check.db')
# engine = create_engine("postgres://postgres@localhost/mydb_3")
@bubnenkoff
bubnenkoff / gist:7a7d8076572672a4edd423a6c3194170
Created April 5, 2018 13:32
Миграция от Антона
def upgrade(migrate_engine):
# Upgrade operations go here. Don't create your own engine; bind
# migrate_engine to your metadata
metadata = MetaData(bind=migrate_engine)
user = Table('user', metadata,
Column('user_id', Integer, primary_key=True),
Column('user_name', String(16), nullable=False),
Column('email_address', String(60), key='email'),
Column('password', String(20), nullable=False)
print('-----------')
print('Extracting data from client_id:', client_id) # перенесем сюда дял наглядности, чтобы выводом других ф-ций не ломать вывод
# Проинформируем о том в какиих случаях у нас нет данных
if not dict_list_1:
print('NO DATA for case: ', 'vrb_payout')
f = None
send_email(f, config, name_and_email[1])
else:
print('[GOOD] DATA for case: ', 'vrb_payout')
f = write_reestr_as_csv(client_id, dict_list_1, 'vrb_payout')
import std.stdio;
import std.file;
import std.path;
import std.algorithm;
string folder = r"C:\temp2\contracts";
void main()
{
string [] dublicates_list;
@bubnenkoff
bubnenkoff / app.py
Created March 12, 2019 12:14
parser
import os
# модуль для работы с ftp
import ftplib
from pathlib import Path
# модуль для работы с zip архивами
from zipfile import *
# Библиотека для работы с Oracle
import cx_Oracle
import datetime as dt
import time
import 'dart:convert';
import 'package:flutter/material.dart';
import 'package:flutter/widgets.dart';
import 'package:http/http.dart' as http;
import 'select_regions.dart';
import 'dart:convert';
import 'package:provider/provider.dart';
void main() => runApp(MyApp());