mhsharifi96

Quereis (0-100)

لیست پرداخت

select count(*) from payment

مقدار فروش هر کارمند

select staff_id,sum(amount) as total_amount from payment 

mhsharifi96

DATABASE

what is schema?

Schema is a collection of logical structures of data. In PostgreSQL, schema is a named collection of tables, views, functions, constraints, indexes,sequences etc.

---

Create Database

mhsharifi96

import asyncio
import time

async def sample():
    start_time = time.time()
    print('start')
    await asyncio.sleep(1)
    await asyncio.sleep(2)
    print('after 2s sleep on sample ')
    await asyncio.sleep(1)

mhsharifi96

class ListNode:
   def __init__(self, val=0, next = None):
      self.next = next
      self.val = val

class Solution:
     def isPalindrome(self, head:ListNode) -> bool:
        fast = head
        slow = head
        #find middle

mhsharifi96

!Additive Model Lingo Code 
	write by Mohammad hossein sharifi 
	Aug 2020;
model:
sets:
dmu/1..10/:l;
input/1..4/:si;
output/1..3/:sr;
link1(input,dmu):x;
link2(output,dmu):y;

mhsharifi96

! BCC model OutPut Oriented Lingo Code;
! write by mohammad hossein 
	sharifi Aug 2020;

model:
sets:
dmu/1..10/;  !10 dmu;
input/1..4/:v; !4 input; 
output/1..3/:u; !3 output ;
link(input,dmu):x; !xij 4*10;

mhsharifi96

! BCC model input Oriented lingo code ;
!write by mohammad hossein sharifi Aug 2020; 


model:
sets:
dmu/1..10/;  !10 dmu;
input/1..4/:v; !4 input; 
output/1..3/:u; !3 output ;
link(input,dmu):x; !xij 10*4;

mhsharifi96

model :
sets:
Cinput/1..2/:i;
Coutput/1/:r;
dmu/1..10/:j;
Winput/1..2/:v;
Woutput/1/:u;
link(Cinput,dmu):x;
link1(Coutput,dmu):y;
endsets

mhsharifi96

//https://www.npmjs.com/package/ffmetadata#metadata
//sometimes you need change metadata in mp3 automatically
var ffmetadata = require("ffmetadata");

function ChangeMetaMp3(filename){
    data = {
        album: "RovzeNews.ir",
        
        copyright: "RovzeNews.ir - tel/insta : @rovzenews_ir"
    }

mhsharifi96

    #!/usr/bin/python3.5
class tape:
    def __init__(self,Sum,p):
        self.sum_a=Sum
        self.p=p
    def SUM(self):
        Min=Sum
        for i in range(p):
            sum_left=sum(a[:i])
            sum_right=Sum-sum_left