Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
PerlMonks  

ww's scratchpad

by ww (Bishop)
on Aug 25, 2004 at 16:48 UTC ( #385740=scratchpad: print w/replies, xml ) Need Help??

sqlite> .tables desc items times ie> STM_TEST.sqlite / | \ ------- ------- ------ |items| |times| |desc | ------- ------- ------- sqlite> .schema CREATE TABLE items (ID INTEGER PRIMARY KEY AUTOINCREMENT, link_id INTE +GER, item VARCHAR NOT NULL, style VARCHAR); CREATE TABLE times (ID INTEGER PRIMARY KEY AUTOINCREMENT, link_id INTE +GER, time1 VARCHAR, time2 VARCHAR, location VARCHAR, who VARCHAR, not +e VARCHAR, extra VARCHAR); CREATE TABLE desc (ID INTEGER PRIMARY KEY AUTOINCREMENT, link_id INTEG +ER, desc VARCHAR NOT NULL, EXTRA VARCHAR);
choroba UPDATE (19 Dec) with sample of inserts: The INSERTs were done this way when my proofreading & currying of the csvs proved inadequate:
INSERT INTO "items" VALUES(NULL,1 , "Large RV Permit Holders must arrive", "H");
The "INSERT...VALUES(" is omitted below for brevity. Table items:
1 , Large RV Permit Holders must arrive, "H" , 2 , Early Entry Permit Holders can arrive, "H" , 3 , Registration Gate , "H" , 4 , Shuttle Bus Operates, "H" , ... 42 , The Science of Byurakan: The Golden Era of Soviet Astronomy, "A" +, 43 , Astro Activities for Children, "K" , 44 , Stellafane New Horizons Project, "Y" , 45 , Scope Making For Teens, "Y" , 46 , Scope Making Demo, "T" ,
TABLE times
1 , "2016-08-04 12:00", "2016-08-04 16:00", "Entry Gate", "", "Please +don't arrive before Noon!", "", 2 , "2016-08-04 15:00", "2016-08-04 22:00", "Entry Gate", "", "Please +don't arrive before 3:00!", "", 3 , "2016-08-05 09:00", "2016-08-05 22:00", "Entry Gate", "", "Hours", + "" , 3 , "2016-08-06 07:00", "2016-08-06 19:00", "Entry Gate", "", "Hours", + "" , 4 , "2016-08-05 10:00", "2016-08-05 18:00", "Bus Stops", "", "Bus Stop +s: Pine Island, Food Tent, Pink Clubhouse", 4 , "2016-08-06 09:00", "2016-08-06 17:00", "Bus Stops", "", "Bus Stop +s: Pine Island, Food Tent, Pink Clubhouse", ... 44 , "2016-08-05 13:00", "2016-08-05 17:00", "Bunkhouse", "Paul Fucile + and James Lee", "(Teens 12-16)<i class='YellowHighlight'>(Requires S +ignup)</i>", "Modeling technology from the New Horizons" , 45 , "2016-08-06 11:00", "2016-08-06 12:30", "Bunkhouse", "\"Stargazer +\" Steve Dodson", "Ages 12-16", "" , 46 , "2016-08-05 10:00", "2016-08-05 16:00", "Tent north of Pavilion", + "Ray Morits", "ATM Demo Hours", "" , 46 , "2016-08-06 10:00", "2016-08-06 16:00", "Tent north of Pavilion", + "Ray Morits", "ATM Demo Hours", "" , 46 , "2016-08-05 10:00:01", "2016-08-05 10:30", "Tent north of Pavilio +n", "Ray Morits", "Intro &amp; Rough Grinding", "Intro &amp; Rough Gr +inding" , 46 , "2016-08-06 10:00:01", "2016-08-06 10:30", "Tent north of Pavilio +n", "Ray Morits", "Intro &amp; Rough Grinding", "Intro &amp; Rough Gr +inding" , 46 , "2016-08-05 10:30", "2016-08-05 11:00", "Tent north of Pavilion", + "Rick Hunter", "Fine Grinding", "Fine Grinding" , 46 , "2016-08-06 10:30", "2016-08-06 11:00", "Tent north of Pavilion", + "Rick Hunter", "Fine Grinding", "Fine Grinding" , 46 , "2016-08-05 11:00", "2016-08-05 13:30", "Tent north of Pavilion", + "Junie Esslinger", "Making Dental Stone Tools", "Making Dental Stone + Tools" , 46 , "2016-08-06 11:00", "2016-08-06 11:30", "Tent north of Pavilion", + "Junie Esslinger", "Making Dental Stone Tools", "Making Dental Stone + Tools" , 46 , "2016-08-05 11:30", "2016-08-05 12:00", "Tent north of Pavilion", + "Phil Rounseville","Making Pitch Laps", "Making Pitch Laps" , 46 , "2016-08-06 11:30", "2016-08-06 12:00", "Tent north of Pavilion", + "Phil Rounseville","Making Pitch Laps", "Making Pitch Laps" , 46 , "2016-08-05 13:00", "2016-08-05 14:00", "Tent north of Pavilion", + "Dave Groski", "Polishing &amp; Figuring", "Polishing &amp; Figuring +" , 46 , "2016-08-06 13:00", "2016-08-06 14:00", "Tent north of Pavilion", + "Dave Groski", "Polishing &amp; Figuring", "Polishing &amp; Figuring +" , 46 , "2016-08-05 14:00", "2016-08-05 16:00", "Mirror Lab Room in Pavil +ion", "Dave Kelly", "Testing (Bring your own mirror)", "Testing (Brin +g your own mirror)" , 46 , "2016-08-06 14:00", "2016-08-06 16:00", "Tent north of Pavilion", + "Ken Slater", "Dobsonian Basics", "Dobsonian Basics"
TABLE desc
1 , Large RVs must be pre-registered and must arrive between Noon and +4PM on Thursday. Do not arrive early: we have large trucks making foo +d deliveries and installing sanitation facilities before then. , 2 , Please do not arrive before 3:00 PM and do not park on Jordan Road +. The large RV's come in before you. You will not be admitted before +3:00 PM because our gate staff will be busy getting the RV's safely i +n place. , 3 , Hours of operation of the Registration Gate. , 4 , The Shuttle Bus makes two stops in Stellafane East (one by the Foo +d Tent and one by the main Camping Area) (See <a href='pdf/stellafane +_east_5-15-11_CMYK.pdf'>Stellafane East Site Map</a> (pdf)). It makes + one stop on Breezy Hill near the Clubhouse. , ... 44 , This year our program will be modeling technology from the New Ho +rizons probe which so spectacularly flew by Pluto in 2015.<p>This wil +l be a hands on class where the group will work together to construct + a New Horizons inspired system that will be demonstrated at the Conv +ention. Each participant will have the opportunity to fine tune or mo +dify their take home project during a special dinner hour session.<p> +Attendance will be first-come first-served. If you are 100% sure your + teen(s) will attend convention and will want to attend this event th +en you need to get their name(s) on the list. Please email us directl +y at <a href='mailto:robots@stellafane.org?subject=Teen_Project_Signu +p'>robots@stellafane.org</a>. You will receive a manual reply to let +you know your status. When space is filled, we will add the next two +names to a waiting list. If space is not filled through pre-registrat +ion we will accept others (first-come first-served) at the event, unt +il the class is full.</p><p>Special note: There will be a lot of spec +ialized instruction so you will need to be on time! , 45 , Steve will guide the group in building an 8-inch Dobsonian Newton +ian telescope. Teens aged 12-16 who take part in the entire activity +(stay the whole 90 minutes) will receive a special raffle ticket. The + winner of the telescope will be drawn at the Saturday night program. + You must be present to win and must take the telescope home with you + (no shipping is available). Limited to the first 12 participants so +arrive early! , 46 , "This is a HANDS-ON mirror making demonstration - Gain first-hand + experience working on mirrors at every stage of grinding; polishing +and testing. Experienced ATMs will help explain each step of the proc +ess and answer any questions you may have. Bring your own mirror for +testing between 2:00 and 4:00 PM either day.The 24 inch mirror we hav +e been working on for several years will be available for grinding - +please sign the log book when you work on it." ,
sqlite> .tables desc items times ie> STM_TEST.sqlite / | \ ------- ------- ------ |items| |times| |desc | ------- ------- ------- sqlite> .schema CREATE TABLE items (ID INTEGER PRIMARY KEY AUTOINCREMENT, link_id INTE +GER, item VARCHAR NOT NULL, style VARCHAR); CREATE TABLE times (ID INTEGER PRIMARY KEY AUTOINCREMENT, link_id INTE +GER, time1 VARCHAR, time2 VARCHAR, location VARCHAR, who VARCHAR, not +e VARCHAR, extra VARCHAR); CREATE TABLE desc (ID INTEGER PRIMARY KEY AUTOINCREMENT, link_id INTEG +ER, desc VARCHAR NOT NULL, EXTRA VARCHAR);

Tables were populated with a series of manual INSERTs to verify my cleanup of the source data (which had been delivered in inconsistent formats, variable field quantities, and nasty (incorrect) quoting and commas). All was good. items has 4 fields; times has 8 (some null), and desc has three, but those shown are the relevant ones for this example. Only the times table has multiple entries with the same link_id, because some of the events in "items" occur multiple times across the days of the meeting for which the data applies. And a simple SELECT * from tablename produces exactly the expected output... 46 records in item and desc and multiple records, identical except for their datetime entries (in times.times1 and times.times2).

So, as I say, I suspect my joins are defective, but after wading thru the sqlite docs I'm still baffled.

sqlite> SELECT item, time1, time2, location, who, note, extra FROM ite +ms INNER JOIN ...> times ON items.link_id = times.link_id WHERE times.time1 LIKE +"2016-08-06 %" ORDER BY times.time1; sqlite> SELECT item, time1, time2, location, who, note, extra FROM ite +ms INNER JOIN ...> times ON items.link_id = times.link_id WHERE times.time1 LIKE +"2016-08-06 %" ...> LIMIT 50; Registration Gate |2016-08-06 07:00|2016-08-06 19:00|Entry Gate||Hours +| Registration Gate |2016-08-06 07:00|2016-08-06 19:00|Entry Gate||Hours +| Tee Shirt Booth in Tuthill Towers|2016-08-06 09:00|2016-08-06 18:00|Sw +ag Shop|||Hours Tee Shirt Booth in Tuthill Towers|2016-08-06 09:00|2016-08-06 18:00|Sw +ag Shop|||Hours Historic Clubhouse|2016-08-06 08:00|2016-08-06 18:00|Clubhouse|||Hours Historic Clubhouse|2016-08-06 08:00|2016-08-06 18:00|Clubhouse|||Hours Porter Turret Telescope|2016-08-06 08:00|2016-08-06 18:00|Porter Turre +t Telescope|||Hours Porter Turret Telescope|2016-08-06 08:00|2016-08-06 18:00|Porter Turre +t Telescope|||Hours Raffle Tickets at the Tee Shirt Booth|2016-08-06 09:00|2016-08-06 18:0 +0|Raffle Tickets|||Hours Raffle Tickets at the Tee Shirt Booth|2016-08-06 09:00|2016-08-06 18:0 +0|Raffle Tickets|||Hours Ice Cream Shop in the Flanders Pavilion|2016-08-06 10:00|2016-08-06 18 +:00|Ice Cream Shop|||Hours Ice Cream Shop in the Flanders Pavilion|2016-08-06 10:00|2016-08-06 18 +:00|Ice Cream Shop|||Hours Breuning Observatory and Argentini Telescope|2016-08-06 14:00|2016-08- +06 18:00|Breuning Observatory|||Hours Breuning Observatory and Argentini Telescope|2016-08-06 14:00|2016-08- +06 18:00|Breuning Observatory|||Hours Breuning Observatory and Argentini Telescope|2016-08-06 21:00|2016-08- +06 23:59|Breuning Observatory|||Hours Breuning Observatory and Argentini Telescope|2016-08-06 21:00|2016-08- +06 23:59|Breuning Observatory|||Hours Swap Tables|2016-08-06 07:00|2016-08-06 12:00|Swap Table Area - North +of Main Camping Area||| Swap Tables|2016-08-06 07:00|2016-08-06 12:00|Swap Table Area - North +of Main Camping Area||| Saturday Evening Program &amp; Keynote Talk|2016-08-06 19:00|About 201 +6-08-06 21:00 (approx)|Amphitheater (Bad weather alterate: Flanders P +avilion)||Includes Keynote , Shadowgram, Raffle &amp; Awards| Saturday Evening Program &amp; Keynote Talk|2016-08-06 19:00|About 201 +6-08-06 21:00 (approx)|Amphitheater (Bad weather alterate: Flanders P +avilion)||Includes Keynote , Shadowgram, Raffle &amp; Awards| Telescope Competition|2016-08-06 08:00|2016-08-06 09:30|Clubhouse||Mec +hanical (and Optical if needed) Registration| Registration Telescope Competition|2016-08-06 08:00|2016-08-06 09:30|Clubhouse||Mec +hanical (and Optical if needed) Registration| Registration Telescope Competition|2016-08-06 10:00|2016-08-06 13:00|Fields around +Clubhouse||Mechanical Competition| Mechanical Telescope Competition|2016-08-06 10:00|2016-08-06 13:00|Fields around +Clubhouse||Mechanical Competition| Mechanical Registration Gate |2016-08-06 07:00|2016-08-06 19:00|Entry Gate||Hours +| Registration Gate |2016-08-06 07:00|2016-08-06 19:00|Entry Gate||Hours +| Tee Shirt Booth in Tuthill Towers|2016-08-06 09:00|2016-08-06 18:00|Sw +ag Shop|||Hours Tee Shirt Booth in Tuthill Towers|2016-08-06 09:00|2016-08-06 18:00|Sw +ag Shop|||Hours Historic Clubhouse|2016-08-06 08:00|2016-08-06 18:00|Clubhouse|||Hours Historic Clubhouse|2016-08-06 08:00|2016-08-06 18:00|Clubhouse|||Hours Porter Turret Telescope|2016-08-06 08:00|2016-08-06 18:00|Porter Turre +t Telescope|||Hours Porter Turret Telescope|2016-08-06 08:00|2016-08-06 18:00|Porter Turre +t Telescope|||Hours Raffle Tickets at the Tee Shirt Booth|2016-08-06 09:00|2016-08-06 18:0 +0|Raffle Tickets|||Hours Raffle Tickets at the Tee Shirt Booth|2016-08-06 09:00|2016-08-06 18:0 +0|Raffle Tickets|||Hours Ice Cream Shop in the Flanders Pavilion|2016-08-06 10:00|2016-08-06 18 +:00|Ice Cream Shop|||Hours Ice Cream Shop in the Flanders Pavilion|2016-08-06 10:00|2016-08-06 18 +:00|Ice Cream Shop|||Hours Breuning Observatory and Argentini Telescope|2016-08-06 14:00|2016-08- +06 18:00|Breuning Observatory||Hours| Breuning Observatory and Argentini Telescope|2016-08-06 14:00|2016-08- +06 18:00|Breuning Observatory||Hours| Breuning Observatory and Argentini Telescope|2016-08-06 21:00|2016-08- +06 23:59|Breuning Observatory||Hours| Breuning Observatory and Argentini Telescope|2016-08-06 21:00|2016-08- +06 23:59|Breuning Observatory||Hours| Swap Tables|2016-08-06 07:00|2016-08-06 12:00|Swap Table Area - North +of Main Camping Area||| Swap Tables|2016-08-06 07:00|2016-08-06 12:00|Swap Table Area - North +of Main Camping Area||| Saturday Evening Program &amp; Keynote Talk|2016-08-06 19:00|About 201 +6-08-06 21:00 (approx)|Amphitheater (Bad weather alterate: Flanders P +avilion)||Includes Keynote , Shadowgram, Raffle &amp; Awards| Saturday Evening Program &amp; Keynote Talk|2016-08-06 19:00|About 201 +6-08-06 21:00 (approx)|Amphitheater (Bad weather alterate: Flanders P +avilion)||Includes Keynote , Shadowgram, Raffle &amp; Awards| Telescope Competition|2016-08-06 08:00|2016-08-06 09:30|Clubhouse||Mec +hanical (and Optical if needed) Registration| Registration Telescope Competition|2016-08-06 08:00|2016-08-06 09:30|Clubhouse||Mec +hanical (and Optical if needed) Registration| Registration Telescope Competition|2016-08-06 10:00|2016-08-06 13:00|Fields around +Clubhouse||Mechanical Competition| Mechanical Telescope Competition|2016-08-06 10:00|2016-08-06 13:00|Fields around +Clubhouse||Mechanical Competition| Mechanical Registration Gate |2016-08-06 07:00|2016-08-06 19:00|Entry Gate||Hours +| Registration Gate |2016-08-06 07:00|2016-08-06 19:00|Entry Gate||Hours +| sqlite>

20111202 for jdporter: Holders of Unholy Powers should display a random rumour about the powers of the group rotating every day

For ambrus re docs: "Certain other shadowy groups co-exist with the Cabal... but the less said about HOUP...BoF... etc, the safer you will be" (or similar... or even not so similar, except for tongue-in-cheek-ness?)"

post-9/11 Idiocy (Identifying office symbols, names, deleted):

Effective immediately, due to an INFOCON level increase, Outlook Web Access (OWA), Webmail, has been shutdown. We do not expect that it will be back online anytime soon, if at all. Please remember, this is not a XXXX Automation Helpdesk decision and XXXX can not remedy the situation.

To access your email remotely, consider the following choices:

  1. Use AKO Webmail (If you still have an Exchange Account on the xx Domain you will not be able to receive email from other users on the xx Domain unless they email you directly from their AKO to your AKO). Make sure you have removed forwarding on your AKO account. This solution should be used for M-Day personnel or temporary travel situations.
  2. Use VPN Access from your Government Laptop. If you need VPN installed, please open a trouble call with the Automation Helpdesk.
  3. Use a Government owned Blackberry, if you have been issued one.

The HTML capability to send and receive email will also be removed. We are now enforcing plain-text only emails. It will make emails look a little strange and you can not have hyperlinks in the email message. If someone gets all square boxes, instead of text, in an email please open a trouble call with the Automation Helpdesk.

** As a further reminder, all users must register their CAC Cards on our Intranet site. Just click on CCL Registration. Accounts that do not have a CAC registered will be deleted. All workstations need to be upgraded to Windows XP. Computers still running Windows 2000 will be cut off from the network. Computers must be brought into the Automation Helpdesk in xxxxxx to have them upgraded to Windows XP.

xxxxxxxxx, XXX... (name, etc, removed to protect the innocent)

Gaaaaak! my reply....

TO:               (Addressees supressed: identification of individuals and 
                   units compromises security)

SUBJECT:          INFOCON

CLASSIFICATION:   Unclass

DATE:             suppressed, just because we can)

