osx,sqlite3,executable,shebang , Make a SQLite3 command file executable


Make a SQLite3 command file executable

Question:

Tag: osx,sqlite3,executable,shebang

I have a file of SQLite3 commands. For example,

.print "This is running in SQLite3!"

I want the behavior of

sqlite3 < commands.sql

when I run the following on OSX:

./commands.sql

Here's my current solution:

#!/usr/bin/env sqlite3 -init
.print "This is running in SQLite3!"

This works, but it spits up some unwanted lines:

-- Loading resources from ./process_errors.sql
Error: near line 1: unrecognized token: "#"
This is running in SQLite3!    

Answer:

Should work

#!/usr/bin/env bash
tail -n +4 "$0" | sqlite3
exit $?

-- sql commands
select * from some_table

Related:


How to uninstall all python versions and use the default system version of OS X 10.10?


python,osx
I'm looking for a way to cleanly uninstall all versions of python on OS X 10.10 except the default version that followed with the Mac. How do I proceed? Currently I've some weird behaviour. When typing which -a python I get the following output: /Users/harisfawad/anaconda/bin/python /Library/Frameworks/Python.framework/Versions/2.7/bin/python /usr/local/bin/python /usr/bin/python Why doesn't...

Run Boot2Docker from bash


osx,bash,docker,boot2docker
I have installed Boot2Docker on my Mac. By clicking on the app icon, a terminal window opens with some bash script running to prepare the docker vm and then you're good to go. My problem is, I want to write a bash script to run the Boot2Docker vm and then...

Set CALayer Gradient Background


objective-c,xcode,osx,cocoa,cocoa-touch
I am trying to add a gradient to a CALayer I have created. I can set the background colour of the CALayer with the following: self.colorLayer = [CALayer layer]; [self.colorLayer setBackgroundColor:color.CGColor]; [self.colorView setWantsLayer:YES]; [self.colorView setLayer:self.colorLayer]; I've looked around with no success (surprisingly I thought this would have been answered many...

Not able to create staging instance on heroku [duplicate]


ruby-on-rails,git,heroku,sqlite3
This question already has an answer here: Errors of pushing rails app to Heroku error occurred while installing sqlite3, and Bundler cannot continue 3 answers I am trying to create a staging instance of my app on heroku. While I am doing git push staging master I am getting...

Use Unix Executable File to Run Shell Script and MPKG File


osx,shell,unix
I have 2 shell scripts and 2 mpkg installer, I am trying to use an unix excitable file to run them all. here is the script I have, but it always has error message "No such file or directory" ? #!/bin/sh # Find the absolute script current path path=$( cd...

How do you work with views in MainMenu.xib?


objective-c,xcode,osx,cocoa
I'm coming over from iOS development and I can't figure out this basic thing: if I open MainMenu.xib in Interface Builder and I drag a button onto the main window's view, what class should I connect that button's action to -- the App Delegate? If I want to add a...

CGDisplayCopyAllDisplayModes leaves out one valid mode


osx,swift,core-graphics
When programmatically working with display modes in OS X (documentation), I've found that the CGDisplayCopyAllDisplayModes leaves out the rightmost option that is presented in System Preferences. A simple utility that prints the size of the current display mode and all available display mode sizes outputs this current size: 1920x1200 available...

What is the best way to make sure I am not using any unavailable API's on OSX?


objective-c,xcode,osx,cocoa
I am writing an OSX app in Xcode 6 but want my application to have support for OSX 10.7 and up. Unfortunately Xcode 6 only includes SDK for 10.10 and 10.9. What is the best way to make sure I am not using any unavailable API's that would crash on...

How to display Apple San Francisco's numbers mono-spaced rather than proportionally?


osx,fonts,apple
I've recently installed El Capitan on OSX, which comes with the new San Franciso font as system font. The apple presentation here https://developer.apple.com/videos/wwdc/2015/?id=804 (Bit of an overview here: http://codemotionapps.com/san-francisco-display-vs-text-compact-vs-normal-a-brief-review/) states that, by default, numbers are displayed proportionally. They do allow to switch to displaying them mono-spaced (at least in their...

Change NSTextField border and BG color while editing


osx,swift,cocoa,nstextfield
I have a NSTextField that uses no border and window background color while it is displayed but I want it to change to have the default border and white BG color when being edited. I know I can change these properties with: nameTextField.bezeled = true nameTextField.backgroundColor = NSColor.textBackgroundColor() What I...

Using subprocess.check_output for a command with 2>/dev/null


python,osx,subprocess
I am on Mac OS X Yosemite 10.10 and Python 2.7. If I type the following: du -g -d1 /Users 2> /dev/null in the command line, everything works perfectly. Now, my goal is to use that command in a python script. My idea was to use the following: import subprocess...

