Louis-Rene Hache lrhache

## export-mssql-csv.ps1
set-alias installutil $env:windir\microsoft.net\framework\v2.0.50727\installutil
installutil -i "C:\Program Files\Microsoft SQL Server\100\Tools\Binn\Redist\Microsoft.SqlServer.Management.PSProvider.dll"
installutil -i "C:\Program Files\Microsoft SQL Server\100\Tools\Binn\Redist\Microsoft.SqlServer.Management.PSSnapins.dll"


Add-PSSnapin SqlServerCmdletSnapin100
Add-PSSnapin SqlServerProviderSnapin100

$SERVER_NAME="<SERVER NAME>"; $DB_NAME="<DB NAME>";$Tables = invoke-sqlcmd -query "SELECT name FROM sys.tables order by name" -database $DB_NAME -serverinstance $SERVER_NAME;foreach ($Table in $Tables){$TableName = $Table["name"];write-host -ForegroundColor Green "Creating File $TableName.csv";invoke-sqlcmd -query "SELECT * FROM $TableName" -database $DB_NAME -serverinstance $SERVER_NAME |export-csv -path D:\dump\$TableName.csv;}

## python-selenium-open-tab.md

      
              1 file
            
          
              29 forks
            
          
              41 comments
            
          
              136 stars
            
          
                lrhache
                / python-selenium-open-tab.md
            
            
              Last active
              June 10, 2023 13:49
            
              
                Python Selenium - Open new tab / focus tab / close tab
              
          
    On a recent project, I ran into an issue with Python Selenium webdriver. There's no easy way to open a new tab, grab whatever you need and return to original window opener.
Here's a couple people who ran into the same complication:

http://stackoverflow.com/questions/17547473/how-to-open-a-new-tab-using-selenium-webdriver
http://stackoverflow.com/questions/6421988/webdriver-open-new-tab/9122450#9122450
https://groups.google.com/forum/#!topic/selenium-users/kah4iEPRopc
... and many many more.

So, after many minutes (read about an hour) of searching, I decided to do find a quick solution to this problem.

  
## heroku-set-configs-from-file.md

      
              1 file
            
          
              0 forks
            
          
              5 comments
            
          
              4 stars
            
          
                lrhache
                / heroku-set-configs-from-file.md
            
            
              Created
              December 11, 2013 15:21
            
              
                Easy way to batch set Heroku config from a file. No one wants to do this manually(!?).
              
          
    #Heroku set configs from files


Export your configs from Heroku in "shell" format to file:
$ heroku config -a <app_name> -s > .env-<environment_name(production, staging, ...)>


Copy this script to a file


## bitweekdays.py

weekdays = ('Monday', 'Tuesday', 'Wednesday',
            'Thursday', 'Friday', 'Saturday', 'Sunday', )

def convert_choice(*args):
    """Convert weekdays representation to 127 bits

    Example:
        >> # Monday, Tuesday, Friday, Sunday
        >> bw.convert(1, 1, 0, 0, 1, 0, 1)

## list_unique_benchmark.py
"""Benchmark multiple method of removing duplicates in a list
    while keeping item's order in the list.

    numpy.unique will likely be faster and more efficient
    the more the list grows.
    If a list is submitted to numpy.unique, it will be transformed and flattened
    into a numpy.Array which it's data structure is more efficient than standard
    lists since all elements have the same size in memory therefor requires less
    access to the memory. Lists are stored as array of adresses pointing to
    to the objects and requires more memory access (but more flexible).

## models.py
from collections import defaultdict
from typing import Type, cast, Callable, TypeVar, Any
from functools import wraps

T = TypeVar('T')


def wrap_setattr(definition: dict, fn: Callable) -> Callable:
    @wraps(fn)
    def wrapped(self, attr, value):

## sleep.js
function sleep(n) {
  Atomics.wait(new Int32Array(new SharedArrayBuffer(4)), 0, 0, n*1000);
}