Effective yesterday and for the foreseeable future, email has been suspended. An INFOCON level increase, directed by higher authority, required us to take this step. Higher Authority asserts that this step will not only increase security for all members of the United States Military Forces, but will also enhance efficiency, allowing additional resources to be devoted to The War On Terror.

In the future, and effective immediately, all correspondence, directives, orders and other information previously conveyed by email will be inscribed on "paper" or "vellum" (definitions and explanations, infra., at Note 1.) utilizing any of the following acceptable technologies:

  • a. "Typewriter:" A typewriter is a device similar to a combination of a computer keyboard and printer). See Note 2.
  • b. Pen and ink: Acceptable pens include: goose quill, only. (See Note 3).
  • c. Chisel and stone: Use only for those documents requiring the greatest permanency.

Also per the current INFOCON level SOP, possession or use in any military workplace of computer-related technology (exceptions at Note 4.) may, at the discretion of whomever (Note 6.) is next assigned to the Helpdesk after the violation is reported, may subject military personnel to disciplinary proceedings up to and including General Court Martial. Civilian personnel will be summarily executed.

There is one further additional unrelated note, which we have hidden at the bottom of this memo in the expectation that some of you will fail to read it.


Note 1: "Paper" is a form of material commonly found in the form of sheets and often white in color, and sometimes utilized to disseminate information printed or written thereon. Some Members may have observed or even utilized "paper" in the past. Check with your chain of command for your unit or Directorate Paper-Coordinator. "Vellum" is an obsolete technology whose re-introduction to the military forces will afford our communications contractor the opportunity for vast profit.