What's the shortcut to interrupt the kernel in Canopy?


osx,kernel,interrupt,shortcut,canopy
I'm on OSX, using canopy. Does anybody know what the shortcut for interrupting the kernel is? Thanks.

How can I fix “Error: Formulae found in multiple taps”?


php,osx,homebrew,phpredis
I want to install php54-redis. Yu:nginx Yu$ brew install josegonzalez/php/php54-redis ==> Installing php54-redis from josegonzalez/homebrew-php Error: Formulae found in multiple taps: homebrew/php/php54 josegonzalez/php/php54 Please use the fully-qualified name e.g. homebrew/php/php54 to refer the formula. What am I doing wrong and how is thise done properly?...

How to programatically make a key shortcut?


osx,bash,task-switching
I'm not even sure if bash is the most proper way to achieve this but, I need to, programmatically, switch between opened applications on OS X. I'm thinking about doing a bash program to execute "cmd+tab". I'm unable to find this on a regular search, so, perhaps someone can point...

pcap_dispatch() always returns 0 on Mac OSX for wifi interface


osx,pcap,libpcap,arp
I have few devices connected to wifi router, but pcap_dispatch() always returns 0 for wifi interface while live capturing on Mac OS X. The same code captures response in case of wired interface. Please clarify if I have missed any flag here.

JSON in Python: encoding issue on OS X, no issue on Windows


python,json,windows,osx,encoding
I have a file log.json that contains one line: {"k":"caf\u00e9"} I run the following code on Windows 7 SP1 x64 Ultimate: import json a = json.load(open('log.json', 'r')) f = open('test.txt', 'w') f.write(a['k']) I don't have any issue. When I run the same code on Max OS X 10.10 x64: Traceback...

How to get NSTableView to use a custom cell view mixed with preset cell views?


osx,swift,cocoa,nstableview,nstableviewcell
I have a NSTableView configured in Interface Builder which uses several default cell views. However the first column's cell view needs to be created from a custom class. How do I implement NSTableViewDataSource method tableView.viewForTableColumn() so that it creates the default cell views for the remaining columns? Here's my method...

Can I use WAL mode in SQLite3 if I use an additional mutex for multiple writers?


c++,sqlite3,mutex,wal
http://sqlite.org/wal.html WAL mode is specified for N readers and one writer. It the writer's identity interchangible? For example, I have N writers and an additional mutex. Each writer has to obtain this mutex to be able to write, so there are never two writers writing at the same time. Is...

fatal error: limits.h: No such file or directory


xcode,osx,gcc
On OSX, I can't compile simple programs from the command-line when I use an externally-provided compiler (e.g. gcc-4.8). System headers like limits.h cannot be found. Example error messages: fatal error: limits.h: No such file or directory Or: fatal error: stdio.h: No such file or directory and so on. What's wrong?...

Login with Facebook option trigger suggest to download an app


android,ios,facebook,osx,login
Yesterday I logged in to Airbnb with my Facebook account on my OSX. Shortly later I got a notification both on my iPhone and computer saying "Airbnb is available to install on your iPhone" My question is, does anyone here know how this was done? Is this a feature available...

Display django runserver output from Vagrant guest VM in host Mac notifications?


python,django,osx,notifications,vagrant
I can think of many ways to skin this cat, and Googling hasn't shown an elegant solution either. Does anyone have an easy / elegant way to forward the output from Django's runserver command in a terminal connected to a guest Vagrant VM to the host to display to Mac's...

iOS : pod update (unable to find the utility “xcode-select”)


ios,xcode,osx,xcode6,cocoapods
xI am a new iOS developer. Recently when I ran "pod update" sth just went wrong see the detail in the following: (unable to find the utility "xcode-select") bash-3.2$ pod install Analyzing dependencies sh: line 1: 4936 Abort trap: 6 /Applications/Xcode.app/Contents/Developer/usr/bin/xcodebuild -sdk / -find xcode-select 2> /dev/null xcrun: error: unable...

Sqlite3 : Unable to Authenticate


python,sqlite3,flask
I'm creating an application in flask to learn python and sqlite3. What I'm facing problem is my login authentication is not checking database entries and allowing every user to log in. And user data is been stored in database at the time of User signUp so database and tables are...

sqlite3 fails to import db from sql file


sql,sqlite3
I'm trying to install PolicyD v2, but when creating sqlite3 database from sql file it throw errors: SQLite version 3.7.17 2013-05-20 00:56:22 sqlite> .read /usr/doc/policyd2-2.0.14/policyd2.sqlite Error: near line 1: unrecognized token: "#" Error: near line 43: no such table: policies Error: near line 44: no such table: policies Error: near...

