Month: June 2018

Query Mapping between MS-SQL and SQLite

If for some reason you need to migrate your MS-SQL Server database to SQLite Database, among many other things, here are some things that you should pay attention to. Things to consider: Each Statement must end with “;“ Remove references to schema on query eg: References to [dbo]. Select * from [dbo].[table1] in SQL = […]

Read More

Python Replace Texts For Each File

A useful function to replace certain texts for each files in a given folder: Python Replace texts in all Files From a Folder and re-write import os # Getting the current work directory (cwd) thisdir = os.getcwd() folder = thisdir + ‘\\path_to_your_folder’ # r=root, d=directories, f = files for r, d, f in os.walk(folder): for […]

Read More