Note 2: Manual typewriters only. Electric typewriters generate decodeable and interceptable radio frequency pulses for each character typed. Current technology is known to allow interception of these pulses at distances up to dozens of millimeters. Further, since an on-going study of potential security hazards has identified power lines as a possible source of information compromise, electric appliances may be proscribed in the future.

Note 3: As a field expedient, when necessary, crayons may be utilized. Additionally, in the field, documents are permitted, when required, to be inscribed upon birch bark or slabs of newly hewn wood. However, use of cabbage leaves is deprecated.

Note 4: Qualified Information Technology or Intelligence personnel (cf: oxymoron) are authorized and directed to operate captured Al Quaeda computer technology for the purpose of analysis and tactical data gathering. In addition, use of digital numerical calculators is authorized, when required and on a case-by-case basis, and when specifically approved by appropriate authority (minimum: GS-15 level). Examples of appropriate use include the calculation of artillery aiming and inventory accountability maintenance.

Note 5: This note left deliberately BLANK. (Well, not really, because it says its blank, but you should get the idea.)

Note 6: Since the continued contraction of authorized uses of Information Technology is anticipated to accelerate in compliance with the latest INFOCON level change, most assigned IT personnel will be transferred to alternate duties. However, current projections anticipate that at least one IT staff member will be assigned to help desk duties on the third Thursday of months whose (US English) names include the letter "p" or "x."

Unrelated information: Yesterday has been declared an additional holiday for state and federal personnel who were actually present for and performing duty yesterday. Those individuals are authorized to have taken yesterday off. Employees and Members on a regular day off, pass or leave day or otherwise not present for and performing their customary duties yesterday are NOT authorized an alternate or compensatory day. Additionally, and solely to further obfuscate our intent, here is a second additional bit of information; a key and relevant proviso of the latest INFOCON level SOP: creation or possession of any document, paper, file or other information storage technology utilizing justified type (or, typesetting) will be deemed prima facie evidence of the possession or use of prohibited technology.