ffmpeg: wmv files generated on Mac can't be played in Windows


windows,osx,ffmpeg,file-conversion,wmv
On Mac OS X 10.6.8, I converted a animated gif to a video file in wmv (a requested file format) by using ffmpeg -i File.gif -s 400x400 NewFile.wmv The video file played fine using VLC on Mac. The file can't be played on a Windows 7 machine using the Windows...

Eclipse CDT - No Console Output on OSX


c++,eclipse,osx,terminal,64bit
New to the C++ world and wanted to fiddle around using Eclipse's IDE for C/C++ called CDT. I am on OSX 10.10.2 using eclipse-cpp-luna-SR2-macosx-cocoa-x86_64. Sadly this simple example is not printing anything in the eclipse terminal. #include <iostream> using namespace std; int main() { cout << "Hello World" << endl;...

Simulating HID on OSX : IOBluetooth or CoreBluetooth?


ios,osx,core-bluetooth,iobluetooth
I'm intending on doing some simple experiments sending simulated key strokes from mac to IOS and I'm trying to decide which framework to spend my effort on. The impression I get is that CoreBluetooth is too high level for this and that IOBluetooth would be the best choice. Is IOBluetooth...

Native Code: cannot use typeid with -fno-rtti


c++,osx,gcc,android-ndk,vtk
I'm trying to build native code on android because I want to use VTK for my android tablet. However, I am facing some issues when it comes to building one of the vtk examples. I know this problem has been covered here for an objective c issue but I guess...

django-admin startproject not working with python3 on OS X


python,django,osx,python-2.7,python-3.x
I have python3 installed with Django 1.8.2 on Mac OS. There is also python 2.7 installed by default with the OS. When trying to run startproject I get - $ django-admin startproject mysite Traceback (most recent call last): File "/usr/local/bin/django-admin", line 7, in <module> from django.core.management import execute_from_command_line ImportError: No...

Binding an NSTableView to an array of strings in Swift


osx,swift,cocoa,nstableview,cocoa-bindings
I'm showing the contents of an array of strings with an NSTableView via binding through an Array Controller. I have "NSString" in Class Name in the attributes inspector for the Array Controller and in the Model Key Path of the Array Controller's binding inspector I have the path to my...

Cocoa ViewController.m vs. Cocoa Touch ViewController.m


objective-c,osx,cocoa
Total newbie question follows... I am learning Objective C based Cocoa (OS X) app development. Most of the books and videos I have are iOS based, so I'm seeing how the two platforms differ. I have converted a simple iOS app to OS X. I got the converted OS X...

Read plist inside ~/Library/Preferences/


objective-c,xcode,osx
I'm trying to access in ~/Library/Preferences/ but my code doesn't work. NSString *resPath = @"~/Library/Preferences/"; NSError *error = nil; NSArray *filenames = [[NSFileManager defaultManager] contentsOfDirectoryAtPath:resPath error:&error]; if (!error) { for (NSString * filename in filenames) { NSLog(@"%@", filename); } } Maybe I should ask for some permission.. Any idea?...

Change the “about this” window on mac app


java,osx,deployment
On Macs, there's a default menu at the top for basic application handling functions: I've made an application using Java for my Grade 10 final project, (and I'm quite convinced that it's better than Microsoft Paint) and I decided to package it. Using Eclipse, I exported it as a Mac...

Ubuntu 14.04 - An error occurred while installing pg (0.18.2), and Bundler cannot continue


ruby-on-rails,postgresql,ubuntu,heroku,sqlite3
This issue doesn't let me go ahead and I don't know whether it's possible for me to deploy my Rails App ever on Heroku. When I try bundle install by having gem 'pg' in my Gemfile it gives following error. An error occurred while installing pg (0.18.2), and Bundler cannot...

Replace the following query in sqlite


c#,sql-server,sqlite,if-statement,sqlite3
I have a sql server query as follows in a store procedure with parameters @firstId and @secondId IF @firstId = '' begin SELECT DISTINCT x, y = FROM t1 LEFT OUTER JOIN t2 ON t1.id = t2.id AND t2.id = @secondId ORDER BY t1.somecolumn END ELSE BEGIN SELECT DISTINCT x,...

Mac OSX - Allow for user input in shell script via GUI or Prompt


osx,bash,shell
first time post so please let me know how I could improve.. I created a shell script which requires a person to input their name and then generates a report. The script works as needed when chmod'd into an executable script and run from terminal. But, I would like to...

Capitalize all files in a directory using Bash


osx,bash,rename
I have a directory called "Theme_1" and I want to capitalize all the filenames starting with "theme". The first letter of every file name is lowercase and I want it to be upcase. I've tried this but all the letters in the filename are upcase, which is not what I...

Restrict input on NSTextField


osx,swift,cocoa,nstextfield
I want to restrict character input on NSTextField, i.e. so that disallowed characters aren't even appearing. Most of what I found about this topic were solutions that only validate after text input finished or using NSFormatter which still allows the character to appear. So far I came up with this...

OSX tmux configuration session open file in vim automatically


osx,session,vim,configuration-files,tmux
So I have tmux and vim running in iterm2 on OSX. I have a tmux.conf file that sources a session in ~/.tmux/ called 'left'. I have successfully loaded this session with three panes. Two panes in a left column and a single pane on the right. I have also managed...

Initializing a xib view as a subview of another NSView


objective-c,osx,cocoa,xib,nib
I'm trying to learn OSX development, and I've created a view in a .xib file, and I'm trying to initialize and then add this view as a subview. I've googled how to do this, and all of the solutions are for iOS and use a call such as MyViewClass* myViewObject...

SQLITE_BUSY error in iOS application


ios,database,swift,sqlite3
I am writing an iOS application to allow medical doctors to select diagnoses codes from a database and bill patients that are also in the sqlite3 database. The main page is a form that asks for the patient name and date of birth. Also on the main page is a...

ASP.NET vnext overriding status code set in controller. Is this a bug?


osx,asp.net-5,kestrel
I'm building a simple WebApi in asp.net vnext on a Mac. I've followed the example set in this tutorial but I'm having a problem where the response codes I set in my controller methods are being overridden Take this method in my CrudController: [HttpPost] public void Post([FromBody]CrudObject crudObject) { var...

Stuck with creating an event and formatting dates (Swift - EventKit - OS X)


ios,osx,swift,eventkit,ekevent
I have been stuck on trying to hardcode a new event. My difficulty lies especially with the dates and formatting let dateFormatter = NSDateFormatter() dateFormatter.dateFormat = "MM'/dd'/YYYY" var dateString = "07/16/2015" var startDate = dateFormatter.dateFromString(dateString) var endDate = dateFormatter.dateFromString(dateString) var newEvent : EKEvent = EKEvent(eventStore: store) var error : NSError?...

Convert AWK command to sqlite query


sql,awk,sqlite3
I have to parse very big (abt 40Gb) text files(logs) very often. Usually AWK/grep is enough for my needs, but logs are growing and now I'm curious whether sqlite3 will allow me to do the same things more efficiently. I chosen sqlite for my tests as it installed out-of-the-box (SQLite...

Call to implicitly-deleted copy constructor in LLVM(Porting code from windows to mac)


c++,osx,c++11,compiler-errors,llvm
We are in the process of porting some c++ code from windows to mac and are having issues compiling it with LLVM 6.1 using c++11. We are encountering errors all over the place of "Call to implicitly-deleted copy contructor" Some of these errors are popping up in our code. for...

best way to create a mat from a CIImage?


c++,xcode,osx,opencv,opencv3.0
I am using CIDetector to detect faces, then using OpenCV on the lower half of each face to detect the size of any smiles. I am using the below code to create the cv::mat which OpenCV can perform the detection on, as you can see the image goes through the...

How to get CPU utilization in % in terminal (mac)


osx,terminal,cpu
Ive seen the same question asked on linux and windows but not mac (terminal). Can anyone tell me how to get the current processor utilization in %, so an example output would be 40%. Thanks

How to select columns in a table which have values not null in another table


sql,sqlite,sqlite3
I have two SQL tables (I am using SQLite). Table1 (code TEXT) Table2 (code TEXT, codeTable1 TEXT) How can I fetch all the table1's content which has at least one row in the table 2 with the codeTable1 not null?...

Python Sqlite3: Create a schema without having to use a second database


python,database,sqlite,sqlite3
I would like to create a schema for a sqlite3 database in python, but sqlite does not appear to support CREATE SCHEMA (sqlite docs). I've looked into ATTACH, and it seems like it would do the job by using a second database but I only need one database that has...

Crash when processing `__Atom` class object in Objective C (using Objective C runtime )


objective-c,osx,objective-c-runtime
Hi I'm using this answer to get list of class to automatically build some structure. My code looks like that: NSMutableDictionary *result = [NSMutableDictionary dictionaryWithCapacity: 32]; Class* classes = NULL; int numClasses = objc_getClassList(NULL, 0); if (numClasses > 0 ) { classes = (Class*)malloc(sizeof(Class) * numClasses); numClasses = objc_getClassList(classes, numClasses);...