## list.md

      
              1 file
            
          
              1 fork
            
          
              0 comments
            
          
              0 stars
            
          
                lrhache
                / list.md
            
            
              Created
              December 19, 2020 13:07
                — forked from ih2502mk/list.md
            
              
                Quantopian Lectures Saved
              
          
    Lecture 1: Introduction to Research — [📝Lecture Notebooks] [▶️Video]

Lecture 2: Introduction to Python — [📝Lecture Notebooks] [▶️Video]

Lecture 3: Introduction to NumPy — [📝Lecture Notebooks] [▶️Video]

Lecture 4: Introduction to pandas — [📝Lecture Notebooks] [▶️Video]

Lecture 5: Plotting Data — [📝Lecture Notebooks] [[▶️Vide

  
## neo4j-install-ubuntu.sh
#!/bin/sh

sudo echo "export NEO4J_HOME=/opt/neo4j" >> /etc/environment
source /etc/environment

sudo mkdir -p $NEO4J_HOME
sudo chown ubuntu.ubuntu $NEO4J_HOME

cd /tmp

## gist:92d8031e8df7f6133257869d775686aa
grep -rl "oldstring" . | LANG=C LC_ALL=C xargs sed -i '' -e "s/oldstring/newstring/g"
	set-alias installutil $env:windir\microsoft.net\framework\v2.0.50727\installutil
	installutil -i "C:\Program Files\Microsoft SQL Server\100\Tools\Binn\Redist\Microsoft.SqlServer.Management.PSProvider.dll"
	installutil -i "C:\Program Files\Microsoft SQL Server\100\Tools\Binn\Redist\Microsoft.SqlServer.Management.PSSnapins.dll"


	Add-PSSnapin SqlServerCmdletSnapin100
	Add-PSSnapin SqlServerProviderSnapin100

	$SERVER_NAME="<SERVER NAME>"; $DB_NAME="<DB NAME>";$Tables = invoke-sqlcmd -query "SELECT name FROM sys.tables order by name" -database $DB_NAME -serverinstance $SERVER_NAME;foreach ($Table in $Tables){$TableName = $Table["name"];write-host -ForegroundColor Green "Creating File $TableName.csv";invoke-sqlcmd -query "SELECT * FROM $TableName" -database $DB_NAME -serverinstance $SERVER_NAME \|export-csv -path D:\dump\$TableName.csv;}

	weekdays = ('Monday', 'Tuesday', 'Wednesday',
	'Thursday', 'Friday', 'Saturday', 'Sunday', )

	def convert_choice(*args):
	"""Convert weekdays representation to 127 bits

	Example:
	>> # Monday, Tuesday, Friday, Sunday
	>> bw.convert(1, 1, 0, 0, 1, 0, 1)
	"""Benchmark multiple method of removing duplicates in a list
	while keeping item's order in the list.

	numpy.unique will likely be faster and more efficient
	the more the list grows.
	If a list is submitted to numpy.unique, it will be transformed and flattened
	into a numpy.Array which it's data structure is more efficient than standard
	lists since all elements have the same size in memory therefor requires less
	access to the memory. Lists are stored as array of adresses pointing to
	to the objects and requires more memory access (but more flexible).
	from collections import defaultdict
	from typing import Type, cast, Callable, TypeVar, Any
	from functools import wraps

	T = TypeVar('T')


	def wrap_setattr(definition: dict, fn: Callable) -> Callable:
	@wraps(fn)
	def wrapped(self, attr, value):
	function sleep(n) {
	Atomics.wait(new Int32Array(new SharedArrayBuffer(4)), 0, 0, n*1000);
	}
	#!/bin/sh

	sudo echo "export NEO4J_HOME=/opt/neo4j" >> /etc/environment
	source /etc/environment

	sudo mkdir -p $NEO4J_HOME
	sudo chown ubuntu.ubuntu $NEO4J_HOME

	cd /